ooc_interests
3,833,993 rows
This data as json, CSV (advanced)
_link ▼ | _link_ooc_statement | type | interestlevel | beneficialownershiporcontrol | startdate | details |
---|---|---|---|---|---|---|
1000175.interests.0 | 1000175 | other-influence-or-control | direct | false | A controlling interest. | |
1000176.interests.0 | 1000176 | other-influence-or-control | direct | false | A controlling interest. | |
1000177.interests.0 | 1000177 | other-influence-or-control | direct | false | A controlling interest. | |
1000178.interests.0 | 1000178 | other-influence-or-control | direct | false | A controlling interest. | |
1000179.interests.0 | 1000179 | other-influence-or-control | direct | false | A controlling interest. | |
100018.interests.0 | 100018 | other-influence-or-control | indirect | false | 2018-06-27T18:30:00.001Z | |
1000180.interests.0 | 1000180 | other-influence-or-control | direct | false | A controlling interest. | |
1000181.interests.0 | 1000181 | other-influence-or-control | direct | false | A controlling interest. | |
1000182.interests.0 | 1000182 | other-influence-or-control | direct | false | A controlling interest. | |
1000183.interests.0 | 1000183 | other-influence-or-control | direct | false | A controlling interest. | |
1000184.interests.0 | 1000184 | other-influence-or-control | direct | false | A controlling interest. | |
1000185.interests.0 | 1000185 | other-influence-or-control | direct | false | A controlling interest. | |
1000186.interests.0 | 1000186 | other-influence-or-control | direct | false | A controlling interest. | |
1000187.interests.0 | 1000187 | other-influence-or-control | direct | false | A controlling interest. | |
1000188.interests.0 | 1000188 | other-influence-or-control | direct | false | A controlling interest. | |
1000189.interests.0 | 1000189 | other-influence-or-control | direct | false | A controlling interest. | |
100019.interests.0 | 100019 | other-influence-or-control | direct | false | 2018-06-17T18:30:00.001Z | |
1000190.interests.0 | 1000190 | other-influence-or-control | direct | false | A controlling interest. | |
1000191.interests.0 | 1000191 | other-influence-or-control | direct | false | A controlling interest. | |
1000192.interests.0 | 1000192 | other-influence-or-control | direct | false | A controlling interest. | |
1000193.interests.0 | 1000193 | other-influence-or-control | direct | false | A controlling interest. | |
1000194.interests.0 | 1000194 | other-influence-or-control | direct | false | A controlling interest. | |
1000195.interests.0 | 1000195 | other-influence-or-control | direct | false | A controlling interest. | |
1000196.interests.0 | 1000196 | other-influence-or-control | direct | false | A controlling interest. | |
1000197.interests.0 | 1000197 | other-influence-or-control | direct | false | A controlling interest. | |
1000198.interests.0 | 1000198 | other-influence-or-control | direct | false | A controlling interest. | |
1000199.interests.0 | 1000199 | other-influence-or-control | direct | false | A controlling interest. | |
10002.interests.0 | 10002 | other-influence-or-control | indirect | false | 2012-06-19T18:30:00.001Z | |
100020.interests.0 | 100020 | other-influence-or-control | indirect | false | 2018-06-17T18:30:00.001Z | |
1000200.interests.0 | 1000200 | other-influence-or-control | direct | false | A controlling interest. | |
1000201.interests.0 | 1000201 | other-influence-or-control | direct | false | A controlling interest. | |
1000202.interests.0 | 1000202 | other-influence-or-control | direct | false | A controlling interest. | |
1000203.interests.0 | 1000203 | other-influence-or-control | direct | false | A controlling interest. | |
1000204.interests.0 | 1000204 | other-influence-or-control | direct | false | A controlling interest. | |
1000205.interests.0 | 1000205 | other-influence-or-control | direct | false | A controlling interest. | |
1000206.interests.0 | 1000206 | other-influence-or-control | direct | false | A controlling interest. | |
1000207.interests.0 | 1000207 | other-influence-or-control | direct | false | A controlling interest. | |
1000208.interests.0 | 1000208 | other-influence-or-control | direct | false | A controlling interest. | |
1000209.interests.0 | 1000209 | other-influence-or-control | direct | false | A controlling interest. | |
100021.interests.0 | 100021 | other-influence-or-control | direct | false | 2016-05-29T18:30:00.001Z | |
1000210.interests.0 | 1000210 | other-influence-or-control | direct | false | A controlling interest. | |
1000211.interests.0 | 1000211 | other-influence-or-control | direct | false | A controlling interest. | |
1000212.interests.0 | 1000212 | other-influence-or-control | direct | false | A controlling interest. | |
1000213.interests.0 | 1000213 | other-influence-or-control | direct | false | A controlling interest. | |
1000214.interests.0 | 1000214 | other-influence-or-control | direct | false | A controlling interest. | |
1000215.interests.0 | 1000215 | other-influence-or-control | direct | false | A controlling interest. | |
1000216.interests.0 | 1000216 | other-influence-or-control | direct | false | A controlling interest. | |
1000217.interests.0 | 1000217 | other-influence-or-control | direct | false | A controlling interest. | |
1000218.interests.0 | 1000218 | other-influence-or-control | direct | false | A controlling interest. | |
1000219.interests.0 | 1000219 | other-influence-or-control | direct | false | A controlling interest. | |
100022.interests.0 | 100022 | other-influence-or-control | indirect | false | 2016-05-29T18:30:00.001Z | |
1000220.interests.0 | 1000220 | other-influence-or-control | direct | false | A controlling interest. | |
1000221.interests.0 | 1000221 | other-influence-or-control | direct | false | A controlling interest. | |
1000222.interests.0 | 1000222 | other-influence-or-control | direct | false | A controlling interest. | |
1000223.interests.0 | 1000223 | other-influence-or-control | direct | false | A controlling interest. | |
1000224.interests.0 | 1000224 | other-influence-or-control | direct | false | A controlling interest. | |
1000225.interests.0 | 1000225 | other-influence-or-control | direct | false | A controlling interest. | |
1000226.interests.0 | 1000226 | other-influence-or-control | direct | false | A controlling interest. | |
1000227.interests.0 | 1000227 | other-influence-or-control | direct | false | A controlling interest. | |
1000228.interests.0 | 1000228 | other-influence-or-control | direct | false | A controlling interest. | |
1000229.interests.0 | 1000229 | other-influence-or-control | direct | false | A controlling interest. | |
100023.interests.0 | 100023 | other-influence-or-control | direct | false | 2020-10-06T18:30:00.001Z | |
1000230.interests.0 | 1000230 | other-influence-or-control | direct | false | A controlling interest. | |
1000231.interests.0 | 1000231 | other-influence-or-control | direct | false | A controlling interest. | |
1000232.interests.0 | 1000232 | other-influence-or-control | direct | false | A controlling interest. | |
1000233.interests.0 | 1000233 | other-influence-or-control | direct | false | A controlling interest. | |
1000234.interests.0 | 1000234 | other-influence-or-control | direct | false | A controlling interest. | |
1000235.interests.0 | 1000235 | other-influence-or-control | direct | false | A controlling interest. | |
1000236.interests.0 | 1000236 | other-influence-or-control | direct | false | A controlling interest. | |
1000237.interests.0 | 1000237 | other-influence-or-control | direct | false | A controlling interest. | |
1000238.interests.0 | 1000238 | other-influence-or-control | direct | false | A controlling interest. | |
1000239.interests.0 | 1000239 | other-influence-or-control | direct | false | A controlling interest. | |
100024.interests.0 | 100024 | other-influence-or-control | indirect | false | 2020-10-06T18:30:00.001Z | |
1000240.interests.0 | 1000240 | other-influence-or-control | direct | false | A controlling interest. | |
1000241.interests.0 | 1000241 | other-influence-or-control | direct | false | A controlling interest. | |
1000242.interests.0 | 1000242 | other-influence-or-control | direct | false | A controlling interest. | |
1000243.interests.0 | 1000243 | other-influence-or-control | direct | false | A controlling interest. | |
1000244.interests.0 | 1000244 | other-influence-or-control | direct | false | A controlling interest. | |
1000245.interests.0 | 1000245 | other-influence-or-control | direct | false | A controlling interest. | |
1000246.interests.0 | 1000246 | other-influence-or-control | direct | false | A controlling interest. | |
1000247.interests.0 | 1000247 | other-influence-or-control | direct | false | A controlling interest. | |
1000248.interests.0 | 1000248 | other-influence-or-control | direct | false | A controlling interest. | |
1000249.interests.0 | 1000249 | other-influence-or-control | direct | false | A controlling interest. | |
100025.interests.0 | 100025 | other-influence-or-control | direct | false | 2016-01-05T18:30:00.001Z | |
1000250.interests.0 | 1000250 | other-influence-or-control | direct | false | A controlling interest. | |
1000251.interests.0 | 1000251 | other-influence-or-control | direct | false | A controlling interest. | |
1000252.interests.0 | 1000252 | other-influence-or-control | direct | false | A controlling interest. | |
1000253.interests.0 | 1000253 | other-influence-or-control | direct | false | A controlling interest. | |
1000254.interests.0 | 1000254 | other-influence-or-control | direct | false | A controlling interest. | |
1000255.interests.0 | 1000255 | other-influence-or-control | direct | false | A controlling interest. | |
1000256.interests.0 | 1000256 | other-influence-or-control | direct | false | A controlling interest. | |
1000257.interests.0 | 1000257 | other-influence-or-control | direct | false | A controlling interest. | |
1000258.interests.0 | 1000258 | other-influence-or-control | direct | false | A controlling interest. | |
1000259.interests.0 | 1000259 | other-influence-or-control | direct | false | A controlling interest. | |
100026.interests.0 | 100026 | other-influence-or-control | indirect | false | 2016-04-10T18:30:00.001Z | |
1000260.interests.0 | 1000260 | other-influence-or-control | direct | false | A controlling interest. | |
1000261.interests.0 | 1000261 | other-influence-or-control | direct | false | A controlling interest. | |
1000262.interests.0 | 1000262 | other-influence-or-control | direct | false | A controlling interest. | |
1000263.interests.0 | 1000263 | other-influence-or-control | direct | false | A controlling interest. | |
1000264.interests.0 | 1000264 | 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]) );