ooc_interests
29,985,745 rows
This data as json, CSV (advanced)
_link ▼ | _link_ooc_statement | details | type | startdate | share_exclusivemaximum | share_exclusiveminimum | share_maximum | share_minimum | enddate |
---|---|---|---|---|---|---|---|---|---|
10000123.interests.0 | 10000123 | ownership-of-shares-25-to-50-percent | shareholding | 2016-04-22 | false | true | 50 | 25 | |
10000123.interests.1 | 10000123 | voting-rights-25-to-50-percent | voting-rights | 2016-04-22 | false | true | 50 | 25 | |
10000123.interests.2 | 10000123 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-04-22 | |||||
10000124.interests.0 | 10000124 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-12 | false | false | 100 | 75 | |
10000124.interests.1 | 10000124 | voting-rights-75-to-100-percent | voting-rights | 2017-09-12 | false | false | 100 | 75 | |
10000124.interests.2 | 10000124 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-12 | |||||
10000125.interests.0 | 10000125 | ownership-of-shares-75-to-100-percent | shareholding | 2016-06-20 | false | false | 100 | 75 | |
10000126.interests.0 | 10000126 | ownership-of-shares-75-to-100-percent | shareholding | 2017-07-24 | false | false | 100 | 75 | |
10000126.interests.1 | 10000126 | voting-rights-75-to-100-percent | voting-rights | 2017-07-24 | false | false | 100 | 75 | |
10000126.interests.2 | 10000126 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-07-24 | |||||
10000127.interests.0 | 10000127 | ownership-of-shares-75-to-100-percent | shareholding | 2017-03-17 | false | false | 100 | 75 | |
10000127.interests.1 | 10000127 | voting-rights-75-to-100-percent | voting-rights | 2017-03-17 | false | false | 100 | 75 | |
10000127.interests.2 | 10000127 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-03-17 | |||||
10000128.interests.0 | 10000128 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-11 | false | false | 100 | 75 | |
10000128.interests.1 | 10000128 | voting-rights-25-to-50-percent | voting-rights | 2017-08-11 | false | true | 50 | 25 | |
10000128.interests.2 | 10000128 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-11 | |||||
10000129.interests.0 | 10000129 | ownership-of-shares-25-to-50-percent | shareholding | 2017-09-11 | false | true | 50 | 25 | 2020-11-24 |
10000129.interests.1 | 10000129 | voting-rights-25-to-50-percent | voting-rights | 2017-09-11 | false | true | 50 | 25 | 2020-11-24 |
10000129.interests.2 | 10000129 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | 2020-11-24 | ||||
1000013.interests.0 | 1000013 | significant-influence-or-control | other-influence-or-control | 2016-04-29 | |||||
1000013.interests.1 | 1000013 | significant-influence-or-control-as-trust | other-influence-or-control | 2016-04-29 | |||||
1000013.interests.2 | 1000013 | significant-influence-or-control-as-firm | other-influence-or-control | 2016-04-29 | |||||
10000130.interests.0 | 10000130 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-06 | false | false | 100 | 75 | |
10000130.interests.1 | 10000130 | voting-rights-75-to-100-percent | voting-rights | 2016-04-06 | false | false | 100 | 75 | |
10000131.interests.0 | 10000131 | ownership-of-shares-75-to-100-percent | shareholding | 2016-06-21 | false | false | 100 | 75 | |
10000132.interests.0 | 10000132 | significant-influence-or-control | other-influence-or-control | 2017-05-04 | |||||
10000133.interests.0 | 10000133 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-11 | false | false | 100 | 75 | |
10000133.interests.1 | 10000133 | voting-rights-75-to-100-percent | voting-rights | 2017-08-11 | false | false | 100 | 75 | |
10000133.interests.2 | 10000133 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-11 | |||||
10000134.interests.0 | 10000134 | ownership-of-shares-75-to-100-percent | shareholding | 2016-07-01 | false | false | 100 | 75 | |
10000135.interests.0 | 10000135 | ownership-of-shares-25-to-50-percent | shareholding | 2017-07-24 | false | true | 50 | 25 | |
10000135.interests.1 | 10000135 | ownership-of-shares-25-to-50-percent-as-trust | shareholding | 2017-07-24 | false | true | 50 | 25 | |
10000135.interests.2 | 10000135 | ownership-of-shares-25-to-50-percent-as-firm | shareholding | 2017-07-24 | false | true | 50 | 25 | |
10000135.interests.3 | 10000135 | voting-rights-25-to-50-percent | voting-rights | 2017-07-24 | false | true | 50 | 25 | |
10000135.interests.4 | 10000135 | voting-rights-25-to-50-percent-as-trust | voting-rights | 2017-07-24 | false | true | 50 | 25 | |
10000135.interests.5 | 10000135 | voting-rights-25-to-50-percent-as-firm | voting-rights | 2017-07-24 | false | true | 50 | 25 | |
10000136.interests.0 | 10000136 | ownership-of-shares-75-to-100-percent | shareholding | 2016-07-08 | false | false | 100 | 75 | 2016-07-09 |
10000136.interests.1 | 10000136 | voting-rights-75-to-100-percent | voting-rights | 2016-07-08 | false | false | 100 | 75 | 2016-07-09 |
10000136.interests.2 | 10000136 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-07-08 | 2016-07-09 | ||||
10000137.interests.0 | 10000137 | ownership-of-shares-25-to-50-percent | shareholding | 2016-04-06 | false | true | 50 | 25 | 2019-09-18 |
10000137.interests.1 | 10000137 | voting-rights-25-to-50-percent | voting-rights | 2016-04-06 | false | true | 50 | 25 | 2019-09-18 |
10000137.interests.2 | 10000137 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-04-06 | 2019-09-18 | ||||
10000138.interests.0 | 10000138 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-11 | false | false | 100 | 75 | 2017-10-27 |
10000138.interests.1 | 10000138 | voting-rights-75-to-100-percent | voting-rights | 2017-08-11 | false | false | 100 | 75 | 2017-10-27 |
10000138.interests.2 | 10000138 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-11 | 2017-10-27 | ||||
10000139.interests.0 | 10000139 | ownership-of-shares-25-to-50-percent | shareholding | 2016-04-06 | false | true | 50 | 25 | |
10000139.interests.1 | 10000139 | voting-rights-25-to-50-percent | voting-rights | 2016-04-06 | false | true | 50 | 25 | |
1000014.interests.0 | 1000014 | ownership-of-shares-50-to-75-percent | shareholding | 2016-04-06 | true | true | 75 | 50 | |
1000014.interests.1 | 1000014 | voting-rights-50-to-75-percent | voting-rights | 2016-04-06 | true | true | 75 | 50 | |
10000140.interests.0 | 10000140 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-12 | false | false | 100 | 75 | 2017-09-12 |
10000140.interests.1 | 10000140 | voting-rights-75-to-100-percent | voting-rights | 2017-09-12 | false | false | 100 | 75 | 2017-09-12 |
10000141.interests.0 | 10000141 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
10000141.interests.1 | 10000141 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
10000141.interests.2 | 10000141 | right-to-appoint-and-remove-directors-as-trust | appointment-of-board | 2017-09-11 | |||||
10000141.interests.3 | 10000141 | right-to-appoint-and-remove-directors-as-firm | appointment-of-board | 2017-09-11 | |||||
10000142.interests.0 | 10000142 | ownership-of-shares-25-to-50-percent | shareholding | 2016-04-06 | false | true | 50 | 25 | |
10000142.interests.1 | 10000142 | voting-rights-25-to-50-percent | voting-rights | 2016-04-06 | false | true | 50 | 25 | |
10000142.interests.2 | 10000142 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-04-06 | |||||
10000143.interests.0 | 10000143 | right-to-appoint-and-remove-directors-as-firm | appointment-of-board | 2017-09-11 | |||||
10000144.interests.0 | 10000144 | ownership-of-shares-25-to-50-percent | shareholding | 2017-09-11 | false | true | 50 | 25 | |
10000144.interests.1 | 10000144 | voting-rights-25-to-50-percent | voting-rights | 2017-09-11 | false | true | 50 | 25 | |
10000145.interests.0 | 10000145 | ownership-of-shares-75-to-100-percent | shareholding | 2017-07-24 | false | false | 100 | 75 | |
10000146.interests.0 | 10000146 | ownership-of-shares-75-to-100-percent | shareholding | 2016-06-01 | false | false | 100 | 75 | |
10000146.interests.1 | 10000146 | voting-rights-75-to-100-percent | voting-rights | 2016-06-01 | false | false | 100 | 75 | |
10000146.interests.2 | 10000146 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-06-01 | |||||
10000147.interests.0 | 10000147 | ownership-of-shares-25-to-50-percent | shareholding | 2017-09-11 | false | true | 50 | 25 | 2021-07-30 |
10000147.interests.1 | 10000147 | voting-rights-25-to-50-percent | voting-rights | 2017-09-11 | false | true | 50 | 25 | 2021-07-30 |
10000148.interests.0 | 10000148 | ownership-of-shares-25-to-50-percent | shareholding | 2017-08-10 | false | true | 50 | 25 | |
10000148.interests.1 | 10000148 | voting-rights-25-to-50-percent | voting-rights | 2017-08-10 | false | true | 50 | 25 | |
10000149.interests.0 | 10000149 | ownership-of-shares-50-to-75-percent | shareholding | 2016-04-06 | true | true | 75 | 50 | |
1000015.interests.0 | 1000015 | right-to-appoint-and-remove-directors-as-firm | appointment-of-board | 2016-09-22 | |||||
10000150.interests.0 | 10000150 | ownership-of-shares-25-to-50-percent | shareholding | 2017-08-11 | false | true | 50 | 25 | |
10000150.interests.1 | 10000150 | voting-rights-25-to-50-percent | voting-rights | 2017-08-11 | false | true | 50 | 25 | |
10000151.interests.0 | 10000151 | ownership-of-shares-25-to-50-percent | shareholding | 2017-07-24 | false | true | 50 | 25 | |
10000151.interests.1 | 10000151 | ownership-of-shares-25-to-50-percent-as-trust | shareholding | 2017-07-24 | false | true | 50 | 25 | |
10000151.interests.2 | 10000151 | ownership-of-shares-25-to-50-percent-as-firm | shareholding | 2017-07-24 | false | true | 50 | 25 | |
10000151.interests.3 | 10000151 | voting-rights-25-to-50-percent | voting-rights | 2017-07-24 | false | true | 50 | 25 | |
10000151.interests.4 | 10000151 | voting-rights-25-to-50-percent-as-trust | voting-rights | 2017-07-24 | false | true | 50 | 25 | |
10000151.interests.5 | 10000151 | voting-rights-25-to-50-percent-as-firm | voting-rights | 2017-07-24 | false | true | 50 | 25 | |
10000151.interests.6 | 10000151 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-07-24 | |||||
10000151.interests.7 | 10000151 | significant-influence-or-control-as-firm | other-influence-or-control | 2017-07-24 | |||||
10000152.interests.0 | 10000152 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-06 | false | false | 100 | 75 | 2018-05-24 |
10000152.interests.1 | 10000152 | voting-rights-75-to-100-percent | voting-rights | 2016-04-06 | false | false | 100 | 75 | 2018-05-24 |
10000153.interests.0 | 10000153 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
10000153.interests.1 | 10000153 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
10000153.interests.2 | 10000153 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
10000154.interests.0 | 10000154 | ownership-of-shares-75-to-100-percent | shareholding | 2016-06-22 | false | false | 100 | 75 | 2017-01-01 |
10000154.interests.1 | 10000154 | voting-rights-75-to-100-percent | voting-rights | 2016-06-22 | false | false | 100 | 75 | 2017-01-01 |
10000154.interests.2 | 10000154 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-06-22 | 2017-01-01 | ||||
10000155.interests.0 | 10000155 | ownership-of-shares-75-to-100-percent | shareholding | 2017-06-07 | false | false | 100 | 75 | |
10000155.interests.1 | 10000155 | voting-rights-75-to-100-percent | voting-rights | 2017-06-07 | false | false | 100 | 75 | |
10000155.interests.2 | 10000155 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-06-07 | |||||
10000156.interests.0 | 10000156 | ownership-of-shares-25-to-50-percent | shareholding | 2017-09-11 | false | true | 50 | 25 | |
10000156.interests.1 | 10000156 | voting-rights-25-to-50-percent | voting-rights | 2017-09-11 | false | true | 50 | 25 | |
10000157.interests.0 | 10000157 | ownership-of-shares-75-to-100-percent | shareholding | 2017-07-24 | false | false | 100 | 75 | |
10000158.interests.0 | 10000158 | voting-rights-75-to-100-percent | voting-rights | 2017-08-23 | false | false | 100 | 75 | |
10000158.interests.1 | 10000158 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-23 | |||||
10000159.interests.0 | 10000159 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-02 | false | false | 100 | 75 | |
10000159.interests.1 | 10000159 | significant-influence-or-control-as-firm | other-influence-or-control | 2017-08-02 | |||||
1000016.interests.0 | 1000016 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-06 | false | false | 100 | 75 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [ooc_interests] ( [_link] TEXT , [_link_ooc_statement] TEXT , [details] TEXT , [type] TEXT , [startdate] TIMESTAMP , [share_exclusivemaximum] BOOL , [share_exclusiveminimum] BOOL , [share_maximum] NUMERIC , [share_minimum] NUMERIC , [enddate] TIMESTAMP , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );