c_complaint

43,079 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ c_case_number action_sequence recurrence issued contain_noh answer_to_complaint date_of_withdrawal_order
1 1 01-CA-19224-001 0 0 1983-12-07T00:00:00 Y 1984-01-23T00:00:00  
2 2 01-CA-19567-001 0 0 1983-12-07T00:00:00 Y 1984-01-23T00:00:00  
3 3 01-CA-19690-001 0 0 1983-12-07T00:00:00 Y 1984-01-23T00:00:00  
4 4 01-CA-19731-001 0 0 1982-05-12T00:00:00      
5 5 01-CA-19797-001 0 0 1982-05-07T00:00:00      
6 6 01-CA-19903-001 0 0 1982-07-07T00:00:00      
7 7 01-CA-19958-001 0 0 1983-12-07T00:00:00 Y 1984-01-23T00:00:00  
8 8 01-CA-20007-001 0 0 1982-08-09T00:00:00      
9 9 01-CA-20157-001 0 0 1982-10-22T00:00:00      
10 10 01-CA-20218-001 0 0 1982-10-22T00:00:00      
11 11 01-CA-20283-001 0 0 1983-12-07T00:00:00 Y 1983-12-19T00:00:00  
12 12 01-CA-20291-001 0 0 1983-12-07T00:00:00   1984-01-23T00:00:00  
13 13 01-CA-20304-001 0 0 1983-12-07T00:00:00      
14 14 01-CA-20442-001 0 0 1983-01-28T00:00:00      
15 15 01-CA-20508-001 0 0 1983-12-07T00:00:00   1984-01-23T00:00:00  
16 16 01-CA-20521-001 0 0 1983-01-28T00:00:00      
17 17 01-CA-21438-001 0 0 1983-11-17T00:00:00      
18 18 01-CA-21560-001 0 0 1983-12-07T00:00:00   1984-01-23T00:00:00  
19 19 01-CA-21943-001 0 0 1988-01-29T00:00:00   1988-11-07T00:00:00  
20 20 01-CA-22040-002 0 0 1984-06-15T00:00:00 Y 1992-03-02T00:00:00  
21 21 01-CA-22687-001 0 0 1985-03-18T00:00:00      
22 22 01-CA-22769-001 0 0 1985-04-19T00:00:00   1986-02-14T00:00:00  
23 23 01-CA-22869-001 0 0 1985-12-09T00:00:00      
24 24 01-CA-23307-001 0 0 1988-01-29T00:00:00 Y 1988-11-07T00:00:00  
25 25 01-CA-23427-001 0 0 1986-01-03T00:00:00 Y 2000-10-31T00:00:00  
26 26 01-CA-23576-001 0 0 1986-04-30T00:00:00   1988-09-01T00:00:00  
27 27 01-CA-23748-001 0 0 1988-01-29T00:00:00   1998-11-07T00:00:00  
28 28 01-CA-24161-001 0 0 1988-01-29T00:00:00   1988-11-07T00:00:00  
29 29 01-CA-24372-001 0 0 1987-01-09T00:00:00   1987-04-03T00:00:00  
30 30 01-CA-24390-002 0 0 1988-01-29T00:00:00   1988-11-07T00:00:00  
31 31 01-CA-24528-001 0 0 1988-01-29T00:00:00 Y 1988-11-07T00:00:00  
32 32 01-CA-24863-001 0 0 1987-10-06T00:00:00      
33 33 01-CA-24883-001 0 0 1987-10-06T00:00:00   1987-10-19T00:00:00  
34 34 01-CA-24921-001 0 0 1988-01-29T00:00:00   1988-11-07T00:00:00  
35 35 01-CA-24967-001 0 0 1990-09-27T00:00:00      
36 36 01-CA-25033-001 0 0 1988-01-29T00:00:00   1988-11-07T00:00:00  
37 37 01-CA-25237-001 0 0 1988-04-27T00:00:00   1998-06-24T00:00:00  
38 38 01-CA-25237-002 0 0 1988-06-16T00:00:00   1988-06-24T00:00:00  
39 39 01-CA-25341-001 0 0 1988-06-16T00:00:00   1988-11-07T00:00:00  
40 40 01-CA-25521-001 0 0 1988-07-18T00:00:00 Y 1988-08-16T00:00:00  
41 41 01-CA-25599-001 0 0 1988-08-17T00:00:00   1988-09-01T00:00:00  
42 42 01-CA-25656-001 0 0 1988-09-02T00:00:00   1988-09-19T00:00:00  
43 43 01-CA-25656-001 1 0 1989-04-28T00:00:00 Y 1989-06-15T00:00:00  
44 44 01-CA-25736-001 0 0 1988-09-29T00:00:00      
45 45 01-CA-25805-001 0 0 1988-11-18T00:00:00      
46 46 01-CA-25864-001 0 0 1989-01-31T00:00:00 Y 1989-02-10T00:00:00  
47 47 01-CA-25867-001 0 0 1988-12-16T00:00:00   1988-12-22T00:00:00  
48 48 01-CA-25896-001 0 0 1989-01-23T00:00:00 N    
49 49 01-CA-25940-001 0 0 1989-09-11T00:00:00 Y    
50 50 01-CA-25969-001 0 0 1989-01-20T00:00:00      
51 51 01-CA-26144-001 0 0 1989-04-28T00:00:00   1989-06-15T00:00:00  
52 52 01-CA-26183-001 0 0 1989-04-20T00:00:00      
53 53 01-CA-26232-001 0 0 1989-05-23T00:00:00   1989-06-05T00:00:00  
54 54 01-CA-26237-001 0 0 1989-05-23T00:00:00   1989-06-05T00:00:00  
55 55 01-CA-26270-001 0 0 1989-05-12T00:00:00      
56 56 01-CA-26353-001 0 0 1989-06-14T00:00:00      
57 57 01-CA-26463-001 0 0 1989-10-06T00:00:00 Y 1989-10-26T00:00:00  
58 58 01-CA-26463-002 0 0 1989-10-06T00:00:00 Y 1989-10-26T00:00:00  
59 59 01-CA-26463-003 0 0 1989-10-06T00:00:00 Y 1989-10-26T00:00:00  
60 60 01-CA-26463-004 0 0 1989-10-06T00:00:00 Y 1989-10-26T00:00:00  
61 61 01-CA-26463-005 0 0 1989-10-06T00:00:00 Y 1989-10-26T00:00:00  
62 62 01-CA-26463-006 0 0 1989-10-06T00:00:00 Y 1989-10-26T00:00:00  
63 63 01-CA-26573-001 0 0 1989-10-27T00:00:00   1989-11-17T00:00:00  
64 64 01-CA-26575-001 0 0 1989-10-06T00:00:00 Y 1989-11-09T00:00:00  
65 65 01-CA-26744-001 0 0 1989-12-26T00:00:00 Y 1990-02-28T00:00:00  
66 66 01-CA-26820-001 0 0 1991-04-11T00:00:00   1991-04-29T00:00:00  
67 67 01-CA-26936-001 0 0 1990-01-29T00:00:00   1990-03-01T00:00:00  
68 68 01-CA-27014-001 0 0 1990-03-05T00:00:00 Y 1990-03-29T00:00:00  
69 69 01-CA-27070-001 0 0 1990-04-30T00:00:00 Y 1990-05-10T00:00:00  
70 70 01-CA-27142-001 0 0 1991-03-22T00:00:00   1991-09-12T00:00:00  
71 71 01-CA-27321-001 0 0 1990-06-28T00:00:00      
72 72 01-CA-27322-001 0 0 1990-06-28T00:00:00 Y 1990-10-05T00:00:00  
73 73 01-CA-27335-001 0 0 1990-07-06T00:00:00 Y 1990-10-29T00:00:00  
74 74 01-CA-27356-001 0 0 1990-07-18T00:00:00      
75 75 01-CA-27385-001 0 0 1990-07-25T00:00:00   1990-10-05T00:00:00  
76 76 01-CA-27386-001 0 0 1990-07-26T00:00:00      
77 77 01-CA-27417-001 0 0 1990-08-02T00:00:00      
78 78 01-CA-27421-001 0 0 1990-08-29T00:00:00 Y    
79 79 01-CA-27491-001 0 0 1990-10-30T00:00:00 Y 1990-11-04T00:00:00  
80 80 01-CA-27506-001 0 0 1990-10-04T00:00:00      
81 81 01-CA-27659-001 0 0 1990-12-12T00:00:00 Y 1990-12-21T00:00:00  
82 82 01-CA-27731-001 0 0 1990-11-30T00:00:00      
83 83 01-CA-27732-001 0 0 1991-02-21T00:00:00 Y 1991-03-04T00:00:00  
84 84 01-CA-27732-002 0 0 1991-02-21T00:00:00 Y 1991-03-04T00:00:00  
85 85 01-CA-27766-001 0 0 1991-01-29T00:00:00   1991-02-12T00:00:00  
86 86 01-CA-27800-001 0 0 1990-12-20T00:00:00   1991-01-04T00:00:00  
87 87 01-CA-27879-001 0 0 1991-01-25T00:00:00   1991-02-08T00:00:00  
88 88 01-CA-27908-001 0 0 1991-02-05T00:00:00      
89 89 01-CA-27937-001 0 0 1991-02-22T00:00:00 Y 1991-03-04T00:00:00  
90 90 01-CA-27953-001 0 0 1991-02-27T00:00:00      
91 91 01-CA-28064-001 0 0 1991-04-11T00:00:00 Y 1991-10-01T00:00:00  
92 92 01-CA-28250-001 0 0 1991-06-24T00:00:00      
93 93 01-CA-28264-001 0 0 1991-06-11T00:00:00 N    
94 94 01-CA-28297-001 0 0 1991-08-07T00:00:00   1991-08-22T00:00:00  
95 95 01-CA-28298-001 0 0 1991-08-07T00:00:00      
96 96 01-CA-28315-001 0 0 1991-08-13T00:00:00 Y 1991-08-27T00:00:00  
97 97 01-CA-28348-001 0 0 1991-09-19T00:00:00   1991-10-09T00:00:00  
98 98 01-CA-28375-001 0 0 1991-07-24T00:00:00   1991-08-06T00:00:00  
99 99 01-CA-28375-001 1 0 1992-03-25T00:00:00 Y 1992-04-08T00:00:00  
100 100 01-CA-28376-001 0 0 1991-07-31T00:00:00 Y 1991-08-12T00:00:00  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_complaint" (
    "c_case_number" text,
    "action_sequence" integer,
    "recurrence" integer,
    "issued" text,
    "contain_noh" text,
    "answer_to_complaint" text,
    "date_of_withdrawal_order" text
);