c_formal1
where case_number = "02-CA-019594-001"
Download this data as a CSV Spreadsheet (All Rows)
CREATE TABLE "c_formal1" ( [case_number] TEXT REFERENCES [c_master]([case_number]), [cf1_date] TEXT, [date_last_action] TEXT, [consol_type] TEXT, [consol_code] TEXT, [update_control] TEXT, [code_date_complt_iss] TEXT, [date_complaint_issued] TEXT, [allegations] TEXT, [number_discrim] INTEGER, [complaint_control] TEXT, [code_date_ro_disp] TEXT, [date_ro_disp] TEXT, [ro_disp_control] TEXT, [date_hearing_opened] TEXT, [code_date_hearing_closed] TEXT, [date_hearing_closed] TEXT, [hearing_control] TEXT, [code_date_disp_issed_recd] TEXT, [date_disp_issued_recd] TEXT, [type_disposition] TEXT, [allegations_uphld] TEXT, [allegations_dismd] TEXT, [discrim_upheld] TEXT, [discrim_dismissed] TEXT, [back_pay_control] TEXT, [admin_law_judge_disp] TEXT, [board_decision_control] TEXT, [card_control] TEXT, [number_discrim_reinst_ca] INTEGER, [number_rec_back_pay_uni_emp_cb] INTEGER, [number_rec_back_pay_only_ca] INTEGER, [number_discrim_restor_cb] TEXT, [number_discrim_preferd] INTEGER, [remedy] TEXT, [code_date_hearing_opened] TEXT, [chips_amended_code] TEXT, [consol_server] TEXT, [case_state_action] TEXT, [complaint_calendar_year] INTEGER, [complaint_fical_year] INTEGER, [consol_case_number] TEXT, [sub_consol_case_number] TEXT );