c_formal2
13,812 rows
Suggested facets: consolidation_type, consolidation_code, update_control, code_date_transfer_board, control_type, type_decision, disp_allegations, allegations_uphld, allegations_dismd, number_discrim_reinstated_ca, 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, cf2_date (date), date_last_action (date), date_transfer_board (date), date_decision_issued (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-CA-007643-001 | 1970-10-10 | 1973-04-01 | A | 5 | 1973-04-01 | 0 | 1973-10-25 | 0 | 1 | 41 | 00 | 18 | 0 | 0 | 0 | 1 | 0 | 01 | 345 | 1 | 1 | 3 | |||||||
| 01-CA-007837-001 | 1970-10-10 | 1973-04-01 | 1 | E | 5 | 1973-04-01 | 0 | 1973-10-25 | 0 | 1 | 41 | 00 | 0 | 0 | 0 | 0 | 01 | 345 | 1 | 1 | 3 | ||||||||
| 01-CA-007903-001 | 1970-10-10 | 1973-04-01 | 1 | E | 5 | 1973-04-01 | 0 | 1973-10-25 | 0 | 1 | 41 | 00 | 0 | 0 | 0 | 0 | 01 | 345 | 1 | 1 | 3 | ||||||||
| 01-CA-008742-001 | 1970-10-10 | 1973-06-01 | 5 | 1973-06-01 | 2 | 1973-06-25 | 2 | 1 | 41 | 00 | 2 | 0 | 0 | 0 | 0 | 0 | 01 | 1 | 3 | ||||||||||
| 01-CA-010348-001 | 1970-10-10 | 1976-01-21 | 5 | 1976-01-21 | 0 | 1976-05-24 | 0 | 2 | 57 | 01 | 11 | 0 | 0 | 0 | 0 | 0 | 17 | 245 | 1 | 1 | 3 | ||||||||
| 01-CA-011061-001 | 1970-10-10 | 1975-12-01 | 6 | 1975-12-01 | 0 | 1986-09-30 | 0 | 3 | 00 | 33 | 235 | 2 | 0 | 3 | 9 | ||||||||||||||
| 01-CA-011524-001 | 1970-10-10 | 1977-02-01 | 5 | 1977-02-01 | 0 | 1977-04-25 | 0 | 1 | 01 | 09 | 1 | 0 | 0 | 0 | 0 | 0 | 01 | 123 | 1 | 1 | 3 | ||||||||
| 01-CA-011684-001 | 1970-10-10 | 1978-09-01 | 5 | A | 4 | 1978-09-01 | 2 | 1978-09-25 | 2 | 41 | 00 | 1 | 0 | 0 | 0 | 0 | 0 | 01 | 3 | ||||||||||
| 01-CA-011733-001 | 1970-10-10 | 1977-12-01 | 4 | 1977-12-01 | 0 | 1978-09-25 | 0 | 1 | 41 | 00 | 2 | 0 | 0 | 0 | 0 | 0 | 17 | 157 | 1 | 3 | |||||||||
| 01-CA-012015-001 | 1970-10-10 | 1982-03-31 | 1 | A | 4 | 1978-11-02 | 6 | 1982-03-31 | 0 | 1 | 41 | 00 | 2 | 3 | 7 | 0000 | |||||||||||||
| 01-CA-012030-001 | 1970-10-10 | 1978-09-01 | 5 | E | 4 | 1978-09-01 | 2 | 1978-09-25 | 2 | 41 | 00 | 0 | 0 | 0 | 0 | 0 | 01 | 3 | |||||||||||
| 01-CA-012137-001 | 1970-10-10 | 1978-11-02 | 1 | E | 1 | 1978-11-02 | 6 | 3 | |||||||||||||||||||||
| 01-CA-012264-001 | 1970-10-10 | 1978-05-15 | 1 | A | 2 | 1978-05-15 | 0 | 3 | |||||||||||||||||||||
| 01-CA-012370-001 | 1970-10-10 | 1978-05-01 | 1 | E | 2 | 1978-05-01 | 0 | 3 | |||||||||||||||||||||
| 01-CA-012507-001 | 1970-10-10 | 1977-08-01 | 4 | 1977-08-01 | 0 | 1977-11-25 | 0 | 1 | 09 | 00 | 1 | 0 | 0 | 0 | 0 | 0 | 01 | 123 | 1 | 3 | |||||||||
| 01-CA-012643-001 | 1985-11-25 | 1987-02-27 | 5 | 5 | 1984-01-30 | 0 | 1985-11-25 | 0 | 1 | 41 | 00 | 1 | 1 | 3 | 7 | ||||||||||||||
| 01-CA-012958-001 | 1982-11-01 | 1984-12-06 | 5 | 1 | 1982-11-01 | 0 | 1 | 3 | |||||||||||||||||||||
| 01-CA-012975-001 | 1970-10-10 | 1982-08-09 | 4 | 1981-03-13 | 0 | 1982-08-09 | 0 | 1 | 33 | 00 | 1 | 3 | 7 | ||||||||||||||||
| 01-CA-012978-001 | 1982-08-09 | 1982-08-09 | 1 | E | 4 | 5 | 1981-01-30 | 0 | 1982-08-09 | 0 | 2 | 32 | 00 | 0 | 1 | 3 | 7 | ||||||||||||
| 01-CA-013014-001 | 1970-10-10 | 1983-01-06 | A | 5 | 1979-08-02 | 0 | 1982-09-21 | 0 | 1 | 09 | 00 | 125 | 1 | 1 | 3 | 7 | |||||||||||||
| 01-CA-013167-001 | 1970-10-10 | 1980-07-17 | 5 | 1978-04-01 | 0 | 1978-07-25 | 0 | 1 | 09 | 00 | 8 | 0 | 0 | 0 | 0 | 0 | 01 | 124 | 1 | 1 | 3 | ||||||||
| 01-CA-013208-001 | 1970-10-10 | 1982-09-28 | 4 | 0 | 1982-09-28 | 0 | 1 | 41 | 00 | 2 | 3 | 7 | |||||||||||||||||
| 01-CA-013230-001 | 1970-10-10 | 1978-08-02 | E | 4 | 1978-08-02 | 0 | 1979-09-28 | 0 | Z | 09 | 09 | 0 | 0 | 0 | 0 | 01 | 125 | 1 | 3 | ||||||||||
| 01-CA-013282-001 | 1970-10-10 | 1978-08-02 | E | 4 | 1978-08-02 | 0 | 1979-09-28 | 0 | Z | 09 | 09 | 0 | 0 | 0 | 0 | 01 | 125 | 1 | 3 | ||||||||||
| 01-CA-013425-001 | 1970-10-10 | 1979-08-02 | E | 4 | 1979-08-02 | 1979-09-28 | 0 | 0 | 09 | 09 | 0 | 0 | 0 | 0 | 01 | 125 | 1 | 3 | |||||||||||
| 01-CA-013486-001 | 1970-10-10 | 1979-08-02 | E | 4 | 1979-08-02 | 0 | 1979-09-28 | 0 | Z | 09 | 09 | 0 | 0 | 0 | 0 | 01 | 125 | 1 | 3 | ||||||||||
| 01-CA-013882-001 | 1970-10-10 | 1979-01-02 | A | 5 | 1979-01-02 | 0 | 1980-07-17 | 0 | 2 | 25 | 41 | 5 | 0 | 8 | 0 | 3 | 0 | 17 | 123 | 1 | 3 | ||||||||
| 01-CA-014050-001 | 1970-10-10 | 5 | E | 4 | 0 | 1980-05-27 | 0 | 2 | 45 | 01 | 37 | 0 | 0 | 0 | 0 | 17 | 123 | 1 | 3 | ||||||||||
| 01-CA-014085-001 | 1970-10-10 | 1979-07-07 | 5 | A | 4 | 1979-07-07 | 0 | 1980-05-27 | 0 | 2 | 45 | 01 | 37 | 0 | 0 | 0 | 17 | 123 | 1 | 3 | |||||||||
| 01-CA-014086-001 | 1970-10-10 | 1979-07-07 | 5 | E | 4 | 1979-07-07 | 0 | 1980-05-27 | 0 | 1 | 45 | 00 | 42 | 0 | 2 | 40 | 0 | 0 | 01 | 123 | 1 | 3 | |||||||
| 01-CA-014273-001 | 1970-10-10 | E | 4 | 0 | 1980-05-27 | 0 | 1 | 45 | 01 | 0 | 0 | 0 | 0 | 0 | 01 | 123 | 1 | 3 | |||||||||||
| 01-CA-014274-001 | 1970-10-10 | E | 4 | 0 | 1980-05-27 | 0 | 1 | 45 | 01 | 0 | 0 | 0 | 0 | 0 | 17 | 123 | 1 | 3 | |||||||||||
| 01-CA-014347-001 | 1970-10-10 | 1979-12-15 | E | 5 | 1979-12-15 | 0 | 1980-07-17 | 0 | 2 | 25 | 41 | 0 | 0 | 0 | 17 | 123 | 1 | 1 | 3 | ||||||||||
| 01-CA-014383-001 | 1970-10-10 | 1979-12-15 | E | 5 | 1979-12-15 | 0 | 1980-07-17 | 0 | 2 | 25 | 41 | 0 | 0 | 0 | 17 | 123 | 1 | 1 | 3 | ||||||||||
| 01-CA-014443-001 | 1970-10-10 | 1979-12-15 | E | 5 | 1979-12-15 | 0 | 1980-07-17 | 0 | 2 | 25 | 41 | 0 | 0 | 0 | 17 | 123 | 1 | 1 | 3 | ||||||||||
| 01-CA-014495-001 | 1970-10-10 | 1979-06-28 | A | 5 | 1979-06-28 | 0 | 1980-02-21 | 0 | 2 | 09 | 01 | 3 | 0 | 0 | 0 | 0 | 0 | 01 | 246 | 2 | 1 | 3 | |||||||
| 01-CA-014495-002 | 1970-10-10 | 1979-06-28 | E | 4 | 1979-06-28 | 0 | 1980-02-21 | 0 | 2 | 09 | 01 | 0 | 0 | 0 | 0 | 0 | 00 | 246 | 2 | 3 | |||||||||
| 01-CA-014526-001 | 1970-10-10 | 1979-06-28 | E | 5 | 1979-06-28 | 0 | 1980-02-21 | 0 | 2 | 09 | 01 | 0 | 0 | 0 | 0 | 0 | 0 | 01 | 246 | 2 | 1 | 3 | |||||||
| 01-CA-014600-001 | 1970-10-10 | E | 4 | 0 | 1980-05-27 | 0 | 2 | 45 | 01 | 0 | 0 | 0 | 0 | 0 | 17 | 123 | 1 | 3 | |||||||||||
| 01-CA-014624-001 | 1970-10-10 | 1979-11-16 | 4 | 1979-11-16 | 0 | 1980-03-20 | 0 | 1 | 41 | 00 | 5 | 0 | 0 | 0 | 0 | 0 | 17 | 234 | 1 | 3 | |||||||||
| 01-CA-014728-001 | 1970-10-10 | 1979-12-15 | E | 5 | 1979-12-15 | 0 | 1980-07-17 | 0 | 2 | 25 | 41 | 0 | 0 | 0 | 17 | 123 | 1 | 1 | 3 | ||||||||||
| 01-CA-014748-001 | 1970-10-10 | 1983-08-10 | 2 | Q | 4 | 1979-07-23 | 0 | 1983-08-10 | 0 | 1 | 09 | 00 | 234 | 1 | 1 | 3 | 7 | ||||||||||||
| 01-CA-014925-001 | 1970-10-10 | 1979-12-15 | E | 5 | 1979-12-15 | 0 | 1980-07-17 | 0 | 2 | 25 | 41 | 0 | 0 | 0 | 17 | 123 | 1 | 1 | 3 | ||||||||||
| 01-CA-014998-001 | 1970-10-10 | 1979-07-18 | 5 | 1979-07-18 | 0 | 1979-09-28 | 0 | 1 | 09 | 00 | 1 | 0 | 0 | 0 | 0 | 2 | 01 | 125 | 1 | 1 | 3 | ||||||||
| 01-CA-015206-001 | 1970-10-10 | 1982-03-18 | 1 | A | 4 | 1980-10-07 | 0 | 1982-03-18 | 0 | 1 | 25 | 00 | 2 | 3 | 7 | 0000 | |||||||||||||
| 01-CA-015489-001 | 1970-10-10 | 1980-10-07 | 1 | E | 2 | 1980-10-07 | 0 | 3 | |||||||||||||||||||||
| 01-CA-015560-001 | 1970-10-10 | 1982-11-08 | 5 | 1980-10-15 | 0 | 1982-09-30 | 0 | 1 | 33 | 00 | 2 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-015846-001 | 1985-05-01 | 1987-09-15 | 5 | 0 | 1985-05-01 | 0 | 1985-11-15 | 0 | 1 | 09 | 00 | 2 | 1 | 3 | 7 | ||||||||||||||
| 01-CA-015902-001 | 1985-05-01 | 1987-09-15 | 5 | 0 | 1985-05-01 | 0 | 1985-11-15 | 0 | 1 | 09 | 00 | 1 | 1 | 3 | 7 | ||||||||||||||
| 01-CA-015904-001 | 1970-10-10 | 1979-05-23 | 4 | 1979-05-23 | 0 | 1979-07-31 | 0 | 1 | 33 | 00 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 145 | 3 | ||||||||||
| 01-CA-016026-001 | 1985-05-01 | 1987-09-15 | 5 | 0 | 1985-05-01 | 0 | 1985-11-15 | 0 | 1 | 09 | 00 | 2 | 1 | 3 | 7 | ||||||||||||||
| 01-CA-016082-001 | 1981-12-08 | 1981-12-08 | 1 | A | 4 | 5 | 0 | 1981-12-08 | 0 | 2 | 01 | 16 | 0 | 1 | 3 | 7 | |||||||||||||
| 01-CA-016142-001 | 1970-10-10 | 1982-07-16 | 5 | 1981-03-09 | 0 | 1982-06-29 | 0 | 1 | 41 | 00 | 1 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-016163-001 | 1970-10-10 | 1980-10-07 | 1 | E | 2 | 1980-10-07 | 0 | 3 | |||||||||||||||||||||
| 01-CA-016322-001 | 1985-05-01 | 1987-09-15 | 1 | E | 5 | 0 | 1985-05-01 | 0 | 1985-11-15 | 0 | 1 | 25 | 00 | 2 | 1 | 3 | 7 | ||||||||||||
| 01-CA-016322-002 | 1985-05-01 | 1987-09-15 | 5 | 0 | 1985-05-01 | 0 | 1985-11-15 | 0 | 1 | 09 | 00 | 2 | 1 | 3 | 7 | ||||||||||||||
| 01-CA-016532-001 | 1981-12-30 | 1981-12-30 | 2 | 1 | 1981-12-30 | 0 | 3 | ||||||||||||||||||||||
| 01-CA-016548-001 | 1970-10-10 | 1980-10-06 | 1 | A | 4 | 1980-10-06 | 0 | 1981-04-09 | 0 | 3 | |||||||||||||||||||
| 01-CA-016694-001 | 1970-10-10 | 1982-03-02 | A | 4 | 1980-08-18 | 0 | 1982-03-02 | 0 | 1 | 57 | 00 | 2 | 3 | 7 | 0000 | ||||||||||||||
| 01-CA-016917-001 | 1970-10-10 | 1980-10-06 | 1 | E | 2 | 1980-10-06 | 0 | 3 | |||||||||||||||||||||
| 01-CA-017038-001 | 1970-10-10 | 1980-08-18 | E | 2 | 1980-08-18 | 0 | 3 | ||||||||||||||||||||||
| 01-CA-017113-001 | 1970-10-10 | 1981-02-27 | 4 | 1981-02-27 | 0 | 1981-09-14 | 0 | 3 | |||||||||||||||||||||
| 01-CA-017255-001 | 1987-08-21 | 1987-08-21 | 4 | 5 | 1981-07-28 | 0 | 1987-08-21 | 0 | 1 | 09 | 00 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-017298-001 | 1970-10-10 | 1980-05-30 | 5 | 1980-05-30 | 0 | 1980-08-25 | 0 | 1 | 33 | 00 | 0 | 0 | 0 | 0 | 0 | 0 | 01 | 234 | 1 | 1 | 3 | ||||||||
| 01-CA-017394-001 | 1985-05-01 | 1987-09-15 | 1 | E | 5 | 0 | 1985-05-01 | 0 | 1985-11-15 | 0 | 1 | 09 | 00 | 1 | 1 | 3 | 7 | ||||||||||||
| 01-CA-017534-001 | 1985-05-01 | 1987-09-15 | 1 | E | 5 | 0 | 1985-05-01 | 0 | 1985-11-15 | 0 | 1 | 09 | 00 | 2 | 1 | 3 | 7 | ||||||||||||
| 01-CA-017917-001 | 1981-12-11 | 1985-02-19 | 5 | 5 | 0 | 1981-12-11 | 0 | 1 | 57 | 00 | 2 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-018292-001 | 1982-07-22 | 1984-08-20 | 5 | 1 | 1982-07-22 | 0 | 1984-07-13 | 0 | 1 | 33 | 00 | 1 | 1 | 3 | 7 | ||||||||||||||
| 01-CA-018305-001 | 1985-04-29 | 1985-10-29 | E | 5 | 1 | 1985-04-29 | 0 | 1985-09-20 | 0 | 1 | 09 | 00 | 1 | 1 | 3 | 7 | |||||||||||||
| 01-CA-018362-001 | 1983-02-18 | 1984-06-18 | 4 | 1 | 1983-02-18 | 0 | 1984-06-18 | 0 | 1 | 09 | 00 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-018577-001 | 1982-09-30 | 1987-07-16 | 5 | 1 | 1982-10-04 | 0 | 1987-06-25 | 0 | 1 | 33 | 00 | 1 | 1 | 3 | 7 | ||||||||||||||
| 01-CA-018619-001 | 1982-09-04 | 1989-06-09 | 5 | 1 | 1982-10-19 | 0 | 1989-05-31 | 0 | 1 | 41 | 00 | 1 | 1 | 3 | 7 | ||||||||||||||
| 01-CA-019009-001 | 1982-08-23 | 1982-11-29 | 5 | 5 | 0 | 1982-08-23 | 0 | 1 | 33 | 00 | 1 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-019086-001 | 1982-09-09 | 1988-09-29 | 5 | 5 | 0 | 1982-09-09 | 0 | 1 | 01 | 00 | 2 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-019118-001 | 1984-09-24 | 1984-09-24 | 1 | A | 6 | 1 | 1984-09-24 | 0 | 1984-11-30 | 0 | 3 | 00 | 01 | 3 | 0 | 3 | 9 | ||||||||||||
| 01-CA-019299-001 | 1985-08-21 | 1987-01-23 | 1 | A | 5 | 1 | 1985-09-09 | 0 | 1986-09-30 | 0 | 1 | 09 | 00 | 1 | 1 | 3 | 7 | ||||||||||||
| 01-CA-019307-001 | 1982-02-04 | 1982-05-28 | 4 | 0 | 1982-02-04 | 0 | 1982-05-28 | 0 | 1 | 33 | 00 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-019537-001 | 1982-12-16 | 1983-03-29 | 5 | 5 | 0 | 1982-12-16 | 0 | 1 | 33 | 00 | 2 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-019635-001 | 1985-08-21 | 1987-01-23 | 1 | E | 5 | 1 | 1985-09-09 | 0 | 1986-09-30 | 0 | 1 | 09 | 00 | 1 | 1 | 3 | 7 | ||||||||||||
| 01-CA-019685-001 | 1983-04-21 | 1984-02-09 | 4 | 1 | 1983-04-21 | 0 | 1984-02-09 | 0 | 1 | 09 | 00 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-019743-001 | 1982-11-24 | 1983-03-09 | 5 | 5 | 0 | 1982-11-24 | 0 | 1 | 33 | 00 | 2 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-019872-001 | 1984-02-03 | 1984-07-09 | 1 | A | 4 | 1 | 1984-02-03 | 0 | 1984-07-09 | 0 | 1 | 05 | 00 | 1 | 3 | 7 | |||||||||||||
| 01-CA-019896-001 | 1984-02-03 | 1984-07-09 | 4 | 1 | 1984-02-03 | 0 | 1984-07-09 | 0 | 1 | 05 | 00 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-020013-001 | 1983-03-17 | 1983-03-17 | 2 | 1 | 1983-03-17 | 0 | 3 | ||||||||||||||||||||||
| 01-CA-020070-001 | 1983-10-19 | 1985-02-19 | 1 | J | 5 | 1 | 1983-10-19 | 0 | 1984-12-14 | 0 | 1 | 33 | 00 | 1 | 1 | 3 | 7 | ||||||||||||
| 01-CA-020072-001 | 1982-09-17 | 1985-02-22 | 4 | 0 | 1982-09-17 | 0 | 1985-02-22 | 0 | 1 | 33 | 00 | 2 | 3 | 7 | |||||||||||||||
| 01-CA-020200-001 | 1984-10-22 | 1985-06-28 | 4 | 1 | 1984-10-22 | 0 | 1985-06-28 | 0 | 1 | 09 | 00 | 2 | 3 | 7 | |||||||||||||||
| 01-CA-020237-001 | 1984-07-06 | 1987-01-30 | 5 | 1 | 1984-08-13 | 0 | 1986-06-24 | 0 | 1 | 09 | 00 | 1 | 1 | 3 | 7 | ||||||||||||||
| 01-CA-020252-001 | 1983-06-27 | 1985-03-29 | 4 | 1 | 1983-06-27 | 0 | 1985-03-29 | 0 | 1 | 09 | 00 | 1 | 3 | 7 | |||||||||||||||
| 01-CA-020283-001 | 1986-06-03 | 1997-01-09 | 1 | C | 5 | 1 | 1989-07-31 | 0 | 1 | 3 | |||||||||||||||||||
| 01-CA-020291-001 | 1986-06-03 | 1997-01-09 | 1 | C | 5 | 1 | 1989-07-31 | 0 | 1 | 3 | |||||||||||||||||||
| 01-CA-020298-001 | 1984-09-07 | 1984-09-07 | 1 | A | 4 | 5 | 1984-02-22 | 0 | 1984-09-07 | 0 | 1 | 05 | 00 | 1 | 3 | 7 | |||||||||||||
| 01-CA-020304-001 | 1986-06-03 | 1997-01-09 | 1 | C | 5 | 1 | 1989-07-31 | 0 | 1 | 3 | |||||||||||||||||||
| 01-CA-020350-001 | 1983-10-19 | 1985-02-19 | 1 | Q | 5 | 1 | 1983-10-19 | 0 | 1984-12-14 | 0 | 1 | 33 | 00 | 1 | 1 | 3 | 7 | ||||||||||||
| 01-CA-020359-001 | 1984-09-07 | 1984-09-07 | 1 | E | 4 | 5 | 1984-02-22 | 0 | 1984-09-07 | 0 | 1 | 05 | 00 | 1 | 3 | 7 | |||||||||||||
| 01-CA-020404-001 | 1984-05-29 | 1984-05-29 | 4 | 4 | 1984-05-29 | 2 | 1984-05-29 | 2 | 1 | 09 | 00 | 1 | 0 | 3 | 1 | E | |||||||||||||
| 01-CA-020407-001 | 1985-03-29 | 1985-03-29 | 1 | N | 4 | 5 | 0 | 1985-03-29 | 0 | 1 | 09 | 00 | 2 | 3 | 7 | ||||||||||||||
| 01-CA-020459-001 | 1983-10-07 | 1983-10-07 | 1 | J | 2 | 1 | 1983-10-07 | 0 | 3 | ||||||||||||||||||||
| 01-CA-020508-001 | 1986-06-03 | 1997-01-09 | 1 | C | 5 | 1 | 1989-07-31 | 0 | 1 | 3 | |||||||||||||||||||
| 01-CA-020524-001 | 1984-08-24 | 1984-08-24 | 4 | 5 | 0 | 1984-08-24 | 0 | 1 | 33 | 00 | 2 | 3 | 7 |
Table schema
CREATE TABLE c_formal2(case_number VARCHAR, cf2_date DATE, date_last_action DATE, consolidation_type VARCHAR, consolidation_code VARCHAR, update_control BIGINT, code_date_transfer_board BIGINT, date_transfer_board DATE, control_type BIGINT, date_decision_issued DATE, type_decision VARCHAR, disp_allegations VARCHAR, allegations_uphld VARCHAR, allegations_dismd VARCHAR, number_discrim_reinstated_ca BIGINT, number_receive_back_pay_uni_emp_cb BIGINT, number_receive_back_pay_only_ca BIGINT, number_discrim_restored_cb BIGINT, number_discrim_dismissed BIGINT, number_discrim_preferred BIGINT, remedy VARCHAR, board_members VARCHAR, board_disposition_allegations BIGINT, close_control BIGINT, card_control VARCHAR, code_date_dec_issued VARCHAR, volume_number VARCHAR, issue_number VARCHAR, party_filing_excpt VARCHAR, board_members_5 VARCHAR);