ooc_interests
1,826,491 rows
This data as json, CSV (advanced)
These facets timed out: enddate, startdate
_link ▼ | _link_ooc_statement | type | startdate | share_exact | share_maximum | share_minimum | enddate |
---|---|---|---|---|---|---|---|
1000051.interests.0 | 1000051 | shareholding | 2014-01-01 | 33.33 | 33.33 | 33.33 | |
1000051.interests.1 | 1000051 | voting-rights | 2014-01-01 | 33.33 | 33.33 | 33.33 | |
1000052.interests.0 | 1000052 | shareholding | 2022-10-01 | 40 | 40 | 40 | |
1000052.interests.1 | 1000052 | voting-rights | 2022-10-01 | 40 | 40 | 40 | |
1000053.interests.0 | 1000053 | shareholding | 2022-02-15 | 50 | 50 | 50 | |
1000053.interests.1 | 1000053 | voting-rights | 2022-02-15 | 50 | 50 | 50 | |
1000054.interests.0 | 1000054 | shareholding | 2018-12-19 | 100 | 100 | 100 | 2023-09-18 |
1000054.interests.1 | 1000054 | voting-rights | 2018-12-19 | 100 | 100 | 100 | 2023-09-18 |
1000056.interests.0 | 1000056 | shareholding | 2021-11-15 | 50 | 50 | 50 | 2022-06-15 |
1000056.interests.1 | 1000056 | voting-rights | 2021-11-15 | 50 | 50 | 50 | 2022-06-15 |
1000057.interests.0 | 1000057 | shareholding | 2016-02-17 | 100 | 100 | 100 | |
1000057.interests.1 | 1000057 | voting-rights | 2016-02-17 | 100 | 100 | 100 | |
100006.interests.0 | 100006 | shareholding | 2018-09-11 | 100 | 100 | 100 | |
100006.interests.1 | 100006 | voting-rights | 2018-09-11 | 100 | 100 | 100 | |
1000061.interests.0 | 1000061 | shareholding | 2017-10-23 | 50 | 50 | 50 | 2022-01-01 |
1000061.interests.1 | 1000061 | voting-rights | 2017-10-23 | 50 | 50 | 50 | 2022-01-01 |
1000062.interests.0 | 1000062 | shareholding | 2020-09-01 | 100 | 100 | 100 | 2021-04-01 |
1000062.interests.1 | 1000062 | voting-rights | 2020-09-01 | 100 | 100 | 100 | 2021-04-01 |
1000063.interests.0 | 1000063 | shareholding | 2019-01-01 | 50 | 50 | 50 | |
1000063.interests.1 | 1000063 | voting-rights | 2019-01-01 | 50 | 50 | 50 | |
1000065.interests.0 | 1000065 | shareholding | 2023-08-22 | 100 | 100 | 100 | |
1000065.interests.1 | 1000065 | voting-rights | 2023-08-22 | 100 | 100 | 100 | |
1000066.interests.0 | 1000066 | shareholding | 2021-05-27 | 33.33 | 33.33 | 33.33 | |
1000066.interests.1 | 1000066 | voting-rights | 2021-05-27 | 33.33 | 33.33 | 33.33 | |
1000067.interests.0 | 1000067 | shareholding | 2022-08-18 | 100 | 100 | 100 | |
1000067.interests.1 | 1000067 | voting-rights | 2022-08-18 | 100 | 100 | 100 | |
1000068.interests.0 | 1000068 | shareholding | 2019-07-30 | 100 | 100 | 100 | 2022-05-30 |
1000068.interests.1 | 1000068 | voting-rights | 2019-07-30 | 100 | 100 | 100 | 2022-05-30 |
1000069.interests.0 | 1000069 | shareholding | 2014-12-26 | 100 | 100 | 100 | 2018-08-13 |
1000069.interests.1 | 1000069 | voting-rights | 2014-12-26 | 100 | 100 | 100 | 2018-08-13 |
100007.interests.0 | 100007 | shareholding | 2008-04-28 | 50 | 50 | 50 | 2018-07-04 |
100007.interests.1 | 100007 | voting-rights | 2008-04-28 | 50 | 50 | 50 | 2018-07-04 |
1000071.interests.0 | 1000071 | shareholding | 2017-08-25 | 100 | 100 | 100 | 2020-12-18 |
1000071.interests.1 | 1000071 | voting-rights | 2017-08-25 | 100 | 100 | 100 | 2020-12-18 |
1000072.interests.0 | 1000072 | shareholding | 2022-06-16 | 100 | 100 | 100 | |
1000072.interests.1 | 1000072 | voting-rights | 2022-06-16 | 100 | 100 | 100 | |
1000073.interests.0 | 1000073 | shareholding | 2023-10-25 | 32.5 | 32.5 | 32.5 | |
1000073.interests.1 | 1000073 | voting-rights | 2023-10-25 | 32.5 | 32.5 | 32.5 | |
1000074.interests.0 | 1000074 | shareholding | 2014-12-22 | 100 | 100 | 100 | 2018-08-13 |
1000074.interests.1 | 1000074 | voting-rights | 2014-12-22 | 100 | 100 | 100 | 2018-08-13 |
1000075.interests.0 | 1000075 | shareholding | 2022-04-12 | 100 | 100 | 100 | |
1000075.interests.1 | 1000075 | voting-rights | 2022-04-12 | 100 | 100 | 100 | |
1000077.interests.0 | 1000077 | shareholding | 2020-02-19 | 28.799999999999997 | 28.799999999999997 | 28.799999999999997 | |
1000077.interests.1 | 1000077 | voting-rights | 2020-02-19 | 28.799999999999997 | 28.799999999999997 | 28.799999999999997 | |
1000078.interests.0 | 1000078 | shareholding | 2019-08-12 | 100 | 100 | 100 | 2023-07-10 |
1000078.interests.1 | 1000078 | voting-rights | 2019-08-12 | 100 | 100 | 100 | 2023-07-10 |
1000079.interests.0 | 1000079 | shareholding | 2004-06-07 | 100 | 100 | 100 | |
1000079.interests.1 | 1000079 | voting-rights | 2004-06-07 | 100 | 100 | 100 | |
100008.interests.0 | 100008 | shareholding | 2017-11-23 | 50 | 50 | 50 | 2020-12-31 |
100008.interests.1 | 100008 | voting-rights | 2017-11-23 | 50 | 50 | 50 | 2020-12-31 |
1000080.interests.0 | 1000080 | shareholding | 2021-03-26 | 100 | 100 | 100 | 2023-07-10 |
1000080.interests.1 | 1000080 | voting-rights | 2021-03-26 | 100 | 100 | 100 | 2023-07-10 |
1000081.interests.0 | 1000081 | shareholding | 2020-06-09 | 100 | 100 | 100 | 2023-09-05 |
1000081.interests.1 | 1000081 | voting-rights | 2020-06-09 | 100 | 100 | 100 | 2023-09-05 |
1000082.interests.0 | 1000082 | shareholding | 2017-10-18 | 100 | 100 | 100 | 2023-11-17 |
1000082.interests.1 | 1000082 | voting-rights | 2017-10-18 | 100 | 100 | 100 | 2023-11-17 |
1000083.interests.0 | 1000083 | shareholding | 2023-11-21 | 99.99 | 99.99 | 99.99 | |
1000084.interests.0 | 1000084 | shareholding | 1997-11-21 | 100 | 100 | 100 | |
1000084.interests.1 | 1000084 | voting-rights | 1997-11-21 | 100 | 100 | 100 | |
1000085.interests.0 | 1000085 | shareholding | 2017-10-01 | 50 | 50 | 50 | 2018-09-09 |
1000085.interests.1 | 1000085 | voting-rights | 2017-10-01 | 50 | 50 | 50 | 2018-09-09 |
1000086.interests.0 | 1000086 | shareholding | 2022-11-29 | 100 | 100 | 100 | |
1000086.interests.1 | 1000086 | voting-rights | 2022-11-29 | 100 | 100 | 100 | |
1000087.interests.0 | 1000087 | shareholding | 2013-09-01 | 100 | 100 | 100 | |
1000087.interests.1 | 1000087 | voting-rights | 2013-09-01 | 100 | 100 | 100 | |
1000089.interests.0 | 1000089 | shareholding | 2017-02-27 | 100 | 100 | 100 | |
1000089.interests.1 | 1000089 | voting-rights | 2017-02-27 | 100 | 100 | 100 | |
100009.interests.0 | 100009 | shareholding | 2015-03-01 | 49 | 49 | 49 | |
100009.interests.1 | 100009 | voting-rights | 2015-03-01 | 49 | 49 | 49 | |
1000090.interests.0 | 1000090 | shareholding | 2023-06-20 | 50 | 50 | 50 | |
1000090.interests.1 | 1000090 | voting-rights | 2023-06-20 | 50 | 50 | 50 | |
1000091.interests.0 | 1000091 | shareholding | 2020-11-18 | 100 | 100 | 100 | |
1000091.interests.1 | 1000091 | voting-rights | 2020-11-18 | 100 | 100 | 100 | |
1000095.interests.0 | 1000095 | shareholding | 1985-04-01 | 50 | 50 | 50 | |
1000095.interests.1 | 1000095 | voting-rights | 1985-04-01 | 50 | 50 | 50 | |
1000096.interests.0 | 1000096 | shareholding | 2015-05-01 | 100 | 100 | 100 | 2023-08-30 |
1000096.interests.1 | 1000096 | voting-rights | 2015-05-01 | 100 | 100 | 100 | 2023-08-30 |
1000098.interests.0 | 1000098 | shareholding | 2023-11-25 | 49 | 49 | 49 | |
1000098.interests.1 | 1000098 | voting-rights | 2023-11-25 | 49 | 49 | 49 | |
1000099.interests.0 | 1000099 | shareholding | 2018-04-05 | 21.39 | 21.39 | 21.39 | |
1000099.interests.1 | 1000099 | voting-rights | 2018-04-05 | 21.39 | 21.39 | 21.39 | |
10001.interests.0 | 10001 | shareholding | 2021-12-27 | 29.89 | 29.89 | 29.89 | 2022-12-01 |
10001.interests.1 | 10001 | voting-rights | 2021-12-27 | 39.33 | 39.33 | 39.33 | 2022-12-01 |
1000100.interests.0 | 1000100 | shareholding | 2022-06-13 | 100 | 100 | 100 | |
1000100.interests.1 | 1000100 | voting-rights | 2022-06-13 | 100 | 100 | 100 | |
1000101.interests.0 | 1000101 | shareholding | 2023-11-22 | 100 | 100 | 100 | |
1000101.interests.1 | 1000101 | voting-rights | 2023-11-22 | 100 | 100 | 100 | |
1000103.interests.0 | 1000103 | shareholding | 2021-11-29 | 30 | 30 | 30 | |
1000104.interests.0 | 1000104 | shareholding | 2007-03-13 | 50 | 50 | 50 | |
1000104.interests.1 | 1000104 | voting-rights | 2007-03-13 | 50 | 50 | 50 | |
1000105.interests.0 | 1000105 | shareholding | 2022-02-14 | 100 | 100 | 100 | |
1000105.interests.1 | 1000105 | voting-rights | 2022-02-14 | 100 | 100 | 100 | |
1000107.interests.0 | 1000107 | shareholding | 2020-10-20 | 28.050000000000004 | 28.050000000000004 | 28.050000000000004 | |
1000107.interests.1 | 1000107 | voting-rights | 2020-10-20 | 33.989999999999995 | 33.989999999999995 | 33.989999999999995 | |
1000108.interests.0 | 1000108 | shareholding | 2023-11-24 | 50 | 50 | 50 | |
1000108.interests.1 | 1000108 | voting-rights | 2023-11-24 | 50 | 50 | 50 | |
1000109.interests.0 | 1000109 | shareholding | 2018-12-20 | 16.66 | 16.66 | 16.66 | |
1000109.interests.1 | 1000109 | voting-rights | 2018-12-20 | 16.66 | 16.66 | 16.66 | |
100011.interests.0 | 100011 | shareholding | 2019-04-01 | 51 | 51 | 51 | |
100011.interests.1 | 100011 | voting-rights | 2019-04-01 | 51 | 51 | 51 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [ooc_interests] ( [_link] TEXT , [_link_ooc_statement] TEXT , [type] TEXT , [startdate] TIMESTAMP , [share_exact] TEXT , [share_maximum] TEXT , [share_minimum] TEXT , [enddate] TIMESTAMP , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );