cl_c_closed_case_report

126,619 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ 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
1 1 01-CA-19224-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N         Satis      
2 2 01-CA-19567-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
3 3 01-CA-19690-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
4 4 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      
5 5 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      
6 6 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      
7 7 01-CA-19958-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
8 8 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      
9 9 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      
10 10 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      
11 11 01-CA-20283-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
12 12 01-CA-20291-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
13 13 01-CA-20304-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
14 14 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      
15 15 01-CA-20508-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
16 16 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      
17 17 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      
18 18 01-CA-21560-001 0 N CtOrd NoCmp Regn N                                     N     N N N N N     N     N     N N                
19 19 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
20 20 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
21 21 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      
22 22 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      
23 23 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      
24 24 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
25 25 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      
26 26 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
27 27 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
28 28 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      
29 29 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
30 30 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
31 31 01-CA-24863-001 0 N Infrm AllPW Regn N   1 0 1           18 18 6000.0 6000.0           Y 1988-09-23T00:00:00   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      
32 32 01-CA-24883-001 0 N Infrm AllPW Regn N   1 0 1           18 18 6000.0 6000.0           Y 1988-09-23T00:00:00   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      
33 33 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
34 34 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
35 35 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
36 36 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
37 37 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
38 38 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
39 39 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        
40 40 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      
41 41 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        
42 42 01-CA-25736-001 0 N CtOrd PtCmp Regn Y                       94785.0 3000.0           Y 1989-05-30T00:00:00   N N N N N     N     Y APCMS ErCA N N         Satis      
43 43 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      
44 44 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        
45 45 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-01T00:00:00   N N N N N     N     N   ErCA N N         Satis      
46 46 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      
47 47 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.        
48 48 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-08T00:00:00   N N N N N     N     N   ErCA N N         Satis     /s/ Rosemary Pye
49 49 01-CA-26098-001 0 N Infrm UniWr   N                   10 10 810.45 810.45           Y 1989-06-14T00:00:00   N N N N N     N     N   ErCA N N 810.45 810.45     Satis      
50 50 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        
51 51 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.        
52 52 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      
53 53 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      
54 54 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        
55 55 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        
56 56 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      
57 57 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      
58 58 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      
59 59 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      
60 60 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-03T00:00:00   N N N N N     N     N     N N         Satis      
61 61 01-CA-26936-001 0 N BOU NoCmp Regn Y                                     Y     N N N N N     N     Y APCMS   N N         Satis      
62 62 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      
63 63 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      
64 64 01-CA-27142-001 0 Y CtOrd NoCmp Regn Y                         0.0           Y 1992-04-11T00:00:00   N N N N N     N     Y APCMS   N N         Satis      
65 65 01-CA-27197-001 0 N Infrm AllPW   N                                     Y 1990-08-05T00:00:00   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      
66 66 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        
67 67 01-CA-27322-001 0 N BOC NoCmp Regn Y                                     N     N N N N N     N     N     N N         NoSat      
68 68 01-CA-27335-001 0 N Infrm AllPW Regn N   4 0 4           4 4 5000.0 5000.0           Y 1993-09-24T00:00:00   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      
69 69 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      
70 70 01-CA-27385-001 0 N BOC NoCmp Regn Y                                     N     N N N N N     N     N     N N         NoSat      
71 71 01-CA-27386-001 0 N BOC NoCmp Regn Y                                     N     N N N N N     N     N     N N         NoSat      
72 72 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      
73 73 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      
74 74 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      
75 75 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      
76 76 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      
77 77 01-CA-27731-001 0 N CtOrd PtCmp Regn Y                                     Y     N N N N N     N     Y APCMS   N N         Satis      
78 78 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      
79 79 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      
80 80 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      
81 81 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        
82 82 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      
83 83 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      
84 84 01-CA-27953-001 0 N BOC NoCmp Regn Y                                     N     N N N N N     N     N     N N         NoSat      
85 85 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      
86 86 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      
87 87 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      
88 88 01-CA-28315-001 0 N BOU NoCmp Regn N                                     N     N N N N N     N     Y APCMS   N N                
89 89 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-19T00:00:00   N N N N N     N     N   ErCA N N         Satis      
90 90 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-26T00:00:00   N N N N N     N     N   ErCA N N       Expungement Satis      
91 91 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      
92 92 01-CA-28409-001 0 N BOU NoCmp Regn N                                     N     N N N N N     N     Y APCMS   N N                
93 93 01-CA-28418-001 0 N BOC Cmpli Regn N   10 3   7         45 45 88152.25 88152.25           Y 2000-01-24T00:00:00   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      
94 94 01-CA-28466-001 0 N Infrm AllPW Regn N                                     Y 1993-05-19T00:00:00   N N N N N     N     N     N N         Satis      
95 95 01-CA-28474-001 0 N BOU PtCmp Regn Y                                     N     N N N N N     N     Y APCMS   N N                
96 96 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      
97 97 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      
98 98 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      
99 99 01-CA-28558-001 0 N Infrm AllPW Regn N                   3 3 389.36 389.36           Y 1993-09-01T00:00:00   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      
100 100 01-CA-28590-001 0 N BOC Cmpli Regn N   10 3   7         45 45 88152.25 88152.25           Y 2000-01-24T00:00:00   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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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