ooc_interests
3,901,936 rows sorted by startdate descending
This data as json, CSV (advanced)
These facets timed out: startdate
_link | _link_ooc_statement | type | interestlevel | beneficialownershiporcontrol | details | startdate ▲ |
---|---|---|---|---|---|---|
850189.interests.0 | 850189 | other-influence-or-control | direct | false | 9980-12-31T00:00:00.000Z | |
1820032.interests.0 | 1820032 | other-influence-or-control | direct | false | 9970-12-01T00:00:00.000Z | |
1866340.interests.0 | 1866340 | other-influence-or-control | direct | false | 9940-12-31T00:00:00.000Z | |
2167095.interests.0 | 2167095 | other-influence-or-control | direct | false | 9940-12-31T00:00:00.000Z | |
850875.interests.0 | 850875 | other-influence-or-control | direct | false | 9930-01-11T00:00:00.000Z | |
2784203.interests.0 | 2784203 | other-influence-or-control | direct | false | 9900-01-21T00:00:00.000Z | |
836972.interests.0 | 836972 | other-influence-or-control | direct | false | 3015-10-30T00:00:00+01:00 | |
836973.interests.0 | 836973 | other-influence-or-control | indirect | false | 3015-10-30T00:00:00+01:00 | |
1975438.interests.0 | 1975438 | other-influence-or-control | direct | false | 3008-01-29T00:00:00.000Z | |
2887615.interests.0 | 2887615 | other-influence-or-control | direct | false | 2986-02-18T00:00:00.000Z | |
3451196.interests.0 | 3451196 | other-influence-or-control | direct | false | 2983-09-16T00:00:00.000Z | |
3646715.interests.0 | 3646715 | other-influence-or-control | indirect | false | 2918-05-31T00:00:00.000Z | |
60464.interests.0 | 60464 | other-influence-or-control | direct | false | 2300-09-20T00:00:00.000Z | |
431157.interests.0 | 431157 | other-influence-or-control | direct | false | 2160-03-30T00:00:00.000Z | |
3641895.interests.0 | 3641895 | other-influence-or-control | direct | false | 2147-04-08T00:00:00.000Z | |
3641896.interests.0 | 3641896 | other-influence-or-control | indirect | false | 2147-04-08T00:00:00.000Z | |
1869573.interests.0 | 1869573 | other-influence-or-control | direct | false | 2121-06-09T00:00:00.000Z | |
1869574.interests.0 | 1869574 | other-influence-or-control | indirect | false | 2121-06-09T00:00:00.000Z | |
1867847.interests.0 | 1867847 | other-influence-or-control | direct | false | 2105-10-26T00:00:00.000Z | |
1867848.interests.0 | 1867848 | other-influence-or-control | indirect | false | 2105-10-26T00:00:00.000Z | |
3643006.interests.0 | 3643006 | other-influence-or-control | indirect | false | 2099-12-31T00:00:00.000Z | |
3798854.interests.0 | 3798854 | other-influence-or-control | direct | false | 2070-08-16T00:00:00.000Z | |
3175594.interests.0 | 3175594 | other-influence-or-control | direct | false | 2040-05-29T00:00:00.000Z | |
274324.interests.0 | 274324 | other-influence-or-control | direct | false | 2032-11-01T00:00:00.000+01:00 | |
1553576.interests.0 | 1553576 | other-influence-or-control | indirect | false | 2032-05-27T00:00:00.000Z | |
56229.interests.0 | 56229 | other-influence-or-control | direct | false | 2028-10-17T00:00:00.000Z | |
1944212.interests.0 | 1944212 | other-influence-or-control | direct | false | 2028-05-31T00:00:00.000Z | |
3178781.interests.0 | 3178781 | other-influence-or-control | direct | false | 2028-05-18T00:00:00.000Z | |
3673602.interests.0 | 3673602 | other-influence-or-control | direct | false | 2028-04-20T12:00:00.000Z | |
225329.interests.0 | 225329 | other-influence-or-control | direct | false | 2028-02-27T00:00:00.000Z | |
225330.interests.0 | 225330 | other-influence-or-control | direct | false | 2028-02-27T00:00:00.000Z | |
3645762.interests.0 | 3645762 | other-influence-or-control | direct | false | 2028-01-31T00:00:00.000Z | |
1550793.interests.0 | 1550793 | other-influence-or-control | direct | false | 2027-08-23T00:00:00.000Z | |
1549060.interests.0 | 1549060 | other-influence-or-control | direct | false | 2027-05-26T00:00:00.000Z | |
331638.interests.0 | 331638 | other-influence-or-control | direct | false | 2027-03-30T00:00:00Z | |
331639.interests.0 | 331639 | other-influence-or-control | direct | false | 2027-03-30T00:00:00Z | |
3674828.interests.0 | 3674828 | other-influence-or-control | direct | false | 2027-01-16T00:00:00.000Z | |
850477.interests.0 | 850477 | other-influence-or-control | direct | false | 2026-12-31T23:00:00Z | |
1547755.interests.0 | 1547755 | other-influence-or-control | direct | false | 2026-12-31T12:00:00.000Z | |
2800818.interests.0 | 2800818 | other-influence-or-control | direct | false | 2026-12-31T12:00:00.000Z | |
3748339.interests.0 | 3748339 | other-influence-or-control | direct | false | 2026-12-31T12:00:00.000Z | |
850911.interests.0 | 850911 | other-influence-or-control | direct | false | 2026-12-31T00:00:00.000Z | |
1941152.interests.0 | 1941152 | other-influence-or-control | direct | false | 2026-12-31T00:00:00.000Z | |
3178824.interests.0 | 3178824 | other-influence-or-control | direct | false | 2026-12-31T00:00:00.000Z | |
3490895.interests.0 | 3490895 | other-influence-or-control | direct | false | 2026-12-31T00:00:00.000Z | |
3814322.interests.0 | 3814322 | other-influence-or-control | direct | false | 2026-12-31T00:00:00.000Z | |
1942201.interests.0 | 1942201 | other-influence-or-control | direct | false | 2026-11-14T00:00:00.000Z | |
1868489.interests.0 | 1868489 | other-influence-or-control | direct | false | 2026-07-18T00:00:00.000Z | |
1822668.interests.0 | 1822668 | other-influence-or-control | direct | false | 2026-05-05T00:00:00.000Z | |
3452057.interests.0 | 3452057 | other-influence-or-control | direct | false | 2026-04-26T00:00:00.000Z | |
1944145.interests.0 | 1944145 | other-influence-or-control | direct | false | 2025-07-23T12:00:00.000Z | |
3754297.interests.0 | 3754297 | other-influence-or-control | direct | false | 2025-06-02T00:00:00.000Z | |
3814867.interests.0 | 3814867 | other-influence-or-control | direct | false | 2025-06-01T00:00:00.000Z | |
227008.interests.0 | 227008 | other-influence-or-control | direct | false | 2024-12-31T00:00:00.000Z | |
2887683.interests.0 | 2887683 | other-influence-or-control | direct | false | 2024-12-31T00:00:00.000Z | |
3179498.interests.0 | 3179498 | other-influence-or-control | indirect | false | 2024-12-31T00:00:00.000Z | |
3485741.interests.0 | 3485741 | other-influence-or-control | direct | false | 2024-12-31T00:00:00.000Z | |
1867482.interests.0 | 1867482 | other-influence-or-control | direct | false | 2024-12-01T00:00:00.000Z | |
3483421.interests.0 | 3483421 | other-influence-or-control | direct | false | 2024-11-19T00:00:00.000Z | |
333924.interests.0 | 333924 | other-influence-or-control | direct | false | 2024-11-15T01:00:00Z | |
333925.interests.0 | 333925 | other-influence-or-control | direct | false | 2024-11-15T01:00:00Z | |
275845.interests.0 | 275845 | other-influence-or-control | direct | false | 2024-10-24T00:00:00.000Z | |
96912.interests.0 | 96912 | other-influence-or-control | direct | false | 2024-09-19T22:00:00Z | |
96913.interests.0 | 96913 | other-influence-or-control | direct | false | 2024-09-19T22:00:00Z | |
97003.interests.0 | 97003 | other-influence-or-control | direct | false | 2024-09-01T22:00:00Z | |
97004.interests.0 | 97004 | other-influence-or-control | direct | false | 2024-09-01T22:00:00Z | |
3642842.interests.0 | 3642842 | other-influence-or-control | direct | false | 2024-08-16T00:00:00.000Z | |
3642843.interests.0 | 3642843 | other-influence-or-control | direct | false | 2024-08-16T00:00:00.000Z | |
275696.interests.0 | 275696 | other-influence-or-control | direct | false | 2024-08-01T00:00:00.000Z | |
96880.interests.0 | 96880 | other-influence-or-control | direct | false | 2024-07-31T22:00:00Z | |
96881.interests.0 | 96881 | other-influence-or-control | direct | false | 2024-07-31T22:00:00Z | |
3451897.interests.0 | 3451897 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
3451898.interests.0 | 3451898 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
3642124.interests.0 | 3642124 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
3646310.interests.0 | 3646310 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
3646311.interests.0 | 3646311 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
3676846.interests.0 | 3676846 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
3676847.interests.0 | 3676847 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
1161340.interests.0 | 1161340 | other-influence-or-control | direct | false | 2024-07-01T00:00:00+00:00 | |
97093.interests.0 | 97093 | other-influence-or-control | direct | false | 2024-06-30T22:00:00Z | |
97094.interests.0 | 97094 | other-influence-or-control | direct | false | 2024-06-30T22:00:00Z | |
728242.interests.0 | 728242 | other-influence-or-control | direct | false | 2024-06-29T00:00:00.000Z | |
1865935.interests.0 | 1865935 | other-influence-or-control | direct | false | 2024-06-25T00:00:00.000Z | |
3646300.interests.0 | 3646300 | other-influence-or-control | direct | false | 2024-06-25T00:00:00.000Z | |
3643438.interests.0 | 3643438 | other-influence-or-control | direct | false | 2024-06-20T00:00:00.000Z | |
3643439.interests.0 | 3643439 | other-influence-or-control | direct | false | 2024-06-20T00:00:00.000Z | |
3647883.interests.0 | 3647883 | other-influence-or-control | direct | false | 2024-06-20T00:00:00.000Z | |
1866809.interests.0 | 1866809 | other-influence-or-control | direct | false | 2024-06-17T00:00:00.000Z | |
3648140.interests.0 | 3648140 | other-influence-or-control | direct | false | 2024-06-13T00:00:00.000Z | |
3676165.interests.0 | 3676165 | other-influence-or-control | direct | false | 2024-06-13T00:00:00.000Z | |
3454031.interests.0 | 3454031 | other-influence-or-control | direct | false | 2024-06-12T00:00:00.000Z | |
3454032.interests.0 | 3454032 | other-influence-or-control | direct | false | 2024-06-12T00:00:00.000Z | |
3675777.interests.0 | 3675777 | other-influence-or-control | direct | false | 2024-06-12T00:00:00.000Z | |
3675778.interests.0 | 3675778 | other-influence-or-control | direct | false | 2024-06-12T00:00:00.000Z | |
96765.interests.0 | 96765 | other-influence-or-control | direct | false | 2024-06-11T22:00:00Z | |
96766.interests.0 | 96766 | other-influence-or-control | direct | false | 2024-06-11T22:00:00Z | |
3674062.interests.0 | 3674062 | other-influence-or-control | direct | false | 2024-06-11T00:00:00.000Z | |
3674063.interests.0 | 3674063 | other-influence-or-control | direct | false | 2024-06-11T00:00:00.000Z | |
96669.interests.0 | 96669 | other-influence-or-control | direct | false | 2024-06-09T22:00:00Z | |
96670.interests.0 | 96670 | other-influence-or-control | direct | false | 2024-06-09T22: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 , [details] TEXT , [startdate] TIMESTAMP , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );