c_formal3

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ case_number cf3_date date_last_action consol_type consol_code update_control date_ref_app_ct type_ref date_pet_answ_filed date_ref_pet_answ date_ca_opinion date_brief_filed type_disposition ca_no date_ca_decree type_decree control_case card_control code_date_brief_filed
1 1 01-CA-022977-001 1990-10-10 1991-07-15 1 E 3 1990-10-10 2       1991-07-15 2   1991-07-15 6   4 1
2 2 01-CA-023094-001 1988-10-06 1989-06-20     3 1988-10-06 2       1989-06-20 2         4 1
3 3 01-CA-023208-001 1987-02-20 1987-03-24     4 1987-02-20 8             1987-03-24 8   4  
4 4 01-CA-023325-001 1986-06-26 1987-04-21     4 1986-06-26 2       1986-12-22 3 1 1987-04-21     4 0
5 5 01-CA-023395-001 1990-10-10 1991-07-15 1 E 3 1990-10-10 2       1991-07-15 2   1991-07-15 6   4 1
6 6 01-CA-023472-001 1987-10-05 1987-10-05     1 1987-10-05 2                   4  
7 7 01-CA-023549-001 1987-11-27 1987-11-27 1 A 1 1987-11-27 2                   4  
8 8 01-CA-023594-001 1987-11-27 1987-11-27 1 E 1 1987-11-27 2                   4  
9 9 01-CA-023817-001 1988-02-03 1988-02-03 1 A 1 1988-02-03 2                   4  
10 10 01-CA-023839-001 1988-02-03 1988-02-03 1 E 1 1988-02-03 2                   4  
11 11 01-CA-023906-001 1987-11-27 1988-09-12 1 A 4 1987-11-27 2       1988-06-01 3 1 1988-09-12 2   4 0
12 12 01-CA-023953-001 1987-12-14 1988-07-13 1 A 4 1987-12-14 4       1988-04-14 3 3 1988-07-13 2   4 0
13 13 01-CA-023966-001 1987-12-14 1988-07-13 1 E 4 1987-12-14 4       1988-04-14 3 3 1988-07-13 2   4 0
14 14 01-CA-023967-001 1988-01-07 1988-01-07     1 1988-01-07 2                   4  
15 15 01-CA-023980-001 1988-01-07 1988-01-07     1 1988-01-07 2                   4  
16 16 01-CA-023996-001 1988-02-03 1988-02-03 1 E 1 1988-02-03 2                   4  
17 17 01-CA-024152-001 1987-12-14 1988-07-13 1 E 4 1987-12-14 4       1988-04-14 3 3 1988-07-13 2   4 0
18 18 01-CA-024178-001 1987-11-27 1988-09-12 1 E 4 1987-11-27 2       1988-06-01 3 1 1988-09-12 2   4 0
19 19 01-CA-024311-001 1987-07-17 1987-09-30     4 1987-07-17 8             1987-09-30     4  
20 20 01-CA-024421-001 1988-05-06 1990-07-31     3 1988-05-06 2       1990-07-31 2         4 1
21 21 01-CA-024543-001 1988-09-23 1989-09-22 1 J 4 1988-09-23 2       1989-01-19 3 1 1989-09-22 5   4 0
22 22 01-CA-024571-001 1988-01-14 1988-11-08     4 1988-01-14 2       1988-08-05 3 1 1988-11-08 2   4 0
23 23 01-CA-024705-001 1989-10-04 1989-12-01     3 1989-10-04 2       1989-12-01 2         4 1
24 24 01-CA-024958-001 1990-09-12 1991-02-28     3 1990-09-12 2       1991-02-28 2         4 1
25 25 01-CA-024992-001 1990-12-04 1991-06-12     3 1990-12-04 2       1991-06-12 2         4 1
26 26 01-CA-024992-001 1993-01-25 1993-02-24     3 1993-01-25 8       1993-02-24 2   1993-02-24 1   4 1
27 27 01-CA-025070-001 1988-11-28 1988-11-28     1 1988-11-28 2                   4  
28 28 01-CA-025192-001 1988-12-05 1988-12-05     1 1988-12-05 2                   4  
29 29 01-CA-025221-001 1995-06-05 1995-08-07     3 1995-06-05 2       1995-08-07 2         4 1
30 30 01-CA-025327-001 1989-06-20 1990-04-16     4 1989-06-20 2       1989-10-19 3   1990-04-16 2   4 0
31 31 01-CA-025375-001 1991-03-14 1991-10-15     3 1991-03-14 1       1991-10-15 2   1991-10-15 8   4 1
32 32 01-CA-025405-001 1989-02-03 1990-04-23     4 1989-02-03 2       1989-10-20 3   1990-04-23 2   4 0
33 33 01-CA-025698-001 1991-04-16 1992-03-19     4 1991-04-16 4       1991-11-07 3   1992-03-19 5   4 0
34 34 01-CA-025736-001 1990-09-12 1991-04-08     3 1990-09-12 1       1991-04-08 2   1991-04-08 8   4 1
35 35 01-CA-025737-001 1992-04-20 1992-08-12     3 1992-04-20 1       1992-08-12 2   1992-08-12 8   4 1
36 36 01-CA-025779-001 1989-12-27 1990-03-27     3 1989-12-27 1       1990-03-27 2   1990-03-27 8   4 1
37 37 01-CA-025940-001 1992-06-11 1993-02-22     4 1992-06-11 4       1992-08-24 3   1993-02-22 4   4 0
38 38 01-CA-025980-001 1989-09-25 1990-06-28     4 1989-09-25 4       1990-02-12 3   1990-06-28 2   4 0
39 39 01-CA-026069-001 1992-10-29 1993-11-17 1 N 4 1992-10-29 4       1993-03-22 3   1993-11-17 2   4 0
40 40 01-CA-026203-001 1989-12-06 1990-11-26     4 1989-12-06 2       1990-06-19 3   1990-11-26 2   4 0
41 41 01-CA-026214-001 1992-10-29 1993-11-17     4 1992-10-29 4       1993-03-22 3   1993-11-17 2   4 0
42 42 01-CA-026372-001 1991-05-03 1991-07-12     3 1991-05-03 2       1991-07-12 2         4 1
43 43 01-CA-026403-001 1990-01-05 1990-05-11     3 1990-01-05 1       1990-05-11 2   1990-05-11 8   4 1
44 44 01-CA-026403-001 1991-05-30 1991-12-17     3 1991-05-30 1       1991-12-17 2   1991-12-17 8   4 1
45 45 01-CA-026515-001 1990-05-16 1990-10-22     3 1990-05-16 1       1990-10-22 2   1990-10-22 8   4 1
46 46 01-CA-026641-001 1990-11-02 1991-04-24     4 1990-11-02 4       1991-01-30 3   1991-04-24 2   4 0
47 47 01-CA-026660-001 1992-08-24 1994-06-24 1 Q 6 1992-08-24 4       1993-01-13 3   1994-06-24 7 0 4 0
48 48 01-CA-026852-001 1991-05-14 1992-01-09 1 J 3 1991-05-14 1       1992-01-09 2   1992-01-09 8   4 1
49 49 01-CA-026919-001 1992-10-29 1993-11-17 1 Q 4 1992-10-29 4       1993-03-22 3   1993-11-17 2   4 0
50 50 01-CA-026936-001 1991-07-23 1992-04-23     3 1991-07-23 1       1992-04-23 2   1992-04-23 8   4 1
51 51 01-CA-026963-001 1990-12-04 1991-10-15     3 1990-12-04 1       1991-10-15 2   1991-10-15 8   4 1
52 52 01-CA-027007-001 1992-04-20 1993-06-08     3 1992-04-20 2       1993-06-08 2   1993-06-08 7   4 1
53 53 01-CA-027007-001 1993-06-28 1993-08-26     3 1993-06-28 8       1993-08-26 2   1993-08-26 1   4 1
54 54 01-CA-027051-001 1993-08-30 1993-08-30 1 J 1 1993-08-30 2                   4  
55 55 01-CA-027095-001 1991-07-23 1992-04-01     3 1991-07-23 1       1992-04-01 2   1992-04-01 8   4 1
56 56 01-CA-027142-001 1992-07-06 1992-10-09     3 1992-07-06 1       1992-10-09 2   1992-10-09 8   4 1
57 57 01-CA-027159-001 1991-05-14 1992-01-09 1 Q 3 1991-05-14 1       1992-01-09 2   1992-01-09 8   4 1
58 58 01-CA-027201-001 1991-06-07 1992-04-23     3 1991-06-07 1       1992-04-23 2   1992-04-23 8   4 1
59 59 01-CA-027207-001 1993-08-30 1993-08-30 1 Q 1 1993-08-30 2                   4  
60 60 01-CA-027321-001 1991-01-31 1991-10-30     3 1991-01-31 1       1991-10-30 2   1991-10-30 8   4 1
61 61 01-CA-027321-001 1992-07-28 1992-11-13     3 1992-07-28 1       1992-11-13 2   1992-11-13 8   4 1
62 62 01-CA-027506-001 1992-06-05 1992-11-05     3 1992-06-05 1       1992-11-05 2   1992-11-05 8   4 1
63 63 01-CA-027506-001 1995-06-30 1995-07-26     3 1995-06-30 8       1995-07-26 2   1995-07-26 1   4 1
64 64 01-CA-027619-001 1992-07-24 1993-05-17     3 1992-07-24 2       1993-05-17 2   1993-05-17 7   4 1
65 65 01-CA-027730-001 1991-07-23 1992-04-01     3 1991-07-23 1       1992-04-01 2   1992-04-01 8   4 1
66 66 01-CA-027731-001 1991-09-10 1992-05-26     3 1991-09-10 1       1992-05-26 2   1992-05-26 8   4 1
67 67 01-CA-027731-001 1993-06-28 1993-08-25     3 1993-06-28 8       1993-08-25 2   1993-08-25 1   4 1
68 68 01-CA-027784-001 1992-06-09 1992-11-15     3 1992-06-09 1       1992-11-15 2   1992-11-15 8   4 1
69 69 01-CA-027825-001 1993-06-02 1993-08-03     3 1993-06-02 1       1993-08-03 2   1993-08-03 8   4 1
70 70 01-CA-027967-001 1992-08-11 1992-11-18 1 Q 3 1992-08-11 1       1992-11-18 2   1992-11-18 8   4 1
71 71 01-CA-028046-001 1992-08-25 1992-11-16     3 1992-08-25 1       1992-11-16 2   1992-11-16 8   4 1
72 72 01-CA-028114-001 1992-10-01 1992-12-09     3 1992-10-01 1       1992-12-09 2   1992-12-09 8   4 1
73 73 01-CA-028224-001 1992-04-06 1992-09-09     3 1992-04-06 1       1992-09-09 2   1992-09-09 8   4 1
74 74 01-CA-028412-001 1992-06-05 1992-11-09     3 1992-06-05 1       1992-11-09 2   1992-11-09 8   4 1
75 75 01-CA-028424-001 1993-05-19 1993-12-17     4 1993-05-19 4       1993-08-09 3   1993-12-17 2   4 0
76 76 01-CA-028456-001 1992-02-28 1992-07-16     3 1992-02-28 2       1992-07-16 3         4 0
77 77 01-CA-028474-001 1992-06-09 1992-10-26     3 1992-06-09 1       1992-10-26 2   1992-10-26 8   4 1
78 78 01-CA-028534-001 1994-01-06 1994-06-27     4 1994-01-06 4       1994-04-06 3   1994-06-27 2   4 0
79 79 01-CA-028989-001 1992-10-13 1992-12-02     3 1992-10-13 1       1992-12-02 2   1992-12-02 8   4 1
80 80 01-CA-029075-001 1992-11-04 1993-01-25     3 1992-11-04 1       1993-01-25 2   1993-01-25 8   4 1
81 81 01-CA-029075-001 1993-09-21 1993-11-04     3 1993-09-21 1       1993-11-04 2   1993-11-04 8   4 1
82 82 01-CA-029181-001 1993-12-21 1994-03-17     3 1993-12-21 1       1994-03-17 2   1994-03-17 8   4 1
83 83 01-CA-029219-001 1992-11-09 1992-12-17     3 1992-11-09 1       1992-12-17 2   1992-12-17 8   4 1
84 84 01-CA-029367-001 1992-11-10 1993-01-07     3 1992-11-10 1       1993-01-07 2   1993-01-07 8   4 1
85 85 01-CA-029406-001 1993-07-08 1993-09-15     3 1993-07-08 1       1993-09-15 2   1993-09-15 8   4 1
86 86 01-CA-029531-001 1993-03-08 1993-05-04     3 1993-03-08 1       1993-05-04 2   1993-05-04 8   4 1
87 87 01-CA-029676-001 1993-07-27 1993-09-21     3 1993-07-27 1       1993-09-21 2   1993-09-21 8   4 1
88 88 01-CA-029701-001 1995-05-22 1996-04-26     4 1995-05-22 2       1995-12-05 3   1996-04-26 2   4 0
89 89 01-CA-029732-001 1993-03-25 1993-05-19     3 1993-03-25 1       1993-05-19 2   1993-05-19 8   4 1
90 90 01-CA-029781-001 1994-01-03 1994-06-07     3 1994-01-03 2       1994-06-07 2   1994-06-07 7   4 1
91 91 01-CA-029946-001 1995-08-09 1997-04-01 1 J 3 1995-08-09 2       1997-04-01 2         4 1
92 92 01-CA-030261-001 1993-08-31 1993-10-27     3 1993-08-31 1       1993-10-27 2   1993-10-27 8   4 1
93 93 01-CA-030290-001 1993-11-24 1994-01-21 1 J 3 1993-11-24 1       1994-01-21 2   1994-01-21 8   4 1
94 94 01-CA-030347-001 1994-03-07 1994-05-04     3 1994-03-07 1       1994-05-04 2   1994-05-04 8   4 1
95 95 01-CA-030373-001 1993-11-24 1994-01-21 1 N 3 1993-11-24 1       1994-01-21 2   1994-01-21 8   4 1
96 96 01-CA-030472-001 1994-01-27 1994-04-14 1 J 3 1994-01-27 1       1994-04-14 2   1994-04-14 8   4 1
97 97 01-CA-030539-001 1994-01-27 1994-04-28     3 1994-01-27 1       1994-04-28 2   1994-04-28 8   4 1
98 98 01-CA-030547-001 1994-02-15 1994-04-28     3 1994-02-15 1       1994-04-28 2   1994-04-28 8   4 1
99 99 01-CA-030615-001 1994-01-06 1994-10-12     4 1994-01-06 4       1994-05-19 3   1994-10-12 2   4 0
100 100 01-CA-030708-001 1994-01-27 1994-04-14 1 N 3 1994-01-27 1       1994-04-14 2   1994-04-14 8   4 1

Next page

CREATE TABLE "c_formal3" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [cf3_date] TEXT,
   [date_last_action] TEXT,
   [consol_type] TEXT,
   [consol_code] TEXT,
   [update_control] TEXT,
   [date_ref_app_ct] TEXT,
   [type_ref] TEXT,
   [date_pet_answ_filed] TEXT,
   [date_ref_pet_answ] TEXT,
   [date_ca_opinion] TEXT,
   [date_brief_filed] TEXT,
   [type_disposition] TEXT,
   [ca_no] TEXT,
   [date_ca_decree] TEXT,
   [type_decree] TEXT,
   [control_case] TEXT,
   [card_control] TEXT,
   [code_date_brief_filed] INTEGER
);