c_reopening
6,772 rows
Suggested facets: action_sequence, reopen_reason, reopen_date (date)
| c_case_number | action_sequence | reopen_date | reopen_reason |
|---|---|---|---|
| 01-CA-19690-001 | 0 | 1983-09-27 | DisRv |
| 01-CA-29743-001 | 0 | 1997-04-01 | Other |
| 01-CA-35451-001 | 0 | 2004-06-18 | DisRv |
| 01-CA-35784-001 | 0 | 2000-02-16 | Other |
| 01-CA-36658-001 | 0 | 2005-10-26 | Other |
| 01-CA-36659-001 | 0 | 2005-10-26 | Other |
| 01-CA-36799-001 | 0 | 2005-10-26 | Other |
| 01-CA-37075-001 | 0 | 1999-11-04 | WdRev |
| 01-CA-37238-001 | 0 | 1999-11-19 | WdRev |
| 01-CA-37354-001 | 0 | 2001-01-22 | DisRv |
| 01-CA-37477-001 | 0 | 2000-05-09 | Other |
| 01-CA-37509-001 | 0 | 1999-12-27 | WdRev |
| 01-CA-37595-001 | 0 | 2000-01-10 | Other |
| 01-CA-37840-001 | 0 | 2000-09-27 | DisRv |
| 01-CA-38346-001 | 0 | 2006-01-25 | Other |
| 01-CA-38550-001 | 0 | 2002-04-24 | Other |
| 01-CA-38732-001 | 0 | 2002-01-29 | SetAs |
| 01-CA-38930-001 | 0 | 2001-08-22 | DisRv |
| 01-CA-38934-001 | 0 | 2001-04-25 | WdRev |
| 01-CA-39082-001 | 0 | 2001-05-23 | TrxRc |
| 01-CA-39180-001 | 0 | 2001-07-07 | TrxRc |
| 01-CA-41132-001 | 0 | 2003-08-01 | TrxRc |
| 01-CA-42005-001 | 0 | 2004-08-18 | TrxRc |
| 01-CA-42005-001 | 1 | 2004-08-18 | TrxRc |
| 01-CA-44021-001 | 0 | 2007-07-05 | TrxRc |
| 01-CA-44262-001 | 0 | 2007-10-24 | TrxRc |
| 01-CA-44304-001 | 0 | 2008-06-16 | DisRv |
| 01-CA-44616-001 | 0 | 2008-06-12 | TrxRc |
| 01-CA-44957-001 | 0 | 2009-07-30 | SetAs |
| 01-CA-45314-001 | 0 | 2009-05-08 | TrxRc |
| 01-CB-09408-001 | 0 | 1999-09-13 | Other |
| 01-CB-09470-001 | 0 | 2000-06-02 | Other |
| 01-CB-09790-001 | 0 | 2001-09-20 | WdRev |
| 01-CB-10161-001 | 0 | 2003-08-01 | TrxRc |
| 01-CB-10392-001 | 0 | 2005-01-25 | TrxRc |
| 01-CB-10761-001 | 0 | 2007-06-13 | TrxRc |
| 01-CB-10811-001 | 0 | 2008-11-25 | WdRev |
| 02-CA-31177-001 | 0 | 1998-07-06 | DisRv |
| 02-CA-31511-001 | 0 | 1999-08-18 | WdRev |
| 02-CA-31897-001 | 0 | 1999-11-01 | Other |
| 02-CA-32071-001 | 0 | 1999-10-20 | Other |
| 02-CA-32537-001 | 0 | 2000-05-18 | Other |
| 02-CA-32730-001 | 0 | 2002-01-30 | Other |
| 02-CA-32805-001 | 0 | 2000-11-09 | Other |
| 02-CA-32999-001 | 0 | 2000-11-24 | Other |
| 02-CA-33940-001 | 0 | 2006-11-22 | Other |
| 02-CA-34059-001 | 0 | 2006-11-22 | Other |
| 02-CA-34236-001 | 0 | 2002-04-24 | Other |
| 02-CA-34319-001 | 0 | 2003-02-03 | WdRev |
| 02-CA-34482-001 | 0 | 2003-06-27 | WdRev |
| 02-CA-34587-001 | 0 | 2006-11-22 | Other |
| 02-CA-34679-001 | 0 | 2002-09-12 | Other |
| 02-CA-34707-001 | 0 | 2002-06-26 | TrxRc |
| 02-CA-34774-001 | 0 | 2002-07-25 | TrxRc |
| 02-CA-34789-001 | 0 | 2002-08-01 | TrxRc |
| 02-CA-34815-001 | 0 | 2003-06-25 | WdRev |
| 02-CA-35118-001 | 0 | 2002-11-27 | TrxRc |
| 02-CA-35231-001 | 0 | 2003-04-22 | SetAs |
| 02-CA-35414-001 | 0 | 2004-11-08 | WdRev |
| 02-CA-35415-001 | 0 | 2004-11-08 | WdRev |
| 02-CA-35469-001 | 0 | 2004-11-08 | WdRev |
| 02-CA-35501-001 | 0 | 2004-11-08 | WdRev |
| 02-CA-35510-001 | 0 | 2004-11-08 | WdRev |
| 02-CA-35522-001 | 0 | 2003-05-22 | TrxRc |
| 02-CA-35538-001 | 0 | 2004-11-08 | WdRev |
| 02-CA-35577-001 | 0 | 2003-06-18 | TrxRc |
| 02-CA-35781-001 | 0 | 2004-01-26 | Other |
| 02-CA-35782-001 | 0 | 2004-01-26 | Other |
| 02-CA-35792-001 | 0 | 2004-01-26 | Other |
| 02-CA-35837-001 | 0 | 2004-05-03 | Other |
| 02-CA-35901-001 | 0 | 2004-01-16 | Other |
| 02-CA-36030-001 | 0 | 2004-09-09 | Other |
| 02-CA-36127-001 | 0 | 2004-07-17 | Other |
| 02-CA-36139-001 | 0 | 2004-06-18 | Other |
| 02-CA-36241-001 | 0 | 2006-06-12 | Other |
| 02-CA-36267-001 | 0 | 2004-08-04 | Other |
| 02-CA-36517-001 | 0 | 2005-01-18 | Other |
| 02-CA-36658-001 | 0 | 2005-03-31 | Other |
| 02-CA-36737-001 | 0 | 2005-01-20 | Other |
| 02-CA-36933-001 | 0 | 2006-06-12 | Other |
| 02-CA-36969-001 | 0 | 2005-07-25 | Other |
| 02-CA-37160-001 | 0 | 2005-11-08 | Other |
| 02-CA-37325-001 | 0 | 2006-02-06 | Other |
| 02-CA-37359-001 | 0 | 2005-11-30 | TrxRc |
| 02-CA-37367-001 | 0 | 2006-03-23 | TrxRc |
| 02-CA-37367-001 | 1 | 2007-12-12 | SetAs |
| 02-CA-37398-001 | 0 | 2006-09-14 | WdRev |
| 02-CA-37543-001 | 0 | 2006-06-09 | Other |
| 02-CA-37560-001 | 0 | 2006-06-12 | Other |
| 02-CA-37850-001 | 0 | 2007-04-09 | WdRev |
| 02-CA-38028-001 | 0 | 2007-05-21 | Other |
| 02-CA-38095-001 | 0 | 2007-07-25 | Other |
| 02-CA-38306-001 | 0 | 2007-10-25 | WdRev |
| 02-CA-38410-001 | 0 | 2007-08-22 | TrxRc |
| 02-CA-38731-001 | 0 | 2008-04-15 | TrxRc |
| 02-CA-38894-001 | 0 | 2008-12-15 | Other |
| 02-CA-38898-001 | 0 | 2008-08-01 | TrxRc |
| 02-CA-39097-001 | 0 | 2009-03-18 | Other |
| 02-CA-39183-001 | 0 | 2009-06-25 | Other |
| 02-CA-39481-001 | 0 | 2010-06-10 | WdRev |
Table schema
CREATE TABLE c_reopening(c_case_number VARCHAR, action_sequence BIGINT, reopen_date DATE, reopen_reason VARCHAR);