r_case: 03-RC-10806
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 03-RC-10806 | Certification of Representative RC | Closed Close | Region 03, Buffalo, New York 03 | 10806 | Isaac Heating & Air Conditioning Inc. | 1999-03-12T00:00:00 | 1999-03-26T00:00:00 | 1999-04-23T00:00:00 | Isaac Heating & Air Conditioning Inc. | N | N | Plumbing, Heating, and Air-Conditioning Contractors 238220 | 60 | All full-time and regular part-time heating and air conditioning service and installation employees in residential and commercial divisions, including those employed at Employer's Livingston County facility, drivers and warehouse employees, but excluding business office clericals, sales employees, appliance technicians, part coordinators, guards and supervision as defined by 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
- 5 rows from r_case_number in r_part_variant
- 7 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