c_master: 07-CA-026529-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 07-CA-026529-001 | 7 | CA | 26529 | 1 | 1987-01-06 | 1993-10-25 | 1992-09-03 | 49 | 21 | 551 | 1241 | 0 | 0000 | 0 | 9 | 2 | 5 | 1 | 1 | 2 | 18 | 8 | E | 2 | 1987-02-19 | 4 | 3.0 | 8 | 4 | N | 1987 | 1993 | 1987 | 1994 |
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
- 2 rows from case_number in c_formal2
- 2 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