{"dataset": {"id": 10362, "name": "Enforcement", "description": "The dataset contains all concluded WHD compliance actions since FY 2005. The dataset includes whether any violations were found and the back wage amount, number of employees due back wages, and civil money penalties assessed.\r\n\r\nNOTE: Findings Start Date and Findings End Date are not equal to Case Open Date and Case Close Date, which are not included in the dataset.", "tablename": "WHD_enforcement", "published_at": "2026-06-04T00:40:23", "dataset_type": 1, "agency_id": 1, "agency": {"name": "Wage and Hour Division", "abbr": "WHD"}, "frequency": "Quarterly", "api_url": "enforcement", "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/WHD/enforcement/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/WHD/enforcement/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/WHD/enforcement/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/WHD/enforcement/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/WHD/enforcement/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/WHD/enforcement/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\": [{\"case_id\": 1428484, \"trade_nm\": \"Reliant Energy\", \"legal_name\": \"Reliant Energy Retail Services, LLC\", \"street_addr_1_txt\": \"1000 Main\", \"cty_nm\": \"Houston\", \"st_cd\": \"TX\", \"zip_cd\": \"77002\", \"naic_cd\": \"09310\", \"naics_code_description\": \"State Generation and Distribution of Electric Power\", \"case_violtn_cnt\": 0, \"cmp_assd\": 0.0, \"ee_violtd_cnt\": 1, \"bw_atp_amt\": 0.0, \"ee_atp_cnt\": 0, \"findings_start_date\": \"2005-06-20T00:00:00\", \"findings_end_date\": \"2005-07-19T00:00:00\", \"flsa_violtn_cnt\": 0, \"flsa_repeat_violator\": \"N/A\", \"flsa_bw_atp_amt\": 0.0, \"flsa_ee_atp_cnt\": 0, \"flsa_mw_bw_atp_amt\": 0.0, \"flsa_ot_bw_atp_amt\": 0.0, \"flsa_15a3_bw_atp_amt\": 0.0, \"flsa_cmp_assd_amt\": 0.0, \"sca_violtn_cnt\": 0, \"sca_bw_atp_amt\": 0.0, \"sca_ee_atp_cnt\": 0, \"mspa_violtn_cnt\": 0, \"mspa_bw_atp_amt\": 0.0, \"mspa_ee_atp_cnt\": 0, \"mspa_cmp_assd_amt\": 0.0, \"h1b_violtn_cnt\": 0, \"h1b_bw_atp_amt\": 0.0, \"h1b_ee_atp_cnt\": 0, \"h1b_cmp_assd_amt\": 0.0, \"fmla_violtn_cnt\": 0, \"fmla_bw_atp_amt\": 0.0, \"fmla_ee_atp_cnt\": 0, \"fmla_cmp_assd_amt\": 0.0, \"flsa_cl_violtn_cnt\": 0, \"flsa_cl_minor_cnt\": 0, \"flsa_cl_cmp_assd_amt\": 0.0, \"dbra_violtn_cnt\": 0, \"dbra_bw_atp_amt\": 0.0, \"dbra_ee_atp_cnt\": 0, \"h2a_violtn_cnt\": 0, \"h2a_bw_atp_amt\": 0.0, \"h2a_ee_atp_cnt\": 0, \"h2a_cmp_assd_amt\": 0.0, \"flsa_smw14_violtn_cnt\": 0, \"flsa_smw14_bw_amt\": 0.0, \"flsa_smw14_ee_atp_cnt\": 0, \"cwhssa_violtn_cnt\": 0, \"cwhssa_bw_amt\": 0.0, \"cwhssa_ee_cnt\": 0, \"osha_violtn_cnt\": 0, \"osha_bw_atp_amt\": 0.0, \"osha_ee_atp_cnt\": 0, \"osha_cmp_assd_amt\": 0.0, \"eppa_violtn_cnt\": 0, \"eppa_bw_atp_amt\": 0.0, \"eppa_ee_cnt\": 0, \"eppa_cmp_assd_amt\": 0.0, \"h1a_violtn_cnt\": 0, \"h1a_bw_atp_amt\": 0.0, \"h1a_ee_atp_cnt\": 0, \"h1a_cmp_assd_amt\": 0.0, \"crew_violtn_cnt\": 0, \"crew_bw_atp_amt\": 0.0, \"crew_ee_atp_cnt\": 0, \"crew_cmp_assd_amt\": 0.0, \"ccpa_violtn_cnt\": 0, \"ccpa_bw_atp_amt\": 0.0, \"ccpa_ee_atp_cnt\": 0, \"flsa_smwpw_violtn_cnt\": 0, \"flsa_smwpw_bw_atp_amt\": 0.0, \"flsa_smwpw_ee_atp_cnt\": 0, \"flsa_hmwkr_violtn_cnt\": 0, \"flsa_hmwkr_bw_atp_amt\": 0.0, \"flsa_hmwkr_ee_atp_cnt\": 0, \"flsa_hmwkr_cmp_assd_amt\": 0.0, \"ca_violtn_cnt\": 0, \"ca_bw_atp_amt\": 0.0, \"ca_ee_atp_cnt\": 0, \"pca_violtn_cnt\": 0, \"pca_bw_atp_amt\": 0.0, \"pca_ee_atp_cnt\": 0, \"flsa_smwap_violtn_cnt\": 0, \"flsa_smwap_bw_atp_amt\": 0.0, \"flsa_smwap_ee_atp_cnt\": 0, \"flsa_smwft_violtn_cnt\": 0, \"flsa_smwft_bw_atp_amt\": 0.0, \"flsa_smwft_ee_atp_cnt\": 0, \"flsa_smwl_violtn_cnt\": 0, \"flsa_smwl_bw_atp_amt\": 0.0, \"flsa_smwl_ee_atp_cnt\": 0, \"flsa_smwmg_violtn_cnt\": 0, \"flsa_smwmg_bw_atp_amt\": 0.0, \"flsa_smwmg_ee_atp_cnt\": 0, \"flsa_smwsl_violtn_cnt\": 0, \"flsa_smwsl_bw_atp_amt\": 0.0, \"flsa_smwsl_ee_atp_cnt\": 0, \"eev_violtn_cnt\": 0, \"h2b_violtn_cnt\": 0, \"h2b_bw_atp_amt\": 0.0, \"h2b_ee_atp_cnt\": 0, \"sraw_violtn_cnt\": 0, \"sraw_bw_atp_amt\": 0.0, \"sraw_ee_atp_cnt\": 0, \"load_dt\": \"2015-02-20T01:00:06\"}, {\"case_id\": 1784005, \"trade_nm\": \"Healthcare Services Group at Westwood Center\", \"legal_name\": \"Healthcare Services Group, Inc.\", \"street_addr_1_txt\": \"298 Main Street\", \"cty_nm\": \"Keene\", \"st_cd\": \"NH\", \"zip_cd\": \"03431\", \"naic_cd\": \"0967\", \"naics_code_description\": \"Local Nursing Homes\", \"case_violtn_cnt\": 1, \"cmp_assd\": 0.0, \"ee_violtd_cnt\": 0, \"bw_atp_amt\": 0.0, \"ee_atp_cnt\": 0, \"findings_start_date\": \"2014-02-07T00:00:00\", \"findings_end_date\": \"2016-02-06T00:00:00\", \"flsa_violtn_cnt\": 1, \"flsa_repeat_violator\": \"N/A\", \"flsa_bw_atp_amt\": 0.0, \"flsa_ee_atp_cnt\": 0, \"flsa_mw_bw_atp_amt\": 0.0, \"flsa_ot_bw_atp_amt\": 0.0, \"flsa_15a3_bw_atp_amt\": 0.0, \"flsa_cmp_assd_amt\": 0.0, \"sca_violtn_cnt\": 0, \"sca_bw_atp_amt\": 0.0, \"sca_ee_atp_cnt\": 0, \"mspa_violtn_cnt\": 0, \"mspa_bw_atp_amt\": 0.0, \"mspa_ee_atp_cnt\": 0, \"mspa_cmp_assd_amt\": 0.0, \"h1b_violtn_cnt\": 0, \"h1b_bw_atp_amt\": 0.0, \"h1b_ee_atp_cnt\": 0, \"h1b_cmp_assd_amt\": 0.0, \"fmla_violtn_cnt\": 0, \"fmla_bw_atp_amt\": 0.0, \"fmla_ee_atp_cnt\": 0, \"fmla_cmp_assd_amt\": 0.0, \"flsa_cl_violtn_cnt\": 0, \"flsa_cl_minor_cnt\": 0, \"flsa_cl_cmp_assd_amt\": 0.0, \"dbra_violtn_cnt\": 0, \"dbra_bw_atp_amt\": 0.0, \"dbra_ee_atp_cnt\": 0, \"h2a_violtn_cnt\": 0, \"h2a_bw_atp_amt\": 0.0, \"h2a_ee_atp_cnt\": 0, \"h2a_cmp_assd_amt\": 0.0, \"flsa_smw14_violtn_cnt\": 0, \"flsa_smw14_bw_amt\": 0.0, \"flsa_smw14_ee_atp_cnt\": 0, \"cwhssa_violtn_cnt\": 0, \"cwhssa_bw_amt\": 0.0, \"cwhssa_ee_cnt\": 0, \"osha_violtn_cnt\": 0, \"osha_bw_atp_amt\": 0.0, \"osha_ee_atp_cnt\": 0, \"osha_cmp_assd_amt\": 0.0, \"eppa_violtn_cnt\": 0, \"eppa_bw_atp_amt\": 0.0, \"eppa_ee_cnt\": 0, \"eppa_cmp_assd_amt\": 0.0, \"h1a_violtn_cnt\": 0, \"h1a_bw_atp_amt\": 0.0, \"h1a_ee_atp_cnt\": 0, \"h1a_cmp_assd_amt\": 0.0, \"crew_violtn_cnt\": 0, \"crew_bw_atp_amt\": 0.0, \"crew_ee_atp_cnt\": 0, \"crew_cmp_assd_amt\": 0.0, \"ccpa_violtn_cnt\": 0, \"ccpa_bw_atp_amt\": 0.0, \"ccpa_ee_atp_cnt\": 0, \"flsa_smwpw_violtn_cnt\": 0, \"flsa_smwpw_bw_atp_amt\": 0.0, \"flsa_smwpw_ee_atp_cnt\": 0, \"flsa_hmwkr_violtn_cnt\": 0, \"flsa_hmwkr_bw_atp_amt\": 0.0, \"flsa_hmwkr_ee_atp_cnt\": 0, \"flsa_hmwkr_cmp_assd_amt\": 0.0, \"ca_violtn_cnt\": 0, \"ca_bw_atp_amt\": 0.0, \"ca_ee_atp_cnt\": 0, \"pca_violtn_cnt\": 0, \"pca_bw_atp_amt\": 0.0, \"pca_ee_atp_cnt\": 0, \"flsa_smwap_violtn_cnt\": 0, \"flsa_smwap_bw_atp_amt\": 0.0, \"flsa_smwap_ee_atp_cnt\": 0, \"flsa_smwft_violtn_cnt\": 0, \"flsa_smwft_bw_atp_amt\": 0.0, \"flsa_smwft_ee_atp_cnt\": 0, \"flsa_smwl_violtn_cnt\": 0, \"flsa_smwl_bw_atp_amt\": 0.0, \"flsa_smwl_ee_atp_cnt\": 0, \"flsa_smwmg_violtn_cnt\": 0, \"flsa_smwmg_bw_atp_amt\": 0.0, \"flsa_smwmg_ee_atp_cnt\": 0, \"flsa_smwsl_violtn_cnt\": 0, \"flsa_smwsl_bw_atp_amt\": 0.0, \"flsa_smwsl_ee_atp_cnt\": 0, \"eev_violtn_cnt\": 0, \"h2b_violtn_cnt\": 0, \"h2b_bw_atp_amt\": 0.0, \"h2b_ee_atp_cnt\": 0, \"sraw_violtn_cnt\": 0, \"sraw_bw_atp_amt\": 0.0, \"sraw_ee_atp_cnt\": 0, \"load_dt\": \"2016-06-11T02:22:25\"}, {\"case_id\": 1460300, \"trade_nm\": \"Central Avenue Bakery\", \"legal_name\": \"Central Avenue Bakery, Inc.\", \"street_addr_1_txt\": \"679 Central Avenue\", \"cty_nm\": \"Pawtucket\", \"st_cd\": \"RI\", \"zip_cd\": \"02861\", \"naic_cd\": \"311811\", \"naics_code_description\": \"Retail Bakeries\", \"case_violtn_cnt\": 4, \"cmp_assd\": 0.0, \"ee_violtd_cnt\": 3, \"bw_atp_amt\": 12136.0, \"ee_atp_cnt\": 3, \"findings_start_date\": \"2004-11-20T00:00:00\", \"findings_end_date\": \"2006-11-18T00:00:00\", \"flsa_violtn_cnt\": 4, \"flsa_repeat_violator\": \"N/A\", \"flsa_bw_atp_amt\": 12136.0, \"flsa_ee_atp_cnt\": 3, \"flsa_mw_bw_atp_amt\": 0.0, \"flsa_ot_bw_atp_amt\": 12136.0, \"flsa_15a3_bw_atp_amt\": 0.0, \"flsa_cmp_assd_amt\": 0.0, \"sca_violtn_cnt\": 0, \"sca_bw_atp_amt\": 0.0, \"sca_ee_atp_cnt\": 0, \"mspa_violtn_cnt\": 0, \"mspa_bw_atp_amt\": 0.0, \"mspa_ee_atp_cnt\": 0, \"mspa_cmp_assd_amt\": 0.0, \"h1b_violtn_cnt\": 0, \"h1b_bw_atp_amt\": 0.0, \"h1b_ee_atp_cnt\": 0, \"h1b_cmp_assd_amt\": 0.0, \"fmla_violtn_cnt\": 0, \"fmla_bw_atp_amt\": 0.0, \"fmla_ee_atp_cnt\": 0, \"fmla_cmp_assd_amt\": 0.0, \"flsa_cl_violtn_cnt\": 0, \"flsa_cl_minor_cnt\": 0, \"flsa_cl_cmp_assd_amt\": 0.0, \"dbra_violtn_cnt\": 0, \"dbra_bw_atp_amt\": 0.0, \"dbra_ee_atp_cnt\": 0, \"h2a_violtn_cnt\": 0, \"h2a_bw_atp_amt\": 0.0, \"h2a_ee_atp_cnt\": 0, \"h2a_cmp_assd_amt\": 0.0, \"flsa_smw14_violtn_cnt\": 0, \"flsa_smw14_bw_amt\": 0.0, \"flsa_smw14_ee_atp_cnt\": 0, \"cwhssa_violtn_cnt\": 0, \"cwhssa_bw_amt\": 0.0, \"cwhssa_ee_cnt\": 0, \"osha_violtn_cnt\": 0, \"osha_bw_atp_amt\": 0.0, \"osha_ee_atp_cnt\": 0, \"osha_cmp_assd_amt\": 0.0, \"eppa_violtn_cnt\": 0, \"eppa_bw_atp_amt\": 0.0, \"eppa_ee_cnt\": 0, \"eppa_cmp_assd_amt\": 0.0, \"h1a_violtn_cnt\": 0, \"h1a_bw_atp_amt\": 0.0, \"h1a_ee_atp_cnt\": 0, \"h1a_cmp_assd_amt\": 0.0, \"crew_violtn_cnt\": 0, \"crew_bw_atp_amt\": 0.0, \"crew_ee_atp_cnt\": 0, \"crew_cmp_assd_amt\": 0.0, \"ccpa_violtn_cnt\": 0, \"ccpa_bw_atp_amt\": 0.0, \"ccpa_ee_atp_cnt\": 0, \"flsa_smwpw_violtn_cnt\": 0, \"flsa_smwpw_bw_atp_amt\": 0.0, \"flsa_smwpw_ee_atp_cnt\": 0, \"flsa_hmwkr_violtn_cnt\": 0, \"flsa_hmwkr_bw_atp_amt\": 0.0, \"flsa_hmwkr_ee_atp_cnt\": 0, \"flsa_hmwkr_cmp_assd_amt\": 0.0, \"ca_violtn_cnt\": 0, \"ca_bw_atp_amt\": 0.0, \"ca_ee_atp_cnt\": 0, \"pca_violtn_cnt\": 0, \"pca_bw_atp_amt\": 0.0, \"pca_ee_atp_cnt\": 0, \"flsa_smwap_violtn_cnt\": 0, \"flsa_smwap_bw_atp_amt\": 0.0, \"flsa_smwap_ee_atp_cnt\": 0, \"flsa_smwft_violtn_cnt\": 0, \"flsa_smwft_bw_atp_amt\": 0.0, \"flsa_smwft_ee_atp_cnt\": 0, \"flsa_smwl_violtn_cnt\": 0, \"flsa_smwl_bw_atp_amt\": 0.0, \"flsa_smwl_ee_atp_cnt\": 0, \"flsa_smwmg_violtn_cnt\": 0, \"flsa_smwmg_bw_atp_amt\": 0.0, \"flsa_smwmg_ee_atp_cnt\": 0, \"flsa_smwsl_violtn_cnt\": 0, \"flsa_smwsl_bw_atp_amt\": 0.0, \"flsa_smwsl_ee_atp_cnt\": 0, \"eev_violtn_cnt\": 0, \"h2b_violtn_cnt\": 0, \"h2b_bw_atp_amt\": 0.0, \"h2b_ee_atp_cnt\": 0, \"sraw_violtn_cnt\": 0, \"sraw_bw_atp_amt\": 0.0, \"sraw_ee_atp_cnt\": 0, \"load_dt\": \"2015-02-20T01:00:06\"}, {\"case_id\": 1294821, \"trade_nm\": \"Gallagher Services\", \"legal_name\": \"Catholic Cherities\", \"street_addr_1_txt\": \"2520 Pot Spring Road\", \"cty_nm\": \"Lutherville Timonium\", \"st_cd\": \"MD\", \"zip_cd\": \"21093\", \"naic_cd\": \"09690\", \"naics_code_description\": \"Local Group Homes for Mentally and Physically Handicapped\", \"case_violtn_cnt\": 0, \"cmp_assd\": 0.0, \"ee_violtd_cnt\": 1, \"bw_atp_amt\": 0.0, \"ee_atp_cnt\": 0, \"findings_start_date\": \"2002-11-01T00:00:00\", \"findings_end_date\": \"2004-10-22T00:00:00\", \"flsa_violtn_cnt\": 0, \"flsa_repeat_violator\": \"N/A\", \"flsa_bw_atp_amt\": 0.0, \"flsa_ee_atp_cnt\": 0, \"flsa_mw_bw_atp_amt\": 0.0, \"flsa_ot_bw_atp_amt\": 0.0, \"flsa_15a3_bw_atp_amt\": 0.0, \"flsa_cmp_assd_amt\": 0.0, \"sca_violtn_cnt\": 0, \"sca_bw_atp_amt\": 0.0, \"sca_ee_atp_cnt\": 0, \"mspa_violtn_cnt\": 0, \"mspa_bw_atp_amt\": 0.0, \"mspa_ee_atp_cnt\": 0, \"mspa_cmp_assd_amt\": 0.0, \"h1b_violtn_cnt\": 0, \"h1b_bw_atp_amt\": 0.0, \"h1b_ee_atp_cnt\": 0, \"h1b_cmp_assd_amt\": 0.0, \"fmla_violtn_cnt\": 0, \"fmla_bw_atp_amt\": 0.0, \"fmla_ee_atp_cnt\": 0, \"fmla_cmp_assd_amt\": 0.0, \"flsa_cl_violtn_cnt\": 0, \"flsa_cl_minor_cnt\": 0, \"flsa_cl_cmp_assd_amt\": 0.0, \"dbra_violtn_cnt\": 0, \"dbra_bw_atp_amt\": 0.0, \"dbra_ee_atp_cnt\": 0, \"h2a_violtn_cnt\": 0, \"h2a_bw_atp_amt\": 0.0, \"h2a_ee_atp_cnt\": 0, \"h2a_cmp_assd_amt\": 0.0, \"flsa_smw14_violtn_cnt\": 0, \"flsa_smw14_bw_amt\": 0.0, \"flsa_smw14_ee_atp_cnt\": 0, \"cwhssa_violtn_cnt\": 0, \"cwhssa_bw_amt\": 0.0, \"cwhssa_ee_cnt\": 0, \"osha_violtn_cnt\": 0, \"osha_bw_atp_amt\": 0.0, \"osha_ee_atp_cnt\": 0, \"osha_cmp_assd_amt\": 0.0, \"eppa_violtn_cnt\": 0, \"eppa_bw_atp_amt\": 0.0, \"eppa_ee_cnt\": 0, \"eppa_cmp_assd_amt\": 0.0, \"h1a_violtn_cnt\": 0, \"h1a_bw_atp_amt\": 0.0, \"h1a_ee_atp_cnt\": 0, \"h1a_cmp_assd_amt\": 0.0, \"crew_violtn_cnt\": 0, \"crew_bw_atp_amt\": 0.0, \"crew_ee_atp_cnt\": 0, \"crew_cmp_assd_amt\": 0.0, \"ccpa_violtn_cnt\": 0, \"ccpa_bw_atp_amt\": 0.0, \"ccpa_ee_atp_cnt\": 0, \"flsa_smwpw_violtn_cnt\": 0, \"flsa_smwpw_bw_atp_amt\": 0.0, \"flsa_smwpw_ee_atp_cnt\": 0, \"flsa_hmwkr_violtn_cnt\": 0, \"flsa_hmwkr_bw_atp_amt\": 0.0, \"flsa_hmwkr_ee_atp_cnt\": 0, \"flsa_hmwkr_cmp_assd_amt\": 0.0, \"ca_violtn_cnt\": 0, \"ca_bw_atp_amt\": 0.0, \"ca_ee_atp_cnt\": 0, \"pca_violtn_cnt\": 0, \"pca_bw_atp_amt\": 0.0, \"pca_ee_atp_cnt\": 0, \"flsa_smwap_violtn_cnt\": 0, \"flsa_smwap_bw_atp_amt\": 0.0, \"flsa_smwap_ee_atp_cnt\": 0, \"flsa_smwft_violtn_cnt\": 0, \"flsa_smwft_bw_atp_amt\": 0.0, \"flsa_smwft_ee_atp_cnt\": 0, \"flsa_smwl_violtn_cnt\": 0, \"flsa_smwl_bw_atp_amt\": 0.0, \"flsa_smwl_ee_atp_cnt\": 0, \"flsa_smwmg_violtn_cnt\": 0, \"flsa_smwmg_bw_atp_amt\": 0.0, \"flsa_smwmg_ee_atp_cnt\": 0, \"flsa_smwsl_violtn_cnt\": 0, \"flsa_smwsl_bw_atp_amt\": 0.0, \"flsa_smwsl_ee_atp_cnt\": 0, \"eev_violtn_cnt\": 0, \"h2b_violtn_cnt\": 0, \"h2b_bw_atp_amt\": 0.0, \"h2b_ee_atp_cnt\": 0, \"sraw_violtn_cnt\": 0, \"sraw_bw_atp_amt\": 0.0, \"sraw_ee_atp_cnt\": 0, \"load_dt\": \"2015-02-20T01:00:06\"}, {\"case_id\": 1437099, \"trade_nm\": \"Dragon Dynasty Oriental Mart\", \"legal_name\": null, \"street_addr_1_txt\": \"2299 South Ridgewood Avenue\", \"cty_nm\": \"Daytona Beach\", \"st_cd\": \"FL\", \"zip_cd\": \"32119\", \"naic_cd\": \"42449\", \"naics_code_description\": \"Other Grocery and Related Products Merchant Wholesalers\", \"case_violtn_cnt\": 0, \"cmp_assd\": 0.0, \"ee_violtd_cnt\": 0, \"bw_atp_amt\": 0.0, \"ee_atp_cnt\": 0, \"findings_start_date\": \"2004-03-22T00:00:00\", \"findings_end_date\": \"2006-03-22T00:00:00\", \"flsa_violtn_cnt\": 0, \"flsa_repeat_violator\": \"N/A\", \"flsa_bw_atp_amt\": 0.0, \"flsa_ee_atp_cnt\": 0, \"flsa_mw_bw_atp_amt\": 0.0, \"flsa_ot_bw_atp_amt\": 0.0, \"flsa_15a3_bw_atp_amt\": 0.0, \"flsa_cmp_assd_amt\": 0.0, \"sca_violtn_cnt\": 0, \"sca_bw_atp_amt\": 0.0, \"sca_ee_atp_cnt\": 0, \"mspa_violtn_cnt\": 0, \"mspa_bw_atp_amt\": 0.0, \"mspa_ee_atp_cnt\": 0, \"mspa_cmp_assd_amt\": 0.0, \"h1b_violtn_cnt\": 0, \"h1b_bw_atp_amt\": 0.0, \"h1b_ee_atp_cnt\": 0, \"h1b_cmp_assd_amt\": 0.0, \"fmla_violtn_cnt\": 0, \"fmla_bw_atp_amt\": 0.0, \"fmla_ee_atp_cnt\": 0, \"fmla_cmp_assd_amt\": 0.0, \"flsa_cl_violtn_cnt\": 0, \"flsa_cl_minor_cnt\": 0, \"flsa_cl_cmp_assd_amt\": 0.0, \"dbra_violtn_cnt\": 0, \"dbra_bw_atp_amt\": 0.0, \"dbra_ee_atp_cnt\": 0, \"h2a_violtn_cnt\": 0, \"h2a_bw_atp_amt\": 0.0, \"h2a_ee_atp_cnt\": 0, \"h2a_cmp_assd_amt\": 0.0, \"flsa_smw14_violtn_cnt\": 0, \"flsa_smw14_bw_amt\": 0.0, \"flsa_smw14_ee_atp_cnt\": 0, \"cwhssa_violtn_cnt\": 0, \"cwhssa_bw_amt\": 0.0, \"cwhssa_ee_cnt\": 0, \"osha_violtn_cnt\": 0, \"osha_bw_atp_amt\": 0.0, \"osha_ee_atp_cnt\": 0, \"osha_cmp_assd_amt\": 0.0, \"eppa_violtn_cnt\": 0, \"eppa_bw_atp_amt\": 0.0, \"eppa_ee_cnt\": 0, \"eppa_cmp_assd_amt\": 0.0, \"h1a_violtn_cnt\": 0, \"h1a_bw_atp_amt\": 0.0, \"h1a_ee_atp_cnt\": 0, \"h1a_cmp_assd_amt\": 0.0, \"crew_violtn_cnt\": 0, \"crew_bw_atp_amt\": 0.0, \"crew_ee_atp_cnt\": 0, \"crew_cmp_assd_amt\": 0.0, \"ccpa_violtn_cnt\": 0, \"ccpa_bw_atp_amt\": 0.0, \"ccpa_ee_atp_cnt\": 0, \"flsa_smwpw_violtn_cnt\": 0, \"flsa_smwpw_bw_atp_amt\": 0.0, \"flsa_smwpw_ee_atp_cnt\": 0, \"flsa_hmwkr_violtn_cnt\": 0, \"flsa_hmwkr_bw_atp_amt\": 0.0, \"flsa_hmwkr_ee_atp_cnt\": 0, \"flsa_hmwkr_cmp_assd_amt\": 0.0, \"ca_violtn_cnt\": 0, \"ca_bw_atp_amt\": 0.0, \"ca_ee_atp_cnt\": 0, \"pca_violtn_cnt\": 0, \"pca_bw_atp_amt\": 0.0, \"pca_ee_atp_cnt\": 0, \"flsa_smwap_violtn_cnt\": 0, \"flsa_smwap_bw_atp_amt\": 0.0, \"flsa_smwap_ee_atp_cnt\": 0, \"flsa_smwft_violtn_cnt\": 0, \"flsa_smwft_bw_atp_amt\": 0.0, \"flsa_smwft_ee_atp_cnt\": 0, \"flsa_smwl_violtn_cnt\": 0, \"flsa_smwl_bw_atp_amt\": 0.0, \"flsa_smwl_ee_atp_cnt\": 0, \"flsa_smwmg_violtn_cnt\": 0, \"flsa_smwmg_bw_atp_amt\": 0.0, \"flsa_smwmg_ee_atp_cnt\": 0, \"flsa_smwsl_violtn_cnt\": 0, \"flsa_smwsl_bw_atp_amt\": 0.0, \"flsa_smwsl_ee_atp_cnt\": 0, \"eev_violtn_cnt\": 0, \"h2b_violtn_cnt\": 0, \"h2b_bw_atp_amt\": 0.0, \"h2b_ee_atp_cnt\": 0, \"sraw_violtn_cnt\": 0, \"sraw_bw_atp_amt\": 0.0, \"sraw_ee_atp_cnt\": 0, \"load_dt\": \"2015-02-20T01:00:06\"}, {\"case_id\": 1437232, \"trade_nm\": \"Derrick Plumbing, Inc.\", \"legal_name\": \"Derrick Plumbing\", \"street_addr_1_txt\": \"2228 Ridge Road\", \"cty_nm\": \"Leesville\", \"st_cd\": \"SC\", \"zip_cd\": \"29070\", \"naic_cd\": \"238220\", \"naics_code_description\": \"Plumbing, Heating, and Air-Conditioning Contractors\", \"case_violtn_cnt\": 0, \"cmp_assd\": 0.0, \"ee_violtd_cnt\": 0, \"bw_atp_amt\": 0.0, \"ee_atp_cnt\": 0, \"findings_start_date\": \"2004-04-03T00:00:00\", \"findings_end_date\": \"2006-04-01T00:00:00\", \"flsa_violtn_cnt\": 0, \"flsa_repeat_violator\": \"N/A\", \"flsa_bw_atp_amt\": 0.0, \"flsa_ee_atp_cnt\": 0, \"flsa_mw_bw_atp_amt\": 0.0, \"flsa_ot_bw_atp_amt\": 0.0, \"flsa_15a3_bw_atp_amt\": 0.0, \"flsa_cmp_assd_amt\": 0.0, \"sca_violtn_cnt\": 0, \"sca_bw_atp_amt\": 0.0, \"sca_ee_atp_cnt\": 0, \"mspa_violtn_cnt\": 0, \"mspa_bw_atp_amt\": 0.0, \"mspa_ee_atp_cnt\": 0, \"mspa_cmp_assd_amt\": 0.0, \"h1b_violtn_cnt\": 0, \"h1b_bw_atp_amt\": 0.0, \"h1b_ee_atp_cnt\": 0, \"h1b_cmp_assd_amt\": 0.0, \"fmla_violtn_cnt\": 0, \"fmla_bw_atp_amt\": 0.0, \"fmla_ee_atp_cnt\": 0, \"fmla_cmp_assd_amt\": 0.0, \"flsa_cl_violtn_cnt\": 0, \"flsa_cl_minor_cnt\": 0, \"flsa_cl_cmp_assd_amt\": 0.0, \"dbra_violtn_cnt\": 0, \"dbra_bw_atp_amt\": 0.0, \"dbra_ee_atp_cnt\": 0, \"h2a_violtn_cnt\": 0, \"h2a_bw_atp_amt\": 0.0, \"h2a_ee_atp_cnt\": 0, \"h2a_cmp_assd_amt\": 0.0, \"flsa_smw14_violtn_cnt\": 0, \"flsa_smw14_bw_amt\": 0.0, \"flsa_smw14_ee_atp_cnt\": 0, \"cwhssa_violtn_cnt\": 0, \"cwhssa_bw_amt\": 0.0, \"cwhssa_ee_cnt\": 0, \"osha_violtn_cnt\": 0, \"osha_bw_atp_amt\": 0.0, \"osha_ee_atp_cnt\": 0, \"osha_cmp_assd_amt\": 0.0, \"eppa_violtn_cnt\": 0, \"eppa_bw_atp_amt\": 0.0, \"eppa_ee_cnt\": 0, \"eppa_cmp_assd_amt\": 0.0, \"h1a_violtn_cnt\": 0, \"h1a_bw_atp_amt\": 0.0, \"h1a_ee_atp_cnt\": 0, \"h1a_cmp_assd_amt\": 0.0, \"crew_violtn_cnt\": 0, \"crew_bw_atp_amt\": 0.0, \"crew_ee_atp_cnt\": 0, \"crew_cmp_assd_amt\": 0.0, \"ccpa_violtn_cnt\": 0, \"ccpa_bw_atp_amt\": 0.0, \"ccpa_ee_atp_cnt\": 0, \"flsa_smwpw_violtn_cnt\": 0, \"flsa_smwpw_bw_atp_amt\": 0.0, \"flsa_smwpw_ee_atp_cnt\": 0, \"flsa_hmwkr_violtn_cnt\": 0, \"flsa_hmwkr_bw_atp_amt\": 0.0, \"flsa_hmwkr_ee_atp_cnt\": 0, \"flsa_hmwkr_cmp_assd_amt\": 0.0, \"ca_violtn_cnt\": 0, \"ca_bw_atp_amt\": 0.0, \"ca_ee_atp_cnt\": 0, \"pca_violtn_cnt\": 0, \"pca_bw_atp_amt\": 0.0, \"pca_ee_atp_cnt\": 0, \"flsa_smwap_violtn_cnt\": 0, \"flsa_smwap_bw_atp_amt\": 0.0, \"flsa_smwap_ee_atp_cnt\": 0, \"flsa_smwft_violtn_cnt\": 0, \"flsa_smwft_bw_atp_amt\": 0.0, \"flsa_smwft_ee_atp_cnt\": 0, \"flsa_smwl_violtn_cnt\": 0, \"flsa_smwl_bw_atp_amt\": 0.0, \"flsa_smwl_ee_atp_cnt\": 0, \"flsa_smwmg_violtn_cnt\": 0, \"flsa_smwmg_bw_atp_amt\": 0.0, \"flsa_smwmg_ee_atp_cnt\": 0, \"flsa_smwsl_violtn_cnt\": 0, \"flsa_smwsl_bw_atp_amt\": 0.0, \"flsa_smwsl_ee_atp_cnt\": 0, \"eev_violtn_cnt\": 0, \"h2b_violtn_cnt\": 0, \"h2b_bw_atp_amt\": 0.0, \"h2b_ee_atp_cnt\": 0, \"sraw_violtn_cnt\": 0, \"sraw_bw_atp_amt\": 0.0, \"sraw_ee_atp_cnt\": 0, \"load_dt\": \"2015-02-20T01:00:06\"}, {\"case_id\": 1438534, \"trade_nm\": \"China Star Super Buffet\", \"legal_name\": \"China Star of Wichita, Inc.\", \"street_addr_1_txt\": \"5825 W. Central\", \"cty_nm\": \"Wichita\", \"st_cd\": \"KS\", \"zip_cd\": \"67212\", \"naic_cd\": \"722211\", \"naics_code_description\": \"Limited-Service Restaurants\", \"case_violtn_cnt\": 1, \"cmp_assd\": 0.0, \"ee_violtd_cnt\": 0, \"bw_atp_amt\": 0.0, \"ee_atp_cnt\": 0, \"findings_start_date\": \"2004-04-03T00:00:00\", \"findings_end_date\": \"2006-03-31T00:00:00\", \"flsa_violtn_cnt\": 1, \"flsa_repeat_violator\": \"N/A\", \"flsa_bw_atp_amt\": 0.0, \"flsa_ee_atp_cnt\": 0, \"flsa_mw_bw_atp_amt\": 0.0, \"flsa_ot_bw_atp_amt\": 0.0, \"flsa_15a3_bw_atp_amt\": 0.0, \"flsa_cmp_assd_amt\": 0.0, \"sca_violtn_cnt\": 0, \"sca_bw_atp_amt\": 0.0, \"sca_ee_atp_cnt\": 0, \"mspa_violtn_cnt\": 0, \"mspa_bw_atp_amt\": 0.0, \"mspa_ee_atp_cnt\": 0, \"mspa_cmp_assd_amt\": 0.0, \"h1b_violtn_cnt\": 0, \"h1b_bw_atp_amt\": 0.0, \"h1b_ee_atp_cnt\": 0, \"h1b_cmp_assd_amt\": 0.0, \"fmla_violtn_cnt\": 0, \"fmla_bw_atp_amt\": 0.0, \"fmla_ee_atp_cnt\": 0, \"fmla_cmp_assd_amt\": 0.0, \"flsa_cl_violtn_cnt\": 0, \"flsa_cl_minor_cnt\": 0, \"flsa_cl_cmp_assd_amt\": 0.0, \"dbra_violtn_cnt\": 0, \"dbra_bw_atp_amt\": 0.0, \"dbra_ee_atp_cnt\": 0, \"h2a_violtn_cnt\": 0, \"h2a_bw_atp_amt\": 0.0, \"h2a_ee_atp_cnt\": 0, \"h2a_cmp_assd_amt\": 0.0, \"flsa_smw14_violtn_cnt\": 0, \"flsa_smw14_bw_amt\": 0.0, \"flsa_smw14_ee_atp_cnt\": 0, \"cwhssa_violtn_cnt\": 0, \"cwhssa_bw_amt\": 0.0, \"cwhssa_ee_cnt\": 0, \"osha_violtn_cnt\": 0, \"osha_bw_atp_amt\": 0.0, \"osha_ee_atp_cnt\": 0, \"osha_cmp_assd_amt\": 0.0, \"eppa_violtn_cnt\": 0, \"eppa_bw_atp_amt\": 0.0, \"eppa_ee_cnt\": 0, \"eppa_cmp_assd_amt\": 0.0, \"h1a_violtn_cnt\": 0, \"h1a_bw_atp_amt\": 0.0, \"h1a_ee_atp_cnt\": 0, \"h1a_cmp_assd_amt\": 0.0, \"crew_violtn_cnt\": 0, \"crew_bw_atp_amt\": 0.0, \"crew_ee_atp_cnt\": 0, \"crew_cmp_assd_amt\": 0.0, \"ccpa_violtn_cnt\": 0, \"ccpa_bw_atp_amt\": 0.0, \"ccpa_ee_atp_cnt\": 0, \"flsa_smwpw_violtn_cnt\": 0, \"flsa_smwpw_bw_atp_amt\": 0.0, \"flsa_smwpw_ee_atp_cnt\": 0, \"flsa_hmwkr_violtn_cnt\": 0, \"flsa_hmwkr_bw_atp_amt\": 0.0, \"flsa_hmwkr_ee_atp_cnt\": 0, \"flsa_hmwkr_cmp_assd_amt\": 0.0, \"ca_violtn_cnt\": 0, \"ca_bw_atp_amt\": 0.0, \"ca_ee_atp_cnt\": 0, \"pca_violtn_cnt\": 0, \"pca_bw_atp_amt\": 0.0, \"pca_ee_atp_cnt\": 0, \"flsa_smwap_violtn_cnt\": 0, \"flsa_smwap_bw_atp_amt\": 0.0, \"flsa_smwap_ee_atp_cnt\": 0, \"flsa_smwft_violtn_cnt\": 0, \"flsa_smwft_bw_atp_amt\": 0.0, \"flsa_smwft_ee_atp_cnt\": 0, \"flsa_smwl_violtn_cnt\": 0, \"flsa_smwl_bw_atp_amt\": 0.0, \"flsa_smwl_ee_atp_cnt\": 0, \"flsa_smwmg_violtn_cnt\": 0, \"flsa_smwmg_bw_atp_amt\": 0.0, \"flsa_smwmg_ee_atp_cnt\": 0, \"flsa_smwsl_violtn_cnt\": 0, \"flsa_smwsl_bw_atp_amt\": 0.0, \"flsa_smwsl_ee_atp_cnt\": 0, \"eev_violtn_cnt\": 0, \"h2b_violtn_cnt\": 0, \"h2b_bw_atp_amt\": 0.0, \"h2b_ee_atp_cnt\": 0, \"sraw_violtn_cnt\": 0, \"sraw_bw_atp_amt\": 0.0, \"sraw_ee_atp_cnt\": 0, \"load_dt\": \"2015-02-20T01:00:06\"}, {\"case_id\": 1438543, \"trade_nm\": \"Nancy Fuller Childrens University, The\", \"legal_name\": \"Nancy Fuller Childrens University, The\", \"street_addr_1_txt\": \"12018 Charlton Rd.\", \"cty_nm\": \"Madera\", \"st_cd\": \"CA\", \"zip_cd\": \"93638\", \"naic_cd\": \"624410\", \"naics_code_description\": \"Child Day Care Services\", \"case_violtn_cnt\": 5, \"cmp_assd\": 0.0, \"ee_violtd_cnt\": 4, \"bw_atp_amt\": 601.0, \"ee_atp_cnt\": 4, \"findings_start_date\": \"2004-03-29T00:00:00\", \"findings_end_date\": \"2006-03-28T00:00:00\", \"flsa_violtn_cnt\": 5, \"flsa_repeat_violator\": \"N/A\", \"flsa_bw_atp_amt\": 601.0, \"flsa_ee_atp_cnt\": 4, \"flsa_mw_bw_atp_amt\": 0.0, \"flsa_ot_bw_atp_amt\": 601.0, \"flsa_15a3_bw_atp_amt\": 0.0, \"flsa_cmp_assd_amt\": 0.0, \"sca_violtn_cnt\": 0, \"sca_bw_atp_amt\": 0.0, \"sca_ee_atp_cnt\": 0, \"mspa_violtn_cnt\": 0, \"mspa_bw_atp_amt\": 0.0, \"mspa_ee_atp_cnt\": 0, \"mspa_cmp_assd_amt\": 0.0, \"h1b_violtn_cnt\": 0, \"h1b_bw_atp_amt\": 0.0, \"h1b_ee_atp_cnt\": 0, \"h1b_cmp_assd_amt\": 0.0, \"fmla_violtn_cnt\": 0, \"fmla_bw_atp_amt\": 0.0, \"fmla_ee_atp_cnt\": 0, \"fmla_cmp_assd_amt\": 0.0, \"flsa_cl_violtn_cnt\": 0, \"flsa_cl_minor_cnt\": 0, \"flsa_cl_cmp_assd_amt\": 0.0, \"dbra_violtn_cnt\": 0, \"dbra_bw_atp_amt\": 0.0, \"dbra_ee_atp_cnt\": 0, \"h2a_violtn_cnt\": 0, \"h2a_bw_atp_amt\": 0.0, \"h2a_ee_atp_cnt\": 0, \"h2a_cmp_assd_amt\": 0.0, \"flsa_smw14_violtn_cnt\": 0, \"flsa_smw14_bw_amt\": 0.0, \"flsa_smw14_ee_atp_cnt\": 0, \"cwhssa_violtn_cnt\": 0, \"cwhssa_bw_amt\": 0.0, \"cwhssa_ee_cnt\": 0, \"osha_violtn_cnt\": 0, \"osha_bw_atp_amt\": 0.0, \"osha_ee_atp_cnt\": 0, \"osha_cmp_assd_amt\": 0.0, \"eppa_violtn_cnt\": 0, \"eppa_bw_atp_amt\": 0.0, \"eppa_ee_cnt\": 0, \"eppa_cmp_assd_amt\": 0.0, \"h1a_violtn_cnt\": 0, \"h1a_bw_atp_amt\": 0.0, \"h1a_ee_atp_cnt\": 0, \"h1a_cmp_assd_amt\": 0.0, \"crew_violtn_cnt\": 0, \"crew_bw_atp_amt\": 0.0, \"crew_ee_atp_cnt\": 0, \"crew_cmp_assd_amt\": 0.0, \"ccpa_violtn_cnt\": 0, \"ccpa_bw_atp_amt\": 0.0, \"ccpa_ee_atp_cnt\": 0, \"flsa_smwpw_violtn_cnt\": 0, \"flsa_smwpw_bw_atp_amt\": 0.0, \"flsa_smwpw_ee_atp_cnt\": 0, \"flsa_hmwkr_violtn_cnt\": 0, \"flsa_hmwkr_bw_atp_amt\": 0.0, \"flsa_hmwkr_ee_atp_cnt\": 0, \"flsa_hmwkr_cmp_assd_amt\": 0.0, \"ca_violtn_cnt\": 0, \"ca_bw_atp_amt\": 0.0, \"ca_ee_atp_cnt\": 0, \"pca_violtn_cnt\": 0, \"pca_bw_atp_amt\": 0.0, \"pca_ee_atp_cnt\": 0, \"flsa_smwap_violtn_cnt\": 0, \"flsa_smwap_bw_atp_amt\": 0.0, \"flsa_smwap_ee_atp_cnt\": 0, \"flsa_smwft_violtn_cnt\": 0, \"flsa_smwft_bw_atp_amt\": 0.0, \"flsa_smwft_ee_atp_cnt\": 0, \"flsa_smwl_violtn_cnt\": 0, \"flsa_smwl_bw_atp_amt\": 0.0, \"flsa_smwl_ee_atp_cnt\": 0, \"flsa_smwmg_violtn_cnt\": 0, \"flsa_smwmg_bw_atp_amt\": 0.0, \"flsa_smwmg_ee_atp_cnt\": 0, \"flsa_smwsl_violtn_cnt\": 0, \"flsa_smwsl_bw_atp_amt\": 0.0, \"flsa_smwsl_ee_atp_cnt\": 0, \"eev_violtn_cnt\": 0, \"h2b_violtn_cnt\": 0, \"h2b_bw_atp_amt\": 0.0, \"h2b_ee_atp_cnt\": 0, \"sraw_violtn_cnt\": 0, \"sraw_bw_atp_amt\": 0.0, \"sraw_ee_atp_cnt\": 0, \"load_dt\": \"2015-02-20T01:00:06\"}, {\"case_id\": 1475069, \"trade_nm\": \"Mr. Q's Enterprises.\", \"legal_name\": \"Mr. Q's Inc.\", \"street_addr_1_txt\": \"255 West Wilcox Street\", \"cty_nm\": \"Sierra Vista\", \"st_cd\": \"AZ\", \"zip_cd\": \"85635\", \"naic_cd\": \"722310\", \"naics_code_description\": \"Food Service Contractors\", \"case_violtn_cnt\": 174, \"cmp_assd\": 0.0, \"ee_violtd_cnt\": 173, \"bw_atp_amt\": 186357.0, \"ee_atp_cnt\": 171, \"findings_start_date\": \"2006-11-01T00:00:00\", \"findings_end_date\": \"2007-04-30T00:00:00\", \"flsa_violtn_cnt\": 0, \"flsa_repeat_violator\": \"N/A\", \"flsa_bw_atp_amt\": 0.0, \"flsa_ee_atp_cnt\": 0, \"flsa_mw_bw_atp_amt\": 0.0, \"flsa_ot_bw_atp_amt\": 0.0, \"flsa_15a3_bw_atp_amt\": 0.0, \"flsa_cmp_assd_amt\": 0.0, \"sca_violtn_cnt\": 174, \"sca_bw_atp_amt\": 186357.0, \"sca_ee_atp_cnt\": 171, \"mspa_violtn_cnt\": 0, \"mspa_bw_atp_amt\": 0.0, \"mspa_ee_atp_cnt\": 0, \"mspa_cmp_assd_amt\": 0.0, \"h1b_violtn_cnt\": 0, \"h1b_bw_atp_amt\": 0.0, \"h1b_ee_atp_cnt\": 0, \"h1b_cmp_assd_amt\": 0.0, \"fmla_violtn_cnt\": 0, \"fmla_bw_atp_amt\": 0.0, \"fmla_ee_atp_cnt\": 0, \"fmla_cmp_assd_amt\": 0.0, \"flsa_cl_violtn_cnt\": 0, \"flsa_cl_minor_cnt\": 0, \"flsa_cl_cmp_assd_amt\": 0.0, \"dbra_violtn_cnt\": 0, \"dbra_bw_atp_amt\": 0.0, \"dbra_ee_atp_cnt\": 0, \"h2a_violtn_cnt\": 0, \"h2a_bw_atp_amt\": 0.0, \"h2a_ee_atp_cnt\": 0, \"h2a_cmp_assd_amt\": 0.0, \"flsa_smw14_violtn_cnt\": 0, \"flsa_smw14_bw_amt\": 0.0, \"flsa_smw14_ee_atp_cnt\": 0, \"cwhssa_violtn_cnt\": 0, \"cwhssa_bw_amt\": 0.0, \"cwhssa_ee_cnt\": 0, \"osha_violtn_cnt\": 0, \"osha_bw_atp_amt\": 0.0, \"osha_ee_atp_cnt\": 0, \"osha_cmp_assd_amt\": 0.0, \"eppa_violtn_cnt\": 0, \"eppa_bw_atp_amt\": 0.0, \"eppa_ee_cnt\": 0, \"eppa_cmp_assd_amt\": 0.0, \"h1a_violtn_cnt\": 0, \"h1a_bw_atp_amt\": 0.0, \"h1a_ee_atp_cnt\": 0, \"h1a_cmp_assd_amt\": 0.0, \"crew_violtn_cnt\": 0, \"crew_bw_atp_amt\": 0.0, \"crew_ee_atp_cnt\": 0, \"crew_cmp_assd_amt\": 0.0, \"ccpa_violtn_cnt\": 0, \"ccpa_bw_atp_amt\": 0.0, \"ccpa_ee_atp_cnt\": 0, \"flsa_smwpw_violtn_cnt\": 0, \"flsa_smwpw_bw_atp_amt\": 0.0, \"flsa_smwpw_ee_atp_cnt\": 0, \"flsa_hmwkr_violtn_cnt\": 0, \"flsa_hmwkr_bw_atp_amt\": 0.0, \"flsa_hmwkr_ee_atp_cnt\": 0, \"flsa_hmwkr_cmp_assd_amt\": 0.0, \"ca_violtn_cnt\": 0, \"ca_bw_atp_amt\": 0.0, \"ca_ee_atp_cnt\": 0, \"pca_violtn_cnt\": 0, \"pca_bw_atp_amt\": 0.0, \"pca_ee_atp_cnt\": 0, \"flsa_smwap_violtn_cnt\": 0, \"flsa_smwap_bw_atp_amt\": 0.0, \"flsa_smwap_ee_atp_cnt\": 0, \"flsa_smwft_violtn_cnt\": 0, \"flsa_smwft_bw_atp_amt\": 0.0, \"flsa_smwft_ee_atp_cnt\": 0, \"flsa_smwl_violtn_cnt\": 0, \"flsa_smwl_bw_atp_amt\": 0.0, \"flsa_smwl_ee_atp_cnt\": 0, \"flsa_smwmg_violtn_cnt\": 0, \"flsa_smwmg_bw_atp_amt\": 0.0, \"flsa_smwmg_ee_atp_cnt\": 0, \"flsa_smwsl_violtn_cnt\": 0, \"flsa_smwsl_bw_atp_amt\": 0.0, \"flsa_smwsl_ee_atp_cnt\": 0, \"eev_violtn_cnt\": 0, \"h2b_violtn_cnt\": 0, \"h2b_bw_atp_amt\": 0.0, \"h2b_ee_atp_cnt\": 0, \"sraw_violtn_cnt\": 0, \"sraw_bw_atp_amt\": 0.0, \"sraw_ee_atp_cnt\": 0, \"load_dt\": \"2015-02-20T01:00:06\"}, {\"case_id\": 1438544, \"trade_nm\": \"Quiznos\", \"legal_name\": \"Suckow Enterprises LLC d/b/a\", \"street_addr_1_txt\": \"1601 Marketplace Drive\", \"cty_nm\": \"Great Falls\", \"st_cd\": \"MT\", \"zip_cd\": \"59404\", \"naic_cd\": \"722211\", \"naics_code_description\": \"Limited-Service Restaurants\", \"case_violtn_cnt\": 1, \"cmp_assd\": 0.0, \"ee_violtd_cnt\": 1, \"bw_atp_amt\": 43.0, \"ee_atp_cnt\": 1, \"findings_start_date\": \"2004-03-16T00:00:00\", \"findings_end_date\": \"2006-03-15T00:00:00\", \"flsa_violtn_cnt\": 1, \"flsa_repeat_violator\": \"N/A\", \"flsa_bw_atp_amt\": 43.0, \"flsa_ee_atp_cnt\": 1, \"flsa_mw_bw_atp_amt\": 0.0, \"flsa_ot_bw_atp_amt\": 43.0, \"flsa_15a3_bw_atp_amt\": 0.0, \"flsa_cmp_assd_amt\": 0.0, \"sca_violtn_cnt\": 0, \"sca_bw_atp_amt\": 0.0, \"sca_ee_atp_cnt\": 0, \"mspa_violtn_cnt\": 0, \"mspa_bw_atp_amt\": 0.0, \"mspa_ee_atp_cnt\": 0, \"mspa_cmp_assd_amt\": 0.0, \"h1b_violtn_cnt\": 0, \"h1b_bw_atp_amt\": 0.0, \"h1b_ee_atp_cnt\": 0, \"h1b_cmp_assd_amt\": 0.0, \"fmla_violtn_cnt\": 0, \"fmla_bw_atp_amt\": 0.0, \"fmla_ee_atp_cnt\": 0, \"fmla_cmp_assd_amt\": 0.0, \"flsa_cl_violtn_cnt\": 0, \"flsa_cl_minor_cnt\": 0, \"flsa_cl_cmp_assd_amt\": 0.0, \"dbra_violtn_cnt\": 0, \"dbra_bw_atp_amt\": 0.0, \"dbra_ee_atp_cnt\": 0, \"h2a_violtn_cnt\": 0, \"h2a_bw_atp_amt\": 0.0, \"h2a_ee_atp_cnt\": 0, \"h2a_cmp_assd_amt\": 0.0, \"flsa_smw14_violtn_cnt\": 0, \"flsa_smw14_bw_amt\": 0.0, \"flsa_smw14_ee_atp_cnt\": 0, \"cwhssa_violtn_cnt\": 0, \"cwhssa_bw_amt\": 0.0, \"cwhssa_ee_cnt\": 0, \"osha_violtn_cnt\": 0, \"osha_bw_atp_amt\": 0.0, \"osha_ee_atp_cnt\": 0, \"osha_cmp_assd_amt\": 0.0, \"eppa_violtn_cnt\": 0, \"eppa_bw_atp_amt\": 0.0, \"eppa_ee_cnt\": 0, \"eppa_cmp_assd_amt\": 0.0, \"h1a_violtn_cnt\": 0, \"h1a_bw_atp_amt\": 0.0, \"h1a_ee_atp_cnt\": 0, \"h1a_cmp_assd_amt\": 0.0, \"crew_violtn_cnt\": 0, \"crew_bw_atp_amt\": 0.0, \"crew_ee_atp_cnt\": 0, \"crew_cmp_assd_amt\": 0.0, \"ccpa_violtn_cnt\": 0, \"ccpa_bw_atp_amt\": 0.0, \"ccpa_ee_atp_cnt\": 0, \"flsa_smwpw_violtn_cnt\": 0, \"flsa_smwpw_bw_atp_amt\": 0.0, \"flsa_smwpw_ee_atp_cnt\": 0, \"flsa_hmwkr_violtn_cnt\": 0, \"flsa_hmwkr_bw_atp_amt\": 0.0, \"flsa_hmwkr_ee_atp_cnt\": 0, \"flsa_hmwkr_cmp_assd_amt\": 0.0, \"ca_violtn_cnt\": 0, \"ca_bw_atp_amt\": 0.0, \"ca_ee_atp_cnt\": 0, \"pca_violtn_cnt\": 0, \"pca_bw_atp_amt\": 0.0, \"pca_ee_atp_cnt\": 0, \"flsa_smwap_violtn_cnt\": 0, \"flsa_smwap_bw_atp_amt\": 0.0, \"flsa_smwap_ee_atp_cnt\": 0, \"flsa_smwft_violtn_cnt\": 0, \"flsa_smwft_bw_atp_amt\": 0.0, \"flsa_smwft_ee_atp_cnt\": 0, \"flsa_smwl_violtn_cnt\": 0, \"flsa_smwl_bw_atp_amt\": 0.0, \"flsa_smwl_ee_atp_cnt\": 0, \"flsa_smwmg_violtn_cnt\": 0, \"flsa_smwmg_bw_atp_amt\": 0.0, \"flsa_smwmg_ee_atp_cnt\": 0, \"flsa_smwsl_violtn_cnt\": 0, \"flsa_smwsl_bw_atp_amt\": 0.0, \"flsa_smwsl_ee_atp_cnt\": 0, \"eev_violtn_cnt\": 0, \"h2b_violtn_cnt\": 0, \"h2b_bw_atp_amt\": 0.0, \"h2b_ee_atp_cnt\": 0, \"sraw_violtn_cnt\": 0, \"sraw_bw_atp_amt\": 0.0, \"sraw_ee_atp_cnt\": 0, \"load_dt\": \"2015-02-20T01:00:06\"}]}", "dataset_metadatum": [{"column_name": "case_id", "data_type": "number", "column_desc": "Unique Case Identifier", "intended_datatype": "numeric"}, {"column_name": "trade_nm", "data_type": "varchar", "column_desc": "Employer Name", "intended_datatype": "text"}, {"column_name": "legal_name", "data_type": "varchar", "column_desc": "Employer Legal Name.", "intended_datatype": "text"}, {"column_name": "street_addr_1_txt", "data_type": "varchar", "column_desc": "The street address", "intended_datatype": "text"}, {"column_name": "cty_nm", "data_type": "varchar", "column_desc": "Employer City", "intended_datatype": "categorical"}, {"column_name": "st_cd", "data_type": "varchar", "column_desc": "Employer State", "intended_datatype": "categorical"}, {"column_name": "zip_cd", "data_type": "varchar", "column_desc": "Employer Zip Code", "intended_datatype": "categorical"}, {"column_name": "naic_cd", "data_type": "varchar", "column_desc": "Industry Code", "intended_datatype": "categorical"}, {"column_name": "naics_code_description", "data_type": "varchar", "column_desc": "Industry Code Description.", "intended_datatype": "categorical"}, {"column_name": "case_violtn_cnt", "data_type": "number", "column_desc": "Total case violations. Note: A change in data collection procedures occurred on 10/01/2025. The number of violations for compliance actions loaded into the dataset after this date are not directly comparable with the number of violations for compliance actions loaded into the dataset before this date.", "intended_datatype": "numeric"}, {"column_name": "cmp_assd", "data_type": "number", "column_desc": "Total CMP (Civil Monetary Penalties) assessments", "intended_datatype": "currency"}, {"column_name": "ee_violtd_cnt", "data_type": "number", "column_desc": "Total EE's employed in Violation", "intended_datatype": "numeric"}, {"column_name": "bw_atp_amt", "data_type": "number", "column_desc": "Total Backwages Agreed To Pay", "intended_datatype": "currency"}, {"column_name": "ee_atp_cnt", "data_type": "number", "column_desc": "Total Employees Agreed to Pay", "intended_datatype": "numeric"}, {"column_name": "findings_start_date", "data_type": "date", "column_desc": "The date where WHD determined that findings first occurred. Findings are defined as either a Violation or No Violation found. NOTE: Findings Start Date is not equal to Case Open Date which is not included in the dataset.", "intended_datatype": "date"}, {"column_name": "findings_end_date", "data_type": "date", "column_desc": "The date where WHD determined that findings last occurred. Findings are defined as either a Violation or No Violation found. NOTE: Findings End Date is not equal to Case Close Date which is not included in the dataset.", "intended_datatype": "date"}, {"column_name": "flsa_violtn_cnt", "data_type": "number", "column_desc": "Violations found under FLSA (Fair Labor Standards Act). Note: A change in data collection procedures occurred on 10/01/2025. The number of violations for compliance actions loaded into the dataset after this date are not directly comparable with the number of violations for compliance actions loaded into the dataset before this date.", "intended_datatype": "numeric"}, {"column_name": "flsa_repeat_violator", "data_type": "varchar", "column_desc": "FLSA Repeat/Willful violator. R=Repeat; W=Willful; RW=Repeat and Willful.", "intended_datatype": "categorical"}, {"column_name": "flsa_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under FLSA (Fair Labor Standards Act)", "intended_datatype": "currency"}, {"column_name": "flsa_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under FLSA (Fair Labor Standards Act)", "intended_datatype": "numeric"}, {"column_name": "flsa_mw_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under FLSA (Fair Labor Standards Act) Minimum Wages", "intended_datatype": "currency"}, {"column_name": "flsa_ot_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under FLSA (Fair Labor Standards Act) Overtime", "intended_datatype": "currency"}, {"column_name": "flsa_15a3_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed under FLSA (Fair Labor Standards Act) 15 (a)(3)", "intended_datatype": "currency"}, {"column_name": "flsa_cmp_assd_amt", "data_type": "number", "column_desc": "CMP's assessed under FLSA (Fair Labor Standards Act)", "intended_datatype": "currency"}, {"column_name": "sca_violtn_cnt", "data_type": "number", "column_desc": "Violations found under SCA (Service Contract Act)", "intended_datatype": "numeric"}, {"column_name": "sca_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under SCA (Service Contract Act)", "intended_datatype": "currency"}, {"column_name": "sca_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under SCA (Service Contract Act)", "intended_datatype": "numeric"}, {"column_name": "mspa_violtn_cnt", "data_type": "number", "column_desc": "Violations found under MSPA (Migrant and Seasonal Agricultural Worker Protection Act). Note: A change in data collection procedures occurred on 10/01/2025. The number of violations for compliance actions loaded into the dataset after this date are not directly comparable with the number of violations for compliance actions loaded into the dataset before this date.", "intended_datatype": "numeric"}, {"column_name": "mspa_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under MSPA (Migrant and Seasonal Agricultural Worker Protection Act)", "intended_datatype": "currency"}, {"column_name": "mspa_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under MSPA (Migrant and Seasonal Agricultural Worker Protection Act)", "intended_datatype": "numeric"}, {"column_name": "mspa_cmp_assd_amt", "data_type": "number", "column_desc": "CMP's assessed under MSPA (Migrant and Seasonal Agricultural Worker Protection Act)", "intended_datatype": "currency"}, {"column_name": "h1b_violtn_cnt", "data_type": "number", "column_desc": "Violations found under H1B (Work Visa - Speciality Occupations). Note: A change in data collection procedures occurred on 10/01/2025. The number of violations for compliance actions loaded into the dataset after this date are not directly comparable with the number of violations for compliance actions loaded into the dataset before this date.", "intended_datatype": "numeric"}, {"column_name": "h1b_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under H1B (Work Visa - Speciality Occupations)", "intended_datatype": "currency"}, {"column_name": "h1b_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under H1B (Work Visa - Speciality Occupations)", "intended_datatype": "numeric"}, {"column_name": "h1b_cmp_assd_amt", "data_type": "number", "column_desc": "CMP's assessed under H1B (Work Visa - Speciality Occupations)", "intended_datatype": "currency"}, {"column_name": "fmla_violtn_cnt", "data_type": "number", "column_desc": "Violations found under FMLA (Family and Medical Leave Act). Note: A change in data collection procedures occurred on 10/01/2025. The number of violations for compliance actions loaded into the dataset after this date are not directly comparable with the number of violations for compliance actions loaded into the dataset before this date.", "intended_datatype": "numeric"}, {"column_name": "fmla_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under FMLA (Family and Medical Leave Act)", "intended_datatype": "currency"}, {"column_name": "fmla_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under FMLA (Family and Medical Leave Act)", "intended_datatype": "numeric"}, {"column_name": "fmla_cmp_assd_amt", "data_type": "number", "column_desc": "CMP's assessed under FMLA (Family and Medical Leave Act)", "intended_datatype": "currency"}, {"column_name": "flsa_cl_violtn_cnt", "data_type": "number", "column_desc": "Violations found under FLSA - CL (Fair Labor Standards Act - Child Labor)", "intended_datatype": "numeric"}, {"column_name": "flsa_cl_minor_cnt", "data_type": "number", "column_desc": "Minors found employed in violation of FLSA - CL (Fair Labor Standards Act - Child Labor)", "intended_datatype": "numeric"}, {"column_name": "flsa_cl_cmp_assd_amt", "data_type": "number", "column_desc": "CMP's assessed under FLSA - CL (Fair Labor Standards Act - Child Labor)", "intended_datatype": "currency"}, {"column_name": "dbra_violtn_cnt", "data_type": "number", "column_desc": "Violations found under DBRA (Davis-Bacon and Related Act)", "intended_datatype": "numeric"}, {"column_name": "dbra_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under DBRA (Davis-Bacon and Related Act)", "intended_datatype": "currency"}, {"column_name": "dbra_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under DBRA (Davis-Bacon and Related Act)", "intended_datatype": "numeric"}, {"column_name": "h2a_violtn_cnt", "data_type": "number", "column_desc": "Violations found under H2A (Work Visa - Seasonal Agricultural Workers)", "intended_datatype": "numeric"}, {"column_name": "h2a_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under H2A (Work Visa - Seasonal Agricultural Workers)", "intended_datatype": "currency"}, {"column_name": "h2a_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under H2A (Work Visa - Seasonal Agricultural Workers)", "intended_datatype": "numeric"}, {"column_name": "h2a_cmp_assd_amt", "data_type": "number", "column_desc": "CMP's assessed under H2A (Work Visa - Seasonal Agricultural Workers)", "intended_datatype": "currency"}, {"column_name": "flsa_smw14_violtn_cnt", "data_type": "number", "column_desc": "Violations found under FLSA - SMW14 (Fair Labor Standards Act - Special Minimum Wages under Section 14(c))", "intended_datatype": "numeric"}, {"column_name": "flsa_smw14_bw_amt", "data_type": "number", "column_desc": "BW Agreed to under FLSA - SMW14 (Fair Labor Standards Act - Special Minimum Wages under Section 14(c))", "intended_datatype": "currency"}, {"column_name": "flsa_smw14_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under FLSA - SMW14 (Fair Labor Standards Act - Special Minimum Wages under Section 14(c))", "intended_datatype": "numeric"}, {"column_name": "cwhssa_violtn_cnt", "data_type": "number", "column_desc": "Violations found under CWHSSA (Contract Work Hours and Safety Standards Act)", "intended_datatype": "numeric"}, {"column_name": "cwhssa_bw_amt", "data_type": "number", "column_desc": "BW Agreed to under CWHSSA (Contract Work Hours and Safety Standards Act)", "intended_datatype": "currency"}, {"column_name": "cwhssa_ee_cnt", "data_type": "number", "column_desc": "EE's Agreed to under CWHSSA (Contract Work Hours and Safety Standards Act)", "intended_datatype": "numeric"}, {"column_name": "osha_violtn_cnt", "data_type": "number", "column_desc": "Violations found under OSHA (Occupational Safety and Health Standards)", "intended_datatype": "numeric"}, {"column_name": "osha_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under OSHA (Occupational Safety and Health Standards)", "intended_datatype": "currency"}, {"column_name": "osha_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under OSHA (Occupational Safety and Health Standards)", "intended_datatype": "numeric"}, {"column_name": "osha_cmp_assd_amt", "data_type": "number", "column_desc": "CMP's assessed under OSHA (Occupational Safety and Health Standards)", "intended_datatype": "currency"}, {"column_name": "eppa_violtn_cnt", "data_type": "number", "column_desc": "Violations found under EPPA (Employee Polygraph Protection Act)", "intended_datatype": "numeric"}, {"column_name": "eppa_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under EPPA (Employee Polygraph Protection Act)", "intended_datatype": "currency"}, {"column_name": "eppa_ee_cnt", "data_type": "number", "column_desc": "EE's Agreed to under EPPA (Employee Polygraph Protection Act)", "intended_datatype": "numeric"}, {"column_name": "eppa_cmp_assd_amt", "data_type": "number", "column_desc": "CMP's assessed under EPPA (Employee Polygraph Protection Act)", "intended_datatype": "currency"}, {"column_name": "h1a_violtn_cnt", "data_type": "number", "column_desc": "Violations found under H1A (Work Visa - Registered nurses for temporary employment)", "intended_datatype": "numeric"}, {"column_name": "h1a_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under H1A (Work Visa - Registered nurses for temporary employment)", "intended_datatype": "currency"}, {"column_name": "h1a_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under H1A (Work Visa - Registered nurses for temporary employment)", "intended_datatype": "numeric"}, {"column_name": "h1a_cmp_assd_amt", "data_type": "number", "column_desc": "CMP's assessed under H1A (Work Visa - Registered nurses for temporary employment)", "intended_datatype": "currency"}, {"column_name": "crew_violtn_cnt", "data_type": "number", "column_desc": "Violations found under CREW (Longshoremen (D1))", "intended_datatype": "numeric"}, {"column_name": "crew_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under CREW (Longshoremen (D1))", "intended_datatype": "currency"}, {"column_name": "crew_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under CREW (Longshoremen (D1))", "intended_datatype": "numeric"}, {"column_name": "crew_cmp_assd_amt", "data_type": "number", "column_desc": "CMP's assessed under CREW (Longshoremen (D1))", "intended_datatype": "currency"}, {"column_name": "ccpa_violtn_cnt", "data_type": "number", "column_desc": "Violations found under CCPA (Consumer Credit Protection Act - Wage Garnishment)", "intended_datatype": "numeric"}, {"column_name": "ccpa_bw_atp_amt", "data_type": "varchar", "column_desc": "BW Agreed to under CCPA (Consumer Credit Protection Act - Wage Garnishment)", "intended_datatype": "currency"}, {"column_name": "ccpa_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under CCPA (Consumer Credit Protection Act - Wage Garnishment)", "intended_datatype": "numeric"}, {"column_name": "flsa_smwpw_violtn_cnt", "data_type": "number", "column_desc": "Violations found under FLSA - SMWPW (Fair Labor Standards Act - Special Minimum Wages - Patient worker)", "intended_datatype": "numeric"}, {"column_name": "flsa_smwpw_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under FLSA - SMWPW (Fair Labor Standards Act - Special Minimum Wages - Patient worker)", "intended_datatype": "currency"}, {"column_name": "flsa_smwpw_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under FLSA - SMWPW (Fair Labor Standards Act - Special Minimum Wages - Patient worker)", "intended_datatype": "numeric"}, {"column_name": "flsa_hmwkr_violtn_cnt", "data_type": "number", "column_desc": "Violations found under FLSA - HMWKR (Fair Labor Standards Act - industrial homework)", "intended_datatype": "numeric"}, {"column_name": "flsa_hmwkr_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under FLSA - HMWKR (Fair Labor Standards Act - industrial homework)", "intended_datatype": "currency"}, {"column_name": "flsa_hmwkr_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under FLSA - HMWKR (Fair Labor Standards Act - industrial homework)", "intended_datatype": "numeric"}, {"column_name": "flsa_hmwkr_cmp_assd_amt", "data_type": "number", "column_desc": "CMP's assessed under FLSA - HMWKR (Fair Labor Standards Act - industrial homework)", "intended_datatype": "currency"}, {"column_name": "ca_violtn_cnt", "data_type": "number", "column_desc": "Violations found under CA (Copeland Anti-kickbact Act)", "intended_datatype": "numeric"}, {"column_name": "ca_bw_atp_amt", "data_type": "number", "column_desc": "Back Wages Agreed to under CA (Copeland Anti-kickbact Act)", "intended_datatype": "currency"}, {"column_name": "ca_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under CA (Copeland Anti-kickbact Act)", "intended_datatype": "numeric"}, {"column_name": "pca_violtn_cnt", "data_type": "number", "column_desc": "Violations found under PCA (Public Contracts Act)", "intended_datatype": "numeric"}, {"column_name": "pca_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under PCA (Public Contracts Act)", "intended_datatype": "currency"}, {"column_name": "pca_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under PCA (Public Contracts Act)", "intended_datatype": "numeric"}, {"column_name": "flsa_smwap_violtn_cnt", "data_type": "number", "column_desc": "Violations found under FLSA - SMWAP (Fair Labor Standards Act - Special Minimum Wages - Apprentices)", "intended_datatype": "numeric"}, {"column_name": "flsa_smwap_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under FLSA - SMWAP (Fair Labor Standards Act - Special Minimum Wages - Apprentices)", "intended_datatype": "currency"}, {"column_name": "flsa_smwap_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under FLSA - SMWAP (Fair Labor Standards Act - Special Minimum Wages - Apprentices)", "intended_datatype": "numeric"}, {"column_name": "flsa_smwft_violtn_cnt", "data_type": "number", "column_desc": "Violations found under FLSA - SMWFT (Fair Labor Standards Act - Special Minimum Wages - Full Time)", "intended_datatype": "numeric"}, {"column_name": "flsa_smwft_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under FLSA - SMWFT (Fair Labor Standards Act - Special Minimum Wages - Full Time)", "intended_datatype": "currency"}, {"column_name": "flsa_smwft_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under FLSA - SMWFT (Fair Labor Standards Act - Special Minimum Wages - Full Time)", "intended_datatype": "numeric"}, {"column_name": "flsa_smwl_violtn_cnt", "data_type": "number", "column_desc": "Violations found under FLSA - SMWL (Fair Labor Standards Act - Special Minimum Wages - Learners)", "intended_datatype": "numeric"}, {"column_name": "flsa_smwl_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under FLSA - SMWL (Fair Labor Standards Act - Special Minimum Wages - Learners)", "intended_datatype": "currency"}, {"column_name": "flsa_smwl_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under FLSA - SMWL (Fair Labor Standards Act - Special Minimum Wages - Learners)", "intended_datatype": "numeric"}, {"column_name": "flsa_smwmg_violtn_cnt", "data_type": "number", "column_desc": "Violations found under FLSA - SMWMG (Fair Labor Standards Act - Special Minimum Wages - Messengers)", "intended_datatype": "numeric"}, {"column_name": "flsa_smwmg_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under FLSA - SMWMG (Fair Labor Standards Act - Special Minimum Wages - Messengers)", "intended_datatype": "currency"}, {"column_name": "flsa_smwmg_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under FLSA - SMWMG (Fair Labor Standards Act - Special Minimum Wages - Messengers)", "intended_datatype": "numeric"}, {"column_name": "flsa_smwsl_violtn_cnt", "data_type": "number", "column_desc": "Violations found under FLSA - SMWSL (Fair Labor Standards Act - Special Minimum Wages - Student Learners)", "intended_datatype": "numeric"}, {"column_name": "flsa_smwsl_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under FLSA - SMWSL (Fair Labor Standards Act - Special Minimum Wages - Student Learners)", "intended_datatype": "currency"}, {"column_name": "flsa_smwsl_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under FLSA - SMWSL (Fair Labor Standards Act - Special Minimum Wages - Student Learners)", "intended_datatype": "numeric"}, {"column_name": "eev_violtn_cnt", "data_type": "number", "column_desc": "Violations found under EEV (ESA 91)", "intended_datatype": "numeric"}, {"column_name": "h2b_violtn_cnt", "data_type": "number", "column_desc": "Violations found under H2B (Work Visa - Temporary Non-Agricultural Work). Note: A change in data collection procedures occurred on 10/01/2025. The number of violations for compliance actions loaded into the dataset after this date are not directly comparable with the number of violations for compliance actions loaded into the dataset before this date.", "intended_datatype": "numeric"}, {"column_name": "h2b_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under H2B (Work Visa - Temporary Non-Agricultural Work)", "intended_datatype": "currency"}, {"column_name": "h2b_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under H2B (Work Visa - Temporary Non-Agricultural Work)", "intended_datatype": "numeric"}, {"column_name": "sraw_violtn_cnt", "data_type": "number", "column_desc": "Violations found under SRAW (Spec. Agri. Workers/Replenishment Agri. Workers)", "intended_datatype": "numeric"}, {"column_name": "sraw_bw_atp_amt", "data_type": "number", "column_desc": "BW Agreed to under SRAW (Spec. Agri. Workers/Replenishment Agri. Workers)", "intended_datatype": "currency"}, {"column_name": "sraw_ee_atp_cnt", "data_type": "number", "column_desc": "EE's Agreed to under SRAW (Spec. Agri. Workers/Replenishment Agri. Workers)", "intended_datatype": "numeric"}, {"column_name": "load_dt", "data_type": "timestamp_ntz", "column_desc": "Internal Purposes", "intended_datatype": "date"}], "tag_list": ["address", "back wages", "compliance", "industries", "inspection", "penalties", "state", "violations"], "created_at": "2026-06-04T00:24:46", "updated_at": "2026-06-04T00:40:56"}}