Wage and Hour Compliance Action Data

Data source: Department of Labor Enforcement Data Catalog, scraped

Custom SQL query

Tables

cases

case_id, trade_nm, legal_name, street_addr_1_txt, cty_nm, st_cd, zip_cd, naic_cd, naics_code_description, case_violtn_cnt, cmp_assd_cnt, ee_violtd_cnt, bw_atp_amt, ee_atp_cnt, findings_start_date, findings_end_date, flsa_repeat_violator, ld_dt

337,834 rows

flsa_details

violation_id, type, back_wages

200,055 rows

violations

id, case_id, type, violations, back_wages, employees, civil_money_penalty

301,835 rows

sqlite_stat1 (hidden)

tbl, idx, stat

3 rows

Download SQLite DB: whisard.db 77.2 MB