r_formal2

where case_number = "01-RC-018058"

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ case_number suffix rf2_date date_last_action transaction action_777 consol_code date_election_held date_obj_chall_filed number_obj_filed number_chall date_hearing_ordered basis_election party_filing_ob hearing_code hearing_ordered_by date_rps_no_hearing_held update_control date_hearing_closed date_hearing_opened date_rpt_on_obj_chall first_election_rpt rpt_control date_rd_suppl_dec ruling_on_obj type_decision decision_control another_election previously_reported date_certification stage method rd_of_bd_dec date_review_waivered date_exception_filed exception_code date_ruling_on_exc ruling_on_exc_code date_reg_for_review party_filing_req date_ruling_on_req ruling_on_req_code date_board_dec type_board_dec number_obj_sustained number_obj_overuled number_obj_withdrawn number_chall_sustained number_chall_overuled number_chall_withdrawn date_obj_chall_resolved ruling_on_obj_r ruling_on_obj_r.1 date_bd_dec_on_rev bd_dec_on_rev
37 37 01-RC-018058 A 1984-01-19 1984-02-15 113   E 1984-01-12 1984-01-19 8 4 1984-02-15 S 2 2 1 1                                                                               
CREATE TABLE "r_formal2" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [suffix] TEXT,
   [rf2_date] TEXT,
   [date_last_action] TEXT,
   [transaction] TEXT,
   [action_777] TEXT,
   [consol_code] TEXT,
   [date_election_held] TEXT,
   [date_obj_chall_filed] TEXT,
   [number_obj_filed] INTEGER,
   [number_chall] INTEGER,
   [date_hearing_ordered] TEXT,
   [basis_election] TEXT,
   [party_filing_ob] INTEGER,
   [hearing_code] TEXT,
   [hearing_ordered_by] TEXT,
   [date_rps_no_hearing_held] TEXT,
   [update_control] TEXT,
   [date_hearing_closed] TEXT,
   [date_hearing_opened] TEXT,
   [date_rpt_on_obj_chall] TEXT,
   [first_election_rpt] INTEGER,
   [rpt_control] TEXT,
   [date_rd_suppl_dec] TEXT,
   [ruling_on_obj] INTEGER,
   [type_decision] INTEGER,
   [decision_control] TEXT,
   [another_election] TEXT,
   [previously_reported] TEXT,
   [date_certification] TEXT,
   [stage] TEXT,
   [method] TEXT,
   [rd_of_bd_dec] TEXT,
   [date_review_waivered] INTEGER,
   [date_exception_filed] TEXT,
   [exception_code] TEXT,
   [date_ruling_on_exc] TEXT,
   [ruling_on_exc_code] TEXT,
   [date_reg_for_review] TEXT,
   [party_filing_req] TEXT,
   [date_ruling_on_req] TEXT,
   [ruling_on_req_code] TEXT,
   [date_board_dec] INTEGER,
   [type_board_dec] TEXT,
   [number_obj_sustained] INTEGER,
   [number_obj_overuled] INTEGER,
   [number_obj_withdrawn] INTEGER,
   [number_chall_sustained] INTEGER,
   [number_chall_overuled] INTEGER,
   [number_chall_withdrawn] INTEGER,
   [date_obj_chall_resolved] TEXT,
   [ruling_on_obj_r] INTEGER,
   [ruling_on_obj_r.1] INTEGER,
   [date_bd_dec_on_rev] INTEGER,
   [bd_dec_on_rev] INTEGER,
   FOREIGN KEY([transaction]) REFERENCES [l_transaction_codes]([trans]),
   FOREIGN KEY([basis_election]) REFERENCES [l_type_elections]([code]),
   FOREIGN KEY([party_filing_ob]) REFERENCES [l_party_filing_objection]([code])
);