screen

21 rows where building = "STS-100305378"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: network

id ▼ title name_publisher building network
10008929 10008929 - S-Bf Harburg Rathaus, Gl. ber, 3. Sto v li S-Bf Harburg Rathaus, Gl. ber, 3. Sto v li STS-100305378 49
10008930 10008930 - S-Bf Harburg Rathaus, West-Halle vor Säule 3 S-Bf Harburg Rathaus, West-Halle vor Säule 3 STS-100305378 49
10008931 10008931 - S-Bf Harburg Rathaus, Gl. ber, 6. Sto v li S-Bf Harburg Rathaus, Gl. ber, 6. Sto v li STS-100305378 49
10008932 10008932 - S-Bf Harburg Rathaus, Gl. ber, 7. Sto v li S-Bf Harburg Rathaus, Gl. ber, 7. Sto v li STS-100305378 49
10008933 10008933 - S-Bf Harburg Rathaus, Gl. ber, 11.Sto v li S-Bf Harburg Rathaus, Gl. ber, 11.Sto v li STS-100305378 49
10008934 10008934 - S-Bf Harburg Rathaus, West-Halle vor Säule 1 S-Bf Harburg Rathaus, West-Halle vor Säule 1 STS-100305378 49
10008935 10008935 - S-Bf Harburg Rathaus, Gl. ber, 8. Sto v li S-Bf Harburg Rathaus, Gl. ber, 8. Sto v li STS-100305378 49
10008936 10008936 - S-Bf Harburg Rathaus, West-Halle vor Säule 5 S-Bf Harburg Rathaus, West-Halle vor Säule 5 STS-100305378 49
10008937 10008937 - S-Bf Harburg Rathaus, West-Halle vor Säule 4 S-Bf Harburg Rathaus, West-Halle vor Säule 4 STS-100305378 49
10008938 10008938 - S-Bf Harburg Rathaus, West-Halle vor Säule 2 S-Bf Harburg Rathaus, West-Halle vor Säule 2 STS-100305378 49
10008939 10008939 - S-Bf Harburg Rathaus, Gl. ber, 9. Sto v li S-Bf Harburg Rathaus, Gl. ber, 9. Sto v li STS-100305378 49
10008940 10008940 - S-Bf Harburg Rathaus, Gl. ber, 2. Sto v li S-Bf Harburg Rathaus, Gl. ber, 2. Sto v li STS-100305378 49
10008941 10008941 - S-Bf Harburg Rathaus, Gl. ber, 12.Sto v li S-Bf Harburg Rathaus, Gl. ber, 12.Sto v li STS-100305378 49
10008942 10008942 - S-Bf Harburg Rathaus, West-Halle vor Säule 6 S-Bf Harburg Rathaus, West-Halle vor Säule 6 STS-100305378 49
10008943 10008943 - S-Bf Harburg Rathaus, Gl. ber, 4. Sto v li S-Bf Harburg Rathaus, Gl. ber, 4. Sto v li STS-100305378 49
10008944 10008944 - S-Bf Harburg Rathaus, Gl. ber, 5. Sto v li S-Bf Harburg Rathaus, Gl. ber, 5. Sto v li STS-100305378 49
10008945 10008945 - S-Bf Harburg Rathaus,Gl. ber, 10.Sto v li S-Bf Harburg Rathaus,Gl. ber, 10.Sto v li STS-100305378 49
10008946 10008946 - S-Bf Harburg Rathaus,Gl. ber. 1.Sto v li S-Bf Harburg Rathaus,Gl. ber. 1.Sto v li STS-100305378 49
10010525 10010525 - S-Bf Harburg Rathaus, Gl. 3, 1.Sto. Einf. Se. -776 S-Bf Harburg Rathaus, Gl. 3, 1.Sto. Einf. Se. -776 STS-100305378 47
10010531 10010531 - S-Bf Harburg Rathaus, Gl. 3, 2.Sto Einf. Se. -777 S-Bf Harburg Rathaus, Gl. 3, 2.Sto Einf. Se. -777 STS-100305378 47
10010562 10010562 - S-Bf Harburg Rathaus, Gl. 3, 3.Sto Einf. Se. -778 S-Bf Harburg Rathaus, Gl. 3, 3.Sto Einf. Se. -778 STS-100305378 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_name_publisher ON screen (name_publisher);
CREATE INDEX ix_screen_network ON screen (network);
CREATE INDEX ix_screen_building ON screen (building);