Skip to main content

Extract data from EEO-1 workforce reports

An EEO-1 report is the annual workforce headcount that larger US employers file with the Equal Employment Opportunity Commission, broken down by job category, race and ethnicity, and sex. Every private employer with 100 or more employees, plus many federal contractors, must submit one. HR analytics teams, diversity officers, and compliance leads read it to see how many people sit in each of the ten EEO job categories and how those counts split across demographic groups. Brightpath Logistics Corp, EIN 47-3920184, under NAICS code 493110, filed its 2026 EEO-1 for 842 employees, 496 male and 346 female, which foots to the headcount. Within the workforce_demographics table, the count breaks down by job category: 12 Executive/Senior Officials, 148 Professionals, 96 Technicians, and 214 Laborers, each cell split by race-ethnicity and sex. Helen Marsh, VP of People, certified the report on 2026-05-20, against a filing deadline of 2026-06-04. Veteran and disability counts per category sit in a separate protected_class_status table. Reading the report, Talonic returns the employer identity, the reporting period, and the workforce totals as fields, and the demographic breakdown, the protected-class status, and the establishment breakdown as tables. Male and female totals are checked to sum to the total employee count, so a report listing 842 employees but 850 across the cells is flagged. Counts come out as the EEOC form states them: Talonic does not compute representation ratios or judge compliance.

What gets extracted from EEO-1 workforce reports

Employer NameBrightpath Logistics Corp
Employer EIN47-3920184
NAICS Code493110
Reporting Period2026
Total Employees842Checked to equal the male plus female totals
Total Male Employees496
Total Female Employees346
Job CategoryProfessionals
Certifying OfficerHelen Marsh
Filing Deadline2026-06-04

How extraction works for EEO-1 workforce reports

EEO-1 reports are generated from an HRIS such as Workday or ADP and filed through the EEOC online portal, and the demographic grid is the hardest part to read: dozens of cells crossing job category, race-ethnicity, and sex. Talonic classifies the report and aligns it to the workforce-demographics schema in the Field Registry, so employer.name, employer.ein, the NAICS code, and total_employees resolve to fields while the grid loads as the workforce_demographics table, one row per job-category and race-ethnicity combination with male_count and female_count typed as numbers. Dates such as the 2026-05-20 certification and the 2026-06-04 filing deadline parse to ISO 8601. Under DIN SPEC 91491, every value carries a confidence score and a source-region pointer, so a compliance lead can trace a category total back to its cell. Filed counts come back as stated, with no representation analysis added.

Sample extraction

An annual EEO-1 workforce demographic report

{
  "document_date": "2026-05-20",
  "document_number": "EEO1-BPL-2026",
  "employer.name": "Brightpath Logistics Corp",
  "employer.ein": "47-3920184",
  "employer.address": "2200 Commerce Blvd, Atlanta, GA 30328",
  "reporting_period": "2026",
  "naics_code": "493110",
  "total_employees": 842,
  "total_male_employees": 496,
  "total_female_employees": 346,
  "eeo_form_type": "annual report",
  "certifying_officer_name": "Helen Marsh",
  "certification_date": "2026-05-20",
  "filing_deadline": "2026-06-04",
  "workforce_demographics": [
    {
      "job_category": "Executive/Senior Officials",
      "race_ethnicity": "White",
      "gender": "Male",
      "male_count": 8,
      "female_count": 0,
      "total_count": 8
    },
    {
      "job_category": "Professionals",
      "race_ethnicity": "Asian",
      "gender": "Female",
      "male_count": 0,
      "female_count": 22,
      "total_count": 22
    },
    {
      "job_category": "Laborers",
      "race_ethnicity": "Hispanic or Latino",
      "gender": "Male",
      "male_count": 74,
      "female_count": 0,
      "total_count": 74
    }
  ],
  "protected_class_status": [
    {
      "job_category": "Laborers",
      "veteran_status": "Protected Veteran",
      "disability_status": "No Disability",
      "male_count": 11,
      "female_count": 3
    }
  ],
  "establishment_breakdown": [
    {
      "establishment_name": "Atlanta Distribution Center",
      "establishment_address": "2200 Commerce Blvd, Atlanta, GA 30328",
      "naics_code": "493110",
      "total_employees": 842
    }
  ]
}

Frequently asked

Which employers have to file an EEO-1?

Private employers with 100 or more employees, and many federal contractors, file the EEO-1 annually with the EEOC. The report covers headcount by job category, race-ethnicity, and sex.

Does it reconcile the headcounts?

Yes. The total_male_employees of 496 and total_female_employees of 346 are checked to sum to the total_employees of 842, so a filing whose demographic cells do not add up to the stated total is flagged.

Can it read the full demographic grid?

Yes. The workforce_demographics table returns one row per job-category and race-ethnicity combination, each with its male_count and female_count, so the 12 Executive/Senior Officials and 214 Laborers stay traceable to their cells.

Does Talonic score diversity or judge compliance?

No. It extracts the counts the report states. Computing representation ratios or judging whether a workforce meets any standard is left to the reader, not the extraction.

Author note

Reviewed by Talonic engineering, HR compliance schema review · last reviewed 2026-07-08