home / chips

c_formal2

where case_number = "32-CA-004835-001"

✎ View and edit SQL

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
12846 12846 32-CA-004835-001 1983-09-12 1986-03-31     4 1 1983-09-12 0 1986-03-31 0 1 33 00                 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
);
Powered by Datasette · Queries took 14.909ms