OSHA Enforcement Data (inspections, citations, accidents)

Every OSHA inspection on record since 1970, with associated citations, penalties, and accident investigations. Sourced from the federal Occupational Safety and Health Administration's "Integrated Management Information System" (IMIS), the system that captures every enforcement action by federal OSHA offices and the 28 state-plan OSHA programs.

The data is downloaded nightly from DOL's Enforcement Data Catalog (the same upstream source as the WHISARD data); processing scripts live at labordata/osha-enforcement.

Data source: DOL Enforcement Data Catalog, processed

Custom SQL query

Tables

accident

summary_nr, report_id, event_date, event_time, event_desc, event_keyword, const_end_use, build_stories, nonbuild_ht, project_cost, project_type, sic_list, fatality, state_flag, abstract_text, load_dt

165,801 rows

accident_abstract

summary_nr, line_nr, abstract_text, load_dt

1,151,160 rows

accident_injury

summary_nr, rel_insp_nr, age, sex, nature_of_inj, part_of_body, src_of_injury, event_type, evn_factor, hum_factor, occ_code, degree_of_inj, task_assigned, hazsub, const_op, const_op_cause, fat_cause, fall_distance, fall_ht, injury_line_nr, load_dt

231,809 rows

body_part

accident_code, accident_number, accident_value, accident_letter, load_dt

31 rows

cost

accident_code, accident_number, accident_value, accident_letter, load_dt

7 rows

degree_injury

accident_code, accident_number, accident_value, accident_letter, load_dt

3 rows

end_use

accident_code, accident_number, accident_value, accident_letter, load_dt

17 rows

environmental

accident_code, accident_number, accident_value, accident_letter, load_dt

35 rows

event_type

accident_code, accident_number, accident_value, accident_letter, load_dt

14 rows

fatality

accident_code, accident_number, accident_value, accident_letter, load_dt

30 rows

human

accident_code, accident_number, accident_value, accident_letter, load_dt

20 rows

injury

accident_code, accident_number, accident_value, accident_letter, load_dt

22 rows

injury_source

accident_code, accident_number, accident_value, accident_letter, load_dt

48 rows

inspection

activity_nr, reporting_id, state_flag, estab_name, site_address, site_city, site_state, site_zip, owner_type, owner_code, adv_notice, safety_hlth, sic_code, naics_code, insp_type, insp_scope, why_no_insp, union_status, safety_manuf, safety_const, safety_marit, health_manuf, health_const, health_marit, migrant, mail_street, mail_city, mail_state, mail_zip, host_est_key, nr_in_estab, open_date, case_mod_date, close_conf_date, close_case_date, ld_dt

5,179,605 rows

occupation

accident_code, accident_number, accident_value, accident_letter, load_dt

573 rows

operator

accident_code, accident_number, accident_value, accident_letter, load_dt

71 rows

optional_info

activity_nr, opt_type, opt_id, opt_value, opt_info_id, load_dt

1,698,779 rows

project_type

accident_code, accident_number, accident_value, accident_letter, load_dt

5 rows

related_activity

activity_nr, rel_type, rel_act_nr, rel_safety, rel_health, load_dt

2,477,828 rows

strategic_codes

activity_nr, prog_type, prog_value, load_dt

2,901,581 rows

task

accident_code, accident_number, accident_value, accident_letter, load_dt

2 rows

violation

activity_nr, citation_id, delete_flag, standard, viol_type, issuance_date, abate_date, abate_complete, current_penalty, initial_penalty, contest_date, final_order_date, nr_instances, nr_exposed, rec, gravity, emphasis, hazcat, fta_insp_nr, fta_issuance_date, fta_penalty, fta_contest_date, fta_final_order_date, hazsub1, hazsub2, hazsub3, hazsub4, hazsub5, load_dt

13,227,024 rows

violation_event

activity_nr, citation_id, pen_fta, hist_event, hist_date, hist_penalty, hist_abate_date, hist_vtype, hist_insp_nr, load_dt

11,589,476 rows

violation_gen_duty_std

activity_nr, citation_id, line_nr, line_text, load_dt

2,204,627 rows

Database schema

Download SQLite DB: osha_enforcement.db 2.0 GB