ooc_interests
2 rows where _link_ooc_statement = 100053
This data as json, CSV (advanced)
_link ▼ | _link_ooc_statement | type | enddate | startdate | share_exact | share_maximum | share_minimum | details | share_exclusiveminimum | share_exclusivemaximum |
---|---|---|---|---|---|---|---|---|---|---|
100053.interests.0 | 100053 | shareholding | 2017-12-28 | 2017-12-22 | 33.33 | 33.33 | 33.33 | |||
100053.interests.1 | 100053 | voting-rights | 2017-12-28 | 2017-12-22 | 33.33 | 33.33 | 33.33 |
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]) );