c_master: 07-CA-028711-002
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-028711-002 | 7 | CA | 28711 | 2 | 1988-12-12 | 1994-10-25 | 1992-03-25 | 163 | 21 | 179 | 8000 | 0 | 0 | 0 | 15 | 1 | 0 | 4 | 1 | 1 | 93 | P | N | 2 | 1989-01-24 | 4 | 3.0 | 4 | 4 | 1 | N | 1988 | 1994 | 1989 | 1995 | 07-CA-028711-001 |
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