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 |
---|---|---|---|---|---|---|---|
774556.interests.0 | 774556 | shareholding | 2022-04-08 | 0 | 0 | 0 | |
779017.interests.0 | 779017 | shareholding | 2022-04-08 | 0 | 0 | 0 | |
78055.interests.1 | 78055 | voting-rights | 2016-10-03 | 0 | 0 | 0 | 2021-11-09 |
788111.interests.1 | 788111 | voting-rights | 2006-12-21 | 0 | 0 | 0 | |
791581.interests.1 | 791581 | voting-rights | 2012-08-03 | 0 | 0 | 0 | |
792900.interests.0 | 792900 | shareholding | 2020-10-06 | 0 | 0 | 0 | |
79467.interests.0 | 79467 | shareholding | 2018-03-01 | 0 | 0 | 0 | |
79812.interests.0 | 79812 | shareholding | 2021-05-01 | 0 | 0 | 0 | |
80110.interests.0 | 80110 | shareholding | 2015-06-26 | 0 | 0 | 0 | |
801965.interests.0 | 801965 | shareholding | 2022-12-29 | 0 | 0 | 0 | |
80976.interests.1 | 80976 | voting-rights | 2016-10-03 | 0 | 0 | 0 | |
81353.interests.1 | 81353 | voting-rights | 2016-10-03 | 0 | 0 | 0 | |
815037.interests.0 | 815037 | shareholding | 2020-05-07 | 0 | 0 | 0 | |
82114.interests.0 | 82114 | shareholding | 2021-05-01 | 0 | 0 | 0 | |
822145.interests.0 | 822145 | shareholding | 2021-01-01 | 0 | 0 | 0 | 2022-05-05 |
822145.interests.1 | 822145 | voting-rights | 2021-01-01 | 0 | 0 | 0 | 2022-05-05 |
827461.interests.1 | 827461 | voting-rights | 2017-11-29 | 0 | 0 | 0 | |
840470.interests.0 | 840470 | shareholding | 2020-09-13 | 0 | 0 | 0 | |
847003.interests.0 | 847003 | shareholding | 2018-07-04 | 0 | 0 | 0 | 2023-04-04 |
850968.interests.0 | 850968 | shareholding | 2020-12-08 | 0 | 0 | 0 | 2023-03-29 |
851584.interests.0 | 851584 | shareholding | 2020-12-08 | 0 | 0 | 0 | 2023-03-29 |
851927.interests.0 | 851927 | shareholding | 2020-10-06 | 0 | 0 | 0 | 2023-03-29 |
852093.interests.0 | 852093 | shareholding | 2020-10-06 | 0 | 0 | 0 | 2023-03-29 |
852186.interests.0 | 852186 | shareholding | 2020-11-06 | 0 | 0 | 0 | 2023-03-29 |
857242.interests.1 | 857242 | voting-rights | 2023-02-03 | 0 | 0 | 0 | |
862791.interests.0 | 862791 | shareholding | 2023-04-24 | 0 | 0 | 0 | |
862852.interests.0 | 862852 | shareholding | 2023-04-24 | 0 | 0 | 0 | |
864069.interests.0 | 864069 | shareholding | 2023-04-24 | 0 | 0 | 0 | |
870155.interests.0 | 870155 | shareholding | 2020-09-13 | 0 | 0 | 0 | |
878424.interests.0 | 878424 | shareholding | 2021-09-17 | 0 | 0 | 0 | |
878974.interests.0 | 878974 | shareholding | 2021-09-17 | 0 | 0 | 0 | |
890460.interests.0 | 890460 | shareholding | 2020-09-13 | 0 | 0 | 0 | |
896850.interests.0 | 896850 | shareholding | 2018-06-19 | 0 | 0 | 0 | 2019-12-04 |
899645.interests.1 | 899645 | voting-rights | 2023-05-10 | 0 | 0 | 0 | |
904530.interests.0 | 904530 | shareholding | 2023-05-17 | 0 | 0 | 0 | |
904567.interests.0 | 904567 | shareholding | 2023-04-20 | 0 | 0 | 0 | |
905347.interests.0 | 905347 | shareholding | 2018-07-04 | 0 | 0 | 0 | 2023-04-04 |
906073.interests.0 | 906073 | shareholding | 2023-04-20 | 0 | 0 | 0 | |
906912.interests.0 | 906912 | shareholding | 2023-04-20 | 0 | 0 | 0 | |
908747.interests.0 | 908747 | shareholding | 2023-05-17 | 0 | 0 | 0 | |
90894.interests.0 | 90894 | shareholding | 2018-07-04 | 0 | 0 | 0 | |
909269.interests.0 | 909269 | shareholding | 2023-04-20 | 0 | 0 | 0 | |
909487.interests.0 | 909487 | shareholding | 2023-05-17 | 0 | 0 | 0 | |
909573.interests.0 | 909573 | shareholding | 2023-06-12 | 0 | 0 | 0 | |
913123.interests.0 | 913123 | shareholding | 2020-05-07 | 0 | 0 | 0 | |
913371.interests.0 | 913371 | shareholding | 2023-05-10 | 0 | 0 | 0 | |
913524.interests.0 | 913524 | shareholding | 2023-05-17 | 0 | 0 | 0 | |
919687.interests.0 | 919687 | shareholding | 2020-07-06 | 0 | 0 | 0 | |
922257.interests.0 | 922257 | shareholding | 2020-07-06 | 0 | 0 | 0 | |
922818.interests.0 | 922818 | shareholding | 2023-05-22 | 0 | 0 | 0 | |
92896.interests.0 | 92896 | shareholding | 2019-11-13 | 0 | 0 | 0 | |
93576.interests.0 | 93576 | shareholding | 2019-11-13 | 0 | 0 | 0 | |
942064.interests.0 | 942064 | shareholding | 2021-10-15 | 0 | 0 | 0 | |
952339.interests.1 | 952339 | voting-rights | 2023-02-03 | 0 | 0 | 0 | |
956292.interests.0 | 956292 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
956916.interests.0 | 956916 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
961405.interests.0 | 961405 | shareholding | 2019-07-31 | 0 | 0 | 0 | 2021-04-22 |
961405.interests.1 | 961405 | voting-rights | 2019-07-31 | 0 | 0 | 0 | 2021-04-22 |
963172.interests.0 | 963172 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
963269.interests.0 | 963269 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
963395.interests.0 | 963395 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
978308.interests.1 | 978308 | voting-rights | 2012-12-26 | 0 | 0 | 0 | |
980325.interests.1 | 980325 | voting-rights | 2019-12-30 | 0 | 0 | 0 | |
984291.interests.1 | 984291 | voting-rights | 2015-12-30 | 0 | 0 | 0 | 2017-12-31 |
984327.interests.1 | 984327 | voting-rights | 2012-12-26 | 0 | 0 | 0 | |
984859.interests.1 | 984859 | voting-rights | 2017-03-04 | 0 | 0 | 0 | |
991740.interests.1 | 991740 | voting-rights | 2023-02-03 | 0 | 0 | 0 | |
992121.interests.0 | 992121 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
992191.interests.0 | 992191 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
992894.interests.0 | 992894 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
1006754.interests.0 | 1006754 | shareholding | 2019-09-01 | 0.01 | 0.01 | 0.01 | 2021-04-20 |
1006990.interests.0 | 1006990 | shareholding | 2019-10-21 | 0.01 | 0.01 | 0.01 | 2020-12-24 |
1007561.interests.0 | 1007561 | shareholding | 2018-07-13 | 0.01 | 0.01 | 0.01 | 2021-04-20 |
1009989.interests.0 | 1009989 | shareholding | 2014-11-05 | 0.01 | 0.01 | 0.01 | |
1017514.interests.0 | 1017514 | shareholding | 2020-02-17 | 0.01 | 0.01 | 0.01 | |
101767.interests.0 | 101767 | shareholding | 2014-11-05 | 0.01 | 0.01 | 0.01 | |
1019543.interests.1 | 1019543 | voting-rights | 2014-03-07 | 0.01 | 0.01 | 0.01 | 2022-03-29 |
1019715.interests.0 | 1019715 | shareholding | 2018-12-31 | 0.01 | 0.01 | 0.01 | |
102440.interests.0 | 102440 | shareholding | 2018-12-17 | 0.01 | 0.01 | 0.01 | |
1032173.interests.0 | 1032173 | shareholding | 2020-08-31 | 0.01 | 0.01 | 0.01 | |
1032490.interests.0 | 1032490 | shareholding | 2020-08-31 | 0.01 | 0.01 | 0.01 | |
1035140.interests.0 | 1035140 | shareholding | 2021-07-08 | 0.01 | 0.01 | 0.01 | |
1035171.interests.0 | 1035171 | shareholding | 2015-04-17 | 0.01 | 0.01 | 0.01 | |
1035174.interests.0 | 1035174 | shareholding | 2021-09-27 | 0.01 | 0.01 | 0.01 | |
1035272.interests.0 | 1035272 | shareholding | 2021-09-27 | 0.01 | 0.01 | 0.01 | |
1035350.interests.0 | 1035350 | shareholding | 2015-12-29 | 0.01 | 0.01 | 0.01 | |
1043995.interests.0 | 1043995 | shareholding | 2022-11-24 | 0.01 | 0.01 | 0.01 | |
1044060.interests.0 | 1044060 | shareholding | 2022-07-11 | 0.01 | 0.01 | 0.01 | |
1044074.interests.0 | 1044074 | shareholding | 2022-06-21 | 0.01 | 0.01 | 0.01 | |
1044098.interests.0 | 1044098 | shareholding | 2022-03-28 | 0.01 | 0.01 | 0.01 | |
1044162.interests.0 | 1044162 | shareholding | 2020-03-30 | 0.01 | 0.01 | 0.01 | 2022-12-06 |
1046384.interests.1 | 1046384 | voting-rights | 2008-07-11 | 0.01 | 0.01 | 0.01 | |
1046535.interests.0 | 1046535 | shareholding | 2021-03-24 | 0.01 | 0.01 | 0.01 | 2022-03-16 |
1051851.interests.1 | 1051851 | voting-rights | 2014-03-07 | 0.01 | 0.01 | 0.01 | 2022-03-29 |
1059007.interests.0 | 1059007 | shareholding | 2022-07-12 | 0.01 | 0.01 | 0.01 | |
1059333.interests.0 | 1059333 | shareholding | 2022-06-08 | 0.01 | 0.01 | 0.01 | |
106340.interests.0 | 106340 | shareholding | 2018-05-25 | 0.01 | 0.01 | 0.01 | |
1069323.interests.0 | 1069323 | shareholding | 2022-11-22 | 0.01 | 0.01 | 0.01 | |
1072228.interests.0 | 1072228 | shareholding | 2016-04-22 | 0.01 | 0.01 | 0.01 | |
1072386.interests.0 | 1072386 | shareholding | 2016-04-22 | 0.01 | 0.01 | 0.01 |
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]) );