DOL OSHA Enforcement – ​​US Department of Labor developer portal (2023)

The dataset consists of inspection case details for approximately 90,000 OSHA inspections conducted annually. The record includes information about the impetus for conducting the inspection, as well as details of subpoenas and penalties resulting from violations of OSHA standards. Accident investigation information is also provided, including textual descriptions of the accident and details of the injuries and fatalities that occurred. For more information, see:www.osha.gov.

accident table

https://data.dol.gov/get/accident

The table below provides OSHA accident information, including the date, time, description, and other related accident fields.

Accident
column namedata typeColumn Description
column namesummary_nodata typenumeric (9.0)Column DescriptionIdentifies the accident OSHA-170 form
column nameReport IDdata typecharacters(7)Column DescriptionIdentifies the federal or state OSHA reporting jurisdiction
column nameevent datedata typeTimestamp without time zoneColumn DescriptionAccident date (yyyymmdd hhmmss)
column nameevent_timedata typeDatumColumn DescriptionTime of accident (YYYYMMDD)
column nameevent_descdata typevarchar(200)SplitBrief description of the event
column nameevent_keyworddata typevarchar(200)Column DescriptionContains comma-separated keywords entered by ERG during the verification process
column nameconst_end_usedata typevarchar(1)Column DescriptionConstruction - End Use (ENDU code table)
column namebuild_storiesdata typenumeric(4.0)Column DescriptionConstruction - number of floors in the building
column namenonbuild_htdata typenumeric(4.0)column nameStructure - Height in feet if not a building
column nameProjectsdata typevarchar(1)Column DescriptionConstruction - Project Cost Range (COST Code Table)
column nameproject typedata typevarchar(1)Column DescriptionConstruction - project type (code table PTYP)
column namesic_listdata typevarchar(40)Column DescriptionComma-separated 4-digit SICs associated with associated inspections
column namedeathdata typevarchar(1)Column DescriptionX = Death is associated with an accident
column namestate flagdata typenumeric (1.0)Column DescriptionFlag used to identify a state
column nameabstract_textdata typevarcharColumn DescriptionAbstract text
column nameload_dtdata typeTimestamp without time zoneColumn DescriptionDate the upload was completed (yyyymmdd hhmmss)

Accident Summary Table

https://data.dol.gov/get/accident_abstract

(Video) I am DOL: Working for the Occupational Safety and Health Administration

The table below provides information on OSHA accident summaries. The information in the table is from the OSHA-170 form and is linked to OSHA accident reports, which can be found in the osha_accident table.

accident_abstract
column namedata typeColumn Description
column namesummary_nodata typenumeric (9.0)Column DescriptionIdentifies the accident OSHA-170 form
column nameline_nrdata typenumeric (7.0)Column DescriptionAbstract Line Number - This is a sequential number that should only be used to order the lines
column nameabstract_textdata typevarcharColumn DescriptionAbstract text
column nameload_dtdata typeTimestamp without time zoneColumn DescriptionDate the upload was completed (yyyymmdd hhmmss)

Accident Injury Table

https://data.dol.gov/get/accident_injury

The following table provides injury information related to OSHA accident reports. It contains information such as the degree of injury and the cause of the injury, and is linked to OSHA accident reports, which can be found in the osha_acident table.

accident_injury
column namedata typeColumn Description
column namesummary_nodata typenumeric (9.0)Column DescriptionIdentifies the accident OSHA-170 form
column namerel_insp_nrdata typenumeric (9.0)Column DescriptionIdentifies the inspection associated with the investigation of a specific violation
column nameAlterdata typenumeric (2.0)Column Descriptionage of the injured person
column nameSexdata typevarchar(1)Column DescriptionM=male or F=female
column namenature_of_injdata typenumeric (2.0)Column DescriptionType of violation codes - code table IN
column namebody partdata typenumeric (2.0)Column DescriptionBody Part Code - Code Table BD
column namesrc_of_injurydata typenumeric (2.0)Column DescriptionInjury Code Source - Code Table SO
column nameevent typedata typenumeric (2.0)Column DescriptionEvent Type Code - Code Table FT
column nameevn_factordata typenumeric (2.0)Column DescriptionEnvironmental Factor Code - Code Table EN
column namesum factordata typenumeric (2.0)Column DescriptionHuman Factor Code - HU Code Table
column nameOccupancy codedata typenumeric (3.0)Column DescriptionOccupation Code - Code Table OCC
column namedegree_of_injdata typenumeric (1.0)Column Description1 = fatal or 2 = in-hospital injuries or 3 = no in-hospital injuries
column nametask_assigneddata typenumeric (1.0)Column Description1=task assigned regularly or 2=task not assigned regularly
column nameHazsubdata typevarchar(4)Column DescriptionHazardous Substance Code
column nameconst_opdata typenumeric (2.0)Column DescriptionConstruction - Operation code (OPER code table)
column nameconst_op_causedata typenumeric (2.0)Column DescriptionConstruction - Cause of Injury (OPER Code Table)
column namefat causedata typenumeric (2.0)Column DescriptionConstruction site - cause of death (code table CAUS)
column namefall_distancedata typenumeric(4.0)Column DescriptionConstruction - Drop Height (feet)
column namefall_htdata typenumeric(4.0)Column DescriptionConstruction - Height of person at fall (feet)
column nameinjury_line_nodata typenumericColumn DescriptionLine of Injury Number - Often referenced in abstract text to refer to a specific person
column nameload_dtdata typeTimestamp without time zoneColumn DescriptionDate the upload was completed (yyyymmdd hhmmss)

inspection table

https://data.dol.gov/get/inspection

(Video) I am DOL: Working for the Employment and Training Administration

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 the Agency's standards for safe and healthy workplaces retain. OSHA publishes information about its inspection and citation activities on the Internet under the terms of the Electronic Freedom of Information Act. Data for a specific inspection exists when data exists for the inspection and the inspection is marked as complete.

Inspection
column namedata typeColumn Description
column nameActivity_Nodata typenumeric (9.0)Column DescriptionUnique identifier for the inspection
column nameReport IDdata typecharacters(7)Column DescriptionIdentifies the federal or state OSHA reporting jurisdiction
column namestate flagdata typecharacters(1)Column DescriptionFlag used to identify a state
column namecompany namedata typevarchar(300)Column Descriptionoperation inspected
column nameWebsite Addressdata typevarchar(300)Column DescriptionAddress of the site visited
column namesite_citydata typevarchar(180)Column DescriptionCity location inspected
column namesite_statedata typevarchar(20)Column DescriptionState postal code of the site visited
column namesite_zipdata typevarchar(40)Column DescriptionZIP code of the checked location
column nameowner typedata typeTextColumn DescriptionA=Private or B=LocalGovt or C=StateGovt or D=Federal
column nameowner codedata typevarchar(100)Column DescriptionOnly used for owner=D
column nameadv_noticedata typevarchar(1000)Column DescriptionJ/N/read
column namesafety_hlthdata typevarchar(100)Column DescriptionSafety/Health Indicator (S=Safety or H=Health)
column namesic_codedata typevarchar(40)Column DescriptionSIC-Code
column namenaics_codedata typevarchar(10)Column DescriptionUnique code number assigned to the NAICS
column nameinsp_typedata typevarchar(10)Column DescriptionA=accident or B=complaint or C=referral or D=monitoring or E=variance or F=follow up or G=rel. cancel or H=Planned or I=Related to Prog. or J=Other cancel or K=Other Prog. or L= Other-L
column nameinsp_scopedata typevarchar(10)Column DescriptionA=Full or B=Partial or C=Records or D=No inspection
column namewhy_no_inspdata typeTextColumn DescriptionA=No Exam/Not Found or B=No Exam/Business Loss or C=No Exam/Process Inactive or D=No Exam/10 or Less Empe or E=No Exam/Entry Denied or F=No Exam/SIC not on PG or G=No Insp/Exempt Voluntary or H=No Insp/NonExempt Consult or I=No Insp/Other
column nameunion statusdata typevarchar(10)Column DescriptionIndicates union representation during inspection (Yes=Y/U/A or No=N/B/blank)
column namesafety_manufdata typeTextcolumn nameSafety Planning Guide Manufacturing (X/blank)
column namesecurity constdata typevarchar(10)Column DescriptionSafety Planning Guide Construction (X/blank)
column namesafety_maritdata typeTextColumn DescriptionSafety planning guide maritime (X/blank)
column namehealth_manufdata typeTextColumn DescriptionProduction of the health planning guide (X/blank)
column namehealth_constdata typevarchar(10)Column DescriptionStructure of the health planning guide (X/blank)
column namehealth_maritdata typeTextColumn DescriptionMaritime Health Planning Guide (X/blank)
column nameMigrantdata typevarchar(10)Column DescriptionMigrant Labor Inspectorate (X/blank)
column namemail_streetdata typeTextColumn Descriptionpostal address street
column namemail_citydata typeTextColumn DescriptionCity of postal address
column namemail_statedata typeTextColumn DescriptionPostal address State postal code
column namemail_zipdata type(varchar15)Column Descriptionpostal address zip code
column namehost_est_keydata typevarchar(40)Column DescriptionInternal setup key
column nameopen_datedata typeDatumColumn DescriptionShows when the inspection started (YYYYMMDD)
column namecase_mod_datedata typeDatumColumn DescriptionDate the inspection or related findings were last affected by the update (YYYYMMDD). Note: This field was recently added to the database to facilitate the transfer process. For this reason. Cases unaffected by the April update. 2004 or later will be zero in this field
column nameclose_conf_datedata typeDatumColumn DescriptionFinal Conference Date (YYYYMMDD)
column nameclose_case_datedata typeDatumColumn DescriptionInspection Completion Date (YYYYMMDD)
column nameld_dtdata typeTimestamp without time zoneColumn DescriptionTimestamp of loading date (yyyymmdd hhmmss)

Optional information table

https://data.dol.gov/get/optional_info

The table below provides additional, optional information related to an OSHA inspection. The information is linked to OSHA inspection reports found in the osha_inspection table.

(Video) Intro to U.S. Federal Labor and Employment Agencies Webinar

optional_info
column namedata typeColumn Description
column nameActivity_Nodata typenumeric (9.0)Column DescriptionIdentifies the parent inspection
column nameopt_typedata typevarchar(1)Column DescriptionIdentifies the optional information type (only type N included)
column nameopt_iddata typenumeric (2.0)Column DescriptionOptional information ID
column nameopt_valuedata typevarchar(50)Column DescriptionOptional information value
column nameopt_info_iddata typenumericColumn DescriptionOptional Information-ID
column nameload_dtdata typeTimestamp without time zoneColumn DescriptionDate the upload was completed (yyyymmdd hhmmss)

Associated activity table

https://data.dol.gov/get/related_activity

The table below provides information about activities related to an OSHA inspection. The information is linked to OSHA inspection reports found in the osha_inspection table.

Related_activity
column namedata typeColumn Description
column nameActivity_Nodata typenumeric (9.0)Column DescriptionIdentifies the parent inspection
column namerel_typdata typevarchar(1)Column DescriptionC=complaint or I=inspection or R=transfer or A=accident
column namerel_akt_nrdata typenumeric (9.0)Column DescriptionActivity number of the associated activity
column namerel_securitydata typevarchar(1)Column DescriptionX=Yes or blank=No
column namerel_healthdata typevarchar(1)Column DescriptionX=Yes or blank=No
column nameload_dtdata typeTimestamp without time zoneColumn DescriptionDate the upload was completed (yyyymmdd hhmmss)

Table of Strategic Codes

https://data.dol.gov/get/strategic_codes

The table below provides information on strategic codes associated with 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.

(Video) What can YOU do to help address child labor and forced labor?

strategic_codes
column namedata typeColumn Description
column nameActivity_Nodata typenumeric (9.0)Column DescriptionIdentifies the parent inspection
column nameprog_typedata typevarchar(1)Column DescriptionN=NEP (National Priority Program) or L=LEP (Local Priority Program) or S=Strategic plan code
column nameprog_valuedata typevarchar(25)Column DescriptionCodewert
column nameload_dtdata typeTimestamp without time zoneColumn DescriptionDate the upload was completed (yyyymmdd hhmmss)

injury table

https://data.dol.gov/get/violation

The following table provides information about OSHA violations that violate the law, Executive Order 12196, or 29 CFR Part 1960. OSHA publishes information related to its inspection and citation activities on the Internet under the terms of the Electronic Freedom of Information Act. Data for a particular citation may not be available 5 days after receipt by the employer for federal inspections or 30 days after receipt by the employer for state inspections. The information is linked to OSHA inspection reports found in the osha_inspection table.

violation
column namedata typeColumn Description
column nameActivity_Nodata typenumeric (9.0)Column DescriptionIdentifies the parent inspection
column namecitation_iddata typevarchar(25)Column DescriptionIdentifies the citation number, item number, and item group of the literature on display
column namedelete_flagdata typevarchar(25)Column DescriptionD=deleted
column nameStandarddata typevarchar(100)Column DescriptionOSHA standard violated
column nameviol_typedata typevarchar(25)Column DescriptionS=Serious or W=Intentional or R=Repeat or O=Other
column namedate of issuedata typeDatumColumn DescriptionQuote Issue Date (YYYYMMDD)
column nameabate_datedata typeDatumColumn DescriptionDate by which the violation must be resolved (YYYYMMDD)
column nameabate_completedata typevarchar(25)Column DescriptionQ=Quick Fix or X=Correction Completed or I=Corrected During Inspection or E=Not Completed - Employer Out of Business or W=Not Changed - Job Location Changed or S=Not Completed - Attorney Consulted or A=Not Completed - AD- discretion
column namecurrent_penaltydata typenumeric (24.2)Column DescriptionCurrent Penalty Set (ZZZZZZ9.99)
column nameinitial penaltydata typenumeric (24.2)Column DescriptionInitial penalty imposed (ZZZZZZ9.99)
column namecompetition_datedata typeDatumColumn DescriptionDisputed Date (YYYYMMDD)
column namefinal_order_datedata typeDatumColumn DescriptionFinal Order Date (YYYYMMDD)
column nameno_instancesdata typenumeric (5.0)Column DescriptionNumber of Instances
column namenr_exposeddata typenumeric (5.0)Column DescriptionNumber of exposed employees
column namerecdata typevarchar(25)Column DescriptionA = Accident or C = Complaint or I = Imminent danger or R = Transfer or V = Deviation
column nameheavinessdata typevarchar(25)Column DescriptionHeavy Fiddle Severity - 01-10 or blank
column namemain emphasisdata typevarchar(25)Column DescriptionX or blank
column nameHazcatdata typevarchar(25)Column DescriptionIndustry standard general hazard category
column namefta_insp_nrdata typenumeric (9.0)Column DescriptionESTV control number
column namefta_issuance_datedata typeDatumColumn DescriptionDate of issue of the free zone (YYYYMMDD)
column namefta_strafedata typenumeric (24.2)Column DescriptionFTA-Strafe (ZZZZZZ9,99)
column namefta_contest_datedata typeDatumColumn DescriptionFTA Contest Date (YYYYMMDD)
column namefta_final_order_datedata typeDatumColumn DescriptionFinal Order Date of FTA (YYYYMMDD)
column namehazsub1data typevarchar(25)Column DescriptionHazardous Substance Code
column namehatsub2data typevarchar(25)Column DescriptionHazardous Substance Code
column namehatsub3data typevarchar(25)Column DescriptionHazardous Substance Code
column namehazsub4data typevarchar(25)Column DescriptionHazardous Substance Code
column namehatsub5data typevarchar(25)Column DescriptionHazardous Substance Code
column nameload_dtdata typeTimestamp without time zoneColumn DescriptionDate the upload was completed (yyyymmdd hhmmss)

Injury Event Table

https://data.dol.gov/get/violation_event

The following table provides information about OSHA injury events, including event and penalty information. The information is linked to OSHA violation reports in the osha_violation table and inspection reports in the osha_inspection table.

(Video) Examining the Policies and Priorities of the U.S. Department of Labor

injury event
column namedata typeColumn Description
column nameActivity_Nodata typenumeric (9.0)Column DescriptionIdentifies the associated inspection
column namecitation_iddata typevarchar(7)Column DescriptionIdentifies the citation number, item number, and item group of the associated citation
column namepen_ftadata typevarchar(1)Column DescriptionP=Penalty or F=FTA
column namehist_eventdata typevarchar(1)Column DescriptionZ=Issued or P=Petition for Mod Removal or I=Informal Settlement or A=Change or W=Empr. Withdrawn or D=Government Rejected or L=State Settlement or Y=State Decision or F=Formal Settlement or J=ALJ Decision or R=Review Committee or 1=Regional Court or 2=Court of Appeals or 3=Supreme Court
column namehist_datedata typeDatumColumn DescriptionEvent date (YYYYMMDD)
column namehist_strafedata typevarchar(10)Column DescriptionAmount assessed (ZZZZZZ9.99)
column namehist_abate_datedata typeDatumColumn DescriptionReduction Date (YYYYMMDD) – if pen-fta=P
column namehist_vtypedata typevarchar(1)Column DescriptionInjury type - if pen-fta=P
column namehist_insp_nrdata typenumeric (9.0)Column DescriptionFTA control number - if pen-fta=F
column nameload_dtdata typeTimestamp without time zoneColumn DescriptionDate the upload was completed (yyyymmdd hhmmss)

Violation of the general mandatory norms table

https://data.dol.gov/get/violation_gen_duty_std

The table below provides information on common mandatory standards identified during OSHA inspections. The information is linked to OSHA violation reports in the osha_violation table and inspection reports in the osha_inspection table.

injury_gen_duty_hrs
column namedata typeColumn Description
column nameActivity_Nodata typenumeric (9.0)Column DescriptionIdentifies the associated inspection
column namecitation_iddata typevarchar(30)Column DescriptionIdentifies the citation number, item number, and item group of the associated citation
column nameline_nrdata typeintegerColumn DescriptionIdentifies the relative line in the quote text, represented by line text
column nameLine textdata typevarcharColumn DescriptionQuote text line
column nameload_dtdata typeTimestamp without time zoneColumn DescriptionDate the upload was completed (yyyymmdd hhmmss)

Videos

1. Stop Silicosis 1938 US DOL
(markdcatlin)
2. New Employment Laws and Updates from the Dept of Labor Under a Biden Administration
(Conn Maciel Carey LLP)
3. Gerard Scannell interview on his years at OSHA in the 1970s
(markdcatlin)
4. Department of Labor's Workers Memorial Day Program
(USDepartmentofLabor)
5. OSHA Injury Tracking Application
(OSHA Compliance Help)
6. Significant Federal Labor & Employment Legal Developments in 2021
(hrsimple)

References

Top Articles
Latest Posts
Article information

Author: Delena Feil

Last Updated: 10/01/2023

Views: 5573

Rating: 4.4 / 5 (45 voted)

Reviews: 92% of readers found this page helpful

Author information

Name: Delena Feil

Birthday: 1998-08-29

Address: 747 Lubowitz Run, Sidmouth, HI 90646-5543

Phone: +99513241752844

Job: Design Supervisor

Hobby: Digital arts, Lacemaking, Air sports, Running, Scouting, Shooting, Puzzles

Introduction: My name is Delena Feil, I am a clean, splendid, calm, fancy, jolly, bright, faithful person who loves writing and wants to share my knowledge and understanding with you.