ooc_interests
31,673,736 rows
This data as json, CSV (advanced)
These facets timed out: enddate
_link ▼ | _link_ooc_statement | type | startdate | share_exact | share_maximum | share_minimum | enddate | details | share_exclusivemaximum | share_exclusiveminimum |
---|---|---|---|---|---|---|---|---|---|---|
10000088.interests.0 | 10000088 | shareholding | 2016-07-01 | 75 | 50 | ownership-of-shares-50-to-75-percent | true | true | ||
10000089.interests.0 | 10000089 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000089.interests.1 | 10000089 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000089.interests.2 | 10000089 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000090.interests.0 | 10000090 | shareholding | 2017-05-02 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000090.interests.1 | 10000090 | voting-rights | 2017-05-02 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000091.interests.0 | 10000091 | shareholding | 2017-03-29 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000092.interests.0 | 10000092 | shareholding | 2017-05-02 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000092.interests.1 | 10000092 | voting-rights | 2017-05-02 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000092.interests.2 | 10000092 | appointment-of-board | 2017-05-02 | right-to-appoint-and-remove-directors | ||||||
10000093.interests.0 | 10000093 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000094.interests.0 | 10000094 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000095.interests.0 | 10000095 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000095.interests.1 | 10000095 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000095.interests.2 | 10000095 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000096.interests.0 | 10000096 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000096.interests.1 | 10000096 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000096.interests.2 | 10000096 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000097.interests.0 | 10000097 | shareholding | 2016-06-01 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000097.interests.1 | 10000097 | voting-rights | 2016-06-01 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000098.interests.0 | 10000098 | shareholding | 2017-04-06 | 75 | 50 | ownership-of-shares-50-to-75-percent | true | true | ||
10000098.interests.1 | 10000098 | voting-rights | 2017-04-06 | 75 | 50 | voting-rights-50-to-75-percent | true | true | ||
10000098.interests.2 | 10000098 | appointment-of-board | 2017-04-06 | right-to-appoint-and-remove-directors | ||||||
10000099.interests.0 | 10000099 | shareholding | 2017-04-18 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000099.interests.1 | 10000099 | voting-rights | 2017-04-18 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
100001.interests.0 | 100001 | shareholding | 2018-03-26 | 50 | 50 | 50 | ||||
100001.interests.1 | 100001 | voting-rights | 2018-03-26 | 50 | 50 | 50 | ||||
1000010.interests.0 | 1000010 | shareholding | 2020-10-28 | 31.67 | 31.67 | 31.67 | ||||
1000010.interests.1 | 1000010 | voting-rights | 2020-10-28 | 31.67 | 31.67 | 31.67 | ||||
10000100.interests.0 | 10000100 | shareholding | 2016-06-29 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000100.interests.1 | 10000100 | voting-rights | 2016-06-29 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000101.interests.0 | 10000101 | shareholding | 2016-06-01 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000102.interests.0 | 10000102 | shareholding | 2017-05-02 | 50 | 25 | 2018-01-31 | ownership-of-shares-25-to-50-percent | false | true | |
10000102.interests.1 | 10000102 | voting-rights | 2017-05-02 | 50 | 25 | 2018-01-31 | voting-rights-25-to-50-percent | false | true | |
10000103.interests.0 | 10000103 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000103.interests.1 | 10000103 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000103.interests.2 | 10000103 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000104.interests.0 | 10000104 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000104.interests.1 | 10000104 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000104.interests.2 | 10000104 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000105.interests.0 | 10000105 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000105.interests.1 | 10000105 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000106.interests.0 | 10000106 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000107.interests.0 | 10000107 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000107.interests.1 | 10000107 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000108.interests.0 | 10000108 | shareholding | 2017-03-15 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000109.interests.0 | 10000109 | shareholding | 2017-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
1000011.interests.0 | 1000011 | shareholding | 2019-12-23 | 100 | 100 | 100 | ||||
1000011.interests.1 | 1000011 | voting-rights | 2019-12-23 | 100 | 100 | 100 | ||||
10000110.interests.0 | 10000110 | shareholding | 2017-04-18 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000110.interests.1 | 10000110 | voting-rights | 2017-04-18 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000110.interests.2 | 10000110 | appointment-of-board | 2017-04-18 | right-to-appoint-and-remove-directors | ||||||
10000111.interests.0 | 10000111 | shareholding | 2016-04-19 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000111.interests.1 | 10000111 | voting-rights | 2016-04-19 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000112.interests.0 | 10000112 | other-influence-or-control | 2017-04-18 | significant-influence-or-control | ||||||
10000113.interests.0 | 10000113 | shareholding | 2017-03-24 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000113.interests.1 | 10000113 | voting-rights | 2017-03-24 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000114.interests.0 | 10000114 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000115.interests.0 | 10000115 | shareholding | 2016-07-01 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000116.interests.0 | 10000116 | shareholding | 2016-04-06 | 75 | 50 | ownership-of-shares-50-to-75-percent | true | true | ||
10000116.interests.1 | 10000116 | voting-rights | 2016-04-06 | 75 | 50 | voting-rights-50-to-75-percent | true | true | ||
10000117.interests.0 | 10000117 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000117.interests.1 | 10000117 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000118.interests.0 | 10000118 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000118.interests.1 | 10000118 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000118.interests.2 | 10000118 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000119.interests.0 | 10000119 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000119.interests.1 | 10000119 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000119.interests.2 | 10000119 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
1000012.interests.0 | 1000012 | shareholding | 2006-11-23 | 35.5 | 35.5 | 35.5 | ||||
1000012.interests.1 | 1000012 | voting-rights | 2006-11-23 | 30.1 | 30.1 | 30.1 | ||||
10000120.interests.0 | 10000120 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000121.interests.0 | 10000121 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000121.interests.1 | 10000121 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000121.interests.2 | 10000121 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000122.interests.0 | 10000122 | shareholding | 2017-04-19 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000122.interests.1 | 10000122 | voting-rights | 2017-04-19 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000123.interests.0 | 10000123 | shareholding | 2016-10-01 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000124.interests.0 | 10000124 | other-influence-or-control | 2017-04-18 | significant-influence-or-control | ||||||
10000125.interests.0 | 10000125 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000125.interests.1 | 10000125 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000125.interests.2 | 10000125 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000126.interests.0 | 10000126 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000126.interests.1 | 10000126 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000127.interests.0 | 10000127 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000128.interests.0 | 10000128 | shareholding | 2017-04-08 | 50 | 25 | 2021-01-22 | ownership-of-shares-25-to-50-percent | false | true | |
10000129.interests.0 | 10000129 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
1000013.interests.0 | 1000013 | shareholding | 2018-06-03 | 100 | 100 | 100 | ||||
1000013.interests.1 | 1000013 | voting-rights | 2018-06-03 | 100 | 100 | 100 | ||||
10000130.interests.0 | 10000130 | shareholding | 2017-05-02 | 100 | 75 | 2020-06-16 | ownership-of-shares-75-to-100-percent | false | false | |
10000130.interests.1 | 10000130 | shareholding | 2017-05-02 | 100 | 75 | 2020-06-16 | ownership-of-shares-75-to-100-percent-as-firm | false | false | |
10000130.interests.2 | 10000130 | voting-rights | 2017-05-02 | 100 | 75 | 2020-06-16 | voting-rights-75-to-100-percent | false | false | |
10000130.interests.3 | 10000130 | voting-rights | 2017-05-02 | 100 | 75 | 2020-06-16 | voting-rights-75-to-100-percent-as-firm | false | false | |
10000130.interests.4 | 10000130 | appointment-of-board | 2017-05-02 | 2020-06-16 | right-to-appoint-and-remove-directors | |||||
10000130.interests.5 | 10000130 | appointment-of-board | 2017-05-02 | 2020-06-16 | right-to-appoint-and-remove-directors-as-firm | |||||
10000131.interests.0 | 10000131 | shareholding | 2017-03-25 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000132.interests.0 | 10000132 | shareholding | 2017-01-01 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000133.interests.0 | 10000133 | shareholding | 2017-04-04 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000133.interests.1 | 10000133 | voting-rights | 2017-04-04 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000134.interests.0 | 10000134 | other-influence-or-control | 2017-01-01 | significant-influence-or-control |
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 , [details] TEXT , [share_exclusivemaximum] BOOL , [share_exclusiveminimum] BOOL , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );