c_dismissal
109,632 rows
Suggested facets: action_sequence, scope, revoked_date, date_issued (date), revoked_date (date)
| c_case_number | action_sequence | recurrence | revoked_reason | date_issued | scope | revoked_date | adjusted |
|---|---|---|---|---|---|---|---|
| 01-CA-19224-001 | 0 | 0 | 1981-12-28 | FULL | N | ||
| 01-CA-19567-001 | 0 | 0 | Other | 1982-04-08 | FULL | 1983-12-05 | N |
| 01-CA-19690-001 | 0 | 0 | 1982-04-28 | FULL | N | ||
| 01-CA-19731-001 | 0 | 0 | 1982-05-25 | PART | N | ||
| 01-CA-19797-001 | 0 | 0 | 1982-05-25 | PART | N | ||
| 01-CA-19903-001 | 0 | 0 | 1982-05-25 | PART | N | ||
| 01-CA-19958-001 | 0 | 0 | Other | 1982-07-29 | PART | 1983-10-04 | N |
| 01-CA-19958-001 | 1 | 0 | 1983-01-21 | PART | N | ||
| 01-CA-19958-001 | 2 | 0 | 1983-03-23 | FULL | N | ||
| 01-CA-20007-001 | 0 | 0 | 1982-05-25 | PART | N | ||
| 01-CA-20157-001 | 0 | 0 | 1982-05-25 | PART | N | ||
| 01-CA-20218-001 | 0 | 0 | 1982-05-25 | PART | N | ||
| 01-CA-20283-001 | 0 | 0 | 1982-11-03 | FULL | N | ||
| 01-CA-20291-001 | 0 | 0 | 1982-11-12 | FULL | N | ||
| 01-CA-20304-001 | 0 | 0 | 1982-11-16 | FULL | N | ||
| 01-CA-20442-001 | 0 | 0 | 1982-05-25 | PART | N | ||
| 01-CA-20508-001 | 0 | 0 | 1983-01-14 | FULL | N | ||
| 01-CA-20521-001 | 0 | 0 | 1982-05-25 | PART | N | ||
| 01-CA-21438-001 | 0 | 0 | 1982-05-25 | PART | N | ||
| 01-CA-24372-001 | 0 | 0 | 1986-12-31 | PART | N | ||
| 01-CA-25736-001 | 0 | 0 | 1988-09-26 | PART | N | ||
| 01-CA-26098-001 | 0 | 0 | 1989-03-08 | PART | N | ||
| 01-CA-26463-001 | 0 | 0 | 1989-09-26 | PART | N | ||
| 01-CA-26463-003 | 0 | 0 | 1989-09-26 | PART | N | ||
| 01-CA-26463-005 | 0 | 0 | 1989-09-26 | PART | N | ||
| 01-CA-26463-006 | 0 | 0 | 1989-09-26 | PART | N | ||
| 01-CA-26604-001 | 0 | 0 | 2001-08-09 | FULL | N | ||
| 01-CA-27684-001 | 0 | 0 | 2001-10-16 | FULL | N | ||
| 01-CA-27852-001 | 0 | 0 | 2001-10-22 | FULL | N | ||
| 01-CA-28025-001 | 0 | 0 | 1991-04-02 | FULL | N | ||
| 01-CA-28025-002 | 0 | 0 | 1991-04-02 | PART | N | ||
| 01-CA-28025-002 | 1 | 0 | 2000-06-22 | FULL | N | ||
| 01-CA-28025-003 | 0 | 0 | 2000-06-22 | FULL | N | ||
| 01-CA-28184-001 | 0 | 0 | 2001-10-22 | FULL | N | ||
| 01-CA-28315-001 | 0 | 0 | 1991-07-30 | PART | N | ||
| 01-CA-28558-001 | 0 | 0 | 1991-10-30 | PART | N | ||
| 01-CA-28590-001 | 0 | 0 | 1992-03-17 | PART | N | ||
| 01-CA-29179-001 | 0 | 0 | 1992-05-29 | PART | N | ||
| 01-CA-29189-001 | 0 | 0 | 1992-04-29 | PART | N | ||
| 01-CA-29189-001 | 1 | 0 | 2001-10-15 | FULL | N | ||
| 01-CA-29301-001 | 0 | 0 | 1992-05-28 | FULL | N | ||
| 01-CA-29500-001 | 0 | 0 | 1992-07-27 | PART | N | ||
| 01-CA-29741-001 | 0 | 0 | 1999-08-31 | FULL | N | ||
| 01-CA-29756-001 | 0 | 0 | 2001-09-05 | FULL | N | ||
| 01-CA-29869-001 | 0 | 0 | 1993-01-01 | PART | N | ||
| 01-CA-30181-002 | 0 | 0 | Corre | 1999-05-21 | FULL | 1999-06-03 | N |
| 01-CA-30181-002 | 1 | 0 | 1999-06-03 | FULL | N | ||
| 01-CA-30354-001 | 0 | 0 | 2001-09-25 | FULL | N | ||
| 01-CA-30438-001 | 0 | 0 | 1993-08-23 | PART | N | ||
| 01-CA-30568-001 | 0 | 0 | NewEv | 1997-04-24 | FULL | 1997-05-07 | N |
| 01-CA-30568-001 | 1 | 0 | 1999-12-29 | FULL | N | ||
| 01-CA-30629-001 | 0 | 0 | 2002-03-06 | FULL | N | ||
| 01-CA-30745-001 | 0 | 0 | 1997-01-02 | PART | N | ||
| 01-CA-30858-001 | 0 | 0 | 1999-07-21 | FULL | N | ||
| 01-CA-30941-001 | 0 | 0 | 1993-11-09 | PART | N | ||
| 01-CA-30989-001 | 0 | 0 | 1994-03-17 | PART | N | ||
| 01-CA-31010-001 | 0 | 0 | 1993-12-28 | PART | N | ||
| 01-CA-31084-002 | 0 | 0 | 1999-05-24 | FULL | N | ||
| 01-CA-31123-001 | 0 | 0 | 2002-03-04 | FULL | N | ||
| 01-CA-31160-002 | 0 | 0 | 1999-05-26 | FULL | N | ||
| 01-CA-31242-001 | 0 | 0 | 1994-03-17 | PART | N | ||
| 01-CA-31277-001 | 0 | 0 | 1999-05-25 | FULL | N | ||
| 01-CA-31299-001 | 0 | 0 | 1994-03-17 | PART | N | ||
| 01-CA-31374-001 | 0 | 0 | 2001-09-05 | FULL | N | ||
| 01-CA-31481-001 | 0 | 0 | 1994-06-30 | PART | N | ||
| 01-CA-31567-001 | 0 | 0 | 1994-05-23 | PART | N | ||
| 01-CA-31617-001 | 0 | 0 | 1994-07-27 | FULL | N | ||
| 01-CA-31708-001 | 0 | 0 | 1999-05-26 | FULL | N | ||
| 01-CA-31717-001 | 0 | 0 | 1999-01-12 | FULL | N | ||
| 01-CA-31722-001 | 0 | 0 | 1999-05-26 | FULL | N | ||
| 01-CA-31821-001 | 0 | 0 | 1999-06-02 | FULL | N | ||
| 01-CA-31878-001 | 0 | 0 | 1994-09-30 | PART | N | ||
| 01-CA-31889-001 | 0 | 0 | 1994-09-06 | FULL | 1995-04-24 | N | |
| 01-CA-32128-001 | 0 | 0 | 1999-05-26 | FULL | N | ||
| 01-CA-32140-001 | 0 | 0 | 1999-05-25 | FULL | N | ||
| 01-CA-32158-001 | 0 | 0 | 1997-05-12 | PART | N | ||
| 01-CA-32158-001 | 1 | 0 | 2000-02-25 | PART | N | ||
| 01-CA-32229-001 | 0 | 0 | 2001-09-06 | FULL | N | ||
| 01-CA-32233-002 | 0 | 0 | 1999-05-25 | FULL | N | ||
| 01-CA-32248-001 | 0 | 0 | 1997-05-12 | PART | N | ||
| 01-CA-32248-001 | 1 | 0 | 2000-02-25 | PART | N | ||
| 01-CA-32329-001 | 0 | 0 | 1999-05-25 | FULL | N | ||
| 01-CA-32493-001 | 0 | 0 | 2004-01-15 | FULL | N | ||
| 01-CA-32557-001 | 0 | 0 | 1997-03-12 | FULL | N | ||
| 01-CA-32558-001 | 0 | 0 | 1999-12-20 | FULL | N | ||
| 01-CA-32570-001 | 0 | 0 | Corre | 1999-05-24 | FULL | 1999-06-02 | N |
| 01-CA-32591-001 | 0 | 0 | 1995-11-02 | PART | N | ||
| 01-CA-32609-002 | 0 | 0 | 1999-05-26 | FULL | N | ||
| 01-CA-32627-001 | 0 | 0 | 2003-01-03 | FULL | N | ||
| 01-CA-32688-001 | 0 | 0 | 1996-05-31 | FULL | N | ||
| 01-CA-32741-001 | 0 | 0 | 1999-05-20 | FULL | N | ||
| 01-CA-32742-001 | 0 | 0 | 1998-10-23 | PART | N | ||
| 01-CA-32767-001 | 0 | 0 | 1998-10-23 | PART | N | ||
| 01-CA-32875-001 | 0 | 0 | 1999-05-26 | FULL | N | ||
| 01-CA-32881-001 | 0 | 0 | 1995-11-08 | PART | N | ||
| 01-CA-32986-001 | 0 | 0 | 1999-05-25 | FULL | N | ||
| 01-CA-33099-001 | 0 | 0 | 1995-08-14 | FULL | N | ||
| 01-CA-33147-001 | 0 | 0 | 1996-10-31 | FULL | N | ||
| 01-CA-33249-001 | 0 | 0 | 1996-01-22 | PART | N | ||
| 01-CA-33250-001 | 0 | 0 | 1996-05-31 | PART | N |
Table schema
CREATE TABLE c_dismissal(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, revoked_reason VARCHAR, date_issued DATE, "scope" VARCHAR, revoked_date DATE, adjusted VARCHAR);