ooc_interests
1,324,489 rows sorted by details 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 |
---|---|---|---|---|---|---|---|---|---|---|
743421.interests.0 | 743421 | voting-rights | 2016-06-01 | 100 | 75 | voting-rights-75-to-100-percent-limited-liability-partnership | false | false | ||
748306.interests.0 | 748306 | voting-rights | 2016-06-30 | 100 | 75 | voting-rights-75-to-100-percent-limited-liability-partnership | false | false | ||
743696.interests.4 | 743696 | voting-rights | 2016-07-07 | 100 | 75 | voting-rights-75-to-100-percent-as-trust | false | false | ||
744958.interests.2 | 744958 | voting-rights | 2016-06-12 | 100 | 75 | voting-rights-75-to-100-percent-as-trust | false | false | ||
745228.interests.4 | 745228 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent-as-trust | false | false | ||
745301.interests.4 | 745301 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent-as-trust | false | false | ||
745535.interests.3 | 745535 | voting-rights | 2016-07-14 | 100 | 75 | voting-rights-75-to-100-percent-as-trust | false | false | ||
745866.interests.4 | 745866 | voting-rights | 2016-07-14 | 100 | 75 | voting-rights-75-to-100-percent-as-trust | false | false | ||
747920.interests.4 | 747920 | voting-rights | 2016-07-17 | 100 | 75 | voting-rights-75-to-100-percent-as-trust | false | false | ||
748664.interests.3 | 748664 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent-as-trust | false | false | ||
750599.interests.4 | 750599 | voting-rights | 2016-07-27 | 100 | 75 | voting-rights-75-to-100-percent-as-trust | false | false | ||
751965.interests.3 | 751965 | voting-rights | 2016-07-29 | 100 | 75 | voting-rights-75-to-100-percent-as-trust | false | false | ||
752587.interests.3 | 752587 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent-as-trust | false | false | ||
743696.interests.5 | 743696 | voting-rights | 2016-07-07 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
744784.interests.3 | 744784 | voting-rights | 2022-10-12 | 2016-07-12 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | |
744958.interests.3 | 744958 | voting-rights | 2016-06-12 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
745228.interests.5 | 745228 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
745301.interests.5 | 745301 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
745535.interests.4 | 745535 | voting-rights | 2016-07-14 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
745866.interests.5 | 745866 | voting-rights | 2016-07-14 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
746711.interests.1 | 746711 | voting-rights | 2022-10-07 | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | |
747920.interests.5 | 747920 | voting-rights | 2016-07-17 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
748664.interests.4 | 748664 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
750599.interests.5 | 750599 | voting-rights | 2016-07-27 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
751965.interests.4 | 751965 | voting-rights | 2016-07-29 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
752299.interests.4 | 752299 | voting-rights | 2016-06-24 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
752587.interests.4 | 752587 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent-as-firm | false | false | ||
742809.interests.1 | 742809 | voting-rights | 2016-07-01 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743033.interests.1 | 743033 | voting-rights | 2016-07-03 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743068.interests.1 | 743068 | voting-rights | 2016-07-04 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743095.interests.1 | 743095 | voting-rights | 2016-07-04 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743139.interests.1 | 743139 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743178.interests.1 | 743178 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743181.interests.1 | 743181 | voting-rights | 2016-07-05 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743262.interests.1 | 743262 | voting-rights | 2022-09-17 | 2016-07-05 | 100 | 75 | voting-rights-75-to-100-percent | false | false | |
743316.interests.1 | 743316 | voting-rights | 2016-07-05 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743417.interests.1 | 743417 | voting-rights | 2016-07-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743431.interests.1 | 743431 | voting-rights | 2016-07-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743449.interests.1 | 743449 | voting-rights | 2016-07-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743486.interests.1 | 743486 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743504.interests.1 | 743504 | voting-rights | 2016-06-11 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743632.interests.1 | 743632 | voting-rights | 2016-07-07 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743634.interests.1 | 743634 | voting-rights | 2016-07-07 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743696.interests.3 | 743696 | voting-rights | 2016-07-07 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
743871.interests.1 | 743871 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744068.interests.1 | 744068 | voting-rights | 2016-07-01 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744267.interests.1 | 744267 | voting-rights | 2016-07-08 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744348.interests.1 | 744348 | voting-rights | 2016-07-05 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744360.interests.0 | 744360 | voting-rights | 2022-08-01 | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | |
744397.interests.1 | 744397 | voting-rights | 2016-07-11 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744457.interests.1 | 744457 | voting-rights | 2016-07-11 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744458.interests.1 | 744458 | voting-rights | 2016-07-04 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744464.interests.1 | 744464 | voting-rights | 2016-07-11 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744475.interests.1 | 744475 | voting-rights | 2016-07-11 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744481.interests.1 | 744481 | voting-rights | 2016-07-11 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744511.interests.1 | 744511 | voting-rights | 2016-07-11 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744571.interests.1 | 744571 | voting-rights | 2016-07-04 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744684.interests.1 | 744684 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744691.interests.1 | 744691 | voting-rights | 2022-09-14 | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | |
744740.interests.1 | 744740 | voting-rights | 2016-07-09 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744784.interests.2 | 744784 | voting-rights | 2022-10-12 | 2016-07-12 | 100 | 75 | voting-rights-75-to-100-percent | false | false | |
744857.interests.1 | 744857 | voting-rights | 2016-07-12 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744860.interests.1 | 744860 | voting-rights | 2016-07-12 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744874.interests.1 | 744874 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744880.interests.1 | 744880 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744884.interests.1 | 744884 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744922.interests.1 | 744922 | voting-rights | 2016-07-01 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744949.interests.1 | 744949 | voting-rights | 2016-07-12 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744958.interests.1 | 744958 | voting-rights | 2016-06-12 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744978.interests.1 | 744978 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
744979.interests.1 | 744979 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745024.interests.1 | 745024 | voting-rights | 2017-07-15 | 2016-07-12 | 100 | 75 | voting-rights-75-to-100-percent | false | false | |
745063.interests.1 | 745063 | voting-rights | 2016-06-30 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745088.interests.1 | 745088 | voting-rights | 2016-07-01 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745197.interests.1 | 745197 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745212.interests.1 | 745212 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745227.interests.1 | 745227 | voting-rights | 2016-06-30 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745228.interests.3 | 745228 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745301.interests.3 | 745301 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745364.interests.1 | 745364 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745387.interests.1 | 745387 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745458.interests.1 | 745458 | voting-rights | 2022-09-20 | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | |
745489.interests.1 | 745489 | voting-rights | 2016-07-09 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745535.interests.2 | 745535 | voting-rights | 2016-07-14 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745611.interests.1 | 745611 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745759.interests.1 | 745759 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745766.interests.1 | 745766 | voting-rights | 2016-07-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745782.interests.1 | 745782 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745808.interests.1 | 745808 | voting-rights | 2016-07-14 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745866.interests.3 | 745866 | voting-rights | 2016-07-14 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745907.interests.1 | 745907 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745919.interests.1 | 745919 | voting-rights | 2016-07-01 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745992.interests.1 | 745992 | voting-rights | 2016-07-15 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
745994.interests.1 | 745994 | voting-rights | 2022-10-31 | 2016-07-15 | 100 | 75 | voting-rights-75-to-100-percent | false | false | |
746229.interests.1 | 746229 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
746274.interests.1 | 746274 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
746294.interests.1 | 746294 | voting-rights | 2016-07-15 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
746295.interests.1 | 746295 | voting-rights | 2016-07-15 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
746326.interests.1 | 746326 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false | ||
746357.interests.1 | 746357 | voting-rights | 2016-04-06 | 100 | 75 | voting-rights-75-to-100-percent | false | false |
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]) );