ooc_interests
1,324,489 rows
This data as json, CSV (advanced)
_link ▼ | _link_ooc_statement | type | enddate | startdate | share_exact | share_maximum | share_minimum | details | share_exclusiveminimum | share_exclusivemaximum |
---|---|---|---|---|---|---|---|---|---|---|
100093.interests.1 | 100093 | voting-rights | 2020-12-22 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | ||||
100094.interests.0 | 100094 | shareholding | 2020-12-17 | 33.33 | 33.33 | 33.33 | ||||
100094.interests.1 | 100094 | voting-rights | 2020-12-17 | 33.33 | 33.33 | 33.33 | ||||
100095.interests.0 | 100095 | shareholding | 2017-12-21 | 2017-05-30 | 50 | 50 | 50 | |||
100095.interests.1 | 100095 | voting-rights | 2017-12-21 | 2017-05-30 | 50 | 50 | 50 | |||
100096.interests.0 | 100096 | shareholding | 2018-11-22 | 50 | 50 | 50 | ||||
100096.interests.1 | 100096 | voting-rights | 2018-11-22 | 50 | 50 | 50 | ||||
100098.interests.0 | 100098 | shareholding | 2017-11-07 | 70 | 70 | 70 | ||||
100098.interests.1 | 100098 | voting-rights | 2017-11-07 | 70 | 70 | 70 | ||||
100099.interests.0 | 100099 | shareholding | 1998-04-23 | 100 | 100 | 100 | ||||
100099.interests.1 | 100099 | voting-rights | 1998-04-23 | 100 | 100 | 100 | ||||
1001.interests.0 | 1001 | shareholding | 2017-12-07 | 100 | 100 | 100 | ||||
1001.interests.1 | 1001 | voting-rights | 2017-12-07 | 100 | 100 | 100 | ||||
10010.interests.0 | 10010 | shareholding | 2006-07-05 | 50 | 50 | 50 | ||||
10010.interests.1 | 10010 | voting-rights | 2006-07-05 | 50 | 50 | 50 | ||||
100100.interests.0 | 100100 | shareholding | 2017-11-07 | 100 | 100 | 100 | ||||
100100.interests.1 | 100100 | voting-rights | 2017-11-07 | 100 | 100 | 100 | ||||
100101.interests.0 | 100101 | shareholding | 2022-08-29 | 50 | 50 | 50 | ||||
100101.interests.1 | 100101 | voting-rights | 2022-08-29 | 50 | 50 | 50 | ||||
100102.interests.0 | 100102 | shareholding | 2014-02-04 | 60 | 60 | 60 | ||||
100102.interests.1 | 100102 | voting-rights | 2014-02-04 | 60 | 60 | 60 | ||||
100103.interests.0 | 100103 | shareholding | 2017-06-15 | 25 | 25 | 25 | ||||
100103.interests.1 | 100103 | voting-rights | 2017-06-15 | 25 | 25 | 25 | ||||
100104.interests.0 | 100104 | shareholding | 2022-09-01 | 50 | 50 | 50 | ||||
100104.interests.1 | 100104 | voting-rights | 2022-09-01 | 50 | 50 | 50 | ||||
100105.interests.0 | 100105 | shareholding | 2022-04-13 | 50 | 50 | 50 | ||||
100105.interests.1 | 100105 | voting-rights | 2022-04-13 | 50 | 50 | 50 | ||||
100106.interests.0 | 100106 | shareholding | 2015-02-04 | 100 | 100 | 100 | ||||
100106.interests.1 | 100106 | voting-rights | 2015-02-04 | 100 | 100 | 100 | ||||
100107.interests.0 | 100107 | shareholding | 2019-08-14 | 40 | 40 | 40 | ||||
100107.interests.1 | 100107 | voting-rights | 2019-08-14 | 40 | 40 | 40 | ||||
100108.interests.0 | 100108 | shareholding | 2022-09-15 | 2020-06-24 | 50 | 50 | 50 | |||
100108.interests.1 | 100108 | voting-rights | 2022-09-15 | 2020-06-24 | 50 | 50 | 50 | |||
100109.interests.0 | 100109 | shareholding | 2017-04-05 | 50 | 50 | 50 | ||||
100109.interests.1 | 100109 | voting-rights | 2017-04-05 | 50 | 50 | 50 | ||||
100110.interests.0 | 100110 | shareholding | 2016-10-03 | 100 | 100 | 100 | ||||
100110.interests.1 | 100110 | voting-rights | 2016-10-03 | 100 | 100 | 100 | ||||
100111.interests.0 | 100111 | shareholding | 2016-10-03 | 30 | 30 | 30 | ||||
100111.interests.1 | 100111 | voting-rights | 2016-10-03 | 30 | 30 | 30 | ||||
100112.interests.0 | 100112 | shareholding | 1997-07-01 | 100 | 100 | 100 | ||||
100112.interests.1 | 100112 | voting-rights | 1997-07-01 | 100 | 100 | 100 | ||||
100113.interests.0 | 100113 | shareholding | 2020-09-25 | 2016-07-26 | 50 | 50 | 50 | |||
100113.interests.1 | 100113 | voting-rights | 2020-09-25 | 2016-07-26 | 50 | 50 | 50 | |||
100114.interests.0 | 100114 | shareholding | 2021-05-14 | 2018-02-01 | 33.33 | 33.33 | 33.33 | |||
100114.interests.1 | 100114 | voting-rights | 2021-05-14 | 2018-02-01 | 33.33 | 33.33 | 33.33 | |||
100115.interests.0 | 100115 | shareholding | 2018-12-21 | 100 | 100 | 100 | ||||
100115.interests.1 | 100115 | voting-rights | 2018-12-21 | 100 | 100 | 100 | ||||
100116.interests.0 | 100116 | shareholding | 2018-12-21 | 100 | 100 | 100 | ||||
100116.interests.1 | 100116 | voting-rights | 2018-12-21 | 100 | 100 | 100 | ||||
100117.interests.0 | 100117 | shareholding | 2018-04-25 | 50 | 50 | 50 | ||||
100117.interests.1 | 100117 | voting-rights | 2018-04-25 | 50 | 50 | 50 | ||||
100118.interests.0 | 100118 | shareholding | 2018-12-21 | 100 | 100 | 100 | ||||
100118.interests.1 | 100118 | voting-rights | 2018-12-21 | 100 | 100 | 100 | ||||
100119.interests.0 | 100119 | shareholding | 2014-11-03 | 100 | 100 | 100 | ||||
100119.interests.1 | 100119 | voting-rights | 2014-11-03 | 100 | 100 | 100 | ||||
10012.interests.0 | 10012 | shareholding | 2019-09-09 | 2016-08-23 | 100 | 100 | 100 | |||
10012.interests.1 | 10012 | voting-rights | 2019-09-09 | 2016-08-23 | 100 | 100 | 100 | |||
100120.interests.0 | 100120 | shareholding | 2016-10-03 | 100 | 100 | 100 | ||||
100120.interests.1 | 100120 | voting-rights | 2016-10-03 | 100 | 100 | 100 | ||||
100121.interests.0 | 100121 | shareholding | 2016-10-03 | 30 | 30 | 30 | ||||
100121.interests.1 | 100121 | voting-rights | 2016-10-03 | 30 | 30 | 30 | ||||
100122.interests.0 | 100122 | shareholding | 2020-01-24 | 2009-01-19 | 49.8 | 49.8 | 49.8 | |||
100122.interests.1 | 100122 | voting-rights | 2020-01-24 | 2009-01-19 | 49.8 | 49.8 | 49.8 | |||
100123.interests.0 | 100123 | shareholding | 2020-01-24 | 2009-01-19 | 100 | 100 | 100 | |||
100123.interests.1 | 100123 | voting-rights | 2020-01-24 | 2009-01-19 | 100 | 100 | 100 | |||
100124.interests.0 | 100124 | shareholding | 2021-01-21 | 40 | 40 | 40 | ||||
100124.interests.1 | 100124 | voting-rights | 2021-01-21 | 40 | 40 | 40 | ||||
100125.interests.0 | 100125 | shareholding | 2021-01-12 | 100 | 100 | 100 | ||||
100125.interests.1 | 100125 | voting-rights | 2021-01-12 | 100 | 100 | 100 | ||||
100127.interests.0 | 100127 | shareholding | 2009-08-11 | 100 | 100 | 100 | ||||
100127.interests.1 | 100127 | voting-rights | 2009-08-11 | 100 | 100 | 100 | ||||
100128.interests.0 | 100128 | shareholding | 2020-06-23 | 100 | 100 | 100 | ||||
100128.interests.1 | 100128 | voting-rights | 2020-06-23 | 100 | 100 | 100 | ||||
100129.interests.0 | 100129 | shareholding | 2009-08-11 | 28.999999999999996 | 28.999999999999996 | 28.999999999999996 | ||||
100129.interests.1 | 100129 | voting-rights | 2009-08-11 | 28.999999999999996 | 28.999999999999996 | 28.999999999999996 | ||||
10013.interests.0 | 10013 | shareholding | 2019-09-09 | 2019-04-03 | 100 | 100 | 100 | |||
10013.interests.1 | 10013 | voting-rights | 2019-09-09 | 2019-04-03 | 100 | 100 | 100 | |||
100130.interests.0 | 100130 | shareholding | 2013-05-29 | 25 | 25 | 25 | ||||
100130.interests.1 | 100130 | voting-rights | 2013-05-29 | 25 | 25 | 25 | ||||
100131.interests.0 | 100131 | shareholding | 2020-12-21 | 25 | 25 | 25 | ||||
100131.interests.1 | 100131 | voting-rights | 2020-12-21 | 25 | 25 | 25 | ||||
100132.interests.0 | 100132 | shareholding | 2021-06-30 | 2020-06-18 | 25 | 25 | 25 | |||
100132.interests.1 | 100132 | voting-rights | 2021-06-30 | 2020-06-18 | 25 | 25 | 25 | |||
100133.interests.0 | 100133 | shareholding | 2020-12-31 | 2017-08-27 | 50 | 50 | 50 | |||
100133.interests.1 | 100133 | voting-rights | 2020-12-31 | 2017-08-27 | 50 | 50 | 50 | |||
100134.interests.0 | 100134 | shareholding | 2022-05-27 | 2020-02-17 | 100 | 100 | 100 | |||
100134.interests.1 | 100134 | voting-rights | 2022-05-27 | 2020-02-17 | 100 | 100 | 100 | |||
100135.interests.0 | 100135 | shareholding | 2017-12-01 | 2016-03-21 | 100 | 100 | 100 | |||
100135.interests.1 | 100135 | voting-rights | 2017-12-01 | 2016-03-21 | 100 | 100 | 100 | |||
100136.interests.0 | 100136 | shareholding | 2017-12-11 | 2016-03-21 | 100 | 100 | 100 | |||
100136.interests.1 | 100136 | voting-rights | 2017-12-11 | 2016-03-21 | 100 | 100 | 100 | |||
100137.interests.0 | 100137 | shareholding | 2021-01-26 | 100 | 100 | 100 | ||||
100137.interests.1 | 100137 | voting-rights | 2021-01-26 | 100 | 100 | 100 | ||||
100138.interests.0 | 100138 | shareholding | 2017-05-30 | 50 | 50 | 50 | ||||
100138.interests.1 | 100138 | voting-rights | 2017-05-30 | 50 | 50 | 50 | ||||
100139.interests.0 | 100139 | shareholding | 2019-02-06 | 1989-06-21 | 100 | 100 | 100 | |||
100139.interests.1 | 100139 | voting-rights | 2019-02-06 | 1989-06-21 | 100 | 100 | 100 | |||
10014.interests.0 | 10014 | shareholding | 2017-12-21 | 2017-03-10 | 51 | 51 | 51 | |||
10014.interests.1 | 10014 | voting-rights | 2017-12-21 | 2017-03-10 | 51 | 51 | 51 | |||
100140.interests.0 | 100140 | shareholding | 2018-01-29 | 2014-06-27 | 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]) );