entity_addresses
1 row where address = "10th Floor, 135 Bishopsgate, London, EC2M 3TP"
This data as json, CSV (advanced)
_link ▼ | _link_entity_statement | type | address | country |
---|---|---|---|---|
448763.addresses.0 | Fnz Securities Limited 448763 | registered | 10th Floor, 135 Bishopsgate, London, EC2M 3TP | GB |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [entity_addresses] ( [_link] TEXT , [_link_entity_statement] TEXT , [type] TEXT , [address] TEXT , [country] TEXT , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_entity_statement]) REFERENCES [entity_statement]([_link]) );