c_alj_decision

20,118 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ c_case_number action_sequence recurrence brief_due_date eot_request_rcvd_alj eot_brief_party eot_deter_date eot_determination alj_date_filed alj_brief_rcvd_region alj_brief_party alj_brief_type determination_date determination
1 1 01-CA-19224-001 0 0                   1989-04-05T00:00:00 PartM
2 2 01-CA-19567-001 0 0 1988-05-31T00:00:00         1988-08-19T00:00:00   GC Initl 1989-04-05T00:00:00 PartM
3 3 01-CA-19690-001 0 0 1988-05-31T00:00:00         1988-08-19T00:00:00   GC Initl 1989-04-05T00:00:00 PartM
4 4 01-CA-19731-001 0 0 1983-04-11T00:00:00                 1983-06-30T00:00:00 FullM
5 5 01-CA-19797-001 0 0 1983-04-11T00:00:00                 1983-06-30T00:00:00 FullM
6 6 01-CA-19903-001 0 0 1983-04-11T00:00:00                 1983-06-30T00:00:00 FullM
7 7 01-CA-19958-001 0 0 1988-05-31T00:00:00         1988-08-19T00:00:00   GC Initl 1989-04-05T00:00:00 PartM
8 8 01-CA-20007-001 0 0 1983-04-11T00:00:00                 1983-06-30T00:00:00 FullM
9 9 01-CA-20157-001 0 0 1983-04-11T00:00:00                 1983-06-30T00:00:00 FullM
10 10 01-CA-20218-001 0 0 1983-04-11T00:00:00                 1983-06-30T00:00:00 FullM
11 11 01-CA-20283-001 0 0 1988-05-31T00:00:00         1988-08-19T00:00:00   GC Initl 1989-04-05T00:00:00 PartM
12 12 01-CA-20291-001 0 0 1988-05-31T00:00:00         1988-08-19T00:00:00   GC Initl 1989-04-05T00:00:00 PartM
13 13 01-CA-20304-001 0 0 1988-05-31T00:00:00         1988-08-19T00:00:00   GC Initl 1989-04-05T00:00:00 PartM
14 14 01-CA-20442-001 0 0 1983-04-11T00:00:00                 1983-06-30T00:00:00 FullM
15 15 01-CA-20508-001 0 0 1988-05-31T00:00:00         1988-08-19T00:00:00   GC Initl 1989-04-05T00:00:00 PartM
16 16 01-CA-20521-001 0 0 1983-04-11T00:00:00                 1983-06-30T00:00:00 FullM
17 17 01-CA-21438-001 0 0 1983-04-11T00:00:00                 1983-06-30T00:00:00 FullM
18 18 01-CA-21560-001 0 0 1988-05-31T00:00:00         1988-08-19T00:00:00   GC Initl 1989-04-05T00:00:00 PartM
19 19 01-CA-22687-001 0 0                   1996-06-06T00:00:00 FullM
20 20 01-CA-22769-001 0 0                   1996-06-06T00:00:00 FullM
21 21 01-CA-22869-001 0 0                   1996-06-06T00:00:00 FullM
22 22 01-CA-23427-001 0 0 1989-02-13T00:00:00                 1989-03-22T00:00:00 FullM
23 23 01-CA-23576-001 0 0                   1996-06-06T00:00:00 FullM
24 24 01-CA-24372-001 0 0                   1987-07-10T00:00:00 FullM
25 25 01-CA-24863-001 0 0 1988-07-15T00:00:00                    
26 26 01-CA-24883-001 0 0 1988-07-15T00:00:00                    
27 27 01-CA-25521-001 0 0 1991-07-30T00:00:00         1991-07-29T00:00:00   GC Initl 1991-10-11T00:00:00 Dismi
28 28 01-CA-25599-001 0 0                   1996-06-06T00:00:00 FullM
29 29 01-CA-25656-001 0 0                   1990-04-25T00:00:00 FullM
30 30 01-CA-25736-001 0 0                   1989-03-01T00:00:00 FullM
31 31 01-CA-25805-001 0 0                   1996-06-06T00:00:00 FullM
32 32 01-CA-25864-001 0 0 1991-07-30T00:00:00         1991-07-29T00:00:00   GC Initl 1991-10-11T00:00:00 Dismi
33 33 01-CA-25896-001 0 0                   1996-06-06T00:00:00 FullM
34 34 01-CA-25940-001 0 0 1990-04-26T00:00:00         1990-04-25T00:00:00   GC Initl 1991-06-18T00:00:00 FullM
35 35 01-CA-25969-001 0 0 1989-10-30T00:00:00                 1989-11-24T00:00:00 FullM
36 36 01-CA-26144-001 0 0                   1990-04-25T00:00:00 FullM
37 37 01-CA-26463-001 0 0 1990-07-06T00:00:00         1990-07-05T00:00:00   GC Initl 1991-04-08T00:00:00 FullM
38 38 01-CA-26463-001 1 0                   1994-05-19T00:00:00 FullM
39 39 01-CA-26463-002 0 0 1990-07-06T00:00:00         1990-07-05T00:00:00   GC Initl 1991-04-08T00:00:00 FullM
40 40 01-CA-26463-002 1 0                   1994-05-19T00:00:00 Dismi
41 41 01-CA-26463-003 0 0 1990-07-06T00:00:00                 1991-04-08T00:00:00 Dismi
42 42 01-CA-26463-003 1 0                   1994-05-19T00:00:00 Dismi
43 43 01-CA-26463-004 0 0 1990-05-21T00:00:00                 1991-04-08T00:00:00 Dismi
44 44 01-CA-26463-005 0 0 1990-07-06T00:00:00                 1994-05-19T00:00:00 Dismi
45 45 01-CA-26463-005 1 0                   1994-05-19T00:00:00 Dismi
46 46 01-CA-26463-006 0 0 1990-07-06T00:00:00                 1991-05-28T00:00:00 Dismi
47 47 01-CA-26573-001 0 0 1990-07-19T00:00:00         1990-11-02T00:00:00 1990-11-02T00:00:00 GC Initl 1991-03-29T00:00:00 FullM
48 48 01-CA-26744-001 0 0 1990-08-06T00:00:00         1990-08-02T00:00:00   GC Initl 1993-02-16T00:00:00 PartM
49 49 01-CA-26820-001 0 0 1991-12-13T00:00:00         1991-12-12T00:00:00 1991-12-12T00:00:00 GC Initl 1992-06-03T00:00:00 Dismi
50 50 01-CA-27014-001 0 0                   1990-08-03T00:00:00 FullM
51 51 01-CA-27070-001 0 0 1990-07-19T00:00:00         1990-11-02T00:00:00 1990-11-02T00:00:00 GC Initl 1991-03-29T00:00:00 FullM
52 52 01-CA-27322-001 0 0                   1991-10-09T00:00:00 FullM
53 53 01-CA-27322-001 1 0                   1991-11-18T00:00:00 FullM
54 54 01-CA-27385-001 0 0                   1991-10-09T00:00:00 FullM
55 55 01-CA-27385-001 1 0                   1991-11-18T00:00:00 FullM
56 56 01-CA-27386-001 0 0                   1991-10-09T00:00:00 FullM
57 57 01-CA-27386-001 1 0                   1991-11-18T00:00:00 FullM
58 58 01-CA-27800-001 0 0 1994-01-17T00:00:00                 1994-05-05T00:00:00 FullM
59 59 01-CA-27953-001 0 0                   1991-10-09T00:00:00 FullM
60 60 01-CA-27953-001 1 0                   1991-11-18T00:00:00 FullM
61 61 01-CA-28315-001 0 0                   1993-02-22T00:00:00 FullM
62 62 01-CA-28375-001 0 0 1992-12-18T00:00:00         1992-12-17T00:00:00 1992-12-17T00:00:00 GC Initl 1993-03-24T00:00:00 FullM
63 63 01-CA-28375-001 0 1           1992-12-17T00:00:00   CHP Initl    
64 64 01-CA-28409-001 0 0                   1993-02-22T00:00:00 FullM
65 65 01-CA-28418-001 0 0 1992-07-20T00:00:00         1992-09-24T00:00:00 1992-09-24T00:00:00 GC Initl 1992-12-01T00:00:00 FullM
66 66 01-CA-28590-001 0 0 1992-07-20T00:00:00         1992-09-24T00:00:00 1992-09-24T00:00:00 GC Initl 1992-12-01T00:00:00 FullM
67 67 01-CA-29051-001 0 0 1992-12-18T00:00:00         1992-12-17T00:00:00 1992-12-17T00:00:00 GC Initl 1993-03-24T00:00:00 FullM
68 68 01-CA-29051-001 0 1           1992-12-17T00:00:00 1992-12-17T00:00:00 CHP Initl    
69 69 01-CA-29179-001 0 0 1993-05-27T00:00:00         1993-05-25T00:00:00   GC Initl 1994-01-11T00:00:00 FullM
70 70 01-CA-29224-001 0 0 1993-05-27T00:00:00         1993-05-25T00:00:00   GC Initl 1994-01-11T00:00:00 FullM
71 71 01-CA-29414-001 0 0                   1994-01-11T00:00:00 FullM
72 72 01-CA-29433-001 0 0 1993-05-20T00:00:00         1993-05-19T00:00:00 1993-05-19T00:00:00 GC Initl 1993-11-22T00:00:00 PartM
73 73 01-CA-29434-001 0 0 1993-05-20T00:00:00         1993-05-19T00:00:00 1993-05-19T00:00:00 GC Initl 1993-11-22T00:00:00 PartM
74 74 01-CA-29621-001 0 0 1993-12-09T00:00:00         1993-12-09T00:00:00 1993-12-09T00:00:00 GC Initl 1994-06-30T00:00:00 Dismi
75 75 01-CA-29621-001 0 1           1993-12-09T00:00:00 1993-12-13T00:00:00 CHP Initl    
76 76 01-CA-29740-001 0 0 1993-12-09T00:00:00         1993-12-09T00:00:00 1993-12-09T00:00:00 GC Initl 1994-06-30T00:00:00 Dismi
77 77 01-CA-29740-001 0 1           1993-12-09T00:00:00 1993-12-13T00:00:00 CHP Initl    
78 78 01-CA-29743-001 0 0 1993-10-01T00:00:00         1993-12-02T00:00:00 1993-12-02T00:00:00 GC Initl 1994-02-04T00:00:00 PartM
79 79 01-CA-29743-001 0 1           1993-12-06T00:00:00 1993-12-08T00:00:00 CHP Initl    
80 80 01-CA-29751-001 0 0 1993-09-03T00:00:00         1993-11-22T00:00:00 1993-11-22T00:00:00 GC Initl 1994-12-08T00:00:00 Other
81 81 01-CA-29796-001 0 0 1993-11-19T00:00:00         1993-11-22T00:00:00 1993-11-22T00:00:00 GC Initl 1994-12-08T00:00:00 Other
82 82 01-CA-29844-001 0 0 1993-08-02T00:00:00         1993-07-29T00:00:00   GC Initl 1993-09-08T00:00:00 FullM
83 83 01-CA-29966-001 0 0 1995-07-28T00:00:00                 1996-06-14T00:00:00 FullM
84 84 01-CA-29985-001 0 0 1993-11-22T00:00:00         1993-12-09T00:00:00 1993-12-09T00:00:00 GC Initl 1993-12-30T00:00:00 FullM
85 85 01-CA-30044-001 0 0 1993-08-02T00:00:00         1993-07-29T00:00:00   GC Initl 1993-09-08T00:00:00 FullM
86 86 01-CA-30236-001 0 0 1993-11-22T00:00:00         1993-12-09T00:00:00 1993-12-09T00:00:00 GC Initl 1993-12-30T00:00:00 FullM
87 87 01-CA-30297-001 0 0 1993-12-09T00:00:00         1993-12-09T00:00:00 1993-12-09T00:00:00 GC Initl 1994-06-30T00:00:00 Dismi
88 88 01-CA-30297-001 0 1           1993-12-09T00:00:00 1993-12-13T00:00:00 CHP Initl    
89 89 01-CA-30428-001 0 0 1993-12-09T00:00:00         1993-12-09T00:00:00 1993-12-09T00:00:00 GC Initl 1994-06-30T00:00:00 Dismi
90 90 01-CA-30428-001 0 1           1993-12-09T00:00:00 1993-12-13T00:00:00 CHP Initl    
91 91 01-CA-30434-001 0 0 1996-11-07T00:00:00         1996-12-09T00:00:00 1996-12-09T00:00:00 GC Initl 1997-03-07T00:00:00 Dismi
92 92 01-CA-30434-001 0 1           1996-12-10T00:00:00 1996-12-11T00:00:00 CHP Initl    
93 93 01-CA-30470-001 0 0 1994-06-20T00:00:00         1994-06-17T00:00:00 1994-06-17T00:00:00 GC Initl 1995-07-31T00:00:00 FullM
94 94 01-CA-30470-001 0 1           1994-06-20T00:00:00 1994-06-20T00:00:00 CHP Initl    
95 95 01-CA-30745-001 0 0 1997-12-05T00:00:00         1997-12-03T00:00:00   GC Initl 1998-01-26T00:00:00 Dismi
96 96 01-CA-30745-001 0 1           1997-12-04T00:00:00 1997-12-05T00:00:00 CHP Initl    
97 97 01-CA-30745-001 0 2           1997-12-04T00:00:00 1997-12-05T00:00:00 CGP Initl    
98 98 01-CA-31010-001 0 0 1996-11-07T00:00:00         1996-12-09T00:00:00 1996-12-09T00:00:00 GC Initl 1997-03-07T00:00:00 PartM
99 99 01-CA-31010-001 0 1           1996-12-10T00:00:00 1996-12-11T00:00:00 CHP Initl    
100 100 01-CA-31148-001 0 0 1994-08-22T00:00:00         1994-09-30T00:00:00   GC Initl 1994-11-03T00:00:00 FullM

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_alj_decision" (
    "c_case_number" text,
    "action_sequence" integer,
    "recurrence" integer,
    "brief_due_date" text,
    "eot_request_rcvd_alj" text,
    "eot_brief_party" text,
    "eot_deter_date" text,
    "eot_determination" text,
    "alj_date_filed" text,
    "alj_brief_rcvd_region" text,
    "alj_brief_party" text,
    "alj_brief_type" text,
    "determination_date" text,
    "determination" text
);