ooc_interests
2 rows where _link_ooc_statement = 1000039 sorted by startdate
This data as json, CSV (advanced)
_link | _link_ooc_statement | type | startdate ▼ | share_exact | share_maximum | share_minimum | enddate |
---|---|---|---|---|---|---|---|
1000039.interests.0 | 1000039 | shareholding | 2016-02-15 | 50 | 50 | 50 | 2020-06-04 |
1000039.interests.1 | 1000039 | voting-rights | 2016-02-15 | 50 | 50 | 50 | 2020-06-04 |
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]) );