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 schema

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,159 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,176,840 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,628 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,744 rows

strategic_codes

activity_nr, prog_type, prog_value, load_dt

2,897,530 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,222,011 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,579,650 rows

violation_gen_duty_std

activity_nr, citation_id, line_nr, line_text, load_dt

2,202,786 rows

... and 1 hidden table

Download SQLite DB: osha_enforcement.db 5.6 GB