r_master: 01-RD-001604
| 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-RD-001604 | 1 1 | RD | 1604 | 1989-05-19 | 1990-08-16 | 1990-05-23 | 201 | 28 28 | 11 | 8 | 0 | 0 | 1 | 241 241 | 0 | A | 90 | 0 | 41 | E | 2 | 1990-05-16 | 1990-05-23 | 1990-05-23 | J | 5 | 7 | 3 | 1 | 1989-09-11 | 1990-01-08 | 0 | 1989 | 1989 | 1990 | 1990 | 01-CA-026782-001 |
Links from other tables
- 1 row from case_number in r_formal2
- 0 rows from case_number in r_formal1
- 1 row from case_number in r_blocking
- 0 rows from case_number in r_consolid
- 1 row from case_number in r_names
- 1 row from case_number in r_address
- 2 rows from case_number in rc_elect
- 0 rows from case_number in ud_elect