ooc_interests
1,826,491 rows sorted by enddate
This data as json, CSV (advanced)
_link | _link_ooc_statement | type | startdate | share_exact | share_maximum | share_minimum | enddate ▼ |
---|---|---|---|---|---|---|---|
930.interests.0 | 930 | shareholding | 2017-10-16 | 100 | 100 | 100 | |
930.interests.1 | 930 | voting-rights | 2017-10-16 | 100 | 100 | 100 | |
9300.interests.0 | 9300 | shareholding | 2018-08-17 | 100 | 100 | 100 | |
9300.interests.1 | 9300 | voting-rights | 2018-08-17 | 100 | 100 | 100 | |
93000.interests.0 | 93000 | shareholding | 2012-05-01 | 40 | 40 | 40 | |
93000.interests.1 | 93000 | voting-rights | 2012-05-01 | 86.96000000000001 | 86.96000000000001 | 86.96000000000001 | |
930001.interests.0 | 930001 | shareholding | 2015-11-30 | 27.46 | 27.46 | 27.46 | |
930001.interests.1 | 930001 | voting-rights | 2015-11-30 | 27.46 | 27.46 | 27.46 | |
930003.interests.0 | 930003 | shareholding | 1987-01-01 | 50 | 50 | 50 | |
930003.interests.1 | 930003 | voting-rights | 1987-01-01 | 50 | 50 | 50 | |
930005.interests.0 | 930005 | shareholding | 2014-02-06 | 100 | 100 | 100 | |
930005.interests.1 | 930005 | voting-rights | 2014-02-06 | 100 | 100 | 100 | |
930009.interests.0 | 930009 | shareholding | 2016-04-26 | 100 | 100 | 100 | |
930009.interests.1 | 930009 | voting-rights | 2016-04-26 | 100 | 100 | 100 | |
93001.interests.0 | 93001 | shareholding | 2021-07-02 | 100 | 100 | 100 | |
93001.interests.1 | 93001 | voting-rights | 2021-07-02 | 100 | 100 | 100 | |
930010.interests.0 | 930010 | shareholding | 2023-07-01 | 100 | 100 | 100 | |
930010.interests.1 | 930010 | voting-rights | 2023-07-01 | 100 | 100 | 100 | |
930014.interests.0 | 930014 | shareholding | 2015-11-24 | 50 | 50 | 50 | |
930014.interests.1 | 930014 | voting-rights | 2015-11-24 | 50 | 50 | 50 | |
930016.interests.0 | 930016 | shareholding | 2016-01-29 | 100 | 100 | 100 | |
930016.interests.1 | 930016 | voting-rights | 2016-01-29 | 100 | 100 | 100 | |
93002.interests.0 | 93002 | shareholding | 2020-01-03 | 50 | 50 | 50 | |
93002.interests.1 | 93002 | voting-rights | 2020-01-03 | 50 | 50 | 50 | |
930020.interests.0 | 930020 | shareholding | 2021-07-15 | 25.5 | 25.5 | 25.5 | |
930020.interests.1 | 930020 | voting-rights | 2021-07-15 | 76.5 | 76.5 | 76.5 | |
930021.interests.0 | 930021 | shareholding | 2016-07-14 | 100 | 100 | 100 | |
930021.interests.1 | 930021 | voting-rights | 2016-07-14 | 100 | 100 | 100 | |
930022.interests.0 | 930022 | shareholding | 2021-12-19 | 50 | 50 | 50 | |
930022.interests.1 | 930022 | voting-rights | 2021-12-19 | 50 | 50 | 50 | |
930024.interests.0 | 930024 | shareholding | 2023-06-25 | 100 | 100 | 100 | |
930024.interests.1 | 930024 | voting-rights | 2023-06-25 | 100 | 100 | 100 | |
930026.interests.0 | 930026 | shareholding | 2023-06-26 | 100 | 100 | 100 | |
930026.interests.1 | 930026 | voting-rights | 2023-06-26 | 100 | 100 | 100 | |
930027.interests.0 | 930027 | shareholding | 2016-07-01 | 40.129999999999995 | 40.129999999999995 | 40.129999999999995 | |
930027.interests.1 | 930027 | voting-rights | 2016-07-01 | 40.129999999999995 | 40.129999999999995 | 40.129999999999995 | |
93003.interests.0 | 93003 | shareholding | 2012-10-12 | 100 | 100 | 100 | |
93003.interests.1 | 93003 | voting-rights | 2012-10-12 | 100 | 100 | 100 | |
930030.interests.0 | 930030 | shareholding | 2021-02-25 | 100 | 100 | 100 | |
930030.interests.1 | 930030 | voting-rights | 2021-02-25 | 100 | 100 | 100 | |
930031.interests.0 | 930031 | shareholding | 2023-05-31 | 100 | 100 | 100 | |
930031.interests.1 | 930031 | voting-rights | 2023-05-31 | 100 | 100 | 100 | |
930035.interests.0 | 930035 | shareholding | 2016-07-20 | 25 | 25 | 25 | |
930035.interests.1 | 930035 | voting-rights | 2016-07-20 | 75 | 75 | 75 | |
930037.interests.0 | 930037 | shareholding | 2023-07-06 | 100 | 100 | 100 | |
930037.interests.1 | 930037 | voting-rights | 2023-07-06 | 100 | 100 | 100 | |
930041.interests.0 | 930041 | shareholding | 2017-07-01 | 9.58 | 9.58 | 9.58 | |
930041.interests.1 | 930041 | voting-rights | 2017-07-01 | 38.33 | 38.33 | 38.33 | |
930046.interests.0 | 930046 | shareholding | 2022-12-13 | 25 | 25 | 25 | |
930046.interests.1 | 930046 | voting-rights | 2022-12-13 | 25 | 25 | 25 | |
930049.interests.0 | 930049 | shareholding | 2017-12-21 | 90 | 90 | 90 | |
93005.interests.0 | 93005 | shareholding | 2019-02-08 | 33.33 | 33.33 | 33.33 | |
93005.interests.1 | 93005 | voting-rights | 2019-02-08 | 33.33 | 33.33 | 33.33 | |
930057.interests.0 | 930057 | shareholding | 2023-05-30 | 100 | 100 | 100 | |
930057.interests.1 | 930057 | voting-rights | 2023-05-30 | 100 | 100 | 100 | |
930058.interests.0 | 930058 | shareholding | 2018-05-31 | 100 | 100 | 100 | |
930058.interests.1 | 930058 | voting-rights | 2018-05-31 | 100 | 100 | 100 | |
930059.interests.0 | 930059 | shareholding | 2023-07-04 | 50 | 50 | 50 | |
930059.interests.1 | 930059 | voting-rights | 2023-07-04 | 50 | 50 | 50 | |
930061.interests.0 | 930061 | shareholding | 2011-01-05 | 100 | 100 | 100 | |
930061.interests.1 | 930061 | voting-rights | 2011-01-05 | 100 | 100 | 100 | |
930062.interests.0 | 930062 | shareholding | 2023-06-01 | 50 | 50 | 50 | |
930062.interests.1 | 930062 | voting-rights | 2023-06-01 | 50 | 50 | 50 | |
930064.interests.0 | 930064 | shareholding | 2023-06-16 | 100 | 100 | 100 | |
930064.interests.1 | 930064 | voting-rights | 2023-06-16 | 100 | 100 | 100 | |
930068.interests.0 | 930068 | shareholding | 2021-07-01 | 10 | 10 | 10 | |
930068.interests.1 | 930068 | voting-rights | 2021-07-01 | 10 | 10 | 10 | |
930069.interests.0 | 930069 | shareholding | 2016-11-25 | 100 | 100 | 100 | |
930069.interests.1 | 930069 | voting-rights | 2016-11-25 | 100 | 100 | 100 | |
93007.interests.0 | 93007 | shareholding | 2020-10-07 | 100 | 100 | 100 | |
93007.interests.1 | 93007 | voting-rights | 2020-10-07 | 100 | 100 | 100 | |
930072.interests.0 | 930072 | shareholding | 2023-05-15 | 12.5 | 12.5 | 12.5 | |
930074.interests.0 | 930074 | shareholding | 2022-07-01 | 90 | 90 | 90 | |
930074.interests.1 | 930074 | voting-rights | 2022-07-01 | 90 | 90 | 90 | |
930079.interests.0 | 930079 | shareholding | 2021-02-25 | 75 | 75 | 75 | |
930079.interests.1 | 930079 | voting-rights | 2021-02-25 | 75 | 75 | 75 | |
93008.interests.0 | 93008 | shareholding | 1990-10-01 | 100 | 100 | 100 | |
93008.interests.1 | 93008 | voting-rights | 1990-10-01 | 100 | 100 | 100 | |
930082.interests.0 | 930082 | shareholding | 2013-11-19 | 50 | 50 | 50 | |
930082.interests.1 | 930082 | voting-rights | 2013-11-19 | 50 | 50 | 50 | |
930083.interests.0 | 930083 | shareholding | 2022-05-17 | 25 | 25 | 25 | |
930083.interests.1 | 930083 | voting-rights | 2022-05-17 | 27.77 | 27.77 | 27.77 | |
930088.interests.0 | 930088 | shareholding | 2015-10-07 | 100 | 100 | 100 | |
930088.interests.1 | 930088 | voting-rights | 2015-10-07 | 100 | 100 | 100 | |
93009.interests.0 | 93009 | shareholding | 2019-09-03 | 100 | 100 | 100 | |
93009.interests.1 | 93009 | voting-rights | 2019-09-03 | 100 | 100 | 100 | |
930090.interests.0 | 930090 | shareholding | 2023-06-28 | 30 | 30 | 30 | |
930090.interests.1 | 930090 | voting-rights | 2023-06-28 | 30 | 30 | 30 | |
930092.interests.0 | 930092 | shareholding | 2020-08-19 | 22.5 | 22.5 | 22.5 | |
930092.interests.1 | 930092 | voting-rights | 2020-08-19 | 22.5 | 22.5 | 22.5 | |
930093.interests.0 | 930093 | shareholding | 2023-06-07 | 100 | 100 | 100 | |
930093.interests.1 | 930093 | voting-rights | 2023-06-07 | 100 | 100 | 100 | |
930095.interests.0 | 930095 | shareholding | 2008-08-04 | 33.33 | 33.33 | 33.33 | |
930095.interests.1 | 930095 | voting-rights | 2008-08-04 | 33.33 | 33.33 | 33.33 | |
930096.interests.0 | 930096 | shareholding | 2023-07-04 | 50 | 50 | 50 | |
930096.interests.1 | 930096 | voting-rights | 2023-07-04 | 50 | 50 | 50 | |
930097.interests.0 | 930097 | shareholding | 2005-11-15 | 100 | 100 | 100 | |
930097.interests.1 | 930097 | voting-rights | 2005-11-15 | 100 | 100 | 100 | |
93010.interests.0 | 93010 | shareholding | 2021-06-01 | 100 | 100 | 100 | |
93010.interests.1 | 93010 | voting-rights | 2021-06-01 | 100 | 100 | 100 |
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]) );