ooc_interests
1,826,491 rows sorted by type descending
This data as json, CSV (advanced)
Suggested facets: startdate (date), enddate (date)
_link | _link_ooc_statement | type ▲ | startdate | share_exact | share_maximum | share_minimum | enddate |
---|---|---|---|---|---|---|---|
1.interests.1 | 1 | voting-rights | 2022-10-28 | 100 | 100 | 100 | |
2.interests.1 | 2 | voting-rights | 2012-03-20 | 27 | 27 | 27 | 2018-10-01 |
3.interests.1 | 3 | voting-rights | 2011-06-18 | 50 | 50 | 50 | |
4.interests.1 | 4 | voting-rights | 2017-04-28 | 100 | 100 | 100 | |
6.interests.1 | 6 | voting-rights | 2022-09-28 | 100 | 100 | 100 | |
7.interests.1 | 7 | voting-rights | 2017-09-01 | 29.4 | 29.4 | 29.4 | 2018-03-20 |
8.interests.1 | 8 | voting-rights | 2006-05-19 | 100 | 100 | 100 | 2019-09-30 |
9.interests.1 | 9 | voting-rights | 2018-06-17 | 100 | 100 | 100 | |
10.interests.1 | 10 | voting-rights | 2020-02-20 | 100 | 100 | 100 | |
11.interests.1 | 11 | voting-rights | 2012-11-01 | 33 | 33 | 33 | |
12.interests.1 | 12 | voting-rights | 2001-01-23 | 100 | 100 | 100 | |
14.interests.1 | 14 | voting-rights | 2016-06-27 | 80 | 80 | 80 | 2022-08-31 |
15.interests.1 | 15 | voting-rights | 2022-07-11 | 50 | 50 | 50 | |
16.interests.1 | 16 | voting-rights | 2015-10-19 | 100 | 100 | 100 | 2020-11-09 |
17.interests.1 | 17 | voting-rights | 2010-11-01 | 50 | 50 | 50 | 2020-12-21 |
18.interests.1 | 18 | voting-rights | 2003-10-01 | 100 | 100 | 100 | |
19.interests.1 | 19 | voting-rights | 2017-07-01 | 50 | 50 | 50 | 2018-09-30 |
20.interests.1 | 20 | voting-rights | 2017-02-21 | 100 | 100 | 100 | 2022-03-15 |
21.interests.1 | 21 | voting-rights | 2015-01-07 | 50 | 50 | 50 | 2018-01-31 |
23.interests.1 | 23 | voting-rights | 2011-03-24 | 100 | 100 | 100 | 2018-11-02 |
24.interests.1 | 24 | voting-rights | 2018-05-13 | 100 | 100 | 100 | |
26.interests.1 | 26 | voting-rights | 2019-04-22 | 3 | 3 | 3 | 2021-03-01 |
30.interests.1 | 30 | voting-rights | 2001-01-01 | 100 | 100 | 100 | |
31.interests.1 | 31 | voting-rights | 2013-06-12 | 100 | 100 | 100 | |
34.interests.1 | 34 | voting-rights | 2012-06-04 | 100 | 100 | 100 | |
35.interests.1 | 35 | voting-rights | 2022-02-18 | 100 | 100 | 100 | |
36.interests.1 | 36 | voting-rights | 2018-09-04 | 18.55 | 18.55 | 18.55 | |
38.interests.0 | 38 | voting-rights | 2017-11-06 | 20 | 20 | 20 | 2018-12-31 |
39.interests.0 | 39 | voting-rights | 2018-10-23 | 100 | 100 | 100 | |
40.interests.1 | 40 | voting-rights | 2016-06-07 | 50 | 50 | 50 | |
41.interests.1 | 41 | voting-rights | 2013-12-19 | 50 | 50 | 50 | 2020-11-12 |
42.interests.1 | 42 | voting-rights | 2009-06-02 | 33.33 | 33.33 | 33.33 | 2021-05-21 |
43.interests.1 | 43 | voting-rights | 2010-10-14 | 33.33 | 33.33 | 33.33 | |
44.interests.1 | 44 | voting-rights | 2016-12-23 | 33 | 33 | 33 | 2020-06-08 |
45.interests.1 | 45 | voting-rights | 2018-02-27 | 100 | 100 | 100 | |
46.interests.1 | 46 | voting-rights | 2021-08-02 | 50 | 50 | 50 | |
47.interests.1 | 47 | voting-rights | 2009-01-29 | 100 | 100 | 100 | |
48.interests.1 | 48 | voting-rights | 2017-01-01 | 50 | 50 | 50 | |
50.interests.1 | 50 | voting-rights | 2013-05-21 | 100 | 100 | 100 | |
51.interests.1 | 51 | voting-rights | 2016-10-21 | 100 | 100 | 100 | |
52.interests.1 | 52 | voting-rights | 2017-10-05 | 50 | 50 | 50 | 2019-11-27 |
53.interests.1 | 53 | voting-rights | 2021-03-29 | 25.5 | 25.5 | 25.5 | |
54.interests.1 | 54 | voting-rights | 2015-09-07 | 100 | 100 | 100 | 2022-10-06 |
55.interests.1 | 55 | voting-rights | 2015-11-01 | 15 | 15 | 15 | 2019-12-01 |
56.interests.1 | 56 | voting-rights | 2016-04-21 | 33.33 | 33.33 | 33.33 | |
57.interests.1 | 57 | voting-rights | 2019-04-15 | 100 | 100 | 100 | |
58.interests.1 | 58 | voting-rights | 2014-10-07 | 20 | 20 | 20 | |
60.interests.1 | 60 | voting-rights | 2015-12-23 | 100 | 100 | 100 | |
61.interests.1 | 61 | voting-rights | 2019-06-14 | 35.089999999999996 | 35.089999999999996 | 35.089999999999996 | 2022-02-17 |
62.interests.1 | 62 | voting-rights | 1980-05-27 | 100 | 100 | 100 | 2018-08-29 |
63.interests.1 | 63 | voting-rights | 2022-02-06 | 100 | 100 | 100 | |
64.interests.1 | 64 | voting-rights | 2016-10-01 | 60 | 60 | 60 | 2018-09-30 |
65.interests.1 | 65 | voting-rights | 2002-02-04 | 100 | 100 | 100 | |
66.interests.1 | 66 | voting-rights | 2022-07-14 | 100 | 100 | 100 | |
67.interests.1 | 67 | voting-rights | 2021-10-15 | 50 | 50 | 50 | |
68.interests.1 | 68 | voting-rights | 2021-01-27 | 100 | 100 | 100 | |
69.interests.1 | 69 | voting-rights | 2018-09-01 | 100 | 100 | 100 | 2020-09-16 |
70.interests.1 | 70 | voting-rights | 2008-03-10 | 33.75 | 33.75 | 33.75 | 2020-01-09 |
71.interests.1 | 71 | voting-rights | 2017-01-20 | 90 | 90 | 90 | |
72.interests.1 | 72 | voting-rights | 2015-11-11 | 100 | 100 | 100 | |
73.interests.1 | 73 | voting-rights | 2019-05-15 | 40 | 40 | 40 | 2022-10-06 |
75.interests.1 | 75 | voting-rights | 2010-06-22 | 100 | 100 | 100 | |
77.interests.1 | 77 | voting-rights | 2013-06-12 | 100 | 100 | 100 | |
78.interests.1 | 78 | voting-rights | 2008-02-27 | 50 | 50 | 50 | 2022-04-13 |
81.interests.1 | 81 | voting-rights | 2016-09-01 | 33.33 | 33.33 | 33.33 | |
83.interests.1 | 83 | voting-rights | 2002-01-01 | 100 | 100 | 100 | |
84.interests.1 | 84 | voting-rights | 2018-03-06 | 100 | 100 | 100 | |
85.interests.1 | 85 | voting-rights | 2017-04-28 | 100 | 100 | 100 | |
86.interests.1 | 86 | voting-rights | 2019-06-11 | 100 | 100 | 100 | |
87.interests.1 | 87 | voting-rights | 2021-11-29 | 100 | 100 | 100 | |
88.interests.1 | 88 | voting-rights | 2015-06-15 | 100 | 100 | 100 | |
89.interests.1 | 89 | voting-rights | 1996-12-27 | 50 | 50 | 50 | 2019-01-18 |
90.interests.1 | 90 | voting-rights | 2002-11-15 | 100 | 100 | 100 | |
91.interests.1 | 91 | voting-rights | 2011-06-15 | 100 | 100 | 100 | |
92.interests.1 | 92 | voting-rights | 2021-03-08 | 100 | 100 | 100 | |
93.interests.1 | 93 | voting-rights | 2020-11-01 | 50 | 50 | 50 | |
94.interests.1 | 94 | voting-rights | 2007-01-01 | 50 | 50 | 50 | 2021-12-31 |
95.interests.1 | 95 | voting-rights | 2017-10-09 | 100 | 100 | 100 | |
96.interests.1 | 96 | voting-rights | 2014-06-04 | 51 | 51 | 51 | |
97.interests.1 | 97 | voting-rights | 2015-07-17 | 100 | 100 | 100 | |
98.interests.1 | 98 | voting-rights | 2015-11-23 | 100 | 100 | 100 | |
99.interests.1 | 99 | voting-rights | 2014-02-06 | 33 | 33 | 33 | 2018-09-09 |
100.interests.1 | 100 | voting-rights | 2007-03-15 | 100 | 100 | 100 | 2018-05-28 |
101.interests.1 | 101 | voting-rights | 2021-11-14 | 100 | 100 | 100 | |
102.interests.1 | 102 | voting-rights | 1999-01-01 | 55.00000000000001 | 55.00000000000001 | 55.00000000000001 | |
104.interests.1 | 104 | voting-rights | 2021-10-10 | 50 | 50 | 50 | |
105.interests.1 | 105 | voting-rights | 2015-10-20 | 33 | 33 | 33 | 2020-11-19 |
108.interests.1 | 108 | voting-rights | 2015-08-03 | 29.049999999999997 | 29.049999999999997 | 29.049999999999997 | |
109.interests.1 | 109 | voting-rights | 2017-05-29 | 100 | 100 | 100 | |
110.interests.1 | 110 | voting-rights | 1980-03-15 | 84 | 84 | 84 | 2019-08-19 |
111.interests.1 | 111 | voting-rights | 2018-05-09 | 100 | 100 | 100 | 2021-09-13 |
112.interests.1 | 112 | voting-rights | 2012-12-21 | 34 | 34 | 34 | |
113.interests.1 | 113 | voting-rights | 2019-09-05 | 100 | 100 | 100 | 2021-09-20 |
114.interests.1 | 114 | voting-rights | 2011-01-01 | 50 | 50 | 50 | 2018-12-31 |
115.interests.1 | 115 | voting-rights | 2015-01-01 | 50 | 50 | 50 | |
116.interests.1 | 116 | voting-rights | 2017-11-01 | 100 | 100 | 100 | |
117.interests.1 | 117 | voting-rights | 2017-06-12 | 50 | 50 | 50 | 2019-11-04 |
118.interests.1 | 118 | voting-rights | 2019-02-11 | 100 | 100 | 100 | 2022-02-01 |
119.interests.1 | 119 | voting-rights | 2019-09-11 | 50 | 50 | 50 | 2022-09-30 |
121.interests.1 | 121 | voting-rights | 2021-01-01 | 21.67 | 21.67 | 21.67 |
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]) );