screen
5 rows where building = 582685
This data as json, copyable, CSV (advanced)
Suggested facets: name_publisher
| id ▼ | title | name_publisher | building |
|---|---|---|---|
| 10015326 | 10015326 - Screen Verkaufsfläche | Screen Verkaufsfläche | 582685 |
| 10015327 | 10015327 - Screen Verkaufsfläche | Screen Verkaufsfläche | 582685 |
| 10015328 | 10015328 - Screen Verkaufsfläche | Screen Verkaufsfläche | 582685 |
| 10015329 | 10015329 - Screen Verkaufsfläche | Screen Verkaufsfläche | 582685 |
| 10015410 | 10015410 - Screen bei den Kassen | Screen bei den Kassen | 582685 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);