screen

13 rows where building = 098221470

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building
10009132 10009132 - U-Bf Lohmühlenstr./schalterhalle B/li. U-Bf Lohmühlenstr./schalterhalle B/li. 098221470
10009133 10009133 - U-Bf Lohmühlenstr./schalterhalle B/re. U-Bf Lohmühlenstr./schalterhalle B/re. 098221470
10009134 10009134 - U-Bf Lohmühlenstr./Schalterhalle A/Sto. 1 U-Bf Lohmühlenstr./Schalterhalle A/Sto. 1 098221470
10009135 10009135 - U-Bf Lohmühlenstr./Schalterhalle A/Sto. 3 U-Bf Lohmühlenstr./Schalterhalle A/Sto. 3 098221470
10009136 10009136 - U-Bf Lohmühlenstr./Schalterhalle A/Sto. 2 U-Bf Lohmühlenstr./Schalterhalle A/Sto. 2 098221470
10011368 10011368 - U-Bf Lohmühlenstr./Gl. 2/Sto. 3/4 U-Bf Lohmühlenstr./Gl. 2/Sto. 3/4 098221470
10011369 10011369 - U-Bf Lohmühlenstr./Gl. 1/Sto. 1/4 U-Bf Lohmühlenstr./Gl. 1/Sto. 1/4 098221470
10011370 10011370 - U-Bf Lohmühlenstr./Gl. 1/Sto. 2/4 U-Bf Lohmühlenstr./Gl. 1/Sto. 2/4 098221470
10011371 10011371 - U-Bf Lohmühlenstr./Gl. 2 /Sto. 4/4 U-Bf Lohmühlenstr./Gl. 2 /Sto. 4/4 098221470
10011372 10011372 - U-Bf Lohmühlenstr./Gl. 2/Sto. 2/4 U-Bf Lohmühlenstr./Gl. 2/Sto. 2/4 098221470
10011373 10011373 - U-Bf Lohmühlenstr./Gl. 2 /Sto. 3/4 U-Bf Lohmühlenstr./Gl. 2 /Sto. 3/4 098221470
10011374 10011374 - U-Bf Lohmühlenstr./Gl.1/Sto. 4/4 U-Bf Lohmühlenstr./Gl.1/Sto. 4/4 098221470
10011375 10011375 - U-Bf Lohmühlenstr./Gl. 1/Sto. 3/4 U-Bf Lohmühlenstr./Gl. 1/Sto. 3/4 098221470

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