home / PuP_PoC_groups

screengroup_screens

11 rows where screengroup = 4

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link screengroup screen
4,10008904 Hamburg Gänsemarkt (Oper) U-Bf - all screens 4 10008904 - U-Bf Gänsemarkt, SH B Abg. U-Bf re. 10008904
4,10008905 Hamburg Gänsemarkt (Oper) U-Bf - all screens 4 10008905 - U-Bf Gänsemarkt, SH B Abg. U-Bf li. 10008905
4,10008906 Hamburg Gänsemarkt (Oper) U-Bf - all screens 4 10008906 - U-Bf Gänsemarkt, SH B Aufg. Valentinsk. re. 10008906
4,10008907 Hamburg Gänsemarkt (Oper) U-Bf - all screens 4 10008907 - U-Bf Gänsemarkt, SH B Aufg. Valentinsk. li. 10008907
4,10008908 Hamburg Gänsemarkt (Oper) U-Bf - all screens 4 10008908 - U-Bf Gänsemarkt, SH B Aufg. Finanzbehörde 10008908
4,10011269 Hamburg Gänsemarkt (Oper) U-Bf - all screens 4 10011269 - U-Bf Gänsemarkt, Gl.1 Einf. nb. Netzplan - 750 10011269
4,10011270 Hamburg Gänsemarkt (Oper) U-Bf - all screens 4 10011270 - U-Bf Gänsemarkt, Gl.2 Stationsmitte - 766 10011270
4,10011271 Hamburg Gänsemarkt (Oper) U-Bf - all screens 4 10011271 - U-Bf Gänsemarkt, Gl.2 Ausf. - 767 10011271
4,10011272 Hamburg Gänsemarkt (Oper) U-Bf - all screens 4 10011272 - U-Bf Gänsemarkt, Gl.2 Einf. - 765 10011272
4,10011273 Hamburg Gänsemarkt (Oper) U-Bf - all screens 4 10011273 - U-Bf Gänsemarkt, Gl.1 Ausf. nb. Netzplan - 764 10011273
4,10011274 Hamburg Gänsemarkt (Oper) U-Bf - all screens 4 10011274 - U-Bf Gänsemarkt, Gl.1 Stationsmitte - 763 10011274

Advanced export

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

CSV options:

CREATE TABLE screengroup_screens (
	screengroup INTEGER NOT NULL, 
	screen VARCHAR(8) NOT NULL, 
	PRIMARY KEY (screengroup, screen), 
	FOREIGN KEY(screengroup) REFERENCES screengroup (id), 
	FOREIGN KEY(screen) REFERENCES screen (id)
);
Powered by Datasette · Queries took 6.405ms