r_case: 01-UC-00761
| 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-UC-00761 | Unit Clarification UC | Closed Close | Region 01, Boston, Massachusetts 01 | 761 | Narragansett Gas & Electric Company, a Wholly Owned Subsidiary of National Grid, USA | 2000-09-07T00:00:00 | 2000-09-21T00:00:00 | 2000-10-19T00:00:00 | National Grid, USA | N | N | Other Electric Power Generation 221119 | 479 | All maintenance employees, transmission employees, distribution employees, substation employees, customer service employees, clerical employees, meter service employees, and material employees employed by the Employer in the Providence, Rhode island district including the Chopmist, Warren and Providence locations, but ex cluding guards and 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
- 0 rows from r_case_number in r_part_variant
- 4 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