ooc_interests
1,826,491 rows sorted by enddate
This data as json, CSV (advanced)
These facets timed out: enddate, startdate
_link | _link_ooc_statement | type | startdate | share_exact | share_maximum | share_minimum | enddate ▼ |
---|---|---|---|---|---|---|---|
1.interests.0 | 1 | shareholding | 2022-10-28 | 100 | 100 | 100 | |
1.interests.1 | 1 | voting-rights | 2022-10-28 | 100 | 100 | 100 | |
3.interests.0 | 3 | shareholding | 2011-06-18 | 50 | 50 | 50 | |
3.interests.1 | 3 | voting-rights | 2011-06-18 | 50 | 50 | 50 | |
4.interests.0 | 4 | shareholding | 2017-04-28 | 100 | 100 | 100 | |
4.interests.1 | 4 | voting-rights | 2017-04-28 | 100 | 100 | 100 | |
6.interests.0 | 6 | shareholding | 2022-09-28 | 100 | 100 | 100 | |
6.interests.1 | 6 | voting-rights | 2022-09-28 | 100 | 100 | 100 | |
9.interests.0 | 9 | shareholding | 2018-06-17 | 10 | 10 | 10 | |
9.interests.1 | 9 | voting-rights | 2018-06-17 | 100 | 100 | 100 | |
10.interests.0 | 10 | shareholding | 2020-02-20 | 100 | 100 | 100 | |
10.interests.1 | 10 | voting-rights | 2020-02-20 | 100 | 100 | 100 | |
11.interests.0 | 11 | shareholding | 2012-11-01 | 33 | 33 | 33 | |
11.interests.1 | 11 | voting-rights | 2012-11-01 | 33 | 33 | 33 | |
12.interests.0 | 12 | shareholding | 2001-01-23 | 100 | 100 | 100 | |
12.interests.1 | 12 | voting-rights | 2001-01-23 | 100 | 100 | 100 | |
15.interests.0 | 15 | shareholding | 2022-07-11 | 50 | 50 | 50 | |
15.interests.1 | 15 | voting-rights | 2022-07-11 | 50 | 50 | 50 | |
18.interests.0 | 18 | shareholding | 2003-10-01 | 100 | 100 | 100 | |
18.interests.1 | 18 | voting-rights | 2003-10-01 | 100 | 100 | 100 | |
24.interests.0 | 24 | shareholding | 2018-05-13 | 100 | 100 | 100 | |
24.interests.1 | 24 | voting-rights | 2018-05-13 | 100 | 100 | 100 | |
30.interests.0 | 30 | shareholding | 2001-01-01 | 100 | 100 | 100 | |
30.interests.1 | 30 | voting-rights | 2001-01-01 | 100 | 100 | 100 | |
31.interests.0 | 31 | shareholding | 2013-06-12 | 100 | 100 | 100 | |
31.interests.1 | 31 | voting-rights | 2013-06-12 | 100 | 100 | 100 | |
34.interests.0 | 34 | shareholding | 2012-06-04 | 100 | 100 | 100 | |
34.interests.1 | 34 | voting-rights | 2012-06-04 | 100 | 100 | 100 | |
35.interests.0 | 35 | shareholding | 2022-02-18 | 100 | 100 | 100 | |
35.interests.1 | 35 | voting-rights | 2022-02-18 | 100 | 100 | 100 | |
36.interests.0 | 36 | shareholding | 2018-09-04 | 18.55 | 18.55 | 18.55 | |
36.interests.1 | 36 | voting-rights | 2018-09-04 | 18.55 | 18.55 | 18.55 | |
39.interests.0 | 39 | voting-rights | 2018-10-23 | 100 | 100 | 100 | |
40.interests.0 | 40 | shareholding | 2016-06-07 | 50 | 50 | 50 | |
40.interests.1 | 40 | voting-rights | 2016-06-07 | 50 | 50 | 50 | |
43.interests.0 | 43 | shareholding | 2010-10-14 | 33.33 | 33.33 | 33.33 | |
43.interests.1 | 43 | voting-rights | 2010-10-14 | 33.33 | 33.33 | 33.33 | |
45.interests.0 | 45 | shareholding | 2018-02-27 | 100 | 100 | 100 | |
45.interests.1 | 45 | voting-rights | 2018-02-27 | 100 | 100 | 100 | |
46.interests.0 | 46 | shareholding | 2021-08-02 | 50 | 50 | 50 | |
46.interests.1 | 46 | voting-rights | 2021-08-02 | 50 | 50 | 50 | |
47.interests.0 | 47 | shareholding | 2009-01-29 | 100 | 100 | 100 | |
47.interests.1 | 47 | voting-rights | 2009-01-29 | 100 | 100 | 100 | |
48.interests.0 | 48 | shareholding | 2017-01-01 | 50 | 50 | 50 | |
48.interests.1 | 48 | voting-rights | 2017-01-01 | 50 | 50 | 50 | |
50.interests.0 | 50 | shareholding | 2013-05-21 | 100 | 100 | 100 | |
50.interests.1 | 50 | voting-rights | 2013-05-21 | 100 | 100 | 100 | |
51.interests.0 | 51 | shareholding | 2016-10-21 | 100 | 100 | 100 | |
51.interests.1 | 51 | voting-rights | 2016-10-21 | 100 | 100 | 100 | |
53.interests.0 | 53 | shareholding | 2021-03-29 | 25.5 | 25.5 | 25.5 | |
53.interests.1 | 53 | voting-rights | 2021-03-29 | 25.5 | 25.5 | 25.5 | |
56.interests.0 | 56 | shareholding | 2016-04-21 | 33.33 | 33.33 | 33.33 | |
56.interests.1 | 56 | voting-rights | 2016-04-21 | 33.33 | 33.33 | 33.33 | |
57.interests.0 | 57 | shareholding | 2019-04-15 | 100 | 100 | 100 | |
57.interests.1 | 57 | voting-rights | 2019-04-15 | 100 | 100 | 100 | |
58.interests.0 | 58 | shareholding | 2014-10-07 | 33.33 | 33.33 | 33.33 | |
58.interests.1 | 58 | voting-rights | 2014-10-07 | 20 | 20 | 20 | |
60.interests.0 | 60 | shareholding | 2015-12-23 | 100 | 100 | 100 | |
60.interests.1 | 60 | voting-rights | 2015-12-23 | 100 | 100 | 100 | |
63.interests.0 | 63 | shareholding | 2022-02-06 | 100 | 100 | 100 | |
63.interests.1 | 63 | voting-rights | 2022-02-06 | 100 | 100 | 100 | |
65.interests.0 | 65 | shareholding | 2002-02-04 | 100 | 100 | 100 | |
65.interests.1 | 65 | voting-rights | 2002-02-04 | 100 | 100 | 100 | |
66.interests.0 | 66 | shareholding | 2022-07-14 | 100 | 100 | 100 | |
66.interests.1 | 66 | voting-rights | 2022-07-14 | 100 | 100 | 100 | |
67.interests.0 | 67 | shareholding | 2021-10-15 | 50 | 50 | 50 | |
67.interests.1 | 67 | voting-rights | 2021-10-15 | 50 | 50 | 50 | |
68.interests.0 | 68 | shareholding | 2021-01-27 | 100 | 100 | 100 | |
68.interests.1 | 68 | voting-rights | 2021-01-27 | 100 | 100 | 100 | |
71.interests.0 | 71 | shareholding | 2017-01-20 | 90 | 90 | 90 | |
71.interests.1 | 71 | voting-rights | 2017-01-20 | 90 | 90 | 90 | |
72.interests.0 | 72 | shareholding | 2015-11-11 | 100 | 100 | 100 | |
72.interests.1 | 72 | voting-rights | 2015-11-11 | 100 | 100 | 100 | |
75.interests.0 | 75 | shareholding | 2010-06-22 | 100 | 100 | 100 | |
75.interests.1 | 75 | voting-rights | 2010-06-22 | 100 | 100 | 100 | |
77.interests.0 | 77 | shareholding | 2013-06-12 | 100 | 100 | 100 | |
77.interests.1 | 77 | voting-rights | 2013-06-12 | 100 | 100 | 100 | |
80.interests.0 | 80 | shareholding | 2022-06-02 | 25 | 25 | 25 | |
81.interests.0 | 81 | shareholding | 2016-09-01 | 28.89 | 28.89 | 28.89 | |
81.interests.1 | 81 | voting-rights | 2016-09-01 | 33.33 | 33.33 | 33.33 | |
83.interests.0 | 83 | shareholding | 2002-01-01 | 100 | 100 | 100 | |
83.interests.1 | 83 | voting-rights | 2002-01-01 | 100 | 100 | 100 | |
84.interests.0 | 84 | shareholding | 2018-03-06 | 100 | 100 | 100 | |
84.interests.1 | 84 | voting-rights | 2018-03-06 | 100 | 100 | 100 | |
85.interests.0 | 85 | shareholding | 2017-04-28 | 100 | 100 | 100 | |
85.interests.1 | 85 | voting-rights | 2017-04-28 | 100 | 100 | 100 | |
86.interests.0 | 86 | shareholding | 2019-06-11 | 100 | 100 | 100 | |
86.interests.1 | 86 | voting-rights | 2019-06-11 | 100 | 100 | 100 | |
87.interests.0 | 87 | shareholding | 2021-11-29 | 100 | 100 | 100 | |
87.interests.1 | 87 | voting-rights | 2021-11-29 | 100 | 100 | 100 | |
88.interests.0 | 88 | shareholding | 2015-06-15 | 100 | 100 | 100 | |
88.interests.1 | 88 | voting-rights | 2015-06-15 | 100 | 100 | 100 | |
90.interests.0 | 90 | shareholding | 2002-11-15 | 100 | 100 | 100 | |
90.interests.1 | 90 | voting-rights | 2002-11-15 | 100 | 100 | 100 | |
91.interests.0 | 91 | shareholding | 2011-06-15 | 100 | 100 | 100 | |
91.interests.1 | 91 | voting-rights | 2011-06-15 | 100 | 100 | 100 | |
92.interests.0 | 92 | shareholding | 2021-03-08 | 100 | 100 | 100 | |
92.interests.1 | 92 | voting-rights | 2021-03-08 | 100 | 100 | 100 | |
93.interests.0 | 93 | shareholding | 2020-11-01 | 50 | 50 | 50 | |
93.interests.1 | 93 | voting-rights | 2020-11-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]) );