r_case: 01-RC-21508
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-21508 | Certification of Representative RC | Closed Close | Region 01, Boston, Massachusetts 01 | 21508 | Kayem Foods, Inc. | 2002-05-28T00:00:00 | 2002-06-11T00:00:00 | 2002-07-09T00:00:00 | Kayem Foods, Inc. | N | N | All Other Miscellaneous Food Manufacturing 311999 | 320 | A full-time and part-time production, maintenance and warehouse employees employed by the employer at its Chelsea Plant. Excluded, All other employees, production schedulers, quality control employees, industrial engineer, proffessional employees, managerial employees, guards, supervisors 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
- 2 rows from r_case_number in r_impact_category
- 2 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
- 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