cases: 1768547
| case_id | trade_nm | legal_name | street_addr_1_txt | cty_nm | st_cd | zip_cd | naic_cd | naics_code_description | case_violtn_cnt | cmp_assd | ee_violtd_cnt | bw_atp_amt | ee_atp_cnt | findings_start_date | findings_end_date | flsa_repeat_violator | load_dt |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1768547 | R & R Environmental Mechanical Services | R & R Environmental Mechanical Services, LLC | 5130 Boyd Blvd. | Rowlett | TX | 75088 | 238220 | Plumbing, Heating, and Air-Conditioning Contractors | 5 | 0.0 | 4 | 1900.0 | 4 | 2013-10-24 | 2015-10-23 | N/A | 2016-06-11 02:22:25 |
Links from other tables
- 1 row from case_id in violations