c_deferral

75,639 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ c_case_number action_sequence recurrence request_party request_received scope date_deferral_issued deferral_type date_deferral_checked date_deferral_extended willingness_date willingness_type date_processing_resumed
1 1 01-CA-26604-001 0 0     FULL 1989-10-10T00:00:00 Coll         2001-08-06T00:00:00
2 2 01-CA-27684-001 0 0     FULL 1990-11-15T00:00:00 Dubo         2001-09-19T00:00:00
3 3 01-CA-27852-001 0 0     FULL 1991-01-16T00:00:00 Coll         2001-09-19T00:00:00
4 4 01-CA-28025-001 0 0     FULL 1991-04-02T00:00:00 Coll 2000-04-18T00:00:00 2000-05-02T00:00:00     2000-06-21T00:00:00
5 5 01-CA-28025-002 0 0     FULL 1991-04-02T00:00:00 Coll 2000-04-18T00:00:00 2000-05-02T00:00:00      
6 6 01-CA-28025-003 0 0     FULL 1991-04-02T00:00:00 Coll 2000-04-18T00:00:00 2000-05-02T00:00:00      
7 7 01-CA-28184-001 0 0     FULL 1991-05-24T00:00:00 Coll         2001-09-19T00:00:00
8 8 01-CA-28751-001 0 0       1991-11-22T00:00:00 Coll 1992-08-04T00:00:00        
9 9 01-CA-28751-001 0 1           1993-10-13T00:00:00        
10 10 01-CA-28751-001 0 2           1996-05-31T00:00:00        
11 11 01-CA-28751-001 0 3           1997-02-25T00:00:00 1997-03-11T00:00:00      
12 12 01-CA-29186-001 0 0     FULL 1992-04-24T00:00:00 Dubo 1997-02-24T00:00:00 1997-03-10T00:00:00      
13 13 01-CA-29186-001 0 1           2000-04-20T00:00:00 2000-05-04T00:00:00      
14 14 01-CA-29189-001 0 0     FULL 1992-04-29T00:00:00 Coll         2001-09-19T00:00:00
15 15 01-CA-29627-001 0 0     FULL 1992-09-29T00:00:00 Coll         2002-03-21T00:00:00
16 16 01-CA-29743-001 0 0     PART 1992-11-02T00:00:00 Coll          
17 17 01-CA-29756-001 0 0     FULL 1992-11-05T00:00:00 Coll         2001-08-30T00:00:00
18 18 01-CA-30013-001 0 0       1993-11-19T00:00:00 Coll          
19 19 01-CA-30099-001 0 0     FULL 1993-02-19T00:00:00 Coll          
20 20 01-CA-30181-002 0 0       1993-03-12T00:00:00 Dubo          
21 21 01-CA-30292-001 0 0     FULL 1993-04-13T00:00:00 Coll         1993-11-22T00:00:00
22 22 01-CA-30347-001 0 0     PART 1993-06-30T00:00:00 Coll          
23 23 01-CA-30354-001 0 0     FULL 1993-05-11T00:00:00 Coll         2001-09-19T00:00:00
24 24 01-CA-30556-001 0 0       1993-07-07T00:00:00 Coll          
25 25 01-CA-30568-001 0 0     FULL 1993-08-02T00:00:00 Coll         1999-12-28T00:00:00
26 26 01-CA-30629-001 0 0     FULL 1993-08-04T00:00:00 Coll         2002-02-06T00:00:00
27 27 01-CA-30996-001 0 0     FULL 1993-11-29T00:00:00 Other          
28 28 01-CA-31084-002 0 0       1993-12-16T00:00:00 Coll 1999-03-16T00:00:00 1999-03-30T00:00:00      
29 29 01-CA-31123-001 0 0     FULL 1993-12-28T00:00:00 Coll         2002-02-25T00:00:00
30 30 01-CA-31160-002 0 0     FULL 1994-01-26T00:00:00 Coll          
31 31 01-CA-31277-001 0 0       1994-02-17T00:00:00 Coll          
32 32 01-CA-31277-001 1 0     FULL 1994-02-17T00:00:00 Coll          
33 33 01-CA-31374-001 0 0     FULL 1994-03-22T00:00:00 Coll         2001-08-28T00:00:00
34 34 01-CA-31566-001 0 0       1994-05-25T00:00:00 Coll          
35 35 01-CA-31708-001 0 0     FULL 1994-07-08T00:00:00 Coll 1999-03-18T00:00:00        
36 36 01-CA-31708-001 1 0     FULL 1994-07-08T00:00:00 Coll          
37 37 01-CA-31722-001 0 0       1994-07-12T00:00:00 Coll 1999-03-18T00:00:00 1999-04-01T00:00:00      
38 38 01-CA-31722-001 1 0     FULL 1994-07-12T00:00:00 Coll          
39 39 01-CA-31804-001 0 0     FULL 1994-07-26T00:00:00 Coll         2002-04-26T00:00:00
40 40 01-CA-31821-001 0 0     FULL 1994-08-08T00:00:00 Coll 1999-03-18T00:00:00 1999-04-01T00:00:00      
41 41 01-CA-31874-001 0 0       1994-08-11T00:00:00 Coll          
42 42 01-CA-32082-001 0 0       1994-10-26T00:00:00 Coll          
43 43 01-CA-32128-001 0 0       1994-11-04T00:00:00 Coll 1999-03-26T00:00:00 1999-04-09T00:00:00      
44 44 01-CA-32140-001 0 0       1994-11-30T00:00:00 Coll          
45 45 01-CA-32229-001 0 0     FULL 1994-12-13T00:00:00 Coll         2001-08-28T00:00:00
46 46 01-CA-32233-002 0 0       1994-12-16T00:00:00 Coll          
47 47 01-CA-32261-001 0 0     FULL 1994-12-14T00:00:00 Coll         2002-03-21T00:00:00
48 48 01-CA-32327-001 0 0     FULL 1995-01-13T00:00:00 Coll 2004-06-21T00:00:00       2005-03-16T00:00:00
49 49 01-CA-32327-001 0 1           2005-03-16T00:00:00        
50 50 01-CA-32329-001 0 0       1995-01-30T00:00:00 Coll          
51 51 01-CA-32456-001 0 0       1995-02-13T00:00:00 Coll          
52 52 01-CA-32493-001 0 0     FULL 1995-10-12T00:00:00 ERISA         2004-01-15T00:00:00
53 53 01-CA-32557-001 0 0     FULL 1995-03-24T00:00:00 Coll          
54 54 01-CA-32558-001 0 0     FULL 1995-03-13T00:00:00 Dubo         1999-12-20T00:00:00
55 55 01-CA-32570-001 0 0     FULL 1995-03-07T00:00:00 Coll          
56 56 01-CA-32601-001 0 0       1995-03-30T00:00:00 Coll          
57 57 01-CA-32609-001 0 0       1995-05-04T00:00:00 Coll 1999-03-18T00:00:00 1999-04-01T00:00:00      
58 58 01-CA-32609-002 0 0       1995-05-04T00:00:00 Coll 1999-03-18T00:00:00 1999-04-01T00:00:00      
59 59 01-CA-32627-001 0 0     FULL 1995-04-03T00:00:00 Coll         2003-01-02T00:00:00
60 60 01-CA-32660-002 0 0     FULL 1995-04-12T00:00:00 Coll          
61 61 01-CA-32741-001 0 0       1995-04-28T00:00:00 Coll          
62 62 01-CA-32824-001 0 0       1995-05-23T00:00:00 Coll          
63 63 01-CA-32861-001 0 0     FULL 1995-05-17T00:00:00 Coll          
64 64 01-CA-32875-001 0 0       1995-05-31T00:00:00 Coll          
65 65 01-CA-32884-001 0 0       1995-06-07T00:00:00 Coll          
66 66 01-CA-32948-001 0 0       1995-06-14T00:00:00 Coll          
67 67 01-CA-32986-001 0 0       1995-07-11T00:00:00 Dubo 1999-04-08T00:00:00 1999-04-22T00:00:00      
68 68 01-CA-33040-001 0 0     FULL 1995-07-28T00:00:00 Coll 1997-09-16T00:00:00 1997-09-30T00:00:00      
69 69 01-CA-33040-001 0 1           1999-04-12T00:00:00 1999-04-26T00:00:00      
70 70 01-CA-33064-001 0 0     FULL 1995-07-24T00:00:00 Coll 1996-05-31T00:00:00 1996-06-14T00:00:00      
71 71 01-CA-33104-001 0 0       1995-08-09T00:00:00 Coll          
72 72 01-CA-33203-001 0 0       1995-09-01T00:00:00 Coll 1997-05-30T00:00:00 1997-06-13T00:00:00      
73 73 01-CA-33203-001 0 1           1999-04-12T00:00:00 1999-04-26T00:00:00      
74 74 01-CA-33275-001 0 0     FULL 1995-10-26T00:00:00 OSHA         2003-11-14T00:00:00
75 75 01-CA-33300-001 0 0     FULL 1995-09-29T00:00:00 Coll          
76 76 01-CA-33334-001 0 0     FULL 1995-10-20T00:00:00 Coll 1999-04-07T00:00:00 1999-04-21T00:00:00      
77 77 01-CA-33400-001 0 0       1995-11-07T00:00:00 Other          
78 78 01-CA-33409-001 0 0       1995-11-07T00:00:00 Coll          
79 79 01-CA-33417-001 0 0       1995-11-06T00:00:00 Coll 1996-10-21T00:00:00 1996-11-04T00:00:00      
80 80 01-CA-33417-001 0 1           1999-02-05T00:00:00        
81 81 01-CA-33427-001 0 0     FULL 1996-02-28T00:00:00 Coll 1997-05-30T00:00:00 1997-06-13T00:00:00     2002-04-09T00:00:00
82 82 01-CA-33427-001 0 1           1999-04-07T00:00:00 1999-04-21T00:00:00      
83 83 01-CA-33427-001 0 2           2002-03-14T00:00:00 2002-03-28T00:00:00      
84 84 01-CA-33440-001 0 0     FULL 1995-11-21T00:00:00 Coll         2002-04-11T00:00:00
85 85 01-CA-33457-001 0 0     FULL 1995-11-30T00:00:00 Coll 1999-04-07T00:00:00 1999-04-21T00:00:00      
86 86 01-CA-33475-001 0 0     FULL 1995-11-28T00:00:00 Other         2000-03-16T00:00:00
87 87 01-CA-33522-001 0 0       1995-12-15T00:00:00 Coll 1997-05-13T00:00:00 1999-05-27T00:00:00      
88 88 01-CA-33549-001 0 0       1996-01-24T00:00:00 Coll          
89 89 01-CA-33582-001 0 0       1996-02-20T00:00:00 Coll          
90 90 01-CA-33645-001 0 0     FULL 1996-03-05T00:00:00 Coll 1997-07-28T00:00:00 1997-08-11T00:00:00     2002-04-12T00:00:00
91 91 01-CA-33645-001 0 1           1999-04-07T00:00:00 1999-04-21T00:00:00      
92 92 01-CA-33645-001 0 2           2002-03-20T00:00:00 2002-04-03T00:00:00      
93 93 01-CA-33646-001 0 0       1996-03-25T00:00:00 Coll     1996-02-05T00:00:00    
94 94 01-CA-33650-001 0 0     FULL 1996-02-27T00:00:00 Coll         2000-05-23T00:00:00
95 95 01-CA-33687-001 0 0     FULL 1996-02-21T00:00:00 Coll 2002-03-20T00:00:00 2002-04-03T00:00:00     2002-04-12T00:00:00
96 96 01-CA-33689-001 0 0       1996-03-27T00:00:00 Dubo 1997-02-24T00:00:00 1997-03-10T00:00:00      
97 97 01-CA-33689-001 0 1           1999-04-12T00:00:00 1999-04-26T00:00:00      
98 98 01-CA-33716-001 0 0       1996-02-22T00:00:00 Coll     1996-02-01T00:00:00    
99 99 01-CA-33751-001 0 0     FULL 1996-03-20T00:00:00 Coll 2002-03-13T00:00:00 2002-03-26T00:00:00     2002-04-09T00:00:00
100 100 01-CA-33758-001 0 0     FULL 1996-05-08T00:00:00 Coll         2002-03-21T00:00:00

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_deferral" (
    "c_case_number" text,
    "action_sequence" integer,
    "recurrence" integer,
    "request_party" text,
    "request_received" text,
    "scope" text,
    "date_deferral_issued" text,
    "deferral_type" text,
    "date_deferral_checked" text,
    "date_deferral_extended" text,
    "willingness_date" text,
    "willingness_type" text,
    "date_processing_resumed" text
);