violations

One row per violation type per case — the per-statute breakdown of each investigation's findings. The type column identifies the specific federal labor law violated; common values include FLSA (general Fair Labor Standards Act), flsa_ot (overtime), flsa_mw (minimum wage), fmla (Family and Medical Leave Act), and dbra (Davis-Bacon Act).
back_wages
Back wages owed under this statute, in dollars.
case_id
Foreign key to cases.case_id.
civil_money_penalty
Civil money penalty assessed under this statute, in dollars.
employees
Number of employees affected under this statute.
id
Primary key.
type
Statute violated — "flsa" (Fair Labor Standards Act, general), "flsa_ot" (FLSA overtime), "flsa_mw" (FLSA minimum wage), "flsa_cl" (FLSA child labor), "flsa_smw14" (FLSA student/learner Section 14 minimum wage), "fmla" (Family and Medical Leave Act), "dbra" (Davis-Bacon Act, prevailing wage on federal construction), "sca" (Service Contract Act, prevailing wage on federal service contracts), "cwhssa" (Contract Work Hours and Safety Standards Act), "mspa" (Migrant and Seasonal Agricultural Worker Protection Act), "h1b" / "h2a" / "h2b" (visa program violations), "osha" (OSHA-related findings), or "eppa" (Employee Polygraph Protection Act).
violations
Number of violations cited under this statute for this case.

542,030 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ case_id type violations back_wages employees civil_money_penalty
1 1784005 1784005 flsa 1 0.0 0 0.0
2 1460300 1460300 flsa 4 12135.91 3 0.0
3 1460300 1460300 flsa_ot   12135.91    
4 1438534 1438534 flsa 1 0.0 0 0.0
5 1438543 1438543 flsa 5 601.01 4 0.0
6 1438543 1438543 flsa_ot   601.01    
7 1475069 1475069 sca 174 186357.45 171  
8 1438544 1438544 flsa 1 42.53 1 0.0
9 1438544 1438544 flsa_ot   42.53    
10 1463104 1463104 flsa 1 0.0 0 0.0
11 1464575 1464575 flsa_cl 4   4 0.0
12 1442950 1442950 flsa 1 0.0 0 0.0
13 1442957 1442957 flsa_cl 1   1 990.0
14 1620214 1620214 sca 38 51294.18 19  
15 1658229 1658229 mspa 1 0.0 0 50.0
16 1658453 1658453 flsa 1 0.0 0 0.0
17 1658453 1658453 mspa 7 0.0 0 1025.0
18 1658691 1658691 flsa 20 10270.37 18 0.0
19 1658691 1658691 flsa_mw   5112.24    
20 1658691 1658691 flsa_ot   5158.13    
21 1518717 1518717 flsa 10 2818.19 9 0.0
22 1518717 1518717 flsa_ot   2818.19    
23 1518719 1518719 flsa 25 6706.35 24 0.0
24 1518719 1518719 flsa_ot   6706.35    
25 1688432 1688432 flsa 41 132312.06 40 0.0
26 1688432 1688432 flsa_ot   132312.06    
27 1492805 1492805 sca 83 53217.78 82  
28 1594970 1594970 flsa 130 154026.66 103 0.0
29 1594970 1594970 flsa_ot   154026.66    
30 1468695 1468695 fmla 1 150.0 1 0.0
31 1740451 1740451 flsa 24 15518.24 23 0.0
32 1740451 1740451 flsa_mw   27.8    
33 1740451 1740451 flsa_ot   15490.44    
34 1468934 1468934 flsa 3 1920.0 2 0.0
35 1468934 1468934 flsa_ot   1920.0    
36 1744431 1744431 flsa 17 11176.81 12 2640.0
37 1744431 1744431 flsa_mw   652.48    
38 1744431 1744431 flsa_ot   10524.33    
39 1754411 1754411 flsa 2 6996.81 2 0.0
40 1754411 1754411 flsa_ot   6996.81    
41 1763798 1763798 flsa 2 0.0 0 0.0
42 1763808 1763808 fmla 2 0.0 0 0.0
43 1763808 1763808 eppa 1 0.0 0 0.0
44 1763810 1763810 dbra 1 1780.75 1  
45 1763810 1763810 cwhssa 1 28.69 1  
46 1763817 1763817 dbra 1 0.0 0  
47 1299674 1299674 flsa 16 33732.28 16 0.0
48 1299674 1299674 flsa_ot   33732.28    
49 1767280 1767280 flsa 2 26.2 1 0.0
50 1767280 1767280 flsa_ot   26.2    
51 1767289 1767289 flsa 4 2946.88 3 0.0
52 1767289 1767289 flsa_ot   2946.88    
53 1791386 1791386 flsa 145 8844.82 103 0.0
54 1791386 1791386 flsa_mw   8131.01    
55 1791386 1791386 flsa_ot   713.81    
56 1793850 1793850 flsa 2 0.0 0 0.0
57 1794281 1794281 flsa 1 0.0 0 0.0
58 1794652 1794652 flsa 1 0.0 0 0.0
59 1795788 1795788 flsa 2 637.24 1 0.0
60 1795788 1795788 flsa_mw   637.24    
61 1797760 1797760 flsa 4 4892.23 3 0.0
62 1797760 1797760 flsa_ot   4892.23    
63 1799052 1799052 flsa 8 0.0 0 0.0
64 1799560 1799560 flsa 1 0.0 0 0.0
65 1801519 1801519 flsa 1 0.0 0 0.0
66 1760956 1760956 flsa 20 4194.06 15 0.0
67 1760956 1760956 flsa_mw   2788.63    
68 1760956 1760956 flsa_ot   1405.43    
69 1762752 1762752 flsa 2 1473.56 1 0.0
70 1762752 1762752 flsa_ot   1473.56    
71 1773188 1773188 flsa 9 6530.01 6 0.0
72 1773188 1773188 flsa_mw   6306.32    
73 1773188 1773188 flsa_ot   223.69    
74 1773188 1773188 fmla 1 0.0 0 0.0
75 1775360 1775360 flsa 55 149448.88 41 0.0
76 1775360 1775360 flsa_mw   22498.31    
77 1775360 1775360 flsa_ot   126950.57    
78 1783362 1783362 flsa 5 3053.38 4 1082.9
79 1783362 1783362 flsa_mw   380.84    
80 1783362 1783362 flsa_ot   2672.54    
81 1784270 1784270 sca 21 14860.65 21  
82 1784280 1784280 flsa 10 6271.12 7 0.0
83 1784280 1784280 flsa_mw   3495.92    
84 1784280 1784280 flsa_ot   275.2    
85 1784280 1784280 flsa_15a3   2500.0    
86 1784298 1784298 flsa 53 48280.72 52 0.0
87 1784298 1784298 flsa_ot   48280.72    
88 1789671 1789671 flsa 2 1200.0 1 0.0
89 1789671 1789671 flsa_ot   1200.0    
90 1791715 1791715 flsa 3 566.14 2 0.0
91 1791715 1791715 flsa_ot   566.14    
92 1792006 1792006 flsa 9 4685.86 7 0.0
93 1792006 1792006 flsa_mw   4685.86    
94 1798546 1798546 flsa 1 0.0 0 0.0
95 1798908 1798908 flsa_cl 2   2 3252.0
96 1800654 1800654 fmla 144 0.0 0 0.0
97 1800981 1800981 flsa 6 378.51 5 0.0
98 1800981 1800981 flsa_mw   378.51    
99 1801753 1801753 flsa 1 0.0 0 0.0
100 1802853 1802853 mspa 1 0.0 0 0.0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "violations" (
   [id] INTEGER PRIMARY KEY,
   [case_id] INTEGER REFERENCES [cases]([case_id]),
   [type] TEXT,
   [violations] INTEGER,
   [back_wages] FLOAT,
   [employees] INTEGER,
   [civil_money_penalty] FLOAT
);