ooc_interests
31,673,736 rows
This data as json, CSV (advanced)
These facets timed out: enddate, startdate
_link ▼ | _link_ooc_statement | type | startdate | share_exact | share_maximum | share_minimum | enddate | details | share_exclusivemaximum | share_exclusiveminimum |
---|---|---|---|---|---|---|---|---|---|---|
10000042.interests.3 | 10000042 | voting-rights | 2017-04-18 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000042.interests.4 | 10000042 | voting-rights | 2017-04-18 | 100 | 75 | voting-rights-75-to-100-percent-as-trust | false | false | ||
10000042.interests.5 | 10000042 | voting-rights | 2017-04-18 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
10000042.interests.6 | 10000042 | appointment-of-board | 2017-04-18 | right-to-appoint-and-remove-directors | ||||||
10000042.interests.7 | 10000042 | appointment-of-board | 2017-04-18 | right-to-appoint-and-remove-directors-as-firm | ||||||
10000042.interests.8 | 10000042 | other-influence-or-control | 2017-04-18 | significant-influence-or-control-as-firm | ||||||
10000043.interests.0 | 10000043 | shareholding | 2017-04-01 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000044.interests.0 | 10000044 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000045.interests.0 | 10000045 | shareholding | 2017-04-27 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000045.interests.1 | 10000045 | voting-rights | 2017-04-27 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000045.interests.2 | 10000045 | appointment-of-board | 2017-04-27 | right-to-appoint-and-remove-directors | ||||||
10000046.interests.0 | 10000046 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000046.interests.1 | 10000046 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000047.interests.0 | 10000047 | shareholding | 2016-04-06 | 75 | 50 | ownership-of-shares-50-to-75-percent | true | true | ||
10000048.interests.0 | 10000048 | shareholding | 2017-04-01 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000049.interests.0 | 10000049 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000049.interests.1 | 10000049 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
1000005.interests.0 | 1000005 | shareholding | 2020-04-16 | 33.33 | 33.33 | 33.33 | ||||
1000005.interests.1 | 1000005 | voting-rights | 2020-04-16 | 33.33 | 33.33 | 33.33 | ||||
10000050.interests.0 | 10000050 | shareholding | 2016-04-07 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000051.interests.0 | 10000051 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000051.interests.1 | 10000051 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000051.interests.2 | 10000051 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000052.interests.0 | 10000052 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000053.interests.0 | 10000053 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000053.interests.1 | 10000053 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000053.interests.2 | 10000053 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000054.interests.0 | 10000054 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000054.interests.1 | 10000054 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000055.interests.0 | 10000055 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000055.interests.1 | 10000055 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000055.interests.2 | 10000055 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000056.interests.0 | 10000056 | shareholding | 2016-04-12 | 75 | 50 | ownership-of-shares-50-to-75-percent | true | true | ||
10000057.interests.0 | 10000057 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000057.interests.1 | 10000057 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000058.interests.0 | 10000058 | shareholding | 2016-04-06 | 75 | 50 | 2020-05-12 | ownership-of-shares-50-to-75-percent | true | true | |
10000058.interests.1 | 10000058 | voting-rights | 2016-04-06 | 75 | 50 | 2020-05-12 | voting-rights-50-to-75-percent | true | true | |
10000059.interests.0 | 10000059 | shareholding | 2016-06-01 | 50 | 25 | 2017-05-02 | ownership-of-shares-25-to-50-percent | false | true | |
10000059.interests.1 | 10000059 | voting-rights | 2016-06-01 | 50 | 25 | 2017-05-02 | voting-rights-25-to-50-percent | false | true | |
1000006.interests.0 | 1000006 | shareholding | 2022-04-25 | 100 | 100 | 100 | ||||
1000006.interests.1 | 1000006 | voting-rights | 2022-04-25 | 100 | 100 | 100 | ||||
10000060.interests.0 | 10000060 | shareholding | 2017-04-18 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000060.interests.1 | 10000060 | voting-rights | 2017-04-18 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000060.interests.2 | 10000060 | appointment-of-board | 2017-04-18 | right-to-appoint-and-remove-directors | ||||||
10000061.interests.0 | 10000061 | shareholding | 2017-04-10 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000062.interests.0 | 10000062 | shareholding | 2017-03-24 | 100 | 75 | 2017-10-11 | ownership-of-shares-75-to-100-percent | false | false | |
10000063.interests.0 | 10000063 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000064.interests.0 | 10000064 | other-influence-or-control | 2016-04-06 | significant-influence-or-control | ||||||
10000065.interests.0 | 10000065 | shareholding | 2017-05-02 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000066.interests.0 | 10000066 | shareholding | 2017-02-01 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000067.interests.0 | 10000067 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000067.interests.1 | 10000067 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000068.interests.0 | 10000068 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000069.interests.0 | 10000069 | shareholding | 2016-04-06 | 50 | 25 | 2021-10-24 | ownership-of-shares-25-to-50-percent | false | true | |
10000069.interests.1 | 10000069 | voting-rights | 2016-04-06 | 50 | 25 | 2021-10-24 | voting-rights-25-to-50-percent | false | true | |
10000069.interests.2 | 10000069 | appointment-of-board | 2016-04-06 | 2021-10-24 | right-to-appoint-and-remove-directors | |||||
1000007.interests.0 | 1000007 | shareholding | 2007-12-11 | 100 | 100 | 100 | ||||
1000007.interests.1 | 1000007 | voting-rights | 2007-12-11 | 100 | 100 | 100 | ||||
10000070.interests.0 | 10000070 | shareholding | 2017-05-02 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000070.interests.1 | 10000070 | voting-rights | 2017-05-02 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000070.interests.2 | 10000070 | appointment-of-board | 2017-05-02 | right-to-appoint-and-remove-directors | ||||||
10000071.interests.0 | 10000071 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000071.interests.1 | 10000071 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000071.interests.2 | 10000071 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000072.interests.0 | 10000072 | shareholding | 2017-04-24 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000073.interests.0 | 10000073 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000073.interests.1 | 10000073 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000074.interests.0 | 10000074 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent-limited-liability-partnership | false | true | ||
10000074.interests.1 | 10000074 | rights-to-surplus-assets-on-dissolution | 2016-04-06 | right-to-share-surplus-assets-25-to-50-percent-limited-liability-partnership | ||||||
10000075.interests.0 | 10000075 | shareholding | 2016-04-06 | 50 | 25 | 2018-08-30 | ownership-of-shares-25-to-50-percent | false | true | |
10000075.interests.1 | 10000075 | voting-rights | 2016-04-06 | 50 | 25 | 2018-08-30 | voting-rights-25-to-50-percent | false | true | |
10000076.interests.0 | 10000076 | shareholding | 2017-04-24 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000077.interests.0 | 10000077 | shareholding | 2016-04-22 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000077.interests.1 | 10000077 | voting-rights | 2016-04-22 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000078.interests.0 | 10000078 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000078.interests.1 | 10000078 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000079.interests.0 | 10000079 | shareholding | 2017-05-02 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
1000008.interests.0 | 1000008 | shareholding | 2005-10-01 | 33.33 | 33.33 | 33.33 | 2019-04-15 | |||
1000008.interests.1 | 1000008 | voting-rights | 2005-10-01 | 33.33 | 33.33 | 33.33 | 2019-04-15 | |||
10000080.interests.0 | 10000080 | shareholding | 2016-04-21 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000080.interests.1 | 10000080 | voting-rights | 2016-04-21 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000080.interests.2 | 10000080 | appointment-of-board | 2016-04-21 | right-to-appoint-and-remove-directors | ||||||
10000081.interests.0 | 10000081 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000082.interests.0 | 10000082 | shareholding | 2016-06-30 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000083.interests.0 | 10000083 | shareholding | 2017-04-24 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000084.interests.0 | 10000084 | other-influence-or-control | 2017-03-01 | significant-influence-or-control | ||||||
10000085.interests.0 | 10000085 | other-influence-or-control | 2017-04-08 | significant-influence-or-control | ||||||
10000086.interests.0 | 10000086 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000087.interests.0 | 10000087 | other-influence-or-control | 2017-04-14 | significant-influence-or-control | ||||||
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 |
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]) );