c_master: 02-CA-016796-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-016796-001 | 2 | CA | 16796 | 1 | 1979-10-15 | 1985-07-17 | 1985-02-20 | 61 | 31 | 806 | 5000 | 0 | 0000 | 0 | 41 | 0 | 5 | 1 | 1 | 3 | 86 | 6 | M | 1 | 0 | 4 | 3.0 | 8 | 4 | 01 | 0.0 | N | 1979 | 1985 | 1980 | 1985 |
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
- 0 rows 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