c_closing
326,944 rows
Suggested facets: action_sequence, close_method, close_timing, date_closed (date), date_file_sent_archives (date), date_file_to_records (date), date_file_destroyed (date), preclosing_letter (date), notice_of_closing_date (date)
| c_case_number | action_sequence | date_closed | close_method | close_timing | date_file_sent_archives | date_file_to_records | date_file_destroyed | preclosing_letter | notice_of_closing_date |
|---|---|---|---|---|---|---|---|---|---|
| 01-CA-19224-001 | 0 | 1999-08-10 | woCtJ | ASCJ | |||||
| 01-CA-19567-001 | 0 | 1999-08-10 | woCtJ | ASCJ | |||||
| 01-CA-19690-001 | 0 | 1999-08-10 | woCtJ | ASCJ | |||||
| 01-CA-19731-001 | 0 | 2000-03-03 | woCtJ | ACCJT | |||||
| 01-CA-19797-001 | 0 | 2000-03-03 | woFSA | ACCJT | |||||
| 01-CA-19903-001 | 0 | 2000-03-03 | woCtJ | ACCJT | |||||
| 01-CA-19958-001 | 0 | 1999-08-10 | woCtJ | ASCJ | |||||
| 01-CA-20007-001 | 0 | 2000-03-03 | woCtJ | ACCJT | |||||
| 01-CA-20157-001 | 0 | 2000-03-03 | woCtJ | ACCJT | |||||
| 01-CA-20218-001 | 0 | 2000-03-03 | woCtJ | ACCJT | |||||
| 01-CA-20283-001 | 0 | 1999-08-10 | woFSA | ASCJ | |||||
| 01-CA-20291-001 | 0 | 1999-08-10 | woFSA | ASCJ | |||||
| 01-CA-20304-001 | 0 | 1999-08-10 | woFSA | ASCJ | |||||
| 01-CA-20442-001 | 0 | 2000-03-03 | woCtJ | ACCJT | |||||
| 01-CA-20508-001 | 0 | 1999-08-10 | woFSA | ASCJ | |||||
| 01-CA-20521-001 | 0 | 2000-03-03 | woCtJ | ACCJT | |||||
| 01-CA-21438-001 | 0 | 2000-03-03 | woCtJ | ACCJT | |||||
| 01-CA-21560-001 | 0 | 1999-08-10 | woFSA | ASCJ | |||||
| 01-CA-21943-001 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-22040-002 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-22687-001 | 0 | 1999-04-09 | woBdD | ABOCD | |||||
| 01-CA-22769-001 | 0 | 1999-04-09 | woBdD | ABOCD | |||||
| 01-CA-22869-001 | 0 | 1999-04-09 | woBdD | ABOCD | |||||
| 01-CA-23307-001 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-23427-001 | 0 | 2000-10-31 | With | ACCJT | |||||
| 01-CA-23576-001 | 0 | 1999-04-09 | woBdD | ABOCD | |||||
| 01-CA-23748-001 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-24161-001 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-24372-001 | 0 | 2000-02-11 | woCtJ | ACCJ | |||||
| 01-CA-24390-002 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-24528-001 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-24863-001 | 0 | 1999-06-15 | InfSA | AHC | 1988-09-25 | 1999-06-17 | |||
| 01-CA-24883-001 | 0 | 1999-06-15 | InfSA | AHC | 1988-09-25 | 1999-06-17 | |||
| 01-CA-24921-001 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-24967-001 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-25033-001 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-25237-001 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-25237-002 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-25341-001 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-25521-001 | 0 | 1999-05-11 | Dismi | ABOAD | |||||
| 01-CA-25599-001 | 0 | 1999-04-09 | woBdD | ABOCD | |||||
| 01-CA-25656-001 | 0 | 1999-08-19 | woBdD | ABOCD | |||||
| 01-CA-25736-001 | 0 | 1999-05-05 | woCtJ | ACCJT | |||||
| 01-CA-25805-001 | 0 | 1999-04-09 | woBdD | ABOCD | |||||
| 01-CA-25864-001 | 0 | 1999-05-11 | Dismi | ABOAD | |||||
| 01-CA-25867-001 | 0 | 2001-08-16 | InfSA | ACBH | 2001-06-05 | 2001-08-20 | |||
| 01-CA-25896-001 | 0 | 1999-04-09 | woBdD | ABOCD | |||||
| 01-CA-25940-001 | 0 | 1999-06-29 | woFSA | ACCJT | |||||
| 01-CA-25969-001 | 0 | 2008-01-30 | CtDec | ASCJ | 2007-04-30 | 2008-01-31 | |||
| 01-CA-26098-001 | 0 | 1999-06-15 | InfSA | PreCo | 1999-08-02 | 1999-06-15 | |||
| 01-CA-26144-001 | 0 | 1999-08-19 | woBdD | ABOCD | |||||
| 01-CA-26183-001 | 0 | 1999-08-12 | woBdD | ABOAD | |||||
| 01-CA-26232-001 | 0 | 1999-06-16 | woISA | ACBH | 1992-02-25 | 1999-06-17 | |||
| 01-CA-26237-001 | 0 | 1999-06-16 | woISA | ACBH | 1992-02-25 | 1999-06-17 | |||
| 01-CA-26270-001 | 0 | 1999-08-12 | woBdD | ABOAD | |||||
| 01-CA-26353-001 | 0 | 1999-08-12 | woBdD | ABOAD | |||||
| 01-CA-26463-001 | 0 | 1999-09-28 | woCtJ | ACCJT | |||||
| 01-CA-26463-002 | 0 | 1999-09-28 | woCtJ | ABOAD | |||||
| 01-CA-26463-003 | 0 | 1999-09-28 | woCtJ | ACCJT | |||||
| 01-CA-26463-004 | 0 | 1999-09-29 | Dismi | ABOAD | |||||
| 01-CA-26463-004 | 1 | 1999-09-28 | woCtJ | ABOAD | |||||
| 01-CA-26463-005 | 0 | 1999-09-28 | woCtJ | ACCJT | |||||
| 01-CA-26463-006 | 0 | 1999-09-29 | Dismi | ABOAD | |||||
| 01-CA-26463-006 | 1 | 1999-09-28 | woCtJ | ABOAD | |||||
| 01-CA-26573-001 | 0 | 2001-02-05 | CtDec | ACCJ | |||||
| 01-CA-26575-001 | 0 | 1999-12-15 | woBdD | ABOCD | |||||
| 01-CA-26604-001 | 0 | 2001-10-11 | Dismi | PreCo | |||||
| 01-CA-26744-001 | 0 | 2001-09-10 | Dismi | ABOAD | |||||
| 01-CA-26820-001 | 0 | 2001-05-09 | Dismi | ABOAD | |||||
| 01-CA-26936-001 | 0 | 1999-08-18 | woBdD | ABOAD | |||||
| 01-CA-27014-001 | 0 | 1999-07-19 | woBdD | ABOAD | |||||
| 01-CA-27070-001 | 0 | 2001-02-05 | CtDec | ACCJ | |||||
| 01-CA-27142-001 | 0 | 1999-05-05 | woCtJ | ACCJT | |||||
| 01-CA-27197-001 | 0 | 1999-06-15 | InfSA | PreCo | 1990-08-09 | 1999-06-17 | |||
| 01-CA-27321-001 | 0 | 1999-08-06 | woCtJ | ACCJT | |||||
| 01-CA-27322-001 | 0 | 1999-08-09 | woBdD | ABOCD | |||||
| 01-CA-27335-001 | 0 | 1999-06-10 | InfSA | AHOBC | |||||
| 01-CA-27356-001 | 0 | 2000-02-11 | InfSA | ACBH | 1990-12-10 | 2000-02-17 | |||
| 01-CA-27385-001 | 0 | 1999-08-09 | woBdD | ABOCD | |||||
| 01-CA-27386-001 | 0 | 1999-08-09 | woBdD | ABOCD | |||||
| 01-CA-27417-001 | 0 | 2000-02-11 | InfSA | ACBH | 1990-12-10 | 2000-02-17 | |||
| 01-CA-27421-001 | 0 | 1999-10-25 | InfSA | ACBH | 1991-12-12 | 1999-11-03 | |||
| 01-CA-27491-001 | 0 | 1999-10-25 | InfSA | ACBH | 1991-12-12 | 1999-11-03 | |||
| 01-CA-27506-001 | 0 | 1999-02-23 | CtDec | ACCJ | |||||
| 01-CA-27659-001 | 0 | 1999-10-25 | InfSA | ACBH | 1991-12-12 | 1999-11-03 | |||
| 01-CA-27684-001 | 0 | 2001-11-23 | Dismi | PreCo | |||||
| 01-CA-27731-001 | 0 | 1999-08-20 | woCtJ | ACCJ | |||||
| 01-CA-27732-001 | 0 | 1999-10-25 | InfSA | ACBH | 1991-12-12 | 1999-11-03 | |||
| 01-CA-27732-002 | 0 | 1999-10-25 | InfSA | ACBH | 1991-12-12 | 1999-11-03 | |||
| 01-CA-27766-001 | 0 | 2000-01-31 | woISA | ACBH | |||||
| 01-CA-27800-001 | 0 | 1999-08-09 | BdDec | ABOAD | |||||
| 01-CA-27852-001 | 0 | 2002-01-30 | Dismi | PreCo | |||||
| 01-CA-27879-001 | 0 | 1999-11-04 | woBdD | ABOAD | |||||
| 01-CA-27908-001 | 0 | 2001-10-31 | CtDec | ACCJ | 2001-10-18 | 2001-10-31 | |||
| 01-CA-27937-001 | 0 | 1999-10-25 | InfSA | ACBH | 1991-12-12 | 1999-11-03 | |||
| 01-CA-27953-001 | 0 | 1999-08-09 | woBdD | ABOCD | |||||
| 01-CA-28025-001 | 0 | 2000-08-03 | Dismi | PreCo | |||||
| 01-CA-28025-002 | 0 | 2000-08-03 | Dismi | PreCo | |||||
| 01-CA-28025-003 | 0 | 2000-08-03 | Dismi | PreCo | |||||
| 01-CA-28064-001 | 0 | 2000-04-19 | Adj | ACBH |
Table schema
CREATE TABLE c_closing(c_case_number VARCHAR, action_sequence BIGINT, date_closed DATE, close_method VARCHAR, close_timing VARCHAR, date_file_sent_archives DATE, date_file_to_records TIMESTAMP, date_file_destroyed DATE, preclosing_letter DATE, notice_of_closing_date DATE);