home / chips / c_master

c_master: 07-CA-014007-001

This data as json

case_number region ctype docket suffix file_date close_date date_last_action county state industry complainant joint_complainant respondent joint_respondent number_employed allegations number_discrim situation number_of_charges type_charge number_allegations status formal_action_control machine_control proceeding_control fact_advice type_refusal fact_appeal code_date_ro_disp date_ro_disp method_disposition collyer_deferral date_collyer_began date_collyer_end code_date_closed stage_close method_close reason_remedy_close status_barg_close solic_stages_investig contact_witness date_re_advice_received date_action_on_advice date_appeal_received date_action_on_appeal hearing_held_code decision_made_code chips_close_flag chips_close_date related_case chips_amended_code formal_setl filed_calendar_year closed_calendar_year filed_fiscal_year closed_fiscal_year key_case_number sub_key_case_number transferred_case_number
07-CA-014007-001 7 CA 14007 1 1977-05-02 1984-03-29 1983-11-22 125 21 517 2322 0 0000 0 50 9 1 5 1 1 2 18 6 E         2 1977-06-30 4       3.0 6 4 10                         Y   1977 1984 1977 1984      

Links from other tables

  • 0 rows from blocking_case_number in r_blocking
  • 1 row from case_number in c_names
  • 1 row from case_number in c_address
  • 1 row from case_number in c_formal2
  • 1 row from case_number in c_formal3
  • 1 row from case_number in c_formal4
  • 1 row from case_number in c_formal1
  • 0 rows from case_number in c_consolid
  • 1 row from case_number in c_trailer
Powered by Datasette · Queries took 83.935ms