home / cats / r_case

r_case: 06-RC-12276

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
06-RC-12276 Certification of Representative RC   Region 06, Pittsburgh, Pennsylvania 06 12276   Point Park University 2003-10-20T00:00:00     Point Park University     N N Colleges, Universities, and Professional Schools 611310 68 Included: All fulltime faculty; excluding, all other employees, supervisors and guards, 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
  • 2 rows from r_case_number in r_impact_category
  • 0 rows from r_case_number in r_part_variant
  • 7 rows from r_case_number in r_participant
  • 1 row from r_case_number in r_post_elect_board_act
  • 1 row from r_case_number in r_pre_elect_board_act
  • 1 row 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
Powered by Datasette · Queries took 4.08ms