r_case: 01-AC-00098
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-AC-00098 | Amendment of Certification AC | Closed Close | Region 01, Boston, Massachusetts 01 | 98 | Sterling Suffolk Racecourse, LLC, a Joint Employer with U. S. Security Associates, Inc. | 2007-08-17T00:00:00 | 2007-08-31T00:00:00 | 2007-09-28T00:00:00 | Sterling Suffolk Racecourse, LLC, a Joint Employer with U. S. Security Associates, Inc. | International Union, Security, Police and Fire Professionals of America (SPFPA) | N | N | Racetracks 711212 | 50 | Included: All full time and regular part time armed and unarmed security officers performing guard duties employed by the U. S. Security Associates, Inc., and Sterling Suffolk Racecourse, LLC, joint emplyers, and who work at the Suffolk Downs Racetrack in East Boston, Massachusetts. Exluded: All other employees and supervisors 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
- 0 rows from r_case_number in r_part_variant
- 8 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 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