c_consolid

where case_number = "31-CA-018245-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
18123 18123 31-CA-018245-001 1990-06-28 E 1 03 01           31-CA-018073-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
);