Query WHD Enforcement Records
whd_enforcement_queryQuery concluded Wage and Hour Division compliance actions from the DOL WHD Enforcement dataset to retrieve investigation records and violation details.
Instructions
Query concluded Wage and Hour Division compliance actions from the DOL WHD Enforcement (WHISARD) dataset. IMPORTANT date semantics: findings_end_date is the date violations STOPPED occurring, NOT the date the case was concluded. Investigation lag from end-of-violation to case-closed is typically 6-24 months. When filtering for 'cases from 2024-2025,' use a wider findings_end_date window (e.g., findings_end_date >= 2022-10-01) and rank by recency; a strict 2024-2025 findings filter will return an artificially small slice. The ld_dt field is the dataset load date, not the case-conclusion date.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | Sort direction. | |
| limit | No | Maximum records to return. DOL max is 10000. | |
| fields | No | Field names to return, as an array or comma-separated string. | |
| offset | No | Records to skip for paging. | |
| sort_by | No | Field name to sort by. | |
| filter_object | No | DOL filter_object JSON with field/operator/value or and/or groups. |