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 |
---|---|---|---|---|---|---|---|---|---|---|
100045.interests.0 | 100045 | shareholding | 2016-11-30 | 100 | 100 | 100 | ||||
100045.interests.1 | 100045 | voting-rights | 2016-11-30 | 100 | 100 | 100 | ||||
100046.interests.0 | 100046 | shareholding | 2020-08-13 | 100 | 100 | 100 | ||||
100046.interests.1 | 100046 | voting-rights | 2020-08-13 | 100 | 100 | 100 | ||||
100047.interests.0 | 100047 | shareholding | 2020-11-23 | 2017-05-03 | 100 | 100 | 100 | |||
100047.interests.1 | 100047 | voting-rights | 2020-11-23 | 2017-05-03 | 100 | 100 | 100 | |||
100048.interests.0 | 100048 | shareholding | 2019-08-06 | 1984-07-01 | 87.08 | 87.08 | 87.08 | |||
100048.interests.1 | 100048 | voting-rights | 2019-08-06 | 1984-07-01 | 87.08 | 87.08 | 87.08 | |||
100049.interests.0 | 100049 | shareholding | 2017-06-16 | 100 | 100 | 100 | ||||
100049.interests.1 | 100049 | voting-rights | 2017-06-16 | 100 | 100 | 100 | ||||
10005.interests.0 | 10005 | shareholding | 2022-05-31 | 40 | 40 | 40 | ||||
10005.interests.1 | 10005 | voting-rights | 2022-05-31 | 40 | 40 | 40 | ||||
100050.interests.0 | 100050 | shareholding | 2017-06-16 | 100 | 100 | 100 | ||||
100050.interests.1 | 100050 | voting-rights | 2017-06-16 | 100 | 100 | 100 | ||||
100051.interests.0 | 100051 | shareholding | 2019-08-06 | 2018-12-05 | 100 | 100 | 100 | |||
100051.interests.1 | 100051 | voting-rights | 2019-08-06 | 2018-12-05 | 100 | 100 | 100 | |||
100052.interests.0 | 100052 | shareholding | 2018-12-18 | 33.33 | 33.33 | 33.33 | ||||
100052.interests.1 | 100052 | voting-rights | 2018-12-18 | 33.33 | 33.33 | 33.33 | ||||
100053.interests.0 | 100053 | shareholding | 2017-12-28 | 2017-12-22 | 33.33 | 33.33 | 33.33 | |||
100053.interests.1 | 100053 | voting-rights | 2017-12-28 | 2017-12-22 | 33.33 | 33.33 | 33.33 | |||
100054.interests.0 | 100054 | shareholding | 2018-01-01 | 33 | 33 | 33 | ||||
100054.interests.1 | 100054 | voting-rights | 2018-01-01 | 33 | 33 | 33 | ||||
100055.interests.0 | 100055 | shareholding | 2017-12-28 | 100 | 100 | 100 | ||||
100055.interests.1 | 100055 | voting-rights | 2017-12-28 | 100 | 100 | 100 | ||||
100056.interests.0 | 100056 | shareholding | 2016-09-12 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | ||||
100056.interests.1 | 100056 | voting-rights | 2016-09-12 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | ||||
100057.interests.0 | 100057 | shareholding | 2017-01-25 | 33.33 | 33.33 | 33.33 | ||||
100057.interests.1 | 100057 | voting-rights | 2017-01-25 | 33.33 | 33.33 | 33.33 | ||||
100058.interests.0 | 100058 | shareholding | 2015-06-11 | 33.33 | 33.33 | 33.33 | ||||
100058.interests.1 | 100058 | voting-rights | 2015-06-11 | 33.33 | 33.33 | 33.33 | ||||
100059.interests.0 | 100059 | shareholding | 2017-05-20 | 50 | 50 | 50 | ||||
100059.interests.1 | 100059 | voting-rights | 2017-05-20 | 50 | 50 | 50 | ||||
10006.interests.0 | 10006 | shareholding | 2017-07-04 | 40 | 40 | 40 | ||||
10006.interests.1 | 10006 | voting-rights | 2017-07-04 | 40 | 40 | 40 | ||||
100060.interests.0 | 100060 | shareholding | 2020-08-11 | 2017-05-01 | 50 | 50 | 50 | |||
100060.interests.1 | 100060 | voting-rights | 2020-08-11 | 2017-05-01 | 50 | 50 | 50 | |||
100061.interests.0 | 100061 | shareholding | 2021-01-06 | 100 | 100 | 100 | ||||
100061.interests.1 | 100061 | voting-rights | 2021-01-06 | 100 | 100 | 100 | ||||
100062.interests.0 | 100062 | shareholding | 2021-01-06 | 100 | 100 | 100 | ||||
100062.interests.1 | 100062 | voting-rights | 2021-01-06 | 100 | 100 | 100 | ||||
100063.interests.0 | 100063 | shareholding | 2019-08-06 | 2019-07-30 | 100 | 100 | 100 | |||
100063.interests.1 | 100063 | voting-rights | 2019-08-06 | 2019-07-30 | 100 | 100 | 100 | |||
100064.interests.0 | 100064 | shareholding | 2019-11-19 | 2017-08-18 | 100 | 100 | 100 | |||
100064.interests.1 | 100064 | voting-rights | 2019-11-19 | 2017-08-18 | 100 | 100 | 100 | |||
100065.interests.0 | 100065 | shareholding | 2021-04-01 | 25 | 25 | 25 | ||||
100065.interests.1 | 100065 | voting-rights | 2021-04-01 | 25 | 25 | 25 | ||||
100066.interests.0 | 100066 | shareholding | 2021-04-01 | 25 | 25 | 25 | ||||
100066.interests.1 | 100066 | voting-rights | 2021-04-01 | 25 | 25 | 25 | ||||
100067.interests.0 | 100067 | shareholding | 2021-09-15 | 100 | 100 | 100 | ||||
100067.interests.1 | 100067 | voting-rights | 2021-09-15 | 100 | 100 | 100 | ||||
100068.interests.0 | 100068 | shareholding | 2018-08-22 | 100 | 100 | 100 | ||||
100068.interests.1 | 100068 | voting-rights | 2018-08-22 | 100 | 100 | 100 | ||||
100069.interests.0 | 100069 | shareholding | 2018-03-22 | 2018-01-31 | 50 | 50 | 50 | |||
100069.interests.1 | 100069 | voting-rights | 2018-03-22 | 2018-01-31 | 50 | 50 | 50 | |||
10007.interests.0 | 10007 | shareholding | 2017-07-04 | 40 | 40 | 40 | ||||
100070.interests.0 | 100070 | shareholding | 2022-08-26 | 50 | 50 | 50 | ||||
100070.interests.1 | 100070 | voting-rights | 2022-08-26 | 50 | 50 | 50 | ||||
100071.interests.0 | 100071 | shareholding | 2022-02-28 | 2017-06-14 | 50 | 50 | 50 | |||
100071.interests.1 | 100071 | voting-rights | 2022-02-28 | 2017-06-14 | 50 | 50 | 50 | |||
100073.interests.0 | 100073 | shareholding | 2017-04-21 | 100 | 100 | 100 | ||||
100073.interests.1 | 100073 | voting-rights | 2017-04-21 | 100 | 100 | 100 | ||||
100074.interests.0 | 100074 | shareholding | 2018-01-01 | 2016-07-05 | 100 | 100 | 100 | |||
100074.interests.1 | 100074 | voting-rights | 2018-01-01 | 2016-07-05 | 100 | 100 | 100 | |||
100075.interests.0 | 100075 | shareholding | 2017-08-09 | 100 | 100 | 100 | ||||
100075.interests.1 | 100075 | voting-rights | 2017-08-09 | 100 | 100 | 100 | ||||
100076.interests.0 | 100076 | shareholding | 2021-01-27 | 100 | 100 | 100 | ||||
100076.interests.1 | 100076 | voting-rights | 2021-01-27 | 100 | 100 | 100 | ||||
100077.interests.0 | 100077 | shareholding | 2021-02-15 | 52 | 52 | 52 | ||||
100077.interests.1 | 100077 | voting-rights | 2021-02-15 | 52 | 52 | 52 | ||||
100078.interests.0 | 100078 | shareholding | 2017-06-19 | 50 | 50 | 50 | ||||
100078.interests.1 | 100078 | voting-rights | 2017-06-19 | 50 | 50 | 50 | ||||
100079.interests.0 | 100079 | shareholding | 2020-12-18 | 100 | 100 | 100 | ||||
100079.interests.1 | 100079 | voting-rights | 2020-12-18 | 100 | 100 | 100 | ||||
10008.interests.0 | 10008 | shareholding | 2017-03-16 | 50 | 50 | 50 | ||||
10008.interests.1 | 10008 | voting-rights | 2017-03-16 | 50 | 50 | 50 | ||||
100080.interests.0 | 100080 | shareholding | 2021-01-20 | 25 | 25 | 25 | ||||
100080.interests.1 | 100080 | voting-rights | 2021-01-20 | 25 | 25 | 25 | ||||
100082.interests.0 | 100082 | shareholding | 2017-12-19 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | ||||
100082.interests.1 | 100082 | voting-rights | 2017-12-19 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | ||||
100083.interests.0 | 100083 | shareholding | 2017-12-19 | 100 | 100 | 100 | ||||
100083.interests.1 | 100083 | voting-rights | 2017-12-19 | 100 | 100 | 100 | ||||
100085.interests.0 | 100085 | shareholding | 2018-08-29 | 2016-04-01 | 100 | 100 | 100 | |||
100085.interests.1 | 100085 | voting-rights | 2018-08-29 | 2016-04-01 | 100 | 100 | 100 | |||
100086.interests.0 | 100086 | shareholding | 2018-04-03 | 100 | 100 | 100 | ||||
100086.interests.1 | 100086 | voting-rights | 2018-04-03 | 100 | 100 | 100 | ||||
100087.interests.0 | 100087 | shareholding | 2017-12-08 | 2015-01-01 | 100 | 100 | 100 | |||
100087.interests.1 | 100087 | voting-rights | 2017-12-08 | 2015-01-01 | 100 | 100 | 100 | |||
100088.interests.0 | 100088 | shareholding | 2014-05-08 | 100 | 100 | 100 | ||||
100088.interests.1 | 100088 | voting-rights | 2014-05-08 | 100 | 100 | 100 | ||||
100089.interests.0 | 100089 | shareholding | 2017-10-31 | 100 | 100 | 100 | ||||
100089.interests.1 | 100089 | voting-rights | 2017-10-31 | 100 | 100 | 100 | ||||
10009.interests.0 | 10009 | shareholding | 2019-11-13 | 50 | 50 | 50 | ||||
10009.interests.1 | 10009 | voting-rights | 2019-11-13 | 50 | 50 | 50 | ||||
100090.interests.0 | 100090 | shareholding | 2018-11-08 | 2018-11-07 | 25 | 25 | 25 | |||
100090.interests.1 | 100090 | voting-rights | 2018-11-08 | 2018-11-07 | 25 | 25 | 25 | |||
100091.interests.0 | 100091 | shareholding | 2017-05-08 | 50 | 50 | 50 | ||||
100091.interests.1 | 100091 | voting-rights | 2017-05-08 | 50 | 50 | 50 | ||||
100092.interests.0 | 100092 | shareholding | 2020-12-22 | 100 | 100 | 100 | ||||
100092.interests.1 | 100092 | voting-rights | 2020-12-22 | 100 | 100 | 100 | ||||
100093.interests.0 | 100093 | shareholding | 2020-12-22 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 |
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]) );