ooc_interests
29,847,245 rows sorted by _link descending
This data as json, CSV (advanced)
Suggested facets: startdate (date)
These facets timed out: enddate
_link ▲ | _link_ooc_statement | details | type | startdate | share_exclusivemaximum | share_exclusiveminimum | share_maximum | share_minimum | enddate |
---|---|---|---|---|---|---|---|---|---|
9999999.interests.0 | 9999999 | ownership-of-shares-25-to-50-percent | shareholding | 2017-07-24 | false | true | 50 | 25 | |
9999998.interests.0 | 9999998 | significant-influence-or-control | other-influence-or-control | 2017-06-01 | |||||
9999997.interests.0 | 9999997 | significant-influence-or-control | other-influence-or-control | 2016-04-06 | 2020-04-30 | ||||
9999996.interests.1 | 9999996 | voting-rights-75-to-100-percent | voting-rights | 2016-06-26 | false | false | 100 | 75 | |
9999996.interests.0 | 9999996 | ownership-of-shares-75-to-100-percent | shareholding | 2016-06-26 | false | false | 100 | 75 | |
9999995.interests.0 | 9999995 | ownership-of-shares-75-to-100-percent | shareholding | 2017-07-14 | false | false | 100 | 75 | |
9999994.interests.0 | 9999994 | ownership-of-shares-25-to-50-percent | shareholding | 2017-07-24 | false | true | 50 | 25 | |
9999993.interests.0 | 9999993 | voting-rights-25-to-50-percent | voting-rights | 2017-09-11 | false | true | 50 | 25 | |
9999992.interests.2 | 9999992 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
9999992.interests.1 | 9999992 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
9999992.interests.0 | 9999992 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
9999991.interests.0 | 9999991 | significant-influence-or-control | other-influence-or-control | 2017-03-07 | |||||
9999990.interests.1 | 9999990 | voting-rights-25-to-50-percent | voting-rights | 2017-08-11 | false | true | 50 | 25 | |
9999990.interests.0 | 9999990 | ownership-of-shares-25-to-50-percent | shareholding | 2017-08-11 | false | true | 50 | 25 | |
999999.interests.0 | 999999 | significant-influence-or-control | other-influence-or-control | 2016-04-06 | |||||
9999989.interests.1 | 9999989 | voting-rights-25-to-50-percent | voting-rights | 2017-08-09 | false | true | 50 | 25 | |
9999989.interests.0 | 9999989 | ownership-of-shares-25-to-50-percent | shareholding | 2017-08-09 | false | true | 50 | 25 | |
9999988.interests.2 | 9999988 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-11 | |||||
9999988.interests.1 | 9999988 | voting-rights-75-to-100-percent | voting-rights | 2017-08-11 | false | false | 100 | 75 | |
9999988.interests.0 | 9999988 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-11 | false | false | 100 | 75 | |
9999987.interests.2 | 9999987 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-10 | |||||
9999987.interests.1 | 9999987 | voting-rights-75-to-100-percent | voting-rights | 2017-08-10 | false | false | 100 | 75 | |
9999987.interests.0 | 9999987 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-10 | false | false | 100 | 75 | |
9999986.interests.0 | 9999986 | significant-influence-or-control | other-influence-or-control | 2017-06-26 | |||||
9999985.interests.1 | 9999985 | voting-rights-75-to-100-percent | voting-rights | 2017-08-11 | false | false | 100 | 75 | |
9999985.interests.0 | 9999985 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-11 | false | false | 100 | 75 | |
9999984.interests.1 | 9999984 | voting-rights-25-to-50-percent | voting-rights | 2017-04-14 | false | true | 50 | 25 | 2022-06-10 |
9999984.interests.0 | 9999984 | ownership-of-shares-25-to-50-percent | shareholding | 2017-04-14 | false | true | 50 | 25 | 2022-06-10 |
9999983.interests.2 | 9999983 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | 2018-04-01 | ||||
9999983.interests.1 | 9999983 | voting-rights-25-to-50-percent | voting-rights | 2017-09-11 | false | true | 50 | 25 | 2018-04-01 |
9999983.interests.0 | 9999983 | ownership-of-shares-25-to-50-percent | shareholding | 2017-09-11 | false | true | 50 | 25 | 2018-04-01 |
9999982.interests.0 | 9999982 | significant-influence-or-control | other-influence-or-control | 2016-07-01 | |||||
9999981.interests.2 | 9999981 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
9999981.interests.1 | 9999981 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
9999981.interests.0 | 9999981 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
9999980.interests.1 | 9999980 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | 2018-08-31 | ||||
9999980.interests.0 | 9999980 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | 2018-08-31 |
999998.interests.2 | 999998 | right-to-appoint-and-remove-directors | appointment-of-board | 2018-03-05 | |||||
999998.interests.1 | 999998 | voting-rights-25-to-50-percent | voting-rights | 2018-03-05 | false | true | 50 | 25 | |
999998.interests.0 | 999998 | ownership-of-shares-25-to-50-percent | shareholding | 2018-03-05 | false | true | 50 | 25 | |
9999979.interests.2 | 9999979 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-04-06 | |||||
9999979.interests.1 | 9999979 | voting-rights-75-to-100-percent | voting-rights | 2016-04-06 | false | false | 100 | 75 | |
9999979.interests.0 | 9999979 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-06 | false | false | 100 | 75 | |
9999978.interests.0 | 9999978 | significant-influence-or-control | other-influence-or-control | 2016-08-01 | |||||
9999977.interests.2 | 9999977 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-11 | |||||
9999977.interests.1 | 9999977 | voting-rights-75-to-100-percent | voting-rights | 2017-08-11 | false | false | 100 | 75 | |
9999977.interests.0 | 9999977 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-11 | false | false | 100 | 75 | |
9999976.interests.0 | 9999976 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-20 | |||||
9999975.interests.2 | 9999975 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-07-24 | |||||
9999975.interests.1 | 9999975 | voting-rights-75-to-100-percent | voting-rights | 2017-07-24 | false | false | 100 | 75 | |
9999975.interests.0 | 9999975 | ownership-of-shares-75-to-100-percent | shareholding | 2017-07-24 | false | false | 100 | 75 | |
9999974.interests.9 | 9999974 | significant-influence-or-control-as-trust | other-influence-or-control | 2017-07-24 | |||||
9999974.interests.8 | 9999974 | right-to-appoint-and-remove-directors-as-firm | appointment-of-board | 2017-07-24 | |||||
9999974.interests.7 | 9999974 | right-to-appoint-and-remove-directors-as-trust | appointment-of-board | 2017-07-24 | |||||
9999974.interests.6 | 9999974 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-07-24 | |||||
9999974.interests.5 | 9999974 | voting-rights-25-to-50-percent-as-firm | voting-rights | 2017-07-24 | false | true | 50 | 25 | |
9999974.interests.4 | 9999974 | voting-rights-25-to-50-percent-as-trust | voting-rights | 2017-07-24 | false | true | 50 | 25 | |
9999974.interests.3 | 9999974 | voting-rights-25-to-50-percent | voting-rights | 2017-07-24 | false | true | 50 | 25 | |
9999974.interests.2 | 9999974 | ownership-of-shares-25-to-50-percent-as-firm | shareholding | 2017-07-24 | false | true | 50 | 25 | |
9999974.interests.10 | 9999974 | significant-influence-or-control-as-firm | other-influence-or-control | 2017-07-24 | |||||
9999974.interests.1 | 9999974 | ownership-of-shares-25-to-50-percent-as-trust | shareholding | 2017-07-24 | false | true | 50 | 25 | |
9999974.interests.0 | 9999974 | ownership-of-shares-25-to-50-percent | shareholding | 2017-07-24 | false | true | 50 | 25 | |
9999973.interests.0 | 9999973 | significant-influence-or-control | other-influence-or-control | 2017-05-25 | |||||
9999972.interests.0 | 9999972 | ownership-of-shares-75-to-100-percent-as-trust | shareholding | 2017-06-07 | false | false | 100 | 75 | |
9999971.interests.2 | 9999971 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-12 | 2017-10-25 | ||||
9999971.interests.1 | 9999971 | voting-rights-75-to-100-percent | voting-rights | 2017-09-12 | false | false | 100 | 75 | 2017-10-25 |
9999971.interests.0 | 9999971 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-12 | false | false | 100 | 75 | 2017-10-25 |
9999970.interests.2 | 9999970 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
9999970.interests.1 | 9999970 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
9999970.interests.0 | 9999970 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
999997.interests.1 | 999997 | voting-rights-75-to-100-percent | voting-rights | 2016-04-06 | false | false | 100 | 75 | |
999997.interests.0 | 999997 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-06 | false | false | 100 | 75 | |
9999969.interests.0 | 9999969 | significant-influence-or-control | other-influence-or-control | 2017-06-26 | |||||
9999968.interests.2 | 9999968 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-03 | |||||
9999968.interests.1 | 9999968 | voting-rights-75-to-100-percent | voting-rights | 2017-08-03 | false | false | 100 | 75 | |
9999968.interests.0 | 9999968 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-03 | false | false | 100 | 75 | |
9999967.interests.1 | 9999967 | voting-rights-75-to-100-percent | voting-rights | 2016-07-06 | false | false | 100 | 75 | 2017-07-28 |
9999967.interests.0 | 9999967 | ownership-of-shares-75-to-100-percent | shareholding | 2016-07-06 | false | false | 100 | 75 | 2017-07-28 |
9999966.interests.0 | 9999966 | significant-influence-or-control | other-influence-or-control | 2017-07-25 | 2022-03-28 | ||||
9999965.interests.0 | 9999965 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-01 | false | false | 100 | 75 | 2018-12-13 |
9999964.interests.0 | 9999964 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-06 | false | false | 100 | 75 | |
9999963.interests.1 | 9999963 | voting-rights-25-to-50-percent | voting-rights | 2017-08-11 | false | true | 50 | 25 | |
9999963.interests.0 | 9999963 | ownership-of-shares-25-to-50-percent | shareholding | 2017-08-11 | false | true | 50 | 25 | |
9999962.interests.0 | 9999962 | ownership-of-shares-75-to-100-percent | shareholding | 2017-07-24 | false | false | 100 | 75 | |
9999961.interests.0 | 9999961 | ownership-of-shares-50-to-75-percent | shareholding | 2017-07-24 | true | true | 75 | 50 | |
9999960.interests.2 | 9999960 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
9999960.interests.1 | 9999960 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
9999960.interests.0 | 9999960 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
999996.interests.2 | 999996 | right-to-appoint-and-remove-directors | appointment-of-board | 2016-04-06 | |||||
999996.interests.1 | 999996 | voting-rights-75-to-100-percent | voting-rights | 2016-04-06 | false | false | 100 | 75 | |
999996.interests.0 | 999996 | ownership-of-shares-75-to-100-percent | shareholding | 2016-04-06 | false | false | 100 | 75 | |
9999959.interests.2 | 9999959 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-09-11 | |||||
9999959.interests.1 | 9999959 | voting-rights-75-to-100-percent | voting-rights | 2017-09-11 | false | false | 100 | 75 | |
9999959.interests.0 | 9999959 | ownership-of-shares-75-to-100-percent | shareholding | 2017-09-11 | false | false | 100 | 75 | |
9999958.interests.2 | 9999958 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-08-11 | |||||
9999958.interests.1 | 9999958 | voting-rights-75-to-100-percent | voting-rights | 2017-08-11 | false | false | 100 | 75 | |
9999958.interests.0 | 9999958 | ownership-of-shares-75-to-100-percent | shareholding | 2017-08-11 | false | false | 100 | 75 | |
9999957.interests.2 | 9999957 | right-to-appoint-and-remove-directors | appointment-of-board | 2017-04-06 | |||||
9999957.interests.1 | 9999957 | voting-rights-75-to-100-percent | voting-rights | 2017-04-06 | false | false | 100 | 75 | |
9999957.interests.0 | 9999957 | ownership-of-shares-75-to-100-percent | shareholding | 2017-04-06 | false | false | 100 | 75 |
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]) );