c_formal2

13,812 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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
1 1 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          
2 2 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          
3 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          
4 4 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          
5 5 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          
6 6 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        
7 7 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          
8 8 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          
9 9 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          
10 10 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    
11 11 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          
12 12 01-CA-012137-001 1970-10-10 1978-11-02 1 E 1   1978-11-02 6                               3          
13 13 01-CA-012264-001 1970-10-10 1978-05-15 1 A 2   1978-05-15 0                               3          
14 14 01-CA-012370-001 1970-10-10 1978-05-01 1 E 2   1978-05-01 0                               3          
15 15 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          
16 16 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        
17 17 01-CA-012958-001 1982-11-01 1984-12-06     5 1 1982-11-01 0                             1 3          
18 18 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        
19 19 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        
20 20 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        
21 21 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          
22 22 01-CA-013208-001 1970-10-10 1982-09-28     4     0 1982-09-28 0 1 41 00                 2   3 7        
23 23 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          
24 24 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          
25 25 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          
26 26 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          
27 27 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          
28 28 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          
29 29 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          
30 30 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          
31 31 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          
32 32 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          
33 33 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          
34 34 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          
35 35 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          
36 36 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          
37 37 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          
38 38 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          
39 39 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          
40 40 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          
41 41 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          
42 42 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        
43 43 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          
44 44 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          
45 45 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    
46 46 01-CA-015489-001 1970-10-10 1980-10-07 1 E 2   1980-10-07 0                               3          
47 47 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        
48 48 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        
49 49 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        
50 50 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          
51 51 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        
52 52 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        
53 53 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        
54 54 01-CA-016163-001 1970-10-10 1980-10-07 1 E 2   1980-10-07 0                               3          
55 55 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        
56 56 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        
57 57 01-CA-016532-001 1981-12-30 1981-12-30     2 1 1981-12-30 0                               3          
58 58 01-CA-016548-001 1970-10-10 1980-10-06 1 A 4   1980-10-06 0 1981-04-09 0                           3          
59 59 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    
60 60 01-CA-016917-001 1970-10-10 1980-10-06 1 E 2   1980-10-06 0                               3          
61 61 01-CA-017038-001 1970-10-10 1980-08-18   E 2   1980-08-18 0                               3          
62 62 01-CA-017113-001 1970-10-10 1981-02-27     4   1981-02-27 0 1981-09-14 0                           3          
63 63 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        
64 64 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          
65 65 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        
66 66 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        
67 67 01-CA-017917-001 1981-12-11 1985-02-19     5 5   0 1981-12-11 0 1 57 00                 2 1 3 7        
68 68 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        
69 69 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        
70 70 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        
71 71 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        
72 72 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        
73 73 01-CA-019009-001 1982-08-23 1982-11-29     5 5   0 1982-08-23 0 1 33 00                 1 1 3 7        
74 74 01-CA-019086-001 1982-09-09 1988-09-29     5 5   0 1982-09-09 0 1 01 00                 2 1 3 7        
75 75 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        
76 76 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        
77 77 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        
78 78 01-CA-019537-001 1982-12-16 1983-03-29     5 5   0 1982-12-16 0 1 33 00                 2 1 3 7        
79 79 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        
80 80 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        
81 81 01-CA-019743-001 1982-11-24 1983-03-09     5 5   0 1982-11-24 0 1 33 00                 2 1 3 7        
82 82 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        
83 83 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        
84 84 01-CA-020013-001 1983-03-17 1983-03-17     2 1 1983-03-17 0                               3          
85 85 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        
86 86 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        
87 87 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        
88 88 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        
89 89 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        
90 90 01-CA-020283-001 1986-06-03 1997-01-09 1 C 5 1 1989-07-31 0                             1 3          
91 91 01-CA-020291-001 1986-06-03 1997-01-09 1 C 5 1 1989-07-31 0                             1 3          
92 92 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        
93 93 01-CA-020304-001 1986-06-03 1997-01-09 1 C 5 1 1989-07-31 0                             1 3          
94 94 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        
95 95 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        
96 96 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
97 97 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        
98 98 01-CA-020459-001 1983-10-07 1983-10-07 1 J 2 1 1983-10-07 0                               3          
99 99 01-CA-020508-001 1986-06-03 1997-01-09 1 C 5 1 1989-07-31 0                             1 3          
100 100 01-CA-020524-001 1984-08-24 1984-08-24     4 5   0 1984-08-24 0 1 33 00                 2   3 7        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);