ooc_interests
1,324,489 rows sorted by share_exclusivemaximum
This data as json, CSV (advanced)
_link | _link_ooc_statement | type | enddate | startdate | share_exact | share_maximum | share_minimum | details | share_exclusiveminimum | share_exclusivemaximum ▼ |
---|---|---|---|---|---|---|---|---|---|---|
58.interests.1 | 58 | voting-rights | 2019-12-03 | 2016-06-23 | 100 | 100 | 100 | |||
580.interests.0 | 580 | shareholding | 2021-08-27 | 50 | 50 | 50 | ||||
580.interests.1 | 580 | voting-rights | 2021-08-27 | 50 | 50 | 50 | ||||
58000.interests.0 | 58000 | shareholding | 2017-07-12 | 100 | 100 | 100 | ||||
58000.interests.1 | 58000 | voting-rights | 2017-07-12 | 100 | 100 | 100 | ||||
580000.interests.0 | 580000 | shareholding | 2018-01-15 | 2016-03-14 | 100 | 100 | 100 | |||
580000.interests.1 | 580000 | voting-rights | 2018-01-15 | 2016-03-14 | 100 | 100 | 100 | |||
580001.interests.0 | 580001 | shareholding | 2005-06-28 | 100 | 100 | 100 | ||||
580001.interests.1 | 580001 | voting-rights | 2005-06-28 | 100 | 100 | 100 | ||||
580002.interests.0 | 580002 | shareholding | 2018-01-15 | 100 | 100 | 100 | ||||
580002.interests.1 | 580002 | voting-rights | 2018-01-15 | 100 | 100 | 100 | ||||
580004.interests.0 | 580004 | shareholding | 2020-10-12 | 2018-01-02 | 100 | 100 | 100 | |||
580004.interests.1 | 580004 | voting-rights | 2020-10-12 | 2018-01-02 | 100 | 100 | 100 | |||
580005.interests.0 | 580005 | shareholding | 2019-12-12 | 100 | 100 | 100 | ||||
580005.interests.1 | 580005 | voting-rights | 2019-12-12 | 100 | 100 | 100 | ||||
580006.interests.0 | 580006 | shareholding | 2019-01-16 | 2015-12-15 | 100 | 100 | 100 | |||
580006.interests.1 | 580006 | voting-rights | 2019-01-16 | 2015-12-15 | 100 | 100 | 100 | |||
580007.interests.0 | 580007 | shareholding | 2021-09-30 | 100 | 100 | 100 | ||||
580007.interests.1 | 580007 | voting-rights | 2021-09-30 | 100 | 100 | 100 | ||||
580008.interests.0 | 580008 | shareholding | 2019-08-01 | 2014-01-01 | 100 | 100 | 100 | |||
580008.interests.1 | 580008 | voting-rights | 2019-08-01 | 2014-01-01 | 100 | 100 | 100 | |||
580009.interests.0 | 580009 | shareholding | 2021-12-01 | 25 | 25 | 25 | ||||
580009.interests.1 | 580009 | voting-rights | 2021-12-01 | 25 | 25 | 25 | ||||
58001.interests.0 | 58001 | shareholding | 2017-08-30 | 47.34 | 47.34 | 47.34 | ||||
58001.interests.1 | 58001 | voting-rights | 2017-08-30 | 47.34 | 47.34 | 47.34 | ||||
580010.interests.0 | 580010 | shareholding | 2019-08-01 | 2016-07-06 | 100 | 100 | 100 | |||
580010.interests.1 | 580010 | voting-rights | 2019-08-01 | 2016-07-06 | 100 | 100 | 100 | |||
580012.interests.0 | 580012 | shareholding | 2018-04-15 | 100 | 100 | 100 | ||||
580012.interests.1 | 580012 | voting-rights | 2018-04-15 | 100 | 100 | 100 | ||||
580013.interests.0 | 580013 | shareholding | 2018-07-05 | 2015-08-31 | 50 | 50 | 50 | |||
580013.interests.1 | 580013 | voting-rights | 2018-07-05 | 2015-08-31 | 50 | 50 | 50 | |||
580014.interests.0 | 580014 | shareholding | 2018-05-16 | 100 | 100 | 100 | ||||
580014.interests.1 | 580014 | voting-rights | 2018-05-16 | 100 | 100 | 100 | ||||
580015.interests.0 | 580015 | shareholding | 2020-11-13 | 2020-04-28 | 15 | 15 | 15 | |||
580015.interests.1 | 580015 | voting-rights | 2020-11-13 | 2020-04-28 | 15 | 15 | 15 | |||
580016.interests.0 | 580016 | shareholding | 2018-08-22 | 100 | 100 | 100 | ||||
580016.interests.1 | 580016 | voting-rights | 2018-08-22 | 100 | 100 | 100 | ||||
580017.interests.0 | 580017 | shareholding | 2018-07-01 | 100 | 100 | 100 | ||||
580017.interests.1 | 580017 | voting-rights | 2018-07-01 | 100 | 100 | 100 | ||||
580018.interests.0 | 580018 | shareholding | 2008-02-08 | 30 | 30 | 30 | ||||
580018.interests.1 | 580018 | voting-rights | 2008-02-08 | 30 | 30 | 30 | ||||
580019.interests.0 | 580019 | shareholding | 2005-03-11 | 100 | 100 | 100 | ||||
580019.interests.1 | 580019 | voting-rights | 2005-03-11 | 100 | 100 | 100 | ||||
58002.interests.0 | 58002 | shareholding | 2017-06-29 | 100 | 100 | 100 | ||||
58002.interests.1 | 58002 | voting-rights | 2017-06-29 | 100 | 100 | 100 | ||||
580020.interests.0 | 580020 | shareholding | 2020-07-06 | 25 | 25 | 25 | ||||
580020.interests.1 | 580020 | voting-rights | 2020-07-06 | 25 | 25 | 25 | ||||
580021.interests.0 | 580021 | shareholding | 2021-12-06 | 2019-11-01 | 100 | 100 | 100 | |||
580021.interests.1 | 580021 | voting-rights | 2021-12-06 | 2019-11-01 | 100 | 100 | 100 | |||
580022.interests.0 | 580022 | shareholding | 2019-11-01 | 100 | 100 | 100 | ||||
580022.interests.1 | 580022 | voting-rights | 2019-11-01 | 100 | 100 | 100 | ||||
580023.interests.0 | 580023 | shareholding | 2018-06-12 | 100 | 100 | 100 | ||||
580023.interests.1 | 580023 | voting-rights | 2018-06-12 | 100 | 100 | 100 | ||||
580024.interests.0 | 580024 | shareholding | 2016-09-01 | 50 | 50 | 50 | ||||
580024.interests.1 | 580024 | voting-rights | 2016-09-01 | 50 | 50 | 50 | ||||
580025.interests.0 | 580025 | shareholding | 2018-04-04 | 100 | 100 | 100 | ||||
580025.interests.1 | 580025 | voting-rights | 2018-04-04 | 100 | 100 | 100 | ||||
580026.interests.0 | 580026 | shareholding | 2018-04-04 | 100 | 100 | 100 | ||||
580026.interests.1 | 580026 | voting-rights | 2018-04-04 | 100 | 100 | 100 | ||||
580027.interests.0 | 580027 | shareholding | 2016-05-26 | 50 | 50 | 50 | ||||
580027.interests.1 | 580027 | voting-rights | 2016-05-26 | 50 | 50 | 50 | ||||
580028.interests.0 | 580028 | shareholding | 2016-05-26 | 50 | 50 | 50 | ||||
580028.interests.1 | 580028 | voting-rights | 2016-05-26 | 50 | 50 | 50 | ||||
580029.interests.0 | 580029 | shareholding | 2016-05-26 | 50 | 50 | 50 | ||||
580029.interests.1 | 580029 | voting-rights | 2016-05-26 | 50 | 50 | 50 | ||||
58003.interests.0 | 58003 | shareholding | 2019-02-05 | 2018-09-30 | 100 | 100 | 100 | |||
58003.interests.1 | 58003 | voting-rights | 2019-02-05 | 2018-09-30 | 100 | 100 | 100 | |||
580030.interests.0 | 580030 | shareholding | 2020-07-16 | 50 | 50 | 50 | ||||
580030.interests.1 | 580030 | voting-rights | 2020-07-16 | 50 | 50 | 50 | ||||
580032.interests.0 | 580032 | shareholding | 2021-01-15 | 2015-05-01 | 100 | 100 | 100 | |||
580032.interests.1 | 580032 | voting-rights | 2021-01-15 | 2015-05-01 | 100 | 100 | 100 | |||
580033.interests.0 | 580033 | shareholding | 2014-12-19 | 100 | 100 | 100 | ||||
580033.interests.1 | 580033 | voting-rights | 2014-12-19 | 100 | 100 | 100 | ||||
580034.interests.0 | 580034 | shareholding | 2020-01-28 | 2018-04-06 | 100 | 100 | 100 | |||
580034.interests.1 | 580034 | voting-rights | 2020-01-28 | 2018-04-06 | 100 | 100 | 100 | |||
580035.interests.0 | 580035 | shareholding | 2002-01-06 | 100 | 100 | 100 | ||||
580035.interests.1 | 580035 | voting-rights | 2002-01-06 | 100 | 100 | 100 | ||||
580036.interests.0 | 580036 | shareholding | 2020-07-01 | 50 | 50 | 50 | ||||
580036.interests.1 | 580036 | voting-rights | 2020-07-01 | 50 | 50 | 50 | ||||
580037.interests.0 | 580037 | shareholding | 2020-07-28 | 50 | 50 | 50 | ||||
580037.interests.1 | 580037 | voting-rights | 2020-07-28 | 50 | 50 | 50 | ||||
580038.interests.0 | 580038 | shareholding | 2012-05-21 | 100 | 100 | 100 | ||||
580038.interests.1 | 580038 | voting-rights | 2012-05-21 | 100 | 100 | 100 | ||||
580039.interests.0 | 580039 | shareholding | 2012-05-29 | 50 | 50 | 50 | ||||
580039.interests.1 | 580039 | voting-rights | 2012-05-29 | 50 | 50 | 50 | ||||
58004.interests.0 | 58004 | shareholding | 2020-06-13 | 19 | 19 | 19 | ||||
58004.interests.1 | 58004 | voting-rights | 2020-06-13 | 19 | 19 | 19 | ||||
580040.interests.0 | 580040 | shareholding | 2018-05-15 | 100 | 100 | 100 | ||||
580040.interests.1 | 580040 | voting-rights | 2018-05-15 | 100 | 100 | 100 | ||||
580041.interests.0 | 580041 | shareholding | 2018-05-16 | 100 | 100 | 100 | ||||
580041.interests.1 | 580041 | voting-rights | 2018-05-16 | 100 | 100 | 100 | ||||
580042.interests.0 | 580042 | shareholding | 2019-12-31 | 2018-05-20 | 50 | 50 | 50 | |||
580042.interests.1 | 580042 | voting-rights | 2019-12-31 | 2018-05-20 | 50 | 50 | 50 | |||
580043.interests.0 | 580043 | shareholding | 2022-06-06 | 100 | 100 | 100 | ||||
580043.interests.1 | 580043 | voting-rights | 2022-06-06 | 100 | 100 | 100 | ||||
580044.interests.0 | 580044 | shareholding | 2020-07-06 | 2020-04-28 | 20 | 20 | 20 | |||
580044.interests.1 | 580044 | voting-rights | 2020-07-06 | 2020-04-28 | 20 | 20 | 20 | |||
580046.interests.0 | 580046 | shareholding | 2020-09-01 | 50 | 50 | 50 | ||||
580046.interests.1 | 580046 | voting-rights | 2020-09-01 | 50 | 50 | 50 | ||||
580048.interests.0 | 580048 | shareholding | 2018-11-19 | 2017-12-12 | 17.8 | 17.8 | 17.8 |
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]) );