c_alleg_action

1,551,184 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ c_case_number allegation_sequence sequence action_result action_date action_type
1 1 01-CA-19224-001 1 0 NOMER 1981-12-08T00:00:00 DETRM
2 2 01-CA-19224-001 1 1 Dismi 1981-12-28T00:00:00 DISMI
3 3 01-CA-19224-001 1 2 AppRe 1983-09-27T00:00:00 APEAL
4 4 01-CA-19224-001 1 3 Compl 1983-12-07T00:00:00 Compl
5 5 01-CA-19224-001 1 4 ALJDM 1989-04-05T00:00:00 ALJD
6 6 01-CA-19224-001 1 5 ALJDN 1989-04-05T00:00:00 ALJD
7 7 01-CA-19224-001 1 6 BDMer 1990-08-28T00:00:00 BDDEC
8 8 01-CA-19224-001 1 7 BDNMe 1990-08-28T00:00:00 BDDEC
9 9 01-CA-19224-001 1 8 BDNMe 1996-08-16T00:00:00 BDDEC
10 10 01-CA-19567-001 1 0 NOMER 1982-03-19T00:00:00 DETRM
11 11 01-CA-19567-001 1 1 Dismi 1982-04-08T00:00:00 DISMI
12 12 01-CA-19567-001 1 2 MERIT 1983-11-04T00:00:00 DETRM
13 13 01-CA-19567-001 1 3 Compl 1983-12-07T00:00:00 Compl
14 14 01-CA-19567-001 1 4 ALJDM 1989-04-05T00:00:00 ALJD
15 15 01-CA-19567-001 1 5 ALJDN 1989-04-05T00:00:00 ALJD
16 16 01-CA-19567-001 1 6 BDMer 1990-08-28T00:00:00 BDDEC
17 17 01-CA-19567-001 1 7 BDNMe 1990-08-28T00:00:00 BDDEC
18 18 01-CA-19567-001 1 8 BDNMe 1996-08-16T00:00:00 BDDEC
19 19 01-CA-19567-001 2 0 NOMER 1982-03-19T00:00:00 DETRM
20 20 01-CA-19567-001 2 1 Dismi 1982-04-08T00:00:00 DISMI
21 21 01-CA-19567-001 2 2 MERIT 1983-11-04T00:00:00 DETRM
22 22 01-CA-19567-001 2 3 Compl 1983-12-07T00:00:00 Compl
23 23 01-CA-19567-001 2 4 ALJDM 1989-04-05T00:00:00 ALJD
24 24 01-CA-19567-001 2 5 ALJDN 1989-04-05T00:00:00 ALJD
25 25 01-CA-19567-001 2 6 BDMer 1990-08-28T00:00:00 BDDEC
26 26 01-CA-19567-001 2 7 BDNMe 1990-08-28T00:00:00 BDDEC
27 27 01-CA-19567-001 2 8 BDNMe 1996-08-16T00:00:00 BDDEC
28 28 01-CA-19567-001 3 0 NOMER 1982-03-19T00:00:00 DETRM
29 29 01-CA-19567-001 3 1 Dismi 1982-04-08T00:00:00 DISMI
30 30 01-CA-19567-001 3 2 MERIT 1983-11-04T00:00:00 DETRM
31 31 01-CA-19567-001 3 3 Compl 1983-12-07T00:00:00 Compl
32 32 01-CA-19567-001 3 4 ALJDM 1989-04-05T00:00:00 ALJD
33 33 01-CA-19567-001 3 5 ALJDN 1989-04-05T00:00:00 ALJD
34 34 01-CA-19567-001 3 6 BDMer 1990-08-28T00:00:00 BDDEC
35 35 01-CA-19567-001 3 7 BDNMe 1990-08-28T00:00:00 BDDEC
36 36 01-CA-19567-001 3 8 BDNMe 1996-08-16T00:00:00 BDDEC
37 37 01-CA-19690-001 1 0 NOMER 1982-04-16T00:00:00 DETRM
38 38 01-CA-19690-001 1 1 Dismi 1982-04-28T00:00:00 DISMI
39 39 01-CA-19690-001 1 2 AppDS 1982-06-16T00:00:00 APEAL
40 40 01-CA-19690-001 1 3 Compl 1983-12-07T00:00:00 Compl
41 41 01-CA-19690-001 2 0 NOMER 1982-04-16T00:00:00 DETRM
42 42 01-CA-19690-001 2 1 Dismi 1982-04-28T00:00:00 DISMI
43 43 01-CA-19690-001 2 2 AppDS 1982-06-16T00:00:00 APEAL
44 44 01-CA-19690-001 2 3 Compl 1983-12-07T00:00:00 Compl
45 45 01-CA-19690-001 3 0 NOMER 1982-04-16T00:00:00 DETRM
46 46 01-CA-19690-001 3 1 Dismi 1982-04-28T00:00:00 DISMI
47 47 01-CA-19690-001 3 2 AppDS 1982-06-16T00:00:00 APEAL
48 48 01-CA-19690-001 3 3 Compl 1983-12-07T00:00:00 Compl
49 49 01-CA-19731-001 1 0 Advic 1982-04-13T00:00:00 ADVIC
50 50 01-CA-19731-001 1 1 MERIT 1982-05-12T00:00:00 DETRM
51 51 01-CA-19731-001 1 2 Compl 1982-05-12T00:00:00 Compl
52 52 01-CA-19731-001 1 3 Dismi 1982-05-25T00:00:00 DISMI
53 53 01-CA-19731-001 1 4 ALJDM 1983-06-30T00:00:00 ALJD
54 54 01-CA-19731-001 1 5 AdRMe 1983-02-04T00:00:00 ADVCR
55 55 01-CA-19731-001 2 0 Advic 1982-04-13T00:00:00 ADVIC
56 56 01-CA-19731-001 2 1 MERIT 1982-05-12T00:00:00 DETRM
57 57 01-CA-19731-001 2 2 Compl 1982-05-12T00:00:00 Compl
58 58 01-CA-19731-001 2 3 Dismi 1982-05-25T00:00:00 DISMI
59 59 01-CA-19731-001 2 4 ALJDM 1983-06-30T00:00:00 ALJD
60 60 01-CA-19731-001 2 5 AdRMe 1983-02-04T00:00:00 ADVCR
61 61 01-CA-19797-001 1 0 Compl 1982-05-07T00:00:00 Compl
62 62 01-CA-19903-001 1 0 MERIT 1982-07-07T00:00:00 DETRM
63 63 01-CA-19903-001 1 1 Compl 1982-07-07T00:00:00 Compl
64 64 01-CA-19958-001 1 10 MERIT 1982-11-19T00:00:00 DETRM
65 65 01-CA-19958-001 1 11 MERIT 1982-07-16T00:00:00 DETRM
66 66 01-CA-19958-001 1 12 NOMER 1982-07-16T00:00:00 DETRM
67 67 01-CA-19958-001 1 2 Dismi 1982-07-27T00:00:00 DISMI
68 68 01-CA-19958-001 1 3 AppRe 1982-11-19T00:00:00 APEAL
69 69 01-CA-19958-001 1 4 MERIT 1982-11-19T00:00:00 DETRM
70 70 01-CA-19958-001 1 5 Compl 1983-12-07T00:00:00 Compl
71 71 01-CA-19958-001 1 6 Dismi 1983-01-21T00:00:00 DISMI
72 72 01-CA-19958-001 1 7 AppDR 1983-09-27T00:00:00 APEAL
73 73 01-CA-19958-001 1 8 UniSA 1983-03-21T00:00:00 InfSA
74 74 01-CA-19958-001 1 9 Dismi 1983-03-23T00:00:00 DISMI
75 75 01-CA-20007-001 1 0 MERIT 1982-08-09T00:00:00 DETRM
76 76 01-CA-20007-001 1 1 Compl 1982-08-09T00:00:00 Compl
77 77 01-CA-20007-001 2 0 MERIT 1982-08-09T00:00:00 DETRM
78 78 01-CA-20007-001 2 1 Compl 1982-08-09T00:00:00 Compl
79 79 01-CA-20157-001 1 0 Compl 1982-10-22T00:00:00 Compl
80 80 01-CA-20218-001 1 0 Compl 1982-10-22T00:00:00 Compl
81 81 01-CA-20218-001 2 0 Compl 1982-10-22T00:00:00 Compl
82 82 01-CA-20283-001 1 0 NOMER 1982-10-25T00:00:00 DETRM
83 83 01-CA-20283-001 1 1 Dismi 1982-11-03T00:00:00 DISMI
84 84 01-CA-20283-001 1 2 AppRe 1983-09-27T00:00:00 APEAL
85 85 01-CA-20283-001 1 3 NOMER 1983-04-11T00:00:00 DETRM
86 86 01-CA-20283-001 1 4 Compl 1983-12-07T00:00:00 Compl
87 87 01-CA-20291-001 1 0 MERIT 1982-10-25T00:00:00 DETRM
88 88 01-CA-20291-001 1 1 NOMER 1982-10-25T00:00:00 DETRM
89 89 01-CA-20291-001 1 2 Dismi 1982-11-12T00:00:00 DISMI
90 90 01-CA-20291-001 1 3 AppRe 1983-09-27T00:00:00 APEAL
91 91 01-CA-20291-001 1 4 Compl 1983-12-07T00:00:00 Compl
92 92 01-CA-20304-001 1 0 NOMER 1982-10-25T00:00:00 DETRM
93 93 01-CA-20304-001 1 1 Dismi 1982-11-16T00:00:00 DISMI
94 94 01-CA-20304-001 1 2 AppRe 1983-09-27T00:00:00 APEAL
95 95 01-CA-20304-001 1 3 Compl 1983-12-07T00:00:00 Compl
96 96 01-CA-20442-001 1 0 Compl 1983-01-28T00:00:00 Compl
97 97 01-CA-20442-001 2 0 Compl 1983-01-28T00:00:00 Compl
98 98 01-CA-20508-001 1 0 NOMER 1983-01-05T00:00:00 DETRM
99 99 01-CA-20508-001 1 1 Dismi 1983-01-14T00:00:00 DISMI
100 100 01-CA-20508-001 1 2 AppRe 1983-09-27T00:00:00 APEAL

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_alleg_action" (
    "c_case_number" text,
    "allegation_sequence" integer,
    "sequence" integer,
    "action_result" text,
    "action_date" text,
    "action_type" text
);