c_consolid
19,468 rows
Suggested facets: consol_id, consolidation_type, consolidation_code, consolidation_stage, severance_id, severance_stage, consolidation (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-CA-012030-001 | 1977-02-11 | E | 1 | 03 | 01 | 01-CA-011684-001 | ||||||
| 01-CA-012102-001 | 1981-02-13 | E | 1 | 03 | 01 | 01-CA-012015-001 | ||||||
| 01-CA-012137-001 | 1981-02-13 | E | 1 | 03 | 01 | 01-CA-012015-001 | ||||||
| 01-CA-012370-001 | 1976-12-20 | E | 1 | 03 | 01 | 01-CA-011664-001 | ||||||
| 01-CA-012978-001 | 1985-06-28 | E | 1 | 03 | 01 | 01-CA-011775-001 | ||||||
| 01-CA-013016-001 | 1981-06-30 | E | 1 | 03 | 01 | 01-CA-011491-001 | ||||||
| 01-CA-013017-001 | 1981-06-30 | E | 1 | 03 | 01 | 01-CA-011491-001 | ||||||
| 01-CA-013018-001 | 1981-06-30 | E | 1 | 03 | 01 | 01-CA-011491-001 | ||||||
| 01-CA-013019-001 | 1977-06-07 | E | 1 | 03 | 01 | 01-CA-012838-001 | ||||||
| 01-CA-013057-001 | 1977-06-07 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
| 01-CA-013057-001 | 1980-05-05 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
| 01-CA-013230-001 | 1980-05-05 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
| 01-CA-013282-001 | 1980-05-05 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
| 01-CA-013425-001 | 1980-05-05 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
| 01-CA-013486-001 | 1980-05-05 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
| 01-CA-013588-001 | 1977-12-29 | E | 1 | 03 | 01 | 01-CA-013587-001 | ||||||
| 01-CA-013743-001 | 1977-12-29 | E | 1 | 03 | 01 | 01-CA-013587-001 | ||||||
| 01-CA-013868-001 | 1977-12-29 | E | 1 | 03 | 01 | 01-CA-013587-001 | ||||||
| 01-CA-014085-001 | 1978-05-03 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
| 01-CA-014085-001 | 1983-05-06 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
| 01-CA-014086-001 | 1978-05-03 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
| 01-CA-014086-001 | 1983-05-06 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
| 01-CA-014273-001 | 1978-05-03 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
| 01-CA-014273-001 | 1983-05-06 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
| 01-CA-014274-001 | 1978-05-03 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
| 01-CA-014274-001 | 1983-05-06 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
| 01-CA-014347-001 | 1982-11-30 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
| 01-CA-014383-001 | 1978-10-19 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
| 01-CA-014383-001 | 1982-11-30 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
| 01-CA-014443-001 | 1982-11-30 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
| 01-CA-014475-001 | 1978-09-15 | C | 1 | 02 | 01 | 01-CA-014224-001 | 01-CA-014475-001 | |||||
| 01-CA-014495-002 | 1978-06-29 | C | 1 | 02 | 01 | 01-CA-014495-001 | 01-CA-014495-002 | |||||
| 01-CA-014495-002 | 1982-06-30 | C | 1 | 02 | 01 | 01-CA-014495-001 | 01-CA-014495-002 | |||||
| 01-CA-014526-001 | 1978-06-29 | E | 1 | 03 | 01 | 01-CA-014495-001 | 01-CA-014495-002 | |||||
| 01-CA-014526-001 | 1982-06-30 | E | 1 | 03 | 01 | 01-CA-014495-001 | 01-CA-014495-002 | |||||
| 01-CA-014600-001 | 1978-05-03 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
| 01-CA-014600-001 | 1983-05-06 | E | 1 | 03 | 01 | 01-CA-014050-001 | ||||||
| 01-CA-014700-001 | 1978-09-15 | E | 1 | 03 | 01 | 01-CA-014224-001 | 01-CA-014474-001 | |||||
| 01-CA-014728-001 | 1978-10-19 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
| 01-CA-014728-001 | 1982-11-30 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
| 01-CA-014788-001 | 1978-09-15 | E | 1 | 03 | 01 | 01-CA-014224-001 | 01-CA-014475-001 | |||||
| 01-CA-014925-001 | 1982-11-30 | E | 1 | 03 | 01 | 01-CA-013882-001 | ||||||
| 01-CA-014998-001 | 1980-05-05 | E | 1 | 03 | 01 | 01-CA-011614-001 | ||||||
| 01-CA-015902-001 | 1986-04-09 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
| 01-CA-016026-001 | 1986-04-09 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
| 01-CA-016152-001 | 1981-02-13 | E | 1 | 03 | 01 | 01-CA-012015-001 | ||||||
| 01-CA-016183-001 | 1979-07-09 | C | 1 | 02 | 01 | 01-CA-011742-001 | 01-CA-016183-001 | |||||
| 01-CA-016314-001 | 1980-02-07 | E | 1 | 03 | 01 | 01-CA-011616-001 | ||||||
| 01-CA-016322-001 | 1984-08-30 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
| 01-CA-016322-001 | 1985-04-23 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
| 01-CA-016322-001 | 1986-04-09 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
| 01-CA-016322-002 | 1986-04-09 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
| 01-CA-016896-001 | 1980-05-11 | E | 1 | 03 | 01 | 01-CA-016893-001 | ||||||
| 01-CA-016897-001 | 1980-05-11 | E | 1 | 03 | 01 | 01-CA-016893-001 | ||||||
| 01-CA-016898-001 | 1980-05-11 | E | 1 | 03 | 01 | 01-CA-016893-001 | ||||||
| 01-CA-016917-001 | 1982-11-01 | E | 1 | 03 | 01 | 01-CA-016548-001 | ||||||
| 01-CA-017394-001 | 1985-04-23 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
| 01-CA-017394-001 | 1986-04-09 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
| 01-CA-017415-001 | 1980-06-04 | Q | 1 | 03 | 04 | 01-CA-017321-001 | ||||||
| 01-CA-017469-001 | 1980-06-26 | E | 1 | 03 | 01 | 01-CA-017436-001 | ||||||
| 01-CA-017469-001 | 1980-11-28 | E | 1 | 03 | 01 | 01-CA-017436-001 | ||||||
| 01-CA-017469-001 | 1981-03-13 | E | 1 | 03 | 01 | 01-CA-017436-001 | ||||||
| 01-CA-017534-001 | 1985-02-08 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
| 01-CA-017534-001 | 1985-02-28 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
| 01-CA-017534-001 | 1985-04-23 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
| 01-CA-017534-001 | 1986-04-09 | E | 1 | 03 | 01 | 01-CA-015846-001 | ||||||
| 01-CA-017599-001 | 1980-08-18 | E | 1 | 03 | 01 | 01-CA-011682-001 | ||||||
| 01-CA-017803-001 | 1980-10-17 | Q | 1 | 03 | 04 | 01-CA-017321-001 | ||||||
| 01-CA-017990-001 | 1981-03-13 | E | 1 | 03 | 01 | 01-CA-017436-001 | ||||||
| 01-CA-018259-001 | 1981-03-13 | E | 1 | 03 | 01 | 01-CA-017436-001 | ||||||
| 01-CA-018293-001 | 1981-03-13 | E | 1 | 03 | 01 | 01-CA-017436-001 | ||||||
| 01-CA-018592-002 | 1981-08-12 | E | 1 | 03 | 01 | 01-CA-018592-001 | ||||||
| 01-CA-018592-003 | 1981-08-12 | E | 1 | 03 | 01 | 01-CA-018592-001 | ||||||
| 01-CA-018592-004 | 1981-06-09 | E | 1 | 03 | 01 | 01-CA-018592-001 | ||||||
| 01-CA-018592-004 | 1981-08-12 | E | 1 | 03 | 01 | 01-CA-018592-001 | ||||||
| 01-CA-019190-001 | 1981-11-04 | E | 1 | 03 | 01 | 01-CA-018766-001 | ||||||
| 01-CA-019190-001 | 1981-11-14 | E | 1 | 03 | 01 | 01-CA-018766-001 | ||||||
| 01-CA-019190-001 | 1982-01-13 | E | 1 | 03 | 01 | 01-CA-018766-001 | ||||||
| 01-CA-019635-001 | 1982-08-16 | E | 1 | 03 | 01 | 01-CA-019299-001 | ||||||
| 01-CA-019635-001 | 1983-10-27 | E | 1 | 03 | 01 | 01-CA-019299-001 | ||||||
| 01-CA-019765-001 | 1982-05-27 | E | 1 | 03 | 01 | 01-CA-019537-001 | ||||||
| 01-CA-019765-001 | 1984-12-28 | E | 1 | 03 | 01 | 01-CA-019537-001 | ||||||
| 01-CA-019783-001 | 1982-05-27 | E | 1 | 03 | 01 | 01-CA-019537-001 | ||||||
| 01-CA-019783-001 | 1984-12-28 | E | 1 | 03 | 01 | 01-CA-019537-001 | ||||||
| 01-CA-019854-001 | 1984-12-28 | E | 1 | 03 | 01 | 01-CA-019537-001 | ||||||
| 01-CA-020155-001 | 1982-12-28 | N | 1 | 03 | 05 | 01-CA-019964-001 | ||||||
| 01-CA-020256-001 | 1987-04-30 | E | 1 | 03 | 01 | 01-CA-020237-001 | ||||||
| 01-CA-020283-001 | 1983-12-07 | C | 1 | 02 | 01 | 01-CA-019224-001 | 01-CA-020283-001 | |||||
| 01-CA-020291-001 | 1983-12-07 | C | 1 | 02 | 01 | 01-CA-019224-001 | 01-CA-020291-001 | |||||
| 01-CA-020304-001 | 1983-12-07 | C | 1 | 02 | 01 | 01-CA-019224-001 | 01-CA-020304-001 | |||||
| 01-CA-020328-001 | 1982-11-30 | E | 1 | 03 | 01 | 01-CA-020177-001 | ||||||
| 01-CA-020350-001 | 1982-12-16 | Q | 1 | 03 | 04 | 01-CA-020070-001 | ||||||
| 01-CA-020359-001 | 1982-12-06 | E | 1 | 03 | 01 | 01-CA-020298-001 | ||||||
| 01-CA-020390-001 | 1982-12-21 | N | 1 | 02 | 05 | 01-CA-020123-001 | ||||||
| 01-CA-020407-001 | 1982-12-20 | N | 1 | 03 | 05 | 01-CA-020252-001 | ||||||
| 01-CA-020410-001 | 1982-12-23 | N | 1 | 03 | 05 | 01-CA-019964-001 | ||||||
| 01-CA-020508-001 | 1983-12-07 | C | 1 | 02 | 01 | 01-CA-019224-001 | 01-CA-020508-001 | |||||
| 01-CA-020586-001 | 1983-12-20 | E | 1 | 03 | 01 | 01-CA-020225-001 | ||||||
| 01-CA-020646-001 | 1983-03-15 | E | 1 | 03 | 01 | 01-CA-020120-001 | ||||||
| 01-CA-020647-001 | 1985-03-15 | E | 1 | 03 | 01 | 01-CA-020120-001 |
Table schema
CREATE TABLE c_consolid(case_number VARCHAR, consolidation DATE, consol_id VARCHAR, consolidation_type VARCHAR, consolidation_code VARCHAR, consolidation_stage VARCHAR, date_severed VARCHAR, severance_id VARCHAR, severance_type VARCHAR, severance_code BIGINT, severance_stage BIGINT, key_consol_case_number VARCHAR, sub_consol_case_number VARCHAR);