home / cats / r_case

r_case: 04-AC-00080

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-AC-00080 Amendment of Certification AC Closed Close Region 04, Philadelphia, Pennsylvania 04 80   Pinnacle Health System, d/b/a Polyclinic Hospital 2000-08-10T00:00:00 2000-08-24T00:00:00 2000-09-21T00:00:00 Pinnacle Health System, d/b/a Polyclinic Hospital Polyclinic Professional Nurses Association, PSEA Health Care/PSEA Pennsylvania Association of Staff Nurses and Allied Professionals N N General Medical and Surgical Hospitals 622110   All full time and regular part time general duty registered nurses and licensed practical nurses employed by Pinnacle Health Systems, Inc. at its Polyclinic Hospital facility

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
  • 2 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
  • 1 row from r_case_number in r_reopened_case
  • 3 rows from r_case_number in r_transfer_history
  • 1 row from new_case_number in r_transfer_history
  • 3 rows from r_case_number in r_transfer_history
Powered by Datasette · Queries took 3.027ms