ooc_interests
3,833,993 rows sorted by interestlevel descending
This data as json, CSV (advanced)
Suggested facets: startdate (date)
_link | _link_ooc_statement | type | interestlevel ▲ | beneficialownershiporcontrol | startdate | details |
---|---|---|---|---|---|---|
2.interests.0 | 2 | other-influence-or-control | indirect | false | 2014-06-17T12:00:00+02:00 | |
4.interests.0 | 4 | other-influence-or-control | indirect | false | 2008-06-12T00:00:00.000Z | |
14.interests.0 | 14 | other-influence-or-control | indirect | false | 2014-06-24T00:00:00.000Z | |
17.interests.0 | 17 | other-influence-or-control | indirect | false | 2017-10-25T00:00:00.000Z | |
19.interests.0 | 19 | other-influence-or-control | indirect | false | 2015-06-10T00:00:00.000Z | |
22.interests.0 | 22 | other-influence-or-control | indirect | false | 2023-11-09T17:30:00.000Z | |
24.interests.0 | 24 | other-influence-or-control | indirect | false | 2023-11-20T00:00:00.000Z | |
26.interests.0 | 26 | other-influence-or-control | indirect | false | 2010-09-23T00:00:00.000Z | |
33.interests.0 | 33 | other-influence-or-control | indirect | false | 2012-02-24T01:00:00+01:00 | |
35.interests.0 | 35 | other-influence-or-control | indirect | false | 2021-01-11T12:00:00.000Z | |
41.interests.0 | 41 | other-influence-or-control | indirect | false | 2021-08-13T18:38:31.084Z | |
48.interests.0 | 48 | other-influence-or-control | indirect | false | 2020-12-24T00:00:00.000Z | |
50.interests.0 | 50 | other-influence-or-control | indirect | false | 1957-01-01T00:00:00.000Z | |
53.interests.0 | 53 | other-influence-or-control | indirect | false | 2018-03-05T14:00:00.000Z | |
56.interests.0 | 56 | other-influence-or-control | indirect | false | 2018-03-07T00:00:00.000Z | |
58.interests.0 | 58 | other-influence-or-control | indirect | false | 2021-05-20T00:00:00.000Z | |
62.interests.0 | 62 | other-influence-or-control | indirect | false | 2013-09-20T00:00:00.000Z | |
69.interests.0 | 69 | other-influence-or-control | indirect | false | 2019-01-01T00:00:00.000Z | |
71.interests.0 | 71 | other-influence-or-control | indirect | false | 2019-05-14T00:00:00.000Z | |
77.interests.0 | 77 | other-influence-or-control | indirect | false | 2009-12-03T00:00:00.000Z | |
81.interests.0 | 81 | other-influence-or-control | indirect | false | 2020-01-13T15:01:21.513Z | |
83.interests.0 | 83 | other-influence-or-control | indirect | false | 2020-01-22T00:00:00.000Z | |
88.interests.0 | 88 | other-influence-or-control | indirect | false | 2022-04-19T06:31:29Z | |
92.interests.0 | 92 | other-influence-or-control | indirect | false | 2009-04-23T00:00:00.000Z | |
98.interests.0 | 98 | other-influence-or-control | indirect | false | 1982-08-24T00:00:00.000Z | |
103.interests.0 | 103 | other-influence-or-control | indirect | false | 2017-12-27T00:00:00.000Z | |
107.interests.0 | 107 | other-influence-or-control | indirect | false | 2021-08-27T00:00:00Z | |
110.interests.0 | 110 | other-influence-or-control | indirect | false | 2022-01-01T00:00:00.000Z | |
117.interests.0 | 117 | other-influence-or-control | indirect | false | 2019-11-26T00:00:00.000Z | |
120.interests.0 | 120 | other-influence-or-control | indirect | false | 2022-05-18T00:00:00.000Z | |
124.interests.0 | 124 | other-influence-or-control | indirect | false | 2015-07-15T00:00:00.000Z | |
129.interests.0 | 129 | other-influence-or-control | indirect | false | 2017-11-29T00:00:00.000Z | |
131.interests.0 | 131 | other-influence-or-control | indirect | false | 2016-02-09T00:00:00.000Z | |
136.interests.0 | 136 | other-influence-or-control | indirect | false | 2020-10-23T12:13:24.750Z | |
138.interests.0 | 138 | other-influence-or-control | indirect | false | 2022-01-07T00:00:00.000Z | |
140.interests.0 | 140 | other-influence-or-control | indirect | false | 2004-08-10T00:00:00.000Z | |
143.interests.0 | 143 | other-influence-or-control | indirect | false | 1991-08-23T00:00:00.000Z | |
145.interests.0 | 145 | other-influence-or-control | indirect | false | 2022-12-31T00:00:00+01:00 | |
147.interests.0 | 147 | other-influence-or-control | indirect | false | 2018-08-06T02:00:00+02:00 | |
152.interests.0 | 152 | other-influence-or-control | indirect | false | 2014-01-01T00:00:00Z | |
154.interests.0 | 154 | other-influence-or-control | indirect | false | 2022-04-08T00:00:00.000Z | |
160.interests.0 | 160 | other-influence-or-control | indirect | false | 2019-01-10T00:00:00.000Z | |
161.interests.0 | 161 | other-influence-or-control | indirect | false | 2013-05-27T00:00:00.000Z | |
163.interests.0 | 163 | other-influence-or-control | indirect | false | 2019-08-27T00:00:00.000Z | |
172.interests.0 | 172 | other-influence-or-control | indirect | false | 2018-09-21T00:00:00.000Z | |
174.interests.0 | 174 | other-influence-or-control | indirect | false | 2020-01-07T00:00:00.000Z | |
182.interests.0 | 182 | other-influence-or-control | indirect | false | 2013-01-18T00:00:00.000Z | |
184.interests.0 | 184 | other-influence-or-control | indirect | false | 2021-03-19T00:00:00.000Z | |
188.interests.0 | 188 | other-influence-or-control | indirect | false | 2021-06-03T00:00:00.000Z | |
193.interests.0 | 193 | other-influence-or-control | indirect | false | 2021-04-26T00:00:00.000Z | |
196.interests.0 | 196 | other-influence-or-control | indirect | false | 2005-04-01T00:00:00.000Z | |
198.interests.0 | 198 | other-influence-or-control | indirect | false | 1968-02-07T00:00:00.000Z | |
206.interests.0 | 206 | other-influence-or-control | indirect | false | 2004-06-23T00:00:00.000Z | |
211.interests.0 | 211 | other-influence-or-control | indirect | false | 2021-04-22T00:00:00.000Z | |
213.interests.0 | 213 | other-influence-or-control | indirect | false | 2020-05-08T04:00:00.000Z | |
215.interests.0 | 215 | other-influence-or-control | indirect | false | 2017-10-16T00:00:00.000Z | |
219.interests.0 | 219 | other-influence-or-control | indirect | false | 2022-06-21T00:00:00.000Z | |
222.interests.0 | 222 | other-influence-or-control | indirect | false | 2017-09-15T17:30:00.000Z | |
224.interests.0 | 224 | other-influence-or-control | indirect | false | 2023-01-01T00:00:00.000Z | |
232.interests.0 | 232 | other-influence-or-control | indirect | false | 2021-08-19T00:00:00.000Z | |
236.interests.0 | 236 | other-influence-or-control | indirect | false | 2019-05-04T00:00:00.000Z | |
238.interests.0 | 238 | other-influence-or-control | indirect | false | 2019-02-01T16:26:52.023Z | |
240.interests.0 | 240 | other-influence-or-control | indirect | false | 2013-07-13T00:00:00.000Z | |
242.interests.0 | 242 | other-influence-or-control | indirect | false | 1995-03-10T00:00:00.000Z | |
244.interests.0 | 244 | other-influence-or-control | indirect | false | 2020-07-31T00:00:00.000Z | |
245.interests.0 | 245 | other-influence-or-control | indirect | false | 2005-06-29T00:00:00.000Z | |
252.interests.0 | 252 | other-influence-or-control | indirect | false | 2019-01-01T00:00:00.000Z | |
255.interests.0 | 255 | other-influence-or-control | indirect | false | 2001-03-09T00:00:00.000Z | |
258.interests.0 | 258 | other-influence-or-control | indirect | false | 2017-10-12T00:00:00.000Z | |
261.interests.0 | 261 | other-influence-or-control | indirect | false | 2018-06-09T00:00:00.000Z | |
270.interests.0 | 270 | other-influence-or-control | indirect | false | 2018-02-01T00:00:00.000Z | |
272.interests.0 | 272 | other-influence-or-control | indirect | false | 2019-12-31T00:00:00+01:00 | |
274.interests.0 | 274 | other-influence-or-control | indirect | false | 2023-03-16T00:00:00.000Z | |
277.interests.0 | 277 | other-influence-or-control | indirect | false | 1999-12-17T00:00:00.000Z | |
279.interests.0 | 279 | other-influence-or-control | indirect | false | 2013-01-02T00:00:00.000Z | |
294.interests.0 | 294 | other-influence-or-control | indirect | false | 2016-12-09T00:00:00.000Z | |
296.interests.0 | 296 | other-influence-or-control | indirect | false | 2017-09-27T00:00:00.000Z | |
302.interests.0 | 302 | other-influence-or-control | indirect | false | 2021-05-10T00:00:00.000Z | |
306.interests.0 | 306 | other-influence-or-control | indirect | false | 2001-07-01T00:00:00.000Z | |
308.interests.0 | 308 | other-influence-or-control | indirect | false | 2021-12-29T00:00:00.000Z | |
312.interests.0 | 312 | other-influence-or-control | indirect | false | 2006-03-28T00:00:00.000Z | |
314.interests.0 | 314 | other-influence-or-control | indirect | false | 2011-02-23T00:00:00.000Z | |
320.interests.0 | 320 | other-influence-or-control | indirect | false | 2018-10-15T00:00:00.000Z | |
324.interests.0 | 324 | other-influence-or-control | indirect | false | 2013-11-18T00:00:00.000Z | |
329.interests.0 | 329 | other-influence-or-control | indirect | false | 2018-04-23T00:00:00.000Z | |
332.interests.0 | 332 | other-influence-or-control | indirect | false | 1987-09-03T00:00:00.000Z | |
334.interests.0 | 334 | other-influence-or-control | indirect | false | 2018-10-24T00:00:00.000Z | |
338.interests.0 | 338 | other-influence-or-control | indirect | false | 2022-12-22T00:00:00.000Z | |
342.interests.0 | 342 | other-influence-or-control | indirect | false | 2018-04-26T15:33:30.593Z | |
346.interests.0 | 346 | other-influence-or-control | indirect | false | 2011-10-02T17:30:00.000Z | |
347.interests.0 | 347 | other-influence-or-control | indirect | false | 2019-09-09T00:00:00.000Z | |
349.interests.0 | 349 | other-influence-or-control | indirect | false | 2006-11-22T00:00:00.000Z | |
351.interests.0 | 351 | other-influence-or-control | indirect | false | 2021-11-11T00:00:00.000Z | |
354.interests.0 | 354 | other-influence-or-control | indirect | false | 1998-10-23T00:00:00.000Z | |
360.interests.0 | 360 | other-influence-or-control | indirect | false | 1999-07-14T00:00:00.000Z | |
361.interests.0 | 361 | other-influence-or-control | indirect | false | 2021-11-03T00:00:00.000Z | |
367.interests.0 | 367 | other-influence-or-control | indirect | false | 1997-08-11T00:00:00.000Z | |
372.interests.0 | 372 | other-influence-or-control | indirect | false | 2022-02-25T00:00:00.000Z | |
377.interests.0 | 377 | other-influence-or-control | indirect | false | 2020-12-01T00:00:00.000Z | |
379.interests.0 | 379 | other-influence-or-control | indirect | false | 2023-10-20T00:00:00.000Z |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [ooc_interests] ( [_link] TEXT , [_link_ooc_statement] TEXT , [type] TEXT , [interestlevel] TEXT , [beneficialownershiporcontrol] BOOL , [startdate] TIMESTAMP , [details] TEXT , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );