c_advice

6,770 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ c_case_number action_sequence recurrence advice_submission advice_rcvd_submission advice_scope advice_memo_date advice_deter_rcvd_reg file_received_advice
1 1 01-CA-19731-001 0 0 1982-04-13T00:00:00     1983-02-04T00:00:00 1983-02-07T00:00:00  
2 2 01-CA-19903-001 0 0       1983-02-04T00:00:00 1983-02-07T00:00:00  
3 3 01-CA-20007-001 0 0       1983-02-04T00:00:00 1983-02-07T00:00:00  
4 4 01-CA-20157-001 0 0       1983-02-04T00:00:00 1983-02-07T00:00:00  
5 5 01-CA-20218-001 0 0       1983-02-04T00:00:00 1983-02-07T00:00:00  
6 6 01-CA-20442-001 0 0       1983-02-04T00:00:00 1983-02-07T00:00:00  
7 7 01-CA-20521-001 0 0       1983-02-04T00:00:00 1983-02-07T00:00:00  
8 8 01-CA-21438-001 0 0       1983-02-04T00:00:00 1983-02-07T00:00:00  
9 9 01-CA-22769-001 0 0 1986-04-16T00:00:00   Full 1986-05-02T00:00:00    
10 10 01-CA-25940-001 0 0 1989-01-25T00:00:00   Full 1989-08-18T00:00:00   1989-08-23T00:00:00
11 11 01-CA-26820-001 0 0 1989-12-29T00:00:00 1989-12-30T00:00:00 Full 1991-03-20T00:00:00 1991-03-21T00:00:00 1989-12-30T00:00:00
12 12 01-CA-28590-001 0 0 1991-12-23T00:00:00   Full 1992-02-20T00:00:00 1992-02-25T00:00:00  
13 13 01-CA-29631-001 0 0 1992-12-23T00:00:00          
14 14 01-CA-29757-001 0 0 1992-12-23T00:00:00          
15 15 01-CA-29966-001 0 0 1993-01-28T00:00:00   Full 1993-04-26T00:00:00 1993-04-28T00:00:00  
16 16 01-CA-30063-001 0 0       1993-04-26T00:00:00 1993-04-28T00:00:00  
17 17 01-CA-30374-001 0 0 1993-07-28T00:00:00   Full 1993-09-08T00:00:00    
18 18 01-CA-30630-001 0 0 1993-07-28T00:00:00   Full 1993-09-08T00:00:00    
19 19 01-CA-30745-001 0 0 1996-12-24T00:00:00   Full 1997-04-29T00:00:00    
20 20 01-CA-32158-001 0 0 1995-02-22T00:00:00   Full 1995-08-21T00:00:00    
21 21 01-CA-32169-001 0 0 1994-12-28T00:00:00   Full 1995-01-05T00:00:00 1995-01-10T00:00:00  
22 22 01-CA-32170-001 0 0 1994-12-28T00:00:00   Full 1995-01-05T00:00:00 1995-01-10T00:00:00  
23 23 01-CA-32248-001 0 0 1995-02-22T00:00:00   Full 1995-08-21T00:00:00    
24 24 01-CA-32393-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
25 25 01-CA-32742-001 0 0 1995-12-12T00:00:00   Full 1996-04-30T00:00:00    
26 26 01-CA-32767-001 0 0 1995-12-12T00:00:00   Full 1996-04-30T00:00:00    
27 27 01-CA-32952-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
28 28 01-CA-32953-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
29 29 01-CA-32954-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
30 30 01-CA-32965-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
31 31 01-CA-32966-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
32 32 01-CA-32991-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
33 33 01-CA-33016-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
34 34 01-CA-33023-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
35 35 01-CA-33024-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
36 36 01-CA-33025-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
37 37 01-CA-33026-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
38 38 01-CA-33044-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
39 39 01-CA-33045-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
40 40 01-CA-33046-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
41 41 01-CA-33047-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
42 42 01-CA-33050-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
43 43 01-CA-33050-002 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
44 44 01-CA-33214-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
45 45 01-CA-33216-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
46 46 01-CA-33217-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
47 47 01-CA-33218-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
48 48 01-CA-33536-001 0 0 1996-02-29T00:00:00   Full 1996-07-19T00:00:00    
49 49 01-CA-34278-001 0 0 1996-10-28T00:00:00   Full 1997-03-07T00:00:00 1997-03-12T00:00:00  
50 50 01-CA-34338-001 0 0 1997-02-28T00:00:00   Full 1997-04-07T00:00:00    
51 51 01-CA-35110-001 0 0 1997-06-06T00:00:00 1997-06-07T00:00:00 Part 1997-06-11T00:00:00 1997-06-23T00:00:00  
52 52 01-CA-35198-001 0 0 1997-06-06T00:00:00 1997-06-07T00:00:00 Part 1997-06-19T00:00:00 1997-06-23T00:00:00  
53 53 01-CA-36226-001 0 0 1999-01-05T00:00:00   Full 1999-02-01T00:00:00 1999-02-04T00:00:00  
54 54 01-CA-36251-001 0 0 1999-01-29T00:00:00   Full 1999-02-26T00:00:00 1999-03-03T00:00:00  
55 55 01-CA-36484-001 0 0 1998-09-22T00:00:00   Full 1998-10-19T00:00:00 1998-10-19T00:00:00  
56 56 01-CA-36606-001 0 0 1998-11-16T00:00:00   Full 1999-01-15T00:00:00 1999-01-21T00:00:00  
57 57 01-CA-36607-001 0 0 1998-12-16T00:00:00   Full 1999-01-15T00:00:00 1999-01-21T00:00:00  
58 58 01-CA-36635-001 0 0 1999-01-29T00:00:00   Part 1999-02-26T00:00:00 1999-03-03T00:00:00  
59 59 01-CA-36774-001 0 0 1999-04-29T00:00:00   Full 1999-06-03T00:00:00 1999-06-09T00:00:00  
60 60 01-CA-36774-001 1 0 1999-08-25T00:00:00   Full 1999-10-14T00:00:00 1999-10-14T00:00:00  
61 61 01-CA-36875-001 0 0            
62 62 01-CA-36933-001 0 0            
63 63 01-CA-36945-001 0 0 1999-08-25T00:00:00   Full 1999-10-14T00:00:00 1999-10-14T00:00:00  
64 64 01-CA-37018-001 0 0 1999-05-11T00:00:00   Full 1999-07-02T00:00:00 1999-07-02T00:00:00  
65 65 01-CA-37022-001 0 0 1999-05-11T00:00:00   Full 1999-07-02T00:00:00 1999-07-02T00:00:00  
66 66 01-CA-37057-001 0 0 1999-09-03T00:00:00   Full 1999-09-28T00:00:00 1999-10-04T00:00:00  
67 67 01-CA-37058-001 0 0 1999-04-30T00:00:00   Full 1999-06-25T00:00:00 1999-06-25T00:00:00  
68 68 01-CA-37095-001 0 0 1999-05-28T00:00:00   Full 1999-06-25T00:00:00 1999-06-28T00:00:00  
69 69 01-CA-37149-001 0 0 1999-05-11T00:00:00   Full 1999-07-02T00:00:00 1999-07-02T00:00:00  
70 70 01-CA-37256-001 0 0 1999-09-30T00:00:00   Full 1999-10-28T00:00:00    
71 71 01-CA-37282-001 0 0 1999-08-25T00:00:00   Full 1999-10-14T00:00:00 1999-10-14T00:00:00  
72 72 01-CA-37283-001 0 0 1999-08-25T00:00:00   Full 1999-10-14T00:00:00 1999-10-14T00:00:00  
73 73 01-CA-37300-001 0 0 1999-10-15T00:00:00   Full 1999-11-01T00:00:00 1999-11-08T00:00:00  
74 74 01-CA-37354-001 0 0 2000-01-24T00:00:00   Full 2000-03-31T00:00:00 2000-04-03T00:00:00  
75 75 01-CA-37411-001 0 0 2000-05-12T00:00:00   Full 2000-07-27T00:00:00 2000-08-01T00:00:00  
76 76 01-CA-37453-001 0 0 1999-11-05T00:00:00   Full 1999-12-13T00:00:00 1999-12-20T00:00:00  
77 77 01-CA-37465-001 0 0 2000-02-17T00:00:00   Full 2000-05-16T00:00:00 2000-05-19T00:00:00  
78 78 01-CA-37490-001 0 0 1999-12-23T00:00:00   Full 2000-02-24T00:00:00 2000-02-29T00:00:00  
79 79 01-CA-37501-001 0 0 1999-10-15T00:00:00   Full 1999-11-01T00:00:00 1999-11-08T00:00:00  
80 80 01-CA-37535-001 0 0 2000-02-02T00:00:00   Full      
81 81 01-CA-37682-001 0 0 2000-02-04T00:00:00 2000-02-04T00:00:00 Full 2000-03-24T00:00:00 2000-03-24T00:00:00  
82 82 01-CA-37743-001 0 0 2001-04-26T00:00:00   Full 2001-08-31T00:00:00 2001-09-04T00:00:00  
83 83 01-CA-37743-001 0 1       2001-09-25T00:00:00 2001-09-27T00:00:00  
84 84 01-CA-37763-001 0 0 2000-05-18T00:00:00   Full 2000-08-21T00:00:00 2000-08-23T00:00:00  
85 85 01-CA-37769-001 0 0 2000-02-04T00:00:00 2000-02-04T00:00:00 Full 2000-03-24T00:00:00 2000-03-24T00:00:00  
86 86 01-CA-37811-001 0 0 2000-02-25T00:00:00   Full 2000-03-02T00:00:00 2000-03-07T00:00:00  
87 87 01-CA-37828-001 0 0 2000-02-25T00:00:00   Full 2000-03-02T00:00:00 2000-03-07T00:00:00  
88 88 01-CA-37857-001 0 0 2000-04-25T00:00:00   Full 2000-05-15T00:00:00 2000-05-17T00:00:00  
89 89 01-CA-37875-001 0 0 2000-02-25T00:00:00   Full 2000-03-02T00:00:00 2000-03-07T00:00:00  
90 90 01-CA-37925-001 0 0 2000-06-29T00:00:00   Full 2000-07-18T00:00:00 2000-07-21T00:00:00  
91 91 01-CA-37931-001 0 0 2000-02-25T00:00:00   Full 2000-03-02T00:00:00 2000-03-07T00:00:00  
92 92 01-CA-37961-001 0 0 2000-06-29T00:00:00   Full 2000-07-18T00:00:00 2000-07-21T00:00:00  
93 93 01-CA-37988-001 0 0 2000-05-10T00:00:00   Full 2000-06-16T00:00:00 2000-06-19T00:00:00  
94 94 01-CA-38118-001 0 0 2000-07-18T00:00:00   Full 2000-10-30T00:00:00 2000-11-02T00:00:00  
95 95 01-CA-38239-001 0 0 2000-07-05T00:00:00   Full      
96 96 01-CA-38276-001 0 0 2001-02-28T00:00:00   Full 2001-08-17T00:00:00 2001-08-22T00:00:00  
97 97 01-CA-38400-001 0 0 2001-02-28T00:00:00   Full 2001-08-17T00:00:00 2001-08-22T00:00:00  
98 98 01-CA-38508-001 0 0 2000-11-14T00:00:00   Full 2000-12-26T00:00:00 2001-01-02T00:00:00  
99 99 01-CA-38571-001 0 0 2001-02-16T00:00:00 2001-02-20T00:00:00 Full 2001-03-21T00:00:00 2001-03-26T00:00:00  
100 100 01-CA-38647-001 0 0 2001-11-30T00:00:00   Full 2001-12-10T00:00:00 2001-12-10T00:00:00  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_advice" (
    "c_case_number" text,
    "action_sequence" integer,
    "recurrence" integer,
    "advice_submission" text,
    "advice_rcvd_submission" text,
    "advice_scope" text,
    "advice_memo_date" text,
    "advice_deter_rcvd_reg" text,
    "file_received_advice" text
);