DOL OSHA Compliance Dataset
List of Tables |
Description
The dataset consists of inspection case detail for approximately 100,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.More information and details about the data provided can be found at http://www.osha.gov
This complete dataset can be found on the DOL Data Enforcement application at http://enforcedata.dol.gov
Frequency
Daily
Dataset Location
http://api.dol.gov/V1/Compliance/OSHA
Dataset Metadata
http://api.dol.gov/V1/Compliance/OSHA/$metadata
Dataset Sample
Sample this dataset.
full Table
Column Name |
Column Description |
Data Type |
|---|---|---|
activity_nr |
Unique identifier for the inspection |
integer |
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) |
naics_code |
NAICS Code |
varchar(10) |
insp_type |
Inspection Type - A=Accident. B=Complaint. C=Referral. D=Monitoring. E=Variance. F=FollowUp. G=Unprog Rel. H=Planned. I=Prog Related. J=Unprog Other. K=Prog Other. L=Other-L |
varchar(10) |
open_date |
Indicates when the inspection was started |
date |
total_current_penalty |
Total current penalty |
decimal(24,2) |
osha_violation_indicator |
OSHA Violation indicator |
boolean |
serious_violations |
Number of serious violations |
integer |
total_violations |
Total violations |
integer |
load_dt |
The date the load was completed |
date |
foodService Table
Column Name |
Column Description |
Data Type |
|---|---|---|
activity_nr |
Unique identifier for the inspection |
integer |
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) |
naics_code |
NAICS Code |
varchar(10) |
insp_type |
Inspection Type - A=Accident. B=Complaint. C=Referral. D=Monitoring. E=Variance. F=FollowUp. G=Unprog Rel. H=Planned. I=Prog Related. J=Unprog Other. K=Prog Other. L=Other-L |
varchar(10) |
open_date |
Indicates when the inspection was started |
date |
total_current_penalty |
Total current penalty |
decimal(24,2) |
osha_violation_indicator |
OSHA Violation indicator |
boolean |
serious_violations |
Number of serious violations |
integer |
total_violations |
Total violations |
integer |
load_dt |
The date the load was completed |
date |
hospitality Table
Column Name |
Column Description |
Data Type |
|---|---|---|
activity_nr |
Unique identifier for the inspection |
integer |
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) |
naics_code |
NAICS Code |
varchar(10) |
insp_type |
Inspection Type - A=Accident. B=Complaint. C=Referral. D=Monitoring. E=Variance. F=FollowUp. G=Unprog Rel. H=Planned. I=Prog Related. J=Unprog Other. K=Prog Other. L=Other-L |
varchar(10) |
open_date |
Indicates when the inspection was started |
date |
total_current_penalty |
Total current penalty |
decimal(24,2) |
osha_violation_indicator |
OSHA Violation indicator |
boolean |
serious_violations |
Number of serious violations |
integer |
total_violations |
Total violations |
integer |
load_dt |
The date the load was completed |
date |
retail Table
Column Name |
Column Description |
Data Type |
|---|---|---|
activity_nr |
Unique identifier for the inspection |
integer |
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) |
naics_code |
NAICS Code |
varchar(10) |
insp_type |
Inspection Type - A=Accident. B=Complaint. C=Referral. D=Monitoring. E=Variance. F=FollowUp. G=Unprog Rel. H=Planned. I=Prog Related. J=Unprog Other. K=Prog Other. L=Other-L |
varchar(10) |
open_date |
Indicates when the inspection was started |
date |
total_current_penalty |
Total current penalty |
decimal(24,2) |
osha_violation_indicator |
OSHA Violation indicator |
boolean |
serious_violations |
Number of serious violations |
integer |
total_violations |
Total violations |
integer |
load_dt |
The date the load was completed |
date |
occupationCode Table
Column Name |
Column Description |
Data Type |
|---|---|---|
occupation_code |
Unique identifier for the occupation |
varchar(300) |
occupation_description |
Description of the occupation |
varchar(300) |
occupation_code_description |
Occupation code and description |
varchar(300) |
substanceCode Table
Column Name |
Column Description |
Data Type |
|---|---|---|
substance_code |
Unique identifier for the substance |
varchar(300) |
substance_name |
Substance name |
varchar(300) |
substance_code_name |
Substance code and name |
varchar(300) |
