home / whisard / flsa_details

flsa_details

Placeholder table for additional FLSA-violation detail. Currently empty in the snapshot — the upstream WHD export doesn't always populate this. The schema is included for forward-compatibility with future WHD releases.
back_wages
Back wages owed under this detail row, in dollars.
type
Sub-classification of the FLSA violation.
violation_id
Foreign key to violations.id.

✎ View and edit SQL

violation_id type back_wages

0 records

Table schema
CREATE TABLE flsa_details(violation_id BIGINT, "type" VARCHAR, back_wages DOUBLE, FOREIGN KEY (violation_id) REFERENCES violations(id));

Queries took 1.2ms

A project of Forest Gregg. Read about project updates on Notes on Labor Data.