ooc_interests
3,833,993 rows sorted by beneficialownershiporcontrol
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 | |
990000.interests.0 | 990000 | other-influence-or-control | direct | false | A controlling interest. | |
990001.interests.0 | 990001 | other-influence-or-control | direct | false | A controlling interest. | |
990002.interests.0 | 990002 | other-influence-or-control | direct | false | A controlling interest. | |
990003.interests.0 | 990003 | other-influence-or-control | direct | false | A controlling interest. | |
990004.interests.0 | 990004 | other-influence-or-control | direct | false | A controlling interest. | |
990005.interests.0 | 990005 | other-influence-or-control | direct | false | A controlling interest. | |
990006.interests.0 | 990006 | other-influence-or-control | direct | false | A controlling interest. | |
990007.interests.0 | 990007 | other-influence-or-control | direct | false | A controlling interest. | |
990008.interests.0 | 990008 | other-influence-or-control | direct | false | A controlling interest. | |
990009.interests.0 | 990009 | other-influence-or-control | direct | false | A controlling interest. | |
99001.interests.0 | 99001 | other-influence-or-control | indirect | false | 2017-08-30T00:00:00Z | |
990010.interests.0 | 990010 | other-influence-or-control | direct | false | A controlling interest. | |
990011.interests.0 | 990011 | other-influence-or-control | direct | false | A controlling interest. | |
990012.interests.0 | 990012 | other-influence-or-control | direct | false | A controlling interest. | |
990013.interests.0 | 990013 | other-influence-or-control | direct | false | A controlling interest. | |
990014.interests.0 | 990014 | other-influence-or-control | direct | false | A controlling interest. | |
990015.interests.0 | 990015 | other-influence-or-control | direct | false | A controlling interest. | |
990016.interests.0 | 990016 | other-influence-or-control | direct | false | A controlling interest. | |
990017.interests.0 | 990017 | other-influence-or-control | direct | false | A controlling interest. | |
990018.interests.0 | 990018 | other-influence-or-control | direct | false | A controlling interest. | |
990019.interests.0 | 990019 | other-influence-or-control | direct | false | A controlling interest. | |
99002.interests.0 | 99002 | other-influence-or-control | direct | false | 2023-12-15T00:00:00Z | |
990020.interests.0 | 990020 | other-influence-or-control | direct | false | A controlling interest. | |
990021.interests.0 | 990021 | other-influence-or-control | direct | false | A controlling interest. | |
990022.interests.0 | 990022 | other-influence-or-control | direct | false | A controlling interest. | |
990023.interests.0 | 990023 | other-influence-or-control | direct | false | A controlling interest. | |
990024.interests.0 | 990024 | other-influence-or-control | direct | false | A controlling interest. | |
990025.interests.0 | 990025 | other-influence-or-control | direct | false | A controlling interest. | |
990026.interests.0 | 990026 | other-influence-or-control | direct | false | A controlling interest. | |
990027.interests.0 | 990027 | other-influence-or-control | direct | false | A controlling interest. | |
990028.interests.0 | 990028 | other-influence-or-control | direct | false | A controlling interest. | |
990029.interests.0 | 990029 | other-influence-or-control | direct | false | A controlling interest. | |
99003.interests.0 | 99003 | other-influence-or-control | direct | false | 2007-02-19T00:00:00Z | |
990030.interests.0 | 990030 | other-influence-or-control | direct | false | A controlling interest. | |
990031.interests.0 | 990031 | other-influence-or-control | direct | false | A controlling interest. | |
990032.interests.0 | 990032 | other-influence-or-control | direct | false | A controlling interest. | |
990033.interests.0 | 990033 | other-influence-or-control | direct | false | A controlling interest. | |
990034.interests.0 | 990034 | other-influence-or-control | direct | false | A controlling interest. | |
990035.interests.0 | 990035 | other-influence-or-control | direct | false | A controlling interest. | |
990036.interests.0 | 990036 | other-influence-or-control | direct | false | A controlling interest. | |
990037.interests.0 | 990037 | other-influence-or-control | direct | false | A controlling interest. | |
990038.interests.0 | 990038 | other-influence-or-control | direct | false | A controlling interest. | |
990039.interests.0 | 990039 | other-influence-or-control | direct | false | A controlling interest. | |
99004.interests.0 | 99004 | other-influence-or-control | direct | false | 2022-10-05T00:00:00Z | |
990040.interests.0 | 990040 | other-influence-or-control | direct | false | A controlling interest. | |
990041.interests.0 | 990041 | other-influence-or-control | direct | false | A controlling interest. | |
990042.interests.0 | 990042 | other-influence-or-control | direct | false | A controlling interest. | |
990043.interests.0 | 990043 | other-influence-or-control | direct | false | A controlling interest. | |
990044.interests.0 | 990044 | other-influence-or-control | direct | false | A controlling interest. | |
990045.interests.0 | 990045 | other-influence-or-control | direct | false | A controlling interest. | |
990046.interests.0 | 990046 | other-influence-or-control | direct | false | A controlling interest. | |
990047.interests.0 | 990047 | other-influence-or-control | direct | false | A controlling interest. | |
990048.interests.0 | 990048 | other-influence-or-control | direct | false | A controlling interest. | |
990049.interests.0 | 990049 | other-influence-or-control | direct | false | A controlling interest. | |
99005.interests.0 | 99005 | other-influence-or-control | direct | false | 2014-01-08T00:00:00Z | |
990050.interests.0 | 990050 | other-influence-or-control | direct | false | A controlling interest. | |
990051.interests.0 | 990051 | other-influence-or-control | direct | false | A controlling interest. | |
990052.interests.0 | 990052 | other-influence-or-control | direct | false | A controlling interest. | |
990053.interests.0 | 990053 | other-influence-or-control | direct | false | A controlling interest. | |
990054.interests.0 | 990054 | other-influence-or-control | direct | false | A controlling interest. | |
990055.interests.0 | 990055 | other-influence-or-control | direct | false | A controlling interest. | |
990056.interests.0 | 990056 | other-influence-or-control | direct | false | A controlling interest. | |
990057.interests.0 | 990057 | other-influence-or-control | direct | false | A controlling interest. | |
990058.interests.0 | 990058 | other-influence-or-control | direct | false | A controlling interest. | |
990059.interests.0 | 990059 | other-influence-or-control | direct | false | A controlling interest. | |
99006.interests.0 | 99006 | other-influence-or-control | indirect | false | 2014-01-08T00:00:00Z | |
990060.interests.0 | 990060 | other-influence-or-control | direct | false | A controlling interest. | |
990061.interests.0 | 990061 | other-influence-or-control | direct | false | A controlling interest. | |
990062.interests.0 | 990062 | other-influence-or-control | direct | false | A controlling interest. | |
990063.interests.0 | 990063 | other-influence-or-control | direct | false | A controlling interest. | |
990064.interests.0 | 990064 | other-influence-or-control | direct | false | A controlling interest. | |
990065.interests.0 | 990065 | other-influence-or-control | direct | false | A controlling interest. | |
990066.interests.0 | 990066 | other-influence-or-control | direct | false | A controlling interest. | |
990067.interests.0 | 990067 | other-influence-or-control | direct | false | A controlling interest. | |
990068.interests.0 | 990068 | other-influence-or-control | direct | false | A controlling interest. | |
990069.interests.0 | 990069 | other-influence-or-control | direct | false | A controlling interest. | |
99007.interests.0 | 99007 | other-influence-or-control | direct | false | 2018-06-11T00:00:00Z | |
990070.interests.0 | 990070 | other-influence-or-control | direct | false | A controlling interest. | |
990071.interests.0 | 990071 | other-influence-or-control | direct | false | A controlling interest. | |
990072.interests.0 | 990072 | other-influence-or-control | direct | false | A controlling interest. | |
990073.interests.0 | 990073 | other-influence-or-control | direct | false | A controlling interest. | |
990074.interests.0 | 990074 | other-influence-or-control | direct | false | A controlling interest. | |
990075.interests.0 | 990075 | other-influence-or-control | direct | false | A controlling interest. | |
990076.interests.0 | 990076 | other-influence-or-control | direct | false | A controlling interest. | |
990077.interests.0 | 990077 | other-influence-or-control | direct | false | A controlling interest. | |
990078.interests.0 | 990078 | other-influence-or-control | direct | false | A controlling interest. | |
990079.interests.0 | 990079 | other-influence-or-control | direct | false | A controlling interest. | |
99008.interests.0 | 99008 | other-influence-or-control | direct | false | 2019-12-23T00:00:00Z | |
990080.interests.0 | 990080 | other-influence-or-control | direct | false | A controlling interest. | |
990081.interests.0 | 990081 | other-influence-or-control | direct | false | A controlling interest. | |
990082.interests.0 | 990082 | other-influence-or-control | direct | false | A controlling interest. | |
990083.interests.0 | 990083 | other-influence-or-control | direct | false | A controlling interest. | |
990084.interests.0 | 990084 | other-influence-or-control | direct | false | A controlling interest. | |
990085.interests.0 | 990085 | other-influence-or-control | direct | false | A controlling interest. | |
990086.interests.0 | 990086 | other-influence-or-control | direct | false | A controlling interest. | |
990087.interests.0 | 990087 | other-influence-or-control | direct | false | A controlling interest. | |
990088.interests.0 | 990088 | 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 , [startdate] TIMESTAMP , [details] TEXT , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );