c_trailer

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ case_number trailer_date date_last_action allegations_adjusted settlement approval_requested number_reinstated number_w_reinstated number_d_reinstated number_p_list number_restored number_withdrawn_employment number_rcu_employed number_allegations number_made_whole number_receiving_back_pay total_amt amt_pd_co amt_pd_un back_pay_control f_installment number_rcu_dues total_comp total_pd_co total_pd_un dues_control remedy date_end_picket date_end_work_stop number_employs_picket number_employes_stop number_to_be_reinst related_combined_code related_key_case_number
1 1 08-CA-022188-001 1990-07-31 1990-07-31 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0           0    
2 2 08-CA-022189-001 1989-11-30 1989-11-30 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0           0    
3 3 08-CA-022192-001 1990-01-31 1990-01-31 9   0 0 1 0 0 0 0 0 1 1 1 1400 1400 0 2   0 0 0   0           1    
4 4 08-CA-022193-001 1990-05-08 1990-05-08 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01         0    
5 5 08-CA-022197-001 1989-12-26 1989-12-26 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0    
6 6 08-CA-022201-001 1989-11-30 1989-11-30 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0           0    
7 7 08-CA-022202-001 1990-03-22 1990-03-22 9   0 0 2 0 0 0 0 0 1 2 2 5000 5000 0 2   0 0 0   0           2    
8 8 08-CA-022206-001 1990-05-16 1990-05-16 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01         0    
9 9 08-CA-022207-001 1991-12-03 1991-12-03 41   0 0 6 0 0 0 0 0 1 6 6 26739 26739 0 2   0 0 0   0 17         6    
10 10 08-CA-022209-001 1990-09-27 1990-09-27 9   0 20 2 0 0 0 0 0 1 22 22 22000 22000 0 2   0 0 0   0 16         22    
11 11 08-CA-022211-001 1989-12-26 1989-12-26 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0    
12 12 08-CA-022213-001 1989-12-13 1989-12-13 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0    
13 13 08-CA-022217-001 1989-12-14 1989-12-14 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0    
14 14 08-CA-022218-001 1991-02-21 1991-02-21 57   0 0 3 0 0 0 0 0 1 3 3 2150 2150 0 2   0 0 0   0 17         3    
15 15 08-CA-022230-001 1990-01-26 1990-01-26 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0    
16 16 08-CA-022232-001 1989-12-29 1989-12-29 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0    
17 17 08-CA-022233-001 1990-06-15 1990-06-15 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01         0    
18 18 08-CA-022237-001 1989-12-29 1989-12-29 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0    
19 19 08-CA-022241-001 1989-12-27 1989-12-27 57   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0           0    
20 20 08-CA-022243-001 1990-03-27 1990-03-27 9   0 6 0 1 6 0 0 0 1 12 12 19000 19000 0 2   0 0 0   0 16         12    
21 21 08-CA-022246-001 1989-12-05 1989-12-05 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0           0    
22 22 08-CA-022248-001 1990-04-24 1990-04-24 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 16         0    
23 23 08-CA-022254-001 1991-02-27 1991-02-27 9   0 1 0 0 0 0 0 0 1 1 1 2576 2576 0 2   0 0 0   0           1    
24 24 08-CA-022262-001 1993-06-28 1993-06-28 33   0               1           0 0         0 01              
25 25 08-CA-022266-001 1990-03-07 1990-03-07 9   0 0 0 0 0 0 0 0 1 1 1 507 507 0 2   0 0 0   0           0    
26 26 08-CA-022267-001 1990-02-22 1990-02-22 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0    
27 27 08-CA-022268-001 1990-01-05 1990-01-05 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0           0    
28 28 08-CA-022269-001 1990-07-20 1990-07-20 9   0 0 3 0 0 0 0 0 1 3 3 10000 10000 0 2   0 0 0   0           3    
29 29 08-CA-022280-001 1990-02-27 1990-02-27 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0           0    
30 30 08-CA-022282-001 1990-10-24 1990-10-24 41   0 0 3 0 0 0 0 0 1 3 3 6000 6000 0 2   0 0 0   0 16         3    
31 31 08-CA-022284-001 1989-12-19 1989-12-19 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0    
32 32 08-CA-022286-001 1990-01-05 1990-01-05 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0    
33 33 08-CA-022286-002 1990-01-05 1990-01-05 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0 Y 08-CA-022286-001
34 34 08-CA-022288-001 1991-05-16 1991-05-16 25   0 0 8 0 0 0 0 0 1 10 10 20000 20000 0 2 0 0 0 0   0 01         8    
35 35 08-CA-022289-001 1990-02-12 1990-02-12 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0           0    
36 36 08-CA-022300-001 1990-05-01 1990-05-01 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01         0    
37 37 01-CA-007643-001 1985-12-31 1985-12-31 41   0 0 0 0 0 0 0 0 1 17 17 25000 1979 0 2 0 0 0 0   0 16     0 0 17    
38 38 01-CA-007837-001 1985-12-31 1985-12-31 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 16     0 0 0 Y  
39 39 01-CA-007903-001 1985-12-31 1985-12-31 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 16     0 0 0 Y  
40 40 01-CA-008742-001 1986-09-24 1986-09-24 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 97     0 0 0    
41 41 01-CA-010237-001 1984-06-20 1984-06-20 9   0 0 0 6 0 0 0 0 1 6 6 13869 4449 0 2 0 0 0 0   0 10     0 0 6    
42 42 01-CA-010348-001 1986-08-08 1986-08-08 41   0 0 0 0 29 0 0 0 1 29 29 480000 160000 0 2 0 0 0 0   0 97     0 0 29    
43 43 01-CA-010379-001 1984-06-20 1984-06-20 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0 Y  
44 44 01-CA-010381-001 1984-06-20 1984-06-20 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0 Y  
45 45 01-CA-010522-001 1984-06-20 1984-06-20 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0 Y  
46 46 01-CA-010585-001 1991-12-05 1991-12-05 1   0               1           0           0                
47 47 01-CA-011491-001 1988-05-31 1988-05-31 41   0 0 0 11 0 0 0 0 1 85 0 578493 0 0 0   0 0 0   0 17         11    
48 48 01-CA-011524-001 1985-12-05 1985-12-05 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 97     0 0 0    
49 49 01-CA-011628-001 1987-06-29 1987-06-29 33   0 2 0 8 0 0 0 0 1 45 45 319418 319418 0 2 0 0 0 0   0 17     0 0 10    
50 50 01-CA-011684-001 1985-12-11 1985-12-11 9   0 0 0 0 0 0 0 0 1 2 0 51303 0 0 0 0 0 0 0   0 97     0 0 0    
51 51 01-CA-011733-001 1984-11-28 1984-11-28 41   0 1 0 1 0 0 0 0 1 2 2 12884 1798 0 2 0 0 0 0   0 17     0 0 2    
52 52 01-CA-012015-001 1984-08-29 1984-08-29 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 12 1702 1702   2 10     0 0 0    
53 53 01-CA-012030-001 1985-12-11 1985-12-11 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 97     0 0 0 Y 01-CA-011684-001
54 54 01-CA-012102-001 1984-08-29 1984-08-29 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-012015-001
55 55 01-CA-012137-001 1984-08-29 1984-08-29 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-012015-001
56 56 01-CA-012264-001 1985-04-04 1985-04-04 41   0 0 0 1 0 0 0 0 1 2 2 16000 16000 0 2 0 0 0 0   0 10     0 0 1    
57 57 01-CA-012325-001 1987-04-16 1987-04-16 33   0 0 0 31 0 0 0 0 1 31 31 149594 149594 0 2 0 0 0 0   0 01     0 0 31    
58 58 01-CA-012326-001 1987-04-16 1987-04-16 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0 Y  
59 59 01-CA-012370-001 1985-04-04 1985-04-04 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-012264-001
60 60 01-CA-012507-001 1985-12-11 1985-12-11 9   0 0 0 0 0 0 0 0 1 1 1 1200 1200 0 2 0 0 0 0   0 97     0 0 0    
61 61 01-CA-012508-001 1986-07-23 1986-07-23 41   0 0 0 0 9 0 0 0 1 9 0 13231 0 0 0 0 0 0 0   0 01     0 0 9    
62 62 01-CA-012643-001 1987-11-20 1987-11-20 41   0 0 0 54 0 0 0 0 1 54 54 125503 125503 0 2 0 0 0 0   0 17         54    
63 63 01-CA-012715-001 1991-09-24 1991-09-24 9   0 0 0 0 0 0 0 0 1 2 2 34823 33500 0 2   0 0 0   0 01         0    
64 64 01-CA-012812-001 1987-11-20 1987-11-20 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 17         0 Y  
65 65 01-CA-012838-001 1985-12-26 1985-12-26 17   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0    
66 66 01-CA-012958-001 1987-06-29 1987-06-29 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 17     0 0 0 Y  
67 67 01-CA-012975-001 1986-04-29 1986-04-29 33   0 0 0 0 0 0 0 0 1 256 256 750000 750000 0 2 0 0 0 0   0 01     0 0 0    
68 68 01-CA-012978-001 1986-04-29 1986-04-29 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0 Y  
69 69 01-CA-013014-001 1984-12-12 1984-12-12 9   0 1 0 3 0 0 0 0 1 5 5 24394 24394 0 2 0 0 0 0   0 10     0 0 4    
70 70 01-CA-013016-001 1988-05-31 1988-05-31 41   0 0 0 11 0 0 0 0 1 85 0 578493 0 0 0   0 0 0   0 17         11    
71 71 01-CA-013017-001 1988-05-31 1988-05-31 41   0 0 0 11 0 0 0 0 1 85 0 578493 0 0 0   0 0 0   0 01         11    
72 72 01-CA-013018-001 1988-05-31 1988-05-31 41   0 0 0 11 0 0 0 0 1 85 0 578493 0 0 0   0 0 0   0 17         11    
73 73 01-CA-013019-001 1985-12-26 1985-12-26 17   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-012838-001
74 74 01-CA-013057-001 1984-12-12 1984-12-12 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-013014-001
75 75 01-CA-013167-001 1985-02-22 1985-02-22 9   0 0 0 0 0 0 0 0 1 8 0 22326 0 0 0 0 0 0 0   0 97     0 0 8    
76 76 01-CA-013208-001 1983-12-13 1983-12-13 41   0 0 0 1 0 0 0 0 1 1 1 10543 10543 0 2 0 0 0 0   0 16     0 0 1    
77 77 01-CA-013230-001 1984-12-12 1984-12-12 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-013014-001
78 78 01-CA-013282-001 1984-12-12 1984-12-12 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-013014-001
79 79 01-CA-013425-001 1984-12-12 1984-12-12 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-013014-001
80 80 01-CA-013458-001 1987-01-13 1987-01-13 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0    
81 81 01-CA-013486-001 1984-12-12 1984-12-12 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-013014-001
82 82 01-CA-013497-001 1987-11-20 1987-11-20 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 17         0 Y  
83 83 01-CA-013578-001 1987-01-13 1987-01-13 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0 Y  
84 84 01-CA-013586-001 1986-01-13 1986-01-13 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0    
85 85 01-CA-013587-001 1986-01-13 1986-01-13 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-013586-001
86 86 01-CA-013588-001 1986-01-13 1986-01-13 17   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-013586-001
87 87 01-CA-013743-001 1986-01-13 1986-01-13 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-013586-001
88 88 01-CA-013753-001 1986-01-29 1986-01-29 17   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0    
89 89 01-CA-013868-001 1986-01-13 1986-01-13 57   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-013586-001
90 90 01-CA-013882-001 1985-04-04 1985-04-04 9   0 3 0 2 0 0 0 0 1 12 11 45207 45207 0 2 0 0 0 0   0 17     0 0 5    
91 91 01-CA-013913-001 1987-11-20 1987-11-20 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 17         0 Y  
92 92 01-CA-013985-001 1986-01-29 1986-01-29 17   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0    
93 93 01-CA-014050-001 1986-08-26 1986-08-26 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0    
94 94 01-CA-014053-001 1986-01-29 1986-01-29 17   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0    
95 95 01-CA-014071-001 1986-01-13 1986-01-13 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 10     0 0 0 Y 01-CA-013586-001
96 96 01-CA-014085-001 1986-08-26 1986-08-26 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0    
97 97 01-CA-014086-001 1986-08-26 1986-08-26 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0 Y  
98 98 01-CA-014204-001 1985-11-12 1985-11-12 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0    
99 99 01-CA-014224-001 1987-12-08 1987-12-08 9   0 0 0 0 28 0 0 0 1 28 8 100000 18522 0 2 0 0 0 0   0 16         28    
100 100 01-CA-014273-001 1986-08-26 1986-08-26 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01     0 0 0 Y  

Next page

CREATE TABLE "c_trailer" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [trailer_date] TEXT,
   [date_last_action] TEXT,
   [allegations_adjusted] INTEGER,
   [settlement] TEXT,
   [approval_requested] INTEGER,
   [number_reinstated] INTEGER,
   [number_w_reinstated] INTEGER,
   [number_d_reinstated] INTEGER,
   [number_p_list] INTEGER,
   [number_restored] INTEGER,
   [number_withdrawn_employment] INTEGER,
   [number_rcu_employed] INTEGER,
   [number_allegations] INTEGER,
   [number_made_whole] INTEGER,
   [number_receiving_back_pay] INTEGER,
   [total_amt] INTEGER,
   [amt_pd_co] INTEGER,
   [amt_pd_un] INTEGER,
   [back_pay_control] INTEGER,
   [f_installment] TEXT,
   [number_rcu_dues] INTEGER,
   [total_comp] INTEGER,
   [total_pd_co] INTEGER,
   [total_pd_un] INTEGER,
   [dues_control] INTEGER,
   [remedy] TEXT,
   [date_end_picket] TEXT,
   [date_end_work_stop] TEXT,
   [number_employs_picket] INTEGER,
   [number_employes_stop] INTEGER,
   [number_to_be_reinst] INTEGER,
   [related_combined_code] TEXT,
   [related_key_case_number] TEXT
);