ooc_interests
29,847,245 rows
This data as json, CSV (advanced)
_link ▼ | _link_ooc_statement | details | type | startdate | share_exclusivemaximum | share_exclusiveminimum | share_maximum | share_minimum | enddate |
---|---|---|---|---|---|---|---|---|---|
10000077.interests.0 | 10000077 | ownership-of-shares-25-to-50-percent | shareholding | 2017-08-11 | false | true | 50 | 25 | |
10000077.interests.1 | 10000077 | voting-rights-25-to-50-percent | voting-rights | 2017-08-11 | false | true | 50 | 25 | |
10000078.interests.0 | 10000078 | voting-rights-25-to-50-percent-limited-liability-partnership | voting-rights | 2016-07-25 | false | true | 50 | 25 | 2016-07-25 |
10000078.interests.1 | 10000078 | right-to-share-surplus-assets-25-to-50-percent-limited-liability-partnership | rights-to-surplus-assets-on-dissolution | 2016-07-25 | 2016-07-25 | ||||
10000079.interests.0 | 10000079 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-06 | false | false | 100 | 75 | 2020-03-13 |
10000079.interests.1 | 10000079 | voting-rights-75-to-100-percent | voting-rights | 2016-04-06 | false | false | 100 | 75 | 2020-03-13 |
10000079.interests.2 | 10000079 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-04-06 | 2020-03-13 | ||||
1000008.interests.0 | 1000008 | ownership-of-shares-25-to-50-percent | shareholding | 2018-01-02 | false | true | 50 | 25 | |
10000080.interests.0 | 10000080 | ownership-of-shares-25-to-50-percent | shareholding | 2016-04-06 | false | true | 50 | 25 | |
10000080.interests.1 | 10000080 | voting-rights-25-to-50-percent | voting-rights | 2016-04-06 | false | true | 50 | 25 | |
10000081.interests.0 | 10000081 | ownership-of-shares-75-to-100-percent | shareholding | 2017-07-24 | false | false | 100 | 75 | |
10000082.interests.0 | 10000082 | ownership-of-shares-75-to-100-percent | shareholding | 2016-06-07 | false | false | 100 | 75 | 2018-10-15 |
10000083.interests.0 | 10000083 | ownership-of-shares-75-to-100-percent-as-firm | shareholding | 2016-07-01 | false | false | 100 | 75 | |
10000083.interests.1 | 10000083 | voting-rights-75-to-100-percent-as-firm | voting-rights | 2016-07-01 | false | false | 100 | 75 | |
10000083.interests.2 | 10000083 | right-to-appoint-and-remove-directors-as-firm | appointment-of-board | 2016-07-01 | |||||
10000084.interests.0 | 10000084 | ownership-of-shares-75-to-100-percent-as-firm | shareholding | 2017-09-12 | false | false | 100 | 75 | |
10000085.interests.0 | 10000085 | significant-influence-or-control | other-influence-or-control | 2017-07-28 | |||||
10000086.interests.0 | 10000086 | ownership-of-shares-75-to-100-percent | shareholding | 2016-09-05 | false | false | 100 | 75 | |
10000087.interests.0 | 10000087 | ownership-of-shares-75-to-100-percent | shareholding | 2017-07-24 | false | false | 100 | 75 | |
10000087.interests.1 | 10000087 | voting-rights-75-to-100-percent | voting-rights | 2017-07-24 | false | false | 100 | 75 | |
10000087.interests.2 | 10000087 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-07-24 | |||||
10000088.interests.0 | 10000088 | ownership-of-shares-25-to-50-percent | shareholding | 2017-07-21 | false | true | 50 | 25 | |
10000088.interests.1 | 10000088 | voting-rights-25-to-50-percent | voting-rights | 2017-07-21 | false | true | 50 | 25 | |
10000089.interests.0 | 10000089 | significant-influence-or-control | other-influence-or-control | 2017-09-12 | |||||
1000009.interests.0 | 1000009 | ownership-of-shares-75-to-100-percent | shareholding | 2016-09-29 | false | false | 100 | 75 | |
10000090.interests.0 | 10000090 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-11 | false | false | 100 | 75 | |
10000090.interests.1 | 10000090 | voting-rights-75-to-100-percent | voting-rights | 2017-08-11 | false | false | 100 | 75 | |
10000090.interests.2 | 10000090 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-11 | |||||
10000091.interests.0 | 10000091 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
10000092.interests.0 | 10000092 | ownership-of-shares-25-to-50-percent | shareholding | 2017-04-06 | false | true | 50 | 25 | 2017-04-06 |
10000092.interests.1 | 10000092 | voting-rights-25-to-50-percent | voting-rights | 2017-04-06 | false | true | 50 | 25 | 2017-04-06 |
10000093.interests.0 | 10000093 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-12 | false | false | 100 | 75 | |
10000094.interests.0 | 10000094 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
10000094.interests.1 | 10000094 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
10000094.interests.2 | 10000094 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
10000095.interests.0 | 10000095 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-12 | false | false | 100 | 75 | 2017-09-12 |
10000096.interests.0 | 10000096 | ownership-of-shares-25-to-50-percent | shareholding | 2016-04-06 | false | true | 50 | 25 | |
10000097.interests.0 | 10000097 | ownership-of-shares-25-to-50-percent | shareholding | 2017-09-12 | false | true | 50 | 25 | |
10000097.interests.1 | 10000097 | voting-rights-25-to-50-percent | voting-rights | 2017-09-12 | false | true | 50 | 25 | |
10000098.interests.0 | 10000098 | ownership-of-shares-25-to-50-percent | shareholding | 2016-09-15 | false | true | 50 | 25 | |
10000099.interests.0 | 10000099 | ownership-of-shares-75-to-100-percent | shareholding | 2017-07-07 | false | false | 100 | 75 | |
10000099.interests.1 | 10000099 | voting-rights-75-to-100-percent | voting-rights | 2017-07-07 | false | false | 100 | 75 | |
10000099.interests.2 | 10000099 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-07-07 | |||||
100001.interests.0 | 100001 | significant-influence-or-control-as-trust | other-influence-or-control | 2016-04-06 | |||||
1000010.interests.0 | 1000010 | ownership-of-shares-50-to-75-percent | shareholding | 2016-10-01 | true | true | 75 | 50 | |
1000010.interests.1 | 1000010 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-10-01 | |||||
10000100.interests.0 | 10000100 | ownership-of-shares-75-to-100-percent | shareholding | 2017-06-01 | false | false | 100 | 75 | |
10000101.interests.0 | 10000101 | ownership-of-shares-75-to-100-percent | shareholding | 2016-06-17 | false | false | 100 | 75 | |
10000102.interests.0 | 10000102 | ownership-of-shares-25-to-50-percent | shareholding | 2017-09-11 | false | true | 50 | 25 | |
10000102.interests.1 | 10000102 | voting-rights-25-to-50-percent | voting-rights | 2017-09-11 | false | true | 50 | 25 | |
10000102.interests.2 | 10000102 | voting-rights-25-to-50-percent-as-trust | voting-rights | 2017-09-11 | false | true | 50 | 25 | |
10000102.interests.3 | 10000102 | voting-rights-25-to-50-percent-as-firm | voting-rights | 2017-09-11 | false | true | 50 | 25 | |
10000102.interests.4 | 10000102 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
10000103.interests.0 | 10000103 | ownership-of-shares-75-to-100-percent | shareholding | 2016-05-20 | false | false | 100 | 75 | |
10000103.interests.1 | 10000103 | voting-rights-75-to-100-percent | voting-rights | 2016-05-20 | false | false | 100 | 75 | |
10000103.interests.2 | 10000103 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-05-20 | |||||
10000104.interests.0 | 10000104 | significant-influence-or-control | other-influence-or-control | 2016-04-06 | |||||
10000105.interests.0 | 10000105 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
10000105.interests.1 | 10000105 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
10000105.interests.2 | 10000105 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
10000106.interests.0 | 10000106 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-12 | false | false | 100 | 75 | |
10000106.interests.1 | 10000106 | voting-rights-75-to-100-percent | voting-rights | 2017-09-12 | false | false | 100 | 75 | |
10000106.interests.2 | 10000106 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-12 | |||||
10000107.interests.0 | 10000107 | ownership-of-shares-25-to-50-percent | shareholding | 2017-07-24 | false | true | 50 | 25 | |
10000107.interests.1 | 10000107 | voting-rights-25-to-50-percent | voting-rights | 2017-07-24 | false | true | 50 | 25 | |
10000107.interests.2 | 10000107 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-07-24 | |||||
10000108.interests.0 | 10000108 | significant-influence-or-control | other-influence-or-control | 2017-09-12 | 2017-10-12 | ||||
10000109.interests.0 | 10000109 | ownership-of-shares-25-to-50-percent | shareholding | 2016-04-06 | false | true | 50 | 25 | |
1000011.interests.0 | 1000011 | ownership-of-shares-25-to-50-percent | shareholding | 2016-04-06 | false | true | 50 | 25 | |
10000110.interests.0 | 10000110 | ownership-of-shares-25-to-50-percent | shareholding | 2017-08-10 | false | true | 50 | 25 | |
10000111.interests.0 | 10000111 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
10000111.interests.1 | 10000111 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
10000112.interests.0 | 10000112 | ownership-of-shares-75-to-100-percent | shareholding | 2016-09-11 | false | false | 100 | 75 | |
10000112.interests.1 | 10000112 | voting-rights-75-to-100-percent | voting-rights | 2016-09-11 | false | false | 100 | 75 | |
10000112.interests.2 | 10000112 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-09-11 | |||||
10000113.interests.0 | 10000113 | ownership-of-shares-25-to-50-percent | shareholding | 2016-06-16 | false | true | 50 | 25 | |
10000114.interests.0 | 10000114 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-29 | false | false | 100 | 75 | |
10000115.interests.0 | 10000115 | ownership-of-shares-25-to-50-percent | shareholding | 2017-07-24 | false | true | 50 | 25 | |
10000115.interests.1 | 10000115 | voting-rights-25-to-50-percent | voting-rights | 2017-07-24 | false | true | 50 | 25 | |
10000116.interests.0 | 10000116 | ownership-of-shares-25-to-50-percent | shareholding | 2016-05-31 | false | true | 50 | 25 | |
10000117.interests.0 | 10000117 | ownership-of-shares-25-to-50-percent | shareholding | 2017-09-12 | false | true | 50 | 25 | 2017-09-28 |
10000117.interests.1 | 10000117 | voting-rights-25-to-50-percent | voting-rights | 2017-09-12 | false | true | 50 | 25 | 2017-09-28 |
10000117.interests.2 | 10000117 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-12 | 2017-09-28 | ||||
10000118.interests.0 | 10000118 | significant-influence-or-control | other-influence-or-control | 2017-08-11 | |||||
10000119.interests.0 | 10000119 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
10000119.interests.1 | 10000119 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
10000119.interests.2 | 10000119 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
1000012.interests.0 | 1000012 | ownership-of-shares-25-to-50-percent | shareholding | 2016-10-01 | false | true | 50 | 25 | |
1000012.interests.1 | 1000012 | ownership-of-shares-25-to-50-percent-as-trust | shareholding | 2016-10-01 | false | true | 50 | 25 | |
1000012.interests.2 | 1000012 | ownership-of-shares-25-to-50-percent-as-firm | shareholding | 2016-10-01 | false | true | 50 | 25 | |
1000012.interests.3 | 1000012 | voting-rights-25-to-50-percent | voting-rights | 2016-10-01 | false | true | 50 | 25 | |
1000012.interests.4 | 1000012 | voting-rights-25-to-50-percent-as-trust | voting-rights | 2016-10-01 | false | true | 50 | 25 | |
1000012.interests.5 | 1000012 | voting-rights-25-to-50-percent-as-firm | voting-rights | 2016-10-01 | false | true | 50 | 25 | |
1000012.interests.6 | 1000012 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-10-01 | |||||
1000012.interests.7 | 1000012 | significant-influence-or-control | other-influence-or-control | 2016-10-01 | |||||
10000120.interests.0 | 10000120 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
10000120.interests.1 | 10000120 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
10000121.interests.0 | 10000121 | ownership-of-shares-25-to-50-percent | shareholding | 2016-06-30 | false | true | 50 | 25 | 2016-06-30 |
10000122.interests.0 | 10000122 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-05-24 | |||||
10000122.interests.1 | 10000122 | right-to-appoint-and-remove-directors-as-firm | appointment-of-board | 2016-05-24 |
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]) );