r_case: 01-RC-22087
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-RC-22087 | Certification of Representative RC | Closed Close | Region 01, Boston, Massachusetts 01 | 22087 | Fallon Ambulance Service | 2007-01-30T00:00:00 | 2007-02-13T00:00:00 | 2007-03-13T00:00:00 | Fallon Service, Inc. | Office and Professional Employees International Union, Local 6, AFL-CIO | N | N | Special Needs Transportation 485991 | 500 | Included All regular full time and regular part time paramedics, emergency medical technicians and chair car attendants employed at all of the company's Massachusetts locations. Excluded Office clerical, secretaries, guards and all management and supervisors as defined in 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
- 1 row from r_case_number in r_part_variant
- 5 rows from r_case_number in r_participant
- 1 row 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