The semantic layer for the public dashboard Charge Statistics 25: its dimensions, measures, and governance rules as committed YAML. All YAML files · Data catalog and inventory.
title: Charge and Litigation Statistics - Charge Receipts
description: >
EEOC charge receipt and resolution statistics. Counts of discrimination charges
filed with the EEOC (receipts) broken out by US state or territory, fiscal year,
and charge basis, plus nationwide charge-resolution and monetary-benefit trends.
This is the charge half of the Charge and Litigation Statistics tool. This is
US-only, aggregate data. There are no individual, personally identifiable, or
case-level charge records here.
tables:
state_receipts:
label: State charge receipts (by state, fiscal year, and basis)
description: >
One row per US state or territory, fiscal year, and charge basis. The basis
is embedded inside the Year text label formatted exactly "FY <year> <Basis>"
(for example "FY 2024 Disability"); there is no separate Basis, Charge, or
Type column in this table. Use this table for anything by state, or for a
single national number when the basis and fiscal year are both known. Do not
sum across different bases within a year, that double-counts.
n_rows: 12566
columns:
- name: State
dtype_raw: str
semantic: geo_state
cardinality: 61
nullpct: 0.0
ambiguous: false
min_val: AK
max_val: WY
label: State or territory (2-letter USPS code)
description: >
2-letter USPS postal code for a US state, the District of Columbia (DC),
a US territory (PR Puerto Rico, GU Guam, VI Virgin Islands, AS American
Samoa, MP Northern Mariana Islands), or an Armed Forces code (AP, AE, AA).
61 distinct codes. No foreign or foreign sub-national geography exists here.
value_aliases:
AP: Armed Forces Pacific
AE: Armed Forces Europe
AA: Armed Forces Americas
DC: District of Columbia
PR: Puerto Rico
GU: Guam
VI: Virgin Islands
AS: American Samoa
MP: Northern Mariana Islands
- name: Year
dtype_raw: str
semantic: datetime
cardinality: 206
nullpct: 0.0
ambiguous: false
min_val: FY 2009 Age
max_val: FY 2025 Total Charges
label: Fiscal year and basis label ("FY <year> <Basis>")
description: >
Combined text label holding BOTH the EEOC fiscal year AND the charge basis,
formatted exactly "FY <year> <Basis>", for example "FY 2024 Disability" or
"FY 2023 Total Charges". Fiscal years span FY 2009 through FY 2025. The
basis is one of these verbatim strings: Total Charges, Race, Sex, National
Origin, Religion, Color, Retaliation All Statutes, TVII Retaliation, Age,
Disability, EPA, GINA, Pregnant Workers Fairness Act*. To filter by basis,
put it in this Year string, for example Year = 'FY 2024 Race'. Never write
WHERE Basis = ..., that column does not exist. Use Total Charges only for
the overall figure, not for a specific basis.
- name: Count
dtype_raw: float64
semantic: measure
cardinality: 1973
nullpct: 0.049
ambiguous: false
min_val: 0.0
max_val: 9952.0
unit_hint: count
label: Number of charge receipts
description: >
Number of charges of discrimination filed (received) for the given state,
fiscal year, and basis. Aggregate integer count. SUM this column to total.
Missing values are treated as N/A. Round any derived figures to 2 decimals.
- name: File
dtype_raw: str
semantic: dimension
cardinality: 1
nullpct: 0.0
ambiguous: false
min_val: State Receipts
max_val: State Receipts
label: Source worksheet marker
description: >
Constant source-worksheet marker (always "State Receipts") identifying the
origin sheet. Not an analytic dimension; useful only for provenance.
sample_values:
- State Receipts
measure: SUM("Count")
measure_note: each row is one count; SUM "Count" to total. Filter/group by the
dimension columns. Never sum across different bases within a fiscal year, that
double-counts.
all_charges:
n_rows: 4630
columns:
- name: Year
dtype_raw: str
semantic: datetime
cardinality: 34
nullpct: 0.0
ambiguous: false
min_val: '1992-01-01'
max_val: '2025-01-01'
is_year_field: true
sample_values:
- '1992-01-01'
- '1993-01-01'
- '1994-01-01'
- '1995-01-01'
- '1996-01-01'
- '1997-01-01'
- '1998-01-01'
- '1999-01-01'
- '2000-01-01'
- '2001-01-01'
- name: Type
dtype_raw: str
semantic: dimension
cardinality: 13
nullpct: 0.0
ambiguous: false
min_val: '% of Charges'
max_val: Withdrawals w/Benefits
label: Type (group)
sample_values:
- '% of Charges'
- Administrative Closures
- Merit Resolutions
- Monetary Benefits (Millions)*
- Monetary Benefits (Millions)**
- No Reasonable Cause
- Reasonable Cause
- Receipts
- Resolutions
- Settlements
- name: Count
dtype_raw: float64
semantic: measure
cardinality: 3073
nullpct: 0.0
ambiguous: false
min_val: 0.0
max_val: 82980.0
unit_hint: count
- name: Charge
dtype_raw: str
semantic: dimension
cardinality: 18
nullpct: 0.0
ambiguous: false
min_val: ADA (Disability)
max_val: Title VII Sex-Pregnancy-Based
label: Charge (group)
sample_values:
- ADA (Disability)
- ADEA (Age)
- Equal Pay Act
- GINA
- Harassment
- Pregnant Workers Fairness Act
- Race Harassment
- Retaliation-Based (All Statutes)
- Sex-Based Harassment
- Sexual Harassment
value_aliases:
Color Based: Color-Based
Disability Charges: Disability
National Origin Based: National Origin-Based
Race Based: Race-Based
Religion Based: Religion-Based
Retaliation: Retaliation-Based
Sex Based: Sex-Based
Sex-Based Harassment: Sex-Based Harassment*
- name: Total_Receipts
dtype_raw: float64
semantic: measure
cardinality: 29
nullpct: 0.048
ambiguous: false
min_val: 61331.0
max_val: 99947.0
unit_hint: count
- name: Total_Resolutions
dtype_raw: float64
semantic: measure
cardinality: 34
nullpct: 0.0
ambiguous: false
min_val: 13134.0
max_val: 324493.0
unit_hint: count
- name: Total_Monetary
dtype_raw: float64
semantic: measure
cardinality: 34
nullpct: 0.0
ambiguous: false
min_val: 19.8
max_val: 1806.31
unit_hint: $
measure: SUM("Count")
measure_note: each row is one count; SUM "Count" to total. Filter/group by the
dimension columns.
suggested_charts:
- name: Total Count
kind: kpi
dim: null
geo: null
measures:
- Count
agg: sum
color: null
title: Total Count
- name: Count by State
kind: map
dim: null
geo: State
measures:
- Count
agg: sum
color: null
title: Count by State
- name: Count over Time
kind: line
dim: Year
geo: null
measures:
- Count
agg: sum
color: null
title: Count over Time
- name: Count by File
kind: hbar
dim: File
geo: null
measures:
- Count
agg: sum
color: null
title: Count by File
- name: Data Table
kind: table
dim: File
geo: null
measures:
- Count
agg: sum
color: null
title: Data Table
- name: Total Count
kind: kpi
dim: null
geo: null
measures:
- Count
agg: sum
color: null
title: Total Count
- name: Total Total_Receipts
kind: kpi
dim: null
geo: null
measures:
- Total_Receipts
agg: sum
color: null
title: Total Total_Receipts
- name: Total Total_Resolutions
kind: kpi
dim: null
geo: null
measures:
- Total_Resolutions
agg: sum
color: null
title: Total Total_Resolutions
- name: Count over Time
kind: line
dim: Year
geo: null
measures:
- Count
agg: sum
color: null
title: Count over Time
- name: Total_Receipts over Time
kind: line
dim: Year
geo: null
measures:
- Total_Receipts
agg: sum
color: null
title: Total_Receipts over Time
- name: Count by Type
kind: hbar
dim: Type
geo: null
measures:
- Count
agg: sum
color: null
title: Count by Type
- name: Count by Charge
kind: hbar
dim: Charge
geo: null
measures:
- Count
agg: sum
color: null
title: Count by Charge
- name: Data Table
kind: table
dim: Type
geo: null
measures:
- Count
- Total_Receipts
agg: sum
color: null
title: Data Table
governance:
scope: >
EEOC charge receipt and resolution statistics. This is the charge half of the
Charge and Litigation Statistics tool. Two tables: state_receipts holds one
aggregate charge-receipt count per US state or territory, fiscal year, and
basis (the basis is embedded in the Year label); all_charges holds nationwide
resolution trends by year, outcome type, and basis. This is US-only, aggregate
data covering EEOC fiscal years FY 2009 through FY 2025 (state_receipts) and
1992 through 2025 (all_charges nationwide). There are no individual,
personally identifiable, or case-level charge records, and no foreign
geography.
allowed_dimensions:
- geography
- fiscal_year
- basis
- outcome_type
value_domains:
geography: US states, the District of Columbia, US territories (PR Puerto Rico,
GU Guam, VI Virgin Islands, AS American Samoa, MP Northern Mariana Islands),
and Armed Forces codes (AP, AE, AA). 61 two-letter USPS codes total. No
foreign or foreign sub-national geography.
fiscal_year: EEOC fiscal years present in the data. State receipts cover FY 2009
through FY 2025; nationwide trends cover 1992 through 2025.
basis: Protected bases the EEOC enforces, such as Race, Sex, National Origin,
Religion, Color, Age (ADEA), Disability (ADA), Equal Pay Act (EPA), Genetic
Information (GINA), Retaliation, and Pregnant Workers Fairness Act, plus the
Total Charges rollup. Also harassment and sexual-orientation (LGBTQ) breakouts
in the nationwide table.
outcome_type: Charge resolution or measure categories in all_charges, such as
Receipts, Resolutions, Merit Resolutions, Settlements, Withdrawals w/Benefits,
Successful or Unsuccessful Conciliations, Administrative Closures, No
Reasonable Cause, Reasonable Cause, Monetary Benefits (Millions), and % of
Charges.
refuse:
- q: How many charges were filed in the southeast of France?
why: Foreign or foreign sub-national geography is out of scope; geography is US
states and territories only.
- q: Give me the charge filed by a specific named individual.
why: No individual-level or personally identifiable data exists here; counts are
aggregate only.
- q: What is the median household income in Texas?
why: Income and demographic statistics outside EEOC charge counts are not in this
dataset.