r_case: 01-RC-22359
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-22359 | Certification of Representative RC | Region 01, Boston, Massachusetts 01 | 22359 | BTE/EMCOR | 2009-08-25T00:00:00 | BTE/EMCOR | Firemen and Oilers, Chapter 3, Local 615, a/w Service Employees International Union | N | N | Corporate, Subsidiary, and Regional Managing Offices 551114 | 6 | Included: All maintenance technicians including HVAC mechanics, electricians, plumbers, pipe fitters, carpenters, painters, general maintenance mechanics and all helpers located at the Boston Scientific Facility at One Boston Scientific Way, Natick, Massachusetts Excluded: All office clerical employees, sales satff, professional engineers, project supervisors, truck drivers, sub-contracted employees, guards and supervisors as defined by the Act. |
Links from other tables
- 0 rows from r_case_number in r_bargaining_unit
- 0 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
- 8 rows from r_case_number in r_participant
- 0 rows from r_case_number in r_post_elect_board_act
- 1 row from r_case_number in r_pre_elect_board_act
- 0 rows from r_case_number in r_reopened_case
- 0 rows from r_case_number in r_transfer_history
- 0 rows from new_case_number in r_transfer_history
- 0 rows from r_case_number in r_transfer_history