c_consolid

where case_number = "02-CA-021246-001"

✎ 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
1254 1254 02-CA-021246-001 1985-10-31 E 1 03 01           02-CA-021111-001  
1255 1255 02-CA-021246-001 1986-01-09 E 1 03 01           02-CA-021111-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
);