c_formal4

sorted by stage_last_action

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

CREATE TABLE "c_formal4" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [cf4_date] TEXT,
   [date_last_action] TEXT,
   [stage_last_action] TEXT,
   [consolidation_type] TEXT,
   [consolidation_code] TEXT,
   [upate_control] TEXT,
   [date_referred_scb] TEXT,
   [date_recom_writ_cert] INTEGER,
   [type_recom] TEXT,
   [date_pret_writ_cert_filed] TEXT,
   [party_filing] TEXT,
   [date_sc_action] TEXT,
   [sc_ruling] TEXT,
   [date_supreme_court_argue] INTEGER,
   [date_supreme_court_dec] TEXT,
   [type_supreme_court_dec] TEXT,
   [date_back_pay_specs] TEXT,
   [stage_back_pay_specs] TEXT,
   [date_hearing_closed] TEXT,
   [date_administrative_law_judge_dec_issued] TEXT,
   [date_board_suppl_decision] TEXT,
   [type_board_suppl_decision] TEXT,
   [date_ref_acb] TEXT,
   [date_suppl_ca_decree] TEXT,
   [card_control] INTEGER,
   [code_date_hearing_closed] INTEGER,
   [code_date_administrative_law_judges_decision_issued] INTEGER,
   [code_date_board_suppl_decision] INTEGER
);