ooc_interests
31,673,736 rows
This data as json, CSV (advanced)
_link ▼ | _link_ooc_statement | type | startdate | share_exact | share_maximum | share_minimum | enddate | details | share_exclusivemaximum | share_exclusiveminimum |
---|---|---|---|---|---|---|---|---|---|---|
10000135.interests.0 | 10000135 | shareholding | 2016-04-06 | 50 | 25 | 2018-04-09 | ownership-of-shares-25-to-50-percent | false | true | |
10000136.interests.0 | 10000136 | shareholding | 2016-06-01 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000136.interests.1 | 10000136 | voting-rights | 2016-06-01 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000136.interests.2 | 10000136 | appointment-of-board | 2016-06-01 | right-to-appoint-and-remove-directors | ||||||
10000137.interests.0 | 10000137 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000137.interests.1 | 10000137 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000138.interests.0 | 10000138 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000139.interests.0 | 10000139 | shareholding | 2016-04-06 | 50 | 25 | 2020-10-15 | ownership-of-shares-25-to-50-percent | false | true | |
1000014.interests.0 | 1000014 | shareholding | 2022-09-13 | 33.33 | 33.33 | 33.33 | ||||
1000014.interests.1 | 1000014 | voting-rights | 2022-09-13 | 33.33 | 33.33 | 33.33 | ||||
10000140.interests.0 | 10000140 | shareholding | 2017-04-24 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000141.interests.0 | 10000141 | shareholding | 2017-02-01 | 75 | 50 | ownership-of-shares-50-to-75-percent | true | true | ||
10000142.interests.0 | 10000142 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000143.interests.0 | 10000143 | shareholding | 2017-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000143.interests.1 | 10000143 | voting-rights | 2017-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000143.interests.2 | 10000143 | appointment-of-board | 2017-04-06 | right-to-appoint-and-remove-directors | ||||||
10000144.interests.0 | 10000144 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000144.interests.1 | 10000144 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent-as-firm | false | false | ||
10000145.interests.0 | 10000145 | shareholding | 2017-04-24 | 50 | 25 | 2018-12-21 | ownership-of-shares-25-to-50-percent | false | true | |
10000145.interests.1 | 10000145 | voting-rights | 2017-04-24 | 50 | 25 | 2018-12-21 | voting-rights-25-to-50-percent | false | true | |
10000146.interests.0 | 10000146 | shareholding | 2017-04-15 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000147.interests.0 | 10000147 | shareholding | 2017-03-16 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000148.interests.0 | 10000148 | shareholding | 2017-03-31 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000148.interests.1 | 10000148 | voting-rights | 2017-03-31 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000149.interests.0 | 10000149 | shareholding | 2016-04-06 | 100 | 75 | 2022-10-05 | ownership-of-shares-75-to-100-percent | false | false | |
1000015.interests.0 | 1000015 | shareholding | 2005-05-18 | 33.33 | 33.33 | 33.33 | ||||
1000015.interests.1 | 1000015 | voting-rights | 2005-05-18 | 66.66 | 66.66 | 66.66 | ||||
10000150.interests.0 | 10000150 | shareholding | 2017-04-24 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000151.interests.0 | 10000151 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000151.interests.1 | 10000151 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000152.interests.0 | 10000152 | shareholding | 2016-04-27 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000152.interests.1 | 10000152 | voting-rights | 2016-04-27 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000153.interests.0 | 10000153 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000153.interests.1 | 10000153 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000153.interests.2 | 10000153 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000154.interests.0 | 10000154 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000154.interests.1 | 10000154 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000154.interests.2 | 10000154 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000155.interests.0 | 10000155 | other-influence-or-control | 2017-04-24 | significant-influence-or-control | ||||||
10000156.interests.0 | 10000156 | shareholding | 2016-05-01 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000156.interests.1 | 10000156 | voting-rights | 2016-05-01 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000156.interests.2 | 10000156 | appointment-of-board | 2016-05-01 | right-to-appoint-and-remove-directors | ||||||
10000157.interests.0 | 10000157 | shareholding | 2016-07-01 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000158.interests.0 | 10000158 | shareholding | 2016-04-13 | 50 | 25 | 2018-01-26 | ownership-of-shares-25-to-50-percent | false | true | |
10000158.interests.1 | 10000158 | voting-rights | 2016-04-13 | 50 | 25 | 2018-01-26 | voting-rights-25-to-50-percent | false | true | |
10000159.interests.0 | 10000159 | shareholding | 2017-04-21 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000159.interests.1 | 10000159 | voting-rights | 2017-04-21 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
1000016.interests.0 | 1000016 | shareholding | 2020-11-20 | 100 | 100 | 100 | ||||
1000016.interests.1 | 1000016 | voting-rights | 2020-11-20 | 100 | 100 | 100 | ||||
10000160.interests.0 | 10000160 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000160.interests.1 | 10000160 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000160.interests.2 | 10000160 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000161.interests.0 | 10000161 | shareholding | 2017-03-31 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000162.interests.0 | 10000162 | voting-rights | 2017-04-24 | 75 | 50 | 2018-05-01 | voting-rights-50-to-75-percent | true | true | |
10000163.interests.0 | 10000163 | other-influence-or-control | 2016-04-30 | significant-influence-or-control | ||||||
10000164.interests.0 | 10000164 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000164.interests.1 | 10000164 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000165.interests.0 | 10000165 | shareholding | 2016-07-01 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000166.interests.0 | 10000166 | other-influence-or-control | 2016-04-06 | significant-influence-or-control | ||||||
10000167.interests.0 | 10000167 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000168.interests.0 | 10000168 | other-influence-or-control | 2016-04-06 | 2016-04-06 | significant-influence-or-control | |||||
10000169.interests.0 | 10000169 | other-influence-or-control | 2016-04-06 | significant-influence-or-control-limited-liability-partnership | ||||||
10000170.interests.0 | 10000170 | other-influence-or-control | 2016-04-09 | significant-influence-or-control | ||||||
10000171.interests.0 | 10000171 | shareholding | 2017-03-02 | 75 | 50 | ownership-of-shares-50-to-75-percent | true | true | ||
10000172.interests.0 | 10000172 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000172.interests.1 | 10000172 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000173.interests.0 | 10000173 | shareholding | 2016-04-07 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000173.interests.1 | 10000173 | voting-rights | 2016-04-07 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000174.interests.0 | 10000174 | shareholding | 2016-04-15 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000174.interests.1 | 10000174 | voting-rights | 2016-04-15 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000174.interests.2 | 10000174 | appointment-of-board | 2016-04-15 | right-to-appoint-and-remove-directors | ||||||
10000175.interests.0 | 10000175 | other-influence-or-control | 2016-04-06 | significant-influence-or-control | ||||||
10000176.interests.0 | 10000176 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000177.interests.0 | 10000177 | shareholding | 2016-04-06 | 75 | 50 | ownership-of-shares-50-to-75-percent | true | true | ||
10000177.interests.1 | 10000177 | shareholding | 2016-04-06 | 75 | 50 | ownership-of-shares-50-to-75-percent-as-trust | true | true | ||
10000177.interests.2 | 10000177 | shareholding | 2016-04-06 | 75 | 50 | ownership-of-shares-50-to-75-percent-as-firm | true | true | ||
10000177.interests.3 | 10000177 | voting-rights | 2016-04-06 | 75 | 50 | voting-rights-50-to-75-percent | true | true | ||
10000177.interests.4 | 10000177 | voting-rights | 2016-04-06 | 75 | 50 | voting-rights-50-to-75-percent-as-trust | true | true | ||
10000177.interests.5 | 10000177 | voting-rights | 2016-04-06 | 75 | 50 | voting-rights-50-to-75-percent-as-firm | true | true | ||
10000177.interests.6 | 10000177 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors-as-trust | ||||||
10000177.interests.7 | 10000177 | other-influence-or-control | 2016-04-06 | significant-influence-or-control-as-trust | ||||||
10000178.interests.0 | 10000178 | shareholding | 2016-04-06 | 50 | 25 | 2018-02-13 | ownership-of-shares-25-to-50-percent | false | true | |
10000178.interests.1 | 10000178 | voting-rights | 2016-04-06 | 50 | 25 | 2018-02-13 | voting-rights-25-to-50-percent | false | true | |
10000179.interests.0 | 10000179 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000179.interests.1 | 10000179 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
1000018.interests.0 | 1000018 | shareholding | 2022-11-14 | 100 | 100 | 100 | ||||
1000018.interests.1 | 1000018 | voting-rights | 2022-11-14 | 100 | 100 | 100 | ||||
10000180.interests.0 | 10000180 | shareholding | 2016-04-23 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000181.interests.0 | 10000181 | shareholding | 2017-04-18 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000182.interests.0 | 10000182 | shareholding | 2017-04-18 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000182.interests.1 | 10000182 | voting-rights | 2017-04-18 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000182.interests.2 | 10000182 | appointment-of-board | 2017-04-18 | right-to-appoint-and-remove-directors | ||||||
10000183.interests.0 | 10000183 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000184.interests.0 | 10000184 | shareholding | 2016-04-19 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000184.interests.1 | 10000184 | shareholding | 2016-04-19 | 100 | 75 | ownership-of-shares-75-to-100-percent-as-firm | false | false | ||
10000184.interests.2 | 10000184 | voting-rights | 2016-04-19 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000184.interests.3 | 10000184 | voting-rights | 2016-04-19 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
10000184.interests.4 | 10000184 | appointment-of-board | 2016-04-19 | right-to-appoint-and-remove-directors | ||||||
10000184.interests.5 | 10000184 | other-influence-or-control | 2016-04-19 | significant-influence-or-control-as-firm | ||||||
10000185.interests.0 | 10000185 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true |
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]) );