ooc_interests
1,324,489 rows sorted by startdate
This data as json, CSV (advanced)
_link | _link_ooc_statement | type | enddate | startdate ▼ | share_exact | share_maximum | share_minimum | details | share_exclusiveminimum | share_exclusivemaximum |
---|---|---|---|---|---|---|---|---|---|---|
80780.interests.0 | 80780 | shareholding | 1965-07-06 | 100 | 100 | 100 | ||||
80780.interests.1 | 80780 | voting-rights | 1965-07-06 | 100 | 100 | 100 | ||||
85056.interests.0 | 85056 | shareholding | 1965-07-30 | 100 | 100 | 100 | ||||
85056.interests.1 | 85056 | voting-rights | 1965-07-30 | 100 | 100 | 100 | ||||
531793.interests.0 | 531793 | shareholding | 2019-09-05 | 1966-01-19 | 50 | 50 | 50 | |||
531793.interests.1 | 531793 | voting-rights | 2019-09-05 | 1966-01-19 | 50 | 50 | 50 | |||
532049.interests.0 | 532049 | shareholding | 2022-06-30 | 1966-10-01 | 50 | 50 | 50 | |||
532049.interests.1 | 532049 | voting-rights | 2022-06-30 | 1966-10-01 | 50 | 50 | 50 | |||
614661.interests.0 | 614661 | shareholding | 2022-06-30 | 1966-10-01 | 50 | 50 | 50 | |||
614661.interests.1 | 614661 | voting-rights | 2022-06-30 | 1966-10-01 | 50 | 50 | 50 | |||
732711.interests.0 | 732711 | shareholding | 1967-01-14 | 50 | 50 | 50 | ||||
732711.interests.1 | 732711 | voting-rights | 1967-01-14 | 50 | 50 | 50 | ||||
757410.interests.0 | 757410 | shareholding | 1967-03-10 | 33 | 33 | 33 | ||||
757410.interests.1 | 757410 | voting-rights | 1967-03-10 | 83 | 83 | 83 | ||||
42954.interests.0 | 42954 | shareholding | 1967-04-20 | 21.61 | 21.61 | 21.61 | ||||
42954.interests.1 | 42954 | voting-rights | 1967-04-20 | 58.75 | 58.75 | 58.75 | ||||
10476.interests.0 | 10476 | shareholding | 2019-09-29 | 1967-07-03 | 100 | 100 | 100 | |||
10476.interests.1 | 10476 | voting-rights | 2019-09-29 | 1967-07-03 | 100 | 100 | 100 | |||
189273.interests.0 | 189273 | shareholding | 2019-12-31 | 1967-07-03 | 50 | 50 | 50 | |||
189273.interests.1 | 189273 | voting-rights | 2019-12-31 | 1967-07-03 | 50 | 50 | 50 | |||
444252.interests.0 | 444252 | shareholding | 2021-12-31 | 1967-07-03 | 50 | 50 | 50 | |||
444252.interests.1 | 444252 | voting-rights | 2021-12-31 | 1967-07-03 | 50 | 50 | 50 | |||
448749.interests.0 | 448749 | shareholding | 2018-12-31 | 1967-07-03 | 50 | 50 | 50 | |||
448749.interests.1 | 448749 | voting-rights | 2018-12-31 | 1967-07-03 | 50 | 50 | 50 | |||
52523.interests.0 | 52523 | shareholding | 1967-07-03 | 50 | 50 | 50 | ||||
52523.interests.1 | 52523 | voting-rights | 1967-07-03 | 50 | 50 | 50 | ||||
533123.interests.0 | 533123 | shareholding | 2018-12-31 | 1967-07-03 | 50 | 50 | 50 | |||
533123.interests.1 | 533123 | voting-rights | 2018-12-31 | 1967-07-03 | 50 | 50 | 50 | |||
57707.interests.0 | 57707 | shareholding | 1967-07-03 | 50 | 50 | 50 | ||||
57707.interests.1 | 57707 | voting-rights | 1967-07-03 | 50 | 50 | 50 | ||||
612713.interests.0 | 612713 | shareholding | 1967-07-03 | 25 | 25 | 25 | ||||
612713.interests.1 | 612713 | voting-rights | 1967-07-03 | 25 | 25 | 25 | ||||
680953.interests.0 | 680953 | shareholding | 2021-12-31 | 1967-07-03 | 50 | 50 | 50 | |||
680953.interests.1 | 680953 | voting-rights | 2021-12-31 | 1967-07-03 | 50 | 50 | 50 | |||
717760.interests.0 | 717760 | shareholding | 2019-12-31 | 1967-07-03 | 50 | 50 | 50 | |||
717760.interests.1 | 717760 | voting-rights | 2019-12-31 | 1967-07-03 | 50 | 50 | 50 | |||
757939.interests.0 | 757939 | shareholding | 1967-07-03 | 50 | 50 | 50 | ||||
757939.interests.1 | 757939 | voting-rights | 1967-07-03 | 50 | 50 | 50 | ||||
679591.interests.0 | 679591 | shareholding | 2021-01-14 | 1967-10-04 | 10.2 | 10.2 | 10.2 | |||
679591.interests.1 | 679591 | voting-rights | 2021-01-14 | 1967-10-04 | 53 | 53 | 53 | |||
102496.interests.0 | 102496 | shareholding | 2020-05-29 | 1967-11-01 | 100 | 100 | 100 | |||
102496.interests.1 | 102496 | voting-rights | 2020-05-29 | 1967-11-01 | 100 | 100 | 100 | |||
104681.interests.0 | 104681 | shareholding | 1967-11-01 | 100 | 100 | 100 | ||||
104681.interests.1 | 104681 | voting-rights | 1967-11-01 | 100 | 100 | 100 | ||||
157701.interests.0 | 157701 | shareholding | 2021-05-27 | 1967-11-01 | 100 | 100 | 100 | |||
157701.interests.1 | 157701 | voting-rights | 2021-05-27 | 1967-11-01 | 100 | 100 | 100 | |||
219168.interests.0 | 219168 | shareholding | 2021-05-27 | 1967-11-01 | 100 | 100 | 100 | |||
219168.interests.1 | 219168 | voting-rights | 2021-05-27 | 1967-11-01 | 100 | 100 | 100 | |||
462699.interests.0 | 462699 | shareholding | 2018-05-29 | 1967-11-01 | 100 | 100 | 100 | |||
462699.interests.1 | 462699 | voting-rights | 2018-05-29 | 1967-11-01 | 100 | 100 | 100 | |||
106975.interests.0 | 106975 | shareholding | 2019-09-30 | 1968-03-05 | 25 | 25 | 25 | |||
106975.interests.1 | 106975 | voting-rights | 2019-09-30 | 1968-03-05 | 25 | 25 | 25 | |||
158293.interests.0 | 158293 | shareholding | 2019-09-30 | 1968-03-05 | 25 | 25 | 25 | |||
158293.interests.1 | 158293 | voting-rights | 2019-09-30 | 1968-03-05 | 25 | 25 | 25 | |||
374924.interests.0 | 374924 | shareholding | 2019-09-30 | 1968-03-05 | 25 | 25 | 25 | |||
374924.interests.1 | 374924 | voting-rights | 2019-09-30 | 1968-03-05 | 25 | 25 | 25 | |||
500189.interests.0 | 500189 | shareholding | 2019-09-30 | 1968-03-05 | 25 | 25 | 25 | |||
500189.interests.1 | 500189 | voting-rights | 2019-09-30 | 1968-03-05 | 25 | 25 | 25 | |||
262107.interests.0 | 262107 | shareholding | 1968-09-01 | 50 | 50 | 50 | ||||
262107.interests.1 | 262107 | voting-rights | 1968-09-01 | 50 | 50 | 50 | ||||
538332.interests.0 | 538332 | shareholding | 1968-09-01 | 50 | 50 | 50 | ||||
538332.interests.1 | 538332 | voting-rights | 1968-09-01 | 50 | 50 | 50 | ||||
490987.interests.0 | 490987 | shareholding | 1968-10-02 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | ||||
490987.interests.1 | 490987 | voting-rights | 1968-10-02 | 33.300000000000004 | 33.300000000000004 | 33.300000000000004 | ||||
300044.interests.0 | 300044 | shareholding | 2018-11-29 | 1968-10-09 | 36.7 | 36.7 | 36.7 | |||
300044.interests.1 | 300044 | voting-rights | 2018-11-29 | 1968-10-09 | 36.7 | 36.7 | 36.7 | |||
600836.interests.0 | 600836 | shareholding | 1968-10-09 | 63.3 | 63.3 | 63.3 | ||||
600836.interests.1 | 600836 | voting-rights | 1968-10-09 | 100 | 100 | 100 | ||||
272193.interests.0 | 272193 | shareholding | 1968-10-30 | 100 | 100 | 100 | ||||
272193.interests.1 | 272193 | voting-rights | 1968-10-30 | 100 | 100 | 100 | ||||
234914.interests.0 | 234914 | shareholding | 1969-04-01 | 1.03 | 1.03 | 1.03 | ||||
234914.interests.1 | 234914 | voting-rights | 1969-04-01 | 33.51 | 33.51 | 33.51 | ||||
364543.interests.0 | 364543 | shareholding | 1969-04-01 | 1.03 | 1.03 | 1.03 | ||||
364543.interests.1 | 364543 | voting-rights | 1969-04-01 | 33.51 | 33.51 | 33.51 | ||||
447024.interests.0 | 447024 | shareholding | 2018-05-31 | 1969-09-01 | 100 | 100 | 100 | |||
447024.interests.1 | 447024 | voting-rights | 2018-05-31 | 1969-09-01 | 100 | 100 | 100 | |||
441261.interests.0 | 441261 | shareholding | 2018-02-27 | 1969-10-30 | 50 | 50 | 50 | |||
441261.interests.1 | 441261 | voting-rights | 2018-02-27 | 1969-10-30 | 50 | 50 | 50 | |||
764963.interests.0 | 764963 | shareholding | 2019-04-30 | 1969-10-30 | 50 | 50 | 50 | |||
764963.interests.1 | 764963 | voting-rights | 2019-04-30 | 1969-10-30 | 50 | 50 | 50 | |||
754177.interests.0 | 754177 | shareholding | 2021-01-20 | 1969-10-31 | 100 | 100 | 100 | |||
754177.interests.1 | 754177 | voting-rights | 2021-01-20 | 1969-10-31 | 100 | 100 | 100 | |||
304211.interests.0 | 304211 | shareholding | 1969-11-01 | 100 | 100 | 100 | ||||
304211.interests.1 | 304211 | voting-rights | 1969-11-01 | 100 | 100 | 100 | ||||
181760.interests.0 | 181760 | shareholding | 1969-11-05 | 100 | 100 | 100 | ||||
181760.interests.1 | 181760 | voting-rights | 1969-11-05 | 100 | 100 | 100 | ||||
291501.interests.0 | 291501 | shareholding | 2020-01-30 | 1969-11-17 | 100 | 100 | 100 | |||
291501.interests.1 | 291501 | voting-rights | 2020-01-30 | 1969-11-17 | 100 | 100 | 100 | |||
223113.interests.0 | 223113 | shareholding | 2021-05-27 | 1969-11-19 | 100 | 100 | 100 | |||
223113.interests.1 | 223113 | voting-rights | 2021-05-27 | 1969-11-19 | 100 | 100 | 100 | |||
702725.interests.0 | 702725 | shareholding | 1969-12-23 | 100 | 100 | 100 | ||||
702725.interests.1 | 702725 | voting-rights | 1969-12-23 | 100 | 100 | 100 | ||||
217071.interests.0 | 217071 | shareholding | 2022-08-15 | 1970-01-01 | 37.3 | 37.3 | 37.3 | |||
217071.interests.1 | 217071 | voting-rights | 2022-08-15 | 1970-01-01 | 37.3 | 37.3 | 37.3 | |||
248562.interests.0 | 248562 | shareholding | 2020-12-31 | 1970-01-01 | 50 | 50 | 50 | |||
248562.interests.1 | 248562 | voting-rights | 2020-12-31 | 1970-01-01 | 50 | 50 | 50 | |||
441372.interests.0 | 441372 | shareholding | 1970-01-01 | 100 | 100 | 100 | ||||
441372.interests.1 | 441372 | voting-rights | 1970-01-01 | 100 | 100 | 100 | ||||
442078.interests.0 | 442078 | shareholding | 2017-06-30 | 1970-01-01 | 100 | 100 | 100 | |||
442078.interests.1 | 442078 | voting-rights | 2017-06-30 | 1970-01-01 | 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]) );