c_closing

326,944 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ 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
1 1 01-CA-19224-001 0 1999-08-10T00:00:00 woCtJ ASCJ          
2 2 01-CA-19567-001 0 1999-08-10T00:00:00 woCtJ ASCJ          
3 3 01-CA-19690-001 0 1999-08-10T00:00:00 woCtJ ASCJ          
4 4 01-CA-19731-001 0 2000-03-03T00:00:00 woCtJ ACCJT          
5 5 01-CA-19797-001 0 2000-03-03T00:00:00 woFSA ACCJT          
6 6 01-CA-19903-001 0 2000-03-03T00:00:00 woCtJ ACCJT          
7 7 01-CA-19958-001 0 1999-08-10T00:00:00 woCtJ ASCJ          
8 8 01-CA-20007-001 0 2000-03-03T00:00:00 woCtJ ACCJT          
9 9 01-CA-20157-001 0 2000-03-03T00:00:00 woCtJ ACCJT          
10 10 01-CA-20218-001 0 2000-03-03T00:00:00 woCtJ ACCJT          
11 11 01-CA-20283-001 0 1999-08-10T00:00:00 woFSA ASCJ          
12 12 01-CA-20291-001 0 1999-08-10T00:00:00 woFSA ASCJ          
13 13 01-CA-20304-001 0 1999-08-10T00:00:00 woFSA ASCJ          
14 14 01-CA-20442-001 0 2000-03-03T00:00:00 woCtJ ACCJT          
15 15 01-CA-20508-001 0 1999-08-10T00:00:00 woFSA ASCJ          
16 16 01-CA-20521-001 0 2000-03-03T00:00:00 woCtJ ACCJT          
17 17 01-CA-21438-001 0 2000-03-03T00:00:00 woCtJ ACCJT          
18 18 01-CA-21560-001 0 1999-08-10T00:00:00 woFSA ASCJ          
19 19 01-CA-21943-001 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
20 20 01-CA-22040-002 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
21 21 01-CA-22687-001 0 1999-04-09T00:00:00 woBdD ABOCD          
22 22 01-CA-22769-001 0 1999-04-09T00:00:00 woBdD ABOCD          
23 23 01-CA-22869-001 0 1999-04-09T00:00:00 woBdD ABOCD          
24 24 01-CA-23307-001 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
25 25 01-CA-23427-001 0 2000-10-31T00:00:00 With ACCJT          
26 26 01-CA-23576-001 0 1999-04-09T00:00:00 woBdD ABOCD          
27 27 01-CA-23748-001 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
28 28 01-CA-24161-001 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
29 29 01-CA-24372-001 0 2000-02-11T00:00:00 woCtJ ACCJ          
30 30 01-CA-24390-002 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
31 31 01-CA-24528-001 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
32 32 01-CA-24863-001 0 1999-06-15T00:00:00 InfSA AHC       1988-09-25T00:00:00 1999-06-17T00:00:00
33 33 01-CA-24883-001 0 1999-06-15T00:00:00 InfSA AHC       1988-09-25T00:00:00 1999-06-17T00:00:00
34 34 01-CA-24921-001 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
35 35 01-CA-24967-001 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
36 36 01-CA-25033-001 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
37 37 01-CA-25237-001 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
38 38 01-CA-25237-002 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
39 39 01-CA-25341-001 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
40 40 01-CA-25521-001 0 1999-05-11T00:00:00 Dismi ABOAD          
41 41 01-CA-25599-001 0 1999-04-09T00:00:00 woBdD ABOCD          
42 42 01-CA-25656-001 0 1999-08-19T00:00:00 woBdD ABOCD          
43 43 01-CA-25736-001 0 1999-05-05T00:00:00 woCtJ ACCJT          
44 44 01-CA-25805-001 0 1999-04-09T00:00:00 woBdD ABOCD          
45 45 01-CA-25864-001 0 1999-05-11T00:00:00 Dismi ABOAD          
46 46 01-CA-25867-001 0 2001-08-16T00:00:00 InfSA ACBH       2001-06-05T00:00:00 2001-08-20T00:00:00
47 47 01-CA-25896-001 0 1999-04-09T00:00:00 woBdD ABOCD          
48 48 01-CA-25940-001 0 1999-06-29T00:00:00 woFSA ACCJT          
49 49 01-CA-25969-001 0 2008-01-30T00:00:00 CtDec ASCJ       2007-04-30T00:00:00 2008-01-31T00:00:00
50 50 01-CA-26098-001 0 1999-06-15T00:00:00 InfSA PreCo       1999-08-02T00:00:00 1999-06-15T00:00:00
51 51 01-CA-26144-001 0 1999-08-19T00:00:00 woBdD ABOCD          
52 52 01-CA-26183-001 0 1999-08-12T00:00:00 woBdD ABOAD          
53 53 01-CA-26232-001 0 1999-06-16T00:00:00 woISA ACBH       1992-02-25T00:00:00 1999-06-17T00:00:00
54 54 01-CA-26237-001 0 1999-06-16T00:00:00 woISA ACBH       1992-02-25T00:00:00 1999-06-17T00:00:00
55 55 01-CA-26270-001 0 1999-08-12T00:00:00 woBdD ABOAD          
56 56 01-CA-26353-001 0 1999-08-12T00:00:00 woBdD ABOAD          
57 57 01-CA-26463-001 0 1999-09-28T00:00:00 woCtJ ACCJT          
58 58 01-CA-26463-002 0 1999-09-28T00:00:00 woCtJ ABOAD          
59 59 01-CA-26463-003 0 1999-09-28T00:00:00 woCtJ ACCJT          
60 60 01-CA-26463-004 0 1999-09-29T00:00:00 Dismi ABOAD          
61 61 01-CA-26463-004 1 1999-09-28T00:00:00 woCtJ ABOAD          
62 62 01-CA-26463-005 0 1999-09-28T00:00:00 woCtJ ACCJT          
63 63 01-CA-26463-006 0 1999-09-29T00:00:00 Dismi ABOAD          
64 64 01-CA-26463-006 1 1999-09-28T00:00:00 woCtJ ABOAD          
65 65 01-CA-26573-001 0 2001-02-05T00:00:00 CtDec ACCJ          
66 66 01-CA-26575-001 0 1999-12-15T00:00:00 woBdD ABOCD          
67 67 01-CA-26604-001 0 2001-10-11T00:00:00 Dismi PreCo          
68 68 01-CA-26744-001 0 2001-09-10T00:00:00 Dismi ABOAD          
69 69 01-CA-26820-001 0 2001-05-09T00:00:00 Dismi ABOAD          
70 70 01-CA-26936-001 0 1999-08-18T00:00:00 woBdD ABOAD          
71 71 01-CA-27014-001 0 1999-07-19T00:00:00 woBdD ABOAD          
72 72 01-CA-27070-001 0 2001-02-05T00:00:00 CtDec ACCJ          
73 73 01-CA-27142-001 0 1999-05-05T00:00:00 woCtJ ACCJT          
74 74 01-CA-27197-001 0 1999-06-15T00:00:00 InfSA PreCo       1990-08-09T00:00:00 1999-06-17T00:00:00
75 75 01-CA-27321-001 0 1999-08-06T00:00:00 woCtJ ACCJT          
76 76 01-CA-27322-001 0 1999-08-09T00:00:00 woBdD ABOCD          
77 77 01-CA-27335-001 0 1999-06-10T00:00:00 InfSA AHOBC          
78 78 01-CA-27356-001 0 2000-02-11T00:00:00 InfSA ACBH       1990-12-10T00:00:00 2000-02-17T00:00:00
79 79 01-CA-27385-001 0 1999-08-09T00:00:00 woBdD ABOCD          
80 80 01-CA-27386-001 0 1999-08-09T00:00:00 woBdD ABOCD          
81 81 01-CA-27417-001 0 2000-02-11T00:00:00 InfSA ACBH       1990-12-10T00:00:00 2000-02-17T00:00:00
82 82 01-CA-27421-001 0 1999-10-25T00:00:00 InfSA ACBH       1991-12-12T00:00:00 1999-11-03T00:00:00
83 83 01-CA-27491-001 0 1999-10-25T00:00:00 InfSA ACBH       1991-12-12T00:00:00 1999-11-03T00:00:00
84 84 01-CA-27506-001 0 1999-02-23T00:00:00 CtDec ACCJ          
85 85 01-CA-27659-001 0 1999-10-25T00:00:00 InfSA ACBH       1991-12-12T00:00:00 1999-11-03T00:00:00
86 86 01-CA-27684-001 0 2001-11-23T00:00:00 Dismi PreCo          
87 87 01-CA-27731-001 0 1999-08-20T00:00:00 woCtJ ACCJ          
88 88 01-CA-27732-001 0 1999-10-25T00:00:00 InfSA ACBH       1991-12-12T00:00:00 1999-11-03T00:00:00
89 89 01-CA-27732-002 0 1999-10-25T00:00:00 InfSA ACBH       1991-12-12T00:00:00 1999-11-03T00:00:00
90 90 01-CA-27766-001 0 2000-01-31T00:00:00 woISA ACBH          
91 91 01-CA-27800-001 0 1999-08-09T00:00:00 BdDec ABOAD          
92 92 01-CA-27852-001 0 2002-01-30T00:00:00 Dismi PreCo          
93 93 01-CA-27879-001 0 1999-11-04T00:00:00 woBdD ABOAD          
94 94 01-CA-27908-001 0 2001-10-31T00:00:00 CtDec ACCJ       2001-10-18T00:00:00 2001-10-31T00:00:00
95 95 01-CA-27937-001 0 1999-10-25T00:00:00 InfSA ACBH       1991-12-12T00:00:00 1999-11-03T00:00:00
96 96 01-CA-27953-001 0 1999-08-09T00:00:00 woBdD ABOCD          
97 97 01-CA-28025-001 0 2000-08-03T00:00:00 Dismi PreCo          
98 98 01-CA-28025-002 0 2000-08-03T00:00:00 Dismi PreCo          
99 99 01-CA-28025-003 0 2000-08-03T00:00:00 Dismi PreCo          
100 100 01-CA-28064-001 0 2000-04-19T00:00:00 Adj ACBH          

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_closing" (
    "c_case_number" text,
    "action_sequence" integer,
    "date_closed" text,
    "close_method" text,
    "close_timing" text,
    "date_file_sent_archives" text,
    "date_file_to_records" text,
    "date_file_destroyed" text,
    "preclosing_letter" text,
    "notice_of_closing_date" text
);