ooc_interests
1,324,489 rows sorted by type
This data as json, CSV (advanced)
_link | _link_ooc_statement | type ▼ | enddate | startdate | share_exact | share_maximum | share_minimum | details | share_exclusiveminimum | share_exclusivemaximum |
---|---|---|---|---|---|---|---|---|---|---|
745761.interests.2 | 745761 | appointment-of-board | 2016-07-12 | right-to-appoint-and-remove-directors | ||||||
745765.interests.2 | 745765 | appointment-of-board | 2022-10-11 | 2016-04-06 | right-to-appoint-and-remove-directors | |||||
745766.interests.2 | 745766 | appointment-of-board | 2016-07-06 | right-to-appoint-and-remove-directors | ||||||
745766.interests.3 | 745766 | appointment-of-board | 2016-07-06 | right-to-appoint-and-remove-directors-as-firm | ||||||
745782.interests.2 | 745782 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
745808.interests.2 | 745808 | appointment-of-board | 2016-07-14 | right-to-appoint-and-remove-directors | ||||||
745845.interests.2 | 745845 | appointment-of-board | 2016-06-30 | right-to-appoint-and-remove-directors | ||||||
745866.interests.6 | 745866 | appointment-of-board | 2016-07-14 | right-to-appoint-and-remove-directors | ||||||
745882.interests.2 | 745882 | appointment-of-board | 2016-07-14 | right-to-appoint-and-remove-directors | ||||||
745907.interests.2 | 745907 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
745918.interests.2 | 745918 | appointment-of-board | 2016-07-14 | right-to-appoint-and-remove-directors | ||||||
745919.interests.2 | 745919 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
745986.interests.0 | 745986 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
745986.interests.1 | 745986 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors-as-firm | ||||||
745994.interests.2 | 745994 | appointment-of-board | 2022-10-31 | 2016-07-15 | right-to-appoint-and-remove-directors | |||||
746229.interests.2 | 746229 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
746274.interests.2 | 746274 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
746295.interests.2 | 746295 | appointment-of-board | 2016-07-15 | right-to-appoint-and-remove-directors | ||||||
746326.interests.2 | 746326 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
746357.interests.2 | 746357 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
746459.interests.2 | 746459 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
746474.interests.2 | 746474 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
746482.interests.2 | 746482 | appointment-of-board | 2022-09-27 | 2016-04-06 | right-to-appoint-and-remove-directors | |||||
746497.interests.2 | 746497 | appointment-of-board | 2016-07-06 | right-to-appoint-and-remove-directors | ||||||
746498.interests.2 | 746498 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
746499.interests.2 | 746499 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
746522.interests.2 | 746522 | appointment-of-board | 2016-07-18 | right-to-appoint-and-remove-directors | ||||||
746557.interests.2 | 746557 | appointment-of-board | 2022-09-27 | 2016-04-12 | right-to-appoint-and-remove-directors | |||||
746574.interests.2 | 746574 | appointment-of-board | 2022-07-29 | 2016-07-18 | right-to-appoint-and-remove-directors | |||||
746618.interests.2 | 746618 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
746691.interests.2 | 746691 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
746693.interests.2 | 746693 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
746695.interests.2 | 746695 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
746709.interests.2 | 746709 | appointment-of-board | 2022-01-06 | 2016-07-05 | right-to-appoint-and-remove-directors | |||||
746734.interests.2 | 746734 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
746860.interests.6 | 746860 | appointment-of-board | 2016-07-19 | right-to-appoint-and-remove-directors | ||||||
746860.interests.7 | 746860 | appointment-of-board | 2016-07-19 | right-to-appoint-and-remove-directors-as-trust | ||||||
746860.interests.8 | 746860 | appointment-of-board | 2016-07-19 | right-to-appoint-and-remove-directors-as-firm | ||||||
746955.interests.2 | 746955 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
746956.interests.4 | 746956 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
747016.interests.2 | 747016 | appointment-of-board | 2016-07-13 | right-to-appoint-and-remove-directors | ||||||
747021.interests.2 | 747021 | appointment-of-board | 2022-09-28 | 2016-05-12 | right-to-appoint-and-remove-directors | |||||
747069.interests.2 | 747069 | appointment-of-board | 2016-07-19 | right-to-appoint-and-remove-directors | ||||||
747139.interests.2 | 747139 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
747236.interests.2 | 747236 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
747260.interests.2 | 747260 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
747268.interests.2 | 747268 | appointment-of-board | 2016-07-20 | right-to-appoint-and-remove-directors | ||||||
747269.interests.2 | 747269 | appointment-of-board | 2016-07-20 | right-to-appoint-and-remove-directors | ||||||
747305.interests.2 | 747305 | appointment-of-board | 2016-07-20 | right-to-appoint-and-remove-directors | ||||||
747309.interests.2 | 747309 | appointment-of-board | 2016-07-20 | right-to-appoint-and-remove-directors | ||||||
747312.interests.2 | 747312 | appointment-of-board | 2016-07-20 | right-to-appoint-and-remove-directors | ||||||
747341.interests.2 | 747341 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
747342.interests.2 | 747342 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
747360.interests.2 | 747360 | appointment-of-board | 2022-06-01 | 2016-07-01 | right-to-appoint-and-remove-directors | |||||
747411.interests.2 | 747411 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
747423.interests.2 | 747423 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
747444.interests.2 | 747444 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
747464.interests.2 | 747464 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
747506.interests.2 | 747506 | appointment-of-board | 2016-07-18 | right-to-appoint-and-remove-directors | ||||||
747555.interests.2 | 747555 | appointment-of-board | 2022-11-01 | 2016-07-18 | right-to-appoint-and-remove-directors | |||||
747586.interests.2 | 747586 | appointment-of-board | 2016-04-07 | right-to-appoint-and-remove-directors | ||||||
747615.interests.2 | 747615 | appointment-of-board | 2016-07-20 | right-to-appoint-and-remove-directors | ||||||
747730.interests.2 | 747730 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
747751.interests.2 | 747751 | appointment-of-board | 2016-07-21 | right-to-appoint-and-remove-directors | ||||||
747762.interests.2 | 747762 | appointment-of-board | 2021-07-08 | 2016-07-10 | right-to-appoint-and-remove-directors | |||||
747793.interests.0 | 747793 | appointment-of-board | 2016-11-09 | 2016-10-11 | right-to-appoint-and-remove-directors | |||||
747839.interests.2 | 747839 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
747840.interests.2 | 747840 | appointment-of-board | 2021-10-25 | 2016-04-06 | right-to-appoint-and-remove-directors | |||||
747892.interests.2 | 747892 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
747898.interests.2 | 747898 | appointment-of-board | 2016-07-21 | right-to-appoint-and-remove-directors | ||||||
747920.interests.6 | 747920 | appointment-of-board | 2016-07-17 | right-to-appoint-and-remove-directors | ||||||
747920.interests.7 | 747920 | appointment-of-board | 2016-07-17 | right-to-appoint-and-remove-directors-as-firm | ||||||
747930.interests.2 | 747930 | appointment-of-board | 2016-07-21 | right-to-appoint-and-remove-directors | ||||||
747933.interests.2 | 747933 | appointment-of-board | 2016-07-21 | right-to-appoint-and-remove-directors | ||||||
747938.interests.2 | 747938 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
747957.interests.6 | 747957 | appointment-of-board | 2016-07-21 | right-to-appoint-and-remove-directors | ||||||
748033.interests.0 | 748033 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
748040.interests.2 | 748040 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
748097.interests.2 | 748097 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
748109.interests.2 | 748109 | appointment-of-board | 2016-07-22 | right-to-appoint-and-remove-directors | ||||||
748110.interests.2 | 748110 | appointment-of-board | 2016-07-22 | right-to-appoint-and-remove-directors | ||||||
748161.interests.2 | 748161 | appointment-of-board | 2016-07-21 | right-to-appoint-and-remove-directors | ||||||
748239.interests.2 | 748239 | appointment-of-board | 2016-07-01 | right-to-appoint-and-remove-directors | ||||||
748296.interests.2 | 748296 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
748298.interests.2 | 748298 | appointment-of-board | 2022-05-26 | 2016-04-06 | right-to-appoint-and-remove-directors | |||||
748301.interests.2 | 748301 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
748306.interests.3 | 748306 | appointment-of-board | 2016-06-30 | right-to-appoint-and-remove-members-limited-liability-partnership | ||||||
748307.interests.2 | 748307 | appointment-of-board | 2016-07-12 | right-to-appoint-and-remove-directors | ||||||
748415.interests.2 | 748415 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
748416.interests.2 | 748416 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
748487.interests.2 | 748487 | appointment-of-board | 2016-07-22 | right-to-appoint-and-remove-directors | ||||||
748549.interests.2 | 748549 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
748620.interests.2 | 748620 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
748623.interests.2 | 748623 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
748664.interests.5 | 748664 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors | ||||||
748664.interests.6 | 748664 | appointment-of-board | 2016-04-06 | right-to-appoint-and-remove-directors-as-firm | ||||||
748695.interests.0 | 748695 | appointment-of-board | 2016-07-23 | right-to-appoint-and-remove-directors | ||||||
748695.interests.1 | 748695 | appointment-of-board | 2016-07-23 | right-to-appoint-and-remove-directors-as-trust | ||||||
748695.interests.2 | 748695 | appointment-of-board | 2016-07-23 | right-to-appoint-and-remove-directors-as-firm | ||||||
748771.interests.3 | 748771 | appointment-of-board | 2022-10-14 | 2016-06-20 | 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 , [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]) );