home / cats / r_case

r_case: 05-RD-01337

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
05-RD-01337 Decertification (removal of rep.) RD Closed Close Region 05, Baltimore, Maryland 05 1337   Printpack Inc. 2004-04-08T00:00:00 2004-04-22T00:00:00 2004-05-20T00:00:00 Printpack Inc. Paper, Allied-Industrial, Chemical & Energy Workers International Union, Region 3 Local 2-743   N N All Other Plastics Product Manufacturing 326199 146 All production and maintenance employees

Links from other tables

  • 1 row from r_case_number in r_bargaining_unit
  • 2 rows from r_case_number in r_closed_case
  • 4 rows from r_case_number in r_impact_category
  • 0 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
  • 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.187ms