screen

15 rows where building = 098221498

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: network

id ▼ title name_publisher building network
10009237 10009237 - U-Bf Wandsbek-M, Vert.Schr.fl. li.nb.Tr.,li. U-Bf Wandsbek-M, Vert.Schr.fl. li.nb.Tr.,li. 098221498 49
10009238 10009238 - U-Bf Wandsbek-M, Vert. nb. Store li.. Fl. U-Bf Wandsbek-M, Vert. nb. Store li.. Fl. 098221498 49
10009239 10009239 - U-Bf Wandsbek-M, Vert. nb. Store re. Fl. U-Bf Wandsbek-M, Vert. nb. Store re. Fl. 098221498 49
10009240 10009240 - U-Bf Wandsbek-M, Vert.Schr.fl. li.nb.Tr.,re. U-Bf Wandsbek-M, Vert.Schr.fl. li.nb.Tr.,re. 098221498 49
10009241 10009241 - U-Bf Wandsbek-M, Vert. nb. Store mittl. Fl. U-Bf Wandsbek-M, Vert. nb. Store mittl. Fl. 098221498 49
10010692 10010692 - U-Bf Wandsbek Markt, Gl.2 Einf. 1. Fläche - 055 U-Bf Wandsbek Markt, Gl.2 Einf. 1. Fläche - 055 098221498 47
10010693 10010693 - U-Bf Wandsbek Markt, Gl.1 Ausf Ri.Volksdorf - 056 U-Bf Wandsbek Markt, Gl.1 Ausf Ri.Volksdorf - 056 098221498 47
10010776 10010776 - U-Bf Wandsbek Markt, Gl.2 Ausf. - 068 U-Bf Wandsbek Markt, Gl.2 Ausf. - 068 098221498 47
10011046 10011046 - U-Bf Wandsbek Markt, Gl.2 Mitte 3.Fl. v.Einf - 349 U-Bf Wandsbek Markt, Gl.2 Mitte 3.Fl. v.Einf - 349 098221498 47
10011047 10011047 - U-Bf Wandsbek Markt, Gl.1 Mitte 2.St.n.Kiosk - 344 U-Bf Wandsbek Markt, Gl.1 Mitte 2.St.n.Kiosk - 344 098221498 47
10011048 10011048 - U-Bf Wandsbek Markt, Gl.1 Einf. - 342 U-Bf Wandsbek Markt, Gl.1 Einf. - 342 098221498 47
10011049 10011049 - U-Bf Wandsbek Markt, Gl.1 Mitte 3.Fl. v.Einf - 345 U-Bf Wandsbek Markt, Gl.1 Mitte 3.Fl. v.Einf - 345 098221498 47
10011050 10011050 - U-Bf Wandsbek Markt, Gl.1 Mitte 2.Fl. v.Einf - 343 U-Bf Wandsbek Markt, Gl.1 Mitte 2.Fl. v.Einf - 343 098221498 47
10011051 10011051 - U-Bf Wandsbek Markt, Gl.2 Mitte fr.Wand - 370 U-Bf Wandsbek Markt, Gl.2 Mitte fr.Wand - 370 098221498 47
10011052 10011052 - U-Bf Wandsbek Markt, Gl.2 Mitte 2.Fl. v.Einf - 346 U-Bf Wandsbek Markt, Gl.2 Mitte 2.Fl. v.Einf - 346 098221498 47

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, 
	network VARCHAR, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(building) REFERENCES building (id), 
	FOREIGN KEY(network) REFERENCES network (id)
);
CREATE INDEX ix_screen_network ON screen (network);
CREATE INDEX ix_screen_name_publisher ON screen (name_publisher);
CREATE INDEX ix_screen_building ON screen (building);