ooc_interests
1 row where _link_ooc_statement = 1000045 sorted by beneficialownershiporcontrol
This data as json, CSV (advanced)
_link | _link_ooc_statement | type | interestlevel | beneficialownershiporcontrol ▼ | details | startdate |
---|---|---|---|---|---|---|
1000045.interests.0 | 1000045 | other-influence-or-control | direct | false | A controlling interest. |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [ooc_interests] ( [_link] TEXT , [_link_ooc_statement] TEXT , [type] TEXT , [interestlevel] TEXT , [beneficialownershiporcontrol] BOOL , [details] TEXT , [startdate] TIMESTAMP , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );