building

12 rows where publisher = 6

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ name_publisher publisher
DOR-208 Park Hotel Berliner Tor Hamburg Goldbach Germany 6
DOR-217 Stadthotel Hamburg Goldbach Germany 6
DOR-300 Hotel DENBU DTN GmbH Goldbach Germany 6
DOR-301 Hotel Hanseport Goldbach Germany 6
ESC Eidelstedt Center Goldbach Germany 6
I-SAW-WBQ Wandsbek Quarree Goldbach Germany 6
TOT_ND003855 Total Hamburg Neuhöfer Str. 28 Goldbach Germany 6
TOT_ND036962 Total Hamburg Billstedter Hauptstrasse 21 Goldbach Germany 6
TOT_ND037036 Total Hamburg Mundsburger Damm 47 Goldbach Germany 6
TOT_ND038778 Total Hamburg Aluminiumstr. 5 Goldbach Germany 6
TOT_ND040030 Total Hamburg Andreas Meyer Strasse 63 Goldbach Germany 6
TOT_ND040568 Total Hamburg Bramfelder Str. 86A Goldbach Germany 6

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_name_publisher ON building (name_publisher);
CREATE INDEX ix_building_publisher ON building (publisher);