ooc_interests
1,324,489 rows sorted by share_maximum
This data as json, CSV (advanced)
Suggested facets: enddate (date)
These facets timed out: startdate
_link | _link_ooc_statement | type | enddate | startdate | share_exact | share_maximum ▼ | share_minimum | details | share_exclusiveminimum | share_exclusivemaximum |
---|---|---|---|---|---|---|---|---|---|---|
7792.interests.0 | 7792 | shareholding | 2021-04-22 | 2019-07-31 | 0 | 0 | 0 | |||
7792.interests.1 | 7792 | voting-rights | 2021-04-22 | 2019-07-31 | 0 | 0 | 0 | |||
53891.interests.0 | 53891 | shareholding | 2009-09-28 | 0 | 0 | 0 | ||||
70448.interests.0 | 70448 | shareholding | 2016-11-26 | 0 | 0 | 0 | ||||
70449.interests.0 | 70449 | shareholding | 2016-11-12 | 0 | 0 | 0 | ||||
85190.interests.1 | 85190 | voting-rights | 2021-11-09 | 2016-10-03 | 0 | 0 | 0 | |||
85191.interests.1 | 85191 | voting-rights | 2016-10-03 | 0 | 0 | 0 | ||||
85192.interests.1 | 85192 | voting-rights | 2016-10-03 | 0 | 0 | 0 | ||||
85193.interests.1 | 85193 | voting-rights | 2016-10-03 | 0 | 0 | 0 | ||||
104017.interests.0 | 104017 | shareholding | 2021-10-15 | 0 | 0 | 0 | ||||
104018.interests.0 | 104018 | shareholding | 2021-07-30 | 0 | 0 | 0 | ||||
104020.interests.0 | 104020 | shareholding | 2021-07-30 | 0 | 0 | 0 | ||||
104021.interests.0 | 104021 | shareholding | 2021-03-18 | 2021-03-18 | 0 | 0 | 0 | |||
106368.interests.0 | 106368 | shareholding | 2019-05-31 | 0 | 0 | 0 | ||||
115860.interests.0 | 115860 | shareholding | 2020-02-03 | 0 | 0 | 0 | ||||
115881.interests.0 | 115881 | shareholding | 2020-02-03 | 0 | 0 | 0 | ||||
115898.interests.0 | 115898 | shareholding | 2019-03-08 | 0 | 0 | 0 | ||||
115909.interests.0 | 115909 | shareholding | 2017-08-17 | 0 | 0 | 0 | ||||
120097.interests.0 | 120097 | shareholding | 2020-06-04 | 0 | 0 | 0 | ||||
120100.interests.0 | 120100 | shareholding | 2020-06-04 | 0 | 0 | 0 | ||||
132003.interests.0 | 132003 | shareholding | 2021-12-02 | 0 | 0 | 0 | ||||
132004.interests.0 | 132004 | shareholding | 2021-12-02 | 0 | 0 | 0 | ||||
136687.interests.0 | 136687 | shareholding | 2021-03-25 | 0 | 0 | 0 | ||||
136716.interests.0 | 136716 | shareholding | 2021-03-25 | 0 | 0 | 0 | ||||
142933.interests.0 | 142933 | shareholding | 2020-08-27 | 0 | 0 | 0 | ||||
142938.interests.0 | 142938 | shareholding | 2020-08-27 | 0 | 0 | 0 | ||||
142940.interests.0 | 142940 | shareholding | 2020-08-27 | 0 | 0 | 0 | ||||
143028.interests.0 | 143028 | shareholding | 2021-10-01 | 0 | 0 | 0 | ||||
143029.interests.0 | 143029 | shareholding | 2018-03-01 | 0 | 0 | 0 | ||||
145519.interests.0 | 145519 | shareholding | 2021-05-31 | 0 | 0 | 0 | ||||
151190.interests.0 | 151190 | shareholding | 2016-05-24 | 0 | 0 | 0 | ||||
151191.interests.0 | 151191 | shareholding | 2019-09-30 | 0 | 0 | 0 | ||||
159576.interests.0 | 159576 | shareholding | 2018-10-04 | 0 | 0 | 0 | ||||
178322.interests.0 | 178322 | shareholding | 2021-05-01 | 0 | 0 | 0 | ||||
178327.interests.0 | 178327 | shareholding | 2021-05-01 | 0 | 0 | 0 | ||||
178328.interests.0 | 178328 | shareholding | 2021-05-01 | 0 | 0 | 0 | ||||
184341.interests.0 | 184341 | shareholding | 2018-09-03 | 0 | 0 | 0 | ||||
184342.interests.0 | 184342 | shareholding | 2018-09-03 | 0 | 0 | 0 | ||||
188438.interests.1 | 188438 | voting-rights | 2022-04-23 | 0 | 0 | 0 | ||||
195214.interests.0 | 195214 | shareholding | 2017-09-07 | 0 | 0 | 0 | ||||
209811.interests.1 | 209811 | voting-rights | 2022-04-23 | 0 | 0 | 0 | ||||
213201.interests.0 | 213201 | shareholding | 2021-04-13 | 2014-11-19 | 0 | 0 | 0 | |||
214569.interests.0 | 214569 | shareholding | 2020-08-20 | 0 | 0 | 0 | ||||
227027.interests.0 | 227027 | shareholding | 2015-12-31 | 0 | 0 | 0 | ||||
232094.interests.0 | 232094 | shareholding | 2021-02-19 | 0 | 0 | 0 | ||||
232095.interests.0 | 232095 | shareholding | 2021-02-19 | 0 | 0 | 0 | ||||
238420.interests.0 | 238420 | shareholding | 2020-10-06 | 0 | 0 | 0 | ||||
238421.interests.0 | 238421 | shareholding | 2020-10-06 | 0 | 0 | 0 | ||||
238422.interests.0 | 238422 | shareholding | 2020-11-06 | 0 | 0 | 0 | ||||
238423.interests.0 | 238423 | shareholding | 2020-12-08 | 0 | 0 | 0 | ||||
238424.interests.0 | 238424 | shareholding | 2020-12-08 | 0 | 0 | 0 | ||||
250365.interests.0 | 250365 | shareholding | 2021-01-01 | 0 | 0 | 0 | ||||
250365.interests.1 | 250365 | voting-rights | 2021-01-01 | 0 | 0 | 0 | ||||
259358.interests.0 | 259358 | shareholding | 2018-09-03 | 0 | 0 | 0 | ||||
259361.interests.0 | 259361 | shareholding | 2018-09-03 | 0 | 0 | 0 | ||||
259362.interests.0 | 259362 | shareholding | 2018-09-03 | 0 | 0 | 0 | ||||
262410.interests.0 | 262410 | shareholding | 2019-12-04 | 2018-06-19 | 0 | 0 | 0 | |||
264747.interests.0 | 264747 | shareholding | 2019-11-13 | 0 | 0 | 0 | ||||
264755.interests.0 | 264755 | shareholding | 2019-11-13 | 0 | 0 | 0 | ||||
268202.interests.0 | 268202 | shareholding | 2015-06-26 | 0 | 0 | 0 | ||||
269409.interests.0 | 269409 | shareholding | 2018-09-12 | 0 | 0 | 0 | ||||
269410.interests.0 | 269410 | shareholding | 2018-09-12 | 0 | 0 | 0 | ||||
276133.interests.0 | 276133 | shareholding | 2022-03-15 | 0 | 0 | 0 | ||||
282978.interests.0 | 282978 | shareholding | 2016-12-01 | 0 | 0 | 0 | ||||
318044.interests.0 | 318044 | shareholding | 2021-12-15 | 0 | 0 | 0 | ||||
318045.interests.0 | 318045 | shareholding | 2021-12-15 | 0 | 0 | 0 | ||||
318048.interests.0 | 318048 | shareholding | 2021-12-15 | 0 | 0 | 0 | ||||
321815.interests.0 | 321815 | shareholding | 2018-10-02 | 0 | 0 | 0 | ||||
339408.interests.0 | 339408 | shareholding | 2007-01-26 | 0 | 0 | 0 | ||||
342234.interests.0 | 342234 | shareholding | 2018-02-21 | 0 | 0 | 0 | ||||
342235.interests.0 | 342235 | shareholding | 2017-11-06 | 0 | 0 | 0 | ||||
359094.interests.0 | 359094 | shareholding | 2021-09-17 | 0 | 0 | 0 | ||||
359095.interests.0 | 359095 | shareholding | 2021-09-17 | 0 | 0 | 0 | ||||
359608.interests.0 | 359608 | shareholding | 2019-11-20 | 0 | 0 | 0 | ||||
359611.interests.0 | 359611 | shareholding | 2019-11-20 | 0 | 0 | 0 | ||||
359613.interests.0 | 359613 | shareholding | 2019-11-21 | 0 | 0 | 0 | ||||
359614.interests.0 | 359614 | shareholding | 2019-11-20 | 0 | 0 | 0 | ||||
375039.interests.0 | 375039 | shareholding | 2021-04-29 | 0 | 0 | 0 | ||||
401204.interests.0 | 401204 | shareholding | 2021-06-24 | 0 | 0 | 0 | ||||
401205.interests.0 | 401205 | shareholding | 2021-06-24 | 0 | 0 | 0 | ||||
401212.interests.0 | 401212 | shareholding | 2021-06-24 | 0 | 0 | 0 | ||||
401214.interests.0 | 401214 | shareholding | 2021-06-24 | 0 | 0 | 0 | ||||
401217.interests.0 | 401217 | shareholding | 2021-06-24 | 0 | 0 | 0 | ||||
406407.interests.0 | 406407 | shareholding | 2016-11-30 | 0 | 0 | 0 | ||||
406409.interests.0 | 406409 | shareholding | 2016-11-30 | 0 | 0 | 0 | ||||
406411.interests.0 | 406411 | shareholding | 2016-11-30 | 0 | 0 | 0 | ||||
406414.interests.0 | 406414 | shareholding | 2021-12-27 | 2012-10-18 | 0 | 0 | 0 | |||
406415.interests.0 | 406415 | shareholding | 2016-11-30 | 0 | 0 | 0 | ||||
406416.interests.0 | 406416 | shareholding | 2021-05-16 | 0 | 0 | 0 | ||||
406419.interests.0 | 406419 | shareholding | 2014-07-30 | 0 | 0 | 0 | ||||
406420.interests.0 | 406420 | shareholding | 2016-11-30 | 0 | 0 | 0 | ||||
406434.interests.0 | 406434 | shareholding | 2021-05-16 | 0 | 0 | 0 | ||||
406436.interests.0 | 406436 | shareholding | 2016-11-30 | 0 | 0 | 0 | ||||
406442.interests.0 | 406442 | shareholding | 2016-11-30 | 0 | 0 | 0 | ||||
406445.interests.0 | 406445 | shareholding | 2016-11-30 | 0 | 0 | 0 | ||||
411358.interests.0 | 411358 | shareholding | 2022-03-09 | 2020-01-27 | 0 | 0 | 0 | |||
411358.interests.1 | 411358 | voting-rights | 2022-03-09 | 2020-01-27 | 0 | 0 | 0 | |||
412003.interests.0 | 412003 | shareholding | 2022-02-06 | 0 | 0 | 0 | ||||
418077.interests.0 | 418077 | shareholding | 2020-06-24 | 0 | 0 | 0 | ||||
419778.interests.0 | 419778 | shareholding | 2022-10-05 | 0 | 0 | 0 |
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]) );