r_case: 01-RC-21227
| 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-21227 | Certification of Representative RC | Closed Close | Region 01, Boston, Massachusetts 01 | 21227 | Air Quality Experts, Inc. | 2000-08-08T00:00:00 | 2000-08-22T00:00:00 | 2000-09-19T00:00:00 | Air Quality Experts, Inc. | N | N | All Other Support Services 561990 | 20 | All workers involved in the remediation and abatement of asbestos material, all workers involved in lead abatement, all workers performing demolition, all general laborers, and all asbestos supervisors in the territorial jurisdiction of Massachusetts, New Hampshire and Maine. |
Links from other tables
- 1 row from r_case_number in r_bargaining_unit
- 1 row from r_case_number in r_closed_case
- 2 rows 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
- 1 row 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
- 0 rows from r_case_number in r_transfer_history