r_master
where unit = "T"
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-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-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-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-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-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-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-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-018014 | 1 1 | RC | 18014 | 1983-09-14 | 1983-10-14 | 1983-09-28 | 721 | 20 20 | 9 | 4 | 233 233 | 0 | 0 | 0 | T | 9 | 0 | 15 | B | 1983-09-28 | D | 2 | 1 | 1 | 9 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||
| 01-RC-018022 | 1 1 | RC | 18022 | 1983-09-20 | 1984-01-17 | 1983-11-03 | 355 | 18 18 | 5 | 4 | 233 233 | 0 | 0 | 0 | T | 35 | 0 | 22 | C | 1983-10-12 | 1983-10-12 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1983 | 1983 | 1984 | 1984 | ||||||||||||||||||||||||
| 01-RC-018023 | 1 1 | RC | 18023 | 1983-09-21 | 1988-02-29 | 1988-02-29 | 521 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 15 | 0 | 73 | J | 1984-02-28 | F | 5 | X | 3 | 1 | 1 | 1984-03-28 | 0 | 1983 | 1983 | 1988 | 1988 | ||||||||||||||||||||||||
| 01-RC-018024 | 1 1 | RC | 18024 | 1983-09-21 | 1983-11-15 | 1983-10-19 | 355 | 20 20 | 17 | 5 | 0 | 0 | 0 | T | 56 | 0 | 21 | C | C | 5 | 1 | 3 | 1983-10-19 | 0 | 1983 | 1983 | 1983 | 1984 | ||||||||||||||||||||||||||||
| 01-RC-018034 | 1 1 | RC | 18034 | 1983-10-04 | 1983-11-30 | 1983-10-14 | 381 | 44 44 | 7 | 4 | 233 233 | 0 | 0 | 0 | T | 2 | 0 | 15 | B | 1983-10-14 | D | 5 | 1 | 3 | 0 | 1983 | 1984 | 1983 | 1984 | |||||||||||||||||||||||||||
| 01-RC-018037 | 1 1 | RC | 18037 | 1983-10-06 | 1983-11-21 | 1983-11-04 | 262 | 20 20 | 9 | 4 | 233 233 | 0 | 0 | 0 | T | 8 | 0 | 21 | C | F | 5 | 1 | 4 | 1983-11-04 | 0 | 1983 | 1984 | 1983 | 1984 | |||||||||||||||||||||||||||
| 01-RC-018039 | 1 1 | RC | 18039 | 1983-10-12 | 1984-01-13 | 1984-01-11 | 142 | 20 20 | 25 | 4 | 233 233 | 0 | 0 | 0 | T | 13 | 0 | 19 | B | 1983-10-25 | F | 5 | X | 3 | 1 | 1983-10-31 | 0 | 1983 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||
| 01-RC-018040 | 1 1 | RC | 18040 | 1983-10-12 | 1983-12-01 | 1983-11-22 | 809 | 18 18 | 5 | 4 | 233 233 | 0 | 0 | 0 | T | 13 | 0 | 21 | C | 1983-10-27 | F | 5 | 1 | 3 | 1983-11-22 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||||
| 01-RC-018047 | 1 1 | RC | 18047 | 1983-10-24 | 1983-11-22 | 1983-11-10 | 203 | 38 38 | 7 | 4 | 233 233 | 0 | 0 | 0 | T | 15 | 0 | 41 | E | 1983-11-04 | 1983-11-10 | 1983-11-10 | J | 2 | 1 | 1 | 7 | 1 | 0 | 1983 | 1984 | 1983 | 1984 | |||||||||||||||||||||||
| 01-RC-018055 | 1 1 | RC | 18055 | 1983-11-02 | 1983-12-19 | 1983-11-14 | 355 | 20 20 | 9 | 4 | 233 233 | 0 | 0 | 0 | T | 13 | 0 | 15 | B | 1983-11-14 | D | 5 | 1 | 4 | 0 | 1983 | 1984 | 1983 | 1984 | |||||||||||||||||||||||||||
| 01-RC-018057 | 1 1 | RC | 18057 | 1983-11-04 | 1983-12-12 | 1983-11-04 | 421 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 70 | 0 | A | N | 3 | 5 | 0 | 3 | 1 | 1 | 0 | 1983 | 1984 | 1983 | 1984 | ||||||||||||||||||||||||||
| 01-RC-018063 | 1 1 | RC | 18063 | 1983-11-17 | 1984-01-03 | 1983-12-05 | 331 | 28 28 | 15 | 4 | 233 233 | 0 | 0 | 0 | T | 3 | 0 | 15 | B | 1983-12-05 | D | 5 | 1 | 3 | 0 | 1983 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
| 01-RC-018066 | 1 1 | RC | 18066 | 1983-11-22 | 1984-01-06 | 1983-12-12 | 596 | 20 20 | 13 | 4 | 233 233 | 0 | 0 | 0 | T | 10 | 0 | 41 | E | 1983-12-01 | 1983-12-12 | 1983-12-12 | N | 3 | 5 | 0 | 5 | 1 | 1 | 0 | 1983 | 1984 | 1984 | 1984 | ||||||||||||||||||||||
| 01-RC-018072 | 1 1 | RC | 18072 | 1983-12-05 | 1984-02-13 | 1983-12-05 | 353 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 28 | 0 | A | A | 5 | 1 | 4 | 0 | 1983 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||||
| 01-RC-018095 | 1 1 | RC | 18095 | 1984-02-06 | 1984-10-03 | 1984-09-19 | 679 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 14 | 0 | 73 | J | 1984-02-14 | F | 5 | X | 3 | 1984-03-07 | 0 | 1984 | 1984 | 1984 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018102 | 1 1 | RC | 18102 | 1984-02-16 | 1984-05-01 | 1984-05-01 | 355 | 28 28 | 11 | 4 | 233 233 | 0 | 0 | 0 | T | 5 | 0 | 71 | J | C | 5 | X | 4 | 1 | 1984-03-13 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
| 01-RC-018104 | 1 1 | RC | 18104 | 1984-02-17 | 1984-03-12 | 1984-02-27 | 422 | 44 44 | 11 | 4 | 233 233 | 0 | 0 | 0 | T | 8 | 0 | 15 | B | 1984-02-27 | D | 2 | 1 | 1 | 7 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
| 01-RC-018106 | 1 1 | RC | 18106 | 1984-02-27 | 1984-04-26 | 1984-04-26 | 495 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 4 | 0 | 71 | J | B | 5 | 1 | 4 | 1984-03-27 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
| 01-RC-018122 | 1 1 | RC | 18122 | 1984-03-23 | 1984-11-15 | 1984-07-09 | 421 | 20 20 | 25 | 4 | 233 233 | 0 | 0 | 0 | T | 250 | 0 | 71 | J | 1984-04-06 | F | 5 | X | 4 | 1984-04-12 | 0 | 1984 | 1984 | 1984 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018130 | 1 1 | RC | 18130 | 1984-04-03 | 1984-06-12 | 1984-05-01 | 518 | 28 28 | 11 | 4 | 233 233 | 0 | 0 | 0 | T | 18 | 0 | 21 | C | 1984-04-09 | F | 5 | 1 | 4 | 1984-05-01 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
| 01-RC-018133 | 1 1 | RC | 18133 | 1984-04-04 | 1984-04-17 | 1984-04-04 | 599 | 20 20 | 5 | 4 | 233 233 | 0 | 0 | 0 | T | 35 | 0 | A | A | 2 | 1 | 1 | 9 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||||
| 01-RC-018151 | 1 1 | RC | 18151 | 1984-04-23 | 1984-06-05 | 1984-05-21 | 413 | 20 20 | 5 | 4 | 233 233 | 0 | 0 | 0 | T | 19 | 0 | 21 | C | C | 5 | 1 | 3 | 1984-05-21 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
| 01-RC-018161 | 1 1 | RC | 18161 | 1984-05-04 | 1984-07-23 | 1984-06-05 | 505 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 4 | 233 233 | 0 | T | 12 | 0 | 21 | C | 1984-05-14 | F | 5 | 1 | 4 | 1984-06-05 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||
| 01-RC-018162 | 1 1 | RC | 18162 | 1984-05-04 | 1984-06-26 | 1984-06-05 | 421 | 38 38 | 7 | 4 | 233 233 | 0 | 0 | 0 | T | 10 | 0 | 21 | C | F | 5 | 1 | 4 | 1984-06-05 | 0 | 1984 | 1984 | 1984 | 1984 | |||||||||||||||||||||||||||
| 01-RC-018170 | 1 1 | RC | 18170 | 1984-05-14 | 1985-04-01 | 1985-03-05 | 505 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 25 | 0 | 73 | J | C | 5 | X | 3 | 1 | 1984-07-01 | 0 | 1984 | 1984 | 1985 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018181 | 1 1 | RC | 18181 | 1984-05-25 | 1984-09-06 | 1984-05-25 | 421 | 20 20 | 21 | 4 | 233 233 | 0 | 0 | 0 | T | 10 | 0 | A | A | 2 | 1 | 1 | 9 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||||
| 01-RC-018188 | 1 1 | RC | 18188 | 1984-06-08 | 1984-09-06 | 1984-07-18 | 571 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 12 | 0 | 17 | B | 1984-06-15 | 1984-06-22 | 1984-06-22 | N | 3 | 5 | 0 | 5 | 1 | 1 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||
| 01-RC-018200 | 1 1 | RC | 18200 | 1984-06-21 | 1986-11-12 | 1984-07-11 | 327 | 20 20 | 25 | 4 | 233 233 | 0 | 0 | 0 | T | 4 | 0 | 21 | C | C | 4 | 1 | 1 | 7 | 1984-07-11 | 0 | 1984 | 1984 | 1986 | 1987 | ||||||||||||||||||||||||||
| 01-RC-018203 | 1 1 | RC | 18203 | 1984-06-25 | 1984-08-14 | 1984-07-30 | 621 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 13 | 0 | 21 | C | 1984-07-03 | F | 5 | 1 | 4 | 1984-07-30 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
| 01-RC-018211 | 1 1 | RC | 18211 | 1984-07-09 | 1984-09-04 | 1984-07-26 | 553 | 20 20 | 21 | 4 | 233 233 | 0 | 0 | 0 | T | 36 | 0 | 21 | C | 1984-07-19 | F | 5 | 1 | 4 | 1984-07-26 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||
| 01-RC-018214 | 1 1 | RC | 18214 | 1984-07-19 | 1985-01-14 | 1984-11-30 | 353 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 12 | 0 | 71 | J | 1984-07-25 | F | 5 | X | 3 | 1 | 1984-08-13 | 0 | 1984 | 1984 | 1985 | 1985 | |||||||||||||||||||||||||
| 01-RC-018231 | 1 1 | RC | 18231 | 1984-08-15 | 1986-04-10 | 1986-01-23 | 421 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 17 | 0 | 19 | B | C | 5 | 1 | 4 | 1 | 1984-09-05 | 0 | 1984 | 1984 | 1986 | 1986 | ||||||||||||||||||||||||||
| 01-RC-018234 | 1 1 | RC | 18234 | 1984-08-20 | 1984-10-09 | 1984-09-17 | 553 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 14 | 0 | 21 | C | 1984-08-30 | F | 5 | 1 | 4 | 1984-09-17 | 0 | 1984 | 1984 | 1984 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018243 | 1 1 | RC | 18243 | 1984-09-04 | 1984-11-27 | 1984-10-15 | 203 | 38 38 | 3 | 4 | 233 233 | 0 | 0 | 0 | T | 19 | 0 | 22 | C | 1984-09-17 | 1984-09-19 | 1984-09-25 | N | 5 | 7 | 4 | 1 | 1 | 0 | 1984 | 1984 | 1984 | 1985 | |||||||||||||||||||||||
| 01-RC-018245 | 1 1 | RC | 18245 | 1984-09-07 | 1984-09-25 | 1984-09-07 | 521 | 38 38 | 3 | 4 | 233 233 | 0 | 0 | 0 | T | 10 | 0 | A | A | 2 | 1 | 1 | 7 | 0 | 1984 | 1984 | 1984 | 1984 | ||||||||||||||||||||||||||||
| 01-RC-018250 | 1 1 | RC | 18250 | 1984-09-20 | 1984-11-09 | 1984-10-26 | 399 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 10 | 0 | 21 | C | 1984-10-01 | F | 5 | 1 | 4 | 1984-10-26 | 0 | 1984 | 1984 | 1984 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018285 | 1 1 | RC | 18285 | 1984-10-18 | 1985-03-07 | 1984-10-29 | 571 | 20 20 | 9 | 4 | 233 233 | 0 | 0 | 0 | T | 5 | 0 | 15 | B | 1984-10-29 | D | 2 | 1 | 1 | 9 | 0 | 1984 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018295 | 1 1 | RC | 18295 | 1984-10-25 | 1985-01-03 | 1984-10-25 | 412 | 20 20 | 9 | 4 | 233 233 | 0 | 0 | 0 | T | 35 | 0 | A | A | 2 | 1 | 1 | 1 | 0 | 1984 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||||
| 01-RC-018300 | 1 1 | RC | 18300 | 1984-10-30 | 1985-01-02 | 1984-11-23 | 508 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 22 | 0 | 21 | C | 1984-11-05 | F | 5 | 1 | 4 | 1984-11-23 | 0 | 1984 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018313 | 1 1 | RC | 18313 | 1984-11-19 | 1984-12-26 | 1984-12-10 | 596 | 20 20 | 13 | 4 | 233 233 | 0 | 0 | 0 | T | 12 | 0 | 20 | C | B | 5 | 1 | 3 | 1984-12-10 | 0 | 1984 | 1985 | 1984 | 1985 | |||||||||||||||||||||||||||
| 01-RC-018322 | 1 1 | RC | 18322 | 1984-11-26 | 1985-06-28 | 1985-05-09 | 295 | 20 20 | 13 | 4 | 233 233 | 0 | 0 | 0 | T | 8 | 0 | 21 | C | C | 5 | 1 | 3 | 1985-05-09 | 0 | 1984 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
| 01-RC-018324 | 1 1 | RC | 18324 | 1984-11-27 | 1985-03-05 | 1984-11-27 | 349 | 20 20 | 13 | 4 | 233 233 | 0 | 0 | 0 | T | 7 | 0 | A | D | 2 | 1 | 1 | 9 | 0 | 1984 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||||
| 01-RC-018325 | 1 1 | RC | 18325 | 1984-11-28 | 1986-07-29 | 1984-11-28 | 521 | 18 18 | 5 | 4 | 233 233 | 0 | 0 | 0 | T | 16 | 0 | A | A | 2 | 1 | 1 | 9 | 0 | 1984 | 1985 | 1986 | 1986 | ||||||||||||||||||||||||||||
| 01-RC-018331 | 1 1 | RC | 18331 | 1984-12-07 | 1985-12-14 | 1984-12-26 | 553 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 27 | 0 | 41 | E | 1984-12-19 | 1984-12-26 | 1984-12-26 | J | 4 | 9 | 1 | 9 | 1 | 0 | 8 | 1985-12-14 | 1984 | 1985 | 1985 | 1986 | |||||||||||||||||||||
| 01-RC-018357 | 1 1 | RC | 18357 | 1985-01-23 | 1985-02-13 | 1985-01-23 | 421 | 20 20 | 21 | 4 | 233 233 | 0 | 0 | 0 | T | 15 | 0 | A | A | 2 | 1 | 1 | 0 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||||
| 01-RC-018359 | 1 1 | RC | 18359 | 1985-01-25 | 1985-02-12 | 1985-02-05 | 472 | 20 20 | 21 | 4 | 233 233 | 0 | 0 | 0 | T | 26 | 0 | 15 | B | 1985-02-05 | D | 2 | 1 | 1 | 7 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018374 | 1 1 | RC | 18374 | 1985-01-31 | 1985-04-09 | 1985-02-25 | 571 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 11 | 0 | 21 | C | 1985-02-11 | F | 5 | 1 | 3 | 1985-02-25 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018381 | 1 1 | RC | 18381 | 1985-02-19 | 1985-09-24 | 1985-08-28 | 721 | 28 28 | 1 | 4 | 233 233 | 0 | 0 | 0 | T | 7 | 0 | 21 | C | C | 4 | 1 | 1 | 7 | 1985-08-28 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018385 | 1 1 | RC | 18385 | 1985-02-22 | 1985-05-08 | 1985-05-08 | 731 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 20 | 0 | 71 | J | 1985-03-04 | F | 5 | X | 4 | 1985-03-13 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018391 | 1 1 | RC | 18391 | 1985-02-28 | 1985-05-07 | 1985-02-28 | 441 | 28 28 | 11 | 4 | 233 233 | 0 | 0 | 0 | T | 10 | 0 | A | A | 2 | 1 | 1 | 7 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||||
| 01-RC-018394 | 1 1 | RC | 18394 | 1985-03-01 | 1985-05-01 | 1985-03-25 | 508 | 20 20 | 25 | 4 | 233 233 | 0 | 0 | 0 | T | 52 | 0 | 21 | C | 1985-03-20 | F | 2 | 1 | 1 | 7 | 1985-03-25 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||
| 01-RC-018401 | 1 1 | RC | 18401 | 1985-03-19 | 1985-05-17 | 1985-04-10 | 422 | 38 38 | 7 | 4 | 233 233 | 0 | 0 | 0 | T | 68 | 0 | 21 | C | C | 5 | 1 | 4 | 1985-04-10 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
| 01-RC-018408 | 1 1 | RC | 18408 | 1985-03-27 | 1985-06-17 | 1985-05-06 | 621 | 38 38 | 7 | 4 | 233 233 | 0 | 0 | 0 | T | 3 | 0 | 22 | C | 1985-04-03 | 1985-04-19 | 1985-04-19 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||
| 01-RC-018455 | 1 1 | RC | 18455 | 1985-04-04 | 1985-05-09 | 1985-04-23 | 171 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 3 | 0 | 21 | C | C | 5 | 1 | 3 | 1985-04-23 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
| 01-RC-018462 | 1 1 | RC | 18462 | 1985-04-05 | 1985-05-20 | 1985-04-12 | 373 | 20 20 | 5 | 4 | 233 233 | 0 | 0 | 0 | T | 15 | 0 | 15 | B | 1985-04-12 | D | 2 | 1 | 1 | 3 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018484 | 1 1 | RC | 18484 | 1985-04-29 | 1986-03-24 | 1985-08-12 | 421 | 20 20 | 25 | 4 | 233 233 | 0 | 0 | 0 | T | 100 | 0 | 79 | K | E | C | 5 | 1 | 4 | 1985-05-10 | 0 | 02 | 01 | 5 | 1985 | 1985 | 1986 | 1986 | 01-CA-023028-001 | ||||||||||||||||||||||
| 01-RC-018491 | 1 1 | RC | 18491 | 1985-05-08 | 1985-08-27 | 1985-06-21 | 421 | 44 44 | 23 | 4 | 233 233 | 0 | 0 | 0 | T | 14 | 0 | 22 | C | 1985-05-21 | 1985-06-04 | 1985-06-04 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||
| 01-RC-018493 | 1 1 | RC | 18493 | 1985-05-08 | 1985-06-25 | 1985-05-31 | 508 | 20 20 | 23 | 4 | 233 233 | 0 | 0 | 0 | T | 11 | 0 | 21 | C | 1985-05-15 | F | 5 | 1 | 4 | 1985-05-31 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018494 | 1 1 | RC | 18494 | 1985-05-08 | 1985-08-08 | 1985-06-11 | 421 | 44 44 | 23 | 4 | 233 233 | 0 | 0 | 0 | T | 11 | 0 | 21 | C | C | 5 | 1 | 3 | 1985-06-11 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
| 01-RC-018495 | 1 1 | RC | 18495 | 1985-05-08 | 1985-06-20 | 1985-05-28 | 421 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 12 | 0 | 41 | E | 1985-05-17 | 1985-05-28 | 1985-05-28 | N | 3 | 5 | 0 | 5 | 1 | 1 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||
| 01-RC-018505 | 1 1 | RC | 18505 | 1985-05-14 | 1985-07-02 | 1985-05-30 | 206 | 20 20 | 9 | 4 | 233 233 | 0 | 0 | 0 | T | 11 | 0 | 21 | C | 1985-05-22 | F | 5 | 1 | 3 | 1985-05-30 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018513 | 1 1 | RC | 18513 | 1985-06-12 | 1985-08-26 | 1985-07-16 | 509 | 20 20 | 25 | 4 | 233 233 | 0 | 0 | 0 | T | 19 | 0 | 22 | C | 1985-06-24 | 1985-07-01 | 1985-07-01 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||
| 01-RC-018522 | 1 1 | RC | 18522 | 1985-06-26 | 1985-08-05 | 1985-07-17 | 515 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 12 | 0 | 21 | C | C | 5 | 1 | 4 | 1985-07-17 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
| 01-RC-018546 | 1 1 | RC | 18546 | 1985-07-15 | 1985-09-17 | 1985-08-27 | 422 | 44 44 | 7 | 4 | 233 233 | 0 | 0 | 0 | T | 13 | 0 | 21 | C | F | 5 | 1 | 4 | 1985-08-27 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
| 01-RC-018549 | 1 1 | RC | 18549 | 1985-07-22 | 1985-08-30 | 1985-08-15 | 721 | 20 20 | 9 | 4 | 233 233 | 0 | 0 | 0 | T | 16 | 0 | 21 | C | 0 | 1985-07-30 | F | 5 | 1 | 4 | 1985-08-15 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||
| 01-RC-018550 | 1 1 | RC | 18550 | 1985-07-22 | 1985-07-24 | 1985-07-22 | 739 | 20 20 | 15 | 1 | 63 63 | 0 | 0 | 0 | T | 4 | 0 | A | A | 2 | 1 | 1 | 0 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||||
| 01-RC-018553 | 1 1 | RC | 18553 | 1985-07-26 | 1985-09-19 | 1985-08-20 | 355 | 20 20 | 13 | 4 | 233 233 | 0 | 0 | 0 | T | 7 | 0 | 21 | C | 0 | 1985-08-05 | F | 5 | 1 | 3 | 1985-08-20 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||
| 01-RC-018559 | 1 1 | RC | 18559 | 1985-08-01 | 1985-10-04 | 1985-09-13 | 422 | 20 20 | 5 | 4 | 233 233 | 0 | 0 | 0 | T | 3 | 0 | 20 | C | 1985-08-12 | E | 5 | X | 4 | 1 | 1985-09-13 | 0 | 1985 | 1985 | 1985 | 1986 | |||||||||||||||||||||||||
| 01-RC-018560 | 1 1 | RC | 18560 | 1985-08-01 | 1985-09-24 | 1985-09-10 | 514 | 20 20 | 5 | 4 | 233 233 | 0 | 0 | 0 | T | 8 | 0 | 21 | C | F | 5 | 1 | 4 | 1985-09-10 | 0 | 1985 | 1985 | 1985 | 1985 | |||||||||||||||||||||||||||
| 01-RC-018561 | 1 1 | RC | 18561 | 1985-08-01 | 1985-09-16 | 1985-08-20 | 444 | 38 38 | 7 | 4 | 233 233 | 0 | 0 | 0 | T | 8 | 0 | 21 | C | 1985-08-09 | F | 5 | 1 | 4 | 1985-08-20 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||
| 01-RC-018563 | 1 1 | RC | 18563 | 1985-08-05 | 1985-10-09 | 1985-08-29 | 422 | 20 20 | 25 | 4 | 233 233 | 0 | 0 | 0 | T | 17 | 0 | 21 | C | 1985-08-15 | F | 5 | 1 | 4 | 1985-08-29 | 0 | 1985 | 1985 | 1985 | 1986 | ||||||||||||||||||||||||||
| 01-RC-018564 | 1 1 | RC | 18564 | 1985-08-07 | 1985-12-18 | 1985-09-04 | 411 | 20 20 | 25 | 4 | 233 233 | 0 | 0 | 0 | T | 50 | 0 | 41 | E | 1 | 1985-08-16 | 1985-09-03 | 1985-09-04 | J | 0 | 1 | 0 | 2 | 1 | 1985-12-18 | 0 | 1985 | 1985 | 1985 | 1986 | |||||||||||||||||||||
| 01-RC-018569 | 1 1 | RC | 18569 | 1985-08-16 | 1985-10-23 | 1985-09-16 | 421 | 20 20 | 5 | 4 | 233 233 | 0 | 0 | 0 | T | 15 | 0 | 21 | C | C | 5 | 1 | 3 | 1985-09-16 | 0 | 1985 | 1985 | 1985 | 1986 | |||||||||||||||||||||||||||
| 01-RC-018594 | 1 1 | RC | 18594 | 1985-09-12 | 1985-09-24 | 1985-09-12 | 489 | 20 20 | 27 | 4 | 907 907 | 0 | 0 | 0 | T | 36 | 0 | A | A | 2 | 1 | 1 | 9 | 0 | 1985 | 1985 | 1985 | 1985 | ||||||||||||||||||||||||||||
| 01-RC-018595 | 1 1 | RC | 18595 | 1985-09-17 | 1985-11-18 | 1985-10-09 | 422 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 14 | 0 | 21 | C | C | 5 | 1 | 3 | 1985-10-09 | 0 | 1985 | 1985 | 1985 | 1986 | |||||||||||||||||||||||||||
| 01-RC-018601 | 1 1 | RC | 18601 | 1985-09-23 | 1985-11-08 | 1985-10-07 | 478 | 20 20 | 5 | 4 | 233 233 | 0 | 0 | 0 | T | 20 | 0 | 21 | C | 1985-10-03 | F | 5 | 1 | 4 | 1985-10-07 | 0 | 1985 | 1985 | 1985 | 1986 | ||||||||||||||||||||||||||
| 01-RC-018603 | 1 1 | RC | 18603 | 1985-09-24 | 1985-12-31 | 1985-11-25 | 422 | 20 20 | 21 | 4 | 233 233 | 0 | 0 | 0 | T | 3 | 2 | 0 | 22 | C | 1985-10-07 | 1985-10-29 | 1985-10-29 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1985 | 1985 | 1985 | 1986 | ||||||||||||||||||||||
| 01-RC-018605 | 1 1 | RC | 18605 | 1985-09-26 | 1985-11-04 | 1985-10-16 | 736 | 20 20 | 25 | 4 | 233 233 | 0 | 0 | 0 | T | 20 | 0 | 41 | E | 1985-10-09 | 1985-10-16 | 1985-10-16 | N | 3 | 5 | 0 | 5 | 1 | 1 | 0 | 1985 | 1985 | 1985 | 1986 | ||||||||||||||||||||||
| 01-RC-018606 | 1 1 | RC | 18606 | 1985-09-30 | 1985-10-18 | 1985-10-07 | 546 | 20 20 | 21 | 1 | 26 26 | 0 | 0 | 0 | T | 14 | 0 | 15 | B | 1985-10-07 | D | 2 | 1 | 1 | 9 | 0 | 1985 | 1985 | 1985 | 1986 | ||||||||||||||||||||||||||
| 01-RC-018607 | 1 1 | RC | 18607 | 1985-09-30 | 1986-01-14 | 1985-10-25 | 546 | 20 20 | 9 | 1 | 187 187 | 0 | 0 | 0 | T | 23 | 0 | 21 | C | 1985-10-11 | F | 5 | 1 | 4 | 1985-10-25 | 0 | 1985 | 1985 | 1986 | 1986 | ||||||||||||||||||||||||||
| 01-RC-018616 | 1 1 | RC | 18616 | 1985-10-15 | 1985-11-25 | 1985-10-31 | 208 | 28 28 | 15 | 4 | 233 233 | 0 | 0 | 0 | T | 30 | 0 | 21 | C | C | 5 | 1 | 4 | 1985-10-31 | 0 | 1985 | 1986 | 1985 | 1986 | |||||||||||||||||||||||||||
| 01-RC-018622 | 1 1 | RC | 18622 | 1985-11-01 | 1986-04-17 | 1985-11-25 | 511 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 150 | 0 | 21 | C | C | 4 | 1 | 1 | 9 | 1985-11-25 | 0 | 1985 | 1986 | 1986 | 1986 | ||||||||||||||||||||||||||
| 01-RC-018625 | 1 1 | RC | 18625 | 1985-11-06 | 1985-12-17 | 1985-12-02 | 154 | 20 20 | 25 | 4 | 233 233 | 0 | 0 | 0 | T | 21 | 0 | 21 | C | 1985-11-21 | F | 4 | 1 | 1 | 7 | 1985-12-02 | 0 | 1985 | 1986 | 1985 | 1986 | |||||||||||||||||||||||||
| 01-RC-018626 | 1 1 | RC | 18626 | 1985-11-06 | 1986-01-27 | 1985-12-16 | 208 | 20 20 | 21 | 4 | 233 233 | 0 | 0 | 0 | T | 12 | 0 | 22 | C | 1985-11-14 | 1985-11-20 | 1985-11-20 | N | 5 | 7 | 3 | 1 | 1 | 0 | 1985 | 1986 | 1986 | 1986 | |||||||||||||||||||||||
| 01-RC-018628 | 1 1 | RC | 18628 | 1985-11-12 | 1985-12-04 | 1985-11-12 | 441 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 96 | 0 | A | A | 2 | 1 | 1 | 9 | 0 | 1985 | 1986 | 1985 | 1986 | ||||||||||||||||||||||||||||
| 01-RC-018631 | 1 1 | RC | 18631 | 1985-11-22 | 1986-05-21 | 1986-01-24 | 421 | 20 20 | 13 | 4 | 233 233 | 0 | 0 | 0 | T | 10 | 0 | 18 | B | W | C | 4 | X | 1 | 9 | 1985-12-12 | 0 | 02 | 03 | 5 | 1985 | 1986 | 1986 | 1986 | 01-CA-023360-001 | |||||||||||||||||||||
| 01-RC-018636 | 1 1 | RC | 18636 | 1985-12-10 | 1986-02-07 | 1985-12-31 | 451 | 20 20 | 25 | 4 | 233 233 | 0 | 0 | 0 | T | 20 | 0 | 21 | C | 1985-12-17 | F | 2 | 1 | 1 | 7 | 1985-12-31 | 0 | 1985 | 1986 | 1986 | 1986 | |||||||||||||||||||||||||
| 01-RC-018664 | 1 1 | RC | 18664 | 1986-02-03 | 1987-02-02 | 1986-09-12 | 421 | 20 20 | 21 | 4 | 233 233 | 0 | 0 | 0 | T | 37 | 0 | 18 | B | E | C | 5 | X | 4 | 1986-03-04 | 0 | 02 | 01 | 5 | 1986 | 1986 | 1987 | 1987 | 01-CA-023570-001 | ||||||||||||||||||||||
| 01-RC-018668 | 1 1 | RC | 18668 | 1986-02-12 | 1986-04-11 | 1986-03-13 | 739 | 20 20 | 17 | 4 | 233 233 | 0 | 0 | 0 | T | 12 | 0 | 21 | C | C | 5 | 1 | 3 | 1986-03-13 | 0 | 1986 | 1986 | 1986 | 1986 | |||||||||||||||||||||||||||
| 01-RC-018684 | 1 1 | RC | 18684 | 1986-03-03 | 1986-05-02 | 1986-04-21 | 541 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 15 | 0 | 22 | C | 1986-03-12 | 1986-03-19 | 1986-03-19 | N | 4 | 9 | 1 | 9 | 1 | 1 | 0 | 1986 | 1986 | 1986 | 1986 | ||||||||||||||||||||||
| 01-RC-018696 | 1 1 | RC | 18696 | 1986-03-20 | 1987-02-18 | 1986-04-07 | 176 | 20 20 | 27 | 4 | 233 233 | 0 | 0 | 0 | T | 4 | 0 | 15 | B | 1986-04-07 | D | 2 | 1 | 1 | 7 | 0 | 1986 | 1986 | 1987 | 1987 | ||||||||||||||||||||||||||
| 01-RC-018701 | 1 1 | RC | 18701 | 1986-03-26 | 1987-02-13 | 1986-10-27 | 154 | 20 20 | 13 | 4 | 233 233 | 0 | 0 | 0 | T | 13 | 0 | 71 | J | 1986-04-08 | 1986-04-15 | 1986-04-15 | I | 5 | 1 | 3 | 1 | 1986-07-30 | 0 | 1986 | 1986 | 1987 | 1987 |
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]) );