ooc_interests
1,324,489 rows sorted by share_minimum
This data as json, CSV (advanced)
_link | _link_ooc_statement | type | enddate | startdate | share_exact | share_maximum | share_minimum ▼ | details | share_exclusiveminimum | share_exclusivemaximum |
---|---|---|---|---|---|---|---|---|---|---|
419785.interests.0 | 419785 | shareholding | 2022-10-05 | 0 | 0 | 0 | ||||
425745.interests.0 | 425745 | shareholding | 2002-11-13 | 0 | 0 | 0 | ||||
425746.interests.0 | 425746 | shareholding | 1978-06-01 | 0 | 0 | 0 | ||||
425747.interests.0 | 425747 | shareholding | 2005-09-27 | 0 | 0 | 0 | ||||
425749.interests.0 | 425749 | shareholding | 1997-01-01 | 0 | 0 | 0 | ||||
425753.interests.0 | 425753 | shareholding | 2020-08-06 | 2019-06-11 | 0 | 0 | 0 | |||
425755.interests.0 | 425755 | shareholding | 2020-05-05 | 0 | 0 | 0 | ||||
426946.interests.0 | 426946 | shareholding | 2019-05-27 | 0 | 0 | 0 | ||||
427074.interests.0 | 427074 | shareholding | 2022-01-20 | 0 | 0 | 0 | ||||
433745.interests.1 | 433745 | voting-rights | 2020-12-15 | 0 | 0 | 0 | ||||
433957.interests.0 | 433957 | shareholding | 2018-12-14 | 0 | 0 | 0 | ||||
433959.interests.0 | 433959 | shareholding | 2018-12-14 | 0 | 0 | 0 | ||||
463568.interests.0 | 463568 | shareholding | 2011-05-24 | 0 | 0 | 0 | ||||
463569.interests.0 | 463569 | shareholding | 2021-08-30 | 2021-01-19 | 0 | 0 | 0 | |||
463570.interests.0 | 463570 | shareholding | 2014-11-12 | 0 | 0 | 0 | ||||
463571.interests.0 | 463571 | shareholding | 2018-06-14 | 2016-04-11 | 0 | 0 | 0 | |||
463573.interests.0 | 463573 | shareholding | 2015-11-11 | 0 | 0 | 0 | ||||
481946.interests.0 | 481946 | shareholding | 2018-07-04 | 0 | 0 | 0 | ||||
507377.interests.0 | 507377 | shareholding | 2022-01-20 | 0 | 0 | 0 | ||||
520333.interests.0 | 520333 | shareholding | 2021-12-20 | 0 | 0 | 0 | ||||
520334.interests.0 | 520334 | shareholding | 2021-12-20 | 0 | 0 | 0 | ||||
520335.interests.0 | 520335 | shareholding | 2021-12-20 | 0 | 0 | 0 | ||||
525844.interests.0 | 525844 | shareholding | 1997-11-01 | 0 | 0 | 0 | ||||
534341.interests.0 | 534341 | shareholding | 2021-09-24 | 2019-11-11 | 0 | 0 | 0 | |||
53891.interests.0 | 53891 | shareholding | 2009-09-28 | 0 | 0 | 0 | ||||
540498.interests.0 | 540498 | shareholding | 2017-08-22 | 0 | 0 | 0 | ||||
540508.interests.0 | 540508 | shareholding | 2017-08-22 | 0 | 0 | 0 | ||||
556926.interests.0 | 556926 | shareholding | 2002-05-14 | 0 | 0 | 0 | ||||
556927.interests.0 | 556927 | shareholding | 2008-04-02 | 0 | 0 | 0 | ||||
567728.interests.0 | 567728 | shareholding | 2020-09-04 | 0 | 0 | 0 | ||||
572930.interests.0 | 572930 | shareholding | 2020-12-17 | 0 | 0 | 0 | ||||
572932.interests.0 | 572932 | shareholding | 2020-12-17 | 0 | 0 | 0 | ||||
575294.interests.1 | 575294 | voting-rights | 2021-11-09 | 2016-10-03 | 0 | 0 | 0 | |||
575295.interests.1 | 575295 | voting-rights | 2016-10-03 | 0 | 0 | 0 | ||||
575296.interests.1 | 575296 | voting-rights | 2016-10-03 | 0 | 0 | 0 | ||||
575297.interests.1 | 575297 | voting-rights | 2016-10-03 | 0 | 0 | 0 | ||||
592866.interests.0 | 592866 | shareholding | 2021-11-23 | 0 | 0 | 0 | ||||
592867.interests.0 | 592867 | shareholding | 2021-11-23 | 0 | 0 | 0 | ||||
592871.interests.0 | 592871 | shareholding | 2021-11-23 | 0 | 0 | 0 | ||||
600398.interests.0 | 600398 | shareholding | 2022-04-08 | 0 | 0 | 0 | ||||
600401.interests.0 | 600401 | shareholding | 2022-04-08 | 0 | 0 | 0 | ||||
604957.interests.0 | 604957 | shareholding | 2021-07-30 | 0 | 0 | 0 | ||||
604959.interests.0 | 604959 | shareholding | 2021-07-30 | 0 | 0 | 0 | ||||
604961.interests.0 | 604961 | shareholding | 2021-07-30 | 0 | 0 | 0 | ||||
605549.interests.0 | 605549 | shareholding | 2022-02-05 | 0 | 0 | 0 | ||||
605551.interests.0 | 605551 | shareholding | 2022-02-05 | 0 | 0 | 0 | ||||
629779.interests.0 | 629779 | shareholding | 2020-02-14 | 0 | 0 | 0 | ||||
629784.interests.0 | 629784 | shareholding | 2020-12-08 | 0 | 0 | 0 | ||||
644789.interests.0 | 644789 | shareholding | 2021-11-23 | 0 | 0 | 0 | ||||
647164.interests.1 | 647164 | voting-rights | 2007-06-29 | 0 | 0 | 0 | ||||
647954.interests.1 | 647954 | voting-rights | 2012-08-03 | 0 | 0 | 0 | ||||
649125.interests.1 | 649125 | voting-rights | 2012-12-26 | 0 | 0 | 0 | ||||
653157.interests.0 | 653157 | shareholding | 2019-12-30 | 0 | 0 | 0 | ||||
653158.interests.0 | 653158 | shareholding | 2019-12-30 | 0 | 0 | 0 | ||||
653208.interests.0 | 653208 | shareholding | 2019-12-30 | 0 | 0 | 0 | ||||
660326.interests.0 | 660326 | shareholding | 2019-11-01 | 2006-12-31 | 0 | 0 | 0 | |||
662802.interests.1 | 662802 | voting-rights | 2006-12-21 | 0 | 0 | 0 | ||||
663478.interests.1 | 663478 | voting-rights | 2012-12-26 | 0 | 0 | 0 | ||||
669898.interests.0 | 669898 | shareholding | 2022-10-20 | 0 | 0 | 0 | ||||
669899.interests.0 | 669899 | shareholding | 2022-10-20 | 0 | 0 | 0 | ||||
669900.interests.0 | 669900 | shareholding | 2022-10-20 | 0 | 0 | 0 | ||||
676325.interests.0 | 676325 | shareholding | 2022-10-05 | 0 | 0 | 0 | ||||
681472.interests.1 | 681472 | voting-rights | 2006-12-21 | 0 | 0 | 0 | ||||
693672.interests.1 | 693672 | voting-rights | 2013-06-24 | 0 | 0 | 0 | ||||
694643.interests.0 | 694643 | shareholding | 2021-11-23 | 0 | 0 | 0 | ||||
695223.interests.0 | 695223 | shareholding | 2022-04-04 | 0 | 0 | 0 | ||||
702248.interests.0 | 702248 | shareholding | 2019-12-30 | 0 | 0 | 0 | ||||
702249.interests.0 | 702249 | shareholding | 2019-12-30 | 0 | 0 | 0 | ||||
70448.interests.0 | 70448 | shareholding | 2016-11-26 | 0 | 0 | 0 | ||||
70449.interests.0 | 70449 | shareholding | 2016-11-12 | 0 | 0 | 0 | ||||
706670.interests.0 | 706670 | shareholding | 2022-04-08 | 0 | 0 | 0 | ||||
706674.interests.0 | 706674 | shareholding | 2022-04-08 | 0 | 0 | 0 | ||||
732012.interests.0 | 732012 | shareholding | 2008-08-15 | 0 | 0 | 0 | ||||
735755.interests.0 | 735755 | shareholding | 2021-07-08 | 0 | 0 | 0 | ||||
735762.interests.0 | 735762 | shareholding | 2021-07-08 | 0 | 0 | 0 | ||||
736652.interests.0 | 736652 | shareholding | 2019-02-04 | 0 | 0 | 0 | ||||
751672.interests.1 | 751672 | voting-rights | 2019-12-30 | 0 | 0 | 0 | ||||
751970.interests.0 | 751970 | shareholding | 2015-06-26 | 0 | 0 | 0 | ||||
754483.interests.0 | 754483 | shareholding | 2018-10-23 | 2013-08-06 | 0 | 0 | 0 | |||
754484.interests.0 | 754484 | shareholding | 2018-10-23 | 2013-08-06 | 0 | 0 | 0 | |||
754487.interests.0 | 754487 | shareholding | 2018-10-23 | 2013-08-06 | 0 | 0 | 0 | |||
754490.interests.0 | 754490 | shareholding | 2018-10-23 | 2013-08-06 | 0 | 0 | 0 | |||
754491.interests.0 | 754491 | shareholding | 2018-10-23 | 2013-08-07 | 0 | 0 | 0 | |||
755464.interests.0 | 755464 | shareholding | 2019-03-11 | 0 | 0 | 0 | ||||
757493.interests.0 | 757493 | shareholding | 2019-01-02 | 0 | 0 | 0 | ||||
760013.interests.0 | 760013 | shareholding | 2020-09-13 | 0 | 0 | 0 | ||||
767889.interests.1 | 767889 | voting-rights | 2017-12-31 | 2015-12-30 | 0 | 0 | 0 | |||
772682.interests.0 | 772682 | shareholding | 2020-02-14 | 0 | 0 | 0 | ||||
772709.interests.0 | 772709 | shareholding | 2020-12-08 | 0 | 0 | 0 | ||||
7792.interests.0 | 7792 | shareholding | 2021-04-22 | 2019-07-31 | 0 | 0 | 0 | |||
7792.interests.1 | 7792 | voting-rights | 2021-04-22 | 2019-07-31 | 0 | 0 | 0 | |||
784799.interests.0 | 784799 | shareholding | 2019-12-30 | 0 | 0 | 0 | ||||
784801.interests.0 | 784801 | shareholding | 2019-12-30 | 0 | 0 | 0 | ||||
784802.interests.0 | 784802 | shareholding | 2019-12-30 | 0 | 0 | 0 | ||||
788716.interests.0 | 788716 | shareholding | 2021-06-18 | 2006-06-26 | 0 | 0 | 0 | |||
788832.interests.0 | 788832 | shareholding | 2022-10-04 | 0 | 0 | 0 | ||||
85190.interests.1 | 85190 | voting-rights | 2021-11-09 | 2016-10-03 | 0 | 0 | 0 | |||
85191.interests.1 | 85191 | voting-rights | 2016-10-03 | 0 | 0 | 0 | ||||
85192.interests.1 | 85192 | voting-rights | 2016-10-03 | 0 | 0 | 0 | ||||
85193.interests.1 | 85193 | voting-rights | 2016-10-03 | 0 | 0 | 0 |
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]) );