c_master: 02-CA-021111-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 02-CA-021111-001 | 2 | CA | 21111 | 1 | 1985-06-19 | 1989-10-04 | 1989-02-28 | 61 | 31 | 581 | 1105 | 0 | 0000 | 0 | 9 | 1 | 5 | 1 | 1 | 2 | 18 | 8 | E | 2 | 1985-08-01 | 4 | 3.0 | 6 | 4 | 01 | N | 1985 | 1989 | 1985 | 1990 |
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