r_formal1

where case_number = "01-RC-018029"

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ case_number rf1_date date_last_action consol_code code_date_hearing_close date_hearing_close control update_control date_dec_issued unit type_dec type_specl_elect date_waiver date_req_review party_filing date_ruling_reg ruling_control date_board_dec_req board_dec type_board_dec board_unit volume_number issue_number board_members_5 chips_amended_code
36 36 01-RC-018029 1983-11-11 1983-11-11   0 1983-10-24 1 2 1983-11-11 A 1 8                           
CREATE TABLE "r_formal1" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [rf1_date] TEXT,
   [date_last_action] TEXT,
   [consol_code] TEXT,
   [code_date_hearing_close] TEXT,
   [date_hearing_close] TEXT,
   [control] INTEGER,
   [update_control] INTEGER,
   [date_dec_issued] TEXT,
   [unit] TEXT,
   [type_dec] TEXT,
   [type_specl_elect] TEXT,
   [date_waiver] TEXT,
   [date_req_review] TEXT,
   [party_filing] TEXT,
   [date_ruling_reg] TEXT,
   [ruling_control] TEXT,
   [date_board_dec_req] TEXT,
   [board_dec] TEXT,
   [type_board_dec] TEXT,
   [board_unit] TEXT,
   [volume_number] TEXT,
   [issue_number] TEXT,
   [board_members_5] TEXT,
   [chips_amended_code] TEXT,
   FOREIGN KEY([unit]) REFERENCES [l_unit_codes]([code])
);