r_formal1
where case_number = "01-RC-018029"
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]) );