r_consolid
2,345 rows
Suggested facets: key_consol_case_reg, key_consol_case_type, key_consol_case_suffix, sub_consol_case_reg, sub_consol_case_type, consolidation_type, consolidation_code, consolidation_stage, severance_id, severance_type, severance_code, severance_stage, consolidation_date (date), date_severed (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-RC-017441 | 1982-04-14 | 1 | CA | 19402 | 001 | 5 | 02 | 03 | ||||||||||
| 01-RC-017475 | 1982-06-30 | 1 | CA | 19299 | 001 | 01 | RC | 17475 | 02 | 01 | ||||||||
| 01-RC-017718 | 1982-12-20 | 1 | CA | 20252 | 001 | 02 | 05 | |||||||||||
| 01-RC-017751 | 1985-04-30 | 1 | RC | 17736 | 01 | RC | 17751 | 03 | 01 | |||||||||
| 01-RC-017843 | 1983-12-19 | 1 | CA | 20773 | 001 | 01 | RC | 17843 | 02 | 01 | 1984-04-20 | D | 2 | 12 | ||||
| 01-RC-017896 | 1983-08-23 | 1 | CA | 21196 | 001 | 5 | 02 | 03 | ||||||||||
| 01-RC-017940 | 1984-01-27 | 1 | CA | 21381 | 001 | 03 | 01 | 1984-04-09 | D | 2 | 12 | |||||||
| 01-RC-017983 | 1983-12-13 | 1 | CA | 21341 | 001 | 5 | 03 | 01 | 1984-04-16 | D | 2 | 12 | ||||||
| 01-RC-017983 | 1984-04-01 | 1 | CA | 21341 | 001 | 5 | 03 | 01 | 1984-04-16 | D | 2 | 12 | ||||||
| 01-RC-017986 | 1983-12-16 | 1 | CA | 21566 | 001 | 01 | RC | 17986 | 02 | 01 | 1984-02-07 | F | 3 | 12 | ||||
| 01-RC-018015 | 1984-03-27 | 1 | CA | 21429 | 001 | 5 | 02 | 03 | ||||||||||
| 01-RC-018015 | 1984-09-17 | 1 | CA | 21429 | 001 | 5 | 02 | 03 | ||||||||||
| 01-RC-018016 | 1983-12-19 | 1 | CA | 21549 | 001 | 01 | RC | 18016 | 02 | 01 | ||||||||
| 01-RC-018033 | 1984-02-02 | 1 | CA | 21539 | 001 | 03 | 01 | |||||||||||
| 01-RC-018041 | 1983-12-05 | 1 | CA | 21500 | 001 | 03 | 01 | |||||||||||
| 01-RC-018058 | 1984-03-05 | 1 | CA | 21653 | 001 | 03 | 01 | |||||||||||
| 01-RC-018091 | 1984-09-19 | 1 | CA | 22108 | 001 | 01 | RC | 18091 | 02 | 01 | ||||||||
| 01-RC-018131 | 1984-08-01 | 1 | CA | 22059 | 001 | 01 | RC | 18131 | 02 | 01 | 1984-12-07 | D | 2 | 12 | ||||
| 01-RC-018165 | 1984-09-06 | 1 | CA | 22192 | 001 | 5 | 03 | 01 | ||||||||||
| 01-RC-018165 | 1984-09-16 | 1 | CA | 22192 | 001 | 5 | 03 | 01 | ||||||||||
| 01-RC-018165 | 1985-04-01 | 1 | CA | 22192 | 001 | 5 | 03 | 01 | ||||||||||
| 01-RC-018175 | 1984-08-24 | 1 | CA | 22211 | 001 | 01 | RC | 18175 | 02 | 01 | 1984-10-17 | D | 2 | 12 | ||||
| 01-RC-018180 | 1984-08-23 | 1 | CA | 22086 | 001 | 01 | RC | 18180 | 02 | 01 | ||||||||
| 01-RC-018212 | 1985-05-29 | 1 | CA | 22319 | 001 | 5 | 02 | 02 | ||||||||||
| 01-RC-018215 | 1984-11-19 | 1 | CA | 22209 | 001 | 02 | 01 | |||||||||||
| 01-RC-018230 | 1984-11-19 | 1 | CA | 22435 | 001 | 01 | RC | 18230 | 02 | 01 | ||||||||
| 01-RC-018230 | 1985-05-20 | 1 | CA | 22435 | 001 | 01 | RC | 18230 | 02 | 01 | ||||||||
| 01-RC-018239 | 1985-02-04 | 1 | CA | 22149 | 001 | 01 | RC | 18239 | 5 | 02 | 03 | |||||||
| 01-RC-018274 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 02 | 01 | |||||||||
| 01-RC-018275 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
| 01-RC-018276 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
| 01-RC-018277 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
| 01-RC-018278 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
| 01-RC-018279 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
| 01-RC-018280 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
| 01-RC-018281 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
| 01-RC-018282 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
| 01-RC-018283 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
| 01-RC-018284 | 1984-10-29 | 1 | RC | 18273 | 03 | 01 | ||||||||||||
| 01-RC-018286 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18284 | 03 | 01 | |||||||||
| 01-RC-018287 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18284 | 03 | 01 | |||||||||
| 01-RC-018288 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
| 01-RC-018289 | 1984-10-29 | 1 | RC | 18273 | 01 | RC | 18274 | 03 | 01 | |||||||||
| 01-RC-018306 | 1985-02-15 | 1 | CA | 22615 | 001 | 5 | 03 | |||||||||||
| 01-RC-018306 | 1986-03-26 | 1 | CA | 22615 | 001 | 5 | 03 | |||||||||||
| 01-RC-018371 | 1985-02-06 | 1 | RC | 18370 | 01 | RC | 18371 | 03 | 01 | |||||||||
| 01-RC-018459 | 1985-10-04 | 1 | CA | 23133 | 001 | 01 | RC | 18459 | 5 | 03 | 03 | |||||||
| 01-RC-018471 | 1985-04-30 | 1 | RC | 17736 | 01 | RC | 17471 | 03 | 01 | |||||||||
| 01-RC-018472 | 1985-04-30 | 1 | RC | 17736 | 01 | RC | 18472 | 03 | 01 | |||||||||
| 01-RC-018484 | 1985-08-08 | 1 | CA | 23028 | 001 | 5 | 02 | 01 | ||||||||||
| 01-RC-018500 | 1985-05-16 | 1 | RC | 18499 | 01 | RC | 18500 | 02 | 01 | |||||||||
| 01-RC-018525 | 1985-07-15 | 1 | RC | 18524 | - | 03 | 01 | |||||||||||
| 01-RC-018527 | 1985-07-15 | 1 | RC | 18524 | - | 03 | 01 | |||||||||||
| 01-RC-018529 | 1985-07-15 | 1 | RC | 18524 | - | 03 | 01 | |||||||||||
| 01-RC-018531 | 1985-07-15 | 1 | RC | 18524 | - | 03 | 01 | |||||||||||
| 01-RC-018534 | 1985-08-29 | 1 | CA | 22865 | 001 | 5 | 02 | 02 | ||||||||||
| 01-RC-018573 | 1985-09-01 | 1 | RC | 18572 | - | 03 | 01 | |||||||||||
| 01-RC-018573 | 1985-09-03 | 1 | RC | 18572 | - | 03 | 01 | |||||||||||
| 01-RC-018574 | 1985-09-03 | 1 | RC | 18572 | - | 03 | 01 | |||||||||||
| 01-RC-018575 | 1985-09-03 | 1 | RC | 18572 | - | 03 | 01 | |||||||||||
| 01-RC-018576 | 1985-09-03 | 1 | RC | 18572 | - | 03 | 01 | |||||||||||
| 01-RC-018602 | 1986-04-04 | 1 | CA | 23214 | 001 | 5 | 02 | 03 | ||||||||||
| 01-RC-018631 | 1986-01-24 | 1 | CA | 23360 | 001 | 5 | 02 | 03 | ||||||||||
| 01-RC-018650 | 1986-01-29 | 1 | RC | 18649 | - | 03 | 01 | |||||||||||
| 01-RC-018664 | 1986-09-12 | 1 | CA | 23570 | 001 | 5 | 02 | 01 | ||||||||||
| 01-RC-018721 | 1986-05-19 | 1 | RC | 18720 | - | 03 | 01 | |||||||||||
| 01-RC-018750 | 1987-03-24 | 1 | CA | 24185 | 001 | 5 | 02 | 03 | ||||||||||
| 01-RC-018822 | 1987-04-09 | 1 | CA | 24543 | 001 | 5 | 02 | |||||||||||
| 01-RC-018838 | 1987-05-27 | 1 | CA | 24581 | 001 | 5 | 02 | |||||||||||
| 01-RC-018882 | 1987-09-10 | 1 | CA | 24778 | 001 | 5 | 02 | 01 | ||||||||||
| 01-RC-018926 | 1988-01-27 | 1 | CA | 25132 | 001 | 5 | 02 | 01 | ||||||||||
| 01-RC-018931 | 1988-01-25 | 1 | CB | 6704 | 001 | - | 03 | 10 | 1990-10-19 | H | - | 3 | 10 | |||||
| 01-RC-018969 | 1987-10-23 | 1 | RC | 18968 | - | 03 | 01 | |||||||||||
| 01-RC-019224 | 1989-09-29 | 1 | CA | 26184 | 001 | 5 | 02 | |||||||||||
| 01-RC-019303 | 1989-12-26 | 1 | CA | 26744 | 001 | 01 | RC | 19303 | 5 | 02 | 02 | |||||||
| 01-RC-019320 | 1989-12-15 | 1 | CA | 26765 | 001 | 01 | RC | 19320 | 5 | 02 | 01 | |||||||
| 01-RC-019333 | 1990-01-04 | 1 | CA | 26186 | 001 | 5 | 02 | |||||||||||
| 01-RC-019495 | 1991-12-02 | 1 | CA | 28282 | 001 | 5 | 02 | |||||||||||
| 01-RC-019529 | 1991-07-16 | 1 | CB | 7523 | 001 | - | 02 | |||||||||||
| 01-RC-019750 | 1993-09-22 | 1 | CA | 30726 | 001 | 01 | RC | 19750 | 5 | 03 | 12 | 1994-10-06 | Z | 5 | 3 | 12 | ||
| 01-RC-019909 | 1993-03-25 | 1 | CA | 30864 | 001 | 5 | 03 | 12 | ||||||||||
| 01-RC-019909 | 1994-07-28 | 1 | CA | 30864 | 001 | 5 | 03 | 12 | ||||||||||
| 01-RC-019909 | 1995-08-03 | 1 | CA | 30864 | 001 | 5 | 03 | 12 | ||||||||||
| 01-RC-020265 | 1996-01-31 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
| 01-RC-020265 | 1997-02-28 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
| 01-RC-020270 | 1996-01-31 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
| 01-RC-020270 | 1997-02-28 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
| 01-RC-020275 | 1996-01-31 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
| 01-RC-020275 | 1997-02-28 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
| 01-RC-020278 | 1996-01-31 | 1 | CA | 32586 | 001 | 01 | RC | 20265 | 5 | 03 | 04 | 1997-06-27 | H | 5 | 3 | 10 | ||
| 01-RC-020278 | 1997-02-28 | 1 | CA | 32586 | 001 | 01 | RC | 20265 | 5 | 03 | 04 | 1997-06-27 | H | 5 | 3 | 10 | ||
| 01-RC-020284 | 1995-09-05 | 1 | CA | 33118 | 001 | 01 | RC | 20284 | 5 | 02 | 02 | |||||||
| 01-RC-020300 | 1996-01-31 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
| 01-RC-020300 | 1997-02-28 | 1 | CA | 32586 | 001 | 5 | 03 | 10 | 1997-06-27 | H | 5 | 3 | 10 | |||||
| 01-RC-020404 | 1996-04-08 | 1 | CA | 33664 | 001 | 5 | 03 | 12 | 1997-04-04 | Z | 5 | 3 | 12 | |||||
| 01-RC-020404 | 1997-01-14 | 1 | CA | 33664 | 001 | 5 | 03 | 12 | 1997-04-04 | Z | 5 | 3 | 12 | |||||
| 01-RC-020411 | 1996-06-26 | 1 | CB | 8811 | 001 | 01 | RC | 20411 | - | 02 | 01 | |||||||
| 01-RC-020424 | 1996-05-21 | 1 | CA | 33932 | 001 | 01 | RC | 20424 | 5 | 03 | 12 | 1996-08-15 | Z | 5 | 3 | 12 | ||
| 01-RC-020439 | 1997-04-15 | 1 | CA | 33972 | 002 | 01 | RC | 20439 | 5 | 02 | 02 | |||||||
| 01-RC-020442 | 1996-07-17 | 1 | CA | 34002 | 001 | 01 | RC | 20442 | 5 | 03 | 12 | 1996-08-28 | Z | 5 | 3 | 12 |
Table schema
CREATE TABLE r_consolid(case_number VARCHAR, consolidation_date DATE, consol_id BIGINT, key_consol_case_reg BIGINT, key_consol_case_type VARCHAR, key_consol_case_docket BIGINT, key_consol_case_suffix VARCHAR, sub_consol_case_reg VARCHAR, sub_consol_case_type VARCHAR, sub_consol_case_docket VARCHAR, sub_consol_case_suffix VARCHAR, consolidation_type VARCHAR, consolidation_code VARCHAR, consolidation_stage VARCHAR, date_severed DATE, severance_id VARCHAR, severance_type VARCHAR, severance_code BIGINT, severance_stage BIGINT);