OSHA Enforcement
The dataset consists of inspection case detail for approximately 90,000 OSHA inspections conducted annually. The dataset includes information regarding the impetus for conducting the inspection, and details on citations and penalty assessments resulting from violations of OSHA standards. Additionally, accident investigation information is provided, including textual descriptions of the accident, and details regarding the injuries and fatalities which occurred. For more information refer to: www.osha.gov.
View OSHA's metric codes on the 'Data Enforcement' page under 'OSHA Enforcement Data' or Downloaded.
The following datasets use offset for pagination so you can gather more than the limit of 200 records. For more detailed information read about the how to use our offset under the "data.dol.gov" tab.
Dataset Tables
Accident Table
https://data.dol.gov/get/accident
The following table contains OSHA accident information including date, time, description, and other associated accident fields.
| Column Name | Column Description | Data Type |
|---|---|---|
| summary_nr | Identifies the accident OSHA-170 form | numeric(9,0) |
| report_id | Identifies the OSHA federal or state reporting jurisdiction | char(7) |
| event_date | Date of accident (yyyymmdd hhmmss) | timestamp without time zone |
| event_time | Time of accident (yyyymmdd) | date |
| event_desc | Short description of event | varchar(200) |
| event_keyword | Contains comma separated keywords entered by ERG during the review process | varchar(200) |
| const_end_use | Construction - end-use (code table ENDU) | varchar(1) |
| build_stories | Construction - number of stories in building | numeric(4,0) |
| nonbuild_ht | Construction - height in feet when not a building | numeric(4,0) |
| project_cost | Construction - project cost range (code table COST) | varchar(1) |
| project_type | Construction - project type (code table PTYP) | varchar(1) |
| sic_list | Comma separated 4-digit SICs associated with related inspections | varchar(40) |
| fatality | X=Fatality is associated with accident | varchar(1) |
| state_flag | Flag used to identify a State | numeric(1,0) |
| abstract_text | Abstract text | varchar |
| load_dt | Date the load was completed (yyyymmdd hhmmss) | timestamp without time zone |
Accident Abstract Table
https://data.dol.gov/get/accident_abstract
The following table contains information about OSHA accident abstracts. The information in the table originates from form OSHA-170 and is linked to OSHA accident reports found in the osha_accident table.
| Column Name | Column Description | Data Type |
|---|---|---|
| summary_nr | Identifies the accident OSHA-170 form | numeric(9,0) |
| line_nr | Abstract line number - this is a sequence number which should only be used for ordering the lines | numeric(7,0) |
| abstract_text | Abstract text | varchar |
| load_dt | Date the load was completed (yyyymmdd hhmmss) | timestamp without time zone |
Accident Injury Table
https://data.dol.gov/get/accident_injury
The following table contains information about injuries associated with OSHA accident reports. It includes information such as the Degree of Injury and the Cause of Injury and is linked to OSHA accident reports found in the osha_acident table.
| Column Name | Column Description | Data Type |
|---|---|---|
| summary_nr | Identifies the accident OSHA-170 form | numeric(9,0) |
| rel_insp_nr | Identifies the inspection associated with investigating a particular injury | numeric(9,0) |
| age | Age of the injured person | numeric(2,0) |
| sex | M=Male or F=Female | varchar(1) |
| nature_of_inj | Nature of injury code - code table IN | numeric(2,0) |
| part_of_body | Part of body code - code table BD | numeric(2,0) |
| src_of_injury | Source of injury code - code table SO | numeric(2,0) |
| event_type | Event type code - code table FT | numeric(2,0) |
| evn_factor | Environmental factor code - code table EN | numeric(2,0) |
| hum_factor | Human factor code - code table HU | numeric(2,0) |
| occ_code | Occupation code - code table OCC | numeric(3,0) |
| degree_of_inj | 1=Fatality or 2=Hospitalized injuries or 3=No Hospitalized injuries | numeric(1,0) |
| task_assigned | 1=Task regularly assigned or 2=Task not regularly assigned | numeric(1,0) |
| hazsub | Hazardous substance code | varchar(4) |
| const_op | Construction - operation code (code table OPER) | numeric(2,0) |
| const_op_cause | Construction - cause of injury (code table OPER) | numeric(2,0) |
| fat_cause | Construction - cause of fatality (code table CAUS) | numeric(2,0) |
| fall_distance | Construction - distance of fall (feet) | numeric(4,0) |
| fall_ht | Construction - height of person when fell (feet) | numeric(4,0) |
| injury_line_nr | Injury line number - is often referenced in the abstract text to refer to a particular person | numeric |
| load_dt | Date the load was completed (yyyymmdd hhmmss) | timestamp without time zone |
Inspection Table
https://data.dol.gov/get/inspection
http://enforcedata.dol.gov/views/dd_display.php
The following table highlights OSHA inspections conducted by OSHA compliance safety and health officers under the Occupational Safety and Health Act of 1970 (the Act) to determine whether employers are complying with standards issued by the agency for safe and healthful workplaces. OSHA publishes information on its inspection and citation activity on the Internet under the provisions of the Electronic Freedom of Information Act. Data for a given inspection will be present if data exists for the inspection and the inspection is indicated as being closed.
| Column Name | Column Description | Data Type |
|---|---|---|
| activity_nr | Unique identifier for the inspection | numeric(9,0) |
| reporting_id | Identifies the OSHA federal or state reporting jurisdiction | char(7) |
| state_flag | Flag used to identify a State | char(1) |
| estab_name | Establishment being inspected | varchar(300) |
| site_address | Street address of site inspected | varchar(300) |
| site_city | City of site inspected | varchar(180) |
| site_state | State postal abbreviation of site inspected | varchar(20) |
| site_zip | Postal zip code of site inspected | varchar(40) |
| owner_type | A=Private or B=LocalGovt or C=StateGovt or D=Federal | text |
| owner_code | Used for owner=D only | varchar(100) |
| adv_notice | Y/N/blank | varchar(1000) |
| safety_hlth | Safety/Health indicator (S=Safety or H=Health) | varchar(100) |
| sic_code | SIC code | varchar(40) |
| naics_code | Unique code number that is assigned to the NAICS | varchar(10) |
| insp_type | A=Accident or B=Complaint or C=Referral or D=Monitoring or E=Variance or F=FollowUp or G=Unprog Rel or H=Planned or I=Prog Related or J=Unprog Other or K=Prog Other or L=Other-L | varchar(10) |
| insp_scope | A=Complete or B=Partial or C=Records or D=NoInspection | varchar(10) |
| why_no_insp | A=No Insp/Not Found or B=No Insp/Out of Business or C=No Insp/Process Inactive or D=No Insp/10 or Fewer Empe or E=No Insp/Denied Entry or F=No Insp/SIC not on PG or G=No Insp/Exempt Voluntary or H=No Insp/NonExempt Consult or I=No Insp/Other | text |
| union_status | Indicates union representation during inspection (Yes=Y/U/A or No=N/B/blank) | varchar(10) |
| safety_manuf | Safety planning guide manufacturing (X/blank) | text |
| safety_const | Safety planning guide construction (X/blank) | varchar(10) |
| safety_marit | Safety planning guide maritime (X/blank) | text |
| health_manuf | Health planning guide manufacturing (X/blank) | text |
| health_const | Health planning guide construction (X/blank) | varchar(10) |
| health_marit | Health planning guide maritime (X/blank) | text |
| migrant | Migrant labor inspection (X/blank) | varchar(10) |
| mail_street | Mailing address street | text |
| mail_city | Mailing address city | text |
| mail_state | Mailing address state postal abbreviation | text |
| mail_zip | Mailing address postal zip code | varchar15) |
| host_est_key | Internal establishment key | varchar(40) |
| open_date | Indicates when the inspection was started (yyyymmdd) | date |
| case_mod_date | Date the inspection or associated violations were last affected by updating (yyyymmdd). Note: this field was only recently added to the database to facilitate the transfer process. Therefore. cases not affected by updating in April. 2004 or later will have zero in this field | date |
| close_conf_date | Closing conference date (yyyymmdd) | date |
| close_case_date | Close date of inspection (yyyymmdd) | date |
| ld_dt | Load Date Timestamp (yyyymmdd hhmmss) | timestamp without time zone |
Optional Information Table
https://data.dol.gov/get/optional_info
The following table provides additional, optional information associated with an OSHA inspection. The information is linked to OSHA inspection reports found in the osha_inspection table.
| Column Name | Column Description | Data Type |
|---|---|---|
| activity_nr | Identifies the parent inspection | numeric(9,0) |
| opt_type | Identifies the optional information type (only N type included) | varchar(1) |
| opt_id | Optional information ID | numeric(2,0) |
| opt_value | Optional information value | varchar(50) |
| opt_info_id | Optional Information ID | numeric |
| load_dt | Date the load was completed (yyyymmdd hhmmss) | timestamp without time zone |
Related Activity Table
https://data.dol.gov/get/related_activity
The following table provides information about activity related to an OSHA inspection. The information is linked to OSHA inspection reports found in the osha_inspection table.
| Column Name | Column Description | Data Type |
|---|---|---|
| activity_nr | Identifies the parent inspection | numeric(9,0) |
| rel_type | C=Complaint or I=Inspection or R=Referral or A=Accident | varchar(1) |
| rel_act_nr | Activity number of the related activity | numeric(9,0) |
| rel_safety | X=Yes or blank=No | varchar(1) |
| rel_health | X=Yes or blank=No | varchar(1) |
| load_dt | Date the load was completed (yyyymmdd hhmmss) | timestamp without time zone |
Strategic Codes Table
https://data.dol.gov/get/strategic_codes
The following table provides information about strategic codes tied to OSHA inspections, including NEP (National Emphasis Program), LEP (Local Emphasis Program), and Strategic Plan Code. The information is linked to OSHA inspection reports found in the osha_inspection table.
| Column Name | Column Description | Data Type |
|---|---|---|
| activity_nr | Identifies the parent inspection | numeric(9,0) |
| prog_type | N=NEP (National Emphasis Program) or L=LEP (Local Emphasis Program) or S=Strategic Plan Code | varchar(1) |
| prog_value | Code value | varchar(25) |
| load_dt | Date the load was completed (yyyymmdd hhmmss) | timestamp without time zone |
Violation Table
https://data.dol.gov/get/violation
The following table contains information about OSHA violations that are in violation of the Act, Executive Order 12196, or 29 CFR Part 1960. OSHA publishes information on its inspection and citation activity on the Internet under the provisions of the Electronic Freedom of Information Act. Data for a given citation may not be available for 5 days following receipt by the employer for Federal inspections or for 30 days following receipt by the employer for State inspections. The information is linked to OSHA inspection reports found in the osha_inspection table.
| Column Name | Column Description | Data Type |
|---|---|---|
| activity_nr | Identifies the parent inspection | numeric(9,0) |
| citation_id | Identifies the citation number, item number, and item group of the issued citation | varchar(25) |
| delete_flag | D=deleted | varchar(25) |
| standard | OSHA standard violated | varchar(100) |
| viol_type | S=Serious or W=Willful or R=Repeat or O=Other | varchar(25) |
| issuance_date | Date of citation issuance (yyyymmdd) | date |
| abate_date | Date by which the violation must be abated (yyyymmdd) | date |
| abate_complete | Q=Quick Fix or X=Abatement Completed or I=Corrected During Inspection or E=Not Completed - Employer out of business or W=Not Changed - Worksite changed or S=Not Completed - Solicitor advised or A=Not Completed - AD discretion | varchar(25) |
| current_penalty | Current penalty assessed (ZZZZZZ9.99) | numeric(24,2) |
| initial_penalty | Initial penalty assessed (ZZZZZZ9.99) | numeric(24,2) |
| contest_date | Date contested (yyyymmdd) | date |
| final_order_date | Date of final order (yyyymmdd) | date |
| nr_instances | Number of instances | numeric(5,0) |
| nr_exposed | Number of employees exposed | numeric(5,0) |
| rec | A=Accident or C=Complaint or I=Imminent Danger or R=Referral or V=Variance | varchar(25) |
| gravity | Level of gravity for serious viol - 01-10 or blank | varchar(25) |
| emphasis | X or blank | varchar(25) |
| hazcat | General industry standard hazard category | varchar(25) |
| fta_insp_nr | FTA inspection number | numeric(9,0) |
| fta_issuance_date | FTA issuance date (yyyymmdd) | date |
| fta_penalty | FTA penalty (ZZZZZZ9.99) | numeric(24,2) |
| fta_contest_date | FTA contest date (yyyymmdd) | date |
| fta_final_order_date | FTA final order date (yyyymmdd) | date |
| hazsub1 | Hazardous substance code | varchar(25) |
| hazsub2 | Hazardous substance code | varchar(25) |
| hazsub3 | Hazardous substance code | varchar(25) |
| hazsub4 | Hazardous substance code | varchar(25) |
| hazsub5 | Hazardous substance code | varchar(25) |
| load_dt | Date the load was completed (yyyymmdd hhmmss) | timestamp without time zone |
Violation Event Table
https://data.dol.gov/get/violation_event
The following table provides information about OSHA violation events, including the event and penalty information. The information is linked to OSHA violation reports found in the osha_violation table and inspection reports found in the osha_inspection table.
| Column Name | Column Description | Data Type |
|---|---|---|
| activity_nr | Identifies the associated inspection | numeric(9,0) |
| citation_id | Identifies the citation number, item number, and item group of the associated citation | varchar(7) |
| pen_fta | P=Penalty or F=FTA | varchar(1) |
| hist_event | Z=Issued or P=Petition to Mod Abatement or I=Informal Settlement or A=Amendment or W=Empr Withdrew or D=Govt Dismissed or L=State Settlement or Y=State Decision or F=Formal Settlement or J=ALJ Decision or R=Review Commission or 1=State Lower Court or 2=Appeals Court or 3=Supreme Court | varchar(1) |
| hist_date | Date of the event (yyyymmdd) | date |
| hist_penalty | Amount assessed (ZZZZZZ9.99) | varchar(10) |
| hist_abate_date | Abatement date (yyyymmdd) - when pen-fta=P | date |
| hist_vtype | Violation type - when pen-fta=P | varchar(1) |
| hist_insp_nr | FTA inspection number - when pen-fta=F | numeric(9,0) |
| load_dt | Date the load was completed (yyyymmdd hhmmss) | timestamp without time zone |
Violation General Duty Standards Table
https://data.dol.gov/get/violation_gen_duty_std
The following table provides information associated with general duty standards cited during OSHA inspections. The information is linked to OSHA violation reports found in the osha_violation table and inspection reports found in the osha_inspection table.
| Column Name | Column Description | Data Type |
|---|---|---|
| activity_nr | Identifies the associated inspection | numeric(9,0) |
| citation_id | Identifies the citation number, item number, and item group of the associated citation | varchar(30) |
| line_nr | Identifies the relative line in the citation text represented by Line-text | integer |
| line_text | Citation text line | varchar |
| load_dt | Date the load was completed (yyyymmdd hhmmss) | timestamp without time zone |
Accident Table
https://data.dol.gov/get/accident
The following table contains OSHA accident information including date, time, description, and other associated accident fields.
accident - OSHA Enforcement
Column Name: summary_nr
Column Description: Identifies the accident OSHA-170 form
Data Type: numeric(9,0)
Column Name: report_id
Column Description: Identifies the OSHA federal or state reporting jurisdiction
Data Type: char(7)
Column Name: event_date
Column Description: Date of accident (yyyymmdd hhmmss)
Data Type: timestamp without time zone
Column Name: event_time
Column Description: Time of accident (yyyymmdd)
Data Type: date
Column Name: event_desc
Column Description: Short description of event
Data Type: varchar(200)
Column Name: event_keyword
Column Description: Contains comma separated keywords entered by ERG during the review process
Data Type: varchar(200)
Column Name: const_end_use
Column Description: Construction - end-use (code table ENDU)
Data Type: varchar(1)
Column Name: build_stories
Column Description: Construction - number of stories in building
Data Type: numeric(4,0)
Column Name: nonbuild_ht
Column Description: Construction - height in feet when not a building
Data Type: numeric(4,0)
Column Name: project_cost
Column Description: Construction - project cost range (code table COST)
Data Type: varchar(1)
Column Name: project_type
Column Description: Construction - project type (code table PTYP)
Data Type: varchar(1)
Column Name: sic_list
Column Description: Comma separated 4-digit SICs associated with related inspections
Data Type: varchar(40)
Column Name: fatality
Column Description: X=Fatality is associated with accident
Data Type: varchar(1)
Column Name: state_flag
Column Description: Flag used to identify a State
Data Type: numeric(1,0)
Column Name: abstract_text
Column Description: Abstract text
Data Type: varchar
Column Name: load_dt
Column Description: Date the load was completed (yyyymmdd hhmmss)
Data Type: timestamp without time zone
Accident Abstract Table
https://data.dol.gov/get/accident_abstract
The following table contains information about OSHA accident abstracts. The information in the table originates from form OSHA-170 and is linked to OSHA accident reports found in the osha_accident table.
accident_abstract - OSHA Enforcement
Column Name: summary_nr
Column Description: Identifies the accident OSHA-170 form
Data Type: numeric(9,0)
Column Name: line_nr
Column Description: Abstract line number - this is a sequence number which should only be used for ordering the lines
Data Type: numeric(7,0)
Column Name: abstract_text
Column Description: Abstract text
Data Type: varchar
Column Name: load_dt
Column Description: Date the load was completed (yyyymmdd hhmmss)
Data Type: timestamp without time zone
Accident Injury Table
https://data.dol.gov/get/accident_injury
The following table contains information about injuries associated with OSHA accident reports. It includes information such as the Degree of Injury and the Cause of Injury and is linked to OSHA accident reports found in the osha_acident table.
accident_injury - OSHA Enforcement
Column Name: summary_nr
Column Description: Identifies the accident OSHA-170 form
Data Type: numeric(9,0)
Column Name: rel_insp_nr
Column Description: Identifies the inspection associated with investigating a particular injury
Data Type: numeric(9,0)
Column Name: age
Column Description: Age of the injured person
Data Type: numeric(2,0)
Column Name: sex
Column Description: M=Male or F=Female
Data Type: varchar(1)
Column Name: nature_of_inj
Column Description: Nature of injury code - code table IN
Data Type: numeric(2,0)
Column Name: part_of_body
Column Description: Part of body code - code table BD
Data Type: numeric(2,0)
Column Name: src_of_injury
Column Description: Source of injury code - code table SO
Data Type: numeric(2,0)
Column Name: event_type
Column Description: Event type code - code table FT
Data Type: numeric(2,0)
Column Name: evn_factor
Column Description: Environmental factor code - code table EN
Data Type: numeric(2,0)
Column Name: hum_factor
Column Description: Human factor code - code table HU
Data Type: numeric(2,0)
Column Name: occ_code
Column Description: Occupation code - code table OCC
Data Type: numeric(3,0)
Column Name: degree_of_inj
Column Description: 1=Fatality or 2=Hospitalized injuries or 3=No Hospitalized injuries
Data Type: numeric(1,0)
Column Name: task_assigned
Column Description: 1=Task regularly assigned or 2=Task not regularly assigned
Data Type: numeric(1,0)
Column Name: hazsub
Column Description: Hazardous substance code
Data Type: varchar(4)
Column Name: const_op
Column Description: Construction - operation code (code table OPER)
Data Type: numeric(2,0)
Column Name: const_op_cause
Column Description: Construction - cause of injury (code table OPER)
Data Type: numeric(2,0)
Column Name: fat_cause
Column Description: Construction - cause of fatality (code table CAUS)
Data Type: numeric(2,0)
Column Name: fall_distance
Column Description: Construction - distance of fall (feet)
Data Type: numeric(4,0)
Column Name: fall_ht
Column Description: Construction - height of person when fell (feet)
Data Type: numeric(4,0)
Column Name: injury_line_nr
Column Description: Injury line number - is often referenced in the abstract text to refer to a particular person
Data Type: numeric
Column Name: load_dt
Column Description: Date the load was completed (yyyymmdd hhmmss)
Data Type: timestamp without time zone
Inspection Table
https://data.dol.gov/get/inspection
The following table highlights OSHA inspections conducted by OSHA compliance safety and health officers under the Occupational Safety and Health Act of 1970 (the Act) to determine whether employers are complying with standards issued by the agency for safe and healthful workplaces. OSHA publishes information on its inspection and citation activity on the Internet under the provisions of the Electronic Freedom of Information Act. Data for a given inspection will be present if data exists for the inspection and the inspection is indicated as being closed.
inspection - OSHA Enforcement
Column Name: activity_nr
Column Description: Unique identifier for the inspection
Data Type: numeric(9,0)
Column Name: reporting_id
Column Description: Identifies the OSHA federal or state reporting jurisdiction
Data Type: char(7)
Column Name: state_flag
Column Description: Flag used to identify a State
Data Type: char(1)
Column Name: estab_name
Column Description: Establishment being inspected
Data Type: varchar(300)
Column Name: site_address
Column Description: Street address of site inspected
Data Type: varchar(300)
Column Name: site_city
Column Description: City of site inspected
Data Type: varchar(180)
Column Name: site_state
Column Description: State postal abbreviation of site inspected
Data Type: varchar(20)
Column Name: site_zip
Column Description: Postal zip code of site inspected
Data Type: varchar(40)
Column Name: owner_type
Column Description: A=Private or B=LocalGovt or C=StateGovt or D=Federal
Data Type: text
Column Name: owner_code
Column Description: Used for owner=D only
Data Type: varchar(100)
Column Name: adv_notice
Column Description: Y/N/blank
Data Type: varchar(1000)
Column Name: safety_hlth
Column Description: Safety/Health indicator (S=Safety or H=Health)
Data Type: varchar(100)
Column Name: sic_code
Column Description: SIC code
Data Type: varchar(40)
Column Name: naics_code
Column Description: Unique code number that is assigned to the NAICS
Data Type: varchar(10)
Column Name: insp_type
Column Description: A=Accident or B=Complaint or C=Referral or D=Monitoring or E=Variance or F=FollowUp or G=Unprog Rel or H=Planned or I=Prog Related or J=Unprog Other or K=Prog Other or L=Other-L
Data Type: varchar(10)
Column Name: insp_scope
Column Description: A=Complete or B=Partial or C=Records or D=NoInspection
Data Type: varchar(10)
Column Name: why_no_insp
Column Description: A=No Insp/Not Found or B=No Insp/Out of Business or C=No Insp/Process Inactive or D=No Insp/10 or Fewer Empe or E=No Insp/Denied Entry or F=No Insp/SIC not on PG or G=No Insp/Exempt Voluntary or H=No Insp/NonExempt Consult or I=No Insp/Other
Data Type: text
Column Name: union_status
Column Description: Indicates union representation during inspection (Yes=Y/U/A or No=N/B/blank)
Data Type: varchar(10)
Column Name: safety_manuf
Column Description: Safety planning guide manufacturing (X/blank)
Data Type: text
Column Name: safety_const
Column Description: Safety planning guide construction (X/blank)
Data Type: varchar(10)
Column Name: safety_marit
Column Description: Safety planning guide maritime (X/blank)
Data Type: text
Column Name: health_manuf
Column Description: Health planning guide manufacturing (X/blank)
Data Type: text
Column Name: health_const
Column Description: Health planning guide construction (X/blank)
Data Type: varchar(10)
Column Name: health_marit
Column Description: Health planning guide maritime (X/blank)
Data Type: text
Column Name: migrant
Column Description: Migrant labor inspection (X/blank)
Data Type: varchar(10)
Column Name: mail_street
Column Description: Mailing address street
Data Type: text
Column Name: mail_city
Column Description: Mailing address city
Data Type: text
Column Name: mail_state
Column Description: Mailing address state postal abbreviation
Data Type: text
Column Name: mail_zip
Column Description: Mailing address postal zip code
Data Type: varchar15)
Column Name: host_est_key
Column Description: Internal establishment key
Data Type: varchar(40)
Column Name: open_date
Column Description: Indicates when the inspection was started (yyyymmdd)
Data Type: date
Column Name: case_mod_date
Column Description: Date the inspection or associated violations were last affected by updating (yyyymmdd). Note: this field was only recently added to the database to facilitate the transfer process. Therefore. cases not affected by updating in April. 2004 or later will have zero in this field
Data Type: date
Column Name: close_conf_date
Column Description: Closing conference date (yyyymmdd)
Data Type: date
Column Name: close_case_date
Column Description: Close date of inspection (yyyymmdd)
Data Type: date
Column Name: ld_dt
Column Description: Load Date Timestamp (yyyymmdd hhmmss)
Data Type: timestamp without time zone
Optional Information Table
https://data.dol.gov/get/optional_info
The following table provides additional, optional information associated with an OSHA inspection. The information is linked to OSHA inspection reports found in the osha_inspection table.
optional_info - OSHA Enforcement
Column Name: activity_nr
Column Description: Identifies the parent inspection
Data Type: numeric(9,0)
Column Name: opt_type
Column Description: Identifies the optional information type (only N type included)
Data Type: varchar(1)
Column Name: opt_id
Column Description: Optional information ID
Data Type: numeric(2,0)
Column Name: opt_value
Column Description: Optional information value
Data Type: varchar(50)
Column Name: opt_info_id
Column Description: Optional Information ID
Data Type: numeric
Column Name: load_dt
Column Description: Date the load was completed (yyyymmdd hhmmss)
Data Type: timestamp without time zone
Related Activity Table
https://data.dol.gov/get/related_activity
The following table provides information about activity related to an OSHA inspection. The information is linked to OSHA inspection reports found in the osha_inspection table.
related_activity - OSHA Enforcement
Column Name: activity_nr
Column Description: Identifies the parent inspection
Data Type: numeric(9,0)
Column Name: rel_type
Column Description: C=Complaint or I=Inspection or R=Referral or A=Accident
Data Type: varchar(1)
Column Name: rel_act_nr
Column Description: Activity number of the related activity
Data Type: numeric(9,0)
Column Name: rel_safety
Column Description: X=Yes or blank=No
Data Type: varchar(1)
Column Name: rel_health
Column Description: X=Yes or blank=No
Data Type: varchar(1)
Column Name: load_dt
Column Description: Date the load was completed (yyyymmdd hhmmss)
Data Type: timestamp without time zone
Strategic Codes Table
https://data.dol.gov/get/strategic_codes
The following table provides information about strategic codes tied to OSHA inspections, including NEP (National Emphasis Program), LEP (Local Emphasis Program), and Strategic Plan Code. The information is linked to OSHA inspection reports found in the osha_inspection table.
strategic_codes - OSHA Enforcement
Column Name: activity_nr
Column Description: Identifies the parent inspection
Data Type: numeric(9,0)
Column Name: prog_type
Column Description: N=NEP (National Emphasis Program) or L=LEP (Local Emphasis Program) or S=Strategic Plan Code
Data Type: varchar(1)
Column Name: prog_value
Column Description: Code value
Data Type: varchar(25)
Column Name: load_dt
Column Description: Date the load was completed (yyyymmdd hhmmss)
Data Type: timestamp without time zone
Violation Table
https://data.dol.gov/get/violation
The following table contains information about OSHA violations that are in violation of the Act, Executive Order 12196, or 29 CFR Part 1960. OSHA publishes information on its inspection and citation activity on the Internet under the provisions of the Electronic Freedom of Information Act. Data for a given citation may not be available for 5 days following receipt by the employer for Federal inspections or for 30 days following receipt by the employer for State inspections. The information is linked to OSHA inspection reports found in the osha_inspection table.
violation - OSHA Enforcement
Column Name: activity_nr
Column Description: Identifies the parent inspection
Data Type: numeric(9,0)
Column Name: citation_id
Column Description: Identifies the citation number, item number, and item group of the issued citation
Data Type: varchar(25)
Column Name: delete_flag
Column Description: D=deleted
Data Type: varchar(25)
Column Name: standard
Column Description: OSHA standard violated
Data Type: varchar(100)
Column Name: viol_type
Column Description: S=Serious or W=Willful or R=Repeat or O=Other
Data Type: varchar(25)
Column Name: issuance_date
Column Description: Date of citation issuance (yyyymmdd)
Data Type: date
Column Name: abate_date
Column Description: Date by which the violation must be abated (yyyymmdd)
Data Type: date
Column Name: abate_complete
Column Description: Q=Quick Fix or X=Abatement Completed or I=Corrected During Inspection or E=Not Completed - Employer out of business or W=Not Changed - Worksite changed or S=Not Completed - Solicitor advised or A=Not Completed - AD discretion
Data Type: varchar(25)
Column Name: current_penalty
Column Description: Current penalty assessed (ZZZZZZ9.99)
Data Type: numeric(24,2)
Column Name: initial_penalty
Column Description: Initial penalty assessed (ZZZZZZ9.99)
Data Type: numeric(24,2)
Column Name: contest_date
Column Description: Date contested (yyyymmdd)
Data Type: date
Column Name: final_order_date
Column Description: Date of final order (yyyymmdd)
Data Type: date
Column Name: nr_instances
Column Description: Number of instances
Data Type: numeric(5,0)
Column Name: nr_exposed
Column Description: Number of employees exposed
Data Type: numeric(5,0)
Column Name: rec
Column Description: A=Accident or C=Complaint or I=Imminent Danger or R=Referral or V=Variance
Data Type: varchar(25)
Column Name: gravity
Column Description: Level of gravity for serious viol - 01-10 or blank
Data Type: varchar(25)
Column Name: emphasis
Column Description: X or blank
Data Type: varchar(25)
Column Name: hazcat
Column Description: General industry standard hazard category
Data Type: varchar(25)
Column Name: fta_insp_nr
Column Description: FTA inspection number
Data Type: numeric(9,0)
Column Name: fta_issuance_date
Column Description: FTA issuance date (yyyymmdd)
Data Type: date
Column Name: fta_penalty
Column Description: FTA penalty (ZZZZZZ9.99)
Data Type: numeric(24,2)
Column Name: fta_contest_date
Column Description: FTA contest date (yyyymmdd)
Data Type: date
Column Name: fta_final_order_date
Column Description: FTA final order date (yyyymmdd)
Data Type: date
Column Name: hazsub1
Column Description: Hazardous substance code
Data Type: varchar(25)
Column Name: hazsub2
Column Description: Hazardous substance code
Data Type: varchar(25)
Column Name: hazsub3
Column Description: Hazardous substance code
Data Type: varchar(25)
Column Name: hazsub4
Column Description: Hazardous substance code
Data Type: varchar(25)
Column Name: hazsub5
Column Description: Hazardous substance code
Data Type: zvarchar(25)zz
Column Name: load_dt
Column Description: Date the load was completed (yyyymmdd hhmmss)
Data Type: timestamp without time zone
Violation Event Table
https://data.dol.gov/get/violation_event
The following table provides information about OSHA violation events, including the event and penalty information. The information is linked to OSHA violation reports found in the osha_violation table and inspection reports found in the osha_inspection table.
violation_event - OSHA Enforcement
Column Name: activity_nr
Column Description: Identifies the associated inspection
Data Type: numeric(9,0)
Column Name: citation_id
Column Description: Identifies the citation number, item number, and item group of the associated citation
Data Type: varchar(7)
Column Name: pen_fta
Column Description: P=Penalty or F=FTA
Data Type: varchar(1)
Column Name: hist_event
Column Description: Z=Issued or P=Petition to Mod Abatement or I=Informal Settlement or A=Amendment or W=Empr Withdrew or D=Govt Dismissed or L=State Settlement or Y=State Decision or F=Formal Settlement or J=ALJ Decision or R=Review Commission or 1=State Lower Court or 2=Appeals Court or 3=Supreme Court
Data Type: varchar(1)
Column Name: hist_date
Column Description: Date of the event (yyyymmdd)
Data Type: date
Column Name: hist_penalty
Column Description: Amount assessed (ZZZZZZ9.99)
Data Type: varchar(10)
Column Name: hist_abate_date
Column Description: Abatement date (yyyymmdd) - when pen-fta=P
Data Type: date
Column Name: hist_vtype
Column Description: Violation type - when pen-fta=P
Data Type: varchar(1)
Column Name: hist_insp_nr
Column Description: FTA inspection number - when pen-fta=F
Data Type: numeric(9,0)
Column Name: load_dt
Column Description: Date the load was completed (yyyymmdd hhmmss)
Data Type: timestamp without time zone
Violation General Duty Standards Table
https://data.dol.gov/get/violation_gen_duty_std
The following table provides information associated with general duty standards cited during OSHA inspections. The information is linked to OSHA violation reports found in the osha_violation table and inspection reports found in the osha_inspection table.
violation_gen_duty_std - OSHA Enforcement
Column Name: activity_nr
Column Description: Identifies the associated inspection
Data Type: numeric(9,0)
Column Name: citation_id
Column Description: Identifies the citation number, item number, and item group of the associated citation
Data Type: varchar(30)
Column Name: line_nr
Column Description: Identifies the relative line in the citation text represented by Line-text
Data Type: integer
Column Name: line_text
Column Description: Citation text line
Data Type: varchar
Column Name: load_dt
Column Description: Date the load was completed (yyyymmdd hhmmss)
Data Type: timestamp without time zone