chips: c_formal3: where case_number = "02-CA-023697-001"

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

descending

Download this data as a CSV Spreadsheet (All Rows)

Link	rowid ▼	case_number	cf3_date	date_last_action	consol_type	consol_code	update_control	date_ref_app_ct	type_ref	date_pet_answ_filed	date_ref_pet_answ	date_ca_opinion	date_brief_filed	type_disposition	ca_no	date_ca_decree	type_decree	control_case	card_control	code_date_brief_filed
355	355	02-CA-023697-001	1991-02-01	1991-10-21			3	1991-02-01	1				1991-10-21	2		1991-10-21	8		4	1
356	356	02-CA-023697-001	1993-03-09	1993-05-07			3	1993-03-09	1				1993-05-07	2		1993-05-07	8		4	1

CREATE TABLE "c_formal3" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [cf3_date] TEXT,
   [date_last_action] TEXT,
   [consol_type] TEXT,
   [consol_code] TEXT,
   [update_control] TEXT,
   [date_ref_app_ct] TEXT,
   [type_ref] TEXT,
   [date_pet_answ_filed] TEXT,
   [date_ref_pet_answ] TEXT,
   [date_ca_opinion] TEXT,
   [date_brief_filed] TEXT,
   [type_disposition] TEXT,
   [ca_no] TEXT,
   [date_ca_decree] TEXT,
   [type_decree] TEXT,
   [control_case] TEXT,
   [card_control] TEXT,
   [code_date_brief_filed] INTEGER
);