r_case: 04-UC-00372
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 04-UC-00372 | Unit Clarification UC | Closed Close | Region 04, Philadelphia, Pennsylvania 04 | 372 | NBC, Inc. d/b/a WCAU TV (NBC 10) | 2000-06-05T00:00:00 | 2000-06-19T00:00:00 | 2000-07-17T00:00:00 | NBC, Inc. d/b/a WCAU TV (NBC 10) | N | N | Television Broadcasting 515120 | 72 | All persons who are regularly employed by the Company at station WCAU, Philadelphia as staff or freelance announcers, and actors, dramatic narrators, singers, dancers, critics and program hosts and newscasters, sportscasters, weatherpersons, news analysts, news commentators, news correspondents, news writers, news reporters, news editors and news producers. |
Links from other tables
- 1 row from r_case_number in r_bargaining_unit
- 2 rows 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
- 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
- 2 rows from r_case_number in r_reopened_case
- 3 rows from r_case_number in r_transfer_history
- 2 rows from new_case_number in r_transfer_history
- 3 rows from r_case_number in r_transfer_history