c_appeal
143,760 rows
Suggested facets: action_sequence, recurrence, eot_determination, appeal_action, appeal_rcvd_oa, appeal_determination, appeal_expiration_date (date), eot_date_filed (date), eot_date_determination (date), appeal_date_filed (date), appeal_rcvd_in_region (date), appeal_file_oa (date), appeal_rcvd_oa (date), appeal_file_rtrn_reg (date), appeal_file_rcvd_reg (date), appeal_date_determination (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-CA-19224-001 | 0 | 0 | 1982-01-11 | 1982-01-08 | Dismi | 1982-01-21 | 1983-09-27 | 1983-10-06 | 1983-09-27 | Rmnd | CGP | ||||||
| 01-CA-19567-001 | 0 | 0 | 1982-04-22 | ||||||||||||||
| 01-CA-19690-001 | 0 | 0 | 1982-05-12 | 1982-05-20 | Dismi | 1982-05-25 | 1982-05-25 | 1983-10-06 | 1982-06-16 | Deny | CGP | ||||||
| 01-CA-19958-001 | 0 | 0 | 1999-08-12 | 1982-08-16 | Dismi | 1982-08-27 | 1982-11-19 | Rmnd | CGP | ||||||||
| 01-CA-19958-001 | 1 | 0 | 1983-02-04 | 1983-02-22 | Dismi | 1983-03-08 | 1983-04-06 | 1983-10-06 | 1983-09-27 | Sust | CGP | ||||||
| 01-CA-20283-001 | 0 | 0 | 1982-11-17 | 1982-11-24 | Dismi | 1982-12-01 | 1982-11-17 | 1983-02-08 | 1983-02-15 | 1983-02-08 | Rmnd | CGP | |||||
| 01-CA-20291-001 | 0 | 0 | 1982-11-26 | 1982-11-26 | Dismi | 1982-12-07 | 1983-01-12 | 1983-10-06 | 1983-09-27 | Rmnd | CGP | ||||||
| 01-CA-20304-001 | 0 | 0 | 1982-11-30 | 1982-12-06 | Dismi | 1983-01-12 | 1983-10-06 | 1983-09-27 | Rmnd | CGP | |||||||
| 01-CA-20508-001 | 0 | 0 | 1983-01-28 | 1983-01-20 | Dismi | 1983-02-02 | 1983-01-24 | 1983-10-06 | 1983-09-27 | Rmnd | CGP | ||||||
| 01-CA-25736-001 | 0 | 0 | 1988-10-11 | 1988-10-11 | Dismi | 1988-10-17 | 1988-11-07 | 1988-10-31 | Deny | CGP | |||||||
| 01-CA-26098-001 | 0 | 0 | 1989-03-22 | 1989-03-24 | Dismi | 1989-03-30 | 1989-04-07 | 1989-05-08 | 1989-04-27 | Deny | CGP | ||||||
| 01-CA-26463-001 | 0 | 0 | 1989-10-10 | ||||||||||||||
| 01-CA-26463-003 | 0 | 0 | 1989-10-10 | ||||||||||||||
| 01-CA-26463-005 | 0 | 0 | 1989-10-10 | ||||||||||||||
| 01-CA-26463-006 | 0 | 0 | 1989-10-10 | ||||||||||||||
| 01-CA-26604-001 | 0 | 0 | 2001-08-23 | ||||||||||||||
| 01-CA-27684-001 | 0 | 0 | 2001-10-30 | ||||||||||||||
| 01-CA-27852-001 | 0 | 0 | 2001-11-05 | ||||||||||||||
| 01-CA-28025-001 | 0 | 0 | 1991-04-16 | ||||||||||||||
| 01-CA-28025-001 | 1 | 0 | 1991-04-16 | ||||||||||||||
| 01-CA-28025-002 | 0 | 0 | 1991-04-16 | ||||||||||||||
| 01-CA-28025-002 | 1 | 0 | 2000-07-06 | ||||||||||||||
| 01-CA-28025-003 | 0 | 0 | 1991-04-16 | ||||||||||||||
| 01-CA-28025-003 | 1 | 0 | 2000-07-06 | ||||||||||||||
| 01-CA-28184-001 | 0 | 0 | 2001-11-05 | ||||||||||||||
| 01-CA-28315-001 | 0 | 0 | 1991-08-13 | 1991-08-15 | Dismi | 1991-08-22 | CGP | ||||||||||
| 01-CA-28558-001 | 0 | 0 | 1991-11-13 | 1999-11-14 | Dismi | 1991-12-31 | 1992-01-21 | 1992-01-16 | Deny | CGP | |||||||
| 01-CA-28590-001 | 0 | 0 | 1992-03-31 | 1992-04-22 | Dismi | 1992-04-30 | 1992-05-05 | 1992-05-29 | 1992-05-29 | 1992-05-29 | Deny | CGP | |||||
| 01-CA-29179-001 | 0 | 0 | 1992-06-12 | 1992-06-11 | Dismi | 1992-08-11 | 1992-09-08 | 1992-08-31 | Deny | CGP | |||||||
| 01-CA-29189-001 | 0 | 0 | 1992-05-13 | ||||||||||||||
| 01-CA-29627-001 | 0 | 0 | 1992-10-13 | ||||||||||||||
| 01-CA-29741-001 | 0 | 0 | 1999-09-14 | ||||||||||||||
| 01-CA-29743-001 | 0 | 0 | 1992-11-16 | ||||||||||||||
| 01-CA-29756-001 | 0 | 0 | 1992-11-19 | ||||||||||||||
| 01-CA-29756-001 | 1 | 0 | 2001-09-19 | ||||||||||||||
| 01-CA-29869-001 | 0 | 0 | 1993-11-15 | 1994-01-20 | UniSt | 1994-01-20 | 1994-01-28 | 1994-02-01 | 1994-03-09 | 1994-03-14 | 1994-03-09 | Deny | CGP | ||||
| 01-CA-29869-001 | 1 | 0 | 1993-01-15 | ||||||||||||||
| 01-CA-30099-001 | 0 | 0 | 1993-03-05 | ||||||||||||||
| 01-CA-30181-002 | 0 | 0 | 1999-06-17 | ||||||||||||||
| 01-CA-30292-001 | 0 | 0 | 1993-04-27 | 1993-04-27 | Defer | 1993-05-07 | 1993-05-05 | 1993-05-19 | 1993-05-26 | 1993-05-19 | Deny | CGP | |||||
| 01-CA-30347-001 | 0 | 0 | 1993-07-13 | ||||||||||||||
| 01-CA-30354-001 | 0 | 0 | 1993-05-25 | ||||||||||||||
| 01-CA-30354-001 | 1 | 0 | 2001-10-09 | ||||||||||||||
| 01-CA-30438-001 | 0 | 0 | 1999-09-08 | 1993-04-26 | Dismi | 1993-09-27 | 1993-11-22 | 1993-11-15 | Deny | CGP | |||||||
| 01-CA-30568-001 | 0 | 0 | 2000-01-12 | ||||||||||||||
| 01-CA-30629-001 | 0 | 0 | 2002-03-20 | ||||||||||||||
| 01-CA-30629-001 | 1 | 0 | 1993-08-18 | ||||||||||||||
| 01-CA-30745-001 | 0 | 0 | 1997-01-16 | 1997-02-04 | Dismi | 1997-03-11 | 1997-07-02 | 1997-07-21 | 1997-07-02 | Sust | CGP | ||||||
| 01-CA-30858-001 | 0 | 0 | 1999-08-04 | ||||||||||||||
| 01-CA-30941-001 | 0 | 0 | 1993-12-23 | 1993-11-30 | Dismi | 1993-12-02 | 1993-12-15 | 1993-12-30 | 1994-01-10 | 1993-12-30 | Deny | CGP | |||||
| 01-CA-30989-001 | 0 | 0 | 1994-03-31 | ||||||||||||||
| 01-CA-31010-001 | 0 | 0 | 1994-01-11 | 1994-01-10 | Dismi | 1994-01-10 | 1994-01-28 | 1994-02-25 | 1994-03-07 | 1994-02-25 | Deny | CGP | |||||
| 01-CA-31084-002 | 0 | 0 | 1999-06-07 | ||||||||||||||
| 01-CA-31123-001 | 0 | 0 | 2002-03-18 | ||||||||||||||
| 01-CA-31160-002 | 0 | 0 | 1999-06-09 | ||||||||||||||
| 01-CA-31242-001 | 0 | 0 | 1994-03-31 | ||||||||||||||
| 01-CA-31277-001 | 0 | 0 | 1999-06-08 | ||||||||||||||
| 01-CA-31299-001 | 0 | 0 | 1994-03-31 | ||||||||||||||
| 01-CA-31374-001 | 0 | 0 | 1994-04-05 | ||||||||||||||
| 01-CA-31374-001 | 1 | 0 | 2001-09-19 | ||||||||||||||
| 01-CA-31481-001 | 0 | 0 | 1994-07-14 | 1994-08-10 | Dismi | 1994-08-17 | 1995-10-19 | Sust | CGP | ||||||||
| 01-CA-31566-001 | 0 | 0 | 1994-06-08 | 1994-06-13 | Defer | 1994-06-13 | 1994-07-11 | 1994-07-29 | 1994-07-29 | Deny | CGP | ||||||
| 01-CA-31567-001 | 0 | 0 | 1994-06-06 | ||||||||||||||
| 01-CA-31617-001 | 0 | 0 | 1994-08-10 | 1994-08-04 | Dismi | 1994-09-07 | 1995-03-03 | 1995-02-17 | Rmnd | CGP | |||||||
| 01-CA-31708-001 | 0 | 0 | 1999-06-09 | ||||||||||||||
| 01-CA-31717-001 | 0 | 0 | 1999-01-26 | ||||||||||||||
| 01-CA-31722-001 | 0 | 0 | 1999-06-09 | ||||||||||||||
| 01-CA-31821-001 | 0 | 0 | 1999-06-16 | ||||||||||||||
| 01-CA-31878-001 | 0 | 0 | 1996-06-14 | 1996-07-17 | Dismi | 1996-07-19 | 1996-10-08 | 1996-12-13 | 1997-01-08 | 1996-12-13 | GrntP | CGP | |||||
| 01-CA-31889-001 | 0 | 0 | 1994-09-20 | 1994-09-20 | Dismi | 1994-12-28 | CGP | ||||||||||
| 01-CA-32082-001 | 0 | 0 | 1994-11-23 | 1994-11-22 | Defer | 1994-11-22 | CGP | ||||||||||
| 01-CA-32082-001 | 1 | 0 | 1994-11-22 | Defer | 1994-11-22 | CGP | |||||||||||
| 01-CA-32082-001 | 2 | 0 | 1994-01-25 | 1995-02-28 | 1995-03-06 | ||||||||||||
| 01-CA-32082-001 | 3 | 0 | 1995-02-28 | Deny | |||||||||||||
| 01-CA-32128-001 | 0 | 0 | 1999-06-09 | ||||||||||||||
| 01-CA-32140-001 | 0 | 0 | 1999-06-08 | ||||||||||||||
| 01-CA-32158-001 | 0 | 0 | 1997-05-26 | 2000-03-10 | CGP | 1997-05-30 | Dismi | 1997-06-03 | CGP | ||||||||
| 01-CA-32158-001 | 1 | 0 | 2000-03-10 | 2000-03-10 | CGP | 2000-03-13 | Grant | 2000-03-28 | Dismi | 2000-03-31 | 2000-04-05 | 2000-04-28 | 2000-05-01 | 2000-04-28 | Deny | CGP | |
| 01-CA-32229-001 | 0 | 0 | 1994-12-27 | ||||||||||||||
| 01-CA-32229-001 | 1 | 0 | 2001-09-20 | ||||||||||||||
| 01-CA-32233-002 | 0 | 0 | 1999-06-08 | ||||||||||||||
| 01-CA-32248-001 | 0 | 0 | 1997-05-26 | 2000-03-10 | CGP | 1997-05-30 | Dismi | 1997-06-03 | CGP | ||||||||
| 01-CA-32248-001 | 1 | 0 | 2000-03-10 | 2000-03-10 | CGP | 2000-03-13 | Grant | 2000-03-28 | Dismi | 2000-03-31 | 2000-04-05 | 2000-04-28 | 2000-05-01 | 2000-04-28 | Deny | CGP | |
| 01-CA-32261-001 | 0 | 0 | 1994-12-28 | 1994-12-28 | Defer | 1994-12-28 | 1994-12-29 | 1994-01-25 | 1995-01-25 | Deny | CGP | ||||||
| 01-CA-32329-001 | 0 | 0 | 1999-06-08 | ||||||||||||||
| 01-CA-32456-001 | 0 | 0 | 1995-02-27 | ||||||||||||||
| 01-CA-32493-001 | 0 | 0 | 1995-10-26 | 1995-10-23 | Defer | 1995-10-24 | 1995-11-07 | 1995-11-08 | 1995-12-13 | 1996-01-09 | 1995-12-13 | Deny | CGP | ||||
| 01-CA-32493-001 | 1 | 0 | 2004-01-29 | ||||||||||||||
| 01-CA-32558-001 | 0 | 0 | 2000-01-03 | ||||||||||||||
| 01-CA-32570-001 | 0 | 0 | 1999-06-07 | ||||||||||||||
| 01-CA-32591-001 | 0 | 0 | 1995-11-22 | 1996-01-17 | Dismi | 1996-01-22 | 1996-02-13 | 1996-03-22 | 1996-03-27 | 1996-03-22 | Deny | CGP | |||||
| 01-CA-32609-002 | 0 | 0 | 1999-06-09 | ||||||||||||||
| 01-CA-32627-001 | 0 | 0 | 1995-04-17 | ||||||||||||||
| 01-CA-32627-001 | 1 | 0 | 2003-01-17 | ||||||||||||||
| 01-CA-32660-002 | 0 | 0 | 1995-04-26 | ||||||||||||||
| 01-CA-32688-001 | 0 | 0 | 1996-06-14 | 1996-07-15 | Dismi | 1996-07-17 | 1996-10-08 | 1996-12-13 | 1997-01-15 | 1996-12-13 | GrntP | CGP | |||||
| 01-CA-32741-001 | 0 | 0 | 1999-06-03 | ||||||||||||||
| 01-CA-32742-001 | 0 | 0 | 1998-11-06 | 1998-12-04 | Dismi | 1998-12-11 | 1998-12-28 | 1998-12-23 | Deny | CGP | |||||||
| 01-CA-32767-001 | 0 | 0 | 1998-11-06 | 1998-12-04 | Dismi | 1998-12-11 | 1998-12-28 | 1998-12-23 | Deny | CGP | |||||||
| 01-CA-32861-001 | 0 | 0 | 1995-05-31 |
Table schema
CREATE TABLE c_appeal(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, appeal_expiration_date DATE, eot_date_filed DATE, eot_party VARCHAR, eot_date_determination DATE, eot_determination VARCHAR, appeal_date_filed DATE, appeal_action VARCHAR, appeal_rcvd_in_region DATE, appeal_file_oa DATE, appeal_rcvd_oa DATE, appeal_file_rtrn_reg DATE, appeal_file_rcvd_reg DATE, appeal_date_determination DATE, appeal_determination VARCHAR, appeal_party VARCHAR);