r_master
where state = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16-RC-008028 | 16 16 | RC | 8028 | 1979-09-21 | 1984-03-14 | 1979-09-21 | 322 | 3 3 | 131 | 1 | 241 241 | 0 | 0 | 0 | A | 32 | 0 | 71 | J | 1979-10-01 | C | 2 | 1 | 1 | 0 | 1979 | 1979 | 1984 | 1984 | |||||||||||||||||||||||||||
16-RC-009343 | 16 16 | RC | 9343 | 1990-10-04 | 1990-11-16 | 1990-10-23 | 421 | 3 3 | 119 | 4 | 233 233 | 0 | 0 | 0 | T | 12 | 0 | 21 | C | C | 5 | 1 | 4 | 1990-10-23 | 0 | 1990 | 1991 | 1990 | 1991 | |||||||||||||||||||||||||||
26-RC-005823 | 26 26 | RC | 5823 | 1978-07-27 | 1984-08-21 | 1978-11-21 | 361 | 3 3 | 113 | 1 | 141 141 | 0 | 0 | 0 | A | 450 | 0 | 71 | J | E | 1978-08-03 | D | 4 | X | 1 | 9 | 0 | 1978 | 1978 | 1984 | 1984 | 26-CA-007458 | ||||||||||||||||||||||||
26-RC-006388 | 26 26 | RC | 6388 | 1981-05-04 | 1987-09-10 | 1987-09-14 | 944 | 3 3 | 119 | 4 | 233 233 | 0 | 0 | 0 | T | 60 | 0 | 65 | I | F | 1981-05-21 | 1981-05-21 | N | 4 | 7 | 1 | 3 | 1 | 1 | 0 | 01 | 1981 | 1981 | 1987 | 1987 | 26-CA-009244-001 | ||||||||||||||||||||
26-RC-006522 | 26 26 | RC | 6522 | 1982-08-09 | 1984-05-10 | 1982-10-18 | 521 | 3 3 | 139 | 2 | 355 355 | 0 | 0 | 0 | A | 35 | 0 | 71 | J | 1982-08-13 | F | 5 | X | 4 | 1982-08-25 | 0 | 1982 | 1982 | 1984 | 1984 | ||||||||||||||||||||||||||
26-RC-006533 | 26 26 | RC | 6533 | 1982-10-01 | 1983-10-31 | 1983-02-08 | 999 | 3 3 | 131 | 1 | 31 31 | 0 | 0 | 0 | A | 140 | 0 | 18 | B | 1982-10-05 | F | 5 | X | 4 | 1982-10-19 | 0 | 1982 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
26-RC-006566 | 26 26 | RC | 6566 | 1983-03-08 | 1986-02-06 | 1983-06-21 | 371 | 3 3 | 103 | 2 | 452 452 | 0 | 0 | 0 | A | 68 | 0 | 21 | C | C | 1983-03-14 | P | 1 | 7 | 0 | 1983-03-31 | 0 | 02 | 01 | 1983 | 1983 | 1986 | 1986 | 26-CA-010194-001 | 26-RC-006566 | |||||||||||||||||||||
26-RC-006570 | 26 26 | RC | 6570 | 1983-03-17 | 1984-09-11 | 1984-08-01 | 805 | 3 3 | 39 | 1 | 31 31 | 0 | 2 | 0 | A | 44 | 0 | 71 | J | 1983-03-22 | F | 5 | X | 4 | 1 | 1983-06-10 | 1 | 1983 | 1983 | 1984 | 1984 | |||||||||||||||||||||||||
26-RC-006590 | 26 26 | RC | 6590 | 1983-05-31 | 1984-09-17 | 1983-09-01 | 249 | 3 3 | 39 | 2 | 583 583 | 0 | 0 | 0 | A | 173 | 0 | 71 | J | C | 5 | X | 4 | 1 | 1983-06-17 | 0 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||||||||
26-RC-006591 | 26 26 | RC | 6591 | 1983-06-07 | 1984-04-04 | 1983-08-25 | 805 | 3 3 | 3 | 1 | 241 241 | 0 | 1 | 0 | D | 47 | 0 | 71 | J | 1983-06-13 | F | 5 | X | 3 | 1983-06-28 | 0 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||||||||
26-RC-006609 | 26 26 | RC | 6609 | 1983-07-15 | 1983-10-03 | 1983-09-21 | 201 | 3 3 | 63 | 1 | 241 241 | 0 | 0 | 0 | A | 110 | 0 | 18 | B | C | 5 | 1 | 3 | 1983-08-01 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||||
26-RC-006610 | 26 26 | RC | 6610 | 1983-07-18 | 1983-10-06 | 1983-08-15 | 805 | 3 3 | 19 | 1 | 241 241 | 0 | 1 | 0 | A | 55 | 0 | 22 | C | 1983-07-21 | 1983-08-04 | 1983-08-04 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||
26-RC-006616 | 26 26 | RC | 6616 | 1983-08-18 | 1983-10-18 | 1983-08-30 | 346 | 3 3 | 31 | 2 | 342 342 | 0 | 0 | 0 | A | 100 | 0 | 21 | C | C | 5 | 1 | 3 | 1983-08-30 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||||
26-RC-006621 | 26 26 | RC | 6621 | 1983-08-29 | 1983-11-03 | 1983-09-19 | 805 | 3 3 | 27 | 1 | 241 241 | 0 | 1 | 0 | A | 48 | 0 | 21 | C | 1983-09-07 | F | 5 | 1 | 3 | 1983-09-19 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
26-RC-006624 | 26 26 | RC | 6624 | 1983-09-12 | 1983-11-07 | 1983-09-30 | 483 | 3 3 | 119 | 2 | 665 665 | 0 | 0 | 0 | A | 39 | 0 | 21 | C | 1983-09-20 | F | 5 | 1 | 4 | 1983-09-30 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
26-RC-006625 | 26 26 | RC | 6625 | 1983-09-12 | 1983-11-03 | 1983-09-30 | 376 | 3 3 | 103 | 2 | 303 303 | 0 | 0 | A | 225 | 0 | 21 | C | F | 5 | 1 | 4 | 1983-09-30 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||||
26-RC-006627 | 26 26 | RC | 6627 | 1983-09-15 | 1983-10-11 | 1983-10-11 | 162 | 3 3 | 119 | 1 | 31 31 | 0 | 0 | 0 | C | 12 | 0 | 22 | C | 1983-09-19 | 1983-09-27 | 1983-09-27 | N | 3 | 5 | 0 | 5 | 1 | 1 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||
26-RC-006630 | 26 26 | RC | 6630 | 1983-09-29 | 1983-11-21 | 1983-10-12 | 353 | 3 3 | 9 | 4 | 233 233 | 0 | 0 | 0 | T | 88 | 0 | 21 | C | C | 5 | 1 | 4 | 1983-10-12 | 0 | 1983 | 1983 | 1983 | 1984 | |||||||||||||||||||||||||||
26-RC-006637 | 26 26 | RC | 6637 | 1983-10-28 | 1983-12-19 | 1983-11-18 | 281 | 3 3 | 35 | 1 | 88 88 | 0 | 0 | 0 | A | 29 | 0 | 21 | C | C | 5 | 1 | 4 | 1983-11-18 | 0 | 1983 | 1984 | 1983 | 1984 | |||||||||||||||||||||||||||
26-RC-006644 | 26 26 | RC | 6644 | 1983-12-15 | 1984-02-22 | 1984-01-12 | 805 | 3 3 | 3 | 1 | 241 241 | 0 | 1 | 0 | A | 30 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-01-12 | 0 | 1983 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
26-RC-006650 | 26 26 | RC | 6650 | 1984-02-01 | 1984-05-16 | 1984-04-12 | 348 | 3 3 | 103 | 1 | 141 141 | 0 | 0 | 0 | A | 44 | 0 | 71 | J | 1984-02-10 | F | 5 | X | 4 | 1984-02-22 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
26-RC-006652 | 26 26 | RC | 6652 | 1984-02-02 | 1984-04-12 | 1984-02-21 | 801 | 3 3 | 23 | 1 | 241 241 | 0 | 1 | 0 | A | 51 | 0 | 21 | C | 1984-02-08 | F | 5 | 1 | 3 | 1984-02-21 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
26-RC-006653 | 26 26 | RC | 6653 | 1984-02-02 | 1984-04-12 | 1984-02-21 | 801 | 3 3 | 119 | 1 | 241 241 | 0 | 1 | 0 | A | 57 | 0 | 21 | C | 1984-02-08 | F | 5 | 1 | 3 | 1984-02-21 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
26-RC-006654 | 26 26 | RC | 6654 | 1984-02-07 | 1984-04-12 | 1984-03-07 | 614 | 3 3 | 119 | 2 | 342 342 | 0 | 0 | 0 | W | 22 | 0 | 22 | C | 1984-02-13 | 1984-02-23 | 1984-02-24 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||
26-RC-006659 | 26 26 | RC | 6659 | 1984-02-22 | 1984-04-23 | 1984-03-23 | 367 | 3 3 | 91 | 4 | 542 542 | 0 | 0 | 0 | A | 122 | 0 | 21 | C | 1984-02-29 | F | 5 | 1 | 4 | 1984-03-23 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
26-RC-006660 | 26 26 | RC | 6660 | 1984-03-01 | 1984-05-07 | 1984-03-20 | 421 | 3 3 | 9 | 4 | 233 233 | 0 | 0 | 0 | T | 16 | 0 | 21 | C | C | 5 | 1 | 4 | 1984-03-20 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
26-RC-006662 | 26 26 | RC | 6662 | 1984-03-05 | 1984-05-07 | 1984-03-26 | 421 | 3 3 | 9 | 4 | 233 233 | 0 | 0 | 0 | T | 16 | 0 | 21 | C | C | 5 | 1 | 4 | 1984-03-26 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
26-RC-006666 | 26 26 | RC | 6666 | 1984-03-14 | 1984-05-04 | 1984-03-26 | 205 | 3 3 | 91 | 1 | 26 26 | 0 | 0 | 0 | A | 42 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-03-26 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
26-RC-006668 | 26 26 | RC | 6668 | 1984-04-04 | 1984-06-07 | 1984-04-27 | 421 | 3 3 | 7 | 4 | 233 233 | 0 | 0 | 0 | T | 25 | 0 | 21 | C | 1984-04-09 | F | 5 | 1 | 4 | 1984-04-27 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
26-RC-006669 | 26 26 | RC | 6669 | 1984-04-04 | 1984-05-07 | 1984-04-16 | 314 | 3 3 | 37 | 2 | 583 583 | 0 | 0 | 0 | A | 470 | 0 | 21 | C | C | 5 | 1 | 4 | 1984-04-16 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
26-RC-006682 | 26 26 | RC | 6682 | 1984-05-29 | 1984-07-30 | 1984-06-27 | 541 | 3 3 | 123 | 4 | 233 233 | 0 | 1 | 4 | 233 233 | 0 | T | 40 | 1 | 21 | C | 1984-06-06 | F | 5 | 1 | 4 | 1984-06-27 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||
26-RC-006687 | 26 26 | RC | 6687 | 1984-06-18 | 1984-08-06 | 1984-07-16 | 511 | 3 3 | 119 | 1 | 166 166 | 0 | 0 | 0 | W | 12 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-07-16 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
26-RC-006689 | 26 26 | RC | 6689 | 1984-07-03 | 1984-10-31 | 1984-07-09 | 171 | 3 3 | 119 | 1 | 178 178 | 0 | 0 | 0 | A | 23 | 0 | 15 | B | 1984-07-09 | D | 2 | 1 | 1 | 9 | 0 | 1984 | 1984 | 1984 | 1985 | ||||||||||||||||||||||||||
26-RC-006690 | 26 26 | RC | 6690 | 1984-07-03 | 1984-08-30 | 1984-07-17 | 805 | 3 3 | 119 | 1 | 241 241 | 0 | 1 | 0 | Z | 100 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-07-17 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
26-RC-006691 | 26 26 | RC | 6691 | 1984-07-16 | 1984-09-07 | 1984-08-01 | 307 | 3 3 | 7 | 1 | 31 31 | 0 | 0 | 0 | A | 60 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-08-01 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
26-RC-006692 | 26 26 | RC | 6692 | 1984-07-23 | 1986-06-13 | 1984-10-17 | 805 | 3 3 | 103 | 1 | 241 241 | 0 | 1 | 0 | A | 48 | 0 | 19 | B | C | 5 | X | 4 | 1 | 1984-08-01 | 0 | 1984 | 1984 | 1986 | 1986 | ||||||||||||||||||||||||||
26-RC-006693 | 26 26 | RC | 6693 | 1984-07-25 | 1984-09-18 | 1984-08-21 | 289 | 3 3 | 119 | 1 | 25 25 | 0 | 1 | 0 | A | 13 | 0 | 22 | C | 1984-08-02 | 1984-08-10 | 1984-08-10 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||
26-RC-006696 | 26 26 | RC | 6696 | 1984-07-27 | 1984-11-28 | 1984-11-08 | 325 | 3 3 | 119 | 2 | 422 422 | 0 | 0 | 0 | A | 187 | 0 | 71 | J | C | 5 | X | 4 | 1 | 1984-08-09 | 0 | 1984 | 1984 | 1984 | 1985 | ||||||||||||||||||||||||||
26-RC-006700 | 26 26 | RC | 6700 | 1984-08-06 | 1984-10-01 | 1984-09-04 | 307 | 3 3 | 27 | 1 | 63 63 | 0 | 0 | 0 | A | 62 | 0 | 21 | C | C | 5 | 1 | 4 | 1984-09-04 | 0 | 1984 | 1984 | 1984 | 1985 | |||||||||||||||||||||||||||
26-RC-006709 | 26 26 | RC | 6709 | 1984-09-12 | 1984-10-26 | 1984-09-27 | 242 | 3 3 | 11 | 2 | 486 486 | 0 | 0 | 0 | A | 110 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-09-27 | 0 | 1984 | 1984 | 1984 | 1985 | |||||||||||||||||||||||||||
26-RC-006710 | 26 26 | RC | 6710 | 1984-09-18 | 1984-11-27 | 1984-10-12 | 208 | 3 3 | 51 | 1 | 103 103 | 0 | 0 | 0 | A | 34 | 0 | 21 | C | 1984-09-25 | F | 5 | 1 | 4 | 1984-10-12 | 0 | 1984 | 1984 | 1984 | 1985 | ||||||||||||||||||||||||||
26-RC-006712 | 26 26 | RC | 6712 | 1984-09-21 | 1984-10-19 | 1984-09-27 | 271 | 3 3 | 51 | 1 | 238 238 | 0 | 0 | 0 | A | 3 | 0 | 20 | C | B | 5 | 1 | 3 | 1984-09-27 | 0 | 1984 | 1984 | 1984 | 1985 | |||||||||||||||||||||||||||
26-RC-006713 | 26 26 | RC | 6713 | 1984-09-24 | 1984-11-26 | 1984-10-05 | 371 | 3 3 | 111 | 2 | 303 303 | 0 | 0 | 0 | A | 225 | 0 | 21 | C | C | 5 | 1 | 4 | 1984-10-05 | 0 | 1984 | 1984 | 1984 | 1985 | |||||||||||||||||||||||||||
26-RC-006716 | 26 26 | RC | 6716 | 1984-09-27 | 1985-06-19 | 1984-12-05 | 344 | 3 3 | 33 | 1 | 31 31 | 0 | 0 | 0 | A | 160 | 0 | 18 | B | C | 4 | X | 1 | 9 | 1984-10-17 | 0 | 1984 | 1984 | 1985 | 1985 | ||||||||||||||||||||||||||
26-RC-006717 | 26 26 | RC | 6717 | 1984-10-01 | 1984-11-30 | 1984-10-17 | 503 | 3 3 | 59 | 2 | 486 486 | 0 | 0 | 0 | A | 62 | 0 | 21 | C | 1984-10-09 | F | 5 | 1 | 4 | 1984-10-17 | 0 | 1984 | 1985 | 1984 | 1985 | ||||||||||||||||||||||||||
26-RC-006718 | 26 26 | RC | 6718 | 1984-10-04 | 1984-11-30 | 1984-10-23 | 805 | 3 3 | 119 | 1 | 241 241 | 0 | 1 | 0 | A | 110 | 0 | 21 | C | 1984-10-15 | F | 5 | 1 | 4 | 1984-10-23 | 0 | 1984 | 1985 | 1984 | 1985 | ||||||||||||||||||||||||||
26-RC-006720 | 26 26 | RC | 6720 | 1984-10-10 | 1984-11-01 | 1984-10-24 | 162 | 3 3 | 3 | 1 | 178 178 | 0 | 0 | 0 | A | 17 | 1 | 41 | E | 1984-10-17 | 1984-10-24 | 1984-10-24 | N | 3 | 5 | 0 | 5 | 1 | 1 | 0 | 1984 | 1985 | 1984 | 1985 | ||||||||||||||||||||||
26-RC-006722 | 26 26 | RC | 6722 | 1984-10-11 | 1984-12-05 | 1984-11-16 | 358 | 3 3 | 7 | 1 | 31 31 | 0 | 0 | 0 | A | 65 | 0 | 21 | C | 1984-10-19 | F | 4 | 1 | 1 | 9 | 1984-11-16 | 0 | 1984 | 1985 | 1984 | 1985 | |||||||||||||||||||||||||
26-RC-006724 | 26 26 | RC | 6724 | 1984-10-18 | 1984-12-10 | 1984-11-06 | 862 | 3 3 | 119 | 5 | 0 | 0 | 5 | 0 | W | 0 | 21 | C | C | 5 | 1 | 3 | 1984-11-06 | 0 | 1984 | 1985 | 1984 | 1985 | ||||||||||||||||||||||||||||
26-RC-006725 | 26 26 | RC | 6725 | 1984-10-19 | 1984-11-05 | 1984-10-23 | 271 | 3 3 | 119 | 4 | 233 233 | 0 | 0 | 0 | D | 34 | 0 | 31 | D | A | 1 | 1 | 0 | 2 | 0 | 1984 | 1985 | 1984 | 1985 | |||||||||||||||||||||||||||
26-RC-006727 | 26 26 | RC | 6727 | 1984-10-30 | 1985-01-10 | 1984-12-03 | 271 | 3 3 | 119 | 4 | 233 233 | 0 | 0 | 0 | T | 34 | 0 | 22 | C | 1984-11-01 | 1984-11-14 | 1984-11-15 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1984 | 1985 | 1985 | 1985 | |||||||||||||||||||||||
26-RC-006730 | 26 26 | RC | 6730 | 1984-11-26 | 1984-12-31 | 1984-12-03 | 251 | 3 3 | 37 | 1 | 31 31 | 0 | 0 | 0 | A | 53 | 0 | 21 | C | C | 5 | 1 | 4 | 1984-12-03 | 0 | 1984 | 1985 | 1984 | 1985 | |||||||||||||||||||||||||||
26-RC-006733 | 26 26 | RC | 6733 | 1984-12-13 | 1985-02-22 | 1985-01-08 | 541 | 3 3 | 33 | 4 | 233 233 | 0 | 0 | 0 | T | 28 | 0 | 21 | C | C | 5 | 1 | 3 | 1985-01-08 | 0 | 1984 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
26-RC-006734 | 26 26 | RC | 6734 | 1985-01-02 | 1985-03-01 | 1985-01-18 | 331 | 3 3 | 67 | 1 | 141 141 | 0 | 1 | 0 | A | 150 | 0 | 21 | C | C | 5 | 1 | 4 | 1985-01-18 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
26-RC-006745 | 26 26 | RC | 6745 | 1985-02-14 | 1985-03-25 | 1985-03-01 | 171 | 3 3 | 119 | 1 | 178 178 | 0 | 0 | 0 | C | 24 | 0 | 21 | C | C | 5 | 1 | 4 | 1985-03-01 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
26-RC-006749 | 26 26 | RC | 6749 | 1985-02-25 | 1985-04-22 | 1985-03-12 | 394 | 3 3 | 69 | 2 | 463 463 | 0 | 0 | 0 | A | 100 | 0 | 21 | C | C | 5 | 1 | 4 | 1985-03-12 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
26-RC-006751 | 26 26 | RC | 6751 | 1985-03-04 | 1985-04-09 | 1985-04-02 | 596 | 3 3 | 131 | 4 | 233 233 | 0 | 0 | 0 | A | 75 | 0 | 22 | C | 1985-03-12 | 1985-03-19 | 1985-03-19 | N | 4 | 9 | 1 | 2 | 1 | 1 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||
26-RC-006752 | 26 26 | RC | 6752 | 1985-03-07 | 1985-05-02 | 1985-03-28 | 263 | 3 3 | 59 | 1 | 187 187 | 0 | 0 | 0 | A | 80 | 0 | 21 | C | 0 | 1985-03-14 | F | 5 | 1 | 4 | 1985-03-28 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||
26-RC-006753 | 26 26 | RC | 6753 | 1985-03-07 | 1985-05-13 | 1985-04-08 | 353 | 3 3 | 119 | 1 | 213 213 | 0 | 0 | 0 | A | 64 | 0 | 22 | C | 1985-03-13 | 1985-03-20 | 1985-03-20 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1985-03-28 | 1985-03-20 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||
26-RC-006755 | 26 26 | RC | 6755 | 1985-03-20 | 1985-04-01 | 1985-03-27 | 201 | 3 3 | 71 | 4 | 233 233 | 0 | 0 | 0 | A | 525 | 0 | 15 | B | 1985-03-27 | D | 2 | 1 | 1 | 2 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
26-RC-006756 | 26 26 | RC | 6756 | 1985-03-21 | 1985-05-31 | 1985-04-11 | 805 | 3 3 | 119 | 1 | 241 241 | 0 | 1 | 0 | D | 350 | 0 | 21 | C | 0 | 1985-03-26 | F | 5 | 1 | 4 | 1985-04-11 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||
26-RC-006759 | 26 26 | RC | 6759 | 1985-04-09 | 1985-05-28 | 1985-05-03 | 242 | 3 3 | 3 | 1 | 187 187 | 0 | 0 | 0 | A | 0 | 21 | C | C | 5 | 1 | 3 | 1985-05-03 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||||
26-RC-006760 | 26 26 | RC | 6760 | 1985-04-09 | 1985-07-31 | 1985-06-24 | 201 | 3 3 | 7 | 1 | 241 241 | 0 | 0 | 0 | A | 120 | 0 | 71 | J | 1985-04-16 | F | 5 | X | 4 | 1985-05-06 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
26-RC-006762 | 26 26 | RC | 6762 | 1985-04-24 | 1985-07-26 | 1985-05-22 | 483 | 3 3 | 119 | 2 | 473 473 | 0 | 6 | 0 | D | 68 | 0 | 22 | C | 1985-05-02 | 1985-05-09 | 1985-05-09 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||
26-RC-006764 | 26 26 | RC | 6764 | 1985-04-25 | 1985-06-24 | 1985-05-17 | 367 | 3 3 | 91 | 2 | 452 452 | 0 | - | 0 | A | 106 | 0 | 21 | C | F | 5 | 1 | 4 | 1985-05-17 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
26-RC-006765 | 26 26 | RC | 6765 | 1985-05-01 | 1985-07-01 | 1985-05-17 | 201 | 3 3 | 145 | 1 | 241 241 | 0 | 0 | 0 | A | 375 | 0 | 21 | C | F | 5 | 1 | 4 | 1985-05-17 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
26-RC-006767 | 26 26 | RC | 6767 | 1985-05-20 | 1985-07-16 | 1985-06-05 | 322 | 3 3 | 131 | 1 | 31 31 | 0 | 0 | 0 | A | 40 | 0 | 21 | C | C | 5 | 1 | 3 | 1985-06-05 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
26-RC-006770 | 26 26 | RC | 6770 | 1985-06-05 | 1985-09-20 | 1985-07-02 | 242 | 3 3 | 43 | 1 | 31 31 | 0 | 0 | 0 | A | 0 | 21 | C | 1985-06-11 | F | 5 | 7 | 4 | 1985-07-02 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
26-RC-006773 | 26 26 | RC | 6773 | 1985-06-14 | 1985-08-08 | 1985-07-12 | 281 | 3 3 | 59 | 1 | 63 63 | 0 | 0 | 0 | A | 33 | 0 | 22 | C | 1985-06-21 | 1985-06-26 | 1985-06-26 | N | 2 | 1 | 1 | 9 | 1 | 1 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||
26-RC-006775 | 26 26 | RC | 6775 | 1985-07-01 | 1985-08-08 | 1985-07-18 | 242 | 3 3 | 3 | 2 | 486 486 | 0 | 0 | 0 | Z | 19 | 0 | 21 | C | C | 5 | 1 | 3 | 1985-07-18 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
26-RC-006783 | 26 26 | RC | 6783 | 1985-08-02 | 1985-09-10 | 1985-08-08 | 356 | 3 3 | 19 | 2 | 463 463 | 0 | 0 | 0 | A | 0 | 21 | C | 0 | 1985-08-06 | F | 5 | 1 | 4 | 1985-08-08 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
26-RC-006785 | 26 26 | RC | 6785 | 1985-08-05 | 1985-09-16 | 1985-08-22 | 239 | 3 3 | 35 | 1 | 211 211 | 0 | 0 | 0 | A | 235 | 0 | 21 | C | F | 5 | 1 | 4 | 1985-08-22 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
26-RC-006787 | 26 26 | RC | 6787 | 1985-08-09 | 1985-09-30 | 1985-08-19 | 446 | 3 3 | 107 | 2 | 422 422 | 0 | 0 | 0 | A | 58 | 0 | 21 | C | C | 5 | 1 | 3 | 1985-08-19 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
26-RC-006790 | 26 26 | RC | 6790 | 1985-08-20 | 1985-10-11 | 1985-09-06 | 252 | 3 3 | 93 | 2 | 355 355 | 0 | 0 | 0 | A | 0 | 21 | C | 1985-08-27 | F | 2 | 1 | 1 | 1985-09-06 | 0 | 1985 | 1985 | 1985 | 1986 | |||||||||||||||||||||||||||
26-RC-006792 | 26 26 | RC | 6792 | 1985-08-27 | 1985-10-24 | 1985-09-24 | 999 | 3 3 | 103 | 2 | 303 303 | 0 | 0 | 0 | A | 700 | 0 | 21 | C | 0 | 1985-09-04 | F | 5 | 1 | 3 | 1985-09-24 | 0 | 1985 | 1985 | 1985 | 1986 | |||||||||||||||||||||||||
26-RC-006795 | 26 26 | RC | 6795 | 1985-09-06 | 1985-10-22 | 1985-09-19 | 307 | 3 3 | 27 | 1 | 31 31 | 0 | 0 | 0 | A | 72 | 0 | 21 | C | 0 | 1985-09-10 | F | 5 | 1 | 4 | 1985-09-19 | 0 | 1985 | 1985 | 1985 | 1986 | |||||||||||||||||||||||||
26-RC-006796 | 26 26 | RC | 6796 | 1985-09-11 | 1985-12-30 | 1985-12-02 | 307 | 3 3 | 51 | 1 | 31 31 | 0 | 0 | 0 | A | 0 | 71 | J | 0 | 1985-09-16 | F | 5 | X | 4 | 1985-10-02 | 0 | 1985 | 1985 | 1985 | 1986 | ||||||||||||||||||||||||||
26-RC-006801 | 26 26 | RC | 6801 | 1985-09-20 | 1986-08-25 | 1986-04-09 | 208 | 3 3 | 35 | 4 | 233 233 | 0 | 0 | 0 | T | 15 | 0 | 73 | J | 0 | 1985-09-26 | F | 5 | X | 4 | 1 | 1985-10-09 | 0 | 1985 | 1985 | 1986 | 1986 | ||||||||||||||||||||||||
26-RC-006805 | 26 26 | RC | 6805 | 1985-10-09 | 1986-05-05 | 1986-01-31 | 335 | 3 3 | 139 | 2 | 463 463 | 0 | 0 | 0 | A | 100 | 0 | 19 | B | 1985-10-16 | F | 5 | X | 3 | 1 | 1985-10-30 | 0 | 1985 | 1986 | 1986 | 1986 | |||||||||||||||||||||||||
26-RC-006806 | 26 26 | RC | 6806 | 1985-10-15 | 1985-12-03 | 1985-10-30 | 225 | 3 3 | 79 | 1 | 211 211 | 0 | 0 | 0 | A | 160 | 0 | 21 | C | C | 5 | 1 | 4 | 1985-10-30 | 0 | 1985 | 1986 | 1985 | 1986 | |||||||||||||||||||||||||||
26-RC-006807 | 26 26 | RC | 6807 | 1985-10-23 | 1985-12-23 | 1985-11-12 | 371 | 3 3 | 111 | 2 | 303 303 | 0 | 0 | 0 | A | 150 | 0 | 21 | C | 1985-10-30 | F | 5 | 1 | 4 | 1985-11-12 | 0 | 1985 | 1986 | 1985 | 1986 | ||||||||||||||||||||||||||
26-RC-006808 | 26 26 | RC | 6808 | 1985-10-24 | 1985-12-16 | 1985-11-12 | 571 | 3 3 | 119 | 4 | 233 233 | 0 | 0 | 0 | A | 25 | 0 | 21 | C | 1985-11-01 | F | 5 | 1 | 4 | 1985-11-12 | 0 | 1985 | 1986 | 1985 | 1986 | ||||||||||||||||||||||||||
26-RC-006810 | 26 26 | RC | 6810 | 1985-11-04 | 1986-01-02 | 1985-11-26 | 541 | 3 3 | 69 | 1 | 241 241 | 0 | 1 | 0 | A | 0 | 22 | C | 1985-11-12 | 1985-11-18 | 1985-11-18 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1985 | 1986 | 1986 | 1986 | ||||||||||||||||||||||||
26-RC-006811 | 26 26 | RC | 6811 | 1985-11-04 | 1986-10-21 | 1986-06-20 | 734 | 3 3 | 119 | 1 | 23 23 | 0 | 0 | 0 | A | 0 | 18 | B | E | 1985-11-08 | F | 5 | X | 4 | 1 | 1985-11-25 | 0 | 02 | 01 | 5 | 1985 | 1986 | 1986 | 1987 | 26-CA-011499-001 | |||||||||||||||||||||
26-RC-006812 | 26 26 | RC | 6812 | 1985-11-06 | 1986-01-03 | 1985-11-20 | 335 | 3 3 | 119 | 4 | 233 233 | 0 | 0 | 0 | A | 20 | 0 | 21 | C | 1985-11-13 | F | 5 | 1 | 4 | 1985-11-20 | 0 | 1985 | 1986 | 1986 | 1986 | ||||||||||||||||||||||||||
26-RC-006813 | 26 26 | RC | 6813 | 1985-11-12 | 1985-12-31 | 1985-12-03 | 371 | 3 3 | 143 | 1 | 31 31 | 0 | 0 | 0 | A | 60 | 0 | 21 | C | 1985-11-19 | F | 5 | 1 | 3 | 1985-12-03 | 0 | 1985 | 1986 | 1985 | 1986 | ||||||||||||||||||||||||||
26-RC-006816 | 26 26 | RC | 6816 | 1985-11-19 | 1985-12-30 | 1985-12-05 | 366 | 3 3 | 143 | 1 | 5 5 | 0 | 0 | 0 | A | 0 | 21 | C | 1985-11-22 | F | 5 | 1 | 4 | 1985-12-05 | 0 | 1985 | 1986 | 1985 | 1986 | |||||||||||||||||||||||||||
26-RC-006817 | 26 26 | RC | 6817 | 1985-11-19 | 1986-05-29 | 1986-04-22 | 243 | 3 3 | 119 | 2 | 342 342 | 0 | 0 | 0 | A | 60 | 0 | 79 | K | 1985-11-26 | 1985-12-04 | 1985-12-04 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1985 | 1986 | 1986 | 1986 | |||||||||||||||||||||||
26-RC-006822 | 26 26 | RC | 6822 | 1985-12-27 | 1986-02-25 | 1986-01-15 | 805 | 3 3 | 35 | 1 | 241 241 | 0 | 1 | 0 | A | 33 | 0 | 21 | C | C | 5 | 1 | 3 | 1986-01-15 | 0 | 1985 | 1986 | 1986 | 1986 | |||||||||||||||||||||||||||
26-RC-006825 | 26 26 | RC | 6825 | 1986-01-16 | 1986-03-17 | 1986-02-06 | 307 | 3 3 | 111 | 1 | 31 31 | 0 | 0 | 0 | A | 47 | 0 | 21 | C | 1986-01-24 | F | 5 | 1 | 3 | 1986-02-06 | 0 | 1986 | 1986 | 1986 | 1986 | ||||||||||||||||||||||||||
26-RC-006826 | 26 26 | RC | 6826 | 1986-01-17 | 1986-04-28 | 1986-04-15 | 208 | 3 3 | 123 | 2 | 342 342 | 0 | 0 | 0 | A | 21 | 0 | 19 | B | 1986-01-24 | 1986-02-06 | 1986-02-06 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1986 | 1986 | 1986 | 1986 | |||||||||||||||||||||||
26-RC-006827 | 26 26 | RC | 6827 | 1986-01-21 | 1986-03-17 | 1986-02-04 | 344 | 3 3 | 57 | 2 | 463 463 | 0 | 0 | 0 | A | 37 | 0 | 21 | C | C | 5 | 1 | 4 | 1986-02-04 | 0 | 1986 | 1986 | 1986 | 1986 | |||||||||||||||||||||||||||
26-RC-006836 | 26 26 | RC | 6836 | 1986-02-20 | 1986-03-31 | 1986-03-03 | 734 | 3 3 | 125 | 1 | 23 23 | 0 | 0 | 0 | A | 91 | 0 | 21 | C | C | 5 | 1 | 3 | 1986-03-03 | 0 | 1986 | 1986 | 1986 | 1986 | |||||||||||||||||||||||||||
26-RC-006838 | 26 26 | RC | 6838 | 1986-02-24 | 1986-04-21 | 1986-03-12 | 201 | 3 3 | 149 | 1 | 241 241 | 0 | 0 | 0 | A | 500 | 0 | 21 | C | 1986-02-27 | F | 5 | 1 | 4 | 1986-03-12 | 0 | 1986 | 1986 | 1986 | 1986 | ||||||||||||||||||||||||||
26-RC-006839 | 26 26 | RC | 6839 | 1986-02-24 | 1986-04-21 | 1986-03-10 | 371 | 3 3 | 69 | 2 | 303 303 | 0 | 0 | 0 | A | 240 | 0 | 21 | C | C | 5 | 1 | 4 | 1986-03-10 | 0 | 1986 | 1986 | 1986 | 1986 | |||||||||||||||||||||||||||
26-RC-006840 | 26 26 | RC | 6840 | 1986-02-26 | 1986-04-09 | 1986-03-10 | 205 | 3 3 | 57 | 4 | 233 233 | 0 | 0 | 0 | T | 14 | 0 | 21 | C | C | 2 | 1 | 1 | 0 | 1986-03-10 | 0 | 1986 | 1986 | 1986 | 1986 | ||||||||||||||||||||||||||
26-RC-006847 | 26 26 | RC | 6847 | 1986-04-14 | 1986-06-09 | 1986-05-05 | 331 | 3 3 | 63 | 1 | 141 141 | 0 | 0 | 0 | A | 100 | 0 | 21 | C | C | 5 | 1 | 3 | 1986-05-05 | 0 | 1986 | 1986 | 1986 | 1986 | |||||||||||||||||||||||||||
26-RC-006851 | 26 26 | RC | 6851 | 1986-04-22 | 1986-06-12 | 1986-05-06 | 344 | 3 3 | 111 | 2 | 342 342 | 0 | 0 | 0 | A | 40 | 0 | 21 | C | 1986-04-25 | F | 5 | 1 | 3 | 1986-05-06 | 0 | 1986 | 1986 | 1986 | 1986 | ||||||||||||||||||||||||||
26-RC-006853 | 26 26 | RC | 6853 | 1986-04-30 | 1986-06-13 | 1986-05-13 | 805 | 3 3 | 123 | 1 | 241 241 | 0 | 1 | 0 | A | 35 | 0 | 21 | C | 1986-05-07 | F | 5 | 1 | 3 | 1986-05-13 | 0 | 1986 | 1986 | 1986 | 1986 | ||||||||||||||||||||||||||
26-RC-006854 | 26 26 | RC | 6854 | 1986-05-07 | 1986-06-30 | 1986-05-23 | 249 | 3 3 | 39 | 1 | 31 31 | 0 | 0 | 0 | A | 250 | 0 | 21 | C | 1986-05-13 | F | 5 | 1 | 4 | 1986-05-23 | 0 | 1986 | 1986 | 1986 | 1986 |
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]) );