c_transfer_history

19,325 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ c_case_number history_date sequence date_data_received request_date reason_transfer transfer_type transfer_order_date new_case_number former_case_number sent_date received_date
1 1 01-CA-27321-001 1999-08-06T10:11:00 0                  
2 2 01-CA-27879-001 1999-11-30T08:00:00 0                  
3 3 01-CA-30745-001 2004-11-04T14:40:00 0                  
4 4 01-CA-36746-001 1999-05-25T15:15:00 0                  
5 5 01-CA-36965-001 1999-12-14T16:16:00 0                  
6 6 01-CA-37108-001 1999-04-21T16:25:00 0                  
7 7 01-CA-37458-001 2001-04-05T09:52:00 0                  
8 8 01-CA-37495-001 1999-10-18T16:03:00 0                  
9 9 01-CA-37595-001 2000-01-10T12:20:00 0                  
10 10 01-CA-37612-001 1999-09-27T15:10:00 0                  
11 11 01-CA-38184-001 2000-05-30T13:01:00 0                  
12 12 01-CA-38460-001 2000-11-20T14:33:00 0                  
13 13 01-CA-39040-001 2001-05-02T14:53:00 0 2001-05-02T16:15:00 2001-05-01T00:00:00 Other Perm 2001-05-02T00:00:00 01-CA-39040-001 34-CA-09672-001 2001-05-02T00:00:00  
14 14 01-CA-39040-001 2001-05-02T16:04:00 1                  
15 15 01-CA-39082-001 2001-05-22T15:46:00 0 2001-05-22T17:30:00 2001-05-15T00:00:00 Other Perm 2001-05-22T00:00:00 01-CA-39082-001 34-CA-09687-001 2001-05-22T00:00:00  
16 16 01-CA-39082-001 2001-05-22T17:11:00 1                 2001-05-23T00:00:00
17 17 01-CA-39180-001 2001-07-06T15:04:00 0 2001-07-06T17:00:00 2001-07-05T00:00:00 Other Perm 2001-07-06T00:00:00 01-CA-39180-001 34-CA-09719-001 2001-07-06T00:00:00  
18 18 01-CA-39180-001 2001-07-06T16:52:00 1                  
19 19 01-CA-39195-001 2004-02-02T08:38:00 0                  
20 20 01-CA-39471-001 2005-05-05T11:42:00 0                  
21 21 01-CA-39516-001 2001-12-07T13:20:00 0 2001-12-07T16:15:00 2001-11-29T00:00:00 Other Perm 2001-12-07T00:00:00 01-CA-39516-001 05-CA-28886-001    
22 22 01-CA-39516-001 2001-12-07T16:08:00 1                 2001-12-07T00:00:00
23 23 01-CA-39517-001 2001-12-07T16:08:00 0 2001-12-07T16:15:00 2001-11-29T00:00:00 Other Perm 2001-12-07T00:00:00 01-CA-39517-001 05-CA-28958-001    
24 24 01-CA-39517-001 2001-12-07T16:10:00 1                  
25 25 01-CA-39646-001 2002-02-25T16:17:00 0                  
26 26 01-CA-40505-001 2005-08-11T11:13:00 0                  
27 27 01-CA-40690-001 2003-08-27T13:51:00 0                  
28 28 01-CA-41061-001 2005-08-22T08:36:00 0                  
29 29 01-CA-41110-001 2004-09-30T16:47:00 0                  
30 30 01-CA-41132-001 2003-08-01T10:46:00 0 2003-08-01T11:00:00 2003-07-31T00:00:00 Other Perm 2003-07-31T00:00:00 01-CA-41132-001 34-CA-10557-001 2003-07-31T00:00:00  
31 31 01-CA-41132-001 2003-08-01T10:51:00 1                 2003-08-06T00:00:00
32 32 01-CA-41199-001 2004-02-24T14:12:00 0                  
33 33 01-CA-41207-001 2005-08-22T09:26:00 0                  
34 34 01-CA-41272-001 2003-10-01T10:05:00 0 2003-10-01T14:30:00 2003-10-01T00:00:00 Other Perm 2003-10-01T00:00:00 01-CA-41272-001 03-CA-24464-001 2003-10-01T00:00:00  
35 35 01-CA-41272-001 2003-10-01T14:15:00 1                  
36 36 01-CA-41768-001 2010-05-11T12:44:00 0                  
37 37 01-CA-42005-001 2004-08-18T09:08:00 0 2004-08-18T09:15:00 2004-08-18T00:00:00 Geogr Perm 2004-08-18T00:00:00 01-CA-42005-001 04-CA-33191-001    
38 38 01-CA-42005-001 2004-08-18T09:10:00 1 2004-11-18T14:45:00 2004-11-12T00:00:00 Other IAP 2004-11-15T00:00:00 04-CA-33191-001 01-CA-42005-001 2004-11-18T00:00:00 2004-08-18T00:00:00
39 39 01-CA-42005-001 2004-11-18T14:31:00 2 2004-11-18T15:00:00 2004-11-12T00:00:00 NeedA IAP 2004-11-15T00:00:00 01-CA-42005-001 04-CA-33191-001    
40 40 01-CA-42005-001 2004-11-18T14:52:00 3                  
41 41 01-CA-42013-001 2005-02-18T12:00:00 0                  
42 42 01-CA-42161-001 2005-03-14T14:33:00 0                  
43 43 01-CA-42167-001 2004-11-03T11:30:00 0                  
44 44 01-CA-42296-001 2005-03-07T13:42:00 0                  
45 45 01-CA-42299-001 2005-09-28T15:42:00 0                  
46 46 01-CA-42420-001 2005-10-24T12:05:00 0                  
47 47 01-CA-42639-001 2005-10-05T12:39:00 0                  
48 48 01-CA-42984-001 2006-03-06T15:54:00 0                  
49 49 01-CA-43007-001 2006-02-07T16:13:00 0                  
50 50 01-CA-43077-001 2006-03-13T16:33:00 0                  
51 51 01-CA-43100-001 2007-06-12T11:12:00 0                  
52 52 01-CA-43542-001 2007-06-22T10:35:00 0                  
53 53 01-CA-44021-001 2007-07-11T09:11:00 0 2007-07-11T09:30:00 2007-07-03T00:00:00 NeedA IAP 2007-07-03T00:00:00 29-CA-28370-001 01-CA-44021-001    
54 54 01-CA-44021-001 2007-07-11T09:17:00 1 2007-07-30T15:00:00 2007-07-25T00:00:00 NeedA Perm 2007-07-30T00:00:00 01-CA-44021-001 29-CA-28370-001 2007-07-30T00:00:00  
55 55 01-CA-44021-001 2007-07-30T14:46:00 2                  
56 56 01-CA-44022-001 2007-07-11T10:12:00 0 2007-07-11T10:30:00 2007-07-03T00:00:00 NeedA IAP 2007-07-03T00:00:00 29-CA-28371-001 01-CA-44022-001    
57 57 01-CA-44022-001 2007-07-11T10:18:00 1 2007-07-30T15:15:00 2007-07-30T00:00:00 NeedA Perm 2007-07-30T00:00:00 01-CA-44022-001 29-CA-28371-001    
58 58 01-CA-44022-001 2007-07-30T15:04:00 2                  
59 59 01-CA-44034-001 2007-07-19T12:14:00 0                  
60 60 01-CA-44159-001 2007-09-20T11:08:00 0                  
61 61 01-CA-44262-001 2007-10-22T16:51:00 0 2007-10-23T09:45:00 2007-10-23T00:00:00 NeedA IAP 2007-10-23T00:00:00 01-CA-44262-001 34-CA-11873-001 2007-10-23T00:00:00  
62 62 01-CA-44262-001 2007-10-23T09:44:00 1                 2007-11-16T00:00:00
63 63 01-CA-44402-001 2008-01-30T10:28:00 0                  
64 64 01-CA-44521-001 2009-12-03T11:30:00 0                  
65 65 01-CA-44616-001 2008-06-11T09:46:00 0 2008-06-11T14:05:00 2008-05-01T00:00:00 NeedA IAP 2008-06-11T00:00:00 03-CA-26721-001 01-CA-44616-001 2008-06-11T00:00:00  
66 66 01-CA-44616-001 2008-06-11T14:04:00 1 2009-03-24T12:30:00 2009-03-24T00:00:00 Other IAP 2009-03-25T00:00:00 01-CA-44616-001 03-CA-26721-001 2009-03-24T00:00:00 2008-06-18T00:00:00
67 67 01-CA-44616-001 2009-03-24T12:24:00 2                  
68 68 01-CA-45278-001 2009-05-20T11:21:00 0                  
69 69 01-CA-45314-001 2009-05-07T12:27:00 0 2009-05-07T12:45:00 2009-05-07T00:00:00 Conso Perm 2009-05-07T00:00:00 12-CA-26334-001 01-CA-45314-001    
70 70 01-CA-45314-001 2009-05-07T12:29:00 1 2009-07-16T09:15:00 2009-06-29T00:00:00 Other IAP 2009-06-29T00:00:00 01-CA-45314-001 12-CA-26334-001 2009-07-17T00:00:00  
71 71 01-CA-45314-001 2009-07-16T09:08:00 2               2009-07-17T00:00:00 2009-07-20T00:00:00
72 72 01-CA-45397-001 2009-09-29T15:48:00 0                  
73 73 01-CA-45489-001 2010-03-12T10:40:00 0                  
74 74 01-CA-45885-001 2010-01-08T11:15:00 0                  
75 75 01-CA-46277-001 2011-01-14T15:10:00 0                  
76 76 01-CA-46324-001 2011-01-14T14:57:00 0                  
77 77 01-CA-46759-001 2011-06-06T15:54:00 0                  
78 78 01-CA-46761-001 2011-05-05T10:39:00 0                  
79 79 01-CB-09496-001 2000-01-10T12:02:00 0     Other IAP   24-CB-02003-001      
80 80 01-CB-10161-001 2003-08-01T11:00:00 0 2003-08-01T11:15:00 2003-07-31T00:00:00 Other Perm 2003-07-31T00:00:00 01-CB-10161-001 34-CB-02658-001 2003-07-31T00:00:00  
81 81 01-CB-10161-001 2003-08-01T11:01:00 1                 2003-08-06T00:00:00
82 82 01-CB-10392-001 2005-01-25T14:13:00 0 2005-01-25T14:30:00 2005-01-24T00:00:00 Other Perm 2005-01-24T00:00:00 34-CB-02819-001 01-CB-10392-001 2005-01-25T00:00:00  
83 83 01-CB-10392-001 2005-01-25T14:21:00 1 2005-04-20T12:00:00 2005-03-31T00:00:00 Other IAP 2005-04-01T00:00:00 01-CB-10392-001 34-CB-02819-001 2005-04-20T00:00:00  
84 84 01-CB-10392-001 2005-04-20T11:55:00 2                 2005-04-22T00:00:00
85 85 01-CB-10761-001 2007-06-12T16:27:00 0 2007-06-12T16:45:00 2007-06-12T00:00:00 NeedA IAP 2007-06-12T00:00:00 29-CB-13440-001 01-CB-10761-001    
86 86 01-CB-10761-001 2007-06-12T16:33:00 1 2007-09-19T10:30:00 2007-08-24T00:00:00 NeedA IAP 2007-08-27T00:00:00 01-CB-10761-001 29-CB-13440-001 2007-08-27T00:00:00  
87 87 01-CB-10761-001 2007-09-19T10:26:00 2                 2007-09-21T00:00:00
88 88 01-CB-11084-001 2011-01-20T11:40:00 0                  
89 89 01-CB-11275-001 2011-01-14T08:49:00 0                  
90 90 01-CC-02777-001 2005-06-03T09:10:00 0                  
91 91 02-CA-24304-001 2000-02-07T16:22:00 0                  
92 92 02-CA-25386-001 2004-04-06T17:18:00 0                  
93 93 02-CA-25984-001 1999-07-23T13:53:00 0                  
94 94 02-CA-28427-001 2006-12-21T14:58:00 0                  
95 95 02-CA-28505-001 2003-05-15T16:40:00 0                  
96 96 02-CA-29835-001 2007-02-15T12:52:00 0                  
97 97 02-CA-29877-001 2001-08-29T10:07:00 0                  
98 98 02-CA-31014-001 2007-02-15T13:34:00 0                  
99 99 02-CA-31312-001 2007-02-15T13:43:00 0                  
100 100 02-CA-31323-001 2001-05-25T12:18:00 0                  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_transfer_history" (
    "c_case_number" text,
    "history_date" text,
    "sequence" integer,
    "date_data_received" text,
    "request_date" text,
    "reason_transfer" text,
    "transfer_type" text,
    "transfer_order_date" text,
    "new_case_number" text,
    "former_case_number" text,
    "sent_date" text,
    "received_date" text
);