ooc_interests
3,901,936 rows sorted by beneficialownershiporcontrol
This data as json, CSV (advanced)
_link | _link_ooc_statement | type | interestlevel | beneficialownershiporcontrol ▼ | details | startdate |
---|---|---|---|---|---|---|
990089.interests.0 | 990089 | other-influence-or-control | direct | false | 2020-09-29T00:00:00+02:00 | |
99009.interests.0 | 99009 | other-influence-or-control | indirect | false | A controlling interest. | |
990090.interests.0 | 990090 | other-influence-or-control | direct | false | 2020-09-29T00:00:00+02:00 | |
990091.interests.0 | 990091 | other-influence-or-control | direct | false | 2015-03-19T00:00:00.000Z | |
990092.interests.0 | 990092 | other-influence-or-control | indirect | false | 2015-03-19T00:00:00.000Z | |
990093.interests.0 | 990093 | other-influence-or-control | direct | false | 2023-04-07T00:00:00Z | |
990094.interests.0 | 990094 | other-influence-or-control | direct | false | 2023-04-07T00:00:00Z | |
990095.interests.0 | 990095 | other-influence-or-control | direct | false | 2018-10-08T00:00:00Z | |
990096.interests.0 | 990096 | other-influence-or-control | direct | false | 2018-01-19T00:00:00.000+01:00 | |
990097.interests.0 | 990097 | other-influence-or-control | direct | false | 2018-01-19T00:00:00.000+01:00 | |
990098.interests.0 | 990098 | other-influence-or-control | direct | false | 2006-01-12T01:00:00+01:00 | |
990099.interests.0 | 990099 | other-influence-or-control | direct | false | 2022-11-07T00:00:00Z | |
9901.interests.0 | 9901 | other-influence-or-control | direct | false | A controlling interest. | |
99010.interests.0 | 99010 | other-influence-or-control | indirect | false | A controlling interest. | |
990100.interests.0 | 990100 | other-influence-or-control | direct | false | 2021-12-01T00:00:00.000Z | |
990101.interests.0 | 990101 | other-influence-or-control | direct | false | 2023-04-16T00:00:00.000Z | |
990102.interests.0 | 990102 | other-influence-or-control | indirect | false | 2023-04-16T00:00:00.000Z | |
990103.interests.0 | 990103 | other-influence-or-control | direct | false | 2008-08-11T00:00:00+02:00 | |
990104.interests.0 | 990104 | other-influence-or-control | direct | false | 2023-03-06T00:00:00+00:00 | |
990105.interests.0 | 990105 | other-influence-or-control | direct | false | 2023-03-06T00:00:00+00:00 | |
990106.interests.0 | 990106 | other-influence-or-control | direct | false | 2022-11-07T00:00:00Z | |
990107.interests.0 | 990107 | other-influence-or-control | direct | false | 2017-07-11T00:00:00.000Z | |
990108.interests.0 | 990108 | other-influence-or-control | indirect | false | 2017-07-11T00:00:00.000Z | |
990109.interests.0 | 990109 | other-influence-or-control | direct | false | 2016-12-31T00:00:00Z | |
99011.interests.0 | 99011 | other-influence-or-control | indirect | false | A controlling interest. | |
990110.interests.0 | 990110 | other-influence-or-control | indirect | false | 2016-12-31T00:00:00Z | |
990111.interests.0 | 990111 | other-influence-or-control | direct | false | 2021-01-26T00:00:00Z | |
990112.interests.0 | 990112 | other-influence-or-control | indirect | false | 2021-01-26T00:00:00Z | |
990113.interests.0 | 990113 | other-influence-or-control | direct | false | 2014-03-04T00:00:00.000Z | |
990114.interests.0 | 990114 | other-influence-or-control | indirect | false | 2014-03-04T00:00:00.000Z | |
990115.interests.0 | 990115 | other-influence-or-control | direct | false | 2019-03-05T00:00:00.000Z | |
990116.interests.0 | 990116 | other-influence-or-control | indirect | false | 2019-03-05T00:00:00.000Z | |
990117.interests.0 | 990117 | other-influence-or-control | direct | false | 2023-04-11T00:00:00.000Z | |
990118.interests.0 | 990118 | other-influence-or-control | direct | false | 2023-04-11T00:00:00.000Z | |
990119.interests.0 | 990119 | other-influence-or-control | direct | false | 2018-07-30T02:00:00+02:00 | |
99012.interests.0 | 99012 | other-influence-or-control | indirect | false | A controlling interest. | |
990120.interests.0 | 990120 | other-influence-or-control | indirect | false | 2021-11-04T01:00:00+01:00 | |
990121.interests.0 | 990121 | other-influence-or-control | direct | false | 2022-11-04T00:00:00Z | |
990122.interests.0 | 990122 | other-influence-or-control | indirect | false | 2021-11-07T00:00:00Z | |
990123.interests.0 | 990123 | other-influence-or-control | direct | false | 2023-04-17T00:00:00Z | |
990124.interests.0 | 990124 | other-influence-or-control | indirect | false | 2023-04-17T00:00:00Z | |
990125.interests.0 | 990125 | other-influence-or-control | direct | false | 2017-06-22T00:00:00.000Z | |
990126.interests.0 | 990126 | other-influence-or-control | indirect | false | 2017-06-22T00:00:00.000Z | |
990127.interests.0 | 990127 | other-influence-or-control | direct | false | 2020-04-05T00:00:00.000Z | |
990128.interests.0 | 990128 | other-influence-or-control | indirect | false | 2020-04-05T00:00:00.000Z | |
990129.interests.0 | 990129 | other-influence-or-control | direct | false | 2016-12-31T00:00:00.000+01:00 | |
99013.interests.0 | 99013 | other-influence-or-control | indirect | false | A controlling interest. | |
990130.interests.0 | 990130 | other-influence-or-control | direct | false | 2016-12-31T00:00:00.000+01:00 | |
990131.interests.0 | 990131 | other-influence-or-control | direct | false | 2012-07-01T00:00:00.000Z | |
990132.interests.0 | 990132 | other-influence-or-control | indirect | false | 2023-05-10T02:00:00+02:00 | |
990133.interests.0 | 990133 | other-influence-or-control | direct | false | 2018-03-11T00:00:00Z | |
990134.interests.0 | 990134 | other-influence-or-control | indirect | false | 2018-03-11T00:00:00Z | |
990135.interests.0 | 990135 | other-influence-or-control | direct | false | 2023-01-25T00:00:00Z | |
990136.interests.0 | 990136 | other-influence-or-control | indirect | false | 2023-01-25T00:00:00Z | |
990137.interests.0 | 990137 | other-influence-or-control | direct | false | 2011-03-04T00:00:00.000Z | |
990138.interests.0 | 990138 | other-influence-or-control | indirect | false | 2011-03-04T00:00:00.000Z | |
990139.interests.0 | 990139 | other-influence-or-control | direct | false | 2023-04-20T00:00:00.000Z | |
99014.interests.0 | 99014 | other-influence-or-control | indirect | false | A controlling interest. | |
990140.interests.0 | 990140 | other-influence-or-control | direct | false | 2023-04-20T00:00:00.000Z | |
990141.interests.0 | 990141 | other-influence-or-control | direct | false | 2019-10-31T00:00:00.000Z | |
990142.interests.0 | 990142 | other-influence-or-control | indirect | false | 2018-10-22T00:00:00.000Z | |
990143.interests.0 | 990143 | other-influence-or-control | direct | false | 2017-12-13T00:00:00.000Z | |
990144.interests.0 | 990144 | other-influence-or-control | direct | false | 2023-06-27T12:03:16Z | |
990145.interests.0 | 990145 | other-influence-or-control | direct | false | 2023-06-27T12:03:16Z | |
990146.interests.0 | 990146 | other-influence-or-control | direct | false | 2017-12-15T00:00:00Z | |
990147.interests.0 | 990147 | other-influence-or-control | direct | false | 2017-12-15T00:00:00Z | |
990148.interests.0 | 990148 | other-influence-or-control | direct | false | 2023-04-24T00:00:00Z | |
990149.interests.0 | 990149 | other-influence-or-control | direct | false | 2023-04-13T00:00:00.000Z | |
99015.interests.0 | 99015 | other-influence-or-control | indirect | false | A controlling interest. | |
990150.interests.0 | 990150 | other-influence-or-control | direct | false | 2015-04-02T00:00:00.000Z | |
990151.interests.0 | 990151 | other-influence-or-control | direct | false | 2011-10-20T00:00:00Z | |
990152.interests.0 | 990152 | other-influence-or-control | direct | false | 2014-02-07T00:00:00Z | |
990153.interests.0 | 990153 | other-influence-or-control | direct | false | 2023-01-01T00:00:00Z | |
990154.interests.0 | 990154 | other-influence-or-control | direct | false | 2018-03-21T00:00:00Z | |
990155.interests.0 | 990155 | other-influence-or-control | indirect | false | 2018-03-21T00:00:00Z | |
990156.interests.0 | 990156 | other-influence-or-control | direct | false | 2014-05-29T00:00:00+00:00 | |
990157.interests.0 | 990157 | other-influence-or-control | indirect | false | 2014-05-29T00:00:00+00:00 | |
990158.interests.0 | 990158 | other-influence-or-control | direct | false | 2021-05-04T00:00:00.000+02:00 | |
990159.interests.0 | 990159 | other-influence-or-control | direct | false | 2017-02-17T00:00:00.000+01:00 | |
99016.interests.0 | 99016 | other-influence-or-control | indirect | false | A controlling interest. | |
990160.interests.0 | 990160 | other-influence-or-control | indirect | false | 2018-01-23T00:00:00Z | |
990161.interests.0 | 990161 | other-influence-or-control | direct | false | 2022-05-06T00:00:00Z | |
990162.interests.0 | 990162 | other-influence-or-control | direct | false | 2023-07-03T03:40:21.776Z | |
990163.interests.0 | 990163 | other-influence-or-control | direct | false | 2023-03-22T00:00:00Z | |
990164.interests.0 | 990164 | other-influence-or-control | direct | false | 2023-03-22T00:00:00Z | |
990165.interests.0 | 990165 | other-influence-or-control | direct | false | 2019-05-08T00:00:00.000Z | |
990166.interests.0 | 990166 | other-influence-or-control | indirect | false | 2019-05-08T00:00:00.000Z | |
990167.interests.0 | 990167 | other-influence-or-control | direct | false | 2023-05-24T18:10:55.847Z | |
990168.interests.0 | 990168 | other-influence-or-control | direct | false | 2023-05-24T18:11:26.835Z | |
990169.interests.0 | 990169 | other-influence-or-control | indirect | false | 2020-10-01T00:00:00.000Z | |
99017.interests.0 | 99017 | other-influence-or-control | indirect | false | A controlling interest. | |
990170.interests.0 | 990170 | other-influence-or-control | direct | false | 2018-05-31T00:00:00.000Z | |
990171.interests.0 | 990171 | other-influence-or-control | indirect | false | 2018-05-31T00:00:00.000Z | |
990172.interests.0 | 990172 | other-influence-or-control | direct | false | 2015-07-07T00:00:00+02:00 | |
990173.interests.0 | 990173 | other-influence-or-control | direct | false | 2015-07-07T00:00:00+02:00 | |
990174.interests.0 | 990174 | other-influence-or-control | direct | false | 2019-04-25T00:00:00.000Z | |
990175.interests.0 | 990175 | other-influence-or-control | indirect | false | 2019-04-25T00:00:00.000Z | |
990176.interests.0 | 990176 | other-influence-or-control | direct | false | 2018-11-09T00:00:00.000+01:00 | |
990177.interests.0 | 990177 | other-influence-or-control | indirect | false | 2018-11-09T00:00:00.000+01:00 | |
990178.interests.0 | 990178 | other-influence-or-control | direct | false | 1995-06-15T00:00:00+00:00 |
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 , [details] TEXT , [startdate] TIMESTAMP , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );