ooc_interests
3,833,993 rows sorted by details
This data as json, CSV (advanced)
_link | _link_ooc_statement | type | interestlevel | beneficialownershiporcontrol | startdate | details ▼ |
---|---|---|---|---|---|---|
990.interests.0 | 990 | other-influence-or-control | direct | false | 2023-09-20T00:00:00.000Z | |
9900.interests.0 | 9900 | other-influence-or-control | direct | false | 1999-12-10T18:30:00.001Z | |
99000.interests.0 | 99000 | other-influence-or-control | direct | false | 2017-08-30T00:00:00Z | |
99001.interests.0 | 99001 | other-influence-or-control | indirect | false | 2017-08-30T00:00:00Z | |
99002.interests.0 | 99002 | other-influence-or-control | direct | false | 2023-12-15T00:00:00Z | |
99003.interests.0 | 99003 | other-influence-or-control | direct | false | 2007-02-19T00:00:00Z | |
99004.interests.0 | 99004 | other-influence-or-control | direct | false | 2022-10-05T00:00:00Z | |
99005.interests.0 | 99005 | other-influence-or-control | direct | false | 2014-01-08T00:00:00Z | |
99006.interests.0 | 99006 | other-influence-or-control | indirect | false | 2014-01-08T00:00:00Z | |
99007.interests.0 | 99007 | other-influence-or-control | direct | false | 2018-06-11T00:00:00Z | |
99008.interests.0 | 99008 | other-influence-or-control | direct | false | 2019-12-23T00:00:00Z | |
99009.interests.0 | 99009 | other-influence-or-control | direct | false | 2019-12-23T00:00:00Z | |
9901.interests.0 | 9901 | other-influence-or-control | direct | false | 1999-12-10T18:30:00.001Z | |
99010.interests.0 | 99010 | other-influence-or-control | direct | false | 2014-05-23T00:00:00Z | |
99011.interests.0 | 99011 | other-influence-or-control | indirect | false | 2014-05-23T00:00:00Z | |
99012.interests.0 | 99012 | other-influence-or-control | direct | false | 2020-07-09T00:00:00Z | |
99013.interests.0 | 99013 | other-influence-or-control | direct | false | 2020-07-09T00:00:00Z | |
99014.interests.0 | 99014 | other-influence-or-control | direct | false | 2024-02-19T00:00:00Z | |
99015.interests.0 | 99015 | other-influence-or-control | direct | false | 2019-05-08T00:00:00Z | |
99016.interests.0 | 99016 | other-influence-or-control | direct | false | 2019-05-09T00:00:00Z | |
99017.interests.0 | 99017 | other-influence-or-control | indirect | false | 2019-05-08T00:00:00Z | |
99018.interests.0 | 99018 | other-influence-or-control | direct | false | 2014-03-25T00:00:00Z | |
99019.interests.0 | 99019 | other-influence-or-control | indirect | false | 2014-03-25T00:00:00Z | |
9902.interests.0 | 9902 | other-influence-or-control | direct | false | 2019-11-03T18:30:00.001Z | |
99020.interests.0 | 99020 | other-influence-or-control | direct | false | 2018-06-28T00:00:00Z | |
99021.interests.0 | 99021 | other-influence-or-control | indirect | false | 2018-06-28T00:00:00Z | |
99022.interests.0 | 99022 | other-influence-or-control | indirect | false | 2014-05-23T00:00:00Z | |
99023.interests.0 | 99023 | other-influence-or-control | direct | false | 2024-01-01T00:00:00Z | |
99024.interests.0 | 99024 | other-influence-or-control | direct | false | 2024-01-01T00:00:00Z | |
99025.interests.0 | 99025 | other-influence-or-control | direct | false | 2019-11-28T15:31:48.150Z | |
99026.interests.0 | 99026 | other-influence-or-control | indirect | false | 2019-11-28T15:31:50.537Z | |
99027.interests.0 | 99027 | other-influence-or-control | direct | false | 2017-07-25T00:00:00Z | |
99028.interests.0 | 99028 | other-influence-or-control | indirect | false | 2017-07-25T00:00:00Z | |
99029.interests.0 | 99029 | other-influence-or-control | direct | false | 2018-09-04T00:00:00Z | |
9903.interests.0 | 9903 | other-influence-or-control | indirect | false | 2017-03-31T18:30:00.001Z | |
99030.interests.0 | 99030 | other-influence-or-control | direct | false | 2018-09-04T00:00:00Z | |
99031.interests.0 | 99031 | other-influence-or-control | direct | false | 2014-02-10T00:00:00Z | |
99032.interests.0 | 99032 | other-influence-or-control | indirect | false | 2014-02-10T00:00:00Z | |
99033.interests.0 | 99033 | other-influence-or-control | direct | false | 2015-05-08T00:00:00Z | |
99034.interests.0 | 99034 | other-influence-or-control | direct | false | 2015-05-08T00:00:00Z | |
99035.interests.0 | 99035 | other-influence-or-control | direct | false | 2021-05-10T00:00:00Z | |
99036.interests.0 | 99036 | other-influence-or-control | direct | false | 2017-11-21T00:00:00Z | |
99037.interests.0 | 99037 | other-influence-or-control | indirect | false | 2017-11-21T00:00:00Z | |
99038.interests.0 | 99038 | other-influence-or-control | direct | false | 2017-12-28T00:00:00Z | |
99039.interests.0 | 99039 | other-influence-or-control | direct | false | 2016-12-20T00:00:00Z | |
9904.interests.0 | 9904 | other-influence-or-control | direct | false | 2015-06-24T18:30:00.001Z | |
99040.interests.0 | 99040 | other-influence-or-control | direct | false | 1991-07-26T00:00:00Z | |
99041.interests.0 | 99041 | other-influence-or-control | direct | false | 2017-12-18T00:00:00Z | |
99042.interests.0 | 99042 | other-influence-or-control | direct | false | 2017-12-18T00:00:00Z | |
99043.interests.0 | 99043 | other-influence-or-control | indirect | false | 2017-12-18T00:00:00Z | |
99044.interests.0 | 99044 | other-influence-or-control | direct | false | 2018-12-13T00:00:00Z | |
99045.interests.0 | 99045 | other-influence-or-control | indirect | false | 2018-12-13T00:00:00Z | |
99046.interests.0 | 99046 | other-influence-or-control | direct | false | 2018-09-17T00:00:00+02:00 | |
99047.interests.0 | 99047 | other-influence-or-control | indirect | false | 2018-09-17T00:00:00+02:00 | |
99048.interests.0 | 99048 | other-influence-or-control | direct | false | 2018-02-27T00:00:00Z | |
99049.interests.0 | 99049 | other-influence-or-control | indirect | false | 2018-02-27T00:00:00Z | |
9905.interests.0 | 9905 | other-influence-or-control | indirect | false | 2015-06-24T18:30:00.001Z | |
99050.interests.0 | 99050 | other-influence-or-control | direct | false | 2022-04-14T00:00:00Z | |
99051.interests.0 | 99051 | other-influence-or-control | direct | false | 2011-06-01T00:00:00Z | |
99052.interests.0 | 99052 | other-influence-or-control | direct | false | 2011-06-01T00:00:00Z | |
99053.interests.0 | 99053 | other-influence-or-control | direct | false | 2015-09-07T00:00:00Z | |
99054.interests.0 | 99054 | other-influence-or-control | direct | false | 2015-09-07T00:00:00Z | |
99055.interests.0 | 99055 | other-influence-or-control | direct | false | 2019-03-20T12:22:10.953Z | |
99056.interests.0 | 99056 | other-influence-or-control | indirect | false | 2019-03-20T12:22:10.953Z | |
99057.interests.0 | 99057 | other-influence-or-control | direct | false | 2022-11-01T00:00:00Z | |
99058.interests.0 | 99058 | other-influence-or-control | direct | false | 2022-11-01T00:00:00Z | |
99059.interests.0 | 99059 | other-influence-or-control | direct | false | 2023-09-22T08:42:59Z | |
9906.interests.0 | 9906 | other-influence-or-control | direct | false | 2022-12-01T18:30:00.001Z | |
99060.interests.0 | 99060 | other-influence-or-control | indirect | false | 2023-09-22T08:43:01Z | |
99061.interests.0 | 99061 | other-influence-or-control | direct | false | 1989-11-10T00:00:00Z | |
99062.interests.0 | 99062 | other-influence-or-control | direct | false | 2023-03-24T00:00:00Z | |
99063.interests.0 | 99063 | other-influence-or-control | indirect | false | 2023-03-24T00:00:00Z | |
99064.interests.0 | 99064 | other-influence-or-control | direct | false | 2014-03-11T00:00:00Z | |
99065.interests.0 | 99065 | other-influence-or-control | indirect | false | 2014-03-11T00:00:00Z | |
99066.interests.0 | 99066 | other-influence-or-control | direct | false | 2017-12-01T17:02:03.507Z | |
99067.interests.0 | 99067 | other-influence-or-control | indirect | false | 2017-12-01T17:02:11.480Z | |
99068.interests.0 | 99068 | other-influence-or-control | direct | false | 2020-09-04T00:00:00Z | |
99069.interests.0 | 99069 | other-influence-or-control | direct | false | 2021-03-01T00:00:00Z | |
9907.interests.0 | 9907 | other-influence-or-control | indirect | false | 2022-12-01T18:30:00.001Z | |
99070.interests.0 | 99070 | other-influence-or-control | direct | false | 2021-03-01T00:00:00Z | |
99071.interests.0 | 99071 | other-influence-or-control | direct | false | 2018-01-12T00:00:00Z | |
99072.interests.0 | 99072 | other-influence-or-control | indirect | false | 2018-01-12T00:00:00Z | |
99073.interests.0 | 99073 | other-influence-or-control | direct | false | 2024-02-18T00:00:00Z | |
99074.interests.0 | 99074 | other-influence-or-control | direct | false | 2022-12-02T00:00:00Z | |
99075.interests.0 | 99075 | other-influence-or-control | indirect | false | 2022-12-02T00:00:00Z | |
99076.interests.0 | 99076 | other-influence-or-control | direct | false | 2014-01-29T00:00:00Z | |
99077.interests.0 | 99077 | other-influence-or-control | direct | false | 2023-08-03T00:00:00.000+02:00 | |
99078.interests.0 | 99078 | other-influence-or-control | direct | false | 2017-06-21T00:00:00Z | |
99079.interests.0 | 99079 | other-influence-or-control | direct | false | 2017-06-21T00:00:00Z | |
9908.interests.0 | 9908 | other-influence-or-control | direct | false | 2019-11-18T18:30:00.001Z | |
99080.interests.0 | 99080 | other-influence-or-control | direct | false | 2019-04-24T00:00:00Z | |
99081.interests.0 | 99081 | other-influence-or-control | indirect | false | 2019-04-24T00:00:00Z | |
99082.interests.0 | 99082 | other-influence-or-control | direct | false | 2018-01-23T00:00:00Z | |
99083.interests.0 | 99083 | other-influence-or-control | indirect | false | 2018-01-23T00:00:00Z | |
99084.interests.0 | 99084 | other-influence-or-control | direct | false | 2001-03-19T00:00:00Z | |
99085.interests.0 | 99085 | other-influence-or-control | direct | false | 2015-09-01T00:00:00Z | |
99086.interests.0 | 99086 | other-influence-or-control | indirect | false | 2015-09-01T00:00:00Z | |
99087.interests.0 | 99087 | other-influence-or-control | direct | false | 2014-12-10T00:00:00Z | |
99088.interests.0 | 99088 | other-influence-or-control | direct | false | 2016-12-01T00:00:00Z | |
99089.interests.0 | 99089 | other-influence-or-control | indirect | false | 2016-12-01T00:00:00Z |
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]) );