c_formal3
where case_number = "07-CA-028974-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 );