ooc_interests
3,901,936 rows sorted by details
This data as json, CSV (advanced)
_link | _link_ooc_statement | type | interestlevel | beneficialownershiporcontrol | details ▼ | startdate |
---|---|---|---|---|---|---|
990890.interests.0 | 990890 | other-influence-or-control | direct | false | 2023-05-18T07:34:33+02:00 | |
990891.interests.0 | 990891 | other-influence-or-control | indirect | false | 2000-04-24T02:00:00+02:00 | |
990892.interests.0 | 990892 | other-influence-or-control | direct | false | 2024-02-14T08:18:12Z | |
990893.interests.0 | 990893 | other-influence-or-control | indirect | false | 2024-02-14T08:18:14Z | |
990894.interests.0 | 990894 | other-influence-or-control | direct | false | 2003-02-21T00:00:00.000Z | |
990895.interests.0 | 990895 | other-influence-or-control | direct | false | 2022-01-06T00:00:00Z | |
990896.interests.0 | 990896 | other-influence-or-control | indirect | false | 2020-01-14T00:00:00Z | |
990897.interests.0 | 990897 | other-influence-or-control | direct | false | 2015-01-09T00:00:00.000Z | |
990898.interests.0 | 990898 | other-influence-or-control | indirect | false | 2018-03-21T00:00:00Z | |
990899.interests.0 | 990899 | other-influence-or-control | direct | false | 2016-12-01T00:00:00.000Z | |
990900.interests.0 | 990900 | other-influence-or-control | direct | false | 2020-10-08T00:00:00Z | |
990901.interests.0 | 990901 | other-influence-or-control | indirect | false | 2022-09-27T00:00:00Z | |
990902.interests.0 | 990902 | other-influence-or-control | direct | false | 2022-04-19T00:00:00Z | |
990903.interests.0 | 990903 | other-influence-or-control | indirect | false | 2022-04-19T00:00:00Z | |
990904.interests.0 | 990904 | other-influence-or-control | direct | false | 2017-12-19T00:00:00.000Z | |
990905.interests.0 | 990905 | other-influence-or-control | indirect | false | 2020-12-08T00:00:00.000Z | |
990906.interests.0 | 990906 | other-influence-or-control | direct | false | 2022-11-01T00:00:00+01:00 | |
990907.interests.0 | 990907 | other-influence-or-control | direct | false | 2022-11-01T00:00:00+01:00 | |
990908.interests.0 | 990908 | other-influence-or-control | direct | false | 2020-02-03T00:00:00Z | |
990909.interests.0 | 990909 | other-influence-or-control | indirect | false | 2020-02-03T00:00:00Z | |
990910.interests.0 | 990910 | other-influence-or-control | direct | false | 2018-09-08T00:00:00.000Z | |
990911.interests.0 | 990911 | other-influence-or-control | direct | false | 2018-09-07T23:00:00.000Z | |
990912.interests.0 | 990912 | other-influence-or-control | indirect | false | 2018-05-08T17:57:29.054Z | |
990913.interests.0 | 990913 | other-influence-or-control | direct | false | 2018-07-06T02:00:00+02:00 | |
990914.interests.0 | 990914 | other-influence-or-control | indirect | false | 2018-07-06T02:00:00+02:00 | |
990915.interests.0 | 990915 | other-influence-or-control | direct | false | 2019-02-28T00:00:00+00:00 | |
990916.interests.0 | 990916 | other-influence-or-control | direct | false | 2019-02-28T00:00:00+00:00 | |
990917.interests.0 | 990917 | other-influence-or-control | direct | false | 2020-12-04T00:00:00Z | |
990918.interests.0 | 990918 | other-influence-or-control | indirect | false | 2020-12-04T00:00:00Z | |
990919.interests.0 | 990919 | other-influence-or-control | direct | false | 2019-02-18T00:00:00Z | |
990920.interests.0 | 990920 | other-influence-or-control | indirect | false | 2019-02-18T00:00:00Z | |
990921.interests.0 | 990921 | other-influence-or-control | direct | false | 2023-08-03T00:00:00.000+02:00 | |
990922.interests.0 | 990922 | other-influence-or-control | direct | false | 2023-08-03T00:00:00.000+02:00 | |
990923.interests.0 | 990923 | other-influence-or-control | direct | false | 2013-07-05T00:00:00Z | |
990924.interests.0 | 990924 | other-influence-or-control | direct | false | 2013-07-05T00:00:00Z | |
990925.interests.0 | 990925 | other-influence-or-control | direct | false | 2020-06-21T00:00:00Z | |
990926.interests.0 | 990926 | other-influence-or-control | indirect | false | 2020-06-21T00:00:00Z | |
990927.interests.0 | 990927 | other-influence-or-control | direct | false | 2023-06-26T10:23:32Z | |
990928.interests.0 | 990928 | other-influence-or-control | direct | false | 2023-06-26T10:23:32Z | |
990929.interests.0 | 990929 | other-influence-or-control | direct | false | 2023-12-05T00:00:00+01:00 | |
990930.interests.0 | 990930 | other-influence-or-control | indirect | false | 2023-12-05T00:00:00+01:00 | |
990931.interests.0 | 990931 | other-influence-or-control | direct | false | 2018-02-06T00:00:00Z | |
990932.interests.0 | 990932 | other-influence-or-control | indirect | false | 2018-02-06T00:00:00Z | |
990933.interests.0 | 990933 | other-influence-or-control | direct | false | 2022-07-27T02:00:00+02:00 | |
990934.interests.0 | 990934 | other-influence-or-control | indirect | false | 2017-09-02T02:00:00+02:00 | |
990935.interests.0 | 990935 | other-influence-or-control | direct | false | 2001-11-28T00:00:00.000+01:00 | |
990936.interests.0 | 990936 | other-influence-or-control | direct | false | 2005-09-22T00:00:00Z | |
990937.interests.0 | 990937 | other-influence-or-control | direct | false | 2023-05-04T19:25:19.227Z | |
990938.interests.0 | 990938 | other-influence-or-control | direct | false | 2008-06-05T00:00:00.000Z | |
990939.interests.0 | 990939 | other-influence-or-control | indirect | false | 2008-06-05T00:00:00.000Z | |
990940.interests.0 | 990940 | other-influence-or-control | direct | false | 2021-04-26T00:00:00.000Z | |
990941.interests.0 | 990941 | other-influence-or-control | direct | false | 2017-06-01T00:00:00Z | |
990942.interests.0 | 990942 | other-influence-or-control | direct | false | 2007-08-21T00:00:00Z | |
990943.interests.0 | 990943 | other-influence-or-control | direct | false | 2022-12-31T00:00:00+01:00 | |
990944.interests.0 | 990944 | other-influence-or-control | direct | false | 2018-03-12T00:00:00.000Z | |
990945.interests.0 | 990945 | other-influence-or-control | indirect | false | 2018-03-12T00:00:00.000Z | |
990946.interests.0 | 990946 | other-influence-or-control | direct | false | 2023-05-02T15:05:41.001Z | |
990947.interests.0 | 990947 | other-influence-or-control | direct | false | 2023-05-02T15:05:41.132Z | |
990948.interests.0 | 990948 | other-influence-or-control | direct | false | 1999-06-09T00:00:00+02:00 | |
990949.interests.0 | 990949 | other-influence-or-control | direct | false | 2021-07-08T00:00:00.000Z | |
990950.interests.0 | 990950 | other-influence-or-control | indirect | false | 2021-07-08T00:00:00.000Z | |
990951.interests.0 | 990951 | other-influence-or-control | direct | false | 2023-01-09T00:00:00Z | |
990952.interests.0 | 990952 | other-influence-or-control | indirect | false | 2023-01-09T00:00:00Z | |
990953.interests.0 | 990953 | other-influence-or-control | direct | false | 2017-12-13T00:00:00.000Z | |
990954.interests.0 | 990954 | other-influence-or-control | direct | false | 2023-03-28T13:37:14.143Z | |
990955.interests.0 | 990955 | other-influence-or-control | direct | false | 2023-03-28T13:37:14.228Z | |
990956.interests.0 | 990956 | other-influence-or-control | direct | false | 2023-09-01T00:00:00.000+02:00 | |
990957.interests.0 | 990957 | other-influence-or-control | direct | false | 2014-07-07T00:00:00.000+02:00 | |
990958.interests.0 | 990958 | other-influence-or-control | direct | false | 2023-05-15T05:05:45+02:00 | |
990959.interests.0 | 990959 | other-influence-or-control | direct | false | 2016-11-25T00:00:00+00:00 | |
990960.interests.0 | 990960 | other-influence-or-control | indirect | false | 2016-11-25T00:00:00+00:00 | |
990961.interests.0 | 990961 | other-influence-or-control | direct | false | 2022-09-30T00:00:00+00:00 | |
990962.interests.0 | 990962 | other-influence-or-control | direct | false | 2021-12-31T00:00:00+01:00 | |
990963.interests.0 | 990963 | other-influence-or-control | indirect | false | 2021-12-31T00:00:00+01:00 | |
990964.interests.0 | 990964 | other-influence-or-control | direct | false | 2021-06-24T00:00:00Z | |
990965.interests.0 | 990965 | other-influence-or-control | direct | false | 2017-12-22T21:31:04Z | |
990966.interests.0 | 990966 | other-influence-or-control | indirect | false | 2017-12-22T21:31:04Z | |
990967.interests.0 | 990967 | other-influence-or-control | direct | false | 2023-06-28T00:00:00Z | |
990968.interests.0 | 990968 | other-influence-or-control | direct | false | 2023-06-28T00:00:00Z | |
990969.interests.0 | 990969 | other-influence-or-control | direct | false | 2020-12-17T00:00:00+00:00 | |
990970.interests.0 | 990970 | other-influence-or-control | direct | false | 2023-03-29T13:07:27.721Z | |
990971.interests.0 | 990971 | other-influence-or-control | direct | false | 2021-11-04T00:00:00Z | |
990972.interests.0 | 990972 | other-influence-or-control | indirect | false | 2017-10-23T00:00:00Z | |
990973.interests.0 | 990973 | other-influence-or-control | direct | false | 2018-01-25T00:00:00.000Z | |
990974.interests.0 | 990974 | other-influence-or-control | indirect | false | 2018-01-25T00:00:00.000Z | |
990975.interests.0 | 990975 | other-influence-or-control | direct | false | 2023-04-13T00:00:00Z | |
990976.interests.0 | 990976 | other-influence-or-control | indirect | false | 2023-04-13T00:00:00Z | |
990977.interests.0 | 990977 | other-influence-or-control | direct | false | 2023-05-09T13:15:11Z | |
990978.interests.0 | 990978 | other-influence-or-control | direct | false | 2023-05-09T13:15:11Z | |
990979.interests.0 | 990979 | other-influence-or-control | direct | false | 2017-01-01T00:00:00.000Z | |
990980.interests.0 | 990980 | other-influence-or-control | indirect | false | 2017-01-01T00:00:00.000Z | |
990981.interests.0 | 990981 | other-influence-or-control | direct | false | 2019-01-22T00:00:00.000Z | |
990982.interests.0 | 990982 | other-influence-or-control | indirect | false | 2019-11-27T00:00:00.000Z | |
990983.interests.0 | 990983 | other-influence-or-control | direct | false | 2015-10-21T00:00:00Z | |
990984.interests.0 | 990984 | other-influence-or-control | direct | false | 2015-10-21T00:00:00Z | |
990985.interests.0 | 990985 | other-influence-or-control | direct | false | 2022-11-02T00:00:00Z | |
990986.interests.0 | 990986 | other-influence-or-control | direct | false | 2015-06-30T00:00:00+00:00 | |
990987.interests.0 | 990987 | other-influence-or-control | direct | false | 2015-06-30T00:00:00+00:00 | |
990988.interests.0 | 990988 | other-influence-or-control | direct | false | 2017-10-04T00:00:00.000+02:00 | |
990989.interests.0 | 990989 | other-influence-or-control | direct | false | 2023-06-26T10:23:04Z |
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]) );