r_consolid
Download this data as a CSV Spreadsheet (All Rows)
Link | rowid ▼ | case_number | consolidation_date | consol_id | key_consol_case_reg | key_consol_case_type | key_consol_case_docket | key_consol_case_suffix | sub_consol_case_reg | sub_consol_case_type | sub_consol_case_docket | sub_consol_case_suffix | consolidation_type | consolidation_code | consolidation_stage | date_severed | severance_id | severance_type | severance_code | severance_stage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
201 | 201 | 04-RC-016505 | 1987-03-23 | 4 | RC | 16504 | - | 03 | 01 | |||||||||||
202 | 202 | 04-RC-016561 | 1987-10-27 | 4 | CA | 16768 | 001 | 5 | 02 | 01 | ||||||||||
203 | 203 | 04-RC-016613 | 1987-07-24 | 4 | RC | 16612 | - | 03 | 01 | |||||||||||
204 | 204 | 04-RC-016615 | 1987-07-24 | 4 | RC | 16610 | - | 03 | 01 | |||||||||||
205 | 205 | 04-RC-016634 | 1987-08-28 | 4 | RC | 16633 | - | 03 | 01 | |||||||||||
206 | 206 | 04-RC-016683 | 1988-04-21 | 4 | CA | 16977 | 001 | 5 | 03 | |||||||||||
207 | 207 | 04-RC-016683 | 1988-08-12 | 4 | CA | 16977 | 001 | 5 | 03 | |||||||||||
208 | 208 | 04-RC-016705 | 1988-10-05 | 4 | CA | 17173 | 001 | 5 | 03 | 01 | ||||||||||
209 | 209 | 04-RC-016705 | 1988-11-21 | 4 | CA | 17173 | 001 | 5 | 03 | 01 | ||||||||||
210 | 210 | 04-RC-016716 | 1989-03-23 | 4 | CA | 17510 | 001 | 5 | 02 | 02 | ||||||||||
211 | 211 | 04-RC-016845 | 1989-01-23 | 4 | RC | 16762 | - | 03 | 01 | |||||||||||
212 | 212 | 04-RC-016907 | 1989-03-14 | 4 | CA | 17797 | 001 | 5 | 02 | 02 | ||||||||||
213 | 213 | 04-RC-016951 | 1989-02-06 | 4 | RC | 16950 | - | 03 | 01 | |||||||||||
214 | 214 | 04-RC-016952 | 1989-02-06 | 4 | RC | 16950 | - | 03 | 01 | |||||||||||
215 | 215 | 04-RC-016953 | 1989-02-06 | 4 | RC | 16950 | - | 03 | 01 | |||||||||||
216 | 216 | 04-RC-016958 | 1989-02-06 | 4 | RC | 16950 | - | 03 | 01 | |||||||||||
217 | 217 | 04-RC-016989 | 1989-08-28 | 4 | CA | 18021 | 001 | 5 | 02 | 02 | ||||||||||
218 | 218 | 04-RC-017021 | 1989-04-25 | 4 | RC | 17010 | - | 03 | 01 | |||||||||||
219 | 219 | 04-RC-017119 | 1989-09-07 | 4 | RC | 17118 | - | 03 | 01 | |||||||||||
220 | 220 | 04-RC-017126 | 1990-04-16 | 4 | CA | 18432 | 001 | 5 | 03 | |||||||||||
221 | 221 | 04-RC-017126 | 1990-08-10 | 4 | CA | 18432 | 001 | 5 | 03 | |||||||||||
222 | 222 | 04-RC-017171 | 1990-09-28 | 4 | CA | 18560 | 001 | 5 | 02 | 02 | ||||||||||
223 | 223 | 04-RC-017201 | 1990-08-03 | 4 | CA | 18542 | 001 | 5 | 02 | 02 | ||||||||||
224 | 224 | 04-RC-017225 | 1990-01-02 | 4 | RC | 17224 | - | 03 | 01 | |||||||||||
225 | 225 | 04-RC-017360 | 1990-05-22 | 4 | RC | 17350 | - | 03 | 01 | |||||||||||
226 | 226 | 04-RC-017361 | 1990-05-22 | 4 | RC | 17350 | - | 03 | 01 | |||||||||||
227 | 227 | 04-RC-017364 | 1990-05-29 | 4 | RC | 17363 | - | 03 | 01 | |||||||||||
228 | 228 | 04-RC-017366 | 1990-05-22 | 4 | RC | 17350 | - | 03 | 01 | |||||||||||
229 | 229 | 04-RC-017367 | 1990-05-22 | 4 | RC | 17350 | - | 03 | 01 | |||||||||||
230 | 230 | 04-RC-018062 | 1994-02-18 | 4 | CA | 21675 | 001 | 04 | RC | 18062 | 5 | 02 | 01 | |||||||
231 | 231 | 04-RC-018087 | 1993-11-04 | 4 | CA | 21582 | 001 | 04 | RC | 18087 | 5 | 03 | 13 | 1995-02-28 | D | 5 | 3 | 13 | ||
232 | 232 | 04-RC-018096 | 1994-01-28 | 4 | CA | 21694 | 001 | 04 | RC | 18096 | 5 | 02 | 02 | |||||||
233 | 233 | 04-RC-018159 | 1994-09-09 | 4 | CA | 22065 | 001 | 04 | RC | 18159 | 5 | 02 | 02 | |||||||
234 | 234 | 04-RC-018223 | 1994-04-01 | 4 | CA | 22302 | 001 | 04 | RC | 18223 | 5 | 02 | 02 | |||||||
235 | 235 | 04-RC-018226 | 1994-05-10 | 4 | CA | 22186 | 001 | 04 | RC | 18226 | 5 | 02 | 01 | |||||||
236 | 236 | 04-RC-018421 | 1994-08-03 | 4 | RC | 18418 | - | 03 | 02 | |||||||||||
237 | 237 | 04-RC-018421 | 1995-06-26 | 4 | RC | 18418 | - | 03 | 02 | |||||||||||
238 | 238 | 04-RC-018434 | 1994-08-16 | 4 | RC | 18419 | - | 03 | 02 | |||||||||||
239 | 239 | 04-RC-018485 | 1994-10-27 | 4 | RC | 18484 | - | 03 | 02 | |||||||||||
240 | 240 | 04-RC-018518 | 1995-04-28 | 4 | CA | 22548 | 001 | 04 | RC | 18518 | 5 | 02 | 02 | |||||||
241 | 241 | 04-RC-018573 | 1995-03-23 | 4 | RC | 18572 | - | 03 | 02 | |||||||||||
242 | 242 | 04-RC-018589 | 1995-03-23 | 4 | RC | 18572 | - | 03 | 02 | |||||||||||
243 | 243 | 04-RC-018871 | 1996-06-20 | 4 | RC | 18857 | - | 03 | 02 | |||||||||||
244 | 244 | 04-RC-019461 | 1999-02-26 | 4 | CA | 27442 | 001 | 04 | RC | 19461 | 5 | 02 | 01 | |||||||
245 | 245 | 04-RD-001295 | 1986-03-19 | 4 | RD | 1294 | - | 03 | 01 | |||||||||||
246 | 246 | 04-RD-001350 | 1987-02-25 | 4 | RD | 1349 | - | 03 | 01 | |||||||||||
247 | 247 | 04-RD-001415 | 1989-01-30 | 4 | CA | 17534 | 001 | 6 | 02 | 02 | ||||||||||
248 | 248 | 04-RD-001640 | 1993-11-05 | 4 | RC | 18241 | 04 | RD | 01640 | - | 02 | 01 | ||||||||
249 | 249 | 04-RM-001080 | 1984-02-21 | 4 | RC | 15553 | 04 | RM | 01080 | 02 | 01 | |||||||||
250 | 250 | 04-RM-001103 | 1985-06-20 | 4 | RM | 1101 | - | 03 | 01 | |||||||||||
251 | 251 | 04-RM-001128 | 1987-03-20 | 4 | RC | 16508 | - | 02 | 01 | |||||||||||
252 | 252 | 04-RM-001129 | 1987-04-07 | 4 | RC | 16530 | - | 02 | 01 | |||||||||||
253 | 253 | 04-RM-001210 | 1994-07-26 | 4 | RM | 1209 | - | 03 | 02 | |||||||||||
254 | 254 | 04-RM-001211 | 1994-07-26 | 4 | RM | 1209 | - | 03 | 02 | |||||||||||
255 | 255 | 04-RM-001212 | 1994-07-26 | 4 | RM | 1209 | - | 03 | 02 | |||||||||||
256 | 256 | 04-UC-000181 | 1984-01-06 | 4 | RC | 15514 | 04 | UC | 00181 | 02 | 01 | |||||||||
257 | 257 | 04-UC-000216 | 1987-01-08 | 4 | UC | 215 | - | 03 | 01 | |||||||||||
258 | 258 | 04-UC-000229 | 1987-12-30 | 4 | UC | 228 | - | 03 | 01 | |||||||||||
259 | 259 | 04-UC-000230 | 1987-12-30 | 4 | UC | 228 | - | 03 | 01 | |||||||||||
260 | 260 | 04-UC-000233 | 1988-03-11 | 4 | RC | 16727 | - | 02 | 01 | |||||||||||
261 | 261 | 04-UD-000256 | 1986-05-13 | 4 | RC | 16131 | - | 02 | 01 | |||||||||||
262 | 262 | 04-UD-000264 | 1986-10-24 | 4 | RD | 1338 | 04 | UD | 00264 | - | 03 | 01 | ||||||||
263 | 263 | 05-RC-011713 | 1982-05-06 | 5 | CA | 14069 | 001 | 05 | RC | 11713 | 02 | 01 | ||||||||
264 | 264 | 05-RC-012184 | 1984-03-16 | 5 | RC | 12179 | 05 | RC | 12184 | 02 | 01 | |||||||||
265 | 265 | 05-RC-012207 | 1984-04-27 | 5 | RC | 12202 | 05 | RC | 12207 | 02 | 01 | |||||||||
266 | 266 | 05-RC-012208 | 1984-04-27 | 5 | RC | 12202 | 05 | RC | 12208 | 02 | 01 | |||||||||
267 | 267 | 05-RC-012238 | 1984-06-01 | 5 | RC | 12237 | 05 | RC | 12238 | 02 | 01 | |||||||||
268 | 268 | 05-RC-012240 | 1986-04-11 | 5 | CA | 16608 | 001 | 5 | 03 | 01 | ||||||||||
269 | 269 | 05-RC-012240 | 1986-06-04 | 5 | CA | 16608 | 001 | 5 | 03 | 01 | ||||||||||
270 | 270 | 05-RC-012310 | 1985-08-05 | 5 | CA | 16660 | 001 | 5 | 03 | 04 | ||||||||||
271 | 271 | 05-RC-012344 | 1985-04-16 | 5 | CA | 16985 | 001 | 05 | RC | 12344 | 02 | 01 | ||||||||
272 | 272 | 05-RC-012364 | 1984-12-05 | 5 | RC | 12363 | 05 | RC | 12364 | 02 | 01 | |||||||||
273 | 273 | 05-RC-012378 | 1984-12-28 | 5 | RC | 12375 | 05 | RC | 12378 | 02 | 01 | |||||||||
274 | 274 | 05-RC-012388 | 1985-05-10 | 5 | CA | 17024 | 001 | 5 | 02 | |||||||||||
275 | 275 | 05-RC-012399 | 1985-02-13 | 5 | RC | 12398 | 05 | RC | 12399 | 02 | 01 | 1985-03-22 | D | 2 | 12 | |||||
276 | 276 | 05-RC-012414 | 1985-03-11 | 5 | RC | 12409 | 05 | RC | 12414 | 02 | 01 | |||||||||
277 | 277 | 05-RC-012431 | 1985-04-03 | 5 | RC | 12430 | 05 | RC | 12431 | 02 | 01 | |||||||||
278 | 278 | 05-RC-012455 | 1985-04-24 | 5 | RC | 12445 | 05 | RC | 12455 | 02 | 01 | |||||||||
279 | 279 | 05-RC-012481 | 1985-10-16 | 5 | CA | 17400 | 001 | 5 | 02 | 01 | ||||||||||
280 | 280 | 05-RC-012511 | 1985-09-25 | 5 | RC | 12505 | - | 03 | ||||||||||||
281 | 281 | 05-RC-012513 | 1985-08-27 | 5 | RC | 12512 | - | 03 | 01 | |||||||||||
282 | 282 | 05-RC-012538 | 1985-09-18 | 5 | RC | 12529 | - | 03 | 01 | |||||||||||
283 | 283 | 05-RC-012597 | 1986-01-31 | 5 | RC | 12596 | - | 03 | 01 | |||||||||||
284 | 284 | 05-RC-012601 | 1986-07-22 | 5 | CA | 17923 | 001 | 5 | 02 | 01 | ||||||||||
285 | 285 | 05-RC-012635 | 1986-09-15 | 5 | CA | 18074 | 001 | 5 | 02 | |||||||||||
286 | 286 | 05-RC-012641 | 1986-04-04 | 5 | RC | 12632 | - | 03 | 01 | 1986-05-05 | F | 3 | 12 | |||||||
287 | 287 | 05-RC-012730 | 1986-08-29 | 5 | RC | 12727 | - | 03 | 01 | |||||||||||
288 | 288 | 05-RC-012731 | 1986-08-29 | 5 | RC | 12727 | - | 03 | 01 | |||||||||||
289 | 289 | 05-RC-012735 | 1987-09-09 | 5 | RC | 12734 | - | 03 | 01 | |||||||||||
290 | 290 | 05-RC-012840 | 1987-01-23 | 5 | RC | 12835 | - | 03 | 01 | |||||||||||
291 | 291 | 05-RC-012874 | 1987-04-10 | 5 | RC | 12873 | - | 03 | 01 | |||||||||||
292 | 292 | 05-RC-012877 | 1987-04-10 | 5 | RC | 12873 | - | 03 | 01 | |||||||||||
293 | 293 | 05-RC-012900 | 1987-05-13 | 5 | RC | 12899 | - | 03 | 01 | |||||||||||
294 | 294 | 05-RC-012917 | 1987-06-12 | 5 | RC | 12889 | - | 03 | 01 | |||||||||||
295 | 295 | 05-RC-012924 | 1987-06-19 | 5 | RC | 12920 | - | 03 | 01 | |||||||||||
296 | 296 | 05-RC-012951 | 1988-06-08 | 5 | CA | 19331 | 001 | 5 | 03 | |||||||||||
297 | 297 | 05-RC-012951 | 1988-07-20 | 5 | CA | 19331 | 001 | 5 | 03 | |||||||||||
298 | 298 | 05-RC-013098 | 1988-08-03 | 5 | RC | 13089 | - | 03 | 02 | |||||||||||
299 | 299 | 05-RC-013153 | 1988-11-23 | 5 | RC | 13152 | - | 03 | 02 | |||||||||||
300 | 300 | 05-RC-013160 | 1988-12-01 | 5 | RC | 13159 | - | 03 | 01 |
CREATE TABLE "r_consolid" ( [case_number] TEXT REFERENCES [r_master]([case_number]), [consolidation_date] TEXT, [consol_id] INTEGER, [key_consol_case_reg] INTEGER, [key_consol_case_type] TEXT, [key_consol_case_docket] INTEGER, [key_consol_case_suffix] TEXT, [sub_consol_case_reg] TEXT, [sub_consol_case_type] TEXT, [sub_consol_case_docket] TEXT, [sub_consol_case_suffix] TEXT, [consolidation_type] TEXT, [consolidation_code] TEXT, [consolidation_stage] TEXT, [date_severed] TEXT, [severance_id] TEXT, [severance_type] TEXT, [severance_code] INTEGER, [severance_stage] INTEGER );