c_appeal

143,760 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ c_case_number action_sequence recurrence appeal_expiration_date eot_date_filed eot_party eot_date_determination eot_determination appeal_date_filed appeal_action appeal_rcvd_in_region appeal_file_oa appeal_rcvd_oa appeal_file_rtrn_reg appeal_file_rcvd_reg appeal_date_determination appeal_determination appeal_party
1 1 01-CA-19224-001 0 0 1982-01-11T00:00:00         1982-01-08T00:00:00 Dismi   1982-01-21T00:00:00   1983-09-27T00:00:00 1983-10-06T00:00:00 1983-09-27T00:00:00 Rmnd CGP
2 2 01-CA-19567-001 0 0 1982-04-22T00:00:00                            
3 3 01-CA-19690-001 0 0 1982-05-12T00:00:00         1982-05-20T00:00:00 Dismi 1982-05-25T00:00:00 1982-05-25T00:00:00   1983-10-06T00:00:00   1982-06-16T00:00:00 Deny CGP
4 4 01-CA-19958-001 0 0 1999-08-12T00:00:00         1982-08-16T00:00:00 Dismi   1982-08-27T00:00:00       1982-11-19T00:00:00 Rmnd CGP
5 5 01-CA-19958-001 1 0 1983-02-04T00:00:00         1983-02-22T00:00:00 Dismi 1983-03-08T00:00:00 1983-04-06T00:00:00     1983-10-06T00:00:00 1983-09-27T00:00:00 Sust CGP
6 6 01-CA-20283-001 0 0 1982-11-17T00:00:00         1982-11-24T00:00:00 Dismi 1982-12-01T00:00:00 1982-11-17T00:00:00   1983-02-08T00:00:00 1983-02-15T00:00:00 1983-02-08T00:00:00 Rmnd CGP
7 7 01-CA-20291-001 0 0 1982-11-26T00:00:00         1982-11-26T00:00:00 Dismi 1982-12-07T00:00:00 1983-01-12T00:00:00     1983-10-06T00:00:00 1983-09-27T00:00:00 Rmnd CGP
8 8 01-CA-20304-001 0 0 1982-11-30T00:00:00         1982-12-06T00:00:00 Dismi   1983-01-12T00:00:00     1983-10-06T00:00:00 1983-09-27T00:00:00 Rmnd CGP
9 9 01-CA-20508-001 0 0 1983-01-28T00:00:00         1983-01-20T00:00:00 Dismi 1983-02-02T00:00:00 1983-01-24T00:00:00     1983-10-06T00:00:00 1983-09-27T00:00:00 Rmnd CGP
10 10 01-CA-25736-001 0 0 1988-10-11T00:00:00         1988-10-11T00:00:00 Dismi   1988-10-17T00:00:00   1988-11-07T00:00:00   1988-10-31T00:00:00 Deny CGP
11 11 01-CA-26098-001 0 0 1989-03-22T00:00:00         1989-03-24T00:00:00 Dismi 1989-03-30T00:00:00 1989-04-07T00:00:00     1989-05-08T00:00:00 1989-04-27T00:00:00 Deny CGP
12 12 01-CA-26463-001 0 0 1989-10-10T00:00:00                            
13 13 01-CA-26463-003 0 0 1989-10-10T00:00:00                            
14 14 01-CA-26463-005 0 0 1989-10-10T00:00:00                            
15 15 01-CA-26463-006 0 0 1989-10-10T00:00:00                            
16 16 01-CA-26604-001 0 0 2001-08-23T00:00:00                            
17 17 01-CA-27684-001 0 0 2001-10-30T00:00:00                            
18 18 01-CA-27852-001 0 0 2001-11-05T00:00:00                            
19 19 01-CA-28025-001 0 0 1991-04-16T00:00:00                            
20 20 01-CA-28025-001 1 0 1991-04-16T00:00:00                            
21 21 01-CA-28025-002 0 0 1991-04-16T00:00:00                            
22 22 01-CA-28025-002 1 0 2000-07-06T00:00:00                            
23 23 01-CA-28025-003 0 0 1991-04-16T00:00:00                            
24 24 01-CA-28025-003 1 0 2000-07-06T00:00:00                            
25 25 01-CA-28184-001 0 0 2001-11-05T00:00:00                            
26 26 01-CA-28315-001 0 0 1991-08-13T00:00:00         1991-08-15T00:00:00 Dismi 1991-08-22T00:00:00             CGP
27 27 01-CA-28558-001 0 0 1991-11-13T00:00:00         1999-11-14T00:00:00 Dismi   1991-12-31T00:00:00   1992-01-21T00:00:00   1992-01-16T00:00:00 Deny CGP
28 28 01-CA-28590-001 0 0 1992-03-31T00:00:00         1992-04-22T00:00:00 Dismi 1992-04-30T00:00:00 1992-05-05T00:00:00   1992-05-29T00:00:00 1992-05-29T00:00:00 1992-05-29T00:00:00 Deny CGP
29 29 01-CA-29179-001 0 0 1992-06-12T00:00:00         1992-06-11T00:00:00 Dismi   1992-08-11T00:00:00   1992-09-08T00:00:00   1992-08-31T00:00:00 Deny CGP
30 30 01-CA-29189-001 0 0 1992-05-13T00:00:00                            
31 31 01-CA-29627-001 0 0 1992-10-13T00:00:00                            
32 32 01-CA-29741-001 0 0 1999-09-14T00:00:00                            
33 33 01-CA-29743-001 0 0 1992-11-16T00:00:00                            
34 34 01-CA-29756-001 0 0 1992-11-19T00:00:00                            
35 35 01-CA-29756-001 1 0 2001-09-19T00:00:00                            
36 36 01-CA-29869-001 0 0 1993-11-15T00:00:00         1994-01-20T00:00:00 UniSt 1994-01-20T00:00:00 1994-01-28T00:00:00 1994-02-01T00:00:00 1994-03-09T00:00:00 1994-03-14T00:00:00 1994-03-09T00:00:00 Deny CGP
37 37 01-CA-29869-001 1 0 1993-01-15T00:00:00                            
38 38 01-CA-30099-001 0 0 1993-03-05T00:00:00                            
39 39 01-CA-30181-002 0 0 1999-06-17T00:00:00                            
40 40 01-CA-30292-001 0 0 1993-04-27T00:00:00         1993-04-27T00:00:00 Defer 1993-05-07T00:00:00 1993-05-05T00:00:00   1993-05-19T00:00:00 1993-05-26T00:00:00 1993-05-19T00:00:00 Deny CGP
41 41 01-CA-30347-001 0 0 1993-07-13T00:00:00                            
42 42 01-CA-30354-001 0 0 1993-05-25T00:00:00                            
43 43 01-CA-30354-001 1 0 2001-10-09T00:00:00                            
44 44 01-CA-30438-001 0 0 1999-09-08T00:00:00         1993-04-26T00:00:00 Dismi   1993-09-27T00:00:00     1993-11-22T00:00:00 1993-11-15T00:00:00 Deny CGP
45 45 01-CA-30568-001 0 0 2000-01-12T00:00:00                            
46 46 01-CA-30629-001 0 0 2002-03-20T00:00:00                            
47 47 01-CA-30629-001 1 0 1993-08-18T00:00:00                            
48 48 01-CA-30745-001 0 0 1997-01-16T00:00:00         1997-02-04T00:00:00 Dismi   1997-03-11T00:00:00   1997-07-02T00:00:00 1997-07-21T00:00:00 1997-07-02T00:00:00 Sust CGP
49 49 01-CA-30858-001 0 0 1999-08-04T00:00:00                            
50 50 01-CA-30941-001 0 0 1993-12-23T00:00:00         1993-11-30T00:00:00 Dismi 1993-12-02T00:00:00 1993-12-15T00:00:00   1993-12-30T00:00:00 1994-01-10T00:00:00 1993-12-30T00:00:00 Deny CGP
51 51 01-CA-30989-001 0 0 1994-03-31T00:00:00                            
52 52 01-CA-31010-001 0 0 1994-01-11T00:00:00         1994-01-10T00:00:00 Dismi 1994-01-10T00:00:00 1994-01-28T00:00:00   1994-02-25T00:00:00 1994-03-07T00:00:00 1994-02-25T00:00:00 Deny CGP
53 53 01-CA-31084-002 0 0 1999-06-07T00:00:00                            
54 54 01-CA-31123-001 0 0 2002-03-18T00:00:00                            
55 55 01-CA-31160-002 0 0 1999-06-09T00:00:00                            
56 56 01-CA-31242-001 0 0 1994-03-31T00:00:00                            
57 57 01-CA-31277-001 0 0 1999-06-08T00:00:00                            
58 58 01-CA-31299-001 0 0 1994-03-31T00:00:00                            
59 59 01-CA-31374-001 0 0 1994-04-05T00:00:00                            
60 60 01-CA-31374-001 1 0 2001-09-19T00:00:00                            
61 61 01-CA-31481-001 0 0 1994-07-14T00:00:00         1994-08-10T00:00:00 Dismi   1994-08-17T00:00:00       1995-10-19T00:00:00 Sust CGP
62 62 01-CA-31566-001 0 0 1994-06-08T00:00:00         1994-06-13T00:00:00 Defer 1994-06-13T00:00:00 1994-07-11T00:00:00     1994-07-29T00:00:00 1994-07-29T00:00:00 Deny CGP
63 63 01-CA-31567-001 0 0 1994-06-06T00:00:00                            
64 64 01-CA-31617-001 0 0 1994-08-10T00:00:00         1994-08-04T00:00:00 Dismi   1994-09-07T00:00:00     1995-03-03T00:00:00 1995-02-17T00:00:00 Rmnd CGP
65 65 01-CA-31708-001 0 0 1999-06-09T00:00:00                            
66 66 01-CA-31717-001 0 0 1999-01-26T00:00:00                            
67 67 01-CA-31722-001 0 0 1999-06-09T00:00:00                            
68 68 01-CA-31821-001 0 0 1999-06-16T00:00:00                            
69 69 01-CA-31878-001 0 0 1996-06-14T00:00:00         1996-07-17T00:00:00 Dismi 1996-07-19T00:00:00 1996-10-08T00:00:00   1996-12-13T00:00:00 1997-01-08T00:00:00 1996-12-13T00:00:00 GrntP CGP
70 70 01-CA-31889-001 0 0 1994-09-20T00:00:00         1994-09-20T00:00:00 Dismi   1994-12-28T00:00:00           CGP
71 71 01-CA-32082-001 0 0 1994-11-23T00:00:00         1994-11-22T00:00:00 Defer 1994-11-22T00:00:00             CGP
72 72 01-CA-32082-001 1 0           1994-11-22T00:00:00 Defer 1994-11-22T00:00:00             CGP
73 73 01-CA-32082-001 2 0                 1994-01-25T00:00:00   1995-02-28T00:00:00 1995-03-06T00:00:00      
74 74 01-CA-32082-001 3 0                         1995-02-28T00:00:00 Deny  
75 75 01-CA-32128-001 0 0 1999-06-09T00:00:00                            
76 76 01-CA-32140-001 0 0 1999-06-08T00:00:00                            
77 77 01-CA-32158-001 0 0 1997-05-26T00:00:00 2000-03-10T00:00:00 CGP     1997-05-30T00:00:00 Dismi 1997-06-03T00:00:00             CGP
78 78 01-CA-32158-001 1 0 2000-03-10T00:00:00 2000-03-10T00:00:00 CGP 2000-03-13T00:00:00 Grant 2000-03-28T00:00:00 Dismi 2000-03-31T00:00:00 2000-04-05T00:00:00   2000-04-28T00:00:00 2000-05-01T00:00:00 2000-04-28T00:00:00 Deny CGP
79 79 01-CA-32229-001 0 0 1994-12-27T00:00:00                            
80 80 01-CA-32229-001 1 0 2001-09-20T00:00:00                            
81 81 01-CA-32233-002 0 0 1999-06-08T00:00:00                            
82 82 01-CA-32248-001 0 0 1997-05-26T00:00:00 2000-03-10T00:00:00 CGP     1997-05-30T00:00:00 Dismi 1997-06-03T00:00:00             CGP
83 83 01-CA-32248-001 1 0 2000-03-10T00:00:00 2000-03-10T00:00:00 CGP 2000-03-13T00:00:00 Grant 2000-03-28T00:00:00 Dismi 2000-03-31T00:00:00 2000-04-05T00:00:00   2000-04-28T00:00:00 2000-05-01T00:00:00 2000-04-28T00:00:00 Deny CGP
84 84 01-CA-32261-001 0 0 1994-12-28T00:00:00         1994-12-28T00:00:00 Defer 1994-12-28T00:00:00 1994-12-29T00:00:00   1994-01-25T00:00:00   1995-01-25T00:00:00 Deny CGP
85 85 01-CA-32329-001 0 0 1999-06-08T00:00:00                            
86 86 01-CA-32456-001 0 0 1995-02-27T00:00:00                            
87 87 01-CA-32493-001 0 0 1995-10-26T00:00:00         1995-10-23T00:00:00 Defer 1995-10-24T00:00:00 1995-11-07T00:00:00 1995-11-08T00:00:00 1995-12-13T00:00:00 1996-01-09T00:00:00 1995-12-13T00:00:00 Deny CGP
88 88 01-CA-32493-001 1 0 2004-01-29T00:00:00                            
89 89 01-CA-32558-001 0 0 2000-01-03T00:00:00                            
90 90 01-CA-32570-001 0 0 1999-06-07T00:00:00                            
91 91 01-CA-32591-001 0 0 1995-11-22T00:00:00         1996-01-17T00:00:00 Dismi 1996-01-22T00:00:00 1996-02-13T00:00:00   1996-03-22T00:00:00 1996-03-27T00:00:00 1996-03-22T00:00:00 Deny CGP
92 92 01-CA-32609-002 0 0 1999-06-09T00:00:00                            
93 93 01-CA-32627-001 0 0 1995-04-17T00:00:00                            
94 94 01-CA-32627-001 1 0 2003-01-17T00:00:00                            
95 95 01-CA-32660-002 0 0 1995-04-26T00:00:00                            
96 96 01-CA-32688-001 0 0 1996-06-14T00:00:00         1996-07-15T00:00:00 Dismi 1996-07-17T00:00:00 1996-10-08T00:00:00   1996-12-13T00:00:00 1997-01-15T00:00:00 1996-12-13T00:00:00 GrntP CGP
97 97 01-CA-32741-001 0 0 1999-06-03T00:00:00                            
98 98 01-CA-32742-001 0 0 1998-11-06T00:00:00         1998-12-04T00:00:00 Dismi   1998-12-11T00:00:00   1998-12-28T00:00:00   1998-12-23T00:00:00 Deny CGP
99 99 01-CA-32767-001 0 0 1998-11-06T00:00:00         1998-12-04T00:00:00 Dismi   1998-12-11T00:00:00   1998-12-28T00:00:00   1998-12-23T00:00:00 Deny CGP
100 100 01-CA-32861-001 0 0 1995-05-31T00:00:00                            

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_appeal" (
    "c_case_number" text,
    "action_sequence" integer,
    "recurrence" integer,
    "appeal_expiration_date" text,
    "eot_date_filed" text,
    "eot_party" text,
    "eot_date_determination" text,
    "eot_determination" text,
    "appeal_date_filed" text,
    "appeal_action" text,
    "appeal_rcvd_in_region" text,
    "appeal_file_oa" text,
    "appeal_rcvd_oa" text,
    "appeal_file_rtrn_reg" text,
    "appeal_file_rcvd_reg" text,
    "appeal_date_determination" text,
    "appeal_determination" text,
    "appeal_party" text
);