{"dataset": {"id": 10334, "name": "Inspection", "description": "This dataset provides the inspection case detail for OSHA inspections. The dataset includes information about why the inspection was conducted.\r\n\r\nAdditional records can be viewed and/or downloaded from OSHA\u2019s website at www.osha.gov/data.", "tablename": "OSHA_inspection", "published_at": "2026-06-03T20:33:20", "dataset_type": 1, "agency_id": 10, "agency": {"name": "Occupational Safety and Health Administration", "abbr": "OSHA"}, "frequency": "Daily", "api_url": "inspection", "tablename_alias": null, "category_id": 13, "category": {"name": "Enforcement"}, "category_name": "Enforcement", "code_snippets": [{"lang": "R", "code": "# Import libraries\nlibrary(httr)\nlibrary(jsonlite)\n\n# Get metadata\nmetadata_url = \"https://api.dol.gov/v4/get/OSHA/inspection/json/metadata\"\nparams = list(\"X-API-KEY\"=\"<APIKEY>\")\nmetadata_request = GET(metadata_url, query=params)\nmetadata = as.data.frame(fromJSON(content(metadata_request, \"text\")))\n\n# Get data\ndata_url = \"https://api.dol.gov/v4/get/OSHA/inspection/json\"\nparams = list(\"X-API-KEY\"=\"<APIKEY>\", \"limit\"=\"10\")\ndata_request = GET(data_url, query=params)\ndata = as.data.frame(fromJSON(content(data_request, \"text\")))"}, {"lang": "Python", "code": "# Import libraries\nimport requests, pandas as pd\n\n# Get metadata\nmetadata_url = \"https://api.dol.gov/v4/get/OSHA/inspection/json/metadata\"\nparams = {\"X-API-KEY\":\"<APIKEY>\"}\nmetadata_request = requests.get(metadata_url, params=params, verify=False)\nmetadata_json = metadata_request.json()\nmetadata = pd.DataFrame(metadata_json)\n\n# Get data \ndata_url = \"https://api.dol.gov/v4/get/OSHA/inspection/json\"\nparams = {\"X-API-KEY\":\"<APIKEY>\", \"limit\":\"10\"}\ndata_request = requests.get(data_url, params=params, verify=False)\ndata_json = data_request.json()['data']\ndata = pd.DataFrame(data_json)"}, {"lang": "Javascript", "code": "/* Get Metadata */\nfetch( 'https://api.dol.gov/v4/get/OSHA/inspection/json/metadata?X-API-KEY=<APIKEY>' )\n.then( response => response.json() )\n.then( response => {\n    console.log(response);\n    // Do something with response.\n} );\n\n/* Get Data */\nfetch( 'https://api.dol.gov/v4/get/OSHA/inspection/json?X-API-KEY=<APIKEY>&limit=10' )\n.then( response => response.json() )\n.then( response => {\n    console.log(response);\n    // Do something with response.\n});"}], "status": 4, "dataset_preview": "{\"data\": [{\"activity_nr\": 306953084, \"reporting_id\": \"0111700\", \"state_flag\": null, \"estab_name\": \"CHRISTMAS TREE SHOPS\", \"site_address\": \"92 CLUFF CROSSING ROAD\", \"site_city\": \"SALEM\", \"site_state\": \"NH\", \"site_zip\": \"03079\", \"owner_type\": \"A\", \"owner_code\": \"0000\", \"adv_notice\": \"N\", \"safety_hlth\": \"H\", \"sic_code\": \"5399\", \"naics_code\": \"452990\", \"insp_type\": \"F\", \"insp_scope\": \"B\", \"why_no_insp\": null, \"union_status\": \"N\", \"safety_manuf\": null, \"safety_const\": null, \"safety_marit\": null, \"health_manuf\": null, \"health_const\": null, \"health_marit\": null, \"migrant\": null, \"mail_street\": \"92 CLUFF  CROSSING ROAD\", \"mail_city\": \"SALEM\", \"mail_state\": \"NH\", \"mail_zip\": \"03079\", \"host_est_key\": \"N123    000010830\", \"nr_in_estab\": \"120\", \"open_date\": \"2005-12-20T00:00:00\", \"case_mod_date\": \"2006-01-06T00:00:00\", \"close_conf_date\": \"2005-12-20T00:00:00\", \"close_case_date\": \"2006-01-03T00:00:00\", \"load_dt\": \"2011-10-14T16:38:47\"}, {\"activity_nr\": 125110833, \"reporting_id\": \"0552652\", \"state_flag\": null, \"estab_name\": \"FIBER RESIN CORP\", \"site_address\": \"25200 MALYINA\", \"site_city\": \"WARREN\", \"site_state\": \"MI\", \"site_zip\": \"48089\", \"owner_type\": \"A\", \"owner_code\": \"0000\", \"adv_notice\": \"N\", \"safety_hlth\": \"S\", \"sic_code\": \"2821\", \"naics_code\": \"000000\", \"insp_type\": \"H\", \"insp_scope\": \"D\", \"why_no_insp\": \"A\", \"union_status\": null, \"safety_manuf\": \"X\", \"safety_const\": null, \"safety_marit\": null, \"health_manuf\": null, \"health_const\": null, \"health_marit\": null, \"migrant\": null, \"mail_street\": null, \"mail_city\": null, \"mail_state\": null, \"mail_zip\": \"00000\", \"host_est_key\": \"N176    000020357\", \"nr_in_estab\": null, \"open_date\": \"1997-08-18T00:00:00\", \"case_mod_date\": \"2007-05-16T00:00:00\", \"close_conf_date\": \"1997-08-18T00:00:00\", \"close_case_date\": \"1997-09-09T00:00:00\", \"load_dt\": \"2011-10-14T16:38:47\"}, {\"activity_nr\": 116194945, \"reporting_id\": \"0316700\", \"state_flag\": null, \"estab_name\": \"CARLISLE KITCHEN CENTER, INCORPORATED\", \"site_address\": \"701 S. SPRING GARDEN STREET\", \"site_city\": \"CARLISLE\", \"site_state\": \"PA\", \"site_zip\": \"17013\", \"owner_type\": \"A\", \"owner_code\": \"0000\", \"adv_notice\": \"N\", \"safety_hlth\": \"S\", \"sic_code\": \"5722\", \"naics_code\": \"000000\", \"insp_type\": \"H\", \"insp_scope\": \"D\", \"why_no_insp\": \"F\", \"union_status\": \"N\", \"safety_manuf\": null, \"safety_const\": null, \"safety_marit\": null, \"health_manuf\": null, \"health_const\": null, \"health_marit\": null, \"migrant\": null, \"mail_street\": null, \"mail_city\": null, \"mail_state\": null, \"mail_zip\": \"00000\", \"host_est_key\": null, \"nr_in_estab\": \"14\", \"open_date\": \"1998-03-13T00:00:00\", \"case_mod_date\": null, \"close_conf_date\": null, \"close_case_date\": \"1998-03-15T00:00:00\", \"load_dt\": \"2011-10-14T16:38:47\"}, {\"activity_nr\": 109466078, \"reporting_id\": \"0418300\", \"state_flag\": null, \"estab_name\": \"EARLY SERVICES, INC.\", \"site_address\": \"SOMERVILLE ROAD\", \"site_city\": \"DECATUR\", \"site_state\": \"AL\", \"site_zip\": \"35608\", \"owner_type\": \"A\", \"owner_code\": \"0000\", \"adv_notice\": \"N\", \"safety_hlth\": \"S\", \"sic_code\": \"1711\", \"naics_code\": \"000000\", \"insp_type\": \"H\", \"insp_scope\": \"A\", \"why_no_insp\": null, \"union_status\": \"N\", \"safety_manuf\": null, \"safety_const\": \"X\", \"safety_marit\": null, \"health_manuf\": null, \"health_const\": null, \"health_marit\": null, \"migrant\": null, \"mail_street\": \"P. O. BOX  1385\", \"mail_city\": \"DECATUR\", \"mail_state\": \"AL\", \"mail_zip\": \"35601\", \"host_est_key\": null, \"nr_in_estab\": \"2\", \"open_date\": \"1993-10-07T00:00:00\", \"case_mod_date\": null, \"close_conf_date\": \"1993-10-07T00:00:00\", \"close_case_date\": \"1993-10-07T00:00:00\", \"load_dt\": \"2011-10-14T16:38:47\"}, {\"activity_nr\": 103721254, \"reporting_id\": \"0950411\", \"state_flag\": null, \"estab_name\": \"SUN WEST CONTRACTORS INC\", \"site_address\": \"8811 N 51ST AVE\", \"site_city\": \"GLENDALE\", \"site_state\": \"AZ\", \"site_zip\": \"85302\", \"owner_type\": \"A\", \"owner_code\": \"0000\", \"adv_notice\": \"N\", \"safety_hlth\": \"S\", \"sic_code\": \"1542\", \"naics_code\": \"000000\", \"insp_type\": \"H\", \"insp_scope\": \"A\", \"why_no_insp\": null, \"union_status\": \"B\", \"safety_manuf\": null, \"safety_const\": \"X\", \"safety_marit\": null, \"health_manuf\": null, \"health_const\": null, \"health_marit\": null, \"migrant\": null, \"mail_street\": \"8160 N 67TH AVE SUITE 130\", \"mail_city\": \"GLENDALE\", \"mail_state\": \"AZ\", \"mail_zip\": \"85302\", \"host_est_key\": null, \"nr_in_estab\": \"5\", \"open_date\": \"1987-11-19T00:00:00\", \"case_mod_date\": null, \"close_conf_date\": \"1987-11-19T00:00:00\", \"close_case_date\": \"1987-11-30T00:00:00\", \"load_dt\": \"2011-10-14T16:38:47\"}, {\"activity_nr\": 311878862, \"reporting_id\": \"0336000\", \"state_flag\": null, \"estab_name\": \"GEM BUILDING CONTRACTORS & DEVELOPERS, INC.\", \"site_address\": \"1276 OTTER STREET\", \"site_city\": \"FRANKLIN\", \"site_state\": \"PA\", \"site_zip\": \"16323\", \"owner_type\": \"A\", \"owner_code\": \"0000\", \"adv_notice\": \"N\", \"safety_hlth\": \"H\", \"sic_code\": \"1542\", \"naics_code\": \"236220\", \"insp_type\": \"B\", \"insp_scope\": \"B\", \"why_no_insp\": null, \"union_status\": \"N\", \"safety_manuf\": null, \"safety_const\": null, \"safety_marit\": null, \"health_manuf\": null, \"health_const\": null, \"health_marit\": null, \"migrant\": null, \"mail_street\": \"3015 WILMINGTON ROAD\", \"mail_city\": \"NEW CASTLE\", \"mail_state\": \"PA\", \"mail_zip\": \"16105\", \"host_est_key\": \"N021    000010824\", \"nr_in_estab\": \"25\", \"open_date\": \"2010-08-24T00:00:00\", \"case_mod_date\": \"2010-11-08T00:00:00\", \"close_conf_date\": \"2010-09-10T00:00:00\", \"close_case_date\": \"2010-09-10T00:00:00\", \"load_dt\": \"2011-10-14T16:38:47\"}, {\"activity_nr\": 13260468, \"reporting_id\": \"0418300\", \"state_flag\": null, \"estab_name\": \"EMPIRE GAS INC OF LEEDS\", \"site_address\": \"HIGHWAY 78 EAST\", \"site_city\": \"Leeds\", \"site_state\": \"AL\", \"site_zip\": \"33094\", \"owner_type\": null, \"owner_code\": \"0000\", \"adv_notice\": null, \"safety_hlth\": \"S\", \"sic_code\": \"5984\", \"naics_code\": \"000000\", \"insp_type\": \"B\", \"insp_scope\": \"A\", \"why_no_insp\": null, \"union_status\": \"B\", \"safety_manuf\": null, \"safety_const\": null, \"safety_marit\": null, \"health_manuf\": null, \"health_const\": null, \"health_marit\": null, \"migrant\": null, \"mail_street\": null, \"mail_city\": null, \"mail_state\": null, \"mail_zip\": \"00000\", \"host_est_key\": null, \"nr_in_estab\": \"4\", \"open_date\": \"1978-12-01T00:00:00\", \"case_mod_date\": null, \"close_conf_date\": \"1978-12-01T00:00:00\", \"close_case_date\": \"1979-01-03T00:00:00\", \"load_dt\": \"2011-10-14T16:38:47\"}, {\"activity_nr\": 10303956, \"reporting_id\": \"0111700\", \"state_flag\": null, \"estab_name\": \"TAMPAX INC\", \"site_address\": \"RIVER RD\", \"site_city\": \"Claremont\", \"site_state\": \"NH\", \"site_zip\": \"03743\", \"owner_type\": null, \"owner_code\": \"0000\", \"adv_notice\": null, \"safety_hlth\": \"S\", \"sic_code\": \"2676\", \"naics_code\": \"000000\", \"insp_type\": \"H\", \"insp_scope\": \"A\", \"why_no_insp\": null, \"union_status\": \"B\", \"safety_manuf\": \"X\", \"safety_const\": null, \"safety_marit\": null, \"health_manuf\": null, \"health_const\": null, \"health_marit\": null, \"migrant\": null, \"mail_street\": null, \"mail_city\": null, \"mail_state\": null, \"mail_zip\": \"00000\", \"host_est_key\": null, \"nr_in_estab\": \"219\", \"open_date\": \"1982-08-05T00:00:00\", \"case_mod_date\": null, \"close_conf_date\": \"1982-08-05T00:00:00\", \"close_case_date\": \"1982-08-05T00:00:00\", \"load_dt\": \"2011-10-14T16:38:47\"}, {\"activity_nr\": 316113513, \"reporting_id\": \"0453730\", \"state_flag\": null, \"estab_name\": \"MISTRAS GROUP, INC.\", \"site_address\": \"5901 HIGHWAY 74 W\", \"site_city\": \"MARSHVILLE\", \"site_state\": \"NC\", \"site_zip\": \"28103\", \"owner_type\": \"A\", \"owner_code\": \"0000\", \"adv_notice\": \"N\", \"safety_hlth\": \"H\", \"sic_code\": \"1799\", \"naics_code\": \"238990\", \"insp_type\": \"G\", \"insp_scope\": \"A\", \"why_no_insp\": null, \"union_status\": \"N\", \"safety_manuf\": null, \"safety_const\": null, \"safety_marit\": null, \"health_manuf\": \"X\", \"health_const\": \"X\", \"health_marit\": \"X\", \"migrant\": null, \"mail_street\": \"1721 WILLIAMS ROAD\", \"mail_city\": \"MONROE\", \"mail_state\": \"NC\", \"mail_zip\": \"28112\", \"host_est_key\": \"N098    000035526\", \"nr_in_estab\": \"2\", \"open_date\": \"2011-08-22T00:00:00\", \"case_mod_date\": \"2012-02-07T00:00:00\", \"close_conf_date\": \"2011-10-04T00:00:00\", \"close_case_date\": \"2011-11-06T00:00:00\", \"load_dt\": \"2012-02-09T01:00:30\"}, {\"activity_nr\": 100063171, \"reporting_id\": \"0522300\", \"state_flag\": null, \"estab_name\": \"B. F. GOODRICH - AKRON CHEMICAL PLANT\", \"site_address\": \"240 W. EMERLING\", \"site_city\": \"AKRON\", \"site_state\": \"OH\", \"site_zip\": \"44309\", \"owner_type\": \"A\", \"owner_code\": \"0000\", \"adv_notice\": \"N\", \"safety_hlth\": \"H\", \"sic_code\": \"3011\", \"naics_code\": \"000000\", \"insp_type\": \"H\", \"insp_scope\": \"D\", \"why_no_insp\": \"C\", \"union_status\": \"A\", \"safety_manuf\": null, \"safety_const\": null, \"safety_marit\": null, \"health_manuf\": null, \"health_const\": null, \"health_marit\": null, \"migrant\": null, \"mail_street\": null, \"mail_city\": null, \"mail_state\": null, \"mail_zip\": \"00000\", \"host_est_key\": null, \"nr_in_estab\": \"233\", \"open_date\": \"1986-03-26T00:00:00\", \"case_mod_date\": null, \"close_conf_date\": \"1986-03-26T00:00:00\", \"close_case_date\": \"1986-03-28T00:00:00\", \"load_dt\": \"2011-10-14T16:38:47\"}]}", "dataset_metadatum": [{"column_name": "activity_nr", "data_type": "number", "column_desc": "Unique identifier for the inspection", "intended_datatype": "identifier"}, {"column_name": "reporting_id", "data_type": "varchar", "column_desc": "Identifies the OSHA federal or state reporting jurisdiction", "intended_datatype": "identifier"}, {"column_name": "state_flag", "data_type": "varchar", "column_desc": "The flag used to identify a State. (Note: This field is not populated)", "intended_datatype": "text"}, {"column_name": "estab_name", "data_type": "varchar", "column_desc": "Establishment being inspected", "intended_datatype": "text"}, {"column_name": "site_address", "data_type": "varchar", "column_desc": "Street address of site inspected", "intended_datatype": "text"}, {"column_name": "site_city", "data_type": "varchar", "column_desc": "City of site inspected", "intended_datatype": "categorical"}, {"column_name": "site_state", "data_type": "varchar", "column_desc": "State postal abbreviation of site inspected", "intended_datatype": "categorical"}, {"column_name": "site_zip", "data_type": "varchar", "column_desc": "Postal zip code of site inspected", "intended_datatype": "categorical"}, {"column_name": "owner_type", "data_type": "varchar", "column_desc": "A=Private. B=LocalGovt. C=StateGovt. D=Federal", "intended_datatype": "categorical"}, {"column_name": "owner_code", "data_type": "varchar", "column_desc": "Used for owner=D only", "intended_datatype": "text"}, {"column_name": "adv_notice", "data_type": "varchar", "column_desc": "Y/N/blank", "intended_datatype": "categorical"}, {"column_name": "safety_hlth", "data_type": "varchar", "column_desc": "Safety/Health indicator (S=Safety. H=Health)", "intended_datatype": "categorical"}, {"column_name": "sic_code", "data_type": "varchar", "column_desc": "SIC code", "intended_datatype": "categorical"}, {"column_name": "naics_code", "data_type": "varchar", "column_desc": "The unique code number that is assigned to the NAICS.", "intended_datatype": "categorical"}, {"column_name": "insp_type", "data_type": "varchar", "column_desc": "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. M=Fat/Cat. N=Unprog Emph", "intended_datatype": "categorical"}, {"column_name": "insp_scope", "data_type": "varchar", "column_desc": "A=Complete.B=Partial.C=Records.D=NoInspection", "intended_datatype": "categorical"}, {"column_name": "why_no_insp", "data_type": "varchar", "column_desc": "A=No Insp/Not Found.B=No Insp/Out of Business.C=No Insp/Process Inactive.D=No Insp/10 or Fewer Empe.E=No Insp/Denied Entry.F=No Insp/SIC not on PG.G=No Insp/Exempt Voluntary.H=No Insp/NonExempt Consult.I=No Insp/Other.J=No Insp/Employer Exempted By Appropriation Act", "intended_datatype": "categorical"}, {"column_name": "union_status", "data_type": "varchar", "column_desc": "Indicates union representation during inspection (Yes=Y/U/A. No=N/B/blank)", "intended_datatype": "categorical"}, {"column_name": "safety_manuf", "data_type": "varchar", "column_desc": "Safety planning guide manufacturing (X/blank)", "intended_datatype": "boolean"}, {"column_name": "safety_const", "data_type": "varchar", "column_desc": "Safety planning guide construction (X/blank)", "intended_datatype": "boolean"}, {"column_name": "safety_marit", "data_type": "varchar", "column_desc": "Safety planning guide maritime (X/blank)", "intended_datatype": "boolean"}, {"column_name": "health_manuf", "data_type": "varchar", "column_desc": "Health planning guide manufacturing (X/blank)", "intended_datatype": "boolean"}, {"column_name": "health_const", "data_type": "varchar", "column_desc": "Health planning guide construction (X/blank)", "intended_datatype": "boolean"}, {"column_name": "health_marit", "data_type": "varchar", "column_desc": "Health planning guide maritime (X/blank)", "intended_datatype": "boolean"}, {"column_name": "migrant", "data_type": "varchar", "column_desc": "Migrant labor inspection (X/blank)", "intended_datatype": "boolean"}, {"column_name": "mail_street", "data_type": "varchar", "column_desc": "Mailing address street", "intended_datatype": "text"}, {"column_name": "mail_city", "data_type": "varchar", "column_desc": "Mailing address city", "intended_datatype": "categorical"}, {"column_name": "mail_state", "data_type": "varchar", "column_desc": "Mailing address state postal abbreviation", "intended_datatype": "categorical"}, {"column_name": "mail_zip", "data_type": "varchar", "column_desc": "Mailing address postal zip code", "intended_datatype": "categorical"}, {"column_name": "host_est_key", "data_type": "varchar", "column_desc": "Internal establishment key", "intended_datatype": "identifier"}, {"column_name": "nr_in_estab", "data_type": "varchar", "column_desc": "Number of employees in establishment", "intended_datatype": "numeric"}, {"column_name": "open_date", "data_type": "date", "column_desc": "Indicates when the inspection was started.", "intended_datatype": "date"}, {"column_name": "case_mod_date", "data_type": "date", "column_desc": "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. case not affected by updating in April. 2004 or later will have zero in this field.", "intended_datatype": "date"}, {"column_name": "close_conf_date", "data_type": "date", "column_desc": "Closing conference date (yyyymmdd)", "intended_datatype": "date"}, {"column_name": "close_case_date", "data_type": "date", "column_desc": "Close date of inspection (yyyymmdd)", "intended_datatype": "date"}, {"column_name": "load_dt", "data_type": "timestamp_ntz", "column_desc": "Load Date Timestamp", "intended_datatype": "date"}], "tag_list": ["address", "industries", "inspection", "labor unions", "state"], "created_at": "2026-06-03T20:02:30", "updated_at": "2026-06-03T20:33:45"}}