c_formal4

sorted by type_recom

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid case_number cf4_date date_last_action stage_last_action consolidation_type consolidation_code upate_control date_referred_scb date_recom_writ_cert type_recom ▼ date_pret_writ_cert_filed party_filing date_sc_action sc_ruling date_supreme_court_argue date_supreme_court_dec type_supreme_court_dec date_back_pay_specs stage_back_pay_specs date_hearing_closed date_administrative_law_judge_dec_issued date_board_suppl_decision type_board_suppl_decision date_ref_acb date_suppl_ca_decree card_control code_date_hearing_closed code_date_administrative_law_judges_decision_issued code_date_board_suppl_decision
376 376 05-CC-000791-001 1970-10-25       E I 1979-12-01   1                     1921-09-01                
377 377 05-CC-000792-001 1970-10-25       E C 1979-12-01   1                                      
378 378 05-CC-000793-001 1970-10-25       E C 1979-12-01   1                                      
379 379 05-CC-000794-001 1970-10-25       E C 1979-12-01   1                                      
380 380 05-CE-000048-001 1970-10-25       E C 1979-12-01   1                                      
381 381 05-CE-000049-001 1970-10-25       E C 1979-12-01   1                                      
382 382 05-CE-000050-001 1970-10-25       E C 1979-12-01   1                                      
383 383 05-CE-000051-001 1970-10-25       E C 1979-12-01   1                                      
1475 1475 20-CA-011643-001 1970-10-25       E G 1980-03-01   1                   1981-02-01 1981-08-01                 
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
);