OSHA Compliance

http://api.dol.gov/V1/Compliance/OSHA

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

Browse Metadata Explore This Data

Dataset Tables

full Table

Full
Column Name Data Type Column Description
Column Name activity_nr Data Type integer Column Description Unique identifier for the inspection
Column Name estab_name Data Type varchar(300) Column Description Establishment being inspected
Column Name site_address Data Type varchar(300) Column Description Street address of site inspected
Column Name site_city Data Type varchar(180) Column Description City of site inspected
Column Name site_state Data Type varchar(20) Column Description State postal abbreviation of site inspected
Column Name site_zip Data Type varchar(40) Column Description Postal zip code of site inspected
Column Name naics_code Data Type varchar(10) Column Description NAICS Code
Column Name insp_type Data Type varchar(10) Column Description 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
Column Name open_date Data Type date Column Description Indicates when the inspection was started
Column Name total_current_penalty Data Type decimal(24,2) Column Description Total current penalty
Column Name osha_violation_indicator Data Type boolean Column Description OSHA Violation indicator
Column Name serious_violations Data Type integer Column Description Number of serious violations
Column Name total_violations Data Type integer Column Description Total violations
Column Name load_dt Data Type date Column Description The date the load was completed

foodService Table

Food Service
Column Name Data Type Column Description
Column Name activity_nr Data Type integer Column Description Unique identifier for the inspection
Column Name estab_name Data Type varchar(300) Column Description Establishment being inspected
Column Name site_address Data Type varchar(300) Column Description Street address of site inspected
Column Name site_city Data Type varchar(180) Column Description City of site inspected
Column Name site_state Data Type varchar(20) Column Description State postal abbreviation of site inspected
Column Name site_zip Data Type varchar(40) Column Description Postal zip code of site inspected
Column Name naics_code Data Type varchar(10) Column Description NAICS Code
Column Name insp_type Data Type varchar(10) Column Description 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
Column Name open_date Data Type date Column Description Indicates when the inspection was started
Column Name total_current_penalty Data Type decimal(24,2) Column Description Total current penalty
Column Name osha_violation_indicator Data Type boolean Column Description OSHA Violation indicator
Column Name serious_violations Data Type integer Column Description Number of serious violations
Column Name total_violations Data Type integer Column Description Total violations
Column Name load_dt Data Type date Column Description The date the load was completed

hospitality Table

Hospitality
Column Name Data Type Column Description
Column Name activity_nr Data Type integer Column Description Unique identifier for the inspection
Column Name estab_name Data Type varchar(300) Column Description Establishment being inspected
Column Name site_address Data Type varchar(300) Column Description Street address of site inspected
Column Name site_city Data Type varchar(180) Column Description City of site inspected
Column Name site_state Data Type varchar(20) Column Description State postal abbreviation of site inspected
Column Name site_zip Data Type varchar(40) Column Description Postal zip code of site inspected
Column Name naics_code Data Type varchar(10) Column Description NAICS Code
Column Name insp_type Data Type varchar(10) Column Description 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
Column Name open_date Data Type date Column Description Indicates when the inspection was started
Column Name total_current_penalty Data Type decimal(24,2) Column Description Total current penalty
Column Name osha_violation_indicator Data Type boolean Column Description OSHA Violation indicator
Column Name serious_violations Data Type integer Column Description Number of serious violations
Column Name total_violations Data Type integer Column Description Total violations
Column Name load_dt Data Type date Column Description The date the load was completed

retail Table

Retail
Column Name Data Type Column Description
Column Name activity_nr Data Type integer Column Description Unique identifier for the inspection
Column Name estab_name Data Type varchar(300) Column Description Establishment being inspected
Column Name site_address Data Type varchar(300) Column Description Street address of site inspected
Column Name site_city Data Type varchar(180) Column Description City of site inspected
Column Name site_state Data Type varchar(20) Column Description State postal abbreviation of site inspected
Column Name site_zip Data Type varchar(40) Column Description Postal zip code of site inspected
Column Name naics_code Data Type varchar(10) Column Description NAICS Code
Column Name insp_type Data Type varchar(10) Column Description 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
Column Name open_date Data Type date Column Description Indicates when the inspection was started
Column Name total_current_penalty Data Type decimal(24,2) Column Description Total current penalty
Column Name osha_violation_indicator Data Type boolean Column Description OSHA Violation indicator
Column Name serious_violations Data Type integer Column Description Number of serious violations
Column Name total_violations Data Type integer Column Description Total violations
Column Name load_dt Data Type date Column Description The date the load was completed

occupationCode Table

Occupation Code
Column Name Data Type Column Description
Column Name occupation_code Data Type varchar(300) Column Description Unique identifier for the occupation
Column Name occupation_description Data Type varchar(300) Column Description Description of the occupation
Column Name occupation_code_description Data Type varchar(300) Column Description Occupation code and description

substanceCode Table

Substance Code
Column Name Data Type Column Description
Column Name substance_code Data Type varchar(300) Column Description Unique identifier for the substance
Column Name substance_name Data Type varchar(300) Column Description Substance name
Column Name substance_code_name Data Type varchar(300) Column Description Substance code and name