ooc_interests
30,394,279 rows
This data as json, CSV (advanced)
Suggested facets: startdate (date)
These facets timed out: enddate
_link ▼ | _link_ooc_statement | type | startdate | share_exact | share_maximum | share_minimum | enddate | details | share_exclusivemaximum | share_exclusiveminimum |
---|---|---|---|---|---|---|---|---|---|---|
1.interests.0 | 1 | shareholding | 2022-10-28 | 100 | 100 | 100 | ||||
1.interests.1 | 1 | voting-rights | 2022-10-28 | 100 | 100 | 100 | ||||
10.interests.0 | 10 | shareholding | 2020-02-20 | 100 | 100 | 100 | ||||
10.interests.1 | 10 | voting-rights | 2020-02-20 | 100 | 100 | 100 | ||||
100.interests.0 | 100 | shareholding | 2007-03-15 | 100 | 100 | 100 | 2018-05-28 | |||
100.interests.1 | 100 | voting-rights | 2007-03-15 | 100 | 100 | 100 | 2018-05-28 | |||
100000.interests.0 | 100000 | shareholding | 2005-10-31 | 100 | 100 | 100 | ||||
100000.interests.1 | 100000 | voting-rights | 2005-10-31 | 100 | 100 | 100 | ||||
1000000.interests.0 | 1000000 | shareholding | 2016-04-24 | 100 | 100 | 100 | 2023-03-14 | |||
1000000.interests.1 | 1000000 | voting-rights | 2016-04-24 | 100 | 100 | 100 | 2023-03-14 | |||
10000000.interests.0 | 10000000 | shareholding | 2017-04-12 | 50 | 25 | 2022-02-16 | ownership-of-shares-25-to-50-percent | false | true | |
10000001.interests.0 | 10000001 | other-influence-or-control | 2017-04-25 | significant-influence-or-control | ||||||
10000002.interests.0 | 10000002 | shareholding | 2016-04-06 | 100 | 75 | 2016-04-06 | ownership-of-shares-75-to-100-percent | false | false | |
10000003.interests.0 | 10000003 | shareholding | 2016-06-30 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000003.interests.1 | 10000003 | voting-rights | 2016-06-30 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000004.interests.0 | 10000004 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000005.interests.0 | 10000005 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000005.interests.1 | 10000005 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000005.interests.2 | 10000005 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000006.interests.0 | 10000006 | shareholding | 2017-04-11 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000007.interests.0 | 10000007 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000007.interests.1 | 10000007 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000007.interests.2 | 10000007 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000008.interests.0 | 10000008 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000008.interests.1 | 10000008 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000008.interests.2 | 10000008 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000009.interests.0 | 10000009 | other-influence-or-control | 2016-04-28 | significant-influence-or-control | ||||||
1000001.interests.0 | 1000001 | shareholding | 2020-11-05 | 91.76 | 91.76 | 91.76 | ||||
1000001.interests.1 | 1000001 | voting-rights | 2020-11-05 | 91.76 | 91.76 | 91.76 | ||||
10000010.interests.0 | 10000010 | shareholding | 2016-07-01 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000010.interests.1 | 10000010 | voting-rights | 2016-07-01 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000011.interests.0 | 10000011 | voting-rights | 2016-06-01 | 50 | 25 | 2019-02-28 | voting-rights-25-to-50-percent-limited-liability-partnership | false | true | |
10000011.interests.1 | 10000011 | rights-to-surplus-assets-on-dissolution | 2016-06-01 | 2019-02-28 | right-to-share-surplus-assets-25-to-50-percent-limited-liability-partnership | |||||
10000012.interests.0 | 10000012 | shareholding | 2017-04-25 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000012.interests.1 | 10000012 | voting-rights | 2017-04-25 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000012.interests.2 | 10000012 | appointment-of-board | 2017-04-25 | right-to-appoint-and-remove-directors | ||||||
10000013.interests.0 | 10000013 | shareholding | 2017-05-02 | 100 | 75 | 2017-05-02 | ownership-of-shares-75-to-100-percent | false | false | |
10000013.interests.1 | 10000013 | appointment-of-board | 2017-05-02 | 2017-05-02 | right-to-appoint-and-remove-directors | |||||
10000014.interests.0 | 10000014 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000014.interests.1 | 10000014 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000015.interests.0 | 10000015 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000015.interests.1 | 10000015 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000016.interests.0 | 10000016 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000016.interests.1 | 10000016 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000016.interests.2 | 10000016 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000017.interests.0 | 10000017 | shareholding | 2016-07-01 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000017.interests.1 | 10000017 | voting-rights | 2016-07-01 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000017.interests.2 | 10000017 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
10000018.interests.0 | 10000018 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000019.interests.0 | 10000019 | other-influence-or-control | 2016-04-06 | significant-influence-or-control | ||||||
1000002.interests.0 | 1000002 | shareholding | 2018-08-13 | 100 | 100 | 100 | 2020-01-15 | |||
1000002.interests.1 | 1000002 | voting-rights | 2018-08-13 | 100 | 100 | 100 | 2020-01-15 | |||
10000020.interests.0 | 10000020 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000020.interests.1 | 10000020 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000021.interests.0 | 10000021 | other-influence-or-control | 2016-04-06 | significant-influence-or-control | ||||||
10000022.interests.0 | 10000022 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000022.interests.1 | 10000022 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000023.interests.0 | 10000023 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000023.interests.1 | 10000023 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000024.interests.0 | 10000024 | shareholding | 2016-07-01 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000025.interests.0 | 10000025 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000026.interests.0 | 10000026 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000026.interests.1 | 10000026 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000026.interests.2 | 10000026 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000027.interests.0 | 10000027 | other-influence-or-control | 2016-04-06 | 2018-08-21 | significant-influence-or-control | |||||
10000028.interests.0 | 10000028 | shareholding | 2017-04-26 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000028.interests.1 | 10000028 | voting-rights | 2017-04-26 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000029.interests.0 | 10000029 | voting-rights | 2016-04-06 | 50 | 25 | voting-rights-25-to-50-percent-limited-liability-partnership | false | true | ||
10000029.interests.1 | 10000029 | rights-to-surplus-assets-on-dissolution | 2016-04-06 | right-to-share-surplus-assets-25-to-50-percent-limited-liability-partnership | ||||||
1000003.interests.0 | 1000003 | shareholding | 2021-11-03 | 21.31 | 21.31 | 21.31 | ||||
1000003.interests.1 | 1000003 | voting-rights | 2021-11-03 | 21.31 | 21.31 | 21.31 | ||||
10000030.interests.0 | 10000030 | shareholding | 2017-03-01 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000030.interests.1 | 10000030 | voting-rights | 2017-03-01 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000031.interests.0 | 10000031 | shareholding | 2017-04-10 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000031.interests.1 | 10000031 | voting-rights | 2017-04-10 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000031.interests.2 | 10000031 | appointment-of-board | 2017-04-10 | right-to-appoint-and-remove-directors | ||||||
10000032.interests.0 | 10000032 | shareholding | 2017-05-02 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000032.interests.1 | 10000032 | voting-rights | 2017-05-02 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000032.interests.2 | 10000032 | appointment-of-board | 2017-05-02 | right-to-appoint-and-remove-directors | ||||||
10000033.interests.0 | 10000033 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000034.interests.0 | 10000034 | shareholding | 2017-04-25 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000034.interests.1 | 10000034 | voting-rights | 2017-04-25 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000034.interests.2 | 10000034 | appointment-of-board | 2017-04-25 | right-to-appoint-and-remove-directors | ||||||
10000035.interests.0 | 10000035 | shareholding | 2016-04-06 | 75 | 50 | ownership-of-shares-50-to-75-percent | true | true | ||
10000035.interests.1 | 10000035 | voting-rights | 2016-04-06 | 75 | 50 | voting-rights-50-to-75-percent | true | true | ||
10000036.interests.0 | 10000036 | shareholding | 2016-11-21 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000037.interests.0 | 10000037 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000037.interests.1 | 10000037 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000037.interests.2 | 10000037 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000038.interests.0 | 10000038 | shareholding | 2017-04-29 | 75 | 50 | ownership-of-shares-50-to-75-percent | true | true | ||
10000039.interests.0 | 10000039 | other-influence-or-control | 2016-04-06 | significant-influence-or-control | ||||||
1000004.interests.0 | 1000004 | shareholding | 2008-09-17 | 50 | 50 | 50 | ||||
1000004.interests.1 | 1000004 | voting-rights | 2008-09-17 | 50 | 50 | 50 | ||||
10000040.interests.0 | 10000040 | shareholding | 2016-04-06 | 100 | 75 | ownership-of-shares-75-to-100-percent | false | false | ||
10000040.interests.1 | 10000040 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
10000040.interests.2 | 10000040 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
10000041.interests.0 | 10000041 | shareholding | 2016-04-06 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000042.interests.0 | 10000042 | shareholding | 2017-04-14 | 50 | 25 | ownership-of-shares-25-to-50-percent | false | true | ||
10000042.interests.1 | 10000042 | voting-rights | 2017-04-14 | 50 | 25 | voting-rights-25-to-50-percent | false | true | ||
10000042.interests.2 | 10000042 | appointment-of-board | 2017-04-14 | right-to-appoint-and-remove-directors |
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]) );