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