ooc_interests
3,901,936 rows
This data as json, CSV (advanced)
_link ▼ | _link_ooc_statement | type | interestlevel | beneficialownershiporcontrol | details | startdate |
---|---|---|---|---|---|---|
1000265.interests.0 | 1000265 | other-influence-or-control | direct | false | A controlling interest. | |
1000266.interests.0 | 1000266 | other-influence-or-control | direct | false | A controlling interest. | |
1000267.interests.0 | 1000267 | other-influence-or-control | direct | false | A controlling interest. | |
1000268.interests.0 | 1000268 | other-influence-or-control | direct | false | A controlling interest. | |
1000269.interests.0 | 1000269 | other-influence-or-control | direct | false | A controlling interest. | |
100027.interests.0 | 100027 | other-influence-or-control | indirect | false | A controlling interest. | |
1000270.interests.0 | 1000270 | other-influence-or-control | direct | false | A controlling interest. | |
1000271.interests.0 | 1000271 | other-influence-or-control | direct | false | A controlling interest. | |
1000272.interests.0 | 1000272 | other-influence-or-control | direct | false | A controlling interest. | |
1000273.interests.0 | 1000273 | other-influence-or-control | direct | false | A controlling interest. | |
1000274.interests.0 | 1000274 | other-influence-or-control | direct | false | A controlling interest. | |
1000275.interests.0 | 1000275 | other-influence-or-control | direct | false | A controlling interest. | |
1000276.interests.0 | 1000276 | other-influence-or-control | direct | false | A controlling interest. | |
1000277.interests.0 | 1000277 | other-influence-or-control | direct | false | A controlling interest. | |
1000278.interests.0 | 1000278 | other-influence-or-control | direct | false | A controlling interest. | |
1000279.interests.0 | 1000279 | other-influence-or-control | direct | false | A controlling interest. | |
100028.interests.0 | 100028 | other-influence-or-control | indirect | false | A controlling interest. | |
1000280.interests.0 | 1000280 | other-influence-or-control | direct | false | A controlling interest. | |
1000281.interests.0 | 1000281 | other-influence-or-control | direct | false | A controlling interest. | |
1000282.interests.0 | 1000282 | other-influence-or-control | direct | false | A controlling interest. | |
1000283.interests.0 | 1000283 | other-influence-or-control | direct | false | A controlling interest. | |
1000284.interests.0 | 1000284 | other-influence-or-control | direct | false | A controlling interest. | |
1000285.interests.0 | 1000285 | other-influence-or-control | direct | false | A controlling interest. | |
1000286.interests.0 | 1000286 | other-influence-or-control | direct | false | A controlling interest. | |
1000287.interests.0 | 1000287 | other-influence-or-control | direct | false | A controlling interest. | |
1000288.interests.0 | 1000288 | other-influence-or-control | direct | false | A controlling interest. | |
1000289.interests.0 | 1000289 | other-influence-or-control | direct | false | A controlling interest. | |
100029.interests.0 | 100029 | other-influence-or-control | indirect | false | A controlling interest. | |
1000290.interests.0 | 1000290 | other-influence-or-control | direct | false | A controlling interest. | |
1000291.interests.0 | 1000291 | other-influence-or-control | direct | false | A controlling interest. | |
1000292.interests.0 | 1000292 | other-influence-or-control | direct | false | A controlling interest. | |
1000293.interests.0 | 1000293 | other-influence-or-control | direct | false | A controlling interest. | |
1000294.interests.0 | 1000294 | other-influence-or-control | direct | false | A controlling interest. | |
1000295.interests.0 | 1000295 | other-influence-or-control | direct | false | A controlling interest. | |
1000296.interests.0 | 1000296 | other-influence-or-control | direct | false | A controlling interest. | |
1000297.interests.0 | 1000297 | other-influence-or-control | direct | false | A controlling interest. | |
1000298.interests.0 | 1000298 | other-influence-or-control | direct | false | A controlling interest. | |
1000299.interests.0 | 1000299 | other-influence-or-control | direct | false | A controlling interest. | |
10003.interests.0 | 10003 | other-influence-or-control | direct | false | A controlling interest. | |
100030.interests.0 | 100030 | other-influence-or-control | indirect | false | A controlling interest. | |
1000300.interests.0 | 1000300 | other-influence-or-control | direct | false | A controlling interest. | |
1000301.interests.0 | 1000301 | other-influence-or-control | direct | false | A controlling interest. | |
1000302.interests.0 | 1000302 | other-influence-or-control | direct | false | A controlling interest. | |
1000303.interests.0 | 1000303 | other-influence-or-control | direct | false | A controlling interest. | |
1000304.interests.0 | 1000304 | other-influence-or-control | direct | false | A controlling interest. | |
1000305.interests.0 | 1000305 | other-influence-or-control | direct | false | A controlling interest. | |
1000306.interests.0 | 1000306 | other-influence-or-control | direct | false | A controlling interest. | |
1000307.interests.0 | 1000307 | other-influence-or-control | direct | false | A controlling interest. | |
1000308.interests.0 | 1000308 | other-influence-or-control | direct | false | A controlling interest. | |
1000309.interests.0 | 1000309 | other-influence-or-control | direct | false | A controlling interest. | |
100031.interests.0 | 100031 | other-influence-or-control | indirect | false | A controlling interest. | |
1000310.interests.0 | 1000310 | other-influence-or-control | direct | false | A controlling interest. | |
1000311.interests.0 | 1000311 | other-influence-or-control | direct | false | A controlling interest. | |
1000312.interests.0 | 1000312 | other-influence-or-control | direct | false | A controlling interest. | |
1000313.interests.0 | 1000313 | other-influence-or-control | direct | false | A controlling interest. | |
1000314.interests.0 | 1000314 | other-influence-or-control | direct | false | A controlling interest. | |
1000315.interests.0 | 1000315 | other-influence-or-control | direct | false | A controlling interest. | |
1000316.interests.0 | 1000316 | other-influence-or-control | direct | false | A controlling interest. | |
1000317.interests.0 | 1000317 | other-influence-or-control | direct | false | A controlling interest. | |
1000318.interests.0 | 1000318 | other-influence-or-control | direct | false | A controlling interest. | |
1000319.interests.0 | 1000319 | other-influence-or-control | direct | false | A controlling interest. | |
100032.interests.0 | 100032 | other-influence-or-control | indirect | false | A controlling interest. | |
1000320.interests.0 | 1000320 | other-influence-or-control | direct | false | A controlling interest. | |
1000321.interests.0 | 1000321 | other-influence-or-control | direct | false | A controlling interest. | |
1000322.interests.0 | 1000322 | other-influence-or-control | direct | false | A controlling interest. | |
1000323.interests.0 | 1000323 | other-influence-or-control | direct | false | A controlling interest. | |
1000324.interests.0 | 1000324 | other-influence-or-control | direct | false | A controlling interest. | |
1000325.interests.0 | 1000325 | other-influence-or-control | direct | false | A controlling interest. | |
1000326.interests.0 | 1000326 | other-influence-or-control | direct | false | A controlling interest. | |
1000327.interests.0 | 1000327 | other-influence-or-control | direct | false | A controlling interest. | |
1000328.interests.0 | 1000328 | other-influence-or-control | direct | false | A controlling interest. | |
1000329.interests.0 | 1000329 | other-influence-or-control | direct | false | A controlling interest. | |
100033.interests.0 | 100033 | other-influence-or-control | indirect | false | A controlling interest. | |
1000330.interests.0 | 1000330 | other-influence-or-control | direct | false | A controlling interest. | |
1000331.interests.0 | 1000331 | other-influence-or-control | direct | false | A controlling interest. | |
1000332.interests.0 | 1000332 | other-influence-or-control | direct | false | A controlling interest. | |
1000333.interests.0 | 1000333 | other-influence-or-control | direct | false | A controlling interest. | |
1000334.interests.0 | 1000334 | other-influence-or-control | direct | false | A controlling interest. | |
1000335.interests.0 | 1000335 | other-influence-or-control | direct | false | A controlling interest. | |
1000336.interests.0 | 1000336 | other-influence-or-control | direct | false | A controlling interest. | |
1000337.interests.0 | 1000337 | other-influence-or-control | direct | false | A controlling interest. | |
1000338.interests.0 | 1000338 | other-influence-or-control | direct | false | A controlling interest. | |
1000339.interests.0 | 1000339 | other-influence-or-control | direct | false | A controlling interest. | |
100034.interests.0 | 100034 | other-influence-or-control | indirect | false | A controlling interest. | |
1000340.interests.0 | 1000340 | other-influence-or-control | direct | false | A controlling interest. | |
1000341.interests.0 | 1000341 | other-influence-or-control | direct | false | A controlling interest. | |
1000342.interests.0 | 1000342 | other-influence-or-control | direct | false | A controlling interest. | |
1000343.interests.0 | 1000343 | other-influence-or-control | direct | false | A controlling interest. | |
1000344.interests.0 | 1000344 | other-influence-or-control | direct | false | A controlling interest. | |
1000345.interests.0 | 1000345 | other-influence-or-control | direct | false | A controlling interest. | |
1000346.interests.0 | 1000346 | other-influence-or-control | direct | false | A controlling interest. | |
1000347.interests.0 | 1000347 | other-influence-or-control | direct | false | A controlling interest. | |
1000348.interests.0 | 1000348 | other-influence-or-control | direct | false | A controlling interest. | |
1000349.interests.0 | 1000349 | other-influence-or-control | direct | false | A controlling interest. | |
100035.interests.0 | 100035 | other-influence-or-control | indirect | false | A controlling interest. | |
1000350.interests.0 | 1000350 | other-influence-or-control | direct | false | A controlling interest. | |
1000351.interests.0 | 1000351 | other-influence-or-control | direct | false | A controlling interest. | |
1000352.interests.0 | 1000352 | other-influence-or-control | direct | false | A controlling interest. | |
1000353.interests.0 | 1000353 | other-influence-or-control | direct | false | A controlling interest. | |
1000354.interests.0 | 1000354 | other-influence-or-control | direct | false | A controlling interest. |
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]) );