entity_addresses
5 rows where country = ""
This data as json, CSV (advanced)
_link ▼ | _link_entity_statement | type | address | country |
---|---|---|---|---|
445722.addresses.0 | British Security Industry Association (The) 445722 | registered | Anbrian House (First Floor), The Tything, Worcester, WR1 1HD | |
446960.addresses.0 | Mr James A J Witt 446960 | registered | Unit 17 / 18, Unit 17 /18 Norton Enterprise Park, Whittle Road,, Salisbury, Wiltshire, SP2 7YS | |
447002.addresses.0 | Njord Partners Llp 447002 | registered | 4th Floor Phoenix House, 1 Station Hill, Reading, Berkshire, RG1 1NB | |
447109.addresses.0 | Kalypso Media Group Gmbh 447109 | registered | 11-13, Wilhelm-Leuschner Strausse, 67457, Worms | |
448443.addresses.0 | Fidelity National Information Services, Inc. 448443 | registered | 347, Riverside Avenue, Jacksonville, Florida, FL 32202 |
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]) );