home / whisard

Wage and Hour Compliance Action Data

The DOL Wage and Hour Division's "WHISARD" (Wage-Hour Investigative Support and Reporting Database) — every closed WHD investigation. Each case names the employer, the location and industry, and the workers affected; the matched violations table lists each statute violated with counts, back wages owed, and civil money penalties.

WHD enforces a wide range of federal labor laws: the Fair Labor Standards Act (minimum wage, overtime, child labor, recordkeeping); the Family and Medical Leave Act; the Davis-Bacon Act and Service Contract Act (prevailing-wage rules on federal contracts); the Migrant and Seasonal Agricultural Worker Protection Act; H-1B, H-2A, and H-2B visa worker protections; the Employee Polygraph Protection Act; and others. The type column on the violations table identifies which statute was violated.

The data is scraped from the DOL Enforcement Data Catalog. WHD refreshes their dataset roughly quarterly; the scraper checks for updates daily and re-imports when WHD publishes a new snapshot.

Data source: Department of Labor Enforcement Data Catalog, scraped

Custom SQL query

Tables schema

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, ee_violtd_cnt, bw_atp_amt, ee_atp_cnt, findings_start_date, findings_end_date, flsa_repeat_violator, load_dt

365,393 rows

flsa_details

violation_id, type, back_wages

0 rows

violations

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

542,030 rows

... and 1 hidden table

Download SQLite DB: whisard.db 97.0 MB

Powered by Datasette · Data source: Department of Labor Enforcement Data Catalog, scraped