r_master
where state = 24
Download this data as a CSV Spreadsheet (All Rows)
case_number ▼ | region | ctype | docket | file_date | close_date | date_last_action | industry | state | county | petitioner_type | petitioner | joint_petitioner | local_number | recogn_union_type | recogn_union | joint_recogn_union | unit | number_emp | proposed_no_emp | picket_8b7c | status | machine_control | proceeding_control | date_appeal | ruling_code | consol_code | date_notice_hearing_issued | date_hearing_opened | date_hearing_closed | hearing_control | code_date_closed | stage_closed | method_closed | reason_close | hearing_held_code | dec_made_code | date_agree_approv | date_appea_recd | date_action_on_appeal | chips_amended_code | date_hearing2_closed_108 | date_hearing2_open_108 | blocking_case_code | consol_sever | case_stage_action | consol_type | chips_close_flag | chips_close_date | filed_calendar_year | filed_fiscal_year | closed_calendar_year | closed_fiscal_year | blocking_case_number | consol_case_number | sub_consol_case_number | transfer_case_number |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
03-RC-008485 | 3 3 | RC | 8485 | 1983-10-31 | 1984-01-05 | 1983-12-05 | 546 | 24 24 | 165 | 1 | 26 26 | 0 | 0 | 0 | A | 2 | 0 | 21 | C | 1983-11-08 | F | 5 | X | 3 | 1983-12-05 | 0 | 1983 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
06-RD-000869 | 6 6 | RD | 869 | 1984-01-27 | 1984-03-26 | 1984-02-29 | 111 | 24 24 | 23 | 8 | 0 | 0 | 4 | 406 406 | 0 | Z | 19 | 0 | 21 | C | 1984-02-03 | F | 5 | X | 4 | 1984-02-29 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||
14-AC-000045 | 14 14 | AC | 45 | 1988-01-14 | 1988-02-29 | 1988-01-14 | 762 | 24 24 | 510 | 1 | 61 61 | 0 | 0 | 1 | 61 61 | 0 | A | 20 | 20 | 0 | A | N | 6 | 5 | 3 | 1 | 1 | 0 | 1988 | 1988 | 1988 | 1988 | ||||||||||||||||||||||||
14-AC-000046 | 14 14 | AC | 46 | 1990-06-19 | 1990-07-11 | 1990-06-19 | 805 | 24 24 | 189 | 1 | 23 23 | 0 | 0 | 1 | 23 23 | 0 | W | 65 | 65 | 0 | A | N | 6 | 5 | 3 | 1 | 1 | 0 | 1990 | 1990 | 1990 | 1990 | ||||||||||||||||||||||||
14-AC-000047 | 14 14 | AC | 47 | 1994-10-11 | 1994-11-30 | 1994-10-11 | 384 | 24 24 | 510 | 1 | 141 141 | 0 | 0 | 1 | 141 141 | 0 | A | 8 | 10 | 0 | A | A | 2 | 1 | 1 | 9 | 0 | 1994 | 1995 | 1994 | 1995 | |||||||||||||||||||||||||
14-AC-000048 | 14 14 | AC | 48 | 1997-10-07 | 1998-01-09 | 1997-10-07 | 805 | 24 24 | 510 | 1 | 23 23 | 0 | 0 | 1 | 23 23 | 0 | W | 80 | 80 | 0 | A | 1998-01-09 | 1998-01-09 | N | 6 | 5 | 3 | 1 | 1 | 0 | 1997 | 1998 | 1998 | 1998 | ||||||||||||||||||||||
14-RC-008873 | 14 14 | RC | 8873 | 1979-03-07 | 1983-10-18 | 1983-04-18 | 753 | 24 24 | 510 | 4 | 233 233 | 1 | 0 | 0 | T | 20 | 0 | 18 | B | C | 1979-03-13 | 1979-06-01 | F | 5 | X | 4 | 1979-03-27 | 0 | 02 | 01 | 1979 | 1979 | 1983 | 1984 | 14-CA-012530-001 | 14-RC-008873 | ||||||||||||||||||||
14-RC-009214 | 14 14 | RC | 9214 | 1980-07-01 | 1984-01-31 | 1980-07-29 | 201 | 24 24 | 183 | 1 | 241 241 | 0 | A | 19 | 0 | 21 | C | C | 2 | 1 | 1 | 3 | 1980-07-29 | 0 | 1980 | 1980 | 1984 | 1984 | ||||||||||||||||||||||||||||
14-RC-009250 | 14 14 | RC | 9250 | 1980-09-04 | 1984-11-07 | 1981-09-29 | 283 | 24 24 | 510 | 1 | 166 166 | 0 | 0 | 0 | W | 100 | 0 | 77 | K | 1980-09-01 | 1980-10-01 | 1980-10-01 | N | 4 | 7 | 1 | 2 | 1 | 1 | 0 | 1980 | 1980 | 1984 | 1985 | 14-CA-014549-001 | |||||||||||||||||||||
14-RC-009395 | 14 14 | RC | 9395 | 1981-03-01 | 1983-10-31 | 1981-04-08 | 421 | 24 24 | 189 | 1 | 141 141 | 0 | D | 16 | 21 | C | 1981-03-31 | F | 5 | X | 4 | 1981-04-08 | 0 | 1981 | 1981 | 1983 | 1984 | |||||||||||||||||||||||||||||
14-RC-009609 | 14 14 | RC | 9609 | 1982-06-18 | 1984-09-17 | 1984-06-15 | 805 | 24 24 | 189 | 1 | 23 23 | 0 | 0 | 0 | A | 137 | 0 | 73 | J | 1982-06-25 | F | 5 | X | 3 | 1 | 1982-07-09 | 0 | 1982 | 1982 | 1984 | 1984 | |||||||||||||||||||||||||
14-RC-009698 | 14 14 | RC | 9698 | 1983-03-11 | 1984-01-12 | 1983-05-12 | 571 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 5 | 0 | 71 | J | 1983-03-15 | F | 5 | 1 | 4 | 1983-04-08 | 0 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009710 | 14 14 | RC | 9710 | 1983-04-13 | 1983-12-13 | 1983-07-11 | 384 | 24 24 | 510 | 1 | 141 141 | 0 | 0 | 0 | A | 31 | 0 | 71 | J | 1983-04-19 | F | 5 | X | 3 | 1983-05-03 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009713 | 14 14 | RC | 9713 | 1983-04-21 | 1984-03-19 | 1983-06-10 | 805 | 24 24 | 510 | 1 | 241 241 | 0 | 0 | 0 | P | 28 | 0 | 22 | C | A | 1983-04-29 | 1983-05-11 | 1983-05-12 | N | 5 | 7 | 4 | 1 | 1 | 0 | 01 | 01 | 1983 | 1983 | 1984 | 1984 | 14-RC-009713 | |||||||||||||||||||
14-RC-009717 | 14 14 | RC | 9717 | 1983-05-02 | 1983-10-14 | 1983-05-18 | 264 | 24 24 | 510 | 1 | 245 245 | 0 | 0 | 0 | D | 14 | 0 | 21 | C | C | 5 | X | 4 | 1983-05-18 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||||
14-RC-009739 | 14 14 | RC | 9739 | 1983-06-15 | 1984-03-05 | 1983-09-09 | 805 | 24 24 | 175 | 4 | 233 233 | 0 | 0 | 0 | T | 66 | 0 | 71 | J | 1983-06-22 | F | 5 | X | 3 | 1983-07-06 | 0 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009748 | 14 14 | RC | 9748 | 1983-06-29 | 1984-03-02 | 1983-09-26 | 805 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 63 | 0 | 42 | E | 1983-07-12 | 1983-07-20 | 1983-07-22 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1983-09-26 | 1983-09-26 | 1983 | 1983 | 1984 | 1984 | |||||||||||||||||||||
14-RC-009753 | 14 14 | RC | 9753 | 1983-07-14 | 1983-10-03 | 1983-09-06 | 171 | 24 24 | 183 | 2 | 492 492 | 0 | 0 | 0 | A | 5 | 0 | 21 | C | 1983-07-25 | F | 5 | 1 | 4 | 1983-09-06 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009756 | 14 14 | RC | 9756 | 1983-07-19 | 1983-10-03 | 1983-08-24 | 805 | 24 24 | 207 | 4 | 233 233 | 0 | 0 | 0 | A | 38 | 0 | 22 | C | 1983-07-25 | 1983-08-09 | 1983-08-09 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||
14-RC-009757 | 14 14 | RC | 9757 | 1983-07-27 | 1983-11-23 | 1983-08-10 | 421 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 120 | 0 | 31 | D | 1 | A | 0 | 1 | 0 | 2 | 1983-11-23 | 0 | 8 | 1983-11-23 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||
14-RC-009761 | 14 14 | RC | 9761 | 1983-08-09 | 1983-10-11 | 1983-08-25 | 281 | 24 24 | 510 | 1 | 38 38 | 0 | 0 | 0 | A | 70 | 0 | 21 | C | 1983-08-16 | F | 5 | 1 | 4 | 1983-08-25 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009764 | 14 14 | RC | 9764 | 1983-08-17 | 1983-10-11 | 1983-09-02 | 805 | 24 24 | 189 | 1 | 23 23 | 0 | 0 | 0 | A | 18 | 0 | 21 | C | 1983-08-24 | F | 5 | 1 | 3 | 1983-09-02 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009767 | 14 14 | RC | 9767 | 1983-08-22 | 1983-10-28 | 1983-09-12 | 205 | 24 24 | 189 | 1 | 26 26 | 0 | 0 | 0 | A | 15 | 0 | 21 | C | 1983-08-31 | F | 5 | 1 | 4 | 1983-09-12 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009768 | 14 14 | RC | 9768 | 1983-08-25 | 1983-10-24 | 1983-09-13 | 805 | 24 24 | 189 | 1 | 23 23 | 0 | 0 | 0 | D | 22 | 0 | 21 | C | 1983-08-31 | F | 5 | 1 | 3 | 1983-09-13 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009770 | 14 14 | RC | 9770 | 1983-08-29 | 1983-10-12 | 1983-09-15 | 805 | 24 24 | 510 | 1 | 23 23 | 0 | 0 | 0 | A | 99 | 0 | 21 | C | 1983-09-06 | F | 2 | 1 | 1 | 7 | 1983-09-15 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||
14-RC-009772 | 14 14 | RC | 9772 | 1983-09-07 | 1983-11-07 | 1983-10-19 | 334 | 24 24 | 143 | 2 | 463 463 | 0 | 0 | 0 | A | 34 | 0 | 21 | C | 1983-09-15 | F | 5 | 1 | 3 | 1983-10-19 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009773 | 14 14 | RC | 9773 | 1983-09-14 | 1983-12-02 | 1983-10-04 | 753 | 24 24 | 189 | 2 | 303 303 | 0 | 0 | 0 | D | 71 | 0 | 21 | C | 1983-09-22 | F | 5 | 1 | 4 | 1983-10-04 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009774 | 14 14 | RC | 9774 | 1983-09-19 | 1983-11-21 | 1983-10-06 | 571 | 24 24 | 510 | 1 | 31 31 | 0 | 0 | 0 | A | 8 | 0 | 21 | C | 1983-09-28 | F | 5 | 1 | 4 | 1983-10-06 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009775 | 14 14 | RC | 9775 | 1983-09-20 | 1983-10-11 | 1983-09-26 | 251 | 24 24 | 219 | 2 | 322 322 | 0 | 0 | 0 | D | 10 | 0 | 15 | B | 1983-09-26 | D | 2 | 1 | 1 | 0 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009776 | 14 14 | RC | 9776 | 1983-09-30 | 1983-11-18 | 1983-10-19 | 421 | 24 24 | 189 | 4 | 233 233 | 0 | 0 | 0 | T | 7 | 0 | 21 | C | 1983-10-07 | F | 5 | 1 | 3 | 1983-10-19 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009779 | 14 14 | RC | 9779 | 1983-10-05 | 1983-12-23 | 1983-12-08 | 249 | 24 24 | 203 | 1 | 23 23 | 0 | 0 | 0 | A | 53 | 0 | 18 | B | 1983-10-12 | F | 5 | X | 4 | 1 | 1983-10-25 | 0 | 1983 | 1984 | 1983 | 1984 | |||||||||||||||||||||||||
14-RC-009781 | 14 14 | RC | 9781 | 1983-10-11 | 1983-11-29 | 1983-10-31 | 344 | 24 24 | 189 | 1 | 31 31 | 0 | 0 | 2 | 492 492 | 0 | A | 40 | 0 | 21 | C | 1983-10-19 | F | 5 | 1 | 3 | 1983-10-31 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||
14-RC-009782 | 14 14 | RC | 9782 | 1983-10-11 | 1983-12-02 | 1983-10-26 | 483 | 24 24 | 510 | 1 | 61 61 | 0 | 0 | 0 | D | 22 | 0 | 21 | C | 1983-10-17 | F | 5 | 1 | 3 | 1983-10-26 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009783 | 14 14 | RC | 9783 | 1983-10-11 | 1983-11-07 | 1983-10-18 | 332 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 53 | 0 | 21 | C | C | 5 | 1 | 3 | 1983-10-18 | 0 | 1983 | 1984 | 1983 | 1984 | |||||||||||||||||||||||||||
14-RC-009786 | 14 14 | RC | 9786 | 1983-10-24 | 1983-12-27 | 1983-11-17 | 412 | 24 24 | 510 | 4 | 845 845 | 0 | 0 | 5 | 0 | A | 75 | 0 | 22 | C | 1983-10-28 | 1983-11-07 | 1983-11-07 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||
14-RC-009787 | 14 14 | RC | 9787 | 1983-10-25 | 1984-01-16 | 1983-12-06 | 251 | 24 24 | 510 | 1 | 31 31 | 0 | 0 | 0 | D | 18 | 0 | 71 | J | C | 5 | X | 4 | 1983-11-01 | 0 | 1983 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
14-RC-009788 | 14 14 | RC | 9788 | 1983-10-25 | 1984-01-09 | 1983-11-21 | 421 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | A | 100 | 0 | 21 | C | 1983-11-03 | F | 5 | 1 | 3 | 1983-11-21 | 0 | 1983 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009789 | 14 14 | RC | 9789 | 1983-10-26 | 1983-12-09 | 1983-11-15 | 354 | 24 24 | 510 | 1 | 141 141 | 0 | 0 | 0 | A | 15 | 0 | 21 | C | 1983-11-02 | F | 5 | 1 | 4 | 1983-11-15 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009790 | 14 14 | RC | 9790 | 1983-10-26 | 1983-12-19 | 1983-11-15 | 346 | 24 24 | 510 | 1 | 141 141 | 0 | 0 | 0 | A | 10 | 0 | 21 | C | 1983-11-01 | F | 5 | 1 | 3 | 1983-11-15 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009791 | 14 14 | RC | 9791 | 1983-10-26 | 1983-12-27 | 1983-11-16 | 739 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | A | 5 | 0 | 21 | C | 1983-11-02 | F | 5 | 1 | 4 | 1983-11-16 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009792 | 14 14 | RC | 9792 | 1983-10-27 | 1984-01-16 | 1983-12-06 | 805 | 24 24 | 510 | 1 | 23 23 | 0 | 0 | 0 | A | 160 | 0 | 22 | C | A | 1983-11-03 | 1983-11-23 | 1983-11-23 | N | 5 | 7 | 3 | 1 | 1 | 0 | 01 | 01 | 1983 | 1984 | 1984 | 1984 | 14-RC-009792 | |||||||||||||||||||
14-RC-009793 | 14 14 | RC | 9793 | 1983-10-27 | 1984-02-07 | 1983-11-09 | 328 | 24 24 | 31 | 1 | 63 63 | 0 | 0 | 1 | 63 63 | 0 | A | 5 | 0 | 31 | D | 1 | A | 0 | 1 | 0 | 2 | 1984-02-07 | 0 | 1983 | 1984 | 1984 | 1984 | |||||||||||||||||||||||
14-RC-009794 | 14 14 | RC | 9794 | 1983-10-31 | 1983-12-12 | 1983-11-29 | 421 | 24 24 | 189 | 4 | 233 233 | 0 | 0 | 2 | 401 401 | 0 | T | 9 | 0 | 31 | D | 1983-11-07 | D | 1 | 1 | 0 | 5 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||
14-RC-009795 | 14 14 | RC | 9795 | 1983-11-02 | 1984-01-16 | 1983-12-06 | 805 | 24 24 | 510 | 1 | 23 23 | 0 | 0 | 0 | A | 160 | 0 | 22 | C | C | 1983-11-04 | 1983-11-23 | 1983-11-23 | N | 5 | 7 | 3 | 1 | 1 | 0 | 02 | 01 | 1983 | 1984 | 1984 | 1984 | 14-RC-009792 | 14-RC-009795 | ||||||||||||||||||
14-RC-009796 | 14 14 | RC | 9796 | 1983-11-03 | 1983-12-30 | 1983-11-25 | 422 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 40 | 0 | 21 | C | 1983-11-10 | F | 5 | 1 | 4 | 1983-11-25 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009797 | 14 14 | RC | 9797 | 1983-11-07 | 1983-12-30 | 1983-11-23 | 734 | 24 24 | 510 | 1 | 23 23 | 0 | 0 | 0 | A | 85 | 0 | 21 | C | 1983-11-10 | F | 5 | 1 | 3 | 1983-11-23 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009798 | 14 14 | RC | 9798 | 1983-11-07 | 1983-12-23 | 1983-11-28 | 521 | 24 24 | 31 | 4 | 233 233 | 0 | 0 | 2 | 492 492 | 0 | T | 36 | 0 | 21 | C | C | 5 | 1 | 3 | 1983-11-28 | 0 | 1983 | 1984 | 1983 | 1984 | |||||||||||||||||||||||||
14-RC-009799 | 14 14 | RC | 9799 | 1983-11-07 | 1983-12-27 | 1983-11-23 | 737 | 24 24 | 143 | 1 | 63 63 | 0 | 0 | 0 | D | 12 | 0 | 21 | C | C | 5 | 1 | 3 | 1983-11-23 | 0 | 1983 | 1984 | 1983 | 1984 | |||||||||||||||||||||||||||
14-RC-009800 | 14 14 | RC | 9800 | 1983-11-09 | 1984-01-19 | 1983-12-12 | 489 | 24 24 | 510 | 2 | 473 473 | 0 | 0 | 0 | R | 115 | 0 | 21 | C | 1983-11-18 | F | 5 | 1 | 3 | 1983-12-12 | 0 | 1983 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009801 | 14 14 | RC | 9801 | 1983-11-14 | 1983-12-29 | 1983-12-07 | 805 | 24 24 | 143 | 4 | 233 233 | 0 | 0 | 0 | T | 40 | 0 | 21 | C | 1983-11-22 | F | 5 | 1 | 3 | 1983-12-07 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009802 | 14 14 | RC | 9802 | 1983-11-16 | 1983-12-19 | 1983-11-29 | 222 | 24 24 | 183 | 1 | 150 150 | 0 | 0 | 0 | A | 40 | 0 | 21 | C | 1983-11-25 | F | 5 | 1 | 4 | 1983-11-29 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||||
14-RC-009803 | 14 14 | RC | 9803 | 1983-11-18 | 1984-03-28 | 1984-03-07 | 174 | 24 24 | 510 | 1 | 4 4 | 0 | 0 | 0 | A | 23 | 0 | 75 | K | 1983-11-29 | F | 5 | 1 | 3 | 1983-12-23 | 0 | 1983 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009805 | 14 14 | RC | 9805 | 1983-12-01 | 1984-02-06 | 1983-12-23 | 805 | 24 24 | 510 | 1 | 23 23 | 0 | 0 | 0 | A | 63 | 0 | 21 | C | 1983-12-08 | F | 5 | 1 | 4 | 1983-12-23 | 0 | 1983 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009806 | 14 14 | RC | 9806 | 1983-12-01 | 1984-02-17 | 1984-01-10 | 264 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 17 | 0 | 22 | C | 1983-12-14 | 1983-12-21 | 1983-12-21 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1983 | 1984 | 1984 | 1984 | |||||||||||||||||||||||
14-RC-009807 | 14 14 | RC | 9807 | 1983-12-02 | 1987-01-25 | 1984-01-10 | 483 | 24 24 | 510 | 1 | 61 61 | 0 | 0 | 0 | D | 6 | 0 | 22 | C | 1983-12-09 | 1983-12-16 | 1983-12-21 | N | 4 | 9 | 1 | 0 | 1 | 1 | 0 | 1983 | 1984 | 1987 | 1987 | ||||||||||||||||||||||
14-RC-009808 | 14 14 | RC | 9808 | 1983-12-06 | 1984-01-31 | 1983-12-19 | 553 | 24 24 | 189 | 4 | 233 233 | 0 | 0 | 0 | T | 10 | 0 | 21 | C | C | 5 | 1 | 4 | 1983-12-19 | 0 | 1983 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
14-RC-009809 | 14 14 | RC | 9809 | 1983-12-08 | 1983-12-12 | 1983-12-08 | 423 | 24 24 | 193 | 4 | 233 233 | 0 | 0 | 0 | T | 3 | 0 | A | A | 2 | 1 | 1 | 0 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||||||
14-RC-009810 | 14 14 | RC | 9810 | 1983-12-14 | 1986-04-07 | 1984-08-13 | 805 | 24 24 | 31 | 4 | 233 233 | 0 | 0 | 0 | T | 68 | 0 | 17 | B | 1983-12-22 | 1984-01-06 | 1984-01-06 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1983 | 1984 | 1986 | 1986 | |||||||||||||||||||||||
14-RC-009811 | 14 14 | RC | 9811 | 1983-12-14 | 1984-01-16 | 1983-12-21 | 805 | 24 24 | 510 | 1 | 23 23 | 0 | 0 | 0 | Z | 28 | 0 | 15 | B | 1983-12-21 | D | 2 | 1 | 1 | 0 | 0 | 1983 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009812 | 14 14 | RC | 9812 | 1983-12-14 | 1984-01-23 | 1983-12-27 | 395 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 9 | 0 | 21 | C | F | 5 | 1 | 3 | 1983-12-27 | 0 | 1983 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
14-RC-009813 | 14 14 | RC | 9813 | 1983-12-19 | 1984-02-13 | 1984-01-18 | 598 | 24 24 | 71 | 4 | 233 233 | 0 | 0 | 0 | T | 3 | 0 | 21 | C | 1983-12-23 | F | 5 | 1 | 3 | 1984-01-18 | 0 | 1983 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009815 | 14 14 | RC | 9815 | 1983-12-22 | 1984-01-24 | 1984-01-04 | 753 | 24 24 | 189 | 1 | 141 141 | 0 | 0 | 0 | Z | 5 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-01-04 | 0 | 1983 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
14-RC-009816 | 14 14 | RC | 9816 | 1983-12-29 | 1984-01-09 | 1983-12-29 | 263 | 24 24 | 189 | 4 | 233 233 | 0 | 0 | 0 | T | 35 | 0 | A | A | 2 | 1 | 1 | 0 | 0 | 1983 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||||
14-RC-009817 | 14 14 | RC | 9817 | 1984-01-05 | 1984-03-08 | 1984-01-16 | 307 | 24 24 | 510 | 1 | 88 88 | 0 | 0 | 0 | A | 11 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-01-16 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
14-RC-009818 | 14 14 | RC | 9818 | 1984-01-09 | 1984-03-05 | 1984-01-25 | 361 | 24 24 | 31 | 4 | 233 233 | 0 | 0 | 0 | T | 8 | 0 | 21 | C | 1984-01-18 | C | 5 | 1 | 3 | 1984-01-25 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009819 | 14 14 | RC | 9819 | 1984-01-09 | 1984-03-09 | 1984-01-24 | 951 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 12 | 0 | 21 | C | 1984-01-13 | I | 5 | 2 | 4 | 1984-01-24 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009822 | 14 14 | RC | 9822 | 1984-01-16 | 1984-03-13 | 1984-02-03 | 571 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 11 | 0 | 21 | C | 1984-01-25 | F | 4 | 1 | 1 | 9 | 1984-02-03 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||
14-RC-009824 | 14 14 | RC | 9824 | 1984-01-23 | 1984-02-09 | 1984-01-27 | 421 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 2 | 0 | 15 | B | 1984-01-27 | D | 2 | 1 | 1 | 9 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009825 | 14 14 | RC | 9825 | 1984-01-23 | 1984-04-06 | 1984-02-28 | 739 | 24 24 | 510 | 4 | 946 946 | 0 | 0 | 0 | G | 9 | 0 | 22 | C | 1984-01-27 | 1984-02-14 | 1984-02-14 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||
14-RC-009826 | 14 14 | RC | 9826 | 1984-01-31 | 1984-02-16 | 1984-02-03 | 551 | 24 24 | 183 | 1 | 141 141 | 0 | 0 | 0 | D | 6 | 0 | 15 | B | 1984-02-03 | D | 2 | 1 | 1 | 9 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009827 | 14 14 | RC | 9827 | 1984-02-02 | 1984-04-17 | 1984-03-14 | 307 | 24 24 | 189 | 1 | 101 101 | 0 | 0 | 0 | A | 25 | 0 | 22 | C | 1984-02-09 | 1984-02-22 | 1984-02-22 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||
14-RC-009829 | 14 14 | RC | 9829 | 1984-02-07 | 1984-03-26 | 1984-02-28 | 336 | 24 24 | 189 | 1 | 141 141 | 0 | 0 | 0 | D | 7 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-02-28 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
14-RC-009830 | 14 14 | RC | 9830 | 1984-02-10 | 1984-03-26 | 1984-02-29 | 243 | 24 24 | 189 | 1 | 31 31 | 0 | 0 | 0 | A | 10 | 0 | 21 | C | 1984-02-16 | F | 5 | 1 | 4 | 1984-02-29 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009831 | 14 14 | RC | 9831 | 1984-02-13 | 1985-01-02 | 1984-03-20 | 541 | 24 24 | 99 | 1 | 241 241 | 0 | 0 | 0 | A | 78 | 0 | 22 | C | 1984-02-17 | 1984-03-02 | 1984-03-02 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1984 | 1984 | 1985 | 1985 | |||||||||||||||||||||||
14-RC-009832 | 14 14 | RC | 9832 | 1984-02-13 | 1984-02-17 | 1984-02-13 | 541 | 24 24 | 99 | 1 | 241 241 | 0 | 0 | 0 | D | 6 | 0 | A | A | 2 | 1 | 1 | 8 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||||
14-RC-009833 | 14 14 | RC | 9833 | 1984-02-16 | 1984-04-23 | 1984-03-14 | 581 | 24 24 | 187 | 2 | 463 463 | 0 | 0 | 0 | A | 49 | 0 | 22 | C | 1984-02-23 | 1984-03-02 | 1984-03-02 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||
14-RC-009834 | 14 14 | RC | 9834 | 1984-02-16 | 1984-04-16 | 1984-03-06 | 551 | 24 24 | 183 | 1 | 141 141 | 0 | 0 | 0 | D | 13 | 0 | 21 | C | 1984-02-22 | F | 5 | 1 | 3 | 1984-03-06 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009835 | 14 14 | RC | 9835 | 1984-02-17 | 1984-03-21 | 1984-03-02 | 421 | 24 24 | 99 | 4 | 233 233 | 0 | 0 | 0 | T | 24 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-03-02 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
14-RC-009836 | 14 14 | RC | 9836 | 1984-02-17 | 1984-04-16 | 1984-03-14 | 422 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 8 | 0 | 21 | C | 1984-02-29 | F | 5 | 1 | 4 | 1984-03-14 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009837 | 14 14 | RC | 9837 | 1984-02-21 | 1984-02-24 | 1984-02-21 | 805 | 24 24 | 510 | 1 | 23 23 | 0 | 0 | 0 | A | 90 | 0 | A | A | 2 | 1 | 1 | 6 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||||
14-RC-009838 | 14 14 | RC | 9838 | 1984-03-02 | 1985-05-31 | 1984-12-24 | 253 | 24 24 | 31 | 2 | 303 303 | 0 | 0 | 0 | A | 450 | 0 | 75 | K | 1984-03-07 | F | 5 | X | 4 | 1 | 1984-03-28 | 0 | 1984 | 1984 | 1985 | 1985 | |||||||||||||||||||||||||
14-RC-009839 | 14 14 | RC | 9839 | 1984-03-02 | 1984-04-02 | 1984-03-12 | 421 | 24 24 | 189 | 2 | 492 492 | 0 | 0 | 0 | A | 41 | 0 | 20 | C | B | 5 | 1 | 3 | 1984-03-12 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
14-RC-009840 | 14 14 | RC | 9840 | 1984-03-02 | 1984-05-07 | 1984-03-29 | 805 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 119 | 0 | 21 | C | 1984-03-12 | F | 5 | 1 | 4 | 1984-03-29 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009841 | 14 14 | RC | 9841 | 1984-03-08 | 1984-04-03 | 1984-03-21 | 509 | 24 24 | 510 | 1 | 130 130 | 0 | 1 | 0 | A | 25 | 0 | 31 | D | 1984-03-15 | D | 1 | 1 | 0 | 2 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009842 | 14 14 | RC | 9842 | 1984-03-09 | 1984-05-21 | 1984-04-13 | 382 | 24 24 | 510 | 1 | 141 141 | 0 | 0 | 0 | A | 54 | 0 | 22 | C | 1984-03-15 | 1984-03-30 | 1984-03-30 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||
14-RC-009843 | 14 14 | RC | 9843 | 1984-03-09 | 1984-05-07 | 1984-03-29 | 581 | 24 24 | 510 | 1 | 105 105 | 0 | 0 | 0 | A | 65 | 0 | 21 | C | 1984-03-15 | F | 5 | 1 | 3 | 1984-03-29 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009846 | 14 14 | RC | 9846 | 1984-03-30 | 1984-05-29 | 1984-05-01 | 489 | 24 24 | 510 | 1 | 61 61 | 0 | 0 | 0 | D | 13 | 0 | 21 | C | 1984-04-09 | F | 5 | 1 | 4 | 1984-05-01 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009847 | 14 14 | RC | 9847 | 1984-04-03 | 1984-06-04 | 1984-04-27 | 354 | 24 24 | 189 | 1 | 141 141 | 0 | 0 | 0 | A | 8 | 0 | 21 | C | 1984-04-09 | F | 5 | 1 | 4 | 1984-04-27 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009848 | 14 14 | RC | 9848 | 1984-04-05 | 1984-05-04 | 1984-04-26 | 327 | 24 24 | 183 | 4 | 233 233 | 0 | 0 | 0 | T | 3 | 0 | 41 | E | 1984-04-17 | 1984-04-26 | 1984-04-26 | N | 3 | 5 | 0 | 3 | 1 | 1 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||
14-RC-009849 | 14 14 | RC | 9849 | 1984-04-09 | 1984-06-05 | 1984-04-23 | 242 | 24 24 | 35 | 4 | 233 233 | 0 | 0 | 0 | T | 145 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-04-23 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
14-RC-009850 | 14 14 | RC | 9850 | 1984-04-11 | 1984-06-22 | 1984-05-15 | 265 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 17 | 0 | 22 | C | 1984-04-16 | 1984-05-02 | 1984-05-02 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||
14-RC-009852 | 14 14 | RC | 9852 | 1984-04-18 | 1984-06-05 | 1984-05-03 | 805 | 24 24 | 510 | 1 | 23 23 | 0 | 0 | 0 | A | 90 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-05-03 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
14-RC-009853 | 14 14 | RC | 9853 | 1984-04-19 | 1984-05-21 | 1984-05-07 | 353 | 24 24 | 183 | 1 | 63 63 | 0 | 0 | 0 | D | 3 | 0 | 31 | D | 1984-04-25 | D | 1 | 1 | 0 | 9 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009854 | 14 14 | RC | 9854 | 1984-05-01 | 1984-06-07 | 1984-05-11 | 243 | 24 24 | 510 | 2 | 492 492 | 0 | 0 | 1 | 31 31 | 0 | A | 3 | 0 | 21 | C | 1984-05-04 | F | 5 | 1 | 3 | 1984-05-11 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||
14-RC-009855 | 14 14 | RC | 9855 | 1984-05-03 | 1984-06-19 | 1984-05-25 | 614 | 24 24 | 187 | 2 | 463 463 | 0 | 0 | 0 | A | 14 | 0 | 21 | C | 1984-05-09 | F | 5 | 1 | 3 | 1984-05-25 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009856 | 14 14 | RC | 9856 | 1984-05-08 | 1987-02-23 | 1987-02-09 | 152 | 24 24 | 510 | 1 | 178 178 | 0 | 0 | 0 | C | 20 | 0 | 31 | D | 3 | A | 1 | 1 | 0 | 2 | 1984-06-19 | 1986-10-08 | 0 | 1984 | 1984 | 1987 | 1987 | ||||||||||||||||||||||||
14-RC-009858 | 14 14 | RC | 9858 | 1984-05-09 | 1984-06-05 | 1984-05-15 | 839 | 24 24 | 510 | 1 | 246 246 | 0 | 0 | 0 | W | 7 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-05-15 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
14-RC-009860 | 14 14 | RC | 9860 | 1984-05-11 | 1984-07-10 | 1984-06-14 | 421 | 24 24 | 510 | 4 | 233 233 | 0 | 0 | 0 | T | 10 | 0 | 21 | C | 1984-05-18 | F | 5 | 1 | 3 | 1984-06-14 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009861 | 14 14 | RC | 9861 | 1984-05-11 | 1984-06-27 | 1984-06-05 | 521 | 24 24 | 99 | 4 | 233 233 | 0 | 0 | 0 | T | 9 | 0 | 21 | C | 1984-05-25 | F | 5 | 1 | 3 | 1984-06-05 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
14-RC-009862 | 14 14 | RC | 9862 | 1984-05-15 | 1984-06-29 | 1984-06-01 | 541 | 24 24 | 183 | 1 | 241 241 | 0 | 0 | 0 | D | 2 | 0 | 21 | C | 1984-05-23 | F | 5 | 1 | 4 | 1984-06-01 | 0 | 1984 | 1984 | 1984 | 1984 |
CREATE TABLE "r_master" ( [case_number] TEXT PRIMARY KEY, [region] INTEGER REFERENCES [regions]([region_num]), [ctype] TEXT, [docket] INTEGER, [file_date] TEXT, [close_date] TEXT, [date_last_action] TEXT, [industry] TEXT, [state] INTEGER, [county] INTEGER, [petitioner_type] TEXT, [petitioner] INTEGER, [joint_petitioner] INTEGER, [local_number] TEXT, [recogn_union_type] TEXT, [recogn_union] INTEGER, [joint_recogn_union] INTEGER, [unit] TEXT, [number_emp] INTEGER, [proposed_no_emp] INTEGER, [picket_8b7c] INTEGER, [status] TEXT, [machine_control] TEXT, [proceeding_control] TEXT, [date_appeal] INTEGER, [ruling_code] TEXT, [consol_code] TEXT, [date_notice_hearing_issued] TEXT, [date_hearing_opened] TEXT, [date_hearing_closed] TEXT, [hearing_control] TEXT, [code_date_closed] INTEGER, [stage_closed] TEXT, [method_closed] TEXT, [reason_close] TEXT, [hearing_held_code] INTEGER, [dec_made_code] TEXT, [date_agree_approv] TEXT, [date_appea_recd] TEXT, [date_action_on_appeal] TEXT, [chips_amended_code] INTEGER, [date_hearing2_closed_108] TEXT, [date_hearing2_open_108] TEXT, [blocking_case_code] TEXT, [consol_sever] TEXT, [case_stage_action] TEXT, [consol_type] TEXT, [chips_close_flag] TEXT, [chips_close_date] TEXT, [filed_calendar_year] INTEGER, [filed_fiscal_year] INTEGER, [closed_calendar_year] INTEGER, [closed_fiscal_year] INTEGER, [blocking_case_number] TEXT, [consol_case_number] TEXT, [sub_consol_case_number] TEXT, [transfer_case_number] TEXT, FOREIGN KEY([state]) REFERENCES [l_state_codes]([code]), FOREIGN KEY([unit]) REFERENCES [l_unit_codes]([code]), FOREIGN KEY([petitioner]) REFERENCES [l_union_codes_and_names]([code]), FOREIGN KEY([recogn_union]) REFERENCES [l_union_codes_and_names]([code]) );