ooc_interests
3,833,993 rows sorted by startdate descending
This data as json, CSV (advanced)
Suggested facets: startdate (date)
_link | _link_ooc_statement | type | interestlevel | beneficialownershiporcontrol | startdate ▲ | details |
---|---|---|---|---|---|---|
253999.interests.0 | 253999 | other-influence-or-control | direct | false | 9970-12-01T00:00:00.000Z | |
58229.interests.0 | 58229 | other-influence-or-control | direct | false | 9940-12-31T00:00:00.000Z | |
222649.interests.0 | 222649 | other-influence-or-control | direct | false | 9940-12-31T00:00:00.000Z | |
111539.interests.0 | 111539 | other-influence-or-control | direct | false | 9930-01-11T00:00:00.000Z | |
30075.interests.0 | 30075 | other-influence-or-control | direct | false | 3015-10-30T00:00:00+01:00 | |
30076.interests.0 | 30076 | other-influence-or-control | indirect | false | 3015-10-30T00:00:00+01:00 | |
231477.interests.0 | 231477 | other-influence-or-control | direct | false | 3008-01-29T00:00:00.000Z | |
201022.interests.0 | 201022 | other-influence-or-control | direct | false | 2986-02-18T00:00:00.000Z | |
62797.interests.0 | 62797 | other-influence-or-control | direct | false | 2983-09-16T00:00:00.000Z | |
73014.interests.0 | 73014 | other-influence-or-control | indirect | false | 2918-05-31T00:00:00.000Z | |
137526.interests.0 | 137526 | other-influence-or-control | direct | false | 2300-09-20T00:00:00.000Z | |
247466.interests.0 | 247466 | other-influence-or-control | direct | false | 2160-03-30T00:00:00.000Z | |
2063.interests.0 | 2063 | other-influence-or-control | direct | false | 2147-04-08T00:00:00.000Z | |
2064.interests.0 | 2064 | other-influence-or-control | indirect | false | 2147-04-08T00:00:00.000Z | |
61381.interests.0 | 61381 | other-influence-or-control | direct | false | 2121-06-09T00:00:00.000Z | |
61382.interests.0 | 61382 | other-influence-or-control | indirect | false | 2121-06-09T00:00:00.000Z | |
59703.interests.0 | 59703 | other-influence-or-control | direct | false | 2105-10-26T00:00:00.000Z | |
59704.interests.0 | 59704 | other-influence-or-control | indirect | false | 2105-10-26T00:00:00.000Z | |
3126.interests.0 | 3126 | other-influence-or-control | indirect | false | 2099-12-31T00:00:00.000Z | |
120594.interests.0 | 120594 | other-influence-or-control | direct | false | 2070-08-16T00:00:00.000Z | |
44712.interests.0 | 44712 | other-influence-or-control | direct | false | 2032-11-01T00:00:00.000+01:00 | |
152454.interests.0 | 152454 | other-influence-or-control | indirect | false | 2032-05-27T00:00:00.000Z | |
133267.interests.0 | 133267 | other-influence-or-control | direct | false | 2028-10-17T00:00:00.000Z | |
317961.interests.0 | 317961 | other-influence-or-control | direct | false | 2028-05-18T00:00:00.000Z | |
49467.interests.0 | 49467 | other-influence-or-control | direct | false | 2028-04-20T12:00:00.000Z | |
263670.interests.0 | 263670 | other-influence-or-control | direct | false | 2028-04-12T00:00:00.000Z | |
286409.interests.0 | 286409 | other-influence-or-control | direct | false | 2028-02-27T00:00:00.000Z | |
286410.interests.0 | 286410 | other-influence-or-control | direct | false | 2028-02-27T00:00:00.000Z | |
5807.interests.0 | 5807 | other-influence-or-control | direct | false | 2028-01-31T00:00:00.000Z | |
149672.interests.0 | 149672 | other-influence-or-control | direct | false | 2027-08-23T00:00:00.000Z | |
147928.interests.0 | 147928 | other-influence-or-control | direct | false | 2027-05-26T00:00:00.000Z | |
341319.interests.0 | 341319 | other-influence-or-control | direct | false | 2027-03-30T00:00:00Z | |
341320.interests.0 | 341320 | other-influence-or-control | direct | false | 2027-03-30T00:00:00Z | |
50654.interests.0 | 50654 | other-influence-or-control | direct | false | 2027-01-16T00:00:00.000Z | |
111131.interests.0 | 111131 | other-influence-or-control | direct | false | 2026-12-31T23:00:00Z | |
146616.interests.0 | 146616 | other-influence-or-control | direct | false | 2026-12-31T12:00:00.000Z | |
259429.interests.0 | 259429 | other-influence-or-control | direct | false | 2026-12-31T12:00:00.000Z | |
293296.interests.0 | 293296 | other-influence-or-control | direct | false | 2026-12-31T12:00:00.000Z | |
111577.interests.0 | 111577 | other-influence-or-control | direct | false | 2026-12-31T00:00:00.000Z | |
178496.interests.0 | 178496 | other-influence-or-control | direct | false | 2026-12-31T00:00:00.000Z | |
215399.interests.0 | 215399 | other-influence-or-control | direct | false | 2026-12-31T00:00:00.000Z | |
216451.interests.0 | 216451 | other-influence-or-control | direct | false | 2026-11-14T00:00:00.000Z | |
256637.interests.0 | 256637 | other-influence-or-control | direct | false | 2026-05-05T00:00:00.000Z | |
63646.interests.0 | 63646 | other-influence-or-control | direct | false | 2026-04-26T00:00:00.000Z | |
218393.interests.0 | 218393 | other-influence-or-control | direct | false | 2025-07-23T12:00:00.000Z | |
265407.interests.0 | 265407 | other-influence-or-control | direct | false | 2025-06-02T00:00:00.000Z | |
242970.interests.0 | 242970 | other-influence-or-control | direct | false | 2025-06-01T00:00:00.000Z | |
325280.interests.0 | 325280 | other-influence-or-control | indirect | false | 2024-12-31T00:00:00.000Z | |
284257.interests.0 | 284257 | other-influence-or-control | direct | false | 2024-11-19T00:00:00.000Z | |
343473.interests.0 | 343473 | other-influence-or-control | direct | false | 2024-11-15T01:00:00Z | |
343474.interests.0 | 343474 | other-influence-or-control | direct | false | 2024-11-15T01:00:00Z | |
46206.interests.0 | 46206 | other-influence-or-control | direct | false | 2024-10-24T00:00:00.000Z | |
388302.interests.0 | 388302 | other-influence-or-control | direct | false | 2024-09-19T22:00:00Z | |
388303.interests.0 | 388303 | other-influence-or-control | direct | false | 2024-09-19T22:00:00Z | |
2283.interests.0 | 2283 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
6348.interests.0 | 6348 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
6349.interests.0 | 6349 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
52602.interests.0 | 52602 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
52603.interests.0 | 52603 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
63489.interests.0 | 63489 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
63490.interests.0 | 63490 | other-influence-or-control | direct | false | 2024-07-01T00:00:00.000Z | |
216571.interests.0 | 216571 | other-influence-or-control | direct | false | 2024-06-18T00:00:00.000+02:00 | |
388163.interests.0 | 388163 | other-influence-or-control | direct | false | 2024-06-11T22:00:00Z | |
388164.interests.0 | 388164 | other-influence-or-control | direct | false | 2024-06-11T22:00:00Z | |
49911.interests.0 | 49911 | other-influence-or-control | direct | false | 2024-06-11T00:00:00.000Z | |
49912.interests.0 | 49912 | other-influence-or-control | direct | false | 2024-06-11T00:00:00.000Z | |
388067.interests.0 | 388067 | other-influence-or-control | direct | false | 2024-06-09T22:00:00Z | |
388068.interests.0 | 388068 | other-influence-or-control | direct | false | 2024-06-09T22:00:00Z | |
61747.interests.0 | 61747 | other-influence-or-control | direct | false | 2024-06-02T00:00:00.000Z | |
49268.interests.0 | 49268 | other-influence-or-control | direct | false | 2024-06-01T00:00:00.000Z | |
52013.interests.0 | 52013 | other-influence-or-control | direct | false | 2024-06-01T00:00:00.000Z | |
52303.interests.0 | 52303 | other-influence-or-control | direct | false | 2024-06-01T00:00:00.000Z | |
61953.interests.0 | 61953 | other-influence-or-control | direct | false | 2024-06-01T00:00:00.000Z | |
75710.interests.0 | 75710 | other-influence-or-control | direct | false | 2024-05-23T00:00:00.000Z | |
75711.interests.0 | 75711 | other-influence-or-control | direct | false | 2024-05-23T00:00:00.000Z | |
59209.interests.0 | 59209 | other-influence-or-control | direct | false | 2024-05-10T00:00:00.000Z | |
2347.interests.0 | 2347 | other-influence-or-control | direct | false | 2024-05-02T00:00:00.000Z | |
2348.interests.0 | 2348 | other-influence-or-control | direct | false | 2024-05-02T00:00:00.000Z | |
173013.interests.0 | 173013 | other-influence-or-control | direct | false | 2024-05-02T00:00:00.000Z | |
53918.interests.0 | 53918 | other-influence-or-control | direct | false | 2024-04-25T00:00:00.000Z | |
388495.interests.0 | 388495 | other-influence-or-control | direct | false | 2024-04-14T22:00:00Z | |
388496.interests.0 | 388496 | other-influence-or-control | direct | false | 2024-04-14T22:00:00Z | |
62496.interests.0 | 62496 | other-influence-or-control | direct | false | 2024-04-11T00:00:00.000Z | |
388150.interests.0 | 388150 | other-influence-or-control | direct | false | 2024-04-02T22:00:00Z | |
388151.interests.0 | 388151 | other-influence-or-control | direct | false | 2024-04-02T22:00:00Z | |
388443.interests.0 | 388443 | other-influence-or-control | direct | false | 2024-04-02T22:00:00Z | |
388444.interests.0 | 388444 | other-influence-or-control | direct | false | 2024-04-02T22:00:00Z | |
388895.interests.0 | 388895 | other-influence-or-control | direct | false | 2024-04-02T00:00:00+02:00 | |
97427.interests.0 | 97427 | other-influence-or-control | direct | false | 2024-04-01T00:00:00Z | |
51167.interests.0 | 51167 | other-influence-or-control | direct | false | 2024-04-01T00:00:00.000Z | |
387132.interests.0 | 387132 | other-influence-or-control | direct | false | 2024-03-30T16:00:00Z | |
60948.interests.0 | 60948 | other-influence-or-control | direct | false | 2024-03-29T00:00:00.000Z | |
113944.interests.0 | 113944 | other-influence-or-control | direct | false | 2024-03-26T00:00:00+00:00 | |
117808.interests.0 | 117808 | other-influence-or-control | direct | false | 2024-03-26T00:00:00+00:00 | |
387204.interests.0 | 387204 | other-influence-or-control | direct | false | 2024-03-24T23:00:00Z | |
387205.interests.0 | 387205 | other-influence-or-control | direct | false | 2024-03-24T23:00:00Z | |
387586.interests.0 | 387586 | other-influence-or-control | direct | false | 2024-03-24T23:00:00Z | |
387587.interests.0 | 387587 | other-influence-or-control | direct | false | 2024-03-24T23:00:00Z | |
137308.interests.0 | 137308 | other-influence-or-control | direct | false | 2024-03-22T17:30:00.000Z | |
17185.interests.0 | 17185 | other-influence-or-control | direct | false | 2024-03-22T00: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 , [startdate] TIMESTAMP , [details] TEXT , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );