entity_addresses

2 rows where _link_entity_statement = 100001

✎ View and edit SQL

This data as json, CSV (advanced)

_link ▼ _link_entity_statement type address country postcode
100001.addresses.0 Tembusu Partners Pte. Ltd. 100001 registered Ocean Financial Centre, Singapore SG 049315
100001.addresses.1 Tembusu Partners Pte. Ltd. 100001 business Ocean Financial Centre, Singapore SG 049315

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [entity_addresses] ( [_link] TEXT 
 , [_link_entity_statement] TEXT 
 , [type] TEXT 
 , [address] TEXT 
 , [country] TEXT 
 , [postcode] TEXT 
 , PRIMARY KEY ([_link]) 
 , FOREIGN KEY ([_link_entity_statement]) REFERENCES [entity_statement]([_link]) 
   );