home / PuP_PoC_groups

screengroup_screens

4 rows where screengroup = 22

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link screengroup screen
22,10008898 Hamburg Elbbrücken U-Bf - all screens 22 10008898 - U-Bf Elbbr., Sto.1, V-Ebene 0, Schalterh. B 10008898
22,10008899 Hamburg Elbbrücken U-Bf - all screens 22 10008899 - U-Bf Elbbr., Sto.3, V-Ebene 0, Schalterh. C 10008899
22,10008900 Hamburg Elbbrücken U-Bf - all screens 22 10008900 - U-Bf Elbbr., Sto.4, V-Ebene 0, Schalterh. D 10008900
22,10008901 Hamburg Elbbrücken U-Bf - all screens 22 10008901 - U-Bf Elbbr., Sto.2, V-Ebene 0, Schalterh. A 10008901

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 7.392ms