OSHA Enforcement

Every federal OSHA workplace-safety inspection and every cited violation, from the U.S. Department of Labor enforcement data catalog. Two joined tables: one row per inspection (establishment, location, open/close dates, total penalty, distinct standards cited, and accident/fatality flags) and one row per cited violation (the cited standard, violation type, as-issued and settled penalties, and issuance/abatement/settlement dates). Ask "who was cited under 1910.147 in Ohio" or "which employers had a fatality inspection with willful violations."

Penalties are tracked as they change: OSHA settlements amend the as-issued penalty over months, so each violation carries its initial and current (settled) amount, and the record's cursor advances with the amendment history — a later settlement re-surfaces the updated penalty automatically.

Coverage: this is federal OSHA enforcement plus the OSHA-approved State-Plan states that report into the federal system. Establishments in State-Plan states that do not report federally are under-represented — a jurisdictional coverage gap, not a data defect. Accident narrative text (which can name injured or deceased workers) is deliberately excluded; only coded accident signals (a count and a fatality flag) are surfaced.

Coverage figures populate from the ingestion pipeline after the first sync.

{
  "tool": "corp.osha",
  "params": {
    "state": "OH",
    "standard": "19100147",
    "viol_type": "S",
    "limit": 10
  }
}

{
  "activity_nr": "341072429",
  "estab_name": "ACME ROOFING LLC",
  "site_city": "COLUMBUS",
  "site_state": "OH",
  "naics_code": "238160",
  "open_date": "2016-01-05",
  "close_case_date": "2016-09-30",
  "violation_count": 2,
  "serious_violation_count": 2,
  "penalty_total": 5250.00,
  "standards_cited": "19260451 C01; 19260501 B14",
  "has_accident": false,
  "had_fatality": false,
  "violations": [
    {
      "citation_id": "01001",
      "standard": "19260451 C01",
      "viol_type": "S",
      "initial_penalty": 3500.00,
      "current_penalty": 1750.00,
      "issuance_date": "2016-01-07",
      "abate_date": "2016-01-19",
      "final_order_date": "2016-08-26"
    }
  ]
}