ooc_interests
1,826,491 rows sorted by startdate
This data as json, CSV (advanced)
_link | _link_ooc_statement | type | startdate ▼ | share_exact | share_maximum | share_minimum | enddate |
---|---|---|---|---|---|---|---|
448181.interests.0 | 448181 | shareholding | 1968-10-09 | 36.7 | 36.7 | 36.7 | 2018-11-29 |
448181.interests.1 | 448181 | voting-rights | 1968-10-09 | 36.7 | 36.7 | 36.7 | 2018-11-29 |
697872.interests.0 | 697872 | shareholding | 1968-10-30 | 100 | 100 | 100 | |
697872.interests.1 | 697872 | voting-rights | 1968-10-30 | 100 | 100 | 100 | |
168828.interests.0 | 168828 | shareholding | 1969-04-01 | 1.03 | 1.03 | 1.03 | |
168828.interests.1 | 168828 | voting-rights | 1969-04-01 | 33.51 | 33.51 | 33.51 | |
171418.interests.0 | 171418 | shareholding | 1969-04-01 | 1.03 | 1.03 | 1.03 | |
171418.interests.1 | 171418 | voting-rights | 1969-04-01 | 33.51 | 33.51 | 33.51 | |
705001.interests.0 | 705001 | shareholding | 1969-09-01 | 100 | 100 | 100 | 2018-05-31 |
705001.interests.1 | 705001 | voting-rights | 1969-09-01 | 100 | 100 | 100 | 2018-05-31 |
500208.interests.0 | 500208 | shareholding | 1969-10-30 | 50 | 50 | 50 | 2019-04-30 |
500208.interests.1 | 500208 | voting-rights | 1969-10-30 | 50 | 50 | 50 | 2019-04-30 |
629962.interests.0 | 629962 | shareholding | 1969-10-30 | 50 | 50 | 50 | 2018-02-27 |
629962.interests.1 | 629962 | voting-rights | 1969-10-30 | 50 | 50 | 50 | 2018-02-27 |
610513.interests.0 | 610513 | shareholding | 1969-10-31 | 100 | 100 | 100 | 2021-01-20 |
610513.interests.1 | 610513 | voting-rights | 1969-10-31 | 100 | 100 | 100 | 2021-01-20 |
219155.interests.0 | 219155 | shareholding | 1969-11-01 | 100 | 100 | 100 | |
219155.interests.1 | 219155 | voting-rights | 1969-11-01 | 100 | 100 | 100 | |
138765.interests.0 | 138765 | shareholding | 1969-11-05 | 100 | 100 | 100 | |
138765.interests.1 | 138765 | voting-rights | 1969-11-05 | 100 | 100 | 100 | |
543363.interests.0 | 543363 | shareholding | 1969-11-17 | 100 | 100 | 100 | 2020-01-30 |
543363.interests.1 | 543363 | voting-rights | 1969-11-17 | 100 | 100 | 100 | 2020-01-30 |
322700.interests.0 | 322700 | shareholding | 1969-11-19 | 100 | 100 | 100 | 2021-05-27 |
322700.interests.1 | 322700 | voting-rights | 1969-11-19 | 100 | 100 | 100 | 2021-05-27 |
168315.interests.0 | 168315 | shareholding | 1969-12-23 | 100 | 100 | 100 | |
168315.interests.1 | 168315 | voting-rights | 1969-12-23 | 100 | 100 | 100 | |
800242.interests.0 | 800242 | shareholding | 1969-12-23 | 100 | 100 | 100 | |
800242.interests.1 | 800242 | voting-rights | 1969-12-23 | 100 | 100 | 100 | |
252216.interests.0 | 252216 | shareholding | 1970-01-01 | 37.3 | 37.3 | 37.3 | 2022-08-15 |
252216.interests.1 | 252216 | voting-rights | 1970-01-01 | 37.3 | 37.3 | 37.3 | 2022-08-15 |
270796.interests.0 | 270796 | shareholding | 1970-01-01 | 100 | 100 | 100 | |
270796.interests.1 | 270796 | voting-rights | 1970-01-01 | 100 | 100 | 100 | |
279505.interests.0 | 279505 | shareholding | 1970-01-01 | 50 | 50 | 50 | 2020-12-31 |
279505.interests.1 | 279505 | voting-rights | 1970-01-01 | 50 | 50 | 50 | 2020-12-31 |
304431.interests.0 | 304431 | shareholding | 1970-01-01 | 100 | 100 | 100 | 2017-06-30 |
304431.interests.1 | 304431 | voting-rights | 1970-01-01 | 100 | 100 | 100 | 2017-06-30 |
341247.interests.0 | 341247 | shareholding | 1970-01-01 | 95 | 95 | 95 | |
341247.interests.1 | 341247 | voting-rights | 1970-01-01 | 100 | 100 | 100 | |
529011.interests.0 | 529011 | shareholding | 1970-01-01 | 50 | 50 | 50 | |
543702.interests.0 | 543702 | shareholding | 1970-01-01 | 50 | 50 | 50 | 2020-12-31 |
543702.interests.1 | 543702 | voting-rights | 1970-01-01 | 50 | 50 | 50 | 2020-12-31 |
563997.interests.0 | 563997 | shareholding | 1970-01-01 | 9.67 | 9.67 | 9.67 | 2018-10-31 |
563997.interests.1 | 563997 | voting-rights | 1970-01-01 | 5.56 | 5.56 | 5.56 | 2018-10-31 |
755160.interests.0 | 755160 | shareholding | 1970-01-01 | 9.67 | 9.67 | 9.67 | 2018-10-31 |
755160.interests.1 | 755160 | voting-rights | 1970-01-01 | 5.56 | 5.56 | 5.56 | 2018-10-31 |
802811.interests.0 | 802811 | shareholding | 1970-01-01 | 95 | 95 | 95 | 2023-01-06 |
802811.interests.1 | 802811 | voting-rights | 1970-01-01 | 100 | 100 | 100 | 2023-01-06 |
956515.interests.0 | 956515 | shareholding | 1970-01-01 | 95 | 95 | 95 | 2023-01-06 |
956515.interests.1 | 956515 | voting-rights | 1970-01-01 | 100 | 100 | 100 | 2023-01-06 |
635159.interests.0 | 635159 | shareholding | 1970-01-30 | 29.49 | 29.49 | 29.49 | |
418063.interests.0 | 418063 | shareholding | 1970-02-26 | 51 | 51 | 51 | |
418063.interests.1 | 418063 | voting-rights | 1970-02-26 | 51 | 51 | 51 | |
153907.interests.0 | 153907 | shareholding | 1970-03-25 | 61.55 | 61.55 | 61.55 | |
153907.interests.1 | 153907 | voting-rights | 1970-03-25 | 61.55 | 61.55 | 61.55 | |
521244.interests.0 | 521244 | shareholding | 1970-03-25 | 38.45 | 38.45 | 38.45 | |
521244.interests.1 | 521244 | voting-rights | 1970-03-25 | 38.45 | 38.45 | 38.45 | |
93841.interests.0 | 93841 | shareholding | 1970-03-31 | 85 | 85 | 85 | |
93841.interests.1 | 93841 | voting-rights | 1970-03-31 | 85 | 85 | 85 | |
313854.interests.0 | 313854 | shareholding | 1970-04-20 | 100 | 100 | 100 | |
313854.interests.1 | 313854 | voting-rights | 1970-04-20 | 100 | 100 | 100 | |
645733.interests.0 | 645733 | shareholding | 1970-05-01 | 50 | 50 | 50 | |
645733.interests.1 | 645733 | voting-rights | 1970-05-01 | 50 | 50 | 50 | |
767690.interests.0 | 767690 | shareholding | 1970-05-01 | 50 | 50 | 50 | |
767690.interests.1 | 767690 | voting-rights | 1970-05-01 | 50 | 50 | 50 | |
595942.interests.0 | 595942 | shareholding | 1970-05-14 | 100 | 100 | 100 | |
595942.interests.1 | 595942 | voting-rights | 1970-05-14 | 100 | 100 | 100 | |
604370.interests.0 | 604370 | shareholding | 1970-05-20 | 100 | 100 | 100 | |
604370.interests.1 | 604370 | voting-rights | 1970-05-20 | 100 | 100 | 100 | |
645504.interests.0 | 645504 | shareholding | 1970-05-20 | 33.33 | 33.33 | 33.33 | 2020-12-31 |
645504.interests.1 | 645504 | voting-rights | 1970-05-20 | 33.33 | 33.33 | 33.33 | 2020-12-31 |
763878.interests.0 | 763878 | shareholding | 1970-05-20 | 33.33 | 33.33 | 33.33 | 2020-12-31 |
763878.interests.1 | 763878 | voting-rights | 1970-05-20 | 33.33 | 33.33 | 33.33 | 2020-12-31 |
79848.interests.0 | 79848 | shareholding | 1970-05-20 | 33.339999999999996 | 33.339999999999996 | 33.339999999999996 | 2020-12-31 |
79848.interests.1 | 79848 | voting-rights | 1970-05-20 | 33.339999999999996 | 33.339999999999996 | 33.339999999999996 | 2020-12-31 |
119394.interests.0 | 119394 | shareholding | 1970-06-22 | 75.2 | 75.2 | 75.2 | 2018-06-29 |
119394.interests.1 | 119394 | voting-rights | 1970-06-22 | 75.2 | 75.2 | 75.2 | 2018-06-29 |
341353.interests.0 | 341353 | shareholding | 1970-08-01 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | |
344811.interests.0 | 344811 | shareholding | 1970-08-01 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | |
454087.interests.0 | 454087 | shareholding | 1970-08-01 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | |
815422.interests.0 | 815422 | shareholding | 1970-08-01 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | 2023-02-15 |
816554.interests.0 | 816554 | shareholding | 1970-08-01 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | 2023-02-15 |
817222.interests.0 | 817222 | shareholding | 1970-08-01 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | 2023-02-15 |
342581.interests.0 | 342581 | shareholding | 1970-08-14 | 100 | 100 | 100 | |
342581.interests.1 | 342581 | voting-rights | 1970-08-14 | 100 | 100 | 100 | |
290402.interests.0 | 290402 | shareholding | 1970-09-09 | 100 | 100 | 100 | |
290402.interests.1 | 290402 | voting-rights | 1970-09-09 | 100 | 100 | 100 | |
594148.interests.0 | 594148 | shareholding | 1970-09-22 | 100 | 100 | 100 | |
594148.interests.1 | 594148 | voting-rights | 1970-09-22 | 100 | 100 | 100 | |
611052.interests.0 | 611052 | shareholding | 1970-10-02 | 100 | 100 | 100 | |
611052.interests.1 | 611052 | voting-rights | 1970-10-02 | 100 | 100 | 100 | |
106244.interests.0 | 106244 | shareholding | 1970-11-20 | 50 | 50 | 50 | 2021-12-31 |
106244.interests.1 | 106244 | voting-rights | 1970-11-20 | 50 | 50 | 50 | 2021-12-31 |
165574.interests.0 | 165574 | shareholding | 1970-11-20 | 50 | 50 | 50 | 2021-12-31 |
165574.interests.1 | 165574 | voting-rights | 1970-11-20 | 50 | 50 | 50 | 2021-12-31 |
409426.interests.0 | 409426 | shareholding | 1970-11-30 | 100 | 100 | 100 | |
409426.interests.1 | 409426 | voting-rights | 1970-11-30 | 100 | 100 | 100 | |
528336.interests.0 | 528336 | shareholding | 1970-12-01 | 100 | 100 | 100 | |
528336.interests.1 | 528336 | voting-rights | 1970-12-01 | 100 | 100 | 100 | |
633179.interests.0 | 633179 | shareholding | 1970-12-01 | 50 | 50 | 50 | |
633179.interests.1 | 633179 | voting-rights | 1970-12-01 | 50 | 50 | 50 |
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]) );