c_alj_motion

3,135 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ c_case_number action_sequence recurrence date_filed motion_type party_filing determination_date motion_determination
1 1 01-CA-27322-001 0 0 1991-10-30T00:00:00 7      
2 2 01-CA-29631-001 0 0 1993-08-04T00:00:00 7   1993-08-17T00:00:00 FullG
3 3 01-CA-29757-001 0 0 1993-08-04T00:00:00 7   1993-08-17T00:00:00 FullG
4 4 01-CA-30013-001 0 0 1993-08-04T00:00:00 7   1993-08-17T00:00:00 FullG
5 5 01-CA-30110-001 0 0 1993-08-04T00:00:00 7   1993-08-17T00:00:00 FullG
6 6 01-CA-32393-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
7 7 01-CA-32952-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
8 8 01-CA-32953-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
9 9 01-CA-32954-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
10 10 01-CA-32965-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
11 11 01-CA-32965-001 1 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
12 12 01-CA-32966-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
13 13 01-CA-32991-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
14 14 01-CA-33016-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
15 15 01-CA-33044-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
16 16 01-CA-33045-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
17 17 01-CA-33046-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
18 18 01-CA-33047-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
19 19 01-CA-33050-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
20 20 01-CA-33050-002 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
21 21 01-CA-33214-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
22 22 01-CA-33216-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
23 23 01-CA-33217-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
24 24 01-CA-33218-001 0 0 2001-03-23T00:00:00 2   2001-03-30T00:00:00 FullG
25 25 01-CA-36195-001 0 0 1999-11-02T00:00:00 2      
26 26 01-CA-36267-001 0 0 1999-11-02T00:00:00 2      
27 27 01-CA-36529-001 0 0 1999-11-02T00:00:00 2      
28 28 01-CA-36534-001 0 0 1999-11-02T00:00:00 2      
29 29 01-CA-37457-001 0 0 1999-11-09T00:00:00 7      
30 30 01-CA-37682-001 0 0 2000-02-10T00:00:00 8      
31 31 01-CA-37769-001 0 0 2000-02-10T00:00:00 8      
32 32 01-CA-39256-001 0 0 2004-04-27T00:00:00 11   2004-05-02T00:00:00 FullG
33 33 01-CA-39558-001 0 0 2004-04-27T00:00:00 11   2004-05-02T00:00:00 FullG
34 34 01-CA-39568-001 0 0 2004-04-27T00:00:00 11   2004-05-02T00:00:00 FullG
35 35 01-CA-39644-001 0 0 2002-08-19T00:00:00 1   2002-08-22T00:00:00 FullG
36 36 01-CA-39999-001 0 0 2004-04-27T00:00:00 11   2004-05-02T00:00:00 FullG
37 37 01-CA-41154-001 0 0 2004-04-27T00:00:00 11   2004-05-02T00:00:00 FullG
38 38 01-CA-41190-001 0 0 2004-06-07T00:00:00 2   2004-06-16T00:00:00 FullG
39 39 01-CA-41191-001 0 0 2004-06-07T00:00:00 2   2004-06-16T00:00:00 FullG
40 40 01-CA-41192-001 0 0 2004-06-07T00:00:00 2   2004-06-16T00:00:00 FullG
41 41 01-CA-41201-001 0 0 2004-04-27T00:00:00 11   2004-05-02T00:00:00 FullG
42 42 01-CA-41576-001 0 0 2004-07-13T00:00:00 7 GC    
43 43 01-CA-42091-001 0 0 2005-11-08T00:00:00 4 GC    
44 44 01-CA-42411-001 0 0 2005-11-08T00:00:00 4 GC    
45 45 01-CA-42439-001 0 0 2005-11-08T00:00:00 4 GC    
46 46 01-CA-42897-001 0 0 2006-07-11T00:00:00 7 GC    
47 47 01-CA-42992-001 0 0 2006-08-15T00:00:00 13 EMPL 2006-09-13T00:00:00 Deny
48 48 01-CA-43094-001 0 0 2006-08-15T00:00:00 13 EMPL 2006-09-13T00:00:00 Deny
49 49 01-CA-43206-001 0 0 2006-08-15T00:00:00 13 EMPL 2006-09-13T00:00:00 Deny
50 50 01-CA-43351-001 0 0 2006-08-15T00:00:00 13 EMPL 2006-09-13T00:00:00 Deny
51 51 01-CA-43486-001 0 0 2007-10-18T00:00:00 7 GC    
52 52 01-CA-43486-001 1 0 2007-10-19T00:00:00 12 CHP    
53 53 01-CA-43486-001 2 0 2008-01-09T00:00:00 7 GC    
54 54 01-CA-43486-001 3 0 2008-01-16T00:00:00 7 CHP    
55 55 01-CA-43657-001 0 0 2007-10-18T00:00:00 7 GC    
56 56 01-CA-43657-001 1 0 2007-10-19T00:00:00 12 CHP    
57 57 01-CA-43657-001 2 0 2008-01-09T00:00:00 7 GC    
58 58 01-CA-43657-001 3 0 2008-01-16T00:00:00 7 CHP    
59 59 01-CA-43658-001 0 0 2007-10-18T00:00:00 7 GC    
60 60 01-CA-43658-001 1 0 2007-10-19T00:00:00 12 CHP    
61 61 01-CA-43658-001 2 0 2008-01-09T00:00:00 7 GC    
62 62 01-CA-43658-001 3 0 2008-01-16T00:00:00 7 CHP    
63 63 01-CA-43826-001 0 0 2008-05-28T00:00:00 10 GC 2008-06-04T00:00:00 FullG
64 64 01-CA-44047-001 0 0 2008-10-20T00:00:00 2 GC 2008-10-21T00:00:00 FullG
65 65 01-CA-44160-001 0 0 2008-05-28T00:00:00 10 GC 2008-06-04T00:00:00 FullG
66 66 01-CA-44198-001 0 0 2008-05-08T00:00:00 7 GC    
67 67 01-CA-44307-001 0 0 2008-04-17T00:00:00 13 CGP 2008-05-02T00:00:00 Deny
68 68 01-CA-44307-001 1 0 2008-04-21T00:00:00 7 CHP    
69 69 01-CA-44307-001 2 0 2008-04-29T00:00:00 7 GC    
70 70 01-CA-44367-001 0 0 2008-10-20T00:00:00 2 GC 2008-10-21T00:00:00 FullG
71 71 01-CA-44368-001 0 0 2008-10-20T00:00:00 2 GC 2008-10-21T00:00:00 FullG
72 72 01-CA-44827-001 0 0 2009-04-07T00:00:00 7 CHP 2009-05-05T00:00:00 FullG
73 73 01-CA-44920-001 0 0 2010-01-27T00:00:00 7 GC 2010-03-19T00:00:00 FullG
74 74 01-CA-44989-001 0 0 2010-01-27T00:00:00 7 GC    
75 75 01-CA-45008-001 0 0 2010-01-27T00:00:00 7 GC    
76 76 01-CA-45107-001 0 0 2009-04-07T00:00:00 7 CHP 2009-05-05T00:00:00 FullG
77 77 01-CA-45192-001 0 0 2010-01-27T00:00:00 7 GC    
78 78 01-CA-45193-001 0 0 2010-01-27T00:00:00 7 GC    
79 79 01-CA-45210-001 0 0 2010-01-21T00:00:00 11 CHP    
80 80 01-CA-45215-001 0 0 2010-01-27T00:00:00 7 GC    
81 81 01-CA-45233-001 0 0 2010-01-27T00:00:00 7 GC    
82 82 01-CA-45239-001 0 0 2010-01-27T00:00:00 7 GC    
83 83 01-CA-45386-001 0 0 2010-01-27T00:00:00 7 GC    
84 84 01-CB-10710-001 0 0 2008-03-20T00:00:00 7 CHP    
85 85 01-CB-10710-001 1 0 2008-03-28T00:00:00 7 GC    
86 86 01-CB-10710-001 2 0 2008-06-30T00:00:00 7 CHP    
87 87 01-CB-10710-001 3 0 2008-07-02T00:00:00 7 GC    
88 88 01-CC-02712-001 0 0 2004-03-04T00:00:00 11 CHP 2004-03-29T00:00:00 FullG
89 89 02-CA-29205-001 0 0 2000-07-18T00:00:00 10   2000-08-08T00:00:00 FullG
90 90 02-CA-30192-001 0 0 2000-09-20T00:00:00 1   2000-09-20T00:00:00 FullG
91 91 02-CA-30976-001 0 0 1998-12-16T00:00:00 1   1999-03-29T00:00:00 FullG
92 92 02-CA-31999-001 0 0 2001-06-14T00:00:00 10   2001-06-27T00:00:00 FullG
93 93 02-CA-32118-001 0 0 2000-08-10T00:00:00 7   2000-08-10T00:00:00 FullG
94 94 02-CA-32157-001 0 0 2002-11-18T00:00:00 7   2002-12-18T00:00:00 PartG
95 95 02-CA-32157-001 1 0 2003-01-09T00:00:00 7      
96 96 02-CA-32157-001 2 0 2002-11-30T00:00:00 7   2002-11-28T00:00:00 Other
97 97 02-CA-32276-001 0 0 2002-11-18T00:00:00 7   2002-12-18T00:00:00 PartG
98 98 02-CA-32276-001 1 0 2003-01-09T00:00:00 7      
99 99 02-CA-32378-001 0 0 2000-11-07T00:00:00 7   2000-11-08T00:00:00 Deny
100 100 02-CA-34258-001 0 0 2002-07-31T00:00:00 2   2002-08-01T00:00:00 FullG

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_alj_motion" (
    "c_case_number" text,
    "action_sequence" integer,
    "recurrence" integer,
    "date_filed" text,
    "motion_type" integer,
    "party_filing" text,
    "determination_date" text,
    "motion_determination" text
);