r_case: 08-RC-15410
This data as json
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 08-RC-15410 | Certification of Representative RC | Closed Close | Region 08, Cleveland, Ohio 08 | 15410 | St. Francis Health Care Center | 1996-07-16T00:00:00 | 1996-07-30T00:00:00 | 1996-08-27T00:00:00 | St. Francis Health Care Center | District 1199/The Health Care and Social Service Union, SEIU, AFL-CIO | N | N | Nursing Care Facilities 623110 | 130 | Included: All full-time and part-time service and maintenance employees including certified nursing assistants, dietary aides, cooks, assistant cooks, environmental services/housekeepers, laundry aides, plant operations, recreational therapy assistants, occupational therapy assistants, physical therapy aides, transport aides, central supply. Excluded: All professional employees, certified occupational therapy assistants, certified registered respiratory therapists, registered respiratory therapists, education, secretary pool, ward clerks, medical records, physical therapy assistants, licensed practical nurses, registered nurses, and all supervisors and guards as defined by the Act. |
Links from other tables
- 1 row from r_case_number in r_bargaining_unit
- 2 rows from r_case_number in r_closed_case
- 1 row from r_case_number in r_impact_category
- 0 rows from r_case_number in r_part_variant
- 3 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
- 1 row from r_case_number in r_reopened_case
- 1 row from r_case_number in r_transfer_history
- 0 rows from new_case_number in r_transfer_history
- 1 row from r_case_number in r_transfer_history