cl_c_closed_case_report

126,619 rows

✎ View and edit SQL

Suggested facets: action_sequence, washington_approval, compliance_type, closing_type, enforcement_recommend, emprein_num_discrim, emprein_num_accept, emprein_num_waiving, emprein_num_decline, emprein_num_pref_list, back_total_union, fees_num_individuals, fees_total_due, fees_total_employers, fees_total_union, other_post_notice, other_withdraw_assistance, other_disestablish, other_disestablish_notice, other_bargain, other_bargain_status, backpay_control_code, back_installment_flag, court_costs, check_forwarded_finance, cmp_cp_position, other_company_post (date), other_union_post (date), other_end_picketing_date (date), other_end_stoppage_date (date), check_forwarded_finance (date)

c_case_number action_sequence washington_approval compliance_type closing_type complaint enforcement_recommend contempt_recommended_type emprein_num_discrim emprein_num_accept emprein_num_waiving emprein_num_decline emprein_num_pref_list unionres_num_hall_rights unionres_obj_with unionres_hired back_number_made_whole back_total_num_rcv back_total_amount_due back_total_employer back_total_union fees_num_individuals fees_total_due fees_total_employers fees_total_union other_post_notice other_company_post other_union_post other_withdraw_assistance other_withdraw_notice other_disestablish other_disestablish_notice other_end_picketing other_end_picketing_date other_end_picketing_return other_end_stoppage other_end_stoppage_date other_end_stoppage_return other_bargain other_bargain_status backpay_control_code back_installment_flag court_costs court_costs_amount court_costs_collected check_forwarded_finance other_remedies cmp_cp_position agent regional_attorney regional_director
01-CA-19224-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N         Satis      
01-CA-19567-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
01-CA-19690-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
01-CA-19731-001 0 N CtOrd PtCmp Regn Y Civil                 67 62 1240314.42 40665.58           Y     N N N N N     N     Y APCMS ErCA N Y 1240314.42 40665.58     Satis      
01-CA-19797-001 0 N CtOrd PtCmp Regn Y Civil                 67 62 1240314.42 40665.58           Y     N N N N N     N     Y APCMS ErCA N Y 1240314.42 40665.58     Satis      
01-CA-19903-001 0 N CtOrd PtCmp Regn Y Civil                 67 62 1240314.42 40665.58           Y     N N N N N     N     Y APCMS ErCA N Y 1240314.42 40665.58     Satis      
01-CA-19958-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
01-CA-20007-001 0 N CtOrd PtCmp Regn Y Civil                 67 62 1240314.42 40665.58           Y     N N N N N     N     Y APCMS ErCA N Y 1240314.42 40665.58     Satis      
01-CA-20157-001 0 N CtOrd PtCmp Regn Y Civil                 67 62 1240314.42 40665.58           Y     N N N N N     N     Y APCMS ErCA N Y 1240314.42 40665.58     Satis      
01-CA-20218-001 0 N CtOrd PtCmp Regn Y Civil                 67 62 1240314.42 40665.58           Y     N N N N N     N     Y APCMS ErCA N Y 1240314.42 40665.58     Satis      
01-CA-20283-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
01-CA-20291-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
01-CA-20304-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
01-CA-20442-001 0 N CtOrd PtCmp Regn Y Civil                 67 62 1240314.42 40665.58           Y     N N N N N     N     Y APCMS ErCA N Y 1240314.42 40665.58     Satis      
01-CA-20508-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
01-CA-20521-001 0 N CtOrd PtCmp Regn Y Civil                 67 62 1240314.42 40665.58           Y     N N N N N     N     Y APCMS ErCA N Y 1240314.42 40665.58     Satis      
01-CA-21438-001 0 N CtOrd PtCmp Regn Y Civil                 67 62 1240314.42 40665.58           Y     N N N N N     N     Y APCMS ErCA N Y 1240314.42 40665.58     Satis      
01-CA-21560-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
01-CA-21943-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-22040-002 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-22687-001 0 N BOC PtCmp Regn N   14 0             14 14 114886.51 114886.51           N     N N N N N     N     Y APCMS ErCA Y N       Case closed administratively Satis      
01-CA-22769-001 0 N BOC PtCmp Regn N   14               14 14 114886.51 114886.51           N     N N N N N     N     Y APCMS ErCA Y N       closed administratively Satis      
01-CA-22869-001 0 N BOC PtCmp Regn N   14               14 14 114886.51 114886.51           N     N N N N N     N     Y APCMS ErCA Y N       administratively closed Satis      
01-CA-23307-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-23576-001 0 N BOC PtCmp Regn N   14               14 14 114886.51 114886.51           N     N N N N N     N     Y APCMS ErCA Y N   114886.51   adminstratively closed Satis      
01-CA-23748-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-24161-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-24372-001 0 N CtOrd NoCmp Regn Y Civil 0 0 0 0 0 0 0 0 78 0 156337.89 0.0 0.0 0 0.0 0.0 0.0 Y     N N N N N     N     Y APCMS   N N       ER never posted notices and refused to mail notices to ees after facility closed down; charging party is satisfied the Region did all it could do. Satis      
01-CA-24390-002 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-24528-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-24863-001 0 N Infrm AllPW Regn N   1 0 1           18 18 6000.0 6000.0           Y 1988-09-23   N N N N N     N     Y InPrg ErCA Y N 6000.0 6000.0   Respondent rescinded unilateral attendance policy, and will bargain about new policy. preferentail reinstatement policy for one employee. Satis      
01-CA-24883-001 0 N Infrm AllPW Regn N   1 0 1           18 18 6000.0 6000.0           Y 1988-09-23   N N N N N     N     Y InPrg ErCA Y N 6000.0 6000.0   Respondent rescinded unilateral attendance policy, and will bargain about new policy. Preferential reinstatement policy for one employee. Satis      
01-CA-24921-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-24967-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-25033-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-25237-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-25237-002 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-25341-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-25521-001 0 Y   NoCmp   N                                     N     N N N N N     N     N     N N       Board Decision dismissed Complaint on 10/15/1993        
01-CA-25599-001 0 N BOC PtCmp Regn N   14               14 14 114886.51 114886.51           N     N N N N N     N     Y APCMS ErCA Y N   114886.51   administrativley closed Satis      
01-CA-25656-001 0 N BOC NoCmp Regn Y                                     N     N N N N N     N     N     N N       closed for non-compliance after bankruptcy case closed and none of Respondent's unsecured creditors received disbursements        
01-CA-25736-001 0 N CtOrd PtCmp Regn Y                       94785.0 3000.0           Y 1989-05-30   N N N N N     N     Y APCMS ErCA N N         Satis      
01-CA-25805-001 0 N BOC PtCmp Regn N   14               14 14 114886.51 114886.51           N     N N N N N     N     Y APCMS ErCA Y N   114886.51   administratively closed Satis      
01-CA-25864-001 0 N       N                                     N     N N N N N     N     N     N N       Board Decision dismissed Complaint on 10/15/93        
01-CA-25867-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 19 19 20000.0 20000.0 0.0 0 0.0 0.0 0.0 Y 2001-06-01   N N N N N     N     N   ErCA N N         Satis      
01-CA-25896-001 0 N BOC PtCmp Regn N   14               14 14 114886.51 114886.51           N     N N N N N     N     Y APCMS ErCA Y N   114886.51   administratively closed Satis      
01-CA-25940-001 0 N CtOrd NoCmp Regn Y                                     N     N N N N N     N     N     N N       This case is being closed agter the Court of Appeals for the 2nd Circuit refused to enforce the Board's Order by mandate dated 2/22/93.        
01-CA-25969-001 0 N CtOrd Cmpli Regn Y   0 0 0 0 0 0 0 0 28 28 98424.4 98424.4 0.0 0 0.0 0.0 0.0 Y 1996-07-08   N N N N N     N     N   ErCA N N         Satis     /s/ Rosemary Pye
01-CA-26098-001 0 N Infrm UniWr   N                   10 10 810.45 810.45           Y 1989-06-14   N N N N N     N     N   ErCA N N 810.45 810.45     Satis      
01-CA-26144-001 0 N BOC NoCmp Regn Y                                     N     N N N N N     N     N     N N       closed for non-compliance after bankruptcy case closed and none of Respondent's unsecured creditors received disbursements        
01-CA-26183-001 0 N BOU PtCmp Regn N                                     Y     N N N N N     N     Y APCMS   N N       case closed w/partial compliance after U.S. Bankruptcy Court disallowed NLRB's claim to assets and bankruptcy case closed. Aprox. $11000.00 of pension trust allowed and paid as priority claims.        
01-CA-26232-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 2 0 10980.0 0.0 0.0 0 0.0 0.0 0.0 Y     N N N N N     N     N     N N       Notices never mailed to R., and R. became insolvent and closed 7 yrs. ago. RO filed a POC w/ Bnkrtcy Ct., the 94 Trustee's report app. by Bnkrtcy Judge shows not even all of the priority claims by the IRS and state tax auth were able to be paid. No $$$. NoSat      
01-CA-26237-001 0 N Infrm AllPW Regn N   0 0 0 0 0 0 0 0 2 0 10980.0 0.0 0.0 0 0.0 0.0 0.0 Y     N N N N N     N     N     N N       See remedy in master file 1-ca-26232 NoSat      
01-CA-26270-001 0 N BOU PtCmp Regn N                                     Y     N N N N N     N     Y APCMS   N N       case closed w/partial compliance after U.S. Bankruptcy Court disallowed NLRB's claim to assets and bankruptcy case was closed. Aprox. $11000.00 of pension trust allowed and paid as priority claims        
01-CA-26353-001 0 N BOU PtCmp Regn N                                     Y     N N N N N     N     Y APCMS   N N       case closed w/partial compliance after U.S. Bankruptcy Court disallowed NLRB's claim to assets and bankruptcy case was closed. Aprox. $11000.00 of pension trust allowed and paid as priority claims        
01-CA-26463-001 0 N CtOrd Cmpli Regn N   0 0 0 0 0 0 0 0 10 10 9190.0 9190.0 0.0 0 0.0 0.0 0.0 N     N N N N N     N     N   ErCA N N       settled by stipulation at Compliance Stage Satis      
01-CA-26463-003 0 N CtOrd Cmpli Regn N   0 0 0 0 0 0 0 0 10 10 9190.0 9190.0 0.0 0 0.0 0.0 0.0 N     N N N N N     N     N   ErCA N N       settled by stipulation at Compliance Stage Satis      
01-CA-26463-005 0 N CtOrd Cmpli Regn N   0 0 0 0 0 0 0 0 10 10 9190.0 9190.0 0.0 0 0.0 0.0 0.0 N     N N N N N     N     N   ErCA N N       settled by stipulation at Compliance Stage Satis      
01-CA-26573-001 0 N CtOrd Cmpli Regn Y Civil 1 0 1           1 1 21975.35 489.02           Y     N N N N N     N     Y Other ErCA N N       Co. filed bankruptcy and this amount represents total distribution received. It is unclear why the EE waived reinstatement; the waiver was part of the S/A. The EE is now deceased. At the time of the S/A the EE was retired. We suspect Co. posted Notice Satis      
01-CA-26575-001 0 N BOC NoCmp Regn Y   0 0 0 0 0 0 0 0 20 0 38151.66 0.0 0.0 0 0.0 0.0 0.0 Y 1990-05-03   N N N N N     N     N     N N         Satis      
01-CA-26936-001 0 N BOU NoCmp Regn Y                                     Y     N N N N N     N     Y APCMS   N N         Satis      
01-CA-27014-001 0 N BOU NoCmp Regn N   4 0 0 0 0 0 0 0 4 0 20000.0 0.0 0.0 0 0.0 0.0 0.0 N     N N N N N     N     N     N N       CXompany went out of business Satis      
01-CA-27070-001 0 N CtOrd Cmpli Regn Y Civil 1 0 1 0 0 0 0 0 1 1 21975.35 489.02 0.0 0 0.0 0.0 0.0 Y     N N N N N     N     Y Other ErCA N N       Co. filed bankruptcy and this amount represents total distribution received. It is unclear why the EE waived reinstatement; the waiver was part of the S/A. The EE is now deceased. At the time of the S/A the EE was retired. We suspect Co. posted Notice Satis      
01-CA-27142-001 0 Y CtOrd NoCmp Regn Y                         0.0           Y 1992-04-11   N N N N N     N     Y APCMS   N N         Satis      
01-CA-27197-001 0 N Infrm AllPW   N                                     Y 1990-08-05   N N N N N     N     N     N N       CP was reinstated to layoff status. No backpay. CP's personnel file was expunged and CP was advised in writing of such action. Satis      
01-CA-27321-001 0 N CtOrd NoCmp Regn Y                                     N     N N N N N     N     N     N N       bankruptcy, no money for NLRB        
01-CA-27322-001 0 N BOC NoCmp Regn Y                                     N     N N N N N     N     N     N N         NoSat      
01-CA-27335-001 0 N Infrm AllPW Regn N   4 0 4           4 4 5000.0 5000.0           Y 1993-09-24   N N N N N     N     N   ErCA N N       When SA reached & signed in 93, E had already been out of business for awhile, so reinstatment wasn't part of make whole remedy; Although 5 disc. named in Complaint, 1 wasn;t located not at ULP hrg & dropped by RD from SA. Since E no longer in business, Satis      
01-CA-27356-001 0 N Infrm AllPW Regn N                   2 2 23.0 23.0           Y     N N N N N     N     Y APCMS ErCA N N 23.0 23.0   Notices mailed 12/14/90 Satis      
01-CA-27385-001 0 N BOC NoCmp Regn Y                                     N     N N N N N     N     N     N N         NoSat      
01-CA-27386-001 0 N BOC NoCmp Regn Y                                     N     N N N N N     N     N     N N         NoSat      
01-CA-27417-001 0 N Infrm AllPW Regn N                   2 2 23.0 23.0           Y     N N N N N     N     Y APCMS ErCA N N 23.0 23.0   Notices mailed 12/14/90 Satis      
01-CA-27421-001 0 N Infrm UniWr Regn N                   5 5 126725.0 1267.17           Y     N N N N N     N     Y APCMS ErCA N N 126725.0 1267.17   personnel files expunged, notices mailed, employer went out of business Satis      
01-CA-27491-001 0 N Infrm AllPW Regn N                   5 5 126725.0 1267.17           Y     N N N N N     N     Y APCMS ErCA N N 126725.0 1267.17   personnel files expunged, notices mailed, employer went out of business Satis      
01-CA-27506-001 0 N CtOrd Cmpli Regn Y   0 0 0 0 0 0 0 0 27 27 38969.73 38969.73 0.0 0 0.0 0.0 0.0 N     N N N N N     N     Y UnNoI ErCA N N         Satis      
01-CA-27659-001 0 N Infrm AllPW Regn N                   5 5 126725.0 1267.17           Y     N N N N N     N     Y APCMS ErCA N N 126725.0 1267.17   personnel files expunged, notices mailed, employer went out of business Satis      
01-CA-27731-001 0 N CtOrd PtCmp Regn Y                                     Y     N N N N N     N     Y APCMS   N N         Satis      
01-CA-27732-001 0 N Infrm AllPW Regn N                   5 5 126725.0 1267.17           Y     N N N N N     N     Y APCMS ErCA N N 126725.0 1267.17   personnel files expunged, notices mailed, employer went out of business Satis      
01-CA-27732-002 0 N Infrm AllPW Regn N                   5 5 126725.0 1267.17           Y     N N N N N     N     Y APCMS ErCA N N 126725.0 1267.17   personnel files expunged, notices mailed, employer went out of business Satis      
01-CA-27766-001 0 N Infrm UniWr Regn N   4 0 4 0 0 0 0 0 4 0 17229.0 0.0 0.0 0 0.0 0.0 0.0 N     N N N N N     N     Y Other   N N       ceased operations before bargaining ended Satis      
01-CA-27879-001 0 N BOU PtCmp Regn N                                     N     N N N N N     N     Y APCMS   N N       closed for partial compliance after bankruptcy case cloased and the Mass laborers Benefit Fund received some of the money that we had pursued on its behalf        
01-CA-27908-001 0 N CtOrd Cmpli   Y                   6 6 40000.0 36690.34           Y     N N N N N     N     N   ErCA N N       company went out of business prior to posting Notice Satis      
01-CA-27937-001 0 N Infrm UniWr Regn N                   5 5 126725.0 1267.17           Y     N N N N N     N     Y APCMS ErCA N N 126725.0 1267.17   personnel files expunged, notices mailed, employer went out of business Satis      
01-CA-27953-001 0 N BOC NoCmp Regn Y                                     N     N N N N N     N     N     N N         NoSat      
01-CA-28064-001 0 N Adjus NonBd Regn N   0 0 0 0 0 0 0 0 61 61 42302.47 90261.18 0.0 0 0.0 0.0 0.0 Y     N N N N N     N     Y APCMS ErCA N N 42302.47 90261.18   Bef. S/A approved ER paid 11,637.33 backpay & pd. 1022 to TmstPension.2/29/96 7 former ees recd. 2735.55 ea in a non bd.s/a. of remaining NLRB charges and WARN Act claim. 3/11/96 WARN Act claims by CP the Loc. recd. 59,475. See Notes Section of case card Satis      
01-CA-28250-001 0 N BOC NoCmp Regn N   0 0 0 0 0 0 0 0 54 0 33160.27 0.0 0.0 0 0.0 0.0 0.0 N     N N N N N     N     Y Other   N N       Employer ceased business and filed for bankruptcy NoSat      
01-CA-28264-001 0 N BOC PtCmp Regn Y                   23 23 147806.83 119194.78           N     N N N N N     N     N   ErCA N N 147806.83 119194.78     Satis      
01-CA-28315-001 0 N BOU NoCmp Regn N                                     N     N N N N N     N     Y APCMS   N N                
01-CA-28348-001 0 N Infrm AllPW Regn N   3 2 0 0 0 0 0 0 5 4 5555.36 5555.36 0.0 0 0.0 0.0 0.0 Y 1993-03-19   N N N N N     N     N   ErCA N N         Satis      
01-CA-28375-001 0 N BOC Cmpli Regn N   1 0 1 0 0 0 0 0 1 1 45000.0 45000.0 0.0 0 0.0 0.0 0.0 Y 1994-03-26   N N N N N     N     N   ErCA N N       Expungement Satis      
01-CA-28376-001 0 N Infrm NoCmp Regn N   0 0 0 0 0 0 0 0 4 0 5574.48 0.0 0.0 1 900.0 900.0 0.0 N     N N N N N     N     Y APCMS ErCA N N       Employer out of business Satis      
01-CA-28409-001 0 N BOU NoCmp Regn N                                     N     N N N N N     N     Y APCMS   N N                
01-CA-28418-001 0 N BOC Cmpli Regn N   10 3   7         45 45 88152.25 88152.25           Y 2000-01-24   N N N N N     N     Y InCon ErCA N N 88152.25 88152.25   Parties agreed to contract but final contract must be printed for final signature. Satis      
01-CA-28466-001 0 N Infrm AllPW Regn N                                     Y 1993-05-19   N N N N N     N     N     N N         Satis      
01-CA-28474-001 0 N BOU PtCmp Regn Y                                     N     N N N N N     N     Y APCMS   N N                
01-CA-28481-001 0 N Infrm NoCmp Regn N   0 0 0 0 0 0 0 0 4 0 5574.48 0.0 0.0 1 900.0 900.0 0.0 N     N N N N N     N     Y APCMS ErCA N N       Employer out of business. Satis      
01-CA-28493-001 0 N Adjus NonBd Regn N   0 0 0 0 0 0 0 0 61 61 42302.47 90261.18 0.0 0 0.0 0.0 0.0 Y     N N N N N     N     Y APCMS ErCA N N 42302.47 90261.18   Bef. S/A approved ER paid 11,637.33 backpay & pd. 1022 to TmstPension.2/29/96 7 former ees recd. 2735.55 ea in a non bd.s/a. of remaining NLRB charges and WARN Act claim. 3/11/96 WARN Act claims by CP the Loc. recd. 59,475. See Notes Section of case card Satis      
01-CA-28518-001 0 N Infrm UniWr Regn N                   43 42 45000.0 44801.2           Y     N N N N N     N     Y APCMS ErCA N N 45000.0 44801.2     Satis      
01-CA-28558-001 0 N Infrm AllPW Regn N                   3 3 389.36 389.36           Y 1993-09-01   N N N N N     N     Y Other ErCA N N       other - union didn't request that changes be rescinded and Employer provided informaiton. In add'n to backpay to disc., E reimbursed Union's health plan $61,389.32 Satis      
01-CA-28590-001 0 N BOC Cmpli Regn N   10 3   7         45 45 88152.25 88152.25           Y 2000-01-24   N N N N N     N     Y InCon ErCA N N 88152.25 88152.25   Parties agreed to contract but final contract must be printed for final signature Satis      

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE cl_c_closed_case_report(c_case_number VARCHAR, action_sequence BIGINT, washington_approval VARCHAR, compliance_type VARCHAR, closing_type VARCHAR, complaint VARCHAR, enforcement_recommend VARCHAR, contempt_recommended_type VARCHAR, emprein_num_discrim BIGINT, emprein_num_accept BIGINT, emprein_num_waiving BIGINT, emprein_num_decline BIGINT, emprein_num_pref_list BIGINT, unionres_num_hall_rights BIGINT, unionres_obj_with BIGINT, unionres_hired BIGINT, back_number_made_whole BIGINT, back_total_num_rcv BIGINT, back_total_amount_due DOUBLE, back_total_employer DOUBLE, back_total_union DOUBLE, fees_num_individuals BIGINT, fees_total_due DOUBLE, fees_total_employers DOUBLE, fees_total_union DOUBLE, other_post_notice VARCHAR, other_company_post DATE, other_union_post DATE, other_withdraw_assistance VARCHAR, other_withdraw_notice VARCHAR, other_disestablish VARCHAR, other_disestablish_notice VARCHAR, other_end_picketing VARCHAR, other_end_picketing_date DATE, other_end_picketing_return BIGINT, other_end_stoppage VARCHAR, other_end_stoppage_date DATE, other_end_stoppage_return BIGINT, other_bargain VARCHAR, other_bargain_status VARCHAR, backpay_control_code VARCHAR, back_installment_flag VARCHAR, court_costs VARCHAR, court_costs_amount DOUBLE, court_costs_collected DOUBLE, check_forwarded_finance DATE, other_remedies VARCHAR, cmp_cp_position VARCHAR, agent VARCHAR, regional_attorney VARCHAR, regional_director VARCHAR);