c_formal3
where case_number = "01-CA-007643-001"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141 | 141 | 01-CA-007643-001 | 1970-10-20 | 1973-11-15 | 1 | A | 4 | 4 | 1975-07-25 | 1974-12-20 | 3 | 2 | 1975-10-25 | 2 | 4 |
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 );