ooc_interests
1,826,491 rows sorted by type descending
This data as json, CSV (advanced)
_link | _link_ooc_statement | type ▲ | startdate | share_exact | share_maximum | share_minimum | enddate |
---|---|---|---|---|---|---|---|
1210.interests.1 | 1210 | voting-rights | 2008-06-27 | 100 | 100 | 100 | |
12100.interests.1 | 12100 | voting-rights | 2021-06-04 | 100 | 100 | 100 | |
121000.interests.1 | 121000 | voting-rights | 2022-05-10 | 100 | 100 | 100 | |
121001.interests.1 | 121001 | voting-rights | 2020-01-10 | 100 | 100 | 100 | |
121002.interests.1 | 121002 | voting-rights | 2011-02-17 | 100 | 100 | 100 | |
121003.interests.1 | 121003 | voting-rights | 2002-08-03 | 26.33 | 26.33 | 26.33 | |
121005.interests.1 | 121005 | voting-rights | 2018-08-20 | 100 | 100 | 100 | |
121007.interests.1 | 121007 | voting-rights | 2022-10-14 | 100 | 100 | 100 | |
121008.interests.1 | 121008 | voting-rights | 2018-05-29 | 50 | 50 | 50 | 2019-02-25 |
121009.interests.1 | 121009 | voting-rights | 2017-08-28 | 100 | 100 | 100 | 2022-05-09 |
12101.interests.1 | 12101 | voting-rights | 2003-03-19 | 100 | 100 | 100 | |
121010.interests.1 | 121010 | voting-rights | 2018-03-02 | 100 | 100 | 100 | 2022-09-27 |
121012.interests.1 | 121012 | voting-rights | 2022-12-16 | 100 | 100 | 100 | |
121013.interests.1 | 121013 | voting-rights | 2004-11-01 | 30 | 30 | 30 | 2019-05-31 |
121014.interests.1 | 121014 | voting-rights | 2016-08-15 | 51 | 51 | 51 | |
121015.interests.1 | 121015 | voting-rights | 2011-09-30 | 100 | 100 | 100 | |
121016.interests.1 | 121016 | voting-rights | 2018-12-18 | 100 | 100 | 100 | 2019-11-18 |
121017.interests.1 | 121017 | voting-rights | 2022-02-23 | 42.73 | 42.73 | 42.73 | |
121018.interests.1 | 121018 | voting-rights | 2012-12-01 | 50 | 50 | 50 | |
121019.interests.1 | 121019 | voting-rights | 2016-05-01 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | |
12102.interests.1 | 12102 | voting-rights | 2008-09-03 | 50 | 50 | 50 | |
121020.interests.1 | 121020 | voting-rights | 2018-10-11 | 30 | 30 | 30 | 2020-01-31 |
121021.interests.1 | 121021 | voting-rights | 2019-02-04 | 33.33 | 33.33 | 33.33 | |
121022.interests.1 | 121022 | voting-rights | 2006-05-08 | 100 | 100 | 100 | |
121023.interests.1 | 121023 | voting-rights | 2014-04-28 | 100 | 100 | 100 | |
121024.interests.1 | 121024 | voting-rights | 2014-07-18 | 51 | 51 | 51 | 2022-06-16 |
121025.interests.1 | 121025 | voting-rights | 2018-10-01 | 45 | 45 | 45 | |
121026.interests.1 | 121026 | voting-rights | 2020-09-03 | 50 | 50 | 50 | |
121027.interests.1 | 121027 | voting-rights | 2017-12-27 | 100 | 100 | 100 | |
121028.interests.1 | 121028 | voting-rights | 2018-06-27 | 100 | 100 | 100 | |
12103.interests.1 | 12103 | voting-rights | 2019-11-25 | 10 | 10 | 10 | 2019-11-25 |
121030.interests.1 | 121030 | voting-rights | 2017-02-01 | 50 | 50 | 50 | |
121032.interests.1 | 121032 | voting-rights | 2020-03-02 | 33.33 | 33.33 | 33.33 | 2021-10-22 |
121033.interests.1 | 121033 | voting-rights | 2017-02-12 | 29.69 | 29.69 | 29.69 | |
121034.interests.1 | 121034 | voting-rights | 2015-09-30 | 100 | 100 | 100 | |
121035.interests.1 | 121035 | voting-rights | 2014-09-16 | 100 | 100 | 100 | 2018-02-06 |
121036.interests.1 | 121036 | voting-rights | 2021-11-27 | 25 | 25 | 25 | |
121037.interests.1 | 121037 | voting-rights | 1997-12-16 | 100 | 100 | 100 | |
121038.interests.1 | 121038 | voting-rights | 2011-02-03 | 50 | 50 | 50 | 2018-06-04 |
121039.interests.1 | 121039 | voting-rights | 2020-12-15 | 100 | 100 | 100 | 2021-03-09 |
121040.interests.1 | 121040 | voting-rights | 2021-09-01 | 100 | 100 | 100 | |
121041.interests.1 | 121041 | voting-rights | 2008-12-01 | 50 | 50 | 50 | |
121043.interests.1 | 121043 | voting-rights | 2015-07-16 | 33.33 | 33.33 | 33.33 | 2019-12-02 |
121044.interests.1 | 121044 | voting-rights | 2015-06-30 | 50 | 50 | 50 | |
121045.interests.1 | 121045 | voting-rights | 2003-10-06 | 100 | 100 | 100 | |
121046.interests.1 | 121046 | voting-rights | 2010-03-30 | 100 | 100 | 100 | |
121047.interests.1 | 121047 | voting-rights | 2020-08-10 | 100 | 100 | 100 | |
121048.interests.1 | 121048 | voting-rights | 2012-01-02 | 100 | 100 | 100 | |
121049.interests.1 | 121049 | voting-rights | 2007-10-30 | 100 | 100 | 100 | |
12105.interests.1 | 12105 | voting-rights | 2015-11-18 | 100 | 100 | 100 | |
121050.interests.1 | 121050 | voting-rights | 2017-08-30 | 100 | 100 | 100 | |
121051.interests.1 | 121051 | voting-rights | 2020-07-01 | 100 | 100 | 100 | 2022-09-15 |
121052.interests.1 | 121052 | voting-rights | 2010-12-17 | 100 | 100 | 100 | 2021-08-09 |
121053.interests.1 | 121053 | voting-rights | 2017-10-20 | 30 | 30 | 30 | 2020-12-01 |
121054.interests.1 | 121054 | voting-rights | 2015-07-01 | 100 | 100 | 100 | |
121056.interests.1 | 121056 | voting-rights | 2006-12-20 | 60 | 60 | 60 | |
121058.interests.1 | 121058 | voting-rights | 2005-11-04 | 100 | 100 | 100 | 2018-03-02 |
121059.interests.1 | 121059 | voting-rights | 1978-08-10 | 100 | 100 | 100 | 2018-03-07 |
12106.interests.1 | 12106 | voting-rights | 2017-05-08 | 50 | 50 | 50 | 2019-01-08 |
121060.interests.1 | 121060 | voting-rights | 2001-11-28 | 100 | 100 | 100 | |
121064.interests.1 | 121064 | voting-rights | 2005-01-06 | 100 | 100 | 100 | |
121065.interests.1 | 121065 | voting-rights | 2022-09-22 | 100 | 100 | 100 | |
121066.interests.1 | 121066 | voting-rights | 2020-05-18 | 50 | 50 | 50 | |
121067.interests.1 | 121067 | voting-rights | 2022-06-28 | 1 | 1 | 1 | |
121068.interests.1 | 121068 | voting-rights | 2017-01-02 | 50 | 50 | 50 | 2019-05-29 |
121069.interests.1 | 121069 | voting-rights | 2018-01-04 | 100 | 100 | 100 | |
12107.interests.1 | 12107 | voting-rights | 2018-10-01 | 100 | 100 | 100 | |
121070.interests.1 | 121070 | voting-rights | 2006-12-15 | 50 | 50 | 50 | |
121071.interests.1 | 121071 | voting-rights | 2020-03-31 | 55.00000000000001 | 55.00000000000001 | 55.00000000000001 | |
121072.interests.1 | 121072 | voting-rights | 2008-07-31 | 100 | 100 | 100 | |
121073.interests.1 | 121073 | voting-rights | 1995-12-18 | 100 | 100 | 100 | |
121074.interests.1 | 121074 | voting-rights | 2015-07-01 | 50 | 50 | 50 | |
121075.interests.1 | 121075 | voting-rights | 2017-08-21 | 50 | 50 | 50 | 2021-04-20 |
121076.interests.1 | 121076 | voting-rights | 2016-03-11 | 100 | 100 | 100 | |
121077.interests.1 | 121077 | voting-rights | 2020-05-01 | 50 | 50 | 50 | 2021-10-28 |
121078.interests.1 | 121078 | voting-rights | 2020-12-14 | 100 | 100 | 100 | |
121079.interests.1 | 121079 | voting-rights | 2021-11-01 | 28.6 | 28.6 | 28.6 | |
12108.interests.1 | 12108 | voting-rights | 2016-11-30 | 100 | 100 | 100 | |
121080.interests.1 | 121080 | voting-rights | 2014-06-19 | 35 | 35 | 35 | |
121081.interests.1 | 121081 | voting-rights | 2012-12-19 | 100 | 100 | 100 | |
121082.interests.1 | 121082 | voting-rights | 2020-10-14 | 100 | 100 | 100 | |
121083.interests.1 | 121083 | voting-rights | 2021-02-16 | 100 | 100 | 100 | |
121084.interests.1 | 121084 | voting-rights | 2017-10-23 | 5 | 5 | 5 | |
121086.interests.1 | 121086 | voting-rights | 2009-04-23 | 100 | 100 | 100 | 2022-04-26 |
121087.interests.1 | 121087 | voting-rights | 2019-03-08 | 33.33 | 33.33 | 33.33 | |
121088.interests.1 | 121088 | voting-rights | 2015-08-24 | 50 | 50 | 50 | 2019-02-11 |
121089.interests.1 | 121089 | voting-rights | 2018-11-18 | 33.33 | 33.33 | 33.33 | |
12109.interests.1 | 12109 | voting-rights | 2021-10-29 | 100 | 100 | 100 | |
121090.interests.1 | 121090 | voting-rights | 2020-09-11 | 15.83 | 15.83 | 15.83 | |
121091.interests.1 | 121091 | voting-rights | 2021-07-30 | 50 | 50 | 50 | |
121093.interests.1 | 121093 | voting-rights | 2016-05-17 | 50 | 50 | 50 | |
121094.interests.1 | 121094 | voting-rights | 2008-06-12 | 100 | 100 | 100 | |
121095.interests.1 | 121095 | voting-rights | 2015-11-30 | 100 | 100 | 100 | 2019-05-21 |
121096.interests.1 | 121096 | voting-rights | 2010-05-17 | 50 | 50 | 50 | |
121097.interests.1 | 121097 | voting-rights | 2019-06-02 | 5.53 | 5.53 | 5.53 | |
121098.interests.1 | 121098 | voting-rights | 2017-11-29 | 50 | 50 | 50 | 2019-01-14 |
121099.interests.1 | 121099 | voting-rights | 2017-08-07 | 100 | 100 | 100 | |
12110.interests.1 | 12110 | voting-rights | 2015-10-01 | 28.000000000000004 | 28.000000000000004 | 28.000000000000004 | |
121100.interests.1 | 121100 | voting-rights | 2017-09-26 | 29.57 | 29.57 | 29.57 | 2020-08-14 |
121101.interests.1 | 121101 | voting-rights | 2016-07-16 | 100 | 100 | 100 | 2017-12-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]) );