The semantic layer for the public dashboard Litigation Dashboard 25: its dimensions, measures, and governance rules as committed YAML. All YAML files · Data catalog and inventory.
title: Charge and Litigation Statistics - Litigation
description: >
EEOC litigation activity: lawsuits filed, lawsuits resolved, and monetary benefits
recovered, by EEOC fiscal year and statute, plus a curated list of selected
highlighted resolved cases. This is the litigation half of the Charge and
Litigation Statistics tool. This is US-only, aggregate and case-highlight data
drawn from public EEOC enforcement and litigation reporting. There is no
individual, personally identifiable, complainant-level, or charging-party data.
tables:
litigation:
label: Litigation yearly counts (filings, resolutions, benefits by statute)
description: >
One row per Type2 (filings, resolutions, or benefits) by Category (statute or
breakdown) by fiscal year. Fiscal years span FY 1997 through FY 2025. Do not
sum across Category values, that double-counts, because one suit can raise
multiple statutes; pin exactly one Category per Type2. Grand totals: filings
use 'All Suits Filed', resolutions use 'All Resolutions', benefits use
'Monetary Benefits ($ in millions)'.
n_rows: 812
columns:
- name: Type2
dtype_raw: TEXT
semantic: dimension
label: Litigation activity type
description: >
The kind of litigation activity, exactly one of three values. 'Filings' is
the number of lawsuits the EEOC filed (new suits). 'Resolutions' is the
number of lawsuits resolved or closed. 'Benefits' is monetary benefits
recovered in US dollars, millions (a dollar amount, not a case count).
value_aliases:
Filings: Number of lawsuits filed by the EEOC
Resolutions: Number of lawsuits resolved or closed
Benefits: Monetary benefits recovered (US dollars, in millions)
sample_values:
- Filings
- Resolutions
- Benefits
- name: Category
dtype_raw: TEXT
semantic: dimension
label: Statute or breakdown category
description: >
The statute or breakdown the count applies to. Grand totals: 'All Suits
Filed' (with Filings), 'All Resolutions' (with Resolutions), 'Monetary
Benefits ($ in millions)' (with Benefits). Subtotals: 'Merits Suits' (suits
on the merits, excludes subpoena and preliminary-relief actions), 'Subpoena
and Preliminary Relief Actions'. Per-statute filing and resolution labels
use the long form 'Suits with <Statute> Claims' (Title VII, ADA, ADEA, EPA,
GINA, PWFA) plus 'Suits filed under multiple statutes'. Per-statute benefit
labels use the short form 'Title VII', 'ADA', 'ADEA', 'EPA', 'PWFA'.
Per-statute values overlap because one suit can raise several statutes;
never add them together.
sample_values:
- All Suits Filed
- Merits Suits
- Suits with Title VII Claims
- Suits with ADA Claims
- Suits with ADEA Claims
- Suits with PWFA Claims
- Suits with EPA Claims
- Suits with GINA Claims
- Suits filed under multiple statutes
- Subpoena and Preliminary Relief Actions
- All Resolutions
- Monetary Benefits ($ in millions)
- Title VII
- ADA
- ADEA
- PWFA
- EPA
- name: Year
dtype_raw: TEXT
semantic: dimension
label: EEOC fiscal year (text date "YYYY-01-01")
description: >
EEOC fiscal year stored as TEXT in the form "YYYY-01-01" (for example
"2024-01-01"), covering FY 1997 through FY 2025. Do not compare as an
integer; filter a single year with Year='2024-01-01' or Year LIKE '2024%'.
sample_values:
- '1997-01-01'
- '1998-01-01'
- '1999-01-01'
- '2000-01-01'
- '2001-01-01'
- '2002-01-01'
- '2003-01-01'
- '2004-01-01'
- '2005-01-01'
- '2006-01-01'
- '2007-01-01'
- '2008-01-01'
- '2009-01-01'
- '2010-01-01'
- '2011-01-01'
- '2012-01-01'
- '2013-01-01'
- '2014-01-01'
- '2015-01-01'
- '2016-01-01'
- '2017-01-01'
- '2018-01-01'
- '2019-01-01'
- '2020-01-01'
- '2021-01-01'
- '2022-01-01'
- '2023-01-01'
- '2024-01-01'
- '2025-01-01'
- name: Count
dtype_raw: REAL
semantic: measure
label: Value for the row (suits or dollars in millions)
description: >
The numeric value for the Type2 and Category and Year on this row. For
Type2 'Filings' or 'Resolutions' this is a count of lawsuits; for Type2
'Benefits' it is a US dollar amount in millions. SUM this column to total,
after pinning exactly one Category. Round derived figures to 2 decimals.
measure: SUM("Count")
measure_note: each row is one count; SUM "Count" to total. Filter/group by the
dimension columns. Pin exactly one Category per Type2, never sum across
Category values, that double-counts.
selected_resolutions:
label: Selected highlighted resolved cases (one row per case)
description: >
One row per highlighted or notable resolved EEOC case. Public case-highlight
records only (case name, court, resolution type, relief dollar amount, dates,
allegations, EEOC field district, civil action number, and a link to the EEOC
press release). Use SUM("Relief") for total relief dollars, or ORDER BY
"Relief" DESC for the largest case. This is public litigation-highlight data,
not charging-party or complainant records.
n_rows: 620
columns:
- name: Case Name
dtype_raw: TEXT
semantic: dimension
label: Case name (defendant employer)
description: >
Name of the highlighted case, typically the defendant employer. Public
case caption from EEOC litigation reporting, not an individual person.
- name: Court
dtype_raw: TEXT
semantic: dimension
label: Court
description: US federal court in which the case was filed or resolved.
- name: Court_Filing_Date
dtype_raw: TEXT
semantic: dimension
label: Court Filing Date
description: Date the EEOC filed the case in court, text date. N/A if unknown.
- name: Resolution_Date
dtype_raw: TEXT
semantic: dimension
label: Resolution Date
description: Date the case was resolved, text date. N/A if unknown.
- name: Relief
dtype_raw: REAL
semantic: measure
unit_hint: $
label: Monetary relief for the case (US dollars)
description: >
Dollar amount of monetary relief obtained in this case, US dollars. SUM for
total relief, MAX or ORDER BY "Relief" DESC for the largest case. Round to
2 decimals. N/A where no relief amount is recorded.
- name: Resolution
dtype_raw: TEXT
semantic: dimension
label: Resolution Type
description: >
How the case resolved, one of 'Settlement', 'Judgment', or 'Favorable Court
Order'.
sample_values:
- Settlement
- Judgment
- Favorable Court Order
- name: Link Text
dtype_raw: TEXT
semantic: dimension
label: EEOC press-release URL
description: URL to the public EEOC press release for this case.
- name: Allegations.x
dtype_raw: TEXT
semantic: dimension
label: Allegations (source copy)
description: >
Free-text allegations for the case, formatted as statute / basis / issue
(for example "Title VII / Race / Discharge"). Match with LIKE. Duplicate
source copy of Allegations.
- name: District.x
dtype_raw: TEXT
semantic: dimension
label: EEOC field district office
description: >
EEOC field district office handling the case (for example Phoenix, Los
Angeles, Chicago). A US EEOC office, not a court district. May be N/A.
sample_values:
- Phoenix
- Philadelphia
- St Louis
- Los Angeles
- Charlotte
- San Francisco
- Miami
- New York
- Indianapolis
- Memphis
- Birmingham
- Dallas
- Chicago
- Houston
- Atlanta
- name: Civil_Action_Number.x
dtype_raw: TEXT
semantic: dimension
label: Civil action (docket) number
description: >
Federal civil action docket number for the case (for example
"2:24-cv-00721"). Public court identifier. Do not aggregate.
sample_values:
- 2:25-cv-00242-ASB
- 2:19-cv-01242
- 2:23-cv-02439
- 8:22-cv-01765
- 2:24-cv-00721
- 1:23-cv-00722
- 4;24-cv-06848
- 8:23-cv-02067
- 1:24-cv-02816
- 0:24-cv-61812
- 1:25-cv-00004
- 5:20-cv-1628
- 1:24-cv-00377
- 2:24-cv-12424
- 2:23-cv-02568
- 2:23-cv-01213-AMM
- 3:22-cv-01807-C
- 1:22-cv-02407-JRR
- 0:23-cv-03010
- 4:24-cv-02861
- 5:23-cv-00623
- 1:23-CV-04293
- name: Allegations
dtype_raw: TEXT
semantic: dimension
label: Allegations (statute / basis / issue)
description: >
Free-text allegations for the case, formatted as statute / basis / issue
(for example "Title VII / Race / Discharge"), sometimes several joined by
newlines. Match with LIKE '%...%'. N/A if not recorded.
- name: District.y
dtype_raw: TEXT
semantic: dimension
label: EEOC field district office (joined copy)
description: >
EEOC field district office, duplicate joined copy of District.x. A US EEOC
office, not a court district. May be N/A.
sample_values:
- Phoenix
- Philadelphia
- St Louis
- Los Angeles
- Charlotte
- San Francisco
- Miami
- New York
- Indianapolis
- Memphis
- Birmingham
- Dallas
- Chicago
- Houston
- Atlanta
- name: Civil_Action_Number.y
dtype_raw: TEXT
semantic: dimension
label: Civil action (docket) number (joined copy)
description: >
Federal civil action docket number, duplicate joined copy of
Civil_Action_Number.x. Public court identifier. Do not aggregate.
sample_values:
- 2:25-cv-00242-ASB
- 2:19-cv-01242
- 2:23-cv-02439
- 8:22-cv-01765
- 2:24-cv-00721
- 1:23-cv-00722
- 4;24-cv-06848
- 8:23-cv-02067
- 1:24-cv-02816
- 0:24-cv-61812
- 1:25-cv-00004
- 5:20-cv-1628
- 1:24-cv-00377
- 2:24-cv-12424
- 2:23-cv-02568
- 2:23-cv-01213-AMM
- 3:22-cv-01807-C
- 1:22-cv-02407-JRR
- 0:23-cv-03010
- 4:24-cv-02861
- 5:23-cv-00623
- 1:23-CV-04293
- name: Press Release Text.y
dtype_raw: TEXT
semantic: dimension
label: EEOC press-release text or link
description: >
Text or link for the public EEOC press release describing the case
resolution. Free text; N/A if not recorded.
measure: SUM("Relief")
measure_note: each row is one highlighted case; SUM "Relief" for total relief
dollars, or ORDER BY "Relief" DESC for the largest case. Filter/group by the
dimension columns.
suggested_charts: []
governance:
scope: >
EEOC litigation statistics. This is the litigation half of the Charge and
Litigation Statistics tool. Two tables: yearly aggregate counts of lawsuits
the EEOC filed and resolved and the monetary benefits recovered by statute and
EEOC fiscal year, and a curated list of selected highlighted resolved cases
with their relief amounts, courts, districts, and press-release links. This is
US-only, public EEOC enforcement and litigation reporting data. It contains no
individual, personally identifiable, complainant-level, or charging-party
records, and no foreign geography.
allowed_dimensions:
- litigation_activity_type
- statute_category
- fiscal_year
- resolution_type
- eeoc_field_district
- court
value_domains:
litigation_activity_type: Exactly Filings (lawsuits filed), Resolutions (lawsuits
resolved), or Benefits (monetary benefits recovered, US dollars in millions).
statute_category: EEOC-enforced statutes and rollups only, such as All Suits
Filed, All Resolutions, Merits Suits, Subpoena and Preliminary Relief Actions,
Title VII, ADA, ADEA, EPA, GINA, PWFA, and multiple-statute breakdowns.
fiscal_year: EEOC fiscal years present in the data, FY 1997 through FY 2025,
stored as text "YYYY-01-01".
resolution_type: For highlighted cases, one of Settlement, Judgment, or
Favorable Court Order.
eeoc_field_district: EEOC field district offices in the US, such as Phoenix,
Los Angeles, Chicago, Houston, Atlanta, New York. These are US EEOC offices,
not foreign geography and not court districts.
court: US federal courts in which EEOC cases were filed or resolved.
refuse:
- q: How many EEOC lawsuits were filed in the southeast of France?
why: Foreign or foreign sub-national geography is out of scope; geography is US
EEOC field districts and US federal courts only.
- q: Give me the name and contact details of the individual who filed this suit.
why: No individual, complainant, or charging-party records exist here; case rows
are public litigation highlights, not personally identifiable data.
- q: What was the stock price of the defendant company that year?
why: Financial-market data is outside EEOC litigation reporting and is not in
this dataset.