home / cats / r_case

r_case: 01-RC-20080

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-20080 Certification of Representative RC Closed Close Region 01, Boston, Massachusetts 01 20080   Elmhurst Extended Care Facility 1994-01-14T00:00:00 1994-01-28T00:00:00 1994-02-25T00:00:00 Elmhurst Extended Care Facility     N N Nursing Care Facilities 623110 200  

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
  • 2 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
Powered by Datasette · Queries took 10.91ms