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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 01-RC-017441 | 1982-04-14 | 1 | CA | 19402 | 001 | 5 | 02 | 03 | ||||||||||
2 | 2 | 01-RC-017475 | 1982-06-30 | 1 | CA | 19299 | 001 | 01 | RC | 17475 | 02 | 01 | ||||||||
3 | 3 | 01-RC-017718 | 1982-12-20 | 1 | CA | 20252 | 001 | 02 | 05 | |||||||||||
4 | 4 | 01-RC-017751 | 1985-04-30 | 1 | RC | 17736 | 01 | RC | 17751 | 03 | 01 | |||||||||
5 | 5 | 01-RC-017843 | 1983-12-19 | 1 | CA | 20773 | 001 | 01 | RC | 17843 | 02 | 01 | 1984-04-20 | D | 2 | 12 | ||||
6 | 6 | 01-RC-017896 | 1983-08-23 | 1 | CA | 21196 | 001 | 5 | 02 | 03 | ||||||||||
7 | 7 | 01-RC-017940 | 1984-01-27 | 1 | CA | 21381 | 001 | 03 | 01 | 1984-04-09 | D | 2 | 12 | |||||||
8 | 8 | 01-RC-017983 | 1983-12-13 | 1 | CA | 21341 | 001 | 5 | 03 | 01 | 1984-04-16 | D | 2 | 12 | ||||||
9 | 9 | 01-RC-017983 | 1984-04-01 | 1 | CA | 21341 | 001 | 5 | 03 | 01 | 1984-04-16 | D | 2 | 12 | ||||||
10 | 10 | 01-RC-017986 | 1983-12-16 | 1 | CA | 21566 | 001 | 01 | RC | 17986 | 02 | 01 | 1984-02-07 | F | 3 | 12 | ||||
11 | 11 | 01-RC-018015 | 1984-03-27 | 1 | CA | 21429 | 001 | 5 | 02 | 03 | ||||||||||
12 | 12 | 01-RC-018015 | 1984-09-17 | 1 | CA | 21429 | 001 | 5 | 02 | 03 | ||||||||||
13 | 13 | 01-RC-018016 | 1983-12-19 | 1 | CA | 21549 | 001 | 01 | RC | 18016 | 02 | 01 | ||||||||
14 | 14 | 01-RC-018033 | 1984-02-02 | 1 | CA | 21539 | 001 | 03 | 01 | |||||||||||
15 | 15 | 01-RC-018041 | 1983-12-05 | 1 | CA | 21500 | 001 | 03 | 01 | |||||||||||
16 | 16 | 01-RC-018058 | 1984-03-05 | 1 | CA | 21653 | 001 | 03 | 01 | |||||||||||
17 | 17 | 01-RC-018091 | 1984-09-19 | 1 | CA | 22108 | 001 | 01 | RC | 18091 | 02 | 01 | ||||||||
18 | 18 | 01-RC-018131 | 1984-08-01 | 1 | CA | 22059 | 001 | 01 | RC | 18131 | 02 | 01 | 1984-12-07 | D | 2 | 12 | ||||
19 | 19 | 01-RC-018165 | 1984-09-06 | 1 | CA | 22192 | 001 | 5 | 03 | 01 | ||||||||||
20 | 20 | 01-RC-018165 | 1984-09-16 | 1 | CA | 22192 | 001 | 5 | 03 | 01 | ||||||||||
21 | 21 | 01-RC-018165 | 1985-04-01 | 1 | CA | 22192 | 001 | 5 | 03 | 01 | ||||||||||
22 | 22 | 01-RC-018175 | 1984-08-24 | 1 | CA | 22211 | 001 | 01 | RC | 18175 | 02 | 01 | 1984-10-17 | D | 2 | 12 | ||||
23 | 23 | 01-RC-018180 | 1984-08-23 | 1 | CA | 22086 | 001 | 01 | RC | 18180 | 02 | 01 | ||||||||
24 | 24 | 01-RC-018212 | 1985-05-29 | 1 | CA | 22319 | 001 | 5 | 02 | 02 | ||||||||||
25 | 25 | 01-RC-018215 | 1984-11-19 | 1 | CA | 22209 | 001 | 02 | 01 | |||||||||||
26 | 26 | 01-RC-018230 | 1984-11-19 | 1 | CA | 22435 | 001 | 01 | RC | 18230 | 02 | 01 | ||||||||
27 | 27 | 01-RC-018230 | 1985-05-20 | 1 | CA | 22435 | 001 | 01 | RC | 18230 | 02 | 01 | ||||||||
28 | 28 | 01-RC-018239 | 1985-02-04 | 1 | CA | 22149 | 001 | 01 | RC | 18239 | 5 | 02 | 03 | |||||||
29 | 29 | 01-RC-018274 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 02 | 01 | |||||||||
30 | 30 | 01-RC-018275 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
31 | 31 | 01-RC-018276 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
32 | 32 | 01-RC-018277 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
33 | 33 | 01-RC-018278 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
34 | 34 | 01-RC-018279 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
35 | 35 | 01-RC-018280 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
36 | 36 | 01-RC-018281 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
37 | 37 | 01-RC-018282 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
38 | 38 | 01-RC-018283 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
39 | 39 | 01-RC-018284 | 1984-10-29 | 1 | RC | 18273 | 03 | 01 | ||||||||||||
40 | 40 | 01-RC-018286 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18284 | 03 | 01 | |||||||||
41 | 41 | 01-RC-018287 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18284 | 03 | 01 | |||||||||
42 | 42 | 01-RC-018288 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
43 | 43 | 01-RC-018289 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
44 | 44 | 01-RC-018306 | 1985-02-15 | 1 | CA | 22615 | 001 | 5 | 03 | |||||||||||
45 | 45 | 01-RC-018306 | 1986-03-26 | 1 | CA | 22615 | 001 | 5 | 03 | |||||||||||
46 | 46 | 01-RC-018371 | 1985-02-06 | 1 | RC | 18370 | 01 | RC | 18371 | 03 | 01 | |||||||||
47 | 47 | 01-RC-018459 | 1985-10-04 | 1 | CA | 23133 | 001 | 01 | RC | 18459 | 5 | 03 | 03 | |||||||
48 | 48 | 01-RC-018471 | 1985-04-30 | 1 | RC | 17736 | 01 | RC | 17471 | 03 | 01 | |||||||||
49 | 49 | 01-RC-018472 | 1985-04-30 | 1 | RC | 17736 | 01 | RC | 18472 | 03 | 01 | |||||||||
50 | 50 | 01-RC-018484 | 1985-08-08 | 1 | CA | 23028 | 001 | 5 | 02 | 01 | ||||||||||
51 | 51 | 01-RC-018500 | 1985-05-16 | 1 | RC | 18499 | 01 | RC | 18500 | 02 | 01 | |||||||||
52 | 52 | 01-RC-018525 | 1985-07-15 | 1 | RC | 18524 | - | 03 | 01 | |||||||||||
53 | 53 | 01-RC-018527 | 1985-07-15 | 1 | RC | 18524 | - | 03 | 01 | |||||||||||
54 | 54 | 01-RC-018529 | 1985-07-15 | 1 | RC | 18524 | - | 03 | 01 | |||||||||||
55 | 55 | 01-RC-018531 | 1985-07-15 | 1 | RC | 18524 | - | 03 | 01 | |||||||||||
56 | 56 | 01-RC-018534 | 1985-08-29 | 1 | CA | 22865 | 001 | 5 | 02 | 02 | ||||||||||
57 | 57 | 01-RC-018573 | 1985-09-01 | 1 | RC | 18572 | - | 03 | 01 | |||||||||||
58 | 58 | 01-RC-018573 | 1985-09-03 | 1 | RC | 18572 | - | 03 | 01 | |||||||||||
59 | 59 | 01-RC-018574 | 1985-09-03 | 1 | RC | 18572 | - | 03 | 01 | |||||||||||
60 | 60 | 01-RC-018575 | 1985-09-03 | 1 | RC | 18572 | - | 03 | 01 | |||||||||||
61 | 61 | 01-RC-018576 | 1985-09-03 | 1 | RC | 18572 | - | 03 | 01 | |||||||||||
62 | 62 | 01-RC-018602 | 1986-04-04 | 1 | CA | 23214 | 001 | 5 | 02 | 03 | ||||||||||
63 | 63 | 01-RC-018631 | 1986-01-24 | 1 | CA | 23360 | 001 | 5 | 02 | 03 | ||||||||||
64 | 64 | 01-RC-018650 | 1986-01-29 | 1 | RC | 18649 | - | 03 | 01 | |||||||||||
65 | 65 | 01-RC-018664 | 1986-09-12 | 1 | CA | 23570 | 001 | 5 | 02 | 01 | ||||||||||
66 | 66 | 01-RC-018721 | 1986-05-19 | 1 | RC | 18720 | - | 03 | 01 | |||||||||||
67 | 67 | 01-RC-018750 | 1987-03-24 | 1 | CA | 24185 | 001 | 5 | 02 | 03 | ||||||||||
68 | 68 | 01-RC-018822 | 1987-04-09 | 1 | CA | 24543 | 001 | 5 | 02 | |||||||||||
69 | 69 | 01-RC-018838 | 1987-05-27 | 1 | CA | 24581 | 001 | 5 | 02 | |||||||||||
70 | 70 | 01-RC-018882 | 1987-09-10 | 1 | CA | 24778 | 001 | 5 | 02 | 01 | ||||||||||
71 | 71 | 01-RC-018926 | 1988-01-27 | 1 | CA | 25132 | 001 | 5 | 02 | 01 | ||||||||||
72 | 72 | 01-RC-018931 | 1988-01-25 | 1 | CB | 6704 | 001 | - | 03 | 10 | 1990-10-19 | H | - | 3 | 10 | |||||
73 | 73 | 01-RC-018969 | 1987-10-23 | 1 | RC | 18968 | - | 03 | 01 | |||||||||||
74 | 74 | 01-RC-019224 | 1989-09-29 | 1 | CA | 26184 | 001 | 5 | 02 | |||||||||||
75 | 75 | 01-RC-019303 | 1989-12-26 | 1 | CA | 26744 | 001 | 01 | RC | 19303 | 5 | 02 | 02 | |||||||
76 | 76 | 01-RC-019320 | 1989-12-15 | 1 | CA | 26765 | 001 | 01 | RC | 19320 | 5 | 02 | 01 | |||||||
77 | 77 | 01-RC-019333 | 1990-01-04 | 1 | CA | 26186 | 001 | 5 | 02 | |||||||||||
78 | 78 | 01-RC-019495 | 1991-12-02 | 1 | CA | 28282 | 001 | 5 | 02 | |||||||||||
79 | 79 | 01-RC-019529 | 1991-07-16 | 1 | CB | 7523 | 001 | - | 02 | |||||||||||
80 | 80 | 01-RC-019750 | 1993-09-22 | 1 | CA | 30726 | 001 | 01 | RC | 19750 | 5 | 03 | 12 | 1994-10-06 | Z | 5 | 3 | 12 | ||
81 | 81 | 01-RC-019909 | 1993-03-25 | 1 | CA | 30864 | 001 | 5 | 03 | 12 | ||||||||||
82 | 82 | 01-RC-019909 | 1994-07-28 | 1 | CA | 30864 | 001 | 5 | 03 | 12 | ||||||||||
83 | 83 | 01-RC-019909 | 1995-08-03 | 1 | CA | 30864 | 001 | 5 | 03 | 12 | ||||||||||
84 | 84 | 01-RC-020265 | 1996-01-31 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
85 | 85 | 01-RC-020265 | 1997-02-28 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
86 | 86 | 01-RC-020270 | 1996-01-31 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
87 | 87 | 01-RC-020270 | 1997-02-28 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
88 | 88 | 01-RC-020275 | 1996-01-31 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
89 | 89 | 01-RC-020275 | 1997-02-28 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
90 | 90 | 01-RC-020278 | 1996-01-31 | 1 | CA | 32586 | 001 | 01 | RC | 20265 | 5 | 03 | 04 | 1997-06-27 | H | 5 | 3 | 10 | ||
91 | 91 | 01-RC-020278 | 1997-02-28 | 1 | CA | 32586 | 001 | 01 | RC | 20265 | 5 | 03 | 04 | 1997-06-27 | H | 5 | 3 | 10 | ||
92 | 92 | 01-RC-020284 | 1995-09-05 | 1 | CA | 33118 | 001 | 01 | RC | 20284 | 5 | 02 | 02 | |||||||
93 | 93 | 01-RC-020300 | 1996-01-31 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
94 | 94 | 01-RC-020300 | 1997-02-28 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
95 | 95 | 01-RC-020404 | 1996-04-08 | 1 | CA | 33664 | 001 | 5 | 03 | 12 | 1997-04-04 | Z | 5 | 3 | 12 | |||||
96 | 96 | 01-RC-020404 | 1997-01-14 | 1 | CA | 33664 | 001 | 5 | 03 | 12 | 1997-04-04 | Z | 5 | 3 | 12 | |||||
97 | 97 | 01-RC-020411 | 1996-06-26 | 1 | CB | 8811 | 001 | 01 | RC | 20411 | - | 02 | 01 | |||||||
98 | 98 | 01-RC-020424 | 1996-05-21 | 1 | CA | 33932 | 001 | 01 | RC | 20424 | 5 | 03 | 12 | 1996-08-15 | Z | 5 | 3 | 12 | ||
99 | 99 | 01-RC-020439 | 1997-04-15 | 1 | CA | 33972 | 002 | 01 | RC | 20439 | 5 | 02 | 02 | |||||||
100 | 100 | 01-RC-020442 | 1996-07-17 | 1 | CA | 34002 | 001 | 01 | RC | 20442 | 5 | 03 | 12 | 1996-08-28 | Z | 5 | 3 | 12 |
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 );