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
101 101 01-CA-014274-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  
102 102 01-CA-014347-001 1985-04-04 1985-04-04 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  
103 103 01-CA-014383-001 1985-04-04 1985-04-04 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  
104 104 01-CA-014433-001 1984-08-14 1984-08-14 1   0               1           0 0         0       0 0      
105 105 01-CA-014443-001 1985-04-04 1985-04-04 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  
106 106 01-CA-014475-001 1987-12-08 1987-12-08 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0 Y  
107 107 01-CA-014495-001 1983-12-28 1983-12-28 9   0 2 0 1 0 0 0 0 1 3 0 107228 107228 0 2 0 0 0 0   0 97     0 0 3    
108 108 01-CA-014495-002 1983-12-28 1983-12-28 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 Y 01-CA-014495-001
109 109 01-CA-014526-001 1983-12-28 1983-12-28 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 Y 01-CA-014495-001
110 110 01-CA-014600-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    
111 111 01-CA-014619-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
112 112 01-CA-014624-001 1986-05-30 1986-05-30 41   0 0 0 0 0 0 0 0 1 4 4 40972 40972 0 2 0 0 0 0   0 97     0 0 0    
113 113 01-CA-014700-001 1987-12-08 1987-12-08 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0 Y  
114 114 01-CA-014728-001 1985-04-04 1985-04-04 25   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  
115 115 01-CA-014748-001 1983-11-30 1983-11-30 9   0 0 0 0 0 1 1 0 1 1 1 40050 0 40050 1 0 0 0 0   0 10     0 0 0    
116 116 01-CA-014788-001 1987-12-08 1987-12-08 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 16         0 Y  
117 117 01-CA-014925-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 17     0 0 0 Y  
118 118 01-CA-014998-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
119 119 01-CA-015141-001 1986-06-30 1986-06-30 57   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 97     0 0 0    
120 120 01-CA-015206-001 1986-08-18 1986-08-18 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 17     0 0 0    
121 121 01-CA-015416-001 1983-12-15 1983-12-15 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 97     0 0 0    
122 122 01-CA-015433-001 1986-06-30 1986-06-30 57   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  
123 123 01-CA-015489-001 1986-08-18 1986-08-18 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 17     0 0 0    
124 124 01-CA-015560-001 1984-02-29 1984-02-29 33   0 0 0 0 0 0 0 0 1 3 3 9713 9713 0 2 0 0 0 0   0 17     0 0 0    
125 125 01-CA-015846-001 1993-02-25 1993-02-25 25   0 0 0 35 0 0 0 0 1 35 35 100000 100000 0 2   0 0 0   0 01         35    
126 126 01-CA-015902-001 1993-02-25 1993-02-25 25   0 0 0 35 0 0 0 0 1 35 35 100000 100000 0 2   0 0 0   0 01         35    
127 127 01-CA-015922-001 1985-04-20 1985-04-20 1   0               1           0 0         0       0 0      
128 128 01-CA-016026-001 1993-02-25 1993-02-25 25   0 0 0 35 0 0 0 0 1 35 35 100000 100000 0 2   0 0 0   0 01         35    
129 129 01-CA-016082-001 1985-12-03 1985-12-03 17   0 0 0 1 0 0 0 0 1 1 1 24353 24353 0 2 0 0 0 0   0 10     0 0 1    
130 130 01-CA-016142-001 1984-02-24 1984-02-24 1   0 1 0 4 0 0 0 0 1 25 25 50000 41000 0 2 0 0 0 0   0 17     0 0 5    
131 131 01-CA-016152-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
132 132 01-CA-016163-001 1986-08-18 1986-08-18 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 17     0 0 0    
133 133 01-CA-016183-001 1984-02-24 1984-02-24 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 01-CA-016142-001
134 134 01-CA-016198-001 1986-06-30 1986-06-30 57   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  
135 135 01-CA-016314-001 1983-12-15 1983-12-15 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 97     0 0 0    
136 136 01-CA-016322-001 1993-02-25 1993-02-25 25   0 0 0 35 0 0 0 0 1 35 0 100000 100000 0 2   0 0 0   0 01         35    
137 137 01-CA-016322-002 1993-02-25 1993-02-25 25   0 0 0 35 0 0 0 0 1 35 35 100000 100000 0 2   0 0 0   0 01         35    
138 138 01-CA-016532-001 1987-01-20 1987-01-20 9   0 6 0 0 0 0 0 0 1 6 6 100000 31500 0 2 0 0 0 0   0 97     0 0 6    
139 139 01-CA-016536-001 1984-02-24 1984-02-24 41   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 01-CA-016142-001
140 140 01-CA-016548-001 1985-06-26 1985-06-26 9   0               1           0 0         0 01     0 0      
141 141 01-CA-016597-001 1987-01-20 1987-01-20 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 Y  
142 142 01-CA-016694-001 1986-08-18 1986-08-18 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 17     0 0 0    
143 143 01-CA-016795-001 1987-01-20 1987-01-20 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 Y  
144 144 01-CA-016806-001 1984-02-24 1984-02-24 1   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 01-CA-016142-001
145 145 01-CA-016890-001 1987-02-06 1987-02-06 41   0 0 0 0 0 0 0 0 1 100 0 377000 0 0 0 0 0 0 0   0 17     0 0 0    
146 146 01-CA-016893-001 1984-04-11 1984-04-11 9   0 0 0 1 0 0 0 0 1 3 3 575 575 0 2 0 0 0 0   0 10     0 0 1    
147 147 01-CA-016896-001 1984-04-11 1984-04-11 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-016893-001
148 148 01-CA-016897-001 1984-04-11 1984-04-11 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-016893-001
149 149 01-CA-016898-001 1984-04-11 1984-04-11 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-016893-001
150 150 01-CA-016917-001 1985-06-26 1985-06-26 25   0               1           0 0         0 01     0 0      
151 151 01-CA-017038-001 1986-08-18 1986-08-18 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 17     0 0 0    
152 152 01-CA-017048-001 1984-10-30 1984-10-30 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 2000 2000   2 10     0 0 0    
153 153 01-CA-017113-001 1984-05-31 1984-05-31 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 01         0    
154 154 01-CA-017212-001 1985-06-20 1985-06-20 9   0               1           0 0         0 01     0 0      
155 155 01-CA-017255-001 1987-11-25 1987-11-25 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 01         0    
156 156 01-CA-017298-001 1986-02-27 1986-02-27 33   0 0 0 0 0 0 0 0 1 13 13 13551 13551 0 2 0 0 0 0   0 01     0 0 0    
157 157 01-CA-017321-001 1989-05-24 1989-05-24 41   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 17         0    
158 158 01-CA-017394-001 1993-02-25 1993-02-25 25   0 0 0 35 0 0 0 0 1 35 35 100000 100000 0 2   0 0 0   0 01         35    
159 159 01-CA-017408-001 1988-07-20 1988-07-20 1   0               1           0           0                
160 160 01-CA-017415-001 1989-05-24 1989-05-24 41   0 0 0 0 0 0 0 0 1 3 0 3642 3642 0 2   0 0 0   0 16         3    
161 161 01-CA-017436-001 1986-01-27 1986-01-27 33   0 1 0 0 0 0 0 0 1 1 1 954 954 0 2 0 0 0 0   0 10     0 0 1    
162 162 01-CA-017456-001 1984-03-13 1984-03-13 1   0 0 0 1 0 0 0 0 1 1 1 2077 2077 0 2 0 0 0 0   0 97     0 0 1    
163 163 01-CA-017469-001 1986-01-27 1986-01-27 33   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-017436-001
164 164 01-CA-017534-001 1993-02-25 1993-02-25 25   0 0 0 35 0 0 0 0 1 35 35 100000 100000 0 2   0 0 0   0 01         35    
165 165 01-CA-017590-001 1985-11-05 1985-11-05 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    
166 166 01-CA-017599-001 1985-12-03 1985-12-03 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-016082-001
167 167 01-CA-017670-001 1986-08-08 1986-08-08 9   0 0 0 0 1 0 0 0 1 1 1 1900 0 0 0 0 0 0 0   0 01     0 0 1    
168 168 01-CA-017803-001 1989-05-24 1989-05-24 41   0 0 0 0 0 0 0 0 1 3 0 3642 3642 0 2   0 0 0   0 16         3    
169 169 01-CA-017834-001 1985-10-02 1985-10-02 9   0 0 0 6 0 0 0 0 1 6 6 7372 7372 0 2 0 0 0 0   0 97     0 0 6    
170 170 01-CA-017906-001 1985-06-20 1985-06-20 25   0 0 0 0 0 0 0 0 1 83 83 15408 15408 0 2 0 0 0 0   0 10     0 0 0    
171 171 01-CA-017917-001 1996-01-29 1996-01-29 41   0 0 0 20 0       1 61 57 375000 375000 0 2           0 16         20    
172 172 01-CA-017954-001 1986-01-29 1986-01-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    
173 173 01-CA-017967-001 1984-02-01 1984-02-01 9   0 1 0 0 0 1 0   1     0 0 0 0 0         0 0     0 97 1    
174 174 01-CA-017990-001 1986-01-27 1986-01-27 33   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-017436-001
175 175 01-CA-018163-001 1984-05-09 1984-05-09 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 0     0 97 0    
176 176 01-CA-018229-001 1984-04-20 1984-04-20 1   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 01         0    
177 177 01-CA-018259-001 1986-01-27 1986-01-27 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-017436-001
178 178 01-CA-018278-001 1985-02-14 1985-02-14 41   0 0 1 0 0 0 0 0 1 1 1 1560 840 0 2 0 0 0 0   0 97     0 0 1    
179 179 01-CA-018292-001 1985-09-25 1985-09-25 41   0 0 0 0 0 0 0 0 1 1 1 10 10 0 2 0 0 0 0   0 17     0 0 0    
180 180 01-CA-018293-001 1986-01-27 1986-01-27 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-017436-001
181 181 01-CA-018305-001 1986-07-16 1986-07-16 9   0 0 0 1 0 0 0 0 1 1 1 20000 20000 0 2 0 0 0 0   0 01     0 0 1    
182 182 01-CA-018309-001 1984-05-09 1984-05-09 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 0     0 9700 0 Y 01-CA-018163-001
183 183 01-CA-018362-001 1984-09-28 1984-09-28 9   0 0 0 1 0 0 0 0 1 1 1 853 853 0 2 0 0 0 0   0 16     0 0 1    
184 184 01-CA-018408-001 1987-07-23 1987-07-23 33   0 0 0 0 0 0 0 0 1 4 4 5644 5644 0 2 0 0 0 0   0 01     0 0 0    
185 185 01-CA-018426-001 1987-07-23 1987-07-23 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  
186 186 01-CA-018431-001 1985-11-01 1985-11-01 9   0 4 0 0 0 0 0 0 1 4 4 1549 1549 0 2 0 0 0 0   0 97     0 0 4    
187 187 01-CA-018522-001 1985-11-12 1985-11-12 41   0 4 0 0 23 0 0 0 1 27 27 175000 175000 0 2 0 0 0 0   0 10     0 0 27    
188 188 01-CA-018553-001 1983-12-12 1983-12-12 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 0     0 97 0    
189 189 01-CA-018592-001 1983-11-16 1983-11-16 25   0 4 0 0 0 0 0 0 1 4 4 6500 6500 0 2 0 0 0 0   0 10     0 0 4    
190 190 01-CA-018592-002 1983-11-16 1983-11-16 25   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-018592-001
191 191 01-CA-018592-003 1983-11-16 1983-11-16 25   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-018592-001
192 192 01-CA-018592-004 1983-11-16 1983-11-16 25   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-018592-001
193 193 01-CA-018619-001 1996-07-17 1996-07-17 41   0 0 126 0 0       1 126 126 10000000 745483 0 2           0 16         126    
194 194 01-CA-018651-001 1985-12-04 1985-12-04 9   0 0 1 0 0 0 0 0 1 1 1 1000 1000 0 2 0 0 0 0   0 97     0 0 1    
195 195 01-CA-018673-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 10     0 0 0 Y 01-CA-018522-001
196 196 01-CA-018674-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 10     0 0 0 Y 01-CA-018522-001
197 197 01-CA-018681-001 1986-01-08 1986-01-08 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    
198 198 01-CA-018786-001 1985-09-25 1985-09-25 41   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 01-CA-018292-001
199 199 01-CA-018803-001 1984-09-28 1984-09-28 9   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 01-CA-018362-001
200 200 01-CA-018843-001 1985-12-27 1985-12-27 33   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0   0 97     0 0 0    

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
);