{"dataset": {"id": 10338, "name": "Violation", "description": "This dataset provides details about violations and penalty assessments resulting from OSHA inspections, including the type and seriousness of the violations.\r\n\r\nAdditional records can be viewed and/or downloaded from OSHA\u2019s website at www.osha.gov/data.", "tablename": "OSHA_violation", "published_at": "2026-06-03T20:47:07", "dataset_type": 1, "agency_id": 10, "agency": {"name": "Occupational Safety and Health Administration", "abbr": "OSHA"}, "frequency": "Daily", "api_url": "violation", "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/violation/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/violation/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/violation/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/violation/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/violation/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/violation/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\": 304010994, \"citation_id\": \"01006D\", \"delete_flag\": null, \"standard\": \"19101030 G02   IIA\", \"viol_type\": \"O\", \"issuance_date\": \"2002-03-08T00:00:00\", \"abate_date\": \"2002-04-10T00:00:00\", \"abate_complete\": \"X\", \"current_penalty\": null, \"initial_penalty\": null, \"contest_date\": \"2002-03-25T00:00:00\", \"final_order_date\": \"2003-06-10T00:00:00\", \"nr_instances\": 1, \"nr_exposed\": 70, \"rec\": \"C\", \"gravity\": \"03\", \"emphasis\": null, \"hazcat\": null, \"fta_insp_nr\": null, \"fta_issuance_date\": null, \"fta_penalty\": null, \"fta_contest_date\": null, \"fta_final_order_date\": null, \"hazsub1\": null, \"hazsub2\": null, \"hazsub3\": null, \"hazsub4\": null, \"hazsub5\": null, \"load_dt\": \"2011-10-14T16:45:21\"}, {\"activity_nr\": 304011018, \"citation_id\": \"01001\", \"delete_flag\": null, \"standard\": \"19260451 B01\", \"viol_type\": \"S\", \"issuance_date\": \"2001-09-20T00:00:00\", \"abate_date\": \"2001-09-24T00:00:00\", \"abate_complete\": \"X\", \"current_penalty\": 450.0, \"initial_penalty\": 450.0, \"contest_date\": null, \"final_order_date\": null, \"nr_instances\": 1, \"nr_exposed\": 2, \"rec\": null, \"gravity\": \"02\", \"emphasis\": null, \"hazcat\": null, \"fta_insp_nr\": null, \"fta_issuance_date\": null, \"fta_penalty\": null, \"fta_contest_date\": null, \"fta_final_order_date\": null, \"hazsub1\": null, \"hazsub2\": null, \"hazsub3\": null, \"hazsub4\": null, \"hazsub5\": null, \"load_dt\": \"2011-10-14T16:45:21\"}, {\"activity_nr\": 304011018, \"citation_id\": \"01002\", \"delete_flag\": null, \"standard\": \"19260451 G01\", \"viol_type\": \"S\", \"issuance_date\": \"2001-09-20T00:00:00\", \"abate_date\": \"2001-09-24T00:00:00\", \"abate_complete\": \"X\", \"current_penalty\": 450.0, \"initial_penalty\": 450.0, \"contest_date\": null, \"final_order_date\": null, \"nr_instances\": 1, \"nr_exposed\": 2, \"rec\": null, \"gravity\": \"02\", \"emphasis\": null, \"hazcat\": null, \"fta_insp_nr\": null, \"fta_issuance_date\": null, \"fta_penalty\": null, \"fta_contest_date\": null, \"fta_final_order_date\": null, \"hazsub1\": null, \"hazsub2\": null, \"hazsub3\": null, \"hazsub4\": null, \"hazsub5\": null, \"load_dt\": \"2011-10-14T16:45:21\"}, {\"activity_nr\": 304011026, \"citation_id\": \"01001\", \"delete_flag\": null, \"standard\": \"19100132 D01\", \"viol_type\": \"S\", \"issuance_date\": \"2001-10-15T00:00:00\", \"abate_date\": \"2001-11-30T00:00:00\", \"abate_complete\": \"X\", \"current_penalty\": 600.0, \"initial_penalty\": 1250.0, \"contest_date\": null, \"final_order_date\": null, \"nr_instances\": 1, \"nr_exposed\": 38, \"rec\": \"C\", \"gravity\": \"03\", \"emphasis\": null, \"hazcat\": null, \"fta_insp_nr\": null, \"fta_issuance_date\": null, \"fta_penalty\": null, \"fta_contest_date\": null, \"fta_final_order_date\": null, \"hazsub1\": null, \"hazsub2\": null, \"hazsub3\": null, \"hazsub4\": null, \"hazsub5\": null, \"load_dt\": \"2011-10-14T16:45:21\"}, {\"activity_nr\": 304011026, \"citation_id\": \"01002\", \"delete_flag\": null, \"standard\": \"19100147 C04    I\", \"viol_type\": \"S\", \"issuance_date\": \"2001-10-15T00:00:00\", \"abate_date\": \"2001-11-30T00:00:00\", \"abate_complete\": \"X\", \"current_penalty\": 400.0, \"initial_penalty\": 1000.0, \"contest_date\": null, \"final_order_date\": null, \"nr_instances\": 1, \"nr_exposed\": 3, \"rec\": null, \"gravity\": \"02\", \"emphasis\": null, \"hazcat\": null, \"fta_insp_nr\": null, \"fta_issuance_date\": null, \"fta_penalty\": null, \"fta_contest_date\": null, \"fta_final_order_date\": null, \"hazsub1\": null, \"hazsub2\": null, \"hazsub3\": null, \"hazsub4\": null, \"hazsub5\": null, \"load_dt\": \"2011-10-14T16:45:21\"}, {\"activity_nr\": 304011026, \"citation_id\": \"01003\", \"delete_flag\": null, \"standard\": \"19100212 A01\", \"viol_type\": \"S\", \"issuance_date\": \"2001-10-15T00:00:00\", \"abate_date\": \"2002-12-31T00:00:00\", \"abate_complete\": \"X\", \"current_penalty\": 500.0, \"initial_penalty\": 1250.0, \"contest_date\": null, \"final_order_date\": null, \"nr_instances\": 6, \"nr_exposed\": 20, \"rec\": \"C\", \"gravity\": \"03\", \"emphasis\": null, \"hazcat\": null, \"fta_insp_nr\": null, \"fta_issuance_date\": null, \"fta_penalty\": null, \"fta_contest_date\": null, \"fta_final_order_date\": null, \"hazsub1\": null, \"hazsub2\": null, \"hazsub3\": null, \"hazsub4\": null, \"hazsub5\": null, \"load_dt\": \"2011-10-14T16:45:21\"}, {\"activity_nr\": 304011026, \"citation_id\": \"01004A\", \"delete_flag\": null, \"standard\": \"19100219 C03\", \"viol_type\": \"S\", \"issuance_date\": \"2001-10-15T00:00:00\", \"abate_date\": \"2001-11-17T00:00:00\", \"abate_complete\": \"X\", \"current_penalty\": 300.0, \"initial_penalty\": 750.0, \"contest_date\": null, \"final_order_date\": null, \"nr_instances\": 1, \"nr_exposed\": 4, \"rec\": null, \"gravity\": \"01\", \"emphasis\": null, \"hazcat\": null, \"fta_insp_nr\": null, \"fta_issuance_date\": null, \"fta_penalty\": null, \"fta_contest_date\": null, \"fta_final_order_date\": null, \"hazsub1\": null, \"hazsub2\": null, \"hazsub3\": null, \"hazsub4\": null, \"hazsub5\": null, \"load_dt\": \"2011-10-14T16:45:21\"}, {\"activity_nr\": 304011026, \"citation_id\": \"01004B\", \"delete_flag\": null, \"standard\": \"19100219 C04    I\", \"viol_type\": \"S\", \"issuance_date\": \"2001-10-15T00:00:00\", \"abate_date\": \"2001-11-17T00:00:00\", \"abate_complete\": \"X\", \"current_penalty\": null, \"initial_penalty\": null, \"contest_date\": null, \"final_order_date\": null, \"nr_instances\": 1, \"nr_exposed\": 5, \"rec\": null, \"gravity\": \"01\", \"emphasis\": null, \"hazcat\": null, \"fta_insp_nr\": null, \"fta_issuance_date\": null, \"fta_penalty\": null, \"fta_contest_date\": null, \"fta_final_order_date\": null, \"hazsub1\": null, \"hazsub2\": null, \"hazsub3\": null, \"hazsub4\": null, \"hazsub5\": null, \"load_dt\": \"2011-10-14T16:45:21\"}, {\"activity_nr\": 304011026, \"citation_id\": \"01005A\", \"delete_flag\": null, \"standard\": \"19100219 D01\", \"viol_type\": \"S\", \"issuance_date\": \"2001-10-15T00:00:00\", \"abate_date\": \"2001-12-15T00:00:00\", \"abate_complete\": \"X\", \"current_penalty\": 400.0, \"initial_penalty\": 1000.0, \"contest_date\": null, \"final_order_date\": null, \"nr_instances\": 6, \"nr_exposed\": 20, \"rec\": null, \"gravity\": \"02\", \"emphasis\": null, \"hazcat\": null, \"fta_insp_nr\": null, \"fta_issuance_date\": null, \"fta_penalty\": null, \"fta_contest_date\": null, \"fta_final_order_date\": null, \"hazsub1\": null, \"hazsub2\": null, \"hazsub3\": null, \"hazsub4\": null, \"hazsub5\": null, \"load_dt\": \"2011-10-14T16:45:21\"}, {\"activity_nr\": 304011026, \"citation_id\": \"01005B\", \"delete_flag\": null, \"standard\": \"19100219 E03    I\", \"viol_type\": \"S\", \"issuance_date\": \"2001-10-15T00:00:00\", \"abate_date\": \"2001-12-15T00:00:00\", \"abate_complete\": \"X\", \"current_penalty\": null, \"initial_penalty\": null, \"contest_date\": null, \"final_order_date\": null, \"nr_instances\": 6, \"nr_exposed\": 20, \"rec\": null, \"gravity\": \"02\", \"emphasis\": null, \"hazcat\": null, \"fta_insp_nr\": null, \"fta_issuance_date\": null, \"fta_penalty\": null, \"fta_contest_date\": null, \"fta_final_order_date\": null, \"hazsub1\": null, \"hazsub2\": null, \"hazsub3\": null, \"hazsub4\": null, \"hazsub5\": null, \"load_dt\": \"2011-10-14T16:45:21\"}]}", "dataset_metadatum": [{"column_name": "activity_nr", "data_type": "number", "column_desc": "Unique identifier for each inspection", "intended_datatype": "identifier"}, {"column_name": "citation_id", "data_type": "varchar", "column_desc": "Identifies the citation number. item number. and item group of the issued citation.", "intended_datatype": "identifier"}, {"column_name": "delete_flag", "data_type": "varchar", "column_desc": "Violation Deleted Indicator", "intended_datatype": "categorical"}, {"column_name": "standard", "data_type": "varchar", "column_desc": "OSHA Standard Cited", "intended_datatype": "text"}, {"column_name": "viol_type", "data_type": "varchar", "column_desc": "Violation Type", "intended_datatype": "categorical"}, {"column_name": "issuance_date", "data_type": "date", "column_desc": "Citation Issuance Date", "intended_datatype": "date"}, {"column_name": "abate_date", "data_type": "date", "column_desc": "Abatement Due Date", "intended_datatype": "date"}, {"column_name": "abate_complete", "data_type": "varchar", "column_desc": "Abatement Completion Code", "intended_datatype": "categorical"}, {"column_name": "current_penalty", "data_type": "varchar", "column_desc": "Current Penalty Amount", "intended_datatype": "currency"}, {"column_name": "initial_penalty", "data_type": "varchar", "column_desc": "Initial Penalty Amount", "intended_datatype": "currency"}, {"column_name": "contest_date", "data_type": "date", "column_desc": "Date Contested", "intended_datatype": "date"}, {"column_name": "final_order_date", "data_type": "date", "column_desc": "Final Order Date", "intended_datatype": "date"}, {"column_name": "nr_instances", "data_type": "number", "column_desc": "Number of Instances", "intended_datatype": "numeric"}, {"column_name": "nr_exposed", "data_type": "number", "column_desc": "Number of Employees Exposed", "intended_datatype": "numeric"}, {"column_name": "rec", "data_type": "varchar", "column_desc": "Related Event Code", "intended_datatype": "categorical"}, {"column_name": "gravity", "data_type": "varchar", "column_desc": "Level of Gravity for Serious Violations", "intended_datatype": "categorical"}, {"column_name": "emphasis", "data_type": "varchar", "column_desc": "Emphasis Program Indicator", "intended_datatype": "categorical"}, {"column_name": "hazcat", "data_type": "varchar", "column_desc": "General Industry Standard Hazard Category", "intended_datatype": "categorical"}, {"column_name": "fta_insp_nr", "data_type": "number", "column_desc": "Failure-To-Abate (FTA) Inspection Number", "intended_datatype": "identifier"}, {"column_name": "fta_issuance_date", "data_type": "date", "column_desc": "Failure-To-Abate (FTA) Issuance Date", "intended_datatype": "date"}, {"column_name": "fta_penalty", "data_type": "varchar", "column_desc": "Failure-To-Abate (FTA) Penalty Amount", "intended_datatype": "currency"}, {"column_name": "fta_contest_date", "data_type": "date", "column_desc": "Failure-To-Abate (FTA) Date Contested", "intended_datatype": "date"}, {"column_name": "fta_final_order_date", "data_type": "date", "column_desc": "Failure-To-Abate (FTA) Final Order Date", "intended_datatype": "date"}, {"column_name": "hazsub1", "data_type": "varchar", "column_desc": "Hazardous Substance Code 1", "intended_datatype": "categorical"}, {"column_name": "hazsub2", "data_type": "varchar", "column_desc": "Hazardous Substance Code 2", "intended_datatype": "categorical"}, {"column_name": "hazsub3", "data_type": "varchar", "column_desc": "Hazardous Substance Code 3", "intended_datatype": "categorical"}, {"column_name": "hazsub4", "data_type": "varchar", "column_desc": "Hazardous Substance Code 4", "intended_datatype": "categorical"}, {"column_name": "hazsub5", "data_type": "varchar", "column_desc": "Hazardous Substance Code 5", "intended_datatype": "categorical"}, {"column_name": "load_dt", "data_type": "timestamp_ntz", "column_desc": "The date the load was completed.", "intended_datatype": "date"}], "tag_list": ["abatements", "citations", "inspection", "penalties", "violations"], "created_at": "2026-06-03T20:20:42", "updated_at": "2026-06-03T20:48:44"}}