ooc_interests
1,324,489 rows sorted by share_maximum descending
This data as json, CSV (advanced)
Suggested facets: enddate (date), startdate (date)
_link | _link_ooc_statement | type | enddate | startdate | share_exact | share_maximum ▲ | share_minimum | details | share_exclusiveminimum | share_exclusivemaximum |
---|---|---|---|---|---|---|---|---|---|---|
742690.interests.0 | 742690 | other-influence-or-control | 2016-04-06 | significant-influence-or-control | ||||||
742702.interests.0 | 742702 | appointment-of-board | 2016-04-10 | right-to-appoint-and-remove-directors | ||||||
742702.interests.1 | 742702 | appointment-of-board | 2016-04-10 | right-to-appoint-and-remove-directors-as-trust | ||||||
742702.interests.2 | 742702 | appointment-of-board | 2016-04-10 | right-to-appoint-and-remove-directors-as-firm | ||||||
742704.interests.0 | 742704 | other-influence-or-control | 2022-10-03 | 2016-06-30 | significant-influence-or-control | |||||
742768.interests.0 | 742768 | other-influence-or-control | 2021-12-01 | 2016-07-01 | significant-influence-or-control | |||||
742785.interests.0 | 742785 | other-influence-or-control | 2021-12-01 | 2016-07-01 | significant-influence-or-control | |||||
742789.interests.0 | 742789 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
742789.interests.1 | 742789 | other-influence-or-control | 2016-07-01 | significant-influence-or-control | ||||||
742808.interests.0 | 742808 | other-influence-or-control | 2016-06-22 | significant-influence-or-control | ||||||
742808.interests.1 | 742808 | other-influence-or-control | 2016-06-22 | significant-influence-or-control-as-trust | ||||||
742808.interests.2 | 742808 | other-influence-or-control | 2016-06-22 | significant-influence-or-control-as-firm | ||||||
742809.interests.2 | 742809 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
742937.interests.0 | 742937 | other-influence-or-control | 2016-07-01 | significant-influence-or-control | ||||||
742947.interests.0 | 742947 | other-influence-or-control | 2016-07-03 | significant-influence-or-control | ||||||
742947.interests.1 | 742947 | other-influence-or-control | 2016-07-03 | significant-influence-or-control-as-trust | ||||||
742947.interests.2 | 742947 | other-influence-or-control | 2016-07-03 | significant-influence-or-control-as-firm | ||||||
742953.interests.2 | 742953 | appointment-of-board | 2016-07-04 | right-to-appoint-and-remove-directors | ||||||
742953.interests.3 | 742953 | other-influence-or-control | 2016-07-04 | significant-influence-or-control | ||||||
742998.interests.2 | 742998 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
743010.interests.2 | 743010 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
743031.interests.2 | 743031 | other-influence-or-control | 2016-04-06 | significant-influence-or-control | ||||||
743033.interests.2 | 743033 | appointment-of-board | 2016-07-03 | right-to-appoint-and-remove-directors | ||||||
743068.interests.2 | 743068 | appointment-of-board | 2016-07-04 | right-to-appoint-and-remove-directors | ||||||
743068.interests.3 | 743068 | other-influence-or-control | 2016-07-04 | significant-influence-or-control | ||||||
743095.interests.2 | 743095 | appointment-of-board | 2016-07-04 | right-to-appoint-and-remove-directors | ||||||
743130.interests.0 | 743130 | other-influence-or-control | 2021-11-30 | 2016-06-27 | significant-influence-or-control | |||||
743130.interests.1 | 743130 | other-influence-or-control | 2021-11-30 | 2016-06-27 | significant-influence-or-control-as-firm | |||||
743132.interests.0 | 743132 | other-influence-or-control | 2016-06-27 | significant-influence-or-control | ||||||
743133.interests.2 | 743133 | other-influence-or-control | 2022-10-10 | 2016-07-04 | significant-influence-or-control | |||||
743135.interests.2 | 743135 | other-influence-or-control | 2022-10-10 | 2016-07-04 | significant-influence-or-control | |||||
743139.interests.2 | 743139 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
743159.interests.0 | 743159 | other-influence-or-control | 2016-12-22 | 2016-07-04 | significant-influence-or-control | |||||
743177.interests.0 | 743177 | other-influence-or-control | 2022-10-26 | 2016-07-05 | significant-influence-or-control | |||||
743181.interests.2 | 743181 | appointment-of-board | 2016-07-05 | right-to-appoint-and-remove-directors | ||||||
743260.interests.2 | 743260 | appointment-of-board | 2022-10-25 | 2016-05-01 | right-to-appoint-and-remove-directors | |||||
743262.interests.2 | 743262 | appointment-of-board | 2022-09-17 | 2016-07-05 | right-to-appoint-and-remove-directors | |||||
743313.interests.0 | 743313 | appointment-of-board | 2022-10-24 | 2016-04-06 | right-to-appoint-and-remove-directors-as-trust | |||||
743313.interests.1 | 743313 | other-influence-or-control | 2022-10-24 | 2016-04-06 | significant-influence-or-control-as-trust | |||||
743316.interests.2 | 743316 | appointment-of-board | 2016-07-05 | right-to-appoint-and-remove-directors | ||||||
743316.interests.3 | 743316 | other-influence-or-control | 2016-07-05 | significant-influence-or-control | ||||||
743341.interests.2 | 743341 | appointment-of-board | 2016-06-30 | right-to-appoint-and-remove-directors | ||||||
743417.interests.2 | 743417 | appointment-of-board | 2016-07-06 | right-to-appoint-and-remove-directors | ||||||
743417.interests.3 | 743417 | other-influence-or-control | 2016-07-06 | significant-influence-or-control | ||||||
743418.interests.0 | 743418 | other-influence-or-control | 2022-09-13 | 2016-04-06 | significant-influence-or-control | |||||
743421.interests.1 | 743421 | rights-to-surplus-assets-on-dissolution | 2016-06-01 | right-to-share-surplus-assets-75-to-100-percent-limited-liability-partnership | ||||||
743423.interests.0 | 743423 | other-influence-or-control | 2022-09-13 | 2016-04-06 | significant-influence-or-control | |||||
743431.interests.2 | 743431 | appointment-of-board | 2016-07-06 | right-to-appoint-and-remove-directors | ||||||
743449.interests.2 | 743449 | appointment-of-board | 2016-07-06 | right-to-appoint-and-remove-directors | ||||||
743468.interests.3 | 743468 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
743468.interests.4 | 743468 | other-influence-or-control | 2016-07-01 | significant-influence-or-control | ||||||
743471.interests.6 | 743471 | appointment-of-board | 2016-07-06 | right-to-appoint-and-remove-directors | ||||||
743471.interests.7 | 743471 | other-influence-or-control | 2016-07-06 | significant-influence-or-control-as-firm | ||||||
743472.interests.0 | 743472 | other-influence-or-control | 2016-07-06 | significant-influence-or-control | ||||||
743487.interests.2 | 743487 | other-influence-or-control | 2016-04-06 | significant-influence-or-control | ||||||
743488.interests.1 | 743488 | other-influence-or-control | 2018-08-16 | 2016-04-07 | significant-influence-or-control | |||||
743495.interests.2 | 743495 | appointment-of-board | 2022-08-12 | 2016-07-01 | right-to-appoint-and-remove-directors | |||||
743495.interests.3 | 743495 | other-influence-or-control | 2022-08-12 | 2016-07-01 | significant-influence-or-control | |||||
743496.interests.2 | 743496 | appointment-of-board | 2022-08-12 | 2016-07-01 | right-to-appoint-and-remove-directors | |||||
743496.interests.3 | 743496 | other-influence-or-control | 2022-08-12 | 2016-07-01 | significant-influence-or-control | |||||
743504.interests.2 | 743504 | appointment-of-board | 2016-06-11 | right-to-appoint-and-remove-directors | ||||||
743504.interests.3 | 743504 | other-influence-or-control | 2016-06-11 | significant-influence-or-control | ||||||
743634.interests.2 | 743634 | appointment-of-board | 2016-07-07 | right-to-appoint-and-remove-directors | ||||||
743634.interests.3 | 743634 | other-influence-or-control | 2016-07-07 | significant-influence-or-control | ||||||
743655.interests.2 | 743655 | other-influence-or-control | 2022-10-15 | 2016-07-07 | significant-influence-or-control | |||||
743659.interests.0 | 743659 | other-influence-or-control | 2022-10-04 | 2016-04-06 | significant-influence-or-control-as-trust | |||||
743696.interests.6 | 743696 | appointment-of-board | 2016-07-07 | right-to-appoint-and-remove-directors | ||||||
743696.interests.7 | 743696 | other-influence-or-control | 2016-07-07 | significant-influence-or-control | ||||||
743697.interests.0 | 743697 | other-influence-or-control | 2016-07-06 | significant-influence-or-control | ||||||
743704.interests.0 | 743704 | other-influence-or-control | 2016-07-07 | significant-influence-or-control | ||||||
743797.interests.0 | 743797 | other-influence-or-control | 2016-07-07 | significant-influence-or-control-as-firm | ||||||
743825.interests.2 | 743825 | appointment-of-board | 2016-07-07 | right-to-appoint-and-remove-directors | ||||||
743839.interests.0 | 743839 | other-influence-or-control | 2016-04-06 | significant-influence-or-control-as-firm | ||||||
743876.interests.2 | 743876 | other-influence-or-control | 2016-06-30 | significant-influence-or-control | ||||||
743898.interests.2 | 743898 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors-as-firm | ||||||
743898.interests.3 | 743898 | other-influence-or-control | 2016-07-01 | significant-influence-or-control | ||||||
743900.interests.0 | 743900 | other-influence-or-control | 2016-07-01 | significant-influence-or-control | ||||||
743901.interests.0 | 743901 | other-influence-or-control | 2022-09-15 | 2016-04-06 | significant-influence-or-control | |||||
743908.interests.2 | 743908 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
743911.interests.2 | 743911 | appointment-of-board | 2022-10-28 | 2016-04-06 | right-to-appoint-and-remove-directors | |||||
743911.interests.3 | 743911 | appointment-of-board | 2022-10-28 | 2016-04-06 | right-to-appoint-and-remove-directors-as-firm | |||||
744028.interests.2 | 744028 | appointment-of-board | 2016-07-08 | right-to-appoint-and-remove-directors | ||||||
744068.interests.2 | 744068 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
744075.interests.2 | 744075 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
744075.interests.3 | 744075 | other-influence-or-control | 2016-04-06 | significant-influence-or-control | ||||||
744118.interests.0 | 744118 | other-influence-or-control | 2022-10-29 | 2016-07-08 | significant-influence-or-control | |||||
744159.interests.0 | 744159 | other-influence-or-control | 2016-07-08 | significant-influence-or-control | ||||||
744267.interests.2 | 744267 | appointment-of-board | 2016-07-08 | right-to-appoint-and-remove-directors | ||||||
744284.interests.2 | 744284 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
744311.interests.4 | 744311 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
744311.interests.5 | 744311 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors-as-firm | ||||||
744311.interests.6 | 744311 | other-influence-or-control | 2016-07-01 | significant-influence-or-control | ||||||
744311.interests.7 | 744311 | other-influence-or-control | 2016-07-01 | significant-influence-or-control-as-firm | ||||||
744348.interests.2 | 744348 | appointment-of-board | 2016-07-05 | right-to-appoint-and-remove-directors | ||||||
744361.interests.2 | 744361 | other-influence-or-control | 2016-07-02 | significant-influence-or-control | ||||||
744387.interests.2 | 744387 | appointment-of-board | 2016-07-11 | right-to-appoint-and-remove-directors | ||||||
744410.interests.0 | 744410 | other-influence-or-control | 2018-03-09 | 2016-04-06 | significant-influence-or-control | |||||
744419.interests.2 | 744419 | other-influence-or-control | 2016-04-06 | significant-influence-or-control | ||||||
744420.interests.0 | 744420 | other-influence-or-control | 2018-03-09 | 2016-04-06 | significant-influence-or-control | |||||
744434.interests.0 | 744434 | other-influence-or-control | 2022-09-30 | 2016-04-06 | significant-influence-or-control |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [ooc_interests] ( [_link] TEXT , [_link_ooc_statement] TEXT , [type] TEXT , [enddate] TEXT , [startdate] TEXT , [share_exact] NUMERIC , [share_maximum] NUMERIC , [share_minimum] NUMERIC , [details] TEXT , [share_exclusiveminimum] BOOL , [share_exclusivemaximum] BOOL , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );