home / chips / c_master

c_master: 01-CA-027007-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
01-CA-027007-001 1 CA 27007 1 1990-01-23 1994-01-31 1993-08-26 025 20 242 2342 0 0000 0 4 33 0 5 1 1 2 28 8 D         2 1990-03-16 4       0.0 4 4 69                         Y   1990 1994 1990 1994      

Links from other tables

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