screen

15 rows where building = "RSG-HH001"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: name_publisher

id ▼ title name_publisher building
10014069 10014069 - Cardio Screen 1 (links) Cardio Screen 1 (links) RSG-HH001
10014070 10014070 - Cardio Screen 2 (mitte) Cardio Screen 2 (mitte) RSG-HH001
10014071 10014071 - Cardio Screen 3 (rechts) Cardio Screen 3 (rechts) RSG-HH001
10014072 10014072 - Cardio Screen 3 (rechts) Cardio Screen 3 (rechts) RSG-HH001
10014073 10014073 - Lounge Screen Lounge Screen RSG-HH001
10014074 10014074 - Functional Screen 1 (Links) Functional Screen 1 (Links) RSG-HH001
10014075 10014075 - Functional Screen 2 (rechts) Functional Screen 2 (rechts) RSG-HH001
10014076 10014076 - Geräte Screen 1 (Links) Geräte Screen 1 (Links) RSG-HH001
10014077 10014077 - Geräte Screen 2 ( links mitte) Geräte Screen 2 ( links mitte) RSG-HH001
10014078 10014078 - Geräte Screen 3 (Mitte) Geräte Screen 3 (Mitte) RSG-HH001
10014079 10014079 - Geräte Screen 4 (rechts mitte) Geräte Screen 4 (rechts mitte) RSG-HH001
10014080 10014080 - Geräte Screen 5 (rechts) Geräte Screen 5 (rechts) RSG-HH001
10014081 10014081 - Power Screen 1 (links) Power Screen 1 (links) RSG-HH001
10014082 10014082 - Power Screen 2 (mitte) Power Screen 2 (mitte) RSG-HH001
10014083 10014083 - Power Screen 3 (rechts) Power Screen 3 (rechts) RSG-HH001

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, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(building) REFERENCES building (id)
);
CREATE INDEX ix_screen_building ON screen (building);
CREATE INDEX ix_screen_name_publisher ON screen (name_publisher);