ooc_interests
1,324,489 rows sorted by type descending
This data as json, CSV (advanced)
Suggested facets: enddate (date), startdate (date)
_link | _link_ooc_statement | type ▲ | enddate | startdate | share_exact | share_maximum | share_minimum | details | share_exclusiveminimum | share_exclusivemaximum |
---|---|---|---|---|---|---|---|---|---|---|
0.interests.1 | 0 | voting-rights | 2017-12-31 | 2010-04-21 | 50 | 50 | 50 | |||
1.interests.1 | 1 | voting-rights | 2019-01-01 | 2018-10-01 | 25 | 25 | 25 | |||
2.interests.1 | 2 | voting-rights | 2019-01-01 | 2018-10-01 | 25 | 25 | 25 | |||
3.interests.1 | 3 | voting-rights | 2008-07-04 | 6 | 6 | 6 | ||||
4.interests.1 | 4 | voting-rights | 2008-07-04 | 100 | 100 | 100 | ||||
5.interests.1 | 5 | voting-rights | 2021-03-11 | 100 | 100 | 100 | ||||
6.interests.1 | 6 | voting-rights | 2018-11-18 | 100 | 100 | 100 | ||||
7.interests.1 | 7 | voting-rights | 2018-09-15 | 30 | 30 | 30 | ||||
8.interests.1 | 8 | voting-rights | 2018-09-15 | 30 | 30 | 30 | ||||
9.interests.1 | 9 | voting-rights | 2009-12-31 | 50 | 50 | 50 | ||||
10.interests.1 | 10 | voting-rights | 1993-01-14 | 80 | 80 | 80 | ||||
13.interests.1 | 13 | voting-rights | 2017-12-29 | 1988-01-01 | 50 | 50 | 50 | |||
14.interests.1 | 14 | voting-rights | 2018-10-02 | 2015-04-28 | 100 | 100 | 100 | |||
16.interests.1 | 16 | voting-rights | 2020-03-05 | 90 | 90 | 90 | ||||
17.interests.1 | 17 | voting-rights | 2019-12-20 | 2005-05-18 | 100 | 100 | 100 | |||
18.interests.1 | 18 | voting-rights | 2005-05-18 | 100 | 100 | 100 | ||||
20.interests.1 | 20 | voting-rights | 2021-12-31 | 2002-12-31 | 24 | 24 | 24 | |||
22.interests.1 | 22 | voting-rights | 2002-10-15 | 41 | 41 | 41 | ||||
24.interests.1 | 24 | voting-rights | 2021-12-31 | 2014-03-28 | 51 | 51 | 51 | |||
25.interests.1 | 25 | voting-rights | 2021-12-31 | 2002-12-20 | 43.37 | 43.37 | 43.37 | |||
26.interests.1 | 26 | voting-rights | 2021-06-23 | 50 | 50 | 50 | ||||
27.interests.1 | 27 | voting-rights | 2017-07-01 | 50 | 50 | 50 | ||||
28.interests.1 | 28 | voting-rights | 2017-01-02 | 100 | 100 | 100 | ||||
29.interests.1 | 29 | voting-rights | 2017-01-02 | 100 | 100 | 100 | ||||
30.interests.1 | 30 | voting-rights | 2016-06-30 | 100 | 100 | 100 | ||||
31.interests.1 | 31 | voting-rights | 2016-06-30 | 100 | 100 | 100 | ||||
32.interests.1 | 32 | voting-rights | 2018-09-12 | 100 | 100 | 100 | ||||
33.interests.1 | 33 | voting-rights | 2019-01-28 | 100 | 100 | 100 | ||||
34.interests.1 | 34 | voting-rights | 2018-09-12 | 100 | 100 | 100 | ||||
35.interests.1 | 35 | voting-rights | 2019-04-17 | 100 | 100 | 100 | ||||
36.interests.1 | 36 | voting-rights | 2020-10-07 | 100 | 100 | 100 | ||||
37.interests.1 | 37 | voting-rights | 2016-06-21 | 100 | 100 | 100 | ||||
38.interests.1 | 38 | voting-rights | 2016-07-06 | 100 | 100 | 100 | ||||
39.interests.1 | 39 | voting-rights | 2013-03-25 | 60 | 60 | 60 | ||||
40.interests.1 | 40 | voting-rights | 2018-06-08 | 100 | 100 | 100 | ||||
41.interests.1 | 41 | voting-rights | 1999-10-16 | 33.33 | 33.33 | 33.33 | ||||
42.interests.1 | 42 | voting-rights | 1998-05-25 | 100 | 100 | 100 | ||||
43.interests.1 | 43 | voting-rights | 2017-10-02 | 75 | 75 | 75 | ||||
44.interests.1 | 44 | voting-rights | 2021-10-31 | 33.33 | 33.33 | 33.33 | ||||
45.interests.1 | 45 | voting-rights | 2014-01-01 | 100 | 100 | 100 | ||||
46.interests.1 | 46 | voting-rights | 2016-12-21 | 100 | 100 | 100 | ||||
47.interests.1 | 47 | voting-rights | 2022-03-09 | 2020-09-23 | 100 | 100 | 100 | |||
48.interests.1 | 48 | voting-rights | 2013-09-16 | 100 | 100 | 100 | ||||
49.interests.1 | 49 | voting-rights | 2021-01-01 | 100 | 100 | 100 | ||||
52.interests.1 | 52 | voting-rights | 2018-12-04 | 100 | 100 | 100 | ||||
53.interests.1 | 53 | voting-rights | 2021-05-01 | 2018-12-18 | 50 | 50 | 50 | |||
54.interests.1 | 54 | voting-rights | 2022-08-17 | 50 | 50 | 50 | ||||
55.interests.1 | 55 | voting-rights | 2018-03-23 | 100 | 100 | 100 | ||||
56.interests.1 | 56 | voting-rights | 2022-07-05 | 100 | 100 | 100 | ||||
58.interests.1 | 58 | voting-rights | 2019-12-03 | 2016-06-23 | 100 | 100 | 100 | |||
59.interests.1 | 59 | voting-rights | 2016-06-23 | 100 | 100 | 100 | ||||
60.interests.1 | 60 | voting-rights | 2008-04-01 | 50 | 50 | 50 | ||||
61.interests.1 | 61 | voting-rights | 1992-08-20 | 100 | 100 | 100 | ||||
62.interests.1 | 62 | voting-rights | 2022-06-29 | 100 | 100 | 100 | ||||
64.interests.1 | 64 | voting-rights | 2018-06-12 | 2004-02-18 | 100 | 100 | 100 | |||
65.interests.1 | 65 | voting-rights | 2019-06-06 | 100 | 100 | 100 | ||||
66.interests.1 | 66 | voting-rights | 2008-12-09 | 100 | 100 | 100 | ||||
67.interests.1 | 67 | voting-rights | 2008-12-09 | 100 | 100 | 100 | ||||
68.interests.1 | 68 | voting-rights | 2018-09-27 | 50 | 50 | 50 | ||||
69.interests.1 | 69 | voting-rights | 2018-09-27 | 100 | 100 | 100 | ||||
70.interests.1 | 70 | voting-rights | 2018-09-27 | 50 | 50 | 50 | ||||
71.interests.1 | 71 | voting-rights | 2007-01-01 | 100 | 100 | 100 | ||||
72.interests.1 | 72 | voting-rights | 2021-07-09 | 2021-06-30 | 50 | 50 | 50 | |||
73.interests.1 | 73 | voting-rights | 2021-07-09 | 100 | 100 | 100 | ||||
74.interests.1 | 74 | voting-rights | 2022-08-27 | 50 | 50 | 50 | ||||
75.interests.1 | 75 | voting-rights | 2007-03-13 | 50 | 50 | 50 | ||||
76.interests.1 | 76 | voting-rights | 2021-07-14 | 50 | 50 | 50 | ||||
77.interests.1 | 77 | voting-rights | 2021-05-06 | 100 | 100 | 100 | ||||
78.interests.1 | 78 | voting-rights | 2019-01-01 | 2018-11-02 | 50 | 50 | 50 | |||
79.interests.1 | 79 | voting-rights | 2021-05-03 | 100 | 100 | 100 | ||||
80.interests.1 | 80 | voting-rights | 2019-01-14 | 100 | 100 | 100 | ||||
81.interests.1 | 81 | voting-rights | 2022-05-29 | 100 | 100 | 100 | ||||
82.interests.1 | 82 | voting-rights | 2017-10-30 | 100 | 100 | 100 | ||||
83.interests.1 | 83 | voting-rights | 2017-12-31 | 100 | 100 | 100 | ||||
94.interests.1 | 94 | voting-rights | 2020-03-12 | 50 | 50 | 50 | ||||
95.interests.1 | 95 | voting-rights | 2020-04-14 | 50 | 50 | 50 | ||||
96.interests.1 | 96 | voting-rights | 2021-07-14 | 50 | 50 | 50 | ||||
97.interests.1 | 97 | voting-rights | 2013-12-03 | 100 | 100 | 100 | ||||
98.interests.1 | 98 | voting-rights | 2004-02-18 | 100 | 100 | 100 | ||||
99.interests.1 | 99 | voting-rights | 2007-10-01 | 100 | 100 | 100 | ||||
100.interests.1 | 100 | voting-rights | 2004-02-18 | 100 | 100 | 100 | ||||
101.interests.1 | 101 | voting-rights | 2022-08-15 | 100 | 100 | 100 | ||||
102.interests.1 | 102 | voting-rights | 2022-08-16 | 100 | 100 | 100 | ||||
103.interests.1 | 103 | voting-rights | 2022-05-26 | 2010-10-15 | 50 | 50 | 50 | |||
104.interests.1 | 104 | voting-rights | 2017-04-11 | 100 | 100 | 100 | ||||
105.interests.1 | 105 | voting-rights | 2017-09-20 | 100 | 100 | 100 | ||||
106.interests.1 | 106 | voting-rights | 2022-06-08 | 2022-06-08 | 50 | 50 | 50 | |||
107.interests.1 | 107 | voting-rights | 2022-08-02 | 2018-10-16 | 27.6 | 27.6 | 27.6 | |||
108.interests.1 | 108 | voting-rights | 2020-01-10 | 100 | 100 | 100 | ||||
110.interests.1 | 110 | voting-rights | 2018-02-01 | 100 | 100 | 100 | ||||
111.interests.1 | 111 | voting-rights | 2018-02-01 | 100 | 100 | 100 | ||||
112.interests.1 | 112 | voting-rights | 2020-08-11 | 100 | 100 | 100 | ||||
113.interests.1 | 113 | voting-rights | 2020-01-07 | 100 | 100 | 100 | ||||
114.interests.1 | 114 | voting-rights | 1993-03-01 | 50 | 50 | 50 | ||||
115.interests.1 | 115 | voting-rights | 2020-04-30 | 2017-10-17 | 25 | 25 | 25 | |||
116.interests.1 | 116 | voting-rights | 2017-07-17 | 33.33 | 33.33 | 33.33 | ||||
118.interests.1 | 118 | voting-rights | 2001-01-18 | 90 | 90 | 90 | ||||
119.interests.1 | 119 | voting-rights | 2011-06-30 | 90 | 90 | 90 | ||||
120.interests.1 | 120 | voting-rights | 2019-02-06 | 2017-03-03 | 100 | 100 | 100 | |||
121.interests.1 | 121 | voting-rights | 2007-03-29 | 90 | 90 | 90 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [ooc_interests] ( [_link] TEXT , [_link_ooc_statement] TEXT , [type] TEXT , [enddate] TEXT , [startdate] TEXT , [share_exact] NUMERIC , [share_maximum] NUMERIC , [share_minimum] NUMERIC , [details] TEXT , [share_exclusiveminimum] BOOL , [share_exclusivemaximum] BOOL , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );