home / cats / r_case

r_case: 01-RC-20915

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-20915 Certification of Representative RC Closed Close Region 01, Boston, Massachusetts 01 20915   Norton Company (Plant 7) 1998-10-22T00:00:00 1998-11-05T00:00:00 1998-12-03T00:00:00 Norton Company (Plant 7)     N N All Other Miscellaneous Manufacturing 339999 250 molders (all levels), spare fireman, band 2, 3, double spindle operator, machinists, mixer, truer, grader, kiln, dry room attendent, cement mix, strippers, tempt control, machine operator, inspector, fork truck driver, reameer, speed test, finishing, bond plant operator, reclaim, hydraulic technician, packer, production operator (all levels) shaver

Links from other tables

  • 0 rows 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 18.609ms