c_master: 04-CA-010147-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 04-CA-010147-001 | 4 | CA | 10147 | 1 | 1979-04-17 | 1991-10-01 | 1981-10-30 | 001 | 29 | 581 | 1105 | 0 | 0000 | 0 | 9 | 4 | 5 | 1 | 1 | 18 | 6 | E | 2 | 1979-06-22 | 4 | 3.0 | 6 | 5 | 16 | 4.0 | O | 1979 | 1991 | 1979 | 1992 |
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