home / chips / r_master

r_master: 01-RC-018500

This data as json

case_number region ctype docket file_date close_date date_last_action industry state county petitioner_type petitioner joint_petitioner local_number recogn_union_type recogn_union joint_recogn_union unit number_emp proposed_no_emp picket_8b7c status machine_control proceeding_control date_appeal ruling_code consol_code date_notice_hearing_issued date_hearing_opened date_hearing_closed hearing_control code_date_closed stage_closed method_closed reason_close hearing_held_code dec_made_code date_agree_approv date_appea_recd date_action_on_appeal chips_amended_code date_hearing2_closed_108 date_hearing2_open_108 blocking_case_code consol_sever case_stage_action consol_type chips_close_flag chips_close_date filed_calendar_year filed_fiscal_year closed_calendar_year closed_fiscal_year blocking_case_number consol_case_number sub_consol_case_number transfer_case_number
01-RC-018500 1 1 RC 18500 1985-05-10 1985-07-12 1985-07-12 805 20 20 13 1 23 23 0 1     0 P 8   0 22 C       C 1985-05-16 1985-05-30 1985-06-12 P 1 5 0 1 1 1       0       02 01   8 1985-07-12 1985 1985 1985 1985   01-RC-018499 01-RC-018500  

Links from other tables

  • 1 row from case_number in r_address
  • 0 rows from case_number in r_blocking
  • 1 row from case_number in r_consolid
  • 1 row from case_number in r_formal1
  • 0 rows from case_number in r_formal2
  • 1 row from case_number in r_names
  • 0 rows from case_number in rc_elect
  • 0 rows from case_number in ud_elect
Powered by Datasette · Queries took 19.689ms