osha_enforcement

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

151,197 rows

accident_abstract

summary_nr, line_nr, abstract_text, load_dt

1,050,008 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

216,585 rows

body_part

accident_code, accident_number, accident_value, accident_letter, load_date

31 rows

cost

accident_code, accident_number, accident_value, accident_letter, load_date

7 rows

degree_injury

accident_code, accident_number, accident_value, accident_letter, load_date

3 rows

end_use

accident_code, accident_number, accident_value, accident_letter, load_date

17 rows

environmental

accident_code, accident_number, accident_value, accident_letter, load_date

35 rows

event_type

accident_code, accident_number, accident_value, accident_letter, load_date

14 rows

fatality

accident_code, accident_number, accident_value, accident_letter, load_date

30 rows

human

accident_code, accident_number, accident_value, accident_letter, load_date

20 rows

injury

accident_code, accident_number, accident_value, accident_letter, load_date

22 rows

injury_source

accident_code, accident_number, accident_value, accident_letter, load_date

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

4,945,163 rows

occupation

accident_code, accident_number, accident_value, accident_letter, load_date

573 rows

operator

accident_code, accident_number, accident_value, accident_letter, load_date

71 rows

optional_info

activity_nr, opt_type, opt_id, opt_value, opt_info_id, load_dt

1,684,139 rows

project_type

accident_code, accident_number, accident_value, accident_letter, load_date

5 rows

related_activity

activity_nr, rel_type, rel_act_nr, rel_safety, rel_health, load_dt

2,233,916 rows

strategic_codes

activity_nr, prog_type, prog_value, load_dt

2,596,873 rows

task

accident_code, accident_number, accident_value, accident_letter, load_date

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

12,783,651 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

10,811,693 rows

violation_gen_duty_std

activity_nr, citation_id, line_nr, line_text, load_dt

1,270,852 rows

sqlite_stat1 (hidden)

tbl, idx, stat

24 rows

Download SQLite DB: osha_enforcement.db 3.6 GB