c_formal2
where case_number = "07-CA-026529-001"
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | case_number | cf2_date | date_last_action | consolidation_type | consolidation_code | update_control | code_date_transfer_board | date_transfer_board | control_type | date_decision_issued | type_decision | disp_allegations | allegations_uphld | allegations_dismd | number_discrim_reinstated_ca | number_receive_back_pay_uni_emp_cb | number_receive_back_pay_only_ca | number_discrim_restored_cb | number_discrim_dismissed | number_discrim_preferred | remedy | board_members | board_disposition_allegations | close_control | card_control | code_date_dec_issued | volume_number | issue_number | party_filing_excpt | board_members_5 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3160 | 3160 | 07-CA-026529-001 | 1989-03-24 | 1989-05-02 | 1 | A | 2 | 1 | 1989-05-02 | 0 | 3 | ||||||||||||||||||||
| 3161 | 3161 | 07-CA-026529-001 | 1990-06-26 | 1991-12-10 | 1 | A | 5 | 4 | 1990-06-26 | 2 | 1990-06-26 | 0 | 1 | 09 | 00 | 2 | 1 | 3 | 7 |
CREATE TABLE "c_formal2" ( [case_number] TEXT REFERENCES [c_master]([case_number]), [cf2_date] TEXT, [date_last_action] TEXT, [consolidation_type] TEXT, [consolidation_code] TEXT, [update_control] INTEGER, [code_date_transfer_board] TEXT, [date_transfer_board] TEXT, [control_type] TEXT, [date_decision_issued] TEXT, [type_decision] TEXT, [disp_allegations] TEXT, [allegations_uphld] TEXT, [allegations_dismd] TEXT, [number_discrim_reinstated_ca] TEXT, [number_receive_back_pay_uni_emp_cb] TEXT, [number_receive_back_pay_only_ca] TEXT, [number_discrim_restored_cb] TEXT, [number_discrim_dismissed] TEXT, [number_discrim_preferred] TEXT, [remedy] TEXT, [board_members] TEXT, [board_disposition_allegations] TEXT, [close_control] TEXT, [card_control] TEXT, [code_date_dec_issued] TEXT, [volume_number] TEXT, [issue_number] TEXT, [party_filing_excpt] TEXT, [board_members_5] TEXT );