building

7 rows where publisher = 20

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ name_publisher publisher
DMI_AT_00087 Easyfitness Hamburg Altona airtango media GmbH 20
DMI_AT_00088 Easyfitness Hamburg Harburg airtango media GmbH 20
DMI_AT_00338 Cleverfit Hamburg Neugraben airtango media GmbH 20
DMI_AT_00339 Cleverfit Hamburg Niendorf airtango media GmbH 20
DMI_AT_00776 wellyou Hamburg airtango media GmbH 20
DMI_AT_00977 XTRAFIT Hamburg-Wandsbek airtango media GmbH 20
DMI_AT_01049 Cleverfit Hamburg-Rothenburgsort airtango media GmbH 20

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);