home / PuP_PoC_groups

screengroup_screens

10 rows where screengroup = 5

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link screengroup screen
5,10011239 Hamburg Hallerstraße U-Bf - all screens 5 10011239 - U-Bf Hallerstr., Einf. nb. Orientierungsplan - 347 10011239
5,10011240 Hamburg Hallerstraße U-Bf - all screens 5 10011240 - U-Bf Hallerstr., Gl.2 Einf. Höhe Sitzbank - 400 10011240
5,10011242 Hamburg Hallerstraße U-Bf - all screens 5 10011242 - U-Bf Hallerstr., Gl.2 Höhe Notrufsäule - 405 10011242
5,10011243 Hamburg Hallerstraße U-Bf - all screens 5 10011243 - U-Bf Hallerstr., Gl.1 Höhe Notrufsäule - 372 10011243
5,10011244 Hamburg Hallerstraße U-Bf - all screens 5 10011244 - U-Bf Hallerstr., Gl.1 Höhe 2. SB zw. WT - 348 10011244
5,10011251 Hamburg Hallerstraße U-Bf - all screens 5 10011251 - U-Bf Hallerstr., Gl.2 Ausf. Höhe Sitzbank - 408 10011251
5,10011252 Hamburg Hallerstraße U-Bf - all screens 5 10011252 - U-Bf Hallerstr., Gl.1 S-mitte Höhe HS-Schild - 371 10011252
5,10011253 Hamburg Hallerstraße U-Bf - all screens 5 10011253 - U-Bf Hallerstr., Gl.2 Höhe HS-Schild - 406 10011253
5,10011254 Hamburg Hallerstraße U-Bf - all screens 5 10011254 - U-Bf Hallerstr., Gl.2 Höhe Sitzbank zw. WT - 407 10011254
5,10011255 Hamburg Hallerstraße U-Bf - all screens 5 10011255 - U-Bf Hallerstr., Gl.1 Ausf. nb. Infovitr. - 373 10011255

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.192ms