c_formal3

where case_number = "07-CA-028974-001"

✎ View and edit SQL

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
1698 1698 07-CA-028974-001 1989-10-17 1990-01-18 1 A 3 1989-10-17 1       1990-01-18 2   1990-01-18 8   4 1
1699 1699 07-CA-028974-001 1990-02-13 1990-05-22 1 A 3 1990-02-13 1       1990-05-22 2   1990-05-22 8   4 1
1700 1700 07-CA-028974-001 1992-09-25 1992-12-14 1 A 3 1992-09-25 1       1992-12-14 2   1992-12-14 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
);