screen

24 rows where building = 098221437

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: network

id ▼ title name_publisher building network
10008879 10008879 - U-Bf Berliner Tor, V-Eb. Ri.Hbf. LiPl. li. U-Bf Berliner Tor, V-Eb. Ri.Hbf. LiPl. li. 098221437 49
10008880 10008880 - U-Bf Berliner Tor, V-Eb. Abg.z.Gl. re. U-Bf Berliner Tor, V-Eb. Abg.z.Gl. re. 098221437 49
10008881 10008881 - U-Bf Berliner Tor, V-Eb. v. Gel. re. U-Bf Berliner Tor, V-Eb. v. Gel. re. 098221437 49
10008882 10008882 - U-Bf Berliner Tor, V-Eb. Ausg.b. Stroh. N U-Bf Berliner Tor, V-Eb. Ausg.b. Stroh. N 098221437 49
10008883 10008883 - U-Bf Berliner Tor, V-Eb. v. Gel. 2.v.re. U-Bf Berliner Tor, V-Eb. v. Gel. 2.v.re. 098221437 49
10008884 10008884 - U-Bf Berliner Tor, V-Eb. v. Gel. 3.v.re. U-Bf Berliner Tor, V-Eb. v. Gel. 3.v.re. 098221437 49
10008885 10008885 - U-Bf Berliner Tor, V-Eb. Ri.Hbf. LiPl. re. U-Bf Berliner Tor, V-Eb. Ri.Hbf. LiPl. re. 098221437 49
10008886 10008886 - U-Bf Berliner Tor, V-Eb. Ri.Hbf. HBStr. li. U-Bf Berliner Tor, V-Eb. Ri.Hbf. HBStr. li. 098221437 49
10008887 10008887 - U-Bf Berliner Tor, V-Eb. gg.Ausg.b. Stroh.re U-Bf Berliner Tor, V-Eb. gg.Ausg.b. Stroh.re 098221437 49
10008888 10008888 - U-Bf Berliner Tor, V-Eb. gg.Ausg.b. Stroh.li U-Bf Berliner Tor, V-Eb. gg.Ausg.b. Stroh.li 098221437 49
10008889 10008889 - U-Bf Berliner Tor, V-Eb. v. Gel. li. U-Bf Berliner Tor, V-Eb. v. Gel. li. 098221437 49
10008890 10008890 - U-Bf Berliner Tor, V-Eb. Abg.z.Gl. li. U-Bf Berliner Tor, V-Eb. Abg.z.Gl. li. 098221437 49
10008891 10008891 - U-Bf Berliner Tor, V-Eb. Ausg. b. Strohh. U-Bf Berliner Tor, V-Eb. Ausg. b. Strohh. 098221437 49
10008892 10008892 - U-Bf Berliner Tor, V-Eb. Ri.Hbf. HBStr. re. U-Bf Berliner Tor, V-Eb. Ri.Hbf. HBStr. re. 098221437 49
10010884 10010884 - U-Bf Berliner Tor, Gl. 4, Stationsmitte, 2. Fl. U-Bf Berliner Tor, Gl. 4, Stationsmitte, 2. Fl. 098221437 47
10010885 10010885 - U-Bf Berliner Tor, Gl. 1, Ausf. v. Kiosk - 065 U-Bf Berliner Tor, Gl. 1, Ausf. v. Kiosk - 065 098221437 47
10010886 10010886 - U-Bf Berliner Tor, Gl. 1, Stationsmitte 2. Fl. U-Bf Berliner Tor, Gl. 1, Stationsmitte 2. Fl. 098221437 47
10010887 10010887 - U-Bf Berliner Tor, Gleis 1, Stationsmitte, gg 58 U-Bf Berliner Tor, Gleis 1, Stationsmitte, gg 58 098221437 47
10010888 10010888 - U-Bf Berliner Tor, Gl. 4, Stationsmitte, 3. Fl. U-Bf Berliner Tor, Gl. 4, Stationsmitte, 3. Fl. 098221437 47
10010894 10010894 - U-Bf Berliner Tor, Gl. 4, Einf., 1. Fl. - 067 U-Bf Berliner Tor, Gl. 4, Einf., 1. Fl. - 067 098221437 47
10010895 10010895 - U-Bf Berliner Tor, Gl. 2 Rtg. Billstedt RS 74 U-Bf Berliner Tor, Gl. 2 Rtg. Billstedt RS 74 098221437 47
10010896 10010896 - U-Bf Berliner Tor, Gleis 3, Stationsmitte, RS 58 U-Bf Berliner Tor, Gleis 3, Stationsmitte, RS 58 098221437 47
10010951 10010951 - U-Bf Berliner Tor, Gl. 1, 1.Fl. re. von Wandöffn. U-Bf Berliner Tor, Gl. 1, 1.Fl. re. von Wandöffn. 098221437 47
10010952 10010952 - U-Bf Berliner Tor, Gl. 4, gg. Fl.59 Ausf. - 075 U-Bf Berliner Tor, Gl. 4, gg. Fl.59 Ausf. - 075 098221437 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);