ooc_interests
1,826,491 rows sorted by share_minimum
This data as json, CSV (advanced)
_link | _link_ooc_statement | type | startdate | share_exact | share_maximum | share_minimum ▼ | enddate |
---|---|---|---|---|---|---|---|
473073.interests.0 | 473073 | shareholding | 2006-12-14 | 0 | 0 | 0 | |
477805.interests.0 | 477805 | shareholding | 2007-01-26 | 0 | 0 | 0 | |
483330.interests.0 | 483330 | shareholding | 2015-12-31 | 0 | 0 | 0 | |
483714.interests.0 | 483714 | shareholding | 2019-03-11 | 0 | 0 | 0 | |
495988.interests.0 | 495988 | shareholding | 2022-02-06 | 0 | 0 | 0 | |
510344.interests.0 | 510344 | shareholding | 2020-08-27 | 0 | 0 | 0 | |
512032.interests.0 | 512032 | shareholding | 2022-01-20 | 0 | 0 | 0 | |
517181.interests.0 | 517181 | shareholding | 2021-05-31 | 0 | 0 | 0 | |
517490.interests.0 | 517490 | shareholding | 2020-08-27 | 0 | 0 | 0 | |
526146.interests.0 | 526146 | shareholding | 2020-08-27 | 0 | 0 | 0 | |
526164.interests.0 | 526164 | shareholding | 2014-11-19 | 0 | 0 | 0 | 2021-04-13 |
526511.interests.0 | 526511 | shareholding | 2022-04-04 | 0 | 0 | 0 | |
532520.interests.0 | 532520 | shareholding | 2019-05-27 | 0 | 0 | 0 | |
538130.interests.0 | 538130 | shareholding | 2019-11-11 | 0 | 0 | 0 | 2021-09-24 |
538798.interests.0 | 538798 | shareholding | 2021-11-23 | 0 | 0 | 0 | |
539212.interests.0 | 539212 | shareholding | 2021-11-23 | 0 | 0 | 0 | |
540540.interests.0 | 540540 | shareholding | 2009-09-28 | 0 | 0 | 0 | |
543551.interests.0 | 543551 | shareholding | 2018-10-04 | 0 | 0 | 0 | |
547082.interests.0 | 547082 | shareholding | 2022-10-20 | 0 | 0 | 0 | |
547111.interests.0 | 547111 | shareholding | 2022-10-20 | 0 | 0 | 0 | |
549241.interests.0 | 549241 | shareholding | 2022-10-20 | 0 | 0 | 0 | |
550196.interests.0 | 550196 | shareholding | 2021-11-23 | 0 | 0 | 0 | |
551905.interests.0 | 551905 | shareholding | 2017-08-22 | 0 | 0 | 0 | |
554188.interests.0 | 554188 | shareholding | 2020-02-14 | 0 | 0 | 0 | |
557547.interests.0 | 557547 | shareholding | 2016-05-24 | 0 | 0 | 0 | |
559134.interests.0 | 559134 | shareholding | 2020-12-08 | 0 | 0 | 0 | |
559467.interests.0 | 559467 | shareholding | 2019-09-30 | 0 | 0 | 0 | |
560633.interests.0 | 560633 | shareholding | 2017-08-22 | 0 | 0 | 0 | |
574925.interests.1 | 574925 | voting-rights | 2019-12-30 | 0 | 0 | 0 | |
575133.interests.0 | 575133 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
575352.interests.0 | 575352 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
579842.interests.1 | 579842 | voting-rights | 2022-04-23 | 0 | 0 | 0 | |
581143.interests.0 | 581143 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
582872.interests.0 | 582872 | shareholding | 2020-02-14 | 0 | 0 | 0 | |
592058.interests.0 | 592058 | shareholding | 2020-12-08 | 0 | 0 | 0 | |
610599.interests.0 | 610599 | shareholding | 2021-12-15 | 0 | 0 | 0 | |
610661.interests.0 | 610661 | shareholding | 2021-12-15 | 0 | 0 | 0 | |
612208.interests.0 | 612208 | shareholding | 2021-12-02 | 0 | 0 | 0 | |
614785.interests.0 | 614785 | shareholding | 2011-05-24 | 0 | 0 | 0 | |
615583.interests.0 | 615583 | shareholding | 2015-11-11 | 0 | 0 | 0 | |
615927.interests.0 | 615927 | shareholding | 2021-01-19 | 0 | 0 | 0 | 2021-08-30 |
617336.interests.0 | 617336 | shareholding | 2016-04-11 | 0 | 0 | 0 | 2018-06-14 |
617467.interests.0 | 617467 | shareholding | 2021-12-15 | 0 | 0 | 0 | |
618460.interests.0 | 618460 | shareholding | 2021-12-02 | 0 | 0 | 0 | |
619502.interests.0 | 619502 | shareholding | 2014-11-12 | 0 | 0 | 0 | |
626853.interests.0 | 626853 | shareholding | 1997-11-01 | 0 | 0 | 0 | |
632088.interests.0 | 632088 | shareholding | 2020-02-03 | 0 | 0 | 0 | |
633178.interests.0 | 633178 | shareholding | 2019-03-08 | 0 | 0 | 0 | |
636763.interests.0 | 636763 | shareholding | 2020-02-03 | 0 | 0 | 0 | |
639708.interests.0 | 639708 | shareholding | 2017-08-17 | 0 | 0 | 0 | |
642202.interests.0 | 642202 | shareholding | 2019-06-11 | 0 | 0 | 0 | 2020-08-06 |
643237.interests.0 | 643237 | shareholding | 2002-11-13 | 0 | 0 | 0 | |
645229.interests.0 | 645229 | shareholding | 1997-01-01 | 0 | 0 | 0 | |
646246.interests.0 | 646246 | shareholding | 2021-07-08 | 0 | 0 | 0 | |
647670.interests.0 | 647670 | shareholding | 2005-09-27 | 0 | 0 | 0 | |
648946.interests.0 | 648946 | shareholding | 1978-06-01 | 0 | 0 | 0 | |
649498.interests.0 | 649498 | shareholding | 2020-05-05 | 0 | 0 | 0 | |
651069.interests.0 | 651069 | shareholding | 2021-07-08 | 0 | 0 | 0 | |
652567.interests.0 | 652567 | shareholding | 2019-07-31 | 0 | 0 | 0 | 2021-04-22 |
652567.interests.1 | 652567 | voting-rights | 2019-07-31 | 0 | 0 | 0 | 2021-04-22 |
655606.interests.0 | 655606 | shareholding | 2021-09-17 | 0 | 0 | 0 | |
661551.interests.0 | 661551 | shareholding | 2021-09-17 | 0 | 0 | 0 | |
671454.interests.1 | 671454 | voting-rights | 2015-12-30 | 0 | 0 | 0 | 2017-12-31 |
672292.interests.1 | 672292 | voting-rights | 2006-12-21 | 0 | 0 | 0 | |
679999.interests.0 | 679999 | shareholding | 2006-06-26 | 0 | 0 | 0 | 2021-06-18 |
691009.interests.0 | 691009 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
693625.interests.0 | 693625 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
693942.interests.0 | 693942 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
698762.interests.0 | 698762 | shareholding | 2022-10-05 | 0 | 0 | 0 | |
699985.interests.0 | 699985 | shareholding | 2022-10-05 | 0 | 0 | 0 | |
704732.interests.0 | 704732 | shareholding | 2022-10-05 | 0 | 0 | 0 | |
708234.interests.0 | 708234 | shareholding | 2006-12-31 | 0 | 0 | 0 | 2019-11-01 |
716779.interests.0 | 716779 | shareholding | 2022-04-08 | 0 | 0 | 0 | |
71687.interests.1 | 71687 | voting-rights | 2013-06-24 | 0 | 0 | 0 | |
721712.interests.0 | 721712 | shareholding | 2022-04-08 | 0 | 0 | 0 | |
726027.interests.0 | 726027 | shareholding | 2020-09-13 | 0 | 0 | 0 | |
727482.interests.1 | 727482 | voting-rights | 2006-12-21 | 0 | 0 | 0 | |
731615.interests.0 | 731615 | shareholding | 2022-11-07 | 0 | 0 | 0 | |
734563.interests.0 | 734563 | shareholding | 2022-11-07 | 0 | 0 | 0 | |
735185.interests.0 | 735185 | shareholding | 2022-11-07 | 0 | 0 | 0 | |
751377.interests.0 | 751377 | shareholding | 2020-12-17 | 0 | 0 | 0 | |
751683.interests.0 | 751683 | shareholding | 2020-12-17 | 0 | 0 | 0 | |
75578.interests.1 | 75578 | voting-rights | 2016-10-03 | 0 | 0 | 0 | |
75705.interests.0 | 75705 | shareholding | 2021-05-01 | 0 | 0 | 0 | |
761105.interests.0 | 761105 | shareholding | 2016-11-30 | 0 | 0 | 0 | |
761267.interests.0 | 761267 | shareholding | 2016-11-30 | 0 | 0 | 0 | |
762603.interests.0 | 762603 | shareholding | 2016-11-30 | 0 | 0 | 0 | |
76302.interests.0 | 76302 | shareholding | 2021-10-01 | 0 | 0 | 0 | |
763277.interests.0 | 763277 | shareholding | 2016-11-30 | 0 | 0 | 0 | |
764361.interests.1 | 764361 | voting-rights | 2007-06-29 | 0 | 0 | 0 | |
764407.interests.0 | 764407 | shareholding | 2016-11-30 | 0 | 0 | 0 | |
764675.interests.0 | 764675 | shareholding | 2016-11-30 | 0 | 0 | 0 | |
764818.interests.0 | 764818 | shareholding | 2016-11-30 | 0 | 0 | 0 | |
765666.interests.0 | 765666 | shareholding | 2012-10-18 | 0 | 0 | 0 | 2021-12-27 |
766044.interests.0 | 766044 | shareholding | 2014-07-30 | 0 | 0 | 0 | |
766417.interests.0 | 766417 | shareholding | 2022-11-30 | 0 | 0 | 0 | |
766488.interests.0 | 766488 | shareholding | 2016-11-30 | 0 | 0 | 0 | |
767410.interests.0 | 767410 | shareholding | 2021-05-16 | 0 | 0 | 0 | |
767592.interests.0 | 767592 | shareholding | 2022-11-30 | 0 | 0 | 0 | |
769153.interests.0 | 769153 | shareholding | 2021-05-16 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [ooc_interests] ( [_link] TEXT , [_link_ooc_statement] TEXT , [type] TEXT , [startdate] TIMESTAMP , [share_exact] TEXT , [share_maximum] TEXT , [share_minimum] TEXT , [enddate] TIMESTAMP , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );