c_sup_aljd_cmp

726 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_brief_deter_date eot_brief_determination alj_brief_rcvd_region alj_brief_party eot_brief_type alj_brief_rcvd_alj alj_date_filed aljd_comp_date aljd_comp_determination
1 1 01-CA-22687-001 0 0                     1996-06-06T00:00:00  
2 2 01-CA-22769-001 0 0                     1996-06-06T00:00:00  
3 3 01-CA-22869-001 0 0                     1996-06-06T00:00:00  
4 4 01-CA-23576-001 0 0                     1996-06-06T00:00:00  
5 5 01-CA-25599-001 0 0                     1996-06-06T00:00:00  
6 6 01-CA-25736-001 0 0                     1989-03-01T00:00:00 1
7 7 01-CA-25805-001 0 0                     1996-06-06T00:00:00  
8 8 01-CA-25896-001 0 0                     1996-06-06T00:00:00  
9 9 01-CA-25969-001 0 0                     1998-02-17T00:00:00 1
10 10 01-CA-27908-001 0 0 1994-08-24T00:00:00         1994-08-24T00:00:00 GC   1994-08-24T00:00:00 1994-08-23T00:00:00 1994-09-16T00:00:00 1
11 11 01-CA-29179-001 0 0                     1994-01-11T00:00:00  
12 12 01-CA-29433-001 0 0                     2001-08-08T00:00:00 1
13 13 01-CA-29434-001 0 0                     2001-08-08T00:00:00 1
14 14 01-CA-31148-001 0 0 2005-06-03T00:00:00 2005-05-20T00:00:00 GC 2005-06-17T00:00:00 Grant   GC     2005-06-16T00:00:00 2005-06-29T00:00:00 1
15 15 01-CA-31148-001 0 1             CHP     2005-06-15T00:00:00    
16 16 01-CA-31158-001 0 0 2005-06-03T00:00:00 2005-05-20T00:00:00 GC 2005-06-17T00:00:00 Grant   GC     2005-06-16T00:00:00 2005-06-29T00:00:00 1
17 17 01-CA-31158-001 0 1             CHP     2005-06-15T00:00:00    
18 18 01-CA-33353-001 0 0 2003-08-19T00:00:00           GC     2003-09-11T00:00:00 2003-10-29T00:00:00 5
19 19 01-CA-33353-001 0 1             CHP     2003-09-11T00:00:00    
20 20 01-CA-33353-001 1 0                     2004-03-30T00:00:00 1
21 21 01-CA-33762-001 0 0 2003-08-19T00:00:00           GC     2003-09-11T00:00:00 2003-10-29T00:00:00 5
22 22 01-CA-33762-001 0 1             CHP     2003-09-11T00:00:00    
23 23 01-CA-33762-001 1 0                     2004-03-30T00:00:00 1
24 24 01-CA-33956-001 0 0 2003-08-19T00:00:00           GC     2003-09-11T00:00:00 2003-10-29T00:00:00 5
25 25 01-CA-33956-001 0 1             CHP     2003-09-11T00:00:00    
26 26 01-CA-33956-001 1 0                     2004-03-30T00:00:00 1
27 27 01-CA-34066-001 0 0 2003-08-19T00:00:00           GC     2003-09-11T00:00:00 2003-10-29T00:00:00 5
28 28 01-CA-34066-001 0 1             CHP     2003-09-11T00:00:00    
29 29 01-CA-34066-001 1 0                     2004-03-30T00:00:00 1
30 30 01-CA-36229-001 0 0                     1998-12-29T00:00:00  
31 31 01-CA-43892-001 0 0 2010-02-17T00:00:00 2010-01-26T00:00:00 GC 2010-03-31T00:00:00 Grant   GC     2010-03-30T00:00:00 2010-06-04T00:00:00 1
32 32 01-CA-43892-001 0 1             CHP     2010-03-31T00:00:00    
33 33 02-CA-17769-001 0 0 1994-06-14T00:00:00         1994-06-14T00:00:00 GC   1994-06-14T00:00:00 1994-06-14T00:00:00 1997-06-10T00:00:00 2
34 34 02-CA-21761-001 0 0                     1990-07-27T00:00:00 1
35 35 02-CA-21917-001 0 0                     1990-07-27T00:00:00 1
36 36 02-CA-21931-001 0 0                     1990-07-27T00:00:00 1
37 37 02-CA-25886-001 0 0 1999-07-30T00:00:00         1999-08-03T00:00:00 CGP   1999-08-03T00:00:00 1999-07-30T00:00:00 1999-11-15T00:00:00 1
38 38 02-CA-26131-001 0 0 1999-07-30T00:00:00         1999-08-03T00:00:00 CGP   1999-08-03T00:00:00 1999-08-03T00:00:00 1999-11-15T00:00:00 1
39 39 02-CA-26152-001 0 0 1999-07-30T00:00:00         1999-08-03T00:00:00 CGP   1999-08-03T00:00:00 1999-07-30T00:00:00 1999-11-05T00:00:00 1
40 40 02-CA-26386-001 1 0 1999-08-03T00:00:00         1999-08-03T00:00:00 CGP   1999-08-03T00:00:00 1999-08-03T00:00:00 1999-11-15T00:00:00 1
41 41 02-CA-26390-001 1 0                     1999-11-15T00:00:00 1
42 42 02-CA-26409-001 1 0                     1999-11-15T00:00:00 1
43 43 02-CA-26844-001 0 0 1999-04-22T00:00:00                   1999-06-03T00:00:00 1
44 44 02-CA-28129-001 0 0                     1999-10-06T00:00:00 1
45 45 02-CA-28129-001 1 0                     2000-08-22T00:00:00 2
46 46 02-CA-29306-001 0 0 2001-06-22T00:00:00                   2001-06-22T00:00:00 5
47 47 02-CA-29311-001 0 0 1999-07-12T00:00:00                   1997-08-29T00:00:00 5
48 48 02-CA-29311-001 1 0                     1999-11-10T00:00:00 2
49 49 02-CA-30569-001 0 0 2000-08-16T00:00:00         2000-09-19T00:00:00 GC   2000-09-20T00:00:00 2000-09-19T00:00:00 2000-12-29T00:00:00 4
50 50 02-CA-30701-001 0 0                     1999-09-29T00:00:00 5
51 51 02-CA-30788-001 0 0                     2000-02-16T00:00:00 1
52 52 02-CA-30862-001 0 0                     2000-02-16T00:00:00 1
53 53 02-CA-30905-001 0 0                     2000-02-16T00:00:00 1
54 54 02-CA-30986-001 0 0                     2000-02-16T00:00:00 1
55 55 02-CA-31011-001 0 0 2000-08-16T00:00:00         2000-09-19T00:00:00 GC   2000-09-20T00:00:00 2000-09-19T00:00:00 2000-12-29T00:00:00 4
56 56 02-CA-31025-001 0 0                     2000-02-16T00:00:00 1
57 57 02-CA-31170-001 0 0                     2000-02-16T00:00:00 1
58 58 02-CA-31494-001 0 0 2003-12-19T00:00:00 2003-12-12T00:00:00 GC 2003-12-15T00:00:00 Grant 2004-01-30T00:00:00 CHP   2004-01-30T00:00:00 2004-01-29T00:00:00 2004-05-21T00:00:00 1
59 59 02-CA-31504-001 0 0 2005-01-06T00:00:00 2005-01-04T00:00:00 CHP 2005-01-05T00:00:00 Grant 2005-02-10T00:00:00 GC   2005-02-11T00:00:00 2005-02-10T00:00:00 2005-03-08T00:00:00 1
60 60 02-CA-31771-001 0 0                     1999-07-20T00:00:00 5
61 61 02-CA-32559-001 0 0 2010-07-26T00:00:00 2010-07-12T00:00:00 GC 2010-07-14T00:00:00 Grant 2010-08-06T00:00:00 GC   2010-08-06T00:00:00 2010-08-06T00:00:00 2010-09-07T00:00:00 1
62 62 02-CA-32559-001 0 1           2010-08-09T00:00:00 CHP   2010-08-09T00:00:00 2010-08-06T00:00:00    
63 63 02-CA-32778-001 0 0 2010-07-26T00:00:00 2010-07-12T00:00:00 GC 2010-07-14T00:00:00 Grant 2010-08-06T00:00:00 GC   2010-08-06T00:00:00 2010-08-06T00:00:00 2010-09-07T00:00:00 1
64 64 02-CA-32778-001 0 1           2010-08-09T00:00:00 CHP   2010-08-09T00:00:00 2010-08-06T00:00:00    
65 65 02-CA-32811-001 0 0 2005-04-01T00:00:00 2005-03-28T00:00:00 GC 2005-03-28T00:00:00 Grant 2005-04-15T00:00:00 GC   2005-04-15T00:00:00 2005-04-15T00:00:00 2005-05-10T00:00:00 1
66 66 02-CA-32941-001 0 0 2010-07-26T00:00:00 2010-07-12T00:00:00 GC 2010-07-14T00:00:00 Grant 2010-08-06T00:00:00 GC   2010-08-06T00:00:00 2010-08-06T00:00:00 2010-09-07T00:00:00 1
67 67 02-CA-32941-001 0 1           2010-08-09T00:00:00 CHP   2010-08-09T00:00:00 2010-08-06T00:00:00    
68 68 02-CA-33144-001 0 0 2010-07-26T00:00:00 2010-07-12T00:00:00 GC 2010-07-14T00:00:00 Grant 2010-08-06T00:00:00 GC   2010-08-06T00:00:00 2010-08-06T00:00:00 2010-09-07T00:00:00 1
69 69 02-CA-33144-001 0 1           2010-08-09T00:00:00 CHP   2010-08-09T00:00:00 2010-08-06T00:00:00    
70 70 02-CA-33267-001 0 0 2010-07-26T00:00:00 2010-07-12T00:00:00 GC 2010-07-14T00:00:00 Grant 2010-08-06T00:00:00 GC   2010-08-06T00:00:00 2010-08-06T00:00:00 2010-09-07T00:00:00 1
71 71 02-CA-33267-001 0 1           2010-08-09T00:00:00 CHP   2010-08-09T00:00:00 2010-08-06T00:00:00    
72 72 02-CA-33316-001 0 0 2004-03-01T00:00:00 2004-02-10T00:00:00 GC 2004-02-11T00:00:00 Grant 2004-03-29T00:00:00 GC   2004-03-30T00:00:00 2004-03-29T00:00:00 2004-04-13T00:00:00 1
73 73 02-CA-34613-001 0 0 2006-04-06T00:00:00                   2007-03-12T00:00:00 5
74 74 02-CA-35054-001 0 0 2004-08-12T00:00:00 2004-08-04T00:00:00 CHP 2004-08-04T00:00:00 Grant 2004-08-26T00:00:00 GC   2004-08-27T00:00:00 2004-08-26T00:00:00 2004-09-10T00:00:00 1
75 75 02-CA-35306-001 0 0 2006-04-06T00:00:00                   2007-03-12T00:00:00 5
76 76 02-CA-35495-001 0 0 2006-04-06T00:00:00                   2007-03-12T00:00:00 5
77 77 02-CA-35621-001 0 0 2006-04-06T00:00:00                   2007-03-12T00:00:00 5
78 78 02-CA-37967-001 0 0 2009-05-12T00:00:00 2009-05-08T00:00:00 CHP 2009-05-08T00:00:00 Grant 2009-05-26T00:00:00 CHP   2009-05-26T00:00:00 2009-05-26T00:00:00 2009-11-18T00:00:00 1
79 79 02-CA-37967-001 0 1           2009-05-26T00:00:00 GC   2009-05-26T00:00:00 2009-05-26T00:00:00    
80 80 02-CB-08676-001 1 0 1994-06-14T00:00:00         1994-06-14T00:00:00 GC   1994-06-14T00:00:00 1994-06-14T00:00:00 1987-06-10T00:00:00 2
81 81 02-CB-16789-001 0 0                     1999-09-29T00:00:00 5
82 82 03-CA-17899-001 0 0 1997-05-27T00:00:00 1997-05-12T00:00:00 CHP 1997-05-23T00:00:00 Grant   GC     1997-06-19T00:00:00 1997-09-05T00:00:00 1
83 83 03-CA-17899-001 0 1             EMPL     1997-06-19T00:00:00    
84 84 03-CA-17908-001 0 0 1996-07-23T00:00:00 1996-07-08T00:00:00 CHP 1996-08-02T00:00:00 Grant   GC     1996-08-01T00:00:00 1996-09-27T00:00:00 1
85 85 03-CA-17908-001 0 1             CHP     1996-07-31T00:00:00    
86 86 03-CA-17908-001 0 2             CGP     1996-08-02T00:00:00    
87 87 03-CA-18504-001 0 0                     1998-03-30T00:00:00 4
88 88 03-CA-18626-001 0 0 2000-07-25T00:00:00 2000-07-07T00:00:00 CGP 2000-07-07T00:00:00 Grant   GC     2000-08-03T00:00:00 2000-09-18T00:00:00 5
89 89 03-CA-18626-001 0 1   2000-11-17T00:00:00 GC 2000-11-17T00:00:00 Grant   CHP     2000-08-04T00:00:00    
90 90 03-CA-18626-001 0 2             CHP     2000-08-07T00:00:00    
91 91 03-CA-18626-001 0 3             CGP     2000-08-02T00:00:00    
92 92 03-CA-18750-001 0 0 2000-07-25T00:00:00 2000-07-07T00:00:00 CGP 2000-07-07T00:00:00 Grant   CHP     2000-08-07T00:00:00 2000-09-18T00:00:00 5
93 93 03-CA-18750-001 0 1           2000-08-04T00:00:00 CHP   2000-08-04T00:00:00 2000-08-04T00:00:00    
94 94 03-CA-18750-001 0 2           2000-08-03T00:00:00 GC   2000-08-04T00:00:00 2000-08-03T00:00:00    
95 95 03-CA-18750-001 0 3             CGP     2000-08-02T00:00:00    
96 96 03-CA-18760-001 0 0 2000-07-25T00:00:00           CHP     2000-08-07T00:00:00 2000-09-18T00:00:00 5
97 97 03-CA-18760-001 0 1           2000-08-04T00:00:00 CGP   2000-08-04T00:00:00 2000-08-04T00:00:00    
98 98 03-CA-18760-001 0 2           2000-08-03T00:00:00 GC   2000-08-04T00:00:00 2000-08-03T00:00:00    
99 99 03-CA-18760-001 0 3             CGP     2000-08-02T00:00:00    
100 100 03-CA-18760-001 1 0                     2000-09-18T00:00:00 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_sup_aljd_cmp" (
    "c_case_number" text,
    "action_sequence" integer,
    "recurrence" integer,
    "brief_due_date" text,
    "eot_request_rcvd_alj" text,
    "eot_brief_party" text,
    "eot_brief_deter_date" text,
    "eot_brief_determination" text,
    "alj_brief_rcvd_region" text,
    "alj_brief_party" text,
    "eot_brief_type" integer,
    "alj_brief_rcvd_alj" text,
    "alj_date_filed" text,
    "aljd_comp_date" text,
    "aljd_comp_determination" integer
);