building

6 rows where publisher = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ name_publisher publisher
AIR-HAM Flughafen Hamburg Brand Community Network (BCN) 1
AUT-1102 Hamburg-Stillhorn Ost Brand Community Network (BCN) 1
AUT-1103 Hamburg-Stillhorn West Brand Community Network (BCN) 1
AUT-1108 Harburger Berge Ost Brand Community Network (BCN) 1
AUT-1109 Harburger Berge West Brand Community Network (BCN) 1
MALL-W1H_p W1 Hamburg Wandsbek Brand Community Network (BCN) 1

Advanced export

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

CSV options: 

CREATE TABLE building (
	id VARCHAR(100) NOT NULL, 
	name_publisher VARCHAR(250), 
	publisher INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(publisher) REFERENCES publisher (id)
);
CREATE INDEX ix_building_publisher ON building (publisher);
CREATE INDEX ix_building_name_publisher ON building (name_publisher);