c_consolid

✎ View and edit SQL

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  

Next page

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