r_formal1
16,572 rows
Suggested facets: code_date_hearing_close, control, update_control, unit, type_dec, type_specl_elect, party_filing, ruling_control, board_members_5, rf1_date (date), date_last_action (date), date_hearing_close (date), date_dec_issued (date), date_req_review (date), date_ruling_reg (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-AC-000078 | 1984-10-31 | 1984-10-31 | 1 | 1984-10-31 | 2 | 1 | ||||||||||||||||||
| 01-AC-000079 | 1985-02-13 | 0 | 1 | 8 | 1985-02-13 | Z | 1 | |||||||||||||||||
| 01-AC-000082 | 1985-12-09 | 1985-12-23 | 0 | 1985-11-14 | 1 | 4 | 1985-12-09 | C | 1 | 1985-12-23 | 1 | |||||||||||||
| 01-AC-000084 | 1987-09-23 | 0 | 1 | 8 | 1987-09-23 | 4 | ||||||||||||||||||
| 01-RC-016265 | 1980-12-12 | 1980-12-12 | 1 | 1980-12-12 | 2 | 8 | 1986-11-20 | 4 | ||||||||||||||||
| 01-RC-017262 | 1970-10-05 | 1981-05-18 | 0 | 1981-04-23 | 2 | 8 | 1986-11-05 | P | 4 | 8 | 1981-06-02 | 1 | 1981-07-17 | 1 | ||||||||||
| 01-RC-017441 | 1981-10-19 | 1981-10-19 | 0 | 1981-09-30 | 1 | 2 | 1981-10-19 | A | 1 | |||||||||||||||
| 01-RC-017475 | 1982-01-07 | 1982-02-03 | 0 | 1981-11-18 | 1 | 5 | 1982-01-07 | P | 1 | 1982-02-03 | 2 | |||||||||||||
| 01-RC-017569 | 1983-12-23 | 1983-12-23 | 0 | 1983-12-01 | 1 | 2 | 1983-12-23 | C | 1 | 8 | ||||||||||||||
| 01-RC-017622 | 1982-05-18 | 1982-05-18 | 0 | 1982-05-05 | 1 | 2 | 1982-05-18 | A | 1 | |||||||||||||||
| 01-RC-017696 | 1982-09-27 | 1982-09-27 | 0 | 1982-08-17 | 1 | 2 | 1982-09-27 | P | 1 | |||||||||||||||
| 01-RC-017696 | 1984-12-18 | 0 | 1982-08-17 | 1 | 8 | 1984-12-18 | 4 | |||||||||||||||||
| 01-RC-017700 | 1982-09-02 | 0 | 1982-08-13 | 1 | 8 | 1982-09-02 | 4 | |||||||||||||||||
| 01-RC-017711 | 1984-11-21 | 1984-11-21 | 0 | 1984-10-12 | 1 | 2 | 1984-11-21 | A | 1 | 8 | ||||||||||||||
| 01-RC-017751 | 1985-06-04 | 1985-06-04 | 0 | 1985-05-06 | 1 | 2 | 1985-06-04 | A | 1 | |||||||||||||||
| 01-RC-017757 | 1982-11-19 | 1982-11-19 | 0 | 1982-11-05 | 1 | 2 | 1982-11-19 | Z | 1 | |||||||||||||||
| 01-RC-017785 | 1983-08-25 | 1983-09-22 | 0 | 1983-07-15 | 1 | 5 | 1983-08-25 | Z | 1 | 8 | 1983-09-22 | 1 | 1983-09-22 | 1 | ||||||||||
| 01-RC-017813 | 1983-02-03 | 1983-02-03 | 0 | 1983-01-27 | 1 | 2 | 1983-02-03 | A | 1 | 8 | ||||||||||||||
| 01-RC-017829 | 1983-06-13 | 1983-06-13 | 0 | 1983-05-20 | 1 | 2 | 1983-06-13 | A | 1 | 8 | ||||||||||||||
| 01-RC-017830 | 1984-12-07 | 1985-01-14 | 0 | 1983-03-15 | 1 | 5 | 1984-12-07 | P | 1 | 1984-12-26 | 1 | 1985-01-14 | 2 | |||||||||||
| 01-RC-017863 | 1983-04-21 | 1983-04-21 | 0 | 1983-04-04 | 1 | 2 | 1983-04-21 | A | 1 | 8 | ||||||||||||||
| 01-RC-017876 | 1983-06-06 | 1983-06-06 | 1 | 1983-06-06 | 2 | 1 | ||||||||||||||||||
| 01-RC-017904 | 1983-07-20 | 1983-07-20 | 1 | 1983-07-20 | 2 | 1 | ||||||||||||||||||
| 01-RC-017930 | 1983-08-02 | 1983-08-02 | 0 | 1983-07-07 | 1 | 2 | 1983-08-02 | Z | 1 | 8 | ||||||||||||||
| 01-RC-017934 | 1983-09-08 | 1983-09-08 | 0 | 1983-07-19 | 1 | 2 | 1983-09-08 | A | 1 | 8 | ||||||||||||||
| 01-RC-017940 | 1983-08-02 | 1983-08-02 | 0 | 1983-07-12 | 1 | 2 | 1983-08-02 | T | 1 | 8 | ||||||||||||||
| 01-RC-017953 | 1983-12-29 | 1983-12-29 | 0 | 1983-10-03 | 1 | 2 | 1983-12-29 | A | 1 | 8 | ||||||||||||||
| 01-RC-017955 | 1983-09-20 | 1983-09-20 | 0 | 1983-08-25 | 1 | 2 | 1983-09-20 | C | 1 | 8 | ||||||||||||||
| 01-RC-017962 | 1983-09-27 | 1983-09-27 | 0 | 1983-08-16 | 1 | 2 | 1983-09-27 | D | 1 | |||||||||||||||
| 01-RC-017983 | 1983-09-29 | 1983-09-29 | 0 | 1983-09-12 | 1 | 2 | 1983-09-29 | T | 1 | |||||||||||||||
| 01-RC-017991 | 1983-10-06 | 0 | 1 | 8 | 1983-10-06 | 4 | ||||||||||||||||||
| 01-RC-017998 | 1983-10-13 | 1983-10-13 | 0 | 1983-09-21 | 1 | 2 | 1983-10-13 | A | 1 | 8 | ||||||||||||||
| 01-RC-018013 | 1983-11-03 | 1983-11-03 | 0 | 1 | 2 | 1983-11-03 | A | 1 | 8 | |||||||||||||||
| 01-RC-018020 | 1983-12-12 | 1983-12-12 | 0 | 1983-10-04 | 1 | 2 | 1983-12-12 | A | 1 | |||||||||||||||
| 01-RC-018022 | 1983-11-03 | 1983-11-03 | 0 | 1983-10-12 | 1 | 2 | 1983-11-03 | T | 1 | 8 | ||||||||||||||
| 01-RC-018029 | 1983-11-11 | 1983-11-11 | 0 | 1983-10-24 | 1 | 2 | 1983-11-11 | A | 1 | 8 | ||||||||||||||
| 01-RC-018033 | 1983-11-08 | 1983-11-08 | 0 | 1 | 2 | 1983-11-08 | A | 1 | 8 | |||||||||||||||
| 01-RC-018051 | 1984-02-02 | 1984-02-02 | 0 | 1983-12-07 | 1 | 2 | 1984-02-02 | P | 1 | 8 | ||||||||||||||
| 01-RC-018056 | 1983-12-27 | 1983-12-27 | 0 | 1983-12-01 | 1 | 2 | 1983-12-27 | A | 1 | 8 | ||||||||||||||
| 01-RC-018057 | 1983-12-12 | 0 | 1 | 8 | 1983-12-12 | 4 | ||||||||||||||||||
| 01-RC-018060 | 1984-01-25 | 1984-01-25 | 0 | 1983-12-20 | 1 | 2 | 1984-01-25 | A | 1 | 8 | ||||||||||||||
| 01-RC-018062 | 1983-12-23 | 1983-12-23 | 0 | 1983-12-02 | 1 | 2 | 1983-12-23 | A | 1 | 8 | ||||||||||||||
| 01-RC-018064 | 1984-01-04 | 1984-01-04 | 0 | 1983-12-06 | 1 | 2 | 1984-01-04 | W | 1 | 8 | ||||||||||||||
| 01-RC-018066 | 1984-01-06 | 0 | 1983-12-12 | 1 | 8 | 1984-01-06 | 4 | |||||||||||||||||
| 01-RC-018071 | 1984-11-06 | 1984-11-06 | 0 | 1984-03-02 | 1 | 2 | 1984-11-06 | A | 1 | 8 | ||||||||||||||
| 01-RC-018074 | 1984-03-22 | 2 | 8 | 1984-03-22 | 4 | |||||||||||||||||||
| 01-RC-018075 | 1984-01-25 | 1984-01-25 | 0 | 1983-12-27 | 1 | 2 | 1984-01-25 | A | 1 | 8 | ||||||||||||||
| 01-RC-018079 | 1984-01-27 | 1984-01-27 | 0 | 1984-01-16 | 1 | 2 | 1984-01-27 | C | 1 | 8 | ||||||||||||||
| 01-RC-018083 | 1984-02-10 | 1984-02-10 | 0 | 1984-01-17 | 1 | 2 | 1984-02-10 | A | 1 | 8 | ||||||||||||||
| 01-RC-018087 | 1984-02-08 | 1984-02-08 | 0 | 1984-01-27 | 1 | 2 | 1984-02-08 | A | 1 | 8 | ||||||||||||||
| 01-RC-018091 | 1984-06-11 | 1984-06-11 | 0 | 1984-02-10 | 1 | 2 | 1984-06-11 | A | 1 | 8 | ||||||||||||||
| 01-RC-018094 | 1984-04-10 | 1984-04-10 | 0 | 1984-02-29 | 1 | 2 | 1984-04-10 | A | 1 | 8 | ||||||||||||||
| 01-RC-018096 | 1984-03-22 | 0 | 1984-03-16 | 1 | 8 | 1984-03-22 | 4 | |||||||||||||||||
| 01-RC-018099 | 1984-03-30 | 1984-03-30 | 0 | 1984-03-12 | 1 | 2 | 1984-03-30 | A | 1 | 8 | ||||||||||||||
| 01-RC-018100 | 1984-03-27 | 1984-03-27 | 0 | 1984-02-29 | 1 | 2 | 1984-03-27 | A | 1 | 8 | ||||||||||||||
| 01-RC-018107 | 1984-04-11 | 1984-04-11 | 0 | 1984-03-15 | 1 | 2 | 1984-04-11 | D | 1 | 8 | ||||||||||||||
| 01-RC-018110 | 1984-04-04 | 1984-04-04 | 0 | 1984-03-15 | 1 | 2 | 1984-04-04 | D | 1 | 8 | ||||||||||||||
| 01-RC-018111 | 1984-04-04 | 1984-04-04 | 0 | 1984-03-15 | 1 | 2 | 1984-04-04 | P | 1 | 8 | ||||||||||||||
| 01-RC-018114 | 1984-06-12 | 1984-06-25 | 0 | 1984-04-11 | 2 | 8 | 1985-01-24 | D | 4 | 8 | 1984-06-25 | 1 | 5054 | |||||||||||
| 01-RC-018118 | 1984-04-13 | 1984-04-13 | 0 | 1984-04-02 | 1 | 2 | 1984-04-13 | A | 1 | 8 | ||||||||||||||
| 01-RC-018120 | 1984-05-11 | 0 | 1984-04-18 | 1 | 8 | 1984-05-11 | 4 | |||||||||||||||||
| 01-RC-018123 | 1984-05-07 | 1984-05-07 | 0 | 1984-04-16 | 1 | 2 | 1984-05-07 | D | 1 | 8 | ||||||||||||||
| 01-RC-018132 | 1984-05-07 | 0 | 1984-04-23 | 1 | 8 | 1984-05-07 | 4 | |||||||||||||||||
| 01-RC-018135 | 1984-05-07 | 0 | 1984-04-20 | 1 | 8 | 1984-05-07 | 4 | |||||||||||||||||
| 01-RC-018146 | 1984-06-29 | 1984-06-29 | 0 | 1984-05-21 | 1 | 2 | 1984-06-29 | Z | 1 | 8 | ||||||||||||||
| 01-RC-018147 | 1984-05-29 | 1984-05-29 | 0 | 1984-05-10 | 1 | 2 | 1984-05-29 | G | 1 | 8 | ||||||||||||||
| 01-RC-018163 | 1984-08-03 | 1984-08-03 | 0 | 1984-06-06 | 1 | 2 | 1984-08-03 | D | 1 | 8 | ||||||||||||||
| 01-RC-018174 | 1984-06-19 | 1984-06-19 | 0 | 1984-06-08 | 1 | 2 | 1984-06-19 | A | 1 | 8 | ||||||||||||||
| 01-RC-018188 | 1984-09-06 | 0 | 1984-08-13 | 1 | 8 | 1984-09-06 | 4 | |||||||||||||||||
| 01-RC-018193 | 1984-11-02 | 1984-11-14 | 0 | 1984-07-25 | 1 | 4 | 1984-11-02 | A | 1 | 8 | 1984-11-14 | 2 | ||||||||||||
| 01-RC-018194 | 1984-11-02 | 1984-11-14 | 0 | 1984-07-25 | 1 | 4 | 1984-11-02 | P | 1 | 8 | 1984-11-14 | 2 | ||||||||||||
| 01-RC-018195 | 1984-11-02 | 1984-11-02 | 0 | 1984-07-25 | 1 | 2 | 1984-11-02 | P | 1 | 8 | ||||||||||||||
| 01-RC-018198 | 1984-08-06 | 1984-08-06 | 0 | 1984-07-17 | 1 | 2 | 1984-08-06 | Z | 1 | 8 | ||||||||||||||
| 01-RC-018213 | 1984-11-23 | 0 | 1984-08-14 | 1 | 8 | 1984-11-23 | 4 | |||||||||||||||||
| 01-RC-018228 | 1984-09-19 | 1984-09-19 | 0 | 1984-08-29 | 1 | 2 | 1984-09-19 | A | 1 | 8 | ||||||||||||||
| 01-RC-018233 | 1984-10-12 | 1984-10-12 | 0 | 1984-09-13 | 1 | 2 | 1984-10-12 | A | 1 | 8 | ||||||||||||||
| 01-RC-018236 | 1984-09-25 | 1984-09-25 | 0 | 1984-09-11 | 1 | 2 | 1984-09-25 | A | 1 | 8 | ||||||||||||||
| 01-RC-018242 | 1984-10-15 | 1984-10-15 | 0 | 1984-09-25 | 1 | 2 | 1984-10-15 | D | 1 | 8 | ||||||||||||||
| 01-RC-018243 | 1984-10-15 | 1984-10-15 | 0 | 1984-09-25 | 1 | 2 | 1984-10-15 | T | 1 | 8 | ||||||||||||||
| 01-RC-018244 | 1984-11-30 | 0 | 1984-10-11 | 1 | 8 | 1984-11-30 | 4 | |||||||||||||||||
| 01-RC-018247 | 1984-10-19 | 1984-10-19 | 0 | 1984-09-21 | 1 | 2 | 1984-10-19 | A | 1 | 8 | ||||||||||||||
| 01-RC-018249 | 1984-10-18 | 1984-10-18 | 0 | 1984-09-28 | 1 | 2 | 1984-10-18 | A | 1 | |||||||||||||||
| 01-RC-018258 | 1984-11-14 | 1984-11-14 | 0 | 1984-10-22 | 1 | 2 | 1984-11-14 | A | 1 | |||||||||||||||
| 01-RC-018269 | 1984-11-26 | 1984-11-26 | 0 | 1984-11-06 | 1 | 2 | 1984-11-26 | Z | 1 | 8 | ||||||||||||||
| 01-RC-018270 | 1984-11-19 | 1984-11-19 | 0 | 1984-10-30 | 1 | 2 | 1984-11-19 | Z | 1 | 8 | ||||||||||||||
| 01-RC-018296 | 1984-12-05 | 1984-12-05 | 0 | 1984-11-13 | 1 | 2 | 1984-12-05 | A | 1 | 8 | ||||||||||||||
| 01-RC-018302 | 1984-11-27 | 1984-11-27 | 0 | 1984-11-14 | 1 | 2 | 1984-11-27 | G | 1 | 8 | ||||||||||||||
| 01-RC-018305 | 1984-12-24 | 1984-12-24 | 0 | 1984-11-29 | 1 | 2 | 1984-12-24 | D | 1 | |||||||||||||||
| 01-RC-018315 | 1985-04-10 | 1985-04-10 | 0 | 1985-03-06 | 1 | 2 | 1985-04-10 | Z | 1 | 8 | ||||||||||||||
| 01-RC-018316 | 1985-01-03 | 1985-01-03 | 0 | 1 | 2 | 1985-01-03 | D | 1 | 8 | |||||||||||||||
| 01-RC-018334 | 1985-03-27 | 1985-03-27 | 0 | 1985-01-31 | 1 | 2 | 1985-03-27 | P | 1 | 8 | ||||||||||||||
| 01-RC-018337 | 1985-03-15 | 0 | 1985-01-18 | 1 | 8 | 1985-03-15 | 4 | |||||||||||||||||
| 01-RC-018338 | 1985-05-22 | 1985-05-22 | 0 | 1985-02-02 | 1 | 2 | 1985-05-22 | P | 1 | |||||||||||||||
| 01-RC-018339 | 1985-02-07 | 1985-08-27 | 0 | 1985-01-14 | 1 | 2 | 1985-08-27 | A | 1 | |||||||||||||||
| 01-RC-018341 | 1986-05-30 | 2 | 8 | 1986-05-30 | 4 | |||||||||||||||||||
| 01-RC-018355 | 1985-03-27 | 1985-03-27 | 0 | 1985-02-22 | 1 | 2 | 1985-03-27 | A | 1 | 8 | ||||||||||||||
| 01-RC-018358 | 1985-04-11 | 0 | 1985-02-13 | 1 | 8 | 1985-04-11 | 4 | |||||||||||||||||
| 01-RC-018367 | 1985-02-28 | 1985-02-28 | 0 | 1985-02-13 | 1 | 2 | 1985-02-28 | A | 1 | 8 | ||||||||||||||
| 01-RC-018373 | 1985-03-13 | 1985-03-13 | 0 | 1985-02-26 | 1 | 2 | 1985-03-13 | A | 1 | 8 | ||||||||||||||
| 01-RC-018376 | 1985-04-25 | 1985-04-25 | 0 | 1 | 2 | 1985-04-25 | D | 1 | 8 |
Table schema
CREATE TABLE r_formal1(case_number VARCHAR, rf1_date DATE, date_last_action DATE, consol_code VARCHAR, code_date_hearing_close BIGINT, date_hearing_close DATE, control BIGINT, update_control BIGINT, date_dec_issued DATE, unit VARCHAR, type_dec BIGINT, type_specl_elect VARCHAR, date_waiver VARCHAR, date_req_review DATE, party_filing BIGINT, date_ruling_reg DATE, ruling_control BIGINT, date_board_dec_req VARCHAR, board_dec VARCHAR, type_board_dec VARCHAR, board_unit VARCHAR, volume_number VARCHAR, issue_number VARCHAR, board_members_5 VARCHAR, chips_amended_code VARCHAR);