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 |
---|---|---|---|---|---|---|---|---|---|
10000035.interests.1 | 10000035 | right-to-share-surplus-assets-75-to-100-percent-limited-liability-partnership | rights-to-surplus-assets-on-dissolution | 2017-09-11 | |||||
10000036.interests.0 | 10000036 | ownership-of-shares-25-to-50-percent | shareholding | 2016-04-06 | false | true | 50 | 25 | |
10000037.interests.0 | 10000037 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-11 | false | false | 100 | 75 | |
10000037.interests.1 | 10000037 | voting-rights-75-to-100-percent | voting-rights | 2017-08-11 | false | false | 100 | 75 | |
10000037.interests.2 | 10000037 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-11 | |||||
10000038.interests.0 | 10000038 | ownership-of-shares-75-to-100-percent | shareholding | 2017-05-28 | false | false | 100 | 75 | |
10000038.interests.1 | 10000038 | voting-rights-75-to-100-percent | voting-rights | 2017-05-28 | false | false | 100 | 75 | |
10000038.interests.2 | 10000038 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-05-28 | |||||
10000039.interests.0 | 10000039 | ownership-of-shares-75-to-100-percent | shareholding | 2016-11-01 | false | false | 100 | 75 | |
10000039.interests.1 | 10000039 | voting-rights-75-to-100-percent | voting-rights | 2016-11-01 | false | false | 100 | 75 | |
10000039.interests.2 | 10000039 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-11-01 | |||||
1000004.interests.0 | 1000004 | significant-influence-or-control | other-influence-or-control | 2017-12-31 | |||||
1000004.interests.1 | 1000004 | significant-influence-or-control-as-firm | other-influence-or-control | 2017-12-31 | |||||
10000040.interests.0 | 10000040 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-06 | false | false | 100 | 75 | |
10000040.interests.1 | 10000040 | voting-rights-75-to-100-percent | voting-rights | 2016-04-06 | false | false | 100 | 75 | |
10000040.interests.2 | 10000040 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-04-06 | |||||
10000041.interests.0 | 10000041 | ownership-of-shares-25-to-50-percent | shareholding | 2017-09-11 | false | true | 50 | 25 | |
10000041.interests.1 | 10000041 | voting-rights-25-to-50-percent | voting-rights | 2017-09-11 | false | true | 50 | 25 | |
10000041.interests.2 | 10000041 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
10000042.interests.0 | 10000042 | ownership-of-shares-25-to-50-percent | shareholding | 2017-04-06 | false | true | 50 | 25 | |
10000042.interests.1 | 10000042 | voting-rights-25-to-50-percent | voting-rights | 2017-04-06 | false | true | 50 | 25 | |
10000042.interests.2 | 10000042 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-04-06 | |||||
10000042.interests.3 | 10000042 | right-to-appoint-and-remove-directors-as-trust | appointment-of-board | 2017-04-06 | |||||
10000042.interests.4 | 10000042 | right-to-appoint-and-remove-directors-as-firm | appointment-of-board | 2017-04-06 | |||||
10000043.interests.0 | 10000043 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
10000044.interests.0 | 10000044 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-07-24 | |||||
10000044.interests.1 | 10000044 | right-to-appoint-and-remove-directors-as-firm | appointment-of-board | 2017-07-24 | |||||
10000044.interests.2 | 10000044 | significant-influence-or-control-as-firm | other-influence-or-control | 2017-07-24 | |||||
10000045.interests.0 | 10000045 | voting-rights-25-to-50-percent-limited-liability-partnership | voting-rights | 2017-07-24 | false | true | 50 | 25 | 2018-06-26 |
10000045.interests.1 | 10000045 | right-to-share-surplus-assets-25-to-50-percent-limited-liability-partnership | rights-to-surplus-assets-on-dissolution | 2017-07-24 | 2018-06-26 | ||||
10000045.interests.2 | 10000045 | right-to-appoint-and-remove-members-limited-liability-partnership | appointment-of-board | 2017-07-24 | 2018-06-26 | ||||
10000046.interests.0 | 10000046 | ownership-of-shares-25-to-50-percent | shareholding | 2017-06-14 | false | true | 50 | 25 | |
10000047.interests.0 | 10000047 | ownership-of-shares-75-to-100-percent | shareholding | 2016-07-01 | false | false | 100 | 75 | |
10000047.interests.1 | 10000047 | voting-rights-75-to-100-percent | voting-rights | 2016-07-01 | false | false | 100 | 75 | |
10000047.interests.2 | 10000047 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-07-01 | |||||
10000048.interests.0 | 10000048 | ownership-of-shares-25-to-50-percent | shareholding | 2017-08-08 | false | true | 50 | 25 | |
10000049.interests.0 | 10000049 | ownership-of-shares-50-to-75-percent | shareholding | 2017-07-24 | true | true | 75 | 50 | |
10000049.interests.1 | 10000049 | voting-rights-50-to-75-percent | voting-rights | 2017-07-24 | true | true | 75 | 50 | |
1000005.interests.0 | 1000005 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-06 | false | false | 100 | 75 | |
10000050.interests.0 | 10000050 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
10000050.interests.1 | 10000050 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
10000050.interests.2 | 10000050 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
10000051.interests.0 | 10000051 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-11 | false | false | 100 | 75 | |
10000051.interests.1 | 10000051 | voting-rights-75-to-100-percent | voting-rights | 2017-08-11 | false | false | 100 | 75 | |
10000051.interests.2 | 10000051 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-11 | |||||
10000052.interests.0 | 10000052 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
10000052.interests.1 | 10000052 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
10000052.interests.2 | 10000052 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
10000052.interests.3 | 10000052 | right-to-appoint-and-remove-directors-as-trust | appointment-of-board | 2017-09-11 | |||||
10000052.interests.4 | 10000052 | right-to-appoint-and-remove-directors-as-firm | appointment-of-board | 2017-09-11 | |||||
10000053.interests.0 | 10000053 | ownership-of-shares-25-to-50-percent | shareholding | 2016-07-01 | false | true | 50 | 25 | |
10000054.interests.0 | 10000054 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
10000054.interests.1 | 10000054 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
10000054.interests.2 | 10000054 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
10000055.interests.0 | 10000055 | ownership-of-shares-25-to-50-percent-as-trust | shareholding | 2016-06-01 | false | true | 50 | 25 | |
10000055.interests.1 | 10000055 | voting-rights-25-to-50-percent-as-trust | voting-rights | 2016-06-01 | false | true | 50 | 25 | |
10000056.interests.0 | 10000056 | ownership-of-shares-25-to-50-percent | shareholding | 2016-06-29 | false | true | 50 | 25 | |
10000056.interests.1 | 10000056 | voting-rights-25-to-50-percent | voting-rights | 2016-06-29 | false | true | 50 | 25 | |
10000057.interests.0 | 10000057 | ownership-of-shares-50-to-75-percent | shareholding | 2016-04-06 | true | true | 75 | 50 | |
10000057.interests.1 | 10000057 | voting-rights-50-to-75-percent | voting-rights | 2016-04-06 | true | true | 75 | 50 | |
10000057.interests.2 | 10000057 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-04-06 | |||||
10000058.interests.0 | 10000058 | ownership-of-shares-25-to-50-percent | shareholding | 2017-08-04 | false | true | 50 | 25 | 2017-08-04 |
10000058.interests.1 | 10000058 | voting-rights-25-to-50-percent | voting-rights | 2017-08-04 | false | true | 50 | 25 | 2017-08-04 |
10000059.interests.0 | 10000059 | ownership-of-shares-25-to-50-percent | shareholding | 2016-07-01 | false | true | 50 | 25 | |
1000006.interests.0 | 1000006 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-06 | false | false | 100 | 75 | |
10000060.interests.0 | 10000060 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-25 | |||||
10000061.interests.0 | 10000061 | ownership-of-shares-75-to-100-percent | shareholding | 2016-06-09 | false | false | 100 | 75 | |
10000061.interests.1 | 10000061 | voting-rights-75-to-100-percent | voting-rights | 2016-06-09 | false | false | 100 | 75 | |
10000062.interests.0 | 10000062 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
10000062.interests.1 | 10000062 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
10000062.interests.2 | 10000062 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
10000063.interests.0 | 10000063 | ownership-of-shares-25-to-50-percent | shareholding | 2017-08-11 | false | true | 50 | 25 | 2019-09-06 |
10000064.interests.0 | 10000064 | significant-influence-or-control-as-trust | other-influence-or-control | 2016-04-06 | |||||
10000065.interests.0 | 10000065 | ownership-of-shares-25-to-50-percent | shareholding | 2017-09-11 | false | true | 50 | 25 | |
10000066.interests.0 | 10000066 | ownership-of-shares-75-to-100-percent | shareholding | 2017-07-24 | false | false | 100 | 75 | |
10000066.interests.1 | 10000066 | voting-rights-75-to-100-percent | voting-rights | 2017-07-24 | false | false | 100 | 75 | |
10000067.interests.0 | 10000067 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-11 | false | false | 100 | 75 | |
10000068.interests.0 | 10000068 | ownership-of-shares-75-to-100-percent | shareholding | 2017-07-18 | false | false | 100 | 75 | |
10000068.interests.1 | 10000068 | voting-rights-75-to-100-percent | voting-rights | 2017-07-18 | false | false | 100 | 75 | |
10000068.interests.2 | 10000068 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-07-18 | |||||
10000069.interests.0 | 10000069 | ownership-of-shares-25-to-50-percent | shareholding | 2017-06-30 | false | true | 50 | 25 | |
10000069.interests.1 | 10000069 | voting-rights-25-to-50-percent | voting-rights | 2017-06-30 | false | true | 50 | 25 | |
1000007.interests.0 | 1000007 | ownership-of-shares-25-to-50-percent | shareholding | 2016-10-07 | false | true | 50 | 25 | |
10000070.interests.0 | 10000070 | significant-influence-or-control | other-influence-or-control | 2017-07-24 | |||||
10000071.interests.0 | 10000071 | ownership-of-shares-75-to-100-percent | shareholding | 2016-06-17 | false | false | 100 | 75 | |
10000071.interests.1 | 10000071 | voting-rights-75-to-100-percent | voting-rights | 2016-06-17 | false | false | 100 | 75 | |
10000071.interests.2 | 10000071 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-06-17 | |||||
10000072.interests.0 | 10000072 | voting-rights-25-to-50-percent | voting-rights | 2017-07-24 | false | true | 50 | 25 | 2018-03-31 |
10000072.interests.1 | 10000072 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-07-24 | 2018-03-31 | ||||
10000073.interests.0 | 10000073 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-06 | false | false | 100 | 75 | |
10000073.interests.1 | 10000073 | voting-rights-75-to-100-percent | voting-rights | 2016-04-06 | false | false | 100 | 75 | |
10000073.interests.2 | 10000073 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-04-06 | |||||
10000074.interests.0 | 10000074 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-11 | false | false | 100 | 75 | |
10000074.interests.1 | 10000074 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-11 | |||||
10000075.interests.0 | 10000075 | significant-influence-or-control-limited-liability-partnership | other-influence-or-control | 2017-04-01 | |||||
10000075.interests.1 | 10000075 | significant-influence-or-control-as-trust-limited-liability-partnership | other-influence-or-control | 2017-04-01 | |||||
10000075.interests.2 | 10000075 | significant-influence-or-control-as-firm-limited-liability-partnership | other-influence-or-control | 2017-04-01 | |||||
10000076.interests.0 | 10000076 | ownership-of-shares-75-to-100-percent | shareholding | 2017-07-24 | false | false | 100 | 75 | |
10000076.interests.1 | 10000076 | voting-rights-75-to-100-percent | voting-rights | 2017-07-24 | false | false | 100 | 75 | |
10000076.interests.2 | 10000076 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-07-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]) );