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.

214,879 rows

✎ View and edit SQL

Suggested facets: type

violation_id type back_wages
2 flsa_ot 12135.91
5 flsa_ot 601.01
8 flsa_ot 42.53
18 flsa_mw 5112.24
18 flsa_ot 5158.13
21 flsa_ot 2818.19
23 flsa_ot 6706.35
25 flsa_ot 132312.06
28 flsa_ot 154026.66
31 flsa_mw 27.8
31 flsa_ot 15490.44
34 flsa_ot 1920.0
36 flsa_mw 652.48
36 flsa_ot 10524.33
39 flsa_ot 6996.81
47 flsa_ot 33732.28
49 flsa_ot 26.2
51 flsa_ot 2946.88
53 flsa_mw 8131.01
53 flsa_ot 713.81
59 flsa_mw 637.24
61 flsa_ot 4892.23
66 flsa_mw 2788.63
66 flsa_ot 1405.43
69 flsa_ot 1473.56
71 flsa_mw 6306.32
71 flsa_ot 223.69
75 flsa_mw 22498.31
75 flsa_ot 126950.57
78 flsa_mw 380.84
78 flsa_ot 2672.54
82 flsa_15a3 2500.0
82 flsa_mw 3495.92
82 flsa_ot 275.2
86 flsa_ot 48280.72
88 flsa_ot 1200.0
90 flsa_ot 566.14
92 flsa_mw 4685.86
97 flsa_mw 378.51
108 flsa_mw 997.2
115 flsa_ot 2915.43
117 flsa_ot 1340.48
120 flsa_ot 112.03
123 flsa_ot 924.75
125 flsa_mw 2190.75
125 flsa_ot 48834.39
129 flsa_mw 1754.58
129 flsa_ot 8784.8
132 flsa_mw 3155.65
132 flsa_ot 8355.7
135 flsa_mw 9411.06
135 flsa_ot 15741.7
138 flsa_ot 300.0
140 flsa_mw 5707.89
140 flsa_ot 13926.01
145 flsa_ot 9179.25
147 flsa_ot 29495.14
149 flsa_ot 12737.87
151 flsa_mw 239.97
151 flsa_ot 552.21
155 flsa_mw 7.2
155 flsa_ot 45361.19
158 flsa_ot 3624.79
160 flsa_ot 4716.55
162 flsa_mw 13696.0
165 flsa_ot 16567.7
169 flsa_ot 2646.9
171 flsa_ot 2084.13
173 flsa_ot 77420.05
175 flsa_ot 594.38
177 flsa_ot 1088.88
179 flsa_mw 42.0
179 flsa_ot 60.0
183 flsa_mw 128.75
183 flsa_ot 257.21
186 flsa_ot 263.0
197 flsa_ot 219233.5
199 flsa_ot 24951.88
202 flsa_mw 1725.78
202 flsa_ot 2654.5
205 flsa_ot 12954.6
208 flsa_ot 100.17
210 flsa_ot 570.0
212 flsa_ot 4528.98
214 flsa_ot 1033.8
216 flsa_ot 586.42
218 flsa_mw 2669.54
218 flsa_ot 1204.06
221 flsa_ot 1900.0
226 flsa_mw 2178.9
226 flsa_ot 28369.01
230 flsa_ot 169.68
237 flsa_ot 376.67
242 flsa_ot 2913.89
247 flsa_mw 522.71
247 flsa_ot 18876.57
250 flsa_ot 95151.43
252 flsa_ot 15390.91
258 flsa_mw 565.5
258 flsa_ot 487.5

Next page

Download this data

CSV · JSON

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