r_case: 02-RC-23213
| r_case_number | case_type | status | nlrb_office_id | docket_num | inquiry_id | case_name | date_filed | hearing_target_date | election_target_date | employer_on_petition | union_involved_on_petition | intervenor_on_petition | self_certification | post_elect_self_cert | naics_code | num_employees_requested | description_requested |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 02-RC-23213 | Certification of Representative RC | Closed Close | Region 02, New York, New York 02 | 23213 | Nyack Hospital Inc. | 2007-07-25T00:00:00 | 2007-08-08T00:00:00 | 2007-09-05T00:00:00 | Nyack Hospital Inc. | N | N | General Medical and Surgical Hospitals 622110 | 44 | Included All professional employees, including part timers and per diems Excluded All other employees, including registernurses, technical employees, business office clericals skilled maintenance employees, guards an supervisors as defined in the Act. |
Links from other tables
- 1 row from r_case_number in r_bargaining_unit
- 1 row from r_case_number in r_closed_case
- 1 row from r_case_number in r_impact_category
- 6 rows from r_case_number in r_part_variant
- 6 rows from r_case_number in r_participant
- 0 rows from r_case_number in r_post_elect_board_act
- 0 rows from r_case_number in r_pre_elect_board_act
- 0 rows from r_case_number in r_reopened_case
- 0 rows from new_case_number in r_transfer_history
- 1 row from r_case_number in r_transfer_history