U.S. Equal Employment Opportunity Commission seal

Semantic YAML: governed.eeo1_pay_cbsa

The semantic layer for the governed table governed.eeo1_pay_cbsa: its dimensions and measures as committed YAML. All YAML files · Data catalog and inventory.

Download this YAML

dataset: eeo1-pay-data
title: EEO-1 Component 2 Pay Data
description: 'EEO-1 Component 2 Public Use File (PUF): aggregated W-2 pay data that EEOC published for collection years 2017 and 2018. Private employers with 100 or more employees and federal contractors reported each employee''s total Box 1 W-2 earnings, which EEOC bins into twelve standard pay bands and tabulates as employee counts by salary band, race/ethnicity, sex, job category, and industry (2- and 3-digit NAICS). This table holds the metropolitan rollup, one row per Core-Based Statistical Area (within its state) and demographic/industry/pay-band cell. Counts pass through confidentiality suppression.'
source_table: eeo1_pay_cbsa
dimensions:
- name: state_name
  label: State
  description: 'State or District of Columbia in which the Core-Based Statistical Area is located (the 50 states plus DC). Used to scope the CBSA breakout to a state.'
  type: geo
- name: cbsa_title
  label: Core-Based Statistical Area
  description: 'Core-Based Statistical Area (metropolitan or micropolitan area) in which employment is located. CBSAs may cross state lines but are scoped here by the State field.'
  type: geo
- name: year
  label: Year
  description: 'EEO-1 Component 2 collection year. The Component 2 pay PUF covers two years, 2017 and 2018; pay reflects total W-2 (Box 1) earnings reported for that calendar year.'
  type: time
- name: naics_digits
  label: NAICS Level
  description: 'NAICS aggregation level for the industry breakout: 2 for the two-digit sector or 3 for the three-digit subsector, using the 2017 North American Industry Classification System.'
  type: code
- name: naics
  label: NAICS Code
  description: 'NAICS industry code (two- or three-digit, per the NAICS Level field) identifying the employer''s industry under NAICS 2017. Resolves against the committed NAICS 2022 industry-context reference (reference.naics) at the 2-digit sector or 3-digit subsector level for the industry title and a description of the industries it contains, for example 62 is Health Care and Social Assistance and 111 is Crop Production.'
  type: code
- name: naics_name
  label: NAICS Industry
  description: 'Industry name corresponding to the NAICS code (NAICS 2017 sector or subsector title); matches the sector/subsector title carried in the NAICS 2022 industry-context reference (reference.naics).'
  type: code
- name: race
  label: Race/Ethnicity
  description: 'Race/ethnicity of the employees in the cell. Component 2 uses seven categories, coded in the data as WHITE, BLACK, HISPANIC, ASIAN, AIAN (American Indian or Alaska Native), NHOPI (Native Hawaiian or Other Pacific Islander), and TOMR (Two or More Races).'
  type: category
- name: sex
  label: Sex
  description: 'Sex of the employees in the cell, coded M (Male) or F (Female).'
  type: category
- name: job_category
  label: Job Category
  description: 'EEO-1 job category of the employees. Component 2 uses the ten standard EEO-1 categories: Executive/Senior Officials and Managers, First/Mid Officials and Managers, Professionals, Technicians, Sales Workers, Office and Clerical Workers, Craft Workers, Operatives, Laborers, and Service Workers.'
  type: category
- name: salaryband
  label: Salary Band
  description: 'W-2 pay band into which the employee''s total annual earnings fall. Component 2 uses twelve bands: $19,239 and under; $19,240-$24,439; $24,440-$30,679; $30,680-$38,999; $39,000-$49,919; $49,920-$62,919; $62,920-$80,079; $80,080-$101,919; $101,920-$128,959; $128,960-$163,799; $163,800-$207,999; and $208,000 and over.'
  type: category
measures:
- name: employment_value
  label: Employee Count
  description: 'Number of employees in the cell defined by state, CBSA, year, industry (NAICS), race/ethnicity, sex, job category, and salary band. Counts reflect confidentiality suppression applied to protect individual employer pay records.'
  agg: sum
  type: number
metadata:
  title: EEO-1 Component 2 Pay Data
  description: 'EEO-1 Component 2 Public Use File (PUF): aggregated W-2 pay data that EEOC published for collection years 2017 and 2018. Private employers with 100 or more employees and federal contractors reported each employee''s total Box 1 W-2 earnings, which EEOC bins into twelve standard pay bands and tabulates as employee counts by salary band, race/ethnicity, sex, job category, and industry (2- and 3-digit NAICS). This table holds the metropolitan rollup, one row per Core-Based Statistical Area (within its state) and demographic/industry/pay-band cell. Counts pass through confidentiality suppression.'
  identifier: gov-eeoc-eeo1-pay-data
  publisher: U.S. Equal Employment Opportunity Commission
  contactPoint: Jiashen.You@eeoc.gov
  modified: '2026-06-20'
  keyword:
  - EEO-1
  - Component 2
  - pay data
  - compensation
  - salary band
  - pay equity
  - race
  - ethnicity
  - sex
  - job category
  - NAICS
  - private employers
  accessRights: public
  accrualPeriodicity: R/P1Y
  temporal:
    start: '2017-01-01'
    end: '2018-12-31'