screen

4 rows where building = 100410481

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building
10008898 10008898 - U-Bf Elbbr., Sto.1, V-Ebene 0, Schalterh. B U-Bf Elbbr., Sto.1, V-Ebene 0, Schalterh. B 100410481
10008899 10008899 - U-Bf Elbbr., Sto.3, V-Ebene 0, Schalterh. C U-Bf Elbbr., Sto.3, V-Ebene 0, Schalterh. C 100410481
10008900 10008900 - U-Bf Elbbr., Sto.4, V-Ebene 0, Schalterh. D U-Bf Elbbr., Sto.4, V-Ebene 0, Schalterh. D 100410481
10008901 10008901 - U-Bf Elbbr., Sto.2, V-Ebene 0, Schalterh. A U-Bf Elbbr., Sto.2, V-Ebene 0, Schalterh. A 100410481

Advanced export

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

CSV options: 

CREATE TABLE screen (
	id VARCHAR(8) NOT NULL, 
	title VARCHAR(250), 
	name_publisher VARCHAR(250), 
	building VARCHAR, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(building) REFERENCES building (id)
);
CREATE INDEX ix_screen_building ON screen (building);
CREATE INDEX ix_screen_name_publisher ON screen (name_publisher);