c_consolid
Download this data as a CSV Spreadsheet (All Rows)
Link | rowid ▼ | case_number | consolidation | consol_id | consolidation_type | consolidation_code | consolidation_stage | date_severed | severance_id | severance_type | severance_code | severance_stage | key_consol_case_number | sub_consol_case_number |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 01-CA-012030-001 | 1977-02-11 | E | 1 | 03 | 01 | 01-CA-011684-001 | ||||||
2 | 2 | 01-CA-012102-001 | 1981-02-13 | E | 1 | 03 | 01 | 01-CA-012015-001 | ||||||
3 | 3 | 01-CA-012137-001 | 1981-02-13 | E | 1 | 03 | 01 | 01-CA-012015-001 | ||||||
4 | 4 | 01-CA-012370-001 | 1976-12-20 | E | 1 | 03 | 01 | 01-CA-011664-001 | ||||||
5 | 5 | 01-CA-012978-001 | 1985-06-28 | E | 1 | 03 | 01 | 01-CA-011775-001 | ||||||
6 | 6 | 01-CA-013016-001 | 1981-06-30 | E | 1 | 03 | 01 | 01-CA-011491-001 | ||||||
7 | 7 | 01-CA-013017-001 | 1981-06-30 | E | 1 | 03 | 01 | 01-CA-011491-001 | ||||||
8 | 8 | 01-CA-013018-001 | 1981-06-30 | E | 1 | 03 | 01 | 01-CA-011491-001 | ||||||
9 | 9 | 01-CA-013019-001 | 1977-06-07 | E | 1 | 03 | 01 | 01-CA-012838-001 | ||||||
10 | 10 | 01-CA-013057-001 | 1977-06-07 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
11 | 11 | 01-CA-013057-001 | 1980-05-05 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
12 | 12 | 01-CA-013230-001 | 1980-05-05 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
13 | 13 | 01-CA-013282-001 | 1980-05-05 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
14 | 14 | 01-CA-013425-001 | 1980-05-05 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
15 | 15 | 01-CA-013486-001 | 1980-05-05 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
16 | 16 | 01-CA-013588-001 | 1977-12-29 | E | 1 | 03 | 01 | 01-CA-013587-001 | ||||||
17 | 17 | 01-CA-013743-001 | 1977-12-29 | E | 1 | 03 | 01 | 01-CA-013587-001 | ||||||
18 | 18 | 01-CA-013868-001 | 1977-12-29 | E | 1 | 03 | 01 | 01-CA-013587-001 | ||||||
19 | 19 | 01-CA-014085-001 | 1978-05-03 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
20 | 20 | 01-CA-014085-001 | 1983-05-06 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
21 | 21 | 01-CA-014086-001 | 1978-05-03 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
22 | 22 | 01-CA-014086-001 | 1983-05-06 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
23 | 23 | 01-CA-014273-001 | 1978-05-03 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
24 | 24 | 01-CA-014273-001 | 1983-05-06 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
25 | 25 | 01-CA-014274-001 | 1978-05-03 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
26 | 26 | 01-CA-014274-001 | 1983-05-06 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
27 | 27 | 01-CA-014347-001 | 1982-11-30 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
28 | 28 | 01-CA-014383-001 | 1978-10-19 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
29 | 29 | 01-CA-014383-001 | 1982-11-30 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
30 | 30 | 01-CA-014443-001 | 1982-11-30 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
31 | 31 | 01-CA-014475-001 | 1978-09-15 | C | 1 | 02 | 01 | 01-CA-014224-001 | 01-CA-014475-001 | |||||
32 | 32 | 01-CA-014495-002 | 1978-06-29 | C | 1 | 02 | 01 | 01-CA-014495-001 | 01-CA-014495-002 | |||||
33 | 33 | 01-CA-014495-002 | 1982-06-30 | C | 1 | 02 | 01 | 01-CA-014495-001 | 01-CA-014495-002 | |||||
34 | 34 | 01-CA-014526-001 | 1978-06-29 | E | 1 | 03 | 01 | 01-CA-014495-001 | 01-CA-014495-002 | |||||
35 | 35 | 01-CA-014526-001 | 1982-06-30 | E | 1 | 03 | 01 | 01-CA-014495-001 | 01-CA-014495-002 | |||||
36 | 36 | 01-CA-014600-001 | 1978-05-03 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
37 | 37 | 01-CA-014600-001 | 1983-05-06 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
38 | 38 | 01-CA-014700-001 | 1978-09-15 | E | 1 | 03 | 01 | 01-CA-014224-001 | 01-CA-014474-001 | |||||
39 | 39 | 01-CA-014728-001 | 1978-10-19 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
40 | 40 | 01-CA-014728-001 | 1982-11-30 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
41 | 41 | 01-CA-014788-001 | 1978-09-15 | E | 1 | 03 | 01 | 01-CA-014224-001 | 01-CA-014475-001 | |||||
42 | 42 | 01-CA-014925-001 | 1982-11-30 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
43 | 43 | 01-CA-014998-001 | 1980-05-05 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
44 | 44 | 01-CA-015902-001 | 1986-04-09 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
45 | 45 | 01-CA-016026-001 | 1986-04-09 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
46 | 46 | 01-CA-016152-001 | 1981-02-13 | E | 1 | 03 | 01 | 01-CA-012015-001 | ||||||
47 | 47 | 01-CA-016183-001 | 1979-07-09 | C | 1 | 02 | 01 | 01-CA-011742-001 | 01-CA-016183-001 | |||||
48 | 48 | 01-CA-016314-001 | 1980-02-07 | E | 1 | 03 | 01 | 01-CA-011616-001 | ||||||
49 | 49 | 01-CA-016322-001 | 1984-08-30 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
50 | 50 | 01-CA-016322-001 | 1985-04-23 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
51 | 51 | 01-CA-016322-001 | 1986-04-09 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
52 | 52 | 01-CA-016322-002 | 1986-04-09 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
53 | 53 | 01-CA-016896-001 | 1980-05-11 | E | 1 | 03 | 01 | 01-CA-016893-001 | ||||||
54 | 54 | 01-CA-016897-001 | 1980-05-11 | E | 1 | 03 | 01 | 01-CA-016893-001 | ||||||
55 | 55 | 01-CA-016898-001 | 1980-05-11 | E | 1 | 03 | 01 | 01-CA-016893-001 | ||||||
56 | 56 | 01-CA-016917-001 | 1982-11-01 | E | 1 | 03 | 01 | 01-CA-016548-001 | ||||||
57 | 57 | 01-CA-017394-001 | 1985-04-23 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
58 | 58 | 01-CA-017394-001 | 1986-04-09 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
59 | 59 | 01-CA-017415-001 | 1980-06-04 | Q | 1 | 03 | 04 | 01-CA-017321-001 | ||||||
60 | 60 | 01-CA-017469-001 | 1980-06-26 | E | 1 | 03 | 01 | 01-CA-017436-001 | ||||||
61 | 61 | 01-CA-017469-001 | 1980-11-28 | E | 1 | 03 | 01 | 01-CA-017436-001 | ||||||
62 | 62 | 01-CA-017469-001 | 1981-03-13 | E | 1 | 03 | 01 | 01-CA-017436-001 | ||||||
63 | 63 | 01-CA-017534-001 | 1985-02-08 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
64 | 64 | 01-CA-017534-001 | 1985-02-28 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
65 | 65 | 01-CA-017534-001 | 1985-04-23 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
66 | 66 | 01-CA-017534-001 | 1986-04-09 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
67 | 67 | 01-CA-017599-001 | 1980-08-18 | E | 1 | 03 | 01 | 01-CA-011682-001 | ||||||
68 | 68 | 01-CA-017803-001 | 1980-10-17 | Q | 1 | 03 | 04 | 01-CA-017321-001 | ||||||
69 | 69 | 01-CA-017990-001 | 1981-03-13 | E | 1 | 03 | 01 | 01-CA-017436-001 | ||||||
70 | 70 | 01-CA-018259-001 | 1981-03-13 | E | 1 | 03 | 01 | 01-CA-017436-001 | ||||||
71 | 71 | 01-CA-018293-001 | 1981-03-13 | E | 1 | 03 | 01 | 01-CA-017436-001 | ||||||
72 | 72 | 01-CA-018592-002 | 1981-08-12 | E | 1 | 03 | 01 | 01-CA-018592-001 | ||||||
73 | 73 | 01-CA-018592-003 | 1981-08-12 | E | 1 | 03 | 01 | 01-CA-018592-001 | ||||||
74 | 74 | 01-CA-018592-004 | 1981-06-09 | E | 1 | 03 | 01 | 01-CA-018592-001 | ||||||
75 | 75 | 01-CA-018592-004 | 1981-08-12 | E | 1 | 03 | 01 | 01-CA-018592-001 | ||||||
76 | 76 | 01-CA-019190-001 | 1981-11-04 | E | 1 | 03 | 01 | 01-CA-018766-001 | ||||||
77 | 77 | 01-CA-019190-001 | 1981-11-14 | E | 1 | 03 | 01 | 01-CA-018766-001 | ||||||
78 | 78 | 01-CA-019190-001 | 1982-01-13 | E | 1 | 03 | 01 | 01-CA-018766-001 | ||||||
79 | 79 | 01-CA-019635-001 | 1982-08-16 | E | 1 | 03 | 01 | 01-CA-019299-001 | ||||||
80 | 80 | 01-CA-019635-001 | 1983-10-27 | E | 1 | 03 | 01 | 01-CA-019299-001 | ||||||
81 | 81 | 01-CA-019765-001 | 1982-05-27 | E | 1 | 03 | 01 | 01-CA-019537-001 | ||||||
82 | 82 | 01-CA-019765-001 | 1984-12-28 | E | 1 | 03 | 01 | 01-CA-019537-001 | ||||||
83 | 83 | 01-CA-019783-001 | 1982-05-27 | E | 1 | 03 | 01 | 01-CA-019537-001 | ||||||
84 | 84 | 01-CA-019783-001 | 1984-12-28 | E | 1 | 03 | 01 | 01-CA-019537-001 | ||||||
85 | 85 | 01-CA-019854-001 | 1984-12-28 | E | 1 | 03 | 01 | 01-CA-019537-001 | ||||||
86 | 86 | 01-CA-020155-001 | 1982-12-28 | N | 1 | 03 | 05 | 01-CA-019964-001 | ||||||
87 | 87 | 01-CA-020256-001 | 1987-04-30 | E | 1 | 03 | 01 | 01-CA-020237-001 | ||||||
88 | 88 | 01-CA-020283-001 | 1983-12-07 | C | 1 | 02 | 01 | 01-CA-019224-001 | 01-CA-020283-001 | |||||
89 | 89 | 01-CA-020291-001 | 1983-12-07 | C | 1 | 02 | 01 | 01-CA-019224-001 | 01-CA-020291-001 | |||||
90 | 90 | 01-CA-020304-001 | 1983-12-07 | C | 1 | 02 | 01 | 01-CA-019224-001 | 01-CA-020304-001 | |||||
91 | 91 | 01-CA-020328-001 | 1982-11-30 | E | 1 | 03 | 01 | 01-CA-020177-001 | ||||||
92 | 92 | 01-CA-020350-001 | 1982-12-16 | Q | 1 | 03 | 04 | 01-CA-020070-001 | ||||||
93 | 93 | 01-CA-020359-001 | 1982-12-06 | E | 1 | 03 | 01 | 01-CA-020298-001 | ||||||
94 | 94 | 01-CA-020390-001 | 1982-12-21 | N | 1 | 02 | 05 | 01-CA-020123-001 | ||||||
95 | 95 | 01-CA-020407-001 | 1982-12-20 | N | 1 | 03 | 05 | 01-CA-020252-001 | ||||||
96 | 96 | 01-CA-020410-001 | 1982-12-23 | N | 1 | 03 | 05 | 01-CA-019964-001 | ||||||
97 | 97 | 01-CA-020508-001 | 1983-12-07 | C | 1 | 02 | 01 | 01-CA-019224-001 | 01-CA-020508-001 | |||||
98 | 98 | 01-CA-020586-001 | 1983-12-20 | E | 1 | 03 | 01 | 01-CA-020225-001 | ||||||
99 | 99 | 01-CA-020646-001 | 1983-03-15 | E | 1 | 03 | 01 | 01-CA-020120-001 | ||||||
100 | 100 | 01-CA-020647-001 | 1985-03-15 | E | 1 | 03 | 01 | 01-CA-020120-001 |
CREATE TABLE "c_consolid" ( [case_number] TEXT REFERENCES [c_master]([case_number]), [consolidation] TEXT, [consol_id] 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, [key_consol_case_number] TEXT, [sub_consol_case_number] TEXT );