r_master
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
01-AC-000077 | 1 1 | AC | 77 | 1984-04-24 | 1984-05-02 | 1984-04-24 | 295 | 20 20 | 25 | 1 | 63 63 | 0 | 0 | 1 | 63 63 | 0 | Z | 4 | 0 | A | A | 2 | 1 | 1 | 8 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
01-AC-000078 | 1 1 | AC | 78 | 1984-07-30 | 1984-10-31 | 1984-10-31 | 519 | 20 20 | 9 | 5 | 0 | 1 | 5 | 0 | D | 32 | 0 | 61 | H | 1984-08-10 | 1984-08-24 | 1984-08-27 | K | 8 | 0 | 9 | 1 | 0 | 1984 | 1984 | 1984 | 1985 | 01-AC-000078 | |||||||||||||||||||||||
01-AC-000079 | 1 1 | AC | 79 | 1984-12-24 | 1985-02-13 | 1984-12-24 | 739 | 20 20 | 15 | 1 | 105 105 | 0 | 0 | 1 | 105 105 | 0 | Z | 70 | 0 | A | N | 6 | 5 | 3 | 1 | 1 | 0 | 1984 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||
01-AC-000080 | 1 1 | AC | 80 | 1985-04-26 | 1985-07-15 | 1985-06-06 | 822 | 20 20 | 25 | 5 | 0 | 0 | 0 | P | 42 | 0 | 15 | B | 1985-06-06 | D | 2 | 1 | 1 | 9 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
01-AC-000081 | 1 1 | AC | 81 | 1985-08-21 | 1985-09-12 | 1985-08-21 | 171 | 20 20 | 9 | 1 | 178 178 | 0 | 0 | 0 | P | 8 | 0 | A | A | 2 | 1 | 1 | 9 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||||
01-AC-000082 | 1 1 | AC | 82 | 1985-09-30 | 1985-12-09 | 1985-11-14 | 171 | 20 20 | 9 | 1 | 178 178 | 0 | 0 | 0 | C | 8 | 0 | 41 | E | 1985-11-06 | 1985-11-14 | 1985-11-14 | N | 6 | 5 | 3 | 1 | 1 | 0 | 1985 | 1985 | 1985 | 1986 | |||||||||||||||||||||||
01-AC-000083 | 1 1 | AC | 83 | 1986-10-03 | 1986-10-21 | 1986-10-03 | 739 | 20 20 | 9 | 1 | 245 245 | 0 | 0 | 0 | W | 240 | 255 | 0 | A | A | 2 | 1 | 1 | 8 | 0 | 1986 | 1987 | 1986 | 1987 | |||||||||||||||||||||||||||
01-AC-000084 | 1 1 | AC | 84 | 1987-08-20 | 1987-09-23 | 1987-08-20 | 517 | 38 38 | 3 | 1 | 141 141 | 0 | 0 | 1 | 141 141 | 0 | A | 0 | A | N | 7 | 5 | 0 | 1 | 1 | 0 | 1987 | 1987 | 1987 | 1987 | ||||||||||||||||||||||||||
01-AC-000085 | 1 1 | AC | 85 | 1991-04-11 | 1991-05-06 | 1991-04-11 | 805 | 20 20 | 5 | 1 | 23 23 | 0 | 0 | 0 | P | 0 | A | A | 2 | 1 | 1 | 0 | 1991 | 1991 | 1991 | 1991 | ||||||||||||||||||||||||||||||
01-AC-000086 | 1 1 | AC | 86 | 1993-11-24 | 1993-12-22 | 1993-11-24 | 738 | 20 20 | 11 | 5 | 0 | 0 | 5 | 0 | G | 22 | 22 | 0 | A | A | 2 | 1 | 1 | 0 | 1993 | 1994 | 1993 | 1994 | ||||||||||||||||||||||||||||
01-AC-000087 | 1 1 | AC | 87 | 1994-12-20 | 1995-06-28 | 1995-01-04 | 721 | 38 38 | 7 | 2 | 583 583 | 0 | 0 | 0 | A | 25 | 0 | 15 | B | 1995-01-04 | D | 2 | 1 | 1 | 7 | 0 | 1994 | 1995 | 1995 | 1995 | ||||||||||||||||||||||||||
01-AC-000088 | 1 1 | AC | 88 | 1994-12-20 | 1995-06-28 | 1994-12-20 | 721 | 20 20 | 25 | 2 | 583 583 | 0 | 0 | 0 | A | 150 | 0 | A | A | 2 | 1 | 1 | 7 | 0 | 1994 | 1995 | 1995 | 1995 | ||||||||||||||||||||||||||||
01-AC-000089 | 1 1 | AC | 89 | 1994-12-20 | 1995-06-28 | 1995-01-04 | 721 | 20 20 | 21 | 2 | 583 583 | 0 | 0 | 0 | A | 25 | 0 | 15 | B | 1995-01-04 | D | 2 | 1 | 1 | 7 | 0 | 1994 | 1995 | 1995 | 1995 | ||||||||||||||||||||||||||
01-AC-000090 | 1 1 | AC | 90 | 1994-12-20 | 1995-06-28 | 1994-12-20 | 721 | 20 20 | 25 | 2 | 583 583 | 0 | 0 | 0 | A | 11 | 0 | A | A | 2 | 1 | 1 | 7 | 0 | 1994 | 1995 | 1995 | 1995 | ||||||||||||||||||||||||||||
01-AC-000091 | 1 1 | AC | 91 | 1995-01-09 | 1995-06-28 | 1995-01-09 | 721 | 20 20 | 0 | 2 | 583 583 | 0 | 0 | 0 | A | 0 | A | A | 2 | 1 | 1 | 7 | 0 | 1995 | 1995 | 1995 | 1995 | |||||||||||||||||||||||||||||
01-AC-000092 | 1 1 | AC | 92 | 1995-10-12 | 1995-11-06 | 1995-10-12 | 514 | 44 44 | 25 | 4 | 233 233 | 0 | 0 | 0 | D | 150 | 0 | A | A | 2 | 1 | 1 | 0 | 1995 | 1996 | 1995 | 1996 | |||||||||||||||||||||||||||||
01-RC-015889 | 1 1 | RC | 15889 | 1978-08-10 | 1985-01-30 | 1979-05-17 | 251 | 20 20 | 25 | 1 | 121 121 | 0 | 0 | 0 | C | 44 | 0 | 73 | J | 1978-08-17 | F | 5 | X | 4 | 1 | 1978-09-14 | 0 | 1978 | 1978 | 1985 | 1985 | |||||||||||||||||||||||||
01-RC-016265 | 1 1 | RC | 16265 | 1979-03-01 | 1986-11-20 | 1980-12-12 | 822 | 20 20 | 13 | 5 | 0 | Z | 73 | 0 | 61 | H | 1979-04-18 | 1979-05-01 | P | 1 | 5 | 0 | 0 | 1980-12-03 | 1980-12-03 | 1979 | 1979 | 1986 | 1987 | |||||||||||||||||||||||||||
01-RC-017055 | 1 1 | RC | 17055 | 1980-10-01 | 1984-09-10 | 1980-10-07 | 344 | 20 20 | 17 | 4 | 541 541 | 0 | A | 11 | 1 | A | A | 2 | 1 | 1 | 9 | 0 | 1980 | 1981 | 1984 | 1984 | ||||||||||||||||||||||||||||||
01-RC-017183 | 1 1 | RC | 17183 | 1981-02-01 | 1984-07-10 | 1981-07-17 | 171 | 18 18 | 5 | 1 | 178 178 | 0 | D | 15 | 18 | B | 1981-02-01 | 1981-03-01 | F | 5 | X | 3 | 0 | 1981 | 1981 | 1984 | 1984 | |||||||||||||||||||||||||||||
01-RC-017262 | 1 1 | RC | 17262 | 1981-04-01 | 1986-11-05 | 1981-05-18 | 822 | 18 18 | 5 | 1 | 232 232 | 0 | P | 37 | 1 | 22 | C | 1981-04-09 | 1981-04-01 | P | 1 | 5 | 0 | 1 | 1 | 0 | 1981 | 1981 | 1986 | 1987 | ||||||||||||||||||||||||||
01-RC-017441 | 1 1 | RC | 17441 | 1981-09-04 | 1986-01-16 | 1982-04-14 | 739 | 20 20 | 9 | 2 | 342 342 | 0 | 0 | 0 | A | 0 | 18 | B | W | 1981-09-21 | 1981-09-28 | 1981-09-30 | N | 4 | X | 1 | 0 | 1 | 1 | 0 | 02 | 03 | 5 | 1981 | 1981 | 1986 | 1986 | 01-CA-019402-001 | ||||||||||||||||||
01-RC-017455 | 1 1 | RC | 17455 | 1981-09-17 | 1986-06-18 | 1981-09-17 | 173 | 38 38 | 7 | 1 | 61 61 | 0 | 0 | 0 | C | 10 | 0 | 15 | B | 1981-09-01 | D | 4 | 1 | 1 | 5 | 0 | 1981 | 1981 | 1986 | 1986 | ||||||||||||||||||||||||||
01-RC-017475 | 1 1 | RC | 17475 | 1981-10-16 | 1986-10-16 | 1982-07-30 | 805 | 44 44 | 27 | 2 | 451 451 | 0 | 1 | 0 | P | 55 | 0 | 79 | K | C | 1981-10-26 | 1981-10-30 | 1981-11-18 | N | 5 | 7 | 3 | 1 | 1 | 0 | 02 | 01 | 1981 | 1982 | 1986 | 1987 | 01-CA-019299-001 | 01-RC-017475 | ||||||||||||||||||
01-RC-017569 | 1 1 | RC | 17569 | 1982-02-18 | 1984-02-06 | 1983-12-23 | 173 | 18 18 | 19 | 1 | 61 61 | 0 | 0 | 0 | C | 45 | 0 | 22 | C | 1982-02-26 | 1982-03-03 | 1982-03-08 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1982 | 1982 | 1984 | 1984 | |||||||||||||||||||||||
01-RC-017622 | 1 1 | RC | 17622 | 1982-04-20 | 1985-05-06 | 1982-05-18 | 238 | 20 20 | 3 | 1 | 121 121 | 0 | 0 | 0 | A | 70 | 1 | 22 | C | 1982-04-29 | 1982-05-05 | 1982-05-05 | N | 2 | 1 | 1 | 9 | 1 | 1 | 0 | 1982 | 1982 | 1985 | 1985 | ||||||||||||||||||||||
01-RC-017696 | 1 1 | RC | 17696 | 1982-07-14 | 1984-12-18 | 1984-11-13 | 806 | 28 28 | 11 | 4 | 748 748 | 0 | 0 | 0 | P | 54 | 0 | 42 | E | 1982-07-22 | 1982-08-02 | 1982-08-17 | N | 3 | 5 | 0 | 9 | 1 | 1 | 0 | 1984-11-13 | 1984-11-13 | 1982 | 1982 | 1984 | 1985 | ||||||||||||||||||||
01-RC-017700 | 1 1 | RC | 17700 | 1982-07-23 | 1982-09-02 | 1982-09-02 | 386 | 20 20 | 3 | 1 | 61 61 | 0 | 0 | 0 | A | 110 | 0 | 22 | C | 1982-07-30 | 1982-08-13 | 1982-08-13 | N | 3 | 5 | 0 | 1 | 1 | 0 | 1982 | 1982 | 1982 | 1982 | |||||||||||||||||||||||
01-RC-017711 | 1 1 | RC | 17711 | 1982-08-11 | 1985-01-21 | 1984-11-21 | 208 | 20 20 | 21 | 2 | 303 303 | 0 | 0 | 0 | A | 190 | 0 | 22 | C | 1984-09-27 | 1984-10-12 | 1984-10-12 | N | 4 | 9 | 1 | 8 | 1 | 1 | 0 | 1982 | 1982 | 1985 | 1985 | ||||||||||||||||||||||
01-RC-017718 | 1 1 | RC | 17718 | 1982-08-23 | 1984-04-20 | 1982-12-20 | 531 | 20 20 | 3 | 1 | 241 241 | 0 | 0 | 0 | Z | 375 | 0 | 18 | B | N | 1982-09-02 | F | 5 | X | 4 | 1982-09-10 | 0 | 02 | 05 | 1982 | 1982 | 1984 | 1984 | 01-CA-020252-001 | ||||||||||||||||||||||
01-RC-017724 | 1 1 | RC | 17724 | 1982-08-31 | 1985-12-30 | 1982-08-31 | 295 | 20 20 | 13 | 4 | 233 233 | 0 | 0 | 0 | T | 5 | 0 | A | A | 2 | 1 | 1 | 7 | 0 | 1982 | 1982 | 1985 | 1986 | ||||||||||||||||||||||||||||
01-RC-017736 | 1 1 | RC | 17736 | 1982-09-14 | 1985-06-04 | 1985-05-06 | 154 | 20 20 | 27 | 1 | 103 103 | 0 | 0 | 0 | A | 22 | 0 | 41 | E | A | 1982-09-22 | 1985-05-06 | 1985-05-06 | J | 2 | 1 | 1 | 9 | 1 | 0 | 01 | 01 | 1982 | 1982 | 1985 | 1985 | 01-RC-017736 | |||||||||||||||||||
01-RC-017751 | 1 1 | RC | 17751 | 1982-10-04 | 1985-07-09 | 1985-06-04 | 154 | 20 20 | 27 | 1 | 61 61 | 0 | 1 | 0 | Z | 18 | 0 | 22 | C | E | 1985-05-06 | 1985-05-06 | 1985-05-06 | N | 5 | 7 | 3 | 1 | 1 | 0 | 03 | 01 | 1982 | 1983 | 1985 | 1985 | 01-RC-017736 | 01-RC-017751 | ||||||||||||||||||
01-RC-017757 | 1 1 | RC | 17757 | 1982-10-08 | 1985-02-19 | 1982-11-19 | 805 | 20 20 | 23 | 1 | 23 23 | 0 | 0 | 0 | Z | 110 | 0 | 22 | C | 1982-10-19 | 1982-10-27 | 1982-11-05 | N | 4 | 7 | 1 | 9 | 1 | 1 | 0 | 1982 | 1983 | 1985 | 1985 | ||||||||||||||||||||||
01-RC-017764 | 1 1 | RC | 17764 | 1982-10-18 | 1984-05-11 | 1983-02-28 | 598 | 18 18 | 19 | 1 | 187 187 | 0 | 0 | 0 | Z | 15 | 0 | 73 | J | 1982-10-26 | F | 4 | 1 | 1 | 7 | 1982-11-15 | 0 | 1982 | 1983 | 1984 | 1984 | |||||||||||||||||||||||||
01-RC-017782 | 1 1 | RC | 17782 | 1982-11-08 | 1985-03-27 | 1982-11-18 | 792 | 20 20 | 27 | 1 | 103 103 | 0 | 0 | 0 | A | 35 | 0 | 15 | B | 1982-11-18 | D | 2 | 1 | 1 | 9 | 0 | 1982 | 1983 | 1985 | 1985 | ||||||||||||||||||||||||||
01-RC-017785 | 1 1 | RC | 17785 | 1982-11-09 | 1984-11-22 | 1983-09-22 | 414 | 20 20 | 27 | 1 | 223 223 | 0 | 0 | 0 | Z | 20 | 0 | 63 | E | 1983-06-16 | 1983-07-15 | 1983-07-15 | N | 5 | 7 | 1 | 9 | 1 | 1 | 0 | 8 | 1984-11-22 | 1982 | 1983 | 1984 | 1985 | ||||||||||||||||||||
01-RC-017790 | 1 1 | RC | 17790 | 1982-11-18 | 1985-03-27 | 1983-01-11 | 179 | 20 20 | 27 | 1 | 23 23 | 0 | 0 | 0 | Z | 40 | 0 | 15 | B | 1983-01-11 | D | 2 | 1 | 1 | 9 | 0 | 1982 | 1983 | 1985 | 1985 | ||||||||||||||||||||||||||
01-RC-017813 | 1 1 | RC | 17813 | 1983-01-12 | 1986-08-29 | 1983-04-12 | 701 | 18 18 | 5 | 1 | 23 23 | 0 | 0 | 0 | A | 78 | 0 | 22 | C | 1983-01-20 | 1983-01-27 | 1983-01-27 | N | 5 | 7 | 4 | 0 | 1 | 0 | 0 | 8 | 1986-08-29 | 1983 | 1983 | 1986 | 1986 | ||||||||||||||||||||
01-RC-017823 | 1 1 | RC | 17823 | 1983-12-22 | 1984-01-11 | 1983-12-22 | 421 | 38 38 | 7 | 4 | 233 233 | 0 | 0 | 0 | D | 15 | 0 | A | A | 2 | 1 | 1 | 9 | 0 | 1983 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||||
01-RC-017829 | 1 1 | RC | 17829 | 1983-02-10 | 1984-03-30 | 1983-06-13 | 421 | 18 18 | 19 | 4 | 233 233 | 0 | 0 | 0 | A | 20 | 0 | 22 | C | 1983-05-09 | 1983-05-20 | 1983-05-20 | N | 4 | 9 | 1 | 7 | 1 | 1 | 0 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||||
01-RC-017830 | 1 1 | RC | 17830 | 1983-02-11 | 1985-01-25 | 1985-01-14 | 806 | 18 18 | 29 | 4 | 748 748 | 0 | 0 | 0 | P | 47 | 0 | 22 | C | 1983-03-02 | 1983-03-10 | 1983-03-15 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1983 | 1983 | 1985 | 1985 | |||||||||||||||||||||||
01-RC-017842 | 1 1 | RC | 17842 | 1983-02-22 | 1983-12-12 | 1983-06-02 | 531 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 55 | 0 | 71 | J | 1983-03-02 | F | 5 | X | 3 | 1983-04-21 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-017843 | 1 1 | RC | 17843 | 1983-02-22 | 1984-05-09 | 1984-04-20 | 355 | 20 20 | 17 | 1 | 241 241 | 0 | 0 | 0 | Z | 25 | 0 | 21 | C | D | C | 5 | X | 4 | 1983-05-26 | 0 | 02 | 12 | 1983 | 1983 | 1984 | 1984 | 01-CA-020773-001 | 01-RC-017843 | ||||||||||||||||||||||
01-RC-017863 | 1 1 | RC | 17863 | 1983-03-16 | 1983-10-27 | 1983-06-24 | 382 | 18 18 | 1 | 1 | 241 241 | 0 | 0 | 0 | A | 15 | 0 | 23 | C | 1983-03-30 | 1983-04-04 | 1983-04-04 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||
01-RC-017876 | 1 1 | RC | 17876 | 1983-04-06 | 1983-12-29 | 1983-06-06 | 366 | 20 20 | 9 | 2 | 473 473 | 0 | 0 | 0 | P | 600 | 0 | 61 | H | 1983-04-15 | 1983-04-25 | 1983-04-26 | K | 4 | 2 | 1 | 2 | 1 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||
01-RC-017896 | 1 1 | RC | 17896 | 1983-05-02 | 1988-08-31 | 1983-12-15 | 367 | 28 28 | 11 | 2 | 452 452 | 0 | 0 | 0 | A | 90 | 0 | 19 | B | W | 1983-05-17 | F | 5 | X | 4 | 1 | 2 | 1983-05-27 | 0 | 02 | 03 | 5 | 1983 | 1983 | 1988 | 1988 | 01-CA-021196-1-2 | 01-CA-021196-001 | ||||||||||||||||||
01-RC-017897 | 1 1 | RC | 17897 | 1983-06-30 | 1983-12-13 | 1983-10-11 | 249 | 18 18 | 3 | 1 | 187 187 | 0 | 0 | 0 | A | 80 | 0 | 75 | K | C | 5 | X | 4 | 1 | 1983-06-30 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-017904 | 1 1 | RC | 17904 | 1983-05-06 | 1984-03-30 | 1983-07-20 | 892 | 20 20 | 25 | 2 | 303 303 | 0 | 2 | 304 304 | 1 | W | 800 | 0 | 61 | H | 1983-05-19 | 1983-05-26 | 1983-06-09 | K | 5 | X | 0 | 5 | 1 | 0 | 8 | 1984-03-30 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||
01-RC-017923 | 1 1 | RC | 17923 | 1983-06-03 | 1984-10-16 | 1983-06-03 | 513 | 20 20 | 23 | 1 | 81 81 | 0 | 0 | 1 | 81 81 | 0 | A | 12 | 0 | A | A | 2 | 1 | 1 | 9 | 0 | 1983 | 1983 | 1984 | 1985 | ||||||||||||||||||||||||||
01-RC-017930 | 1 1 | RC | 17930 | 1983-06-13 | 1984-09-10 | 1983-08-02 | 422 | 20 20 | 13 | 4 | 233 233 | 0 | 0 | 4 | 233 233 | 0 | Z | 7 | 0 | 22 | C | 1983-06-23 | 1983-07-07 | 1983-07-07 | N | 4 | 9 | 1 | 5 | 1 | 1 | 0 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||
01-RC-017932 | 1 1 | RC | 17932 | 1983-06-14 | 1984-09-24 | 1983-06-14 | 423 | 20 20 | 25 | 1 | 141 141 | 0 | 1 | 141 141 | 0 | A | 10 | 0 | A | A | 5 | 0 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||||||||||||
01-RC-017934 | 1 1 | RC | 17934 | 1983-06-16 | 1984-05-04 | 1983-09-08 | 832 | 20 20 | 21 | 5 | 0 | 0 | 0 | A | 300 | 0 | 22 | C | 1983-06-29 | 1983-07-08 | 1983-07-19 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||||||
01-RC-017939 | 1 1 | RC | 17939 | 1983-06-23 | 1984-10-19 | 1984-07-06 | 483 | 20 20 | 25 | 1 | 61 61 | 0 | 1 | 0 | Z | 3 | 0 | 75 | K | 1983-06-29 | I | 5 | X | 3 | 1 | 1983-07-18 | 0 | 1983 | 1983 | 1984 | 1985 | |||||||||||||||||||||||||
01-RC-017940 | 1 1 | RC | 17940 | 1983-06-24 | 1984-07-03 | 1984-04-09 | 489 | 28 28 | 15 | 1 | 61 61 | 0 | 2 | 0 | T | 18 | 0 | 18 | B | D | 1983-07-06 | 1983-07-12 | 1983-07-12 | N | 5 | 7 | 4 | 1 | 1 | 0 | 02 | 12 | 1983 | 1983 | 1984 | 1984 | 01-CA-021381-001 | |||||||||||||||||||
01-RC-017947 | 1 1 | RC | 17947 | 1983-07-01 | 1984-01-27 | 1983-07-01 | 208 | 18 18 | 19 | 2 | 322 322 | 0 | 0 | 0 | Z | 4 | 0 | A | A | 2 | 1 | 1 | 7 | 0 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||||||||||
01-RC-017949 | 1 1 | RC | 17949 | 1983-07-06 | 1983-10-11 | 1983-09-08 | 514 | 20 20 | 5 | 5 | 0 | 0 | 0 | A | 79 | 0 | 31 | D | A | 1 | 1 | 0 | 7 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||||
01-RC-017952 | 1 1 | RC | 17952 | 1983-07-11 | 1983-11-23 | 1983-10-14 | 835 | 20 20 | 17 | 5 | 0 | 0 | 0 | W | 45 | 0 | 71 | J | 1983-07-19 | F | 5 | 1 | 3 | 1983-08-05 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||||
01-RC-017953 | 1 1 | RC | 17953 | 1983-07-13 | 1984-02-06 | 1983-12-29 | 202 | 18 18 | 19 | 4 | 233 233 | 0 | 0 | 0 | A | 59 | 0 | 22 | C | 1983-08-04 | 1983-10-03 | 1983-10-03 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1983 | 1983 | 1984 | 1984 | |||||||||||||||||||||||
01-RC-017955 | 1 1 | RC | 17955 | 1983-07-14 | 1983-11-01 | 1983-09-20 | 173 | 18 18 | 11 | 1 | 61 61 | 0 | 0 | 0 | C | 18 | 0 | 22 | C | 1983-08-22 | 1983-08-25 | 1983-08-25 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||
01-RC-017962 | 1 1 | RC | 17962 | 1983-07-21 | 1983-11-08 | 1983-09-27 | 353 | 20 20 | 17 | 1 | 23 23 | 0 | 0 | 1 | 23 23 | 0 | D | 2 | 0 | 22 | C | 1983-08-03 | 1983-08-08 | 1983-08-16 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||
01-RC-017964 | 1 1 | RC | 17964 | 1983-07-25 | 1983-09-23 | 1983-08-19 | 805 | 20 20 | 25 | 2 | 451 451 | 0 | 1 | 0 | D | 90 | 0 | 20 | C | E | 5 | 1 | 3 | 1983-08-19 | 0 | 1983 | 1983 | 1983 | 1983 | |||||||||||||||||||||||||||
01-RC-017968 | 1 1 | RC | 17968 | 1983-07-28 | 1983-10-04 | 1983-09-09 | 355 | 20 20 | 17 | 1 | 245 245 | 0 | 0 | 0 | Z | 12 | 0 | 21 | C | 1983-08-10 | F | 5 | 1 | 3 | 1983-09-09 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-017969 | 1 1 | RC | 17969 | 1983-07-29 | 1983-10-03 | 1983-08-29 | 835 | 20 20 | 25 | 2 | 303 303 | 0 | 0 | 0 | P | 12 | 0 | 21 | C | 1983-08-12 | F | 5 | 1 | 3 | 1983-08-29 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-017972 | 1 1 | RC | 17972 | 1983-08-03 | 1983-10-26 | 1983-08-23 | 366 | 20 20 | 27 | 1 | 23 23 | 0 | 0 | 0 | A | 6 | 0 | 20 | C | 1983-08-16 | E | 5 | 1 | 4 | 1983-08-23 | 1 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-017973 | 1 1 | RC | 17973 | 1983-08-04 | 1983-11-16 | 1983-10-28 | 366 | 20 20 | 27 | 1 | 23 23 | 0 | 0 | 0 | A | 6 | 0 | 71 | J | 1983-08-16 | E | 5 | 1 | 4 | 1983-08-23 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-017974 | 1 1 | RC | 17974 | 1983-08-04 | 1983-10-17 | 1983-09-19 | 354 | 20 20 | 17 | 1 | 21 21 | 0 | 0 | 0 | A | 36 | 0 | 21 | C | 1983-08-16 | F | 5 | 1 | 3 | 1983-09-19 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-017977 | 1 1 | RC | 17977 | 1983-08-10 | 1983-10-21 | 1983-09-26 | 369 | 20 20 | 21 | 1 | 61 61 | 0 | 0 | 0 | Z | 12 | 0 | 21 | C | F | 5 | 1 | 4 | 1983-09-26 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||||
01-RC-017978 | 1 1 | RC | 17978 | 1983-08-12 | 1983-10-17 | 1983-09-13 | 543 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 17 | 0 | 20 | C | 1983-08-23 | E | 5 | 1 | 4 | 1983-09-13 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-017982 | 1 1 | RC | 17982 | 1983-08-15 | 1983-10-17 | 1983-10-05 | 801 | 20 20 | 25 | 1 | 105 105 | 0 | 0 | 1 | 105 105 | 0 | D | 7 | 0 | 21 | C | 1983-08-25 | F | 5 | 1 | 3 | 1983-10-05 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||
01-RC-017983 | 1 1 | RC | 17983 | 1983-08-17 | 1984-04-03 | 1984-04-16 | 275 | 20 20 | 13 | 4 | 233 233 | 0 | 0 | 4 | 233 233 | 0 | T | 200 | 0 | 22 | C | D | 1983-08-26 | 1983-09-02 | 1983-09-12 | N | 5 | 7 | 4 | 1 | 1 | 0 | 02 | 12 | 1983 | 1983 | 1984 | 1984 | 01-CA-021341-001 | |||||||||||||||||
01-RC-017984 | 1 1 | RC | 17984 | 1983-08-18 | 1983-10-04 | 1983-09-08 | 806 | 20 20 | 13 | 1 | 23 23 | 0 | 0 | 1 | 23 23 | 0 | T | 2 | 0 | 20 | C | B | 5 | 1 | 3 | 1983-09-08 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||
01-RC-017985 | 1 1 | RC | 17985 | 1983-08-19 | 1983-10-11 | 1983-09-16 | 805 | 18 18 | 19 | 5 | 0 | 0 | 0 | A | 58 | 0 | 21 | C | 1983-08-31 | F | 5 | 1 | 3 | 1983-09-16 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||||
01-RC-017986 | 1 1 | RC | 17986 | 1983-08-19 | 1984-02-08 | 1984-02-07 | 632 | 18 18 | 19 | 1 | 219 219 | 0 | 0 | 1 | 219 219 | 0 | Z | 100 | 0 | 18 | B | F | 1983-08-31 | E | 5 | 1 | 4 | 1983-09-16 | 0 | 03 | 12 | 1983 | 1983 | 1984 | 1984 | 01-CA-021566-001 | 01-RC-017986 | |||||||||||||||||||
01-RC-017987 | 1 1 | RC | 17987 | 1983-08-19 | 1983-10-21 | 1983-09-13 | 783 | 20 20 | 25 | 4 | 541 541 | 0 | 0 | 4 | 541 541 | 1 | A | 28 | 0 | 20 | C | 1983-08-29 | E | 5 | 1 | 3 | 1983-09-13 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||
01-RC-017988 | 1 1 | RC | 17988 | 1983-08-23 | 1983-10-13 | 1983-10-04 | 621 | 18 18 | 5 | 5 | 0 | 0 | 0 | G | 30 | 0 | 21 | C | 1983-09-01 | F | 5 | 1 | 3 | 1983-10-04 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||||
01-RC-017989 | 1 1 | RC | 17989 | 1983-08-24 | 1984-04-27 | 1983-10-28 | 355 | 20 20 | 9 | 2 | 471 471 | 0 | 0 | 0 | A | 35 | 0 | 18 | B | 1983-09-06 | F | 5 | X | 4 | 1983-10-12 | 0 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||||||||
01-RC-017990 | 1 1 | RC | 17990 | 1983-08-25 | 1983-11-07 | 1983-09-22 | 506 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 18 | 0 | 20 | C | E | 5 | 1 | 4 | 1983-09-22 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||||
01-RC-017991 | 1 1 | RC | 17991 | 1983-08-25 | 1983-10-06 | 1983-09-15 | 822 | 20 20 | 25 | 1 | 23 23 | 0 | 0 | 0 | A | 4 | 0 | 41 | E | 1983-09-02 | 1983-09-15 | 1983-09-15 | N | 3 | 5 | 0 | 1 | 1 | 1 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||
01-RC-017992 | 1 1 | RC | 17992 | 1983-08-25 | 1983-12-07 | 1983-10-26 | 353 | 20 20 | 27 | 1 | 23 23 | 0 | 0 | 0 | A | 5 | 0 | 21 | C | 1983-09-01 | F | 5 | X | 4 | 1 | 1983-10-26 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||
01-RC-017993 | 1 1 | RC | 17993 | 1983-08-25 | 1984-05-29 | 1983-09-12 | 353 | 20 20 | 25 | 1 | 23 23 | 0 | 0 | 0 | A | 5 | 0 | 20 | C | 1983-09-07 | E | 5 | 1 | 4 | 1983-09-12 | 1 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||||||||
01-RC-017994 | 1 1 | RC | 17994 | 1983-08-26 | 1983-12-23 | 1983-10-13 | 806 | 20 20 | 9 | 5 | 0 | 0 | 0 | P | 210 | 0 | 41 | E | 1983-09-07 | 1983-09-13 | 1983-10-13 | J | 0 | 3 | 2 | 1 | 1 | 0 | 8 | 1983-12-23 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||
01-RC-017995 | 1 1 | RC | 17995 | 1983-08-26 | 1983-10-25 | 1983-09-23 | 512 | 20 20 | 27 | 1 | 61 61 | 0 | 0 | 0 | D | 60 | 0 | 20 | C | 1983-09-07 | E | 5 | 1 | 4 | 1983-09-23 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-017996 | 1 1 | RC | 17996 | 1983-08-29 | 1983-11-08 | 1983-10-04 | 739 | 44 44 | 23 | 1 | 61 61 | 0 | 0 | 0 | A | 12 | 0 | 21 | C | F | 5 | 1 | 3 | 1983-10-04 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||||
01-RC-017997 | 1 1 | RC | 17997 | 1983-08-29 | 1984-08-08 | 1984-07-06 | 38 38 | 3 | 1 | 141 141 | 0 | 0 | 0 | A | 72 | 0 | 21 | C | C | 5 | 1 | 4 | 1984-07-06 | 0 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||||||||||
01-RC-017998 | 1 1 | RC | 17998 | 1983-08-29 | 1983-11-21 | 1983-10-13 | 18 18 | 31 | 1 | 31 31 | 0 | 0 | 0 | A | 80 | 0 | 22 | C | 1983-09-12 | 1983-09-19 | 1983-09-21 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||
01-RC-017999 | 1 1 | RC | 17999 | 1983-08-30 | 1983-10-04 | 1983-09-13 | 501 | 20 20 | 27 | 5 | 0 | 0 | 0 | A | 12 | 0 | 20 | C | 1983-09-12 | E | 5 | 1 | 4 | 1983-09-13 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||||
01-RC-018000 | 1 1 | RC | 18000 | 1983-08-30 | 1983-11-04 | 1983-10-19 | 806 | 20 20 | 13 | 1 | 23 23 | 0 | 0 | 1 | 23 23 | 0 | A | 41 | 0 | 21 | C | 1983-09-08 | F | 5 | 1 | 3 | 1983-10-19 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||
01-RC-018001 | 1 1 | RC | 18001 | 1983-08-31 | 1983-11-04 | 1983-09-14 | 282 | 44 44 | 1 | 4 | 233 233 | 0 | 0 | 0 | A | 130 | 0 | 20 | C | B | 5 | 1 | 4 | 1983-09-14 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||||
01-RC-018002 | 1 1 | RC | 18002 | 1983-09-01 | 1983-11-09 | 1983-11-09 | 739 | 20 20 | 25 | 4 | 233 233 | 0 | 0 | 0 | A | 36 | 0 | 22 | C | 1983-09-16 | F | 5 | X | 4 | 1 | 1983-10-03 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||
01-RC-018003 | 1 1 | RC | 18003 | 1983-09-01 | 1983-11-03 | 1983-09-16 | 204 | 20 20 | 23 | 1 | 241 241 | 0 | 0 | 0 | A | 80 | 0 | 20 | C | 1983-09-12 | E | 5 | 1 | 4 | 1983-09-16 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-018004 | 1 1 | RC | 18004 | 1983-09-02 | 1983-10-25 | 1983-10-04 | 832 | 20 20 | 11 | 5 | 0 | 0 | 5 | 0 | A | 21 | 0 | 31 | D | 1983-09-19 | D | 1 | 1 | 0 | 1 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-018005 | 1 1 | RC | 18005 | 1983-09-07 | 1983-11-21 | 1983-09-07 | 805 | 20 20 | 17 | 5 | 0 | 0 | 0 | P | 280 | 0 | A | A | 5 | 1 | 4 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||||||
01-RC-018006 | 1 1 | RC | 18006 | 1983-09-08 | 1983-12-15 | 1983-11-23 | 593 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | A | 7 | 0 | 21 | C | 1983-09-19 | F | 5 | 1 | 3 | 1983-11-23 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-018007 | 1 1 | RC | 18007 | 1983-09-08 | 1983-10-31 | 1983-09-19 | 355 | 20 20 | 5 | 4 | 233 233 | 0 | 0 | 4 | 233 233 | 0 | W | 12 | 0 | 15 | B | 1983-09-19 | D | 5 | 1 | 4 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||
01-RC-018008 | 1 1 | RC | 18008 | 1983-09-09 | 1983-12-06 | 1983-09-29 | 509 | 20 20 | 1 | 2 | 342 342 | 0 | 1 | 0 | A | 32 | 0 | 21 | C | 1983-09-20 | F | 5 | 1 | 3 | 1983-09-29 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-018009 | 1 1 | RC | 18009 | 1983-09-09 | 1983-11-30 | 1983-09-29 | 413 | 20 20 | 13 | 1 | 61 61 | 0 | 0 | 0 | D | 15 | 0 | 41 | E | 1983-09-20 | 1983-09-29 | 1983-09-29 | J | 1 | 1 | 0 | 3 | 1 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||
01-RC-018010 | 1 1 | RC | 18010 | 1983-09-09 | 1983-10-17 | 1983-10-03 | 501 | 18 18 | 5 | 1 | 223 223 | 0 | 0 | 0 | Z | 28 | 0 | 21 | C | 1983-09-20 | F | 5 | 1 | 3 | 1983-10-03 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
01-RC-018011 | 1 1 | RC | 18011 | 1983-09-12 | 1983-10-11 | 1983-09-12 | 806 | 18 18 | 19 | 5 | 0 | 0 | 0 | T | 58 | 0 | A | A | 5 | 1 | 3 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||||||
01-RC-018012 | 1 1 | RC | 18012 | 1983-09-12 | 1983-10-26 | 1983-09-19 | 805 | 20 20 | 25 | 5 | 0 | 1 | 0 | A | 90 | 0 | 15 | B | 1983-09-19 | D | 4 | 1 | 1 | 7 | 0 | 1983 | 1983 | 1983 | 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]) );