screen
7 rows where building = 26800
This data as json, copyable, CSV (advanced)
Suggested facets: name_publisher
| id ▼ | title | name_publisher | building | network |
|---|---|---|---|---|
| 10015336 | 10015336 - Screen Verkaufsfläche | Screen Verkaufsfläche | 26800 | 53 |
| 10015337 | 10015337 - Screen Verkaufsfläche | Screen Verkaufsfläche | 26800 | 53 |
| 10015338 | 10015338 - Screen Verkaufsfläche | Screen Verkaufsfläche | 26800 | 53 |
| 10015339 | 10015339 - Screen Verkaufsfläche | Screen Verkaufsfläche | 26800 | 53 |
| 10015340 | 10015340 - Screen Verkaufsfläche | Screen Verkaufsfläche | 26800 | 53 |
| 10015341 | 10015341 - Screen Verkaufsfläche | Screen Verkaufsfläche | 26800 | 53 |
| 10015416 | 10015416 - Screen bei den Kassen | Screen bei den Kassen | 26800 | 53 |
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, network VARCHAR, PRIMARY KEY (id), UNIQUE (id), FOREIGN KEY(building) REFERENCES building (id), FOREIGN KEY(network) REFERENCES network (id) ); CREATE INDEX ix_screen_network ON screen (network); CREATE INDEX ix_screen_name_publisher ON screen (name_publisher); CREATE INDEX ix_screen_building ON screen (building);