ooc_interests
1,826,491 rows sorted by share_minimum
This data as json, CSV (advanced)
Suggested facets: startdate (date)
These facets timed out: enddate
_link | _link_ooc_statement | type | startdate | share_exact | share_maximum | share_minimum ▼ | enddate |
---|---|---|---|---|---|---|---|
3466.interests.0 | 3466 | shareholding | 2020-06-04 | 0 | 0 | 0 | |
4243.interests.0 | 4243 | shareholding | 2020-06-04 | 0 | 0 | 0 | |
21150.interests.1 | 21150 | voting-rights | 2012-12-26 | 0 | 0 | 0 | |
29793.interests.0 | 29793 | shareholding | 2019-11-20 | 0 | 0 | 0 | |
29919.interests.1 | 29919 | voting-rights | 2016-10-03 | 0 | 0 | 0 | |
30048.interests.0 | 30048 | shareholding | 2021-07-30 | 0 | 0 | 0 | |
30495.interests.0 | 30495 | shareholding | 2021-07-30 | 0 | 0 | 0 | |
30511.interests.1 | 30511 | voting-rights | 2016-10-03 | 0 | 0 | 0 | |
30545.interests.0 | 30545 | shareholding | 2019-11-21 | 0 | 0 | 0 | |
30999.interests.1 | 30999 | voting-rights | 2016-10-03 | 0 | 0 | 0 | 2021-11-09 |
31049.interests.0 | 31049 | shareholding | 2021-10-15 | 0 | 0 | 0 | |
32370.interests.0 | 32370 | shareholding | 2021-03-18 | 0 | 0 | 0 | 2021-03-18 |
34001.interests.0 | 34001 | shareholding | 2019-11-20 | 0 | 0 | 0 | |
35300.interests.0 | 35300 | shareholding | 2019-11-20 | 0 | 0 | 0 | |
35461.interests.1 | 35461 | voting-rights | 2016-10-03 | 0 | 0 | 0 | |
46549.interests.1 | 46549 | voting-rights | 2012-12-26 | 0 | 0 | 0 | |
46630.interests.0 | 46630 | shareholding | 2021-11-23 | 0 | 0 | 0 | |
71687.interests.1 | 71687 | voting-rights | 2013-06-24 | 0 | 0 | 0 | |
75578.interests.1 | 75578 | voting-rights | 2016-10-03 | 0 | 0 | 0 | |
75705.interests.0 | 75705 | shareholding | 2021-05-01 | 0 | 0 | 0 | |
76302.interests.0 | 76302 | shareholding | 2021-10-01 | 0 | 0 | 0 | |
78055.interests.1 | 78055 | voting-rights | 2016-10-03 | 0 | 0 | 0 | 2021-11-09 |
79467.interests.0 | 79467 | shareholding | 2018-03-01 | 0 | 0 | 0 | |
79812.interests.0 | 79812 | shareholding | 2021-05-01 | 0 | 0 | 0 | |
80110.interests.0 | 80110 | shareholding | 2015-06-26 | 0 | 0 | 0 | |
80976.interests.1 | 80976 | voting-rights | 2016-10-03 | 0 | 0 | 0 | |
81353.interests.1 | 81353 | voting-rights | 2016-10-03 | 0 | 0 | 0 | |
82114.interests.0 | 82114 | shareholding | 2021-05-01 | 0 | 0 | 0 | |
90894.interests.0 | 90894 | shareholding | 2018-07-04 | 0 | 0 | 0 | |
92896.interests.0 | 92896 | shareholding | 2019-11-13 | 0 | 0 | 0 | |
93576.interests.0 | 93576 | shareholding | 2019-11-13 | 0 | 0 | 0 | |
109402.interests.0 | 109402 | shareholding | 2018-09-03 | 0 | 0 | 0 | |
109541.interests.0 | 109541 | shareholding | 2018-09-03 | 0 | 0 | 0 | |
148223.interests.0 | 148223 | shareholding | 2021-04-29 | 0 | 0 | 0 | |
153040.interests.0 | 153040 | shareholding | 2016-11-26 | 0 | 0 | 0 | |
153049.interests.0 | 153049 | shareholding | 2016-11-12 | 0 | 0 | 0 | |
157971.interests.0 | 157971 | shareholding | 2021-03-25 | 0 | 0 | 0 | |
159580.interests.0 | 159580 | shareholding | 2021-11-23 | 0 | 0 | 0 | |
160360.interests.0 | 160360 | shareholding | 2015-06-26 | 0 | 0 | 0 | |
168299.interests.0 | 168299 | shareholding | 2002-05-14 | 0 | 0 | 0 | |
169121.interests.0 | 169121 | shareholding | 2008-04-02 | 0 | 0 | 0 | |
170240.interests.0 | 170240 | shareholding | 2021-03-25 | 0 | 0 | 0 | |
181283.interests.0 | 181283 | shareholding | 2021-07-30 | 0 | 0 | 0 | |
183190.interests.0 | 183190 | shareholding | 2021-07-30 | 0 | 0 | 0 | |
184187.interests.0 | 184187 | shareholding | 2021-07-30 | 0 | 0 | 0 | |
187503.interests.0 | 187503 | shareholding | 2022-04-08 | 0 | 0 | 0 | |
191306.interests.0 | 191306 | shareholding | 2022-04-08 | 0 | 0 | 0 | |
195159.interests.0 | 195159 | shareholding | 2013-08-06 | 0 | 0 | 0 | 2018-10-23 |
196342.interests.0 | 196342 | shareholding | 2013-08-06 | 0 | 0 | 0 | 2018-10-23 |
197804.interests.0 | 197804 | shareholding | 2013-08-06 | 0 | 0 | 0 | 2018-10-23 |
200474.interests.0 | 200474 | shareholding | 2013-08-07 | 0 | 0 | 0 | 2018-10-23 |
202142.interests.0 | 202142 | shareholding | 2013-08-06 | 0 | 0 | 0 | 2018-10-23 |
238163.interests.0 | 238163 | shareholding | 2022-03-15 | 0 | 0 | 0 | |
244336.interests.0 | 244336 | shareholding | 2022-01-20 | 0 | 0 | 0 | |
264222.interests.0 | 264222 | shareholding | 2022-10-04 | 0 | 0 | 0 | |
266217.interests.1 | 266217 | voting-rights | 2020-12-15 | 0 | 0 | 0 | |
268205.interests.0 | 268205 | shareholding | 2020-10-06 | 0 | 0 | 0 | |
270148.interests.0 | 270148 | shareholding | 2020-11-06 | 0 | 0 | 0 | |
272731.interests.0 | 272731 | shareholding | 2020-12-08 | 0 | 0 | 0 | |
273967.interests.0 | 273967 | shareholding | 2020-12-08 | 0 | 0 | 0 | |
274599.interests.0 | 274599 | shareholding | 2020-10-06 | 0 | 0 | 0 | |
294479.interests.0 | 294479 | shareholding | 2020-09-04 | 0 | 0 | 0 | |
300992.interests.0 | 300992 | shareholding | 2021-02-19 | 0 | 0 | 0 | |
305216.interests.0 | 305216 | shareholding | 2021-02-19 | 0 | 0 | 0 | |
305425.interests.0 | 305425 | shareholding | 2019-02-04 | 0 | 0 | 0 | |
308326.interests.0 | 308326 | shareholding | 2016-12-01 | 0 | 0 | 0 | |
317092.interests.0 | 317092 | shareholding | 2020-06-24 | 0 | 0 | 0 | |
349650.interests.0 | 349650 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
353719.interests.0 | 353719 | shareholding | 2019-12-30 | 0 | 0 | 0 | |
355742.interests.1 | 355742 | voting-rights | 2022-04-23 | 0 | 0 | 0 | |
358560.interests.0 | 358560 | shareholding | 2021-12-20 | 0 | 0 | 0 | |
359117.interests.0 | 359117 | shareholding | 2021-12-20 | 0 | 0 | 0 | |
364333.interests.0 | 364333 | shareholding | 2021-12-20 | 0 | 0 | 0 | |
378473.interests.0 | 378473 | shareholding | 2008-08-15 | 0 | 0 | 0 | |
380421.interests.0 | 380421 | shareholding | 2019-05-31 | 0 | 0 | 0 | |
385069.interests.0 | 385069 | shareholding | 2018-09-03 | 0 | 0 | 0 | |
385094.interests.0 | 385094 | shareholding | 2018-09-03 | 0 | 0 | 0 | |
389559.interests.0 | 389559 | shareholding | 2018-09-03 | 0 | 0 | 0 | |
404366.interests.0 | 404366 | shareholding | 2018-10-02 | 0 | 0 | 0 | |
411463.interests.0 | 411463 | shareholding | 2021-06-24 | 0 | 0 | 0 | |
413003.interests.0 | 413003 | shareholding | 2021-06-24 | 0 | 0 | 0 | |
413226.interests.0 | 413226 | shareholding | 2018-06-19 | 0 | 0 | 0 | 2019-12-04 |
413730.interests.0 | 413730 | shareholding | 2021-06-24 | 0 | 0 | 0 | |
415077.interests.0 | 415077 | shareholding | 2021-06-24 | 0 | 0 | 0 | |
415607.interests.0 | 415607 | shareholding | 2021-06-24 | 0 | 0 | 0 | |
421124.interests.0 | 421124 | shareholding | 2022-02-05 | 0 | 0 | 0 | |
422043.interests.0 | 422043 | shareholding | 2017-11-06 | 0 | 0 | 0 | |
422345.interests.0 | 422345 | shareholding | 2018-02-21 | 0 | 0 | 0 | |
427650.interests.0 | 427650 | shareholding | 2022-02-05 | 0 | 0 | 0 | |
434500.interests.0 | 434500 | shareholding | 2018-12-14 | 0 | 0 | 0 | |
435134.interests.0 | 435134 | shareholding | 2018-12-14 | 0 | 0 | 0 | |
437668.interests.0 | 437668 | shareholding | 2018-09-12 | 0 | 0 | 0 | |
437866.interests.0 | 437866 | shareholding | 2018-09-12 | 0 | 0 | 0 | |
438064.interests.0 | 438064 | shareholding | 2020-01-27 | 0 | 0 | 0 | 2022-03-09 |
438064.interests.1 | 438064 | voting-rights | 2020-01-27 | 0 | 0 | 0 | 2022-03-09 |
454939.interests.0 | 454939 | shareholding | 2019-01-02 | 0 | 0 | 0 | |
468082.interests.0 | 468082 | shareholding | 2020-08-20 | 0 | 0 | 0 | |
468668.interests.0 | 468668 | shareholding | 2021-01-01 | 0 | 0 | 0 | |
468668.interests.1 | 468668 | voting-rights | 2021-01-01 | 0 | 0 | 0 | |
471228.interests.0 | 471228 | shareholding | 2022-11-16 | 0 | 0 | 0 |
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]) );