ooc_interests
1,324,489 rows
This data as json, CSV (advanced)
Suggested facets: enddate (date), startdate (date)
_link ▼ | _link_ooc_statement | type | enddate | startdate | share_exact | share_maximum | share_minimum | details | share_exclusiveminimum | share_exclusivemaximum |
---|---|---|---|---|---|---|---|---|---|---|
0.interests.0 | 0 | shareholding | 2017-12-31 | 2010-04-21 | 50 | 50 | 50 | |||
0.interests.1 | 0 | voting-rights | 2017-12-31 | 2010-04-21 | 50 | 50 | 50 | |||
1.interests.0 | 1 | shareholding | 2019-01-01 | 2018-10-01 | 25 | 25 | 25 | |||
1.interests.1 | 1 | voting-rights | 2019-01-01 | 2018-10-01 | 25 | 25 | 25 | |||
10.interests.0 | 10 | shareholding | 1993-01-14 | 80 | 80 | 80 | ||||
10.interests.1 | 10 | voting-rights | 1993-01-14 | 80 | 80 | 80 | ||||
100.interests.0 | 100 | shareholding | 2004-02-18 | 100 | 100 | 100 | ||||
100.interests.1 | 100 | voting-rights | 2004-02-18 | 100 | 100 | 100 | ||||
1000.interests.0 | 1000 | shareholding | 2020-11-06 | 2017-12-07 | 100 | 100 | 100 | |||
1000.interests.1 | 1000 | voting-rights | 2020-11-06 | 2017-12-07 | 100 | 100 | 100 | |||
10000.interests.0 | 10000 | shareholding | 2019-07-01 | 2016-01-08 | 10 | 10 | 10 | |||
10000.interests.1 | 10000 | voting-rights | 2019-07-01 | 2016-01-08 | 50 | 50 | 50 | |||
100000.interests.0 | 100000 | shareholding | 2022-04-26 | 50 | 50 | 50 | ||||
100000.interests.1 | 100000 | voting-rights | 2022-04-26 | 50 | 50 | 50 | ||||
100001.interests.0 | 100001 | shareholding | 2022-03-10 | 100 | 100 | 100 | ||||
100001.interests.1 | 100001 | voting-rights | 2022-03-10 | 100 | 100 | 100 | ||||
100002.interests.0 | 100002 | shareholding | 2020-10-22 | 2017-06-12 | 100 | 100 | 100 | |||
100002.interests.1 | 100002 | voting-rights | 2020-10-22 | 2017-06-12 | 100 | 100 | 100 | |||
100003.interests.0 | 100003 | shareholding | 2017-06-09 | 100 | 100 | 100 | ||||
100003.interests.1 | 100003 | voting-rights | 2017-06-09 | 100 | 100 | 100 | ||||
100004.interests.0 | 100004 | shareholding | 2022-04-26 | 25 | 25 | 25 | ||||
100004.interests.1 | 100004 | voting-rights | 2022-04-26 | 25 | 25 | 25 | ||||
100005.interests.0 | 100005 | shareholding | 2020-01-08 | 50 | 50 | 50 | ||||
100005.interests.1 | 100005 | voting-rights | 2020-01-08 | 50 | 50 | 50 | ||||
100006.interests.0 | 100006 | shareholding | 2017-06-13 | 28.000000000000004 | 28.000000000000004 | 28.000000000000004 | ||||
100006.interests.1 | 100006 | voting-rights | 2017-06-13 | 28.000000000000004 | 28.000000000000004 | 28.000000000000004 | ||||
100007.interests.0 | 100007 | shareholding | 2017-06-13 | 100 | 100 | 100 | ||||
100007.interests.1 | 100007 | voting-rights | 2017-06-13 | 100 | 100 | 100 | ||||
100008.interests.0 | 100008 | shareholding | 2017-01-01 | 25 | 25 | 25 | ||||
100008.interests.1 | 100008 | voting-rights | 2017-01-01 | 25 | 25 | 25 | ||||
100009.interests.0 | 100009 | shareholding | 2021-11-25 | 100 | 100 | 100 | ||||
100009.interests.1 | 100009 | voting-rights | 2021-11-25 | 100 | 100 | 100 | ||||
10001.interests.0 | 10001 | shareholding | 2013-07-01 | 10 | 10 | 10 | ||||
10001.interests.1 | 10001 | voting-rights | 2013-07-01 | 50 | 50 | 50 | ||||
100010.interests.0 | 100010 | shareholding | 2018-04-01 | 100 | 100 | 100 | ||||
100010.interests.1 | 100010 | voting-rights | 2018-04-01 | 100 | 100 | 100 | ||||
100011.interests.0 | 100011 | shareholding | 2018-11-20 | 50 | 50 | 50 | ||||
100011.interests.1 | 100011 | voting-rights | 2018-11-20 | 50 | 50 | 50 | ||||
100012.interests.0 | 100012 | shareholding | 2021-08-16 | 33.4 | 33.4 | 33.4 | ||||
100012.interests.1 | 100012 | voting-rights | 2021-08-16 | 33.4 | 33.4 | 33.4 | ||||
100013.interests.0 | 100013 | shareholding | 2022-01-05 | 2017-06-26 | 50 | 50 | 50 | |||
100013.interests.1 | 100013 | voting-rights | 2022-01-05 | 2017-06-26 | 50 | 50 | 50 | |||
100014.interests.0 | 100014 | shareholding | 2014-09-29 | 33.339999999999996 | 33.339999999999996 | 33.339999999999996 | ||||
100014.interests.1 | 100014 | voting-rights | 2014-09-29 | 33.339999999999996 | 33.339999999999996 | 33.339999999999996 | ||||
100015.interests.0 | 100015 | shareholding | 2012-08-01 | 33.4 | 33.4 | 33.4 | ||||
100015.interests.1 | 100015 | voting-rights | 2012-08-01 | 33.4 | 33.4 | 33.4 | ||||
100016.interests.0 | 100016 | shareholding | 2014-09-23 | 100 | 100 | 100 | ||||
100016.interests.1 | 100016 | voting-rights | 2014-09-23 | 100 | 100 | 100 | ||||
100017.interests.0 | 100017 | shareholding | 2022-05-30 | 100 | 100 | 100 | ||||
100017.interests.1 | 100017 | voting-rights | 2022-05-30 | 100 | 100 | 100 | ||||
100019.interests.0 | 100019 | shareholding | 2017-05-29 | 50 | 50 | 50 | ||||
100019.interests.1 | 100019 | voting-rights | 2017-05-29 | 50 | 50 | 50 | ||||
10002.interests.0 | 10002 | shareholding | 2016-01-08 | 100 | 100 | 100 | ||||
10002.interests.1 | 10002 | voting-rights | 2016-01-08 | 100 | 100 | 100 | ||||
100021.interests.0 | 100021 | shareholding | 2022-04-16 | 33.33 | 33.33 | 33.33 | ||||
100021.interests.1 | 100021 | voting-rights | 2022-04-16 | 33.33 | 33.33 | 33.33 | ||||
100022.interests.0 | 100022 | shareholding | 2021-04-01 | 2020-06-08 | 50 | 50 | 50 | |||
100022.interests.1 | 100022 | voting-rights | 2021-04-01 | 2020-06-08 | 50 | 50 | 50 | |||
100023.interests.0 | 100023 | shareholding | 2019-07-31 | 2017-05-09 | 100 | 100 | 100 | |||
100023.interests.1 | 100023 | voting-rights | 2019-07-31 | 2017-05-09 | 100 | 100 | 100 | |||
100024.interests.0 | 100024 | shareholding | 2021-03-11 | 50 | 50 | 50 | ||||
100024.interests.1 | 100024 | voting-rights | 2021-03-11 | 50 | 50 | 50 | ||||
100025.interests.0 | 100025 | shareholding | 2017-05-11 | 100 | 100 | 100 | ||||
100025.interests.1 | 100025 | voting-rights | 2017-05-11 | 100 | 100 | 100 | ||||
100026.interests.0 | 100026 | shareholding | 2019-03-08 | 50 | 50 | 50 | ||||
100026.interests.1 | 100026 | voting-rights | 2019-03-08 | 50 | 50 | 50 | ||||
100028.interests.0 | 100028 | shareholding | 2017-05-31 | 100 | 100 | 100 | ||||
100028.interests.1 | 100028 | voting-rights | 2017-05-31 | 100 | 100 | 100 | ||||
100029.interests.0 | 100029 | shareholding | 2021-01-01 | 100 | 100 | 100 | ||||
100029.interests.1 | 100029 | voting-rights | 2021-01-01 | 100 | 100 | 100 | ||||
10003.interests.0 | 10003 | shareholding | 2016-12-08 | 50 | 50 | 50 | ||||
10003.interests.1 | 10003 | voting-rights | 2016-12-08 | 50 | 50 | 50 | ||||
100030.interests.0 | 100030 | shareholding | 2017-05-17 | 100 | 100 | 100 | ||||
100030.interests.1 | 100030 | voting-rights | 2017-05-17 | 100 | 100 | 100 | ||||
100031.interests.0 | 100031 | shareholding | 2016-01-14 | 33.33 | 33.33 | 33.33 | ||||
100031.interests.1 | 100031 | voting-rights | 2016-01-14 | 33.33 | 33.33 | 33.33 | ||||
100032.interests.0 | 100032 | shareholding | 2017-05-08 | 100 | 100 | 100 | ||||
100032.interests.1 | 100032 | voting-rights | 2017-05-08 | 100 | 100 | 100 | ||||
100034.interests.0 | 100034 | shareholding | 2019-08-06 | 2017-12-15 | 100 | 100 | 100 | |||
100034.interests.1 | 100034 | voting-rights | 2019-08-06 | 2017-12-15 | 100 | 100 | 100 | |||
100035.interests.0 | 100035 | shareholding | 2020-11-09 | 2017-05-29 | 49 | 49 | 49 | |||
100035.interests.1 | 100035 | voting-rights | 2020-11-09 | 2017-05-29 | 49 | 49 | 49 | |||
100036.interests.0 | 100036 | shareholding | 2021-01-06 | 50 | 50 | 50 | ||||
100036.interests.1 | 100036 | voting-rights | 2021-01-06 | 50 | 50 | 50 | ||||
100037.interests.0 | 100037 | shareholding | 2021-06-08 | 2021-06-08 | 25 | 25 | 25 | |||
100038.interests.0 | 100038 | shareholding | 2021-06-09 | 25 | 25 | 25 | ||||
100039.interests.0 | 100039 | shareholding | 2021-01-06 | 100 | 100 | 100 | ||||
100039.interests.1 | 100039 | voting-rights | 2021-01-06 | 100 | 100 | 100 | ||||
10004.interests.0 | 10004 | shareholding | 2017-07-04 | 40 | 40 | 40 | ||||
10004.interests.1 | 10004 | voting-rights | 2017-07-04 | 40 | 40 | 40 | ||||
100040.interests.0 | 100040 | shareholding | 2021-01-25 | 55.00000000000001 | 55.00000000000001 | 55.00000000000001 | ||||
100040.interests.1 | 100040 | voting-rights | 2021-01-25 | 75 | 75 | 75 | ||||
100041.interests.0 | 100041 | shareholding | 2019-08-06 | 2016-09-25 | 100 | 100 | 100 | |||
100041.interests.1 | 100041 | voting-rights | 2019-08-06 | 2016-09-25 | 100 | 100 | 100 | |||
100042.interests.0 | 100042 | shareholding | 2017-05-01 | 100 | 100 | 100 | ||||
100042.interests.1 | 100042 | voting-rights | 2017-05-01 | 100 | 100 | 100 | ||||
100043.interests.0 | 100043 | shareholding | 2016-11-29 | 100 | 100 | 100 | ||||
100043.interests.1 | 100043 | voting-rights | 2016-11-29 | 100 | 100 | 100 | ||||
100044.interests.0 | 100044 | shareholding | 2019-08-06 | 2015-03-02 | 50 | 50 | 50 | |||
100044.interests.1 | 100044 | voting-rights | 2019-08-06 | 2015-03-02 | 50 | 50 | 50 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [ooc_interests] ( [_link] TEXT , [_link_ooc_statement] TEXT , [type] TEXT , [enddate] TEXT , [startdate] TEXT , [share_exact] NUMERIC , [share_maximum] NUMERIC , [share_minimum] NUMERIC , [details] TEXT , [share_exclusiveminimum] BOOL , [share_exclusivemaximum] BOOL , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );