ooc_interests
1,826,491 rows
This data as json, CSV (advanced)
_link ▼ | _link_ooc_statement | type | startdate | share_exact | share_maximum | share_minimum | enddate |
---|---|---|---|---|---|---|---|
1000157.interests.0 | 1000157 | shareholding | 2019-03-08 | 100 | 100 | 100 | 2019-04-08 |
1000157.interests.1 | 1000157 | voting-rights | 2019-03-08 | 100 | 100 | 100 | 2019-04-08 |
1000158.interests.0 | 1000158 | shareholding | 2021-10-13 | 100 | 100 | 100 | |
1000158.interests.1 | 1000158 | voting-rights | 2021-10-13 | 100 | 100 | 100 | |
1000159.interests.0 | 1000159 | shareholding | 2023-07-10 | 25 | 25 | 25 | |
1000159.interests.1 | 1000159 | voting-rights | 2023-07-10 | 25 | 25 | 25 | |
1000160.interests.0 | 1000160 | shareholding | 2023-11-24 | 50 | 50 | 50 | |
1000160.interests.1 | 1000160 | voting-rights | 2023-11-24 | 50 | 50 | 50 | |
1000161.interests.0 | 1000161 | shareholding | 2022-02-02 | 50 | 50 | 50 | |
1000161.interests.1 | 1000161 | voting-rights | 2022-02-02 | 50 | 50 | 50 | |
1000162.interests.0 | 1000162 | shareholding | 2018-03-09 | 100 | 100 | 100 | |
1000162.interests.1 | 1000162 | voting-rights | 2018-03-09 | 100 | 100 | 100 | |
1000163.interests.0 | 1000163 | shareholding | 2017-04-30 | 90 | 90 | 90 | |
1000163.interests.1 | 1000163 | voting-rights | 2017-04-30 | 90 | 90 | 90 | |
1000165.interests.0 | 1000165 | shareholding | 2023-11-28 | 100 | 100 | 100 | |
1000165.interests.1 | 1000165 | voting-rights | 2023-11-28 | 100 | 100 | 100 | |
1000166.interests.0 | 1000166 | shareholding | 2020-12-01 | 50 | 50 | 50 | 2021-01-01 |
1000166.interests.1 | 1000166 | voting-rights | 2020-12-01 | 50 | 50 | 50 | 2021-01-01 |
1000167.interests.0 | 1000167 | shareholding | 2023-11-27 | 20 | 20 | 20 | |
1000167.interests.1 | 1000167 | voting-rights | 2023-11-27 | 20 | 20 | 20 | |
1000168.interests.0 | 1000168 | shareholding | 2005-10-05 | 100 | 100 | 100 | |
1000168.interests.1 | 1000168 | voting-rights | 2005-10-05 | 100 | 100 | 100 | |
1000169.interests.0 | 1000169 | shareholding | 2017-09-12 | 100 | 100 | 100 | |
1000169.interests.1 | 1000169 | voting-rights | 2017-09-12 | 100 | 100 | 100 | |
100017.interests.0 | 100017 | shareholding | 2022-06-27 | 100 | 100 | 100 | |
100017.interests.1 | 100017 | voting-rights | 2022-06-27 | 100 | 100 | 100 | |
1000171.interests.0 | 1000171 | shareholding | 2016-01-24 | 50 | 50 | 50 | |
1000171.interests.1 | 1000171 | voting-rights | 2016-01-24 | 50 | 50 | 50 | |
1000172.interests.0 | 1000172 | shareholding | 2013-08-08 | 100 | 100 | 100 | |
1000172.interests.1 | 1000172 | voting-rights | 2013-08-08 | 100 | 100 | 100 | |
1000173.interests.0 | 1000173 | shareholding | 2017-04-30 | 100 | 100 | 100 | |
1000173.interests.1 | 1000173 | voting-rights | 2017-04-30 | 100 | 100 | 100 | |
1000174.interests.0 | 1000174 | shareholding | 2021-08-23 | 80 | 80 | 80 | |
1000174.interests.1 | 1000174 | voting-rights | 2021-08-23 | 80 | 80 | 80 | |
1000175.interests.0 | 1000175 | shareholding | 2016-10-01 | 39 | 39 | 39 | |
1000175.interests.1 | 1000175 | voting-rights | 2016-10-01 | 39 | 39 | 39 | |
1000176.interests.0 | 1000176 | shareholding | 2004-06-17 | 100 | 100 | 100 | |
1000176.interests.1 | 1000176 | voting-rights | 2004-06-17 | 100 | 100 | 100 | |
1000177.interests.0 | 1000177 | shareholding | 2011-07-04 | 100 | 100 | 100 | |
1000177.interests.1 | 1000177 | voting-rights | 2011-07-04 | 100 | 100 | 100 | |
1000178.interests.0 | 1000178 | shareholding | 2018-07-01 | 100 | 100 | 100 | |
1000178.interests.1 | 1000178 | voting-rights | 2018-07-01 | 100 | 100 | 100 | |
1000179.interests.0 | 1000179 | shareholding | 2020-11-17 | 50 | 50 | 50 | 2022-01-22 |
1000179.interests.1 | 1000179 | voting-rights | 2020-11-17 | 50 | 50 | 50 | 2022-01-22 |
100018.interests.0 | 100018 | shareholding | 2019-10-16 | 8.73 | 8.73 | 8.73 | |
100018.interests.1 | 100018 | voting-rights | 2019-10-16 | 4.390000000000001 | 4.390000000000001 | 4.390000000000001 | |
1000180.interests.0 | 1000180 | shareholding | 2018-01-26 | 50 | 50 | 50 | 2023-03-31 |
1000180.interests.1 | 1000180 | voting-rights | 2018-01-26 | 50 | 50 | 50 | 2023-03-31 |
1000181.interests.0 | 1000181 | shareholding | 2015-12-21 | 100 | 100 | 100 | 2023-09-28 |
1000181.interests.1 | 1000181 | voting-rights | 2015-12-21 | 100 | 100 | 100 | 2023-09-28 |
1000182.interests.0 | 1000182 | shareholding | 2019-06-26 | 75.05 | 75.05 | 75.05 | |
1000182.interests.1 | 1000182 | voting-rights | 2019-06-26 | 75.05 | 75.05 | 75.05 | |
1000183.interests.0 | 1000183 | shareholding | 2021-06-01 | 100 | 100 | 100 | |
1000183.interests.1 | 1000183 | voting-rights | 2021-06-01 | 100 | 100 | 100 | |
1000184.interests.0 | 1000184 | shareholding | 2021-10-13 | 100 | 100 | 100 | |
1000184.interests.1 | 1000184 | voting-rights | 2021-10-13 | 100 | 100 | 100 | |
1000185.interests.0 | 1000185 | shareholding | 2000-03-20 | 50 | 50 | 50 | 2023-05-02 |
1000186.interests.0 | 1000186 | shareholding | 2015-11-25 | 100 | 100 | 100 | |
1000186.interests.1 | 1000186 | voting-rights | 2015-11-25 | 100 | 100 | 100 | |
1000187.interests.0 | 1000187 | shareholding | 2021-02-11 | 100 | 100 | 100 | |
1000187.interests.1 | 1000187 | voting-rights | 2021-02-11 | 100 | 100 | 100 | |
1000188.interests.0 | 1000188 | shareholding | 2016-05-30 | 50 | 50 | 50 | 2023-11-14 |
1000188.interests.1 | 1000188 | voting-rights | 2016-05-30 | 50 | 50 | 50 | 2023-11-14 |
1000189.interests.0 | 1000189 | shareholding | 2018-01-08 | 100 | 100 | 100 | |
1000189.interests.1 | 1000189 | voting-rights | 2018-01-08 | 100 | 100 | 100 | |
100019.interests.0 | 100019 | shareholding | 2014-07-23 | 57.78 | 57.78 | 57.78 | |
100019.interests.1 | 100019 | voting-rights | 2014-07-23 | 57.78 | 57.78 | 57.78 | |
1000190.interests.0 | 1000190 | shareholding | 2023-11-16 | 50 | 50 | 50 | |
1000190.interests.1 | 1000190 | voting-rights | 2023-11-16 | 50 | 50 | 50 | |
1000191.interests.0 | 1000191 | shareholding | 2000-02-09 | 50 | 50 | 50 | |
1000191.interests.1 | 1000191 | voting-rights | 2000-02-09 | 50 | 50 | 50 | |
1000192.interests.0 | 1000192 | shareholding | 2020-04-13 | 30 | 30 | 30 | 2023-04-17 |
1000192.interests.1 | 1000192 | voting-rights | 2020-04-13 | 30 | 30 | 30 | 2023-04-17 |
1000194.interests.0 | 1000194 | shareholding | 2020-01-01 | 100 | 100 | 100 | 2020-03-20 |
1000194.interests.1 | 1000194 | voting-rights | 2020-01-01 | 100 | 100 | 100 | 2020-03-20 |
1000195.interests.0 | 1000195 | shareholding | 2000-07-07 | 16.669999999999998 | 16.669999999999998 | 16.669999999999998 | 2018-12-31 |
1000195.interests.1 | 1000195 | voting-rights | 2000-07-07 | 16.669999999999998 | 16.669999999999998 | 16.669999999999998 | 2018-12-31 |
1000196.interests.0 | 1000196 | shareholding | 2022-03-24 | 100 | 100 | 100 | |
1000196.interests.1 | 1000196 | voting-rights | 2022-03-24 | 100 | 100 | 100 | |
1000197.interests.0 | 1000197 | shareholding | 2023-02-06 | 75 | 75 | 75 | |
1000197.interests.1 | 1000197 | voting-rights | 2023-02-06 | 75 | 75 | 75 | |
1000198.interests.0 | 1000198 | shareholding | 2020-04-30 | 100 | 100 | 100 | 2021-07-21 |
1000198.interests.1 | 1000198 | voting-rights | 2020-04-30 | 100 | 100 | 100 | 2021-07-21 |
1000199.interests.0 | 1000199 | shareholding | 2018-09-20 | 100 | 100 | 100 | 2019-12-11 |
1000199.interests.1 | 1000199 | voting-rights | 2018-09-20 | 100 | 100 | 100 | 2019-12-11 |
10002.interests.0 | 10002 | shareholding | 1998-02-15 | 33.33 | 33.33 | 33.33 | |
10002.interests.1 | 10002 | voting-rights | 1998-02-15 | 33.33 | 33.33 | 33.33 | |
100020.interests.0 | 100020 | shareholding | 2020-01-08 | 50 | 50 | 50 | |
100020.interests.1 | 100020 | voting-rights | 2020-01-08 | 50 | 50 | 50 | |
1000200.interests.0 | 1000200 | shareholding | 2018-08-16 | 100 | 100 | 100 | |
1000200.interests.1 | 1000200 | voting-rights | 2018-08-16 | 100 | 100 | 100 | |
1000203.interests.0 | 1000203 | shareholding | 2021-10-01 | 33.33 | 33.33 | 33.33 | |
1000203.interests.1 | 1000203 | voting-rights | 2021-10-01 | 33.33 | 33.33 | 33.33 | |
1000205.interests.0 | 1000205 | shareholding | 2023-01-10 | 25 | 25 | 25 | |
1000205.interests.1 | 1000205 | voting-rights | 2023-01-10 | 25 | 25 | 25 | |
1000206.interests.0 | 1000206 | shareholding | 2022-02-24 | 50 | 50 | 50 | |
1000206.interests.1 | 1000206 | voting-rights | 2022-02-24 | 50 | 50 | 50 | |
1000207.interests.0 | 1000207 | shareholding | 2011-08-17 | 100 | 100 | 100 | |
1000207.interests.1 | 1000207 | voting-rights | 2011-08-17 | 100 | 100 | 100 | |
1000208.interests.0 | 1000208 | shareholding | 2022-02-07 | 33.33 | 33.33 | 33.33 | 2022-10-01 |
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]) );