ooc_interests
1,324,489 rows sorted by share_exclusiveminimum
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.0 | 0 | shareholding | 2017-12-31 | 2010-04-21 | 50 | 50 | 50 | |||
0.interests.1 | 0 | voting-rights | 2017-12-31 | 2010-04-21 | 50 | 50 | 50 | |||
1.interests.0 | 1 | shareholding | 2019-01-01 | 2018-10-01 | 25 | 25 | 25 | |||
1.interests.1 | 1 | voting-rights | 2019-01-01 | 2018-10-01 | 25 | 25 | 25 | |||
2.interests.0 | 2 | shareholding | 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.0 | 3 | shareholding | 2008-07-04 | 25.040000000000003 | 25.040000000000003 | 25.040000000000003 | ||||
3.interests.1 | 3 | voting-rights | 2008-07-04 | 6 | 6 | 6 | ||||
4.interests.0 | 4 | shareholding | 2008-07-04 | 100 | 100 | 100 | ||||
4.interests.1 | 4 | voting-rights | 2008-07-04 | 100 | 100 | 100 | ||||
5.interests.0 | 5 | shareholding | 2021-03-11 | 100 | 100 | 100 | ||||
5.interests.1 | 5 | voting-rights | 2021-03-11 | 100 | 100 | 100 | ||||
6.interests.0 | 6 | shareholding | 2018-11-18 | 100 | 100 | 100 | ||||
6.interests.1 | 6 | voting-rights | 2018-11-18 | 100 | 100 | 100 | ||||
7.interests.0 | 7 | shareholding | 2018-09-15 | 30 | 30 | 30 | ||||
7.interests.1 | 7 | voting-rights | 2018-09-15 | 30 | 30 | 30 | ||||
8.interests.0 | 8 | shareholding | 2018-09-15 | 30 | 30 | 30 | ||||
8.interests.1 | 8 | voting-rights | 2018-09-15 | 30 | 30 | 30 | ||||
9.interests.0 | 9 | shareholding | 2009-12-31 | 50 | 50 | 50 | ||||
9.interests.1 | 9 | voting-rights | 2009-12-31 | 50 | 50 | 50 | ||||
10.interests.0 | 10 | shareholding | 1993-01-14 | 80 | 80 | 80 | ||||
10.interests.1 | 10 | voting-rights | 1993-01-14 | 80 | 80 | 80 | ||||
13.interests.0 | 13 | shareholding | 2017-12-29 | 1988-01-01 | 50 | 50 | 50 | |||
13.interests.1 | 13 | voting-rights | 2017-12-29 | 1988-01-01 | 50 | 50 | 50 | |||
14.interests.0 | 14 | shareholding | 2018-10-02 | 2015-04-28 | 100 | 100 | 100 | |||
14.interests.1 | 14 | voting-rights | 2018-10-02 | 2015-04-28 | 100 | 100 | 100 | |||
15.interests.0 | 15 | shareholding | 2011-04-01 | 50 | 50 | 50 | ||||
16.interests.0 | 16 | shareholding | 2020-03-05 | 10 | 10 | 10 | ||||
16.interests.1 | 16 | voting-rights | 2020-03-05 | 90 | 90 | 90 | ||||
17.interests.0 | 17 | shareholding | 2019-12-20 | 2005-05-18 | 100 | 100 | 100 | |||
17.interests.1 | 17 | voting-rights | 2019-12-20 | 2005-05-18 | 100 | 100 | 100 | |||
18.interests.0 | 18 | shareholding | 2005-05-18 | 100 | 100 | 100 | ||||
18.interests.1 | 18 | voting-rights | 2005-05-18 | 100 | 100 | 100 | ||||
20.interests.0 | 20 | shareholding | 2021-12-31 | 2002-12-31 | 24 | 24 | 24 | |||
20.interests.1 | 20 | voting-rights | 2021-12-31 | 2002-12-31 | 24 | 24 | 24 | |||
22.interests.0 | 22 | shareholding | 2002-10-15 | 41 | 41 | 41 | ||||
22.interests.1 | 22 | voting-rights | 2002-10-15 | 41 | 41 | 41 | ||||
24.interests.0 | 24 | shareholding | 2021-12-31 | 2014-03-28 | 51 | 51 | 51 | |||
24.interests.1 | 24 | voting-rights | 2021-12-31 | 2014-03-28 | 51 | 51 | 51 | |||
25.interests.0 | 25 | shareholding | 2021-12-31 | 2002-12-20 | 43.37 | 43.37 | 43.37 | |||
25.interests.1 | 25 | voting-rights | 2021-12-31 | 2002-12-20 | 43.37 | 43.37 | 43.37 | |||
26.interests.0 | 26 | shareholding | 2021-06-23 | 50 | 50 | 50 | ||||
26.interests.1 | 26 | voting-rights | 2021-06-23 | 50 | 50 | 50 | ||||
27.interests.0 | 27 | shareholding | 2017-07-01 | 50 | 50 | 50 | ||||
27.interests.1 | 27 | voting-rights | 2017-07-01 | 50 | 50 | 50 | ||||
28.interests.0 | 28 | shareholding | 2017-01-02 | 100 | 100 | 100 | ||||
28.interests.1 | 28 | voting-rights | 2017-01-02 | 100 | 100 | 100 | ||||
29.interests.0 | 29 | shareholding | 2017-01-02 | 100 | 100 | 100 | ||||
29.interests.1 | 29 | voting-rights | 2017-01-02 | 100 | 100 | 100 | ||||
30.interests.0 | 30 | shareholding | 2016-06-30 | 100 | 100 | 100 | ||||
30.interests.1 | 30 | voting-rights | 2016-06-30 | 100 | 100 | 100 | ||||
31.interests.0 | 31 | shareholding | 2016-06-30 | 100 | 100 | 100 | ||||
31.interests.1 | 31 | voting-rights | 2016-06-30 | 100 | 100 | 100 | ||||
32.interests.0 | 32 | shareholding | 2018-09-12 | 100 | 100 | 100 | ||||
32.interests.1 | 32 | voting-rights | 2018-09-12 | 100 | 100 | 100 | ||||
33.interests.0 | 33 | shareholding | 2019-01-28 | 100 | 100 | 100 | ||||
33.interests.1 | 33 | voting-rights | 2019-01-28 | 100 | 100 | 100 | ||||
34.interests.0 | 34 | shareholding | 2018-09-12 | 100 | 100 | 100 | ||||
34.interests.1 | 34 | voting-rights | 2018-09-12 | 100 | 100 | 100 | ||||
35.interests.0 | 35 | shareholding | 2019-04-17 | 100 | 100 | 100 | ||||
35.interests.1 | 35 | voting-rights | 2019-04-17 | 100 | 100 | 100 | ||||
36.interests.0 | 36 | shareholding | 2020-10-07 | 100 | 100 | 100 | ||||
36.interests.1 | 36 | voting-rights | 2020-10-07 | 100 | 100 | 100 | ||||
37.interests.0 | 37 | shareholding | 2016-06-21 | 100 | 100 | 100 | ||||
37.interests.1 | 37 | voting-rights | 2016-06-21 | 100 | 100 | 100 | ||||
38.interests.0 | 38 | shareholding | 2016-07-06 | 100 | 100 | 100 | ||||
38.interests.1 | 38 | voting-rights | 2016-07-06 | 100 | 100 | 100 | ||||
39.interests.0 | 39 | shareholding | 2013-03-25 | 60 | 60 | 60 | ||||
39.interests.1 | 39 | voting-rights | 2013-03-25 | 60 | 60 | 60 | ||||
40.interests.0 | 40 | shareholding | 2018-06-08 | 100 | 100 | 100 | ||||
40.interests.1 | 40 | voting-rights | 2018-06-08 | 100 | 100 | 100 | ||||
41.interests.0 | 41 | shareholding | 1999-10-16 | 33.33 | 33.33 | 33.33 | ||||
41.interests.1 | 41 | voting-rights | 1999-10-16 | 33.33 | 33.33 | 33.33 | ||||
42.interests.0 | 42 | shareholding | 1998-05-25 | 100 | 100 | 100 | ||||
42.interests.1 | 42 | voting-rights | 1998-05-25 | 100 | 100 | 100 | ||||
43.interests.0 | 43 | shareholding | 2017-10-02 | 75 | 75 | 75 | ||||
43.interests.1 | 43 | voting-rights | 2017-10-02 | 75 | 75 | 75 | ||||
44.interests.0 | 44 | shareholding | 2021-10-31 | 33.33 | 33.33 | 33.33 | ||||
44.interests.1 | 44 | voting-rights | 2021-10-31 | 33.33 | 33.33 | 33.33 | ||||
45.interests.0 | 45 | shareholding | 2014-01-01 | 100 | 100 | 100 | ||||
45.interests.1 | 45 | voting-rights | 2014-01-01 | 100 | 100 | 100 | ||||
46.interests.0 | 46 | shareholding | 2016-12-21 | 100 | 100 | 100 | ||||
46.interests.1 | 46 | voting-rights | 2016-12-21 | 100 | 100 | 100 | ||||
47.interests.0 | 47 | shareholding | 2022-03-09 | 2020-09-23 | 100 | 100 | 100 | |||
47.interests.1 | 47 | voting-rights | 2022-03-09 | 2020-09-23 | 100 | 100 | 100 | |||
48.interests.0 | 48 | shareholding | 2013-09-16 | 100 | 100 | 100 | ||||
48.interests.1 | 48 | voting-rights | 2013-09-16 | 100 | 100 | 100 | ||||
49.interests.0 | 49 | shareholding | 2021-01-01 | 100 | 100 | 100 | ||||
49.interests.1 | 49 | voting-rights | 2021-01-01 | 100 | 100 | 100 | ||||
52.interests.0 | 52 | shareholding | 2018-12-04 | 100 | 100 | 100 | ||||
52.interests.1 | 52 | voting-rights | 2018-12-04 | 100 | 100 | 100 | ||||
53.interests.0 | 53 | shareholding | 2021-05-01 | 2018-12-18 | 50 | 50 | 50 | |||
53.interests.1 | 53 | voting-rights | 2021-05-01 | 2018-12-18 | 50 | 50 | 50 | |||
54.interests.0 | 54 | shareholding | 2022-08-17 | 50 | 50 | 50 | ||||
54.interests.1 | 54 | voting-rights | 2022-08-17 | 50 | 50 | 50 | ||||
55.interests.0 | 55 | shareholding | 2018-03-23 | 100 | 100 | 100 | ||||
55.interests.1 | 55 | voting-rights | 2018-03-23 | 100 | 100 | 100 | ||||
56.interests.0 | 56 | shareholding | 2022-07-05 | 100 | 100 | 100 | ||||
56.interests.1 | 56 | voting-rights | 2022-07-05 | 100 | 100 | 100 | ||||
58.interests.0 | 58 | shareholding | 2019-12-03 | 2016-06-23 | 100 | 100 | 100 |
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]) );