screen
23 rows where network = 26
This data as json, copyable, CSV (advanced)
| id ▼ | title | name_publisher | building | network |
|---|---|---|---|---|
| 10008006 | 10008006 - Kiosk Büchner - Wandsbeker Chaussee 115 - POS - 1 / 1 | Kiosk Büchner - Wandsbeker Chaussee 115 - POS - 1 / 1 | S-DE-HH-2701-01 | 26 |
| 10008007 | 10008007 - Kiosk Behringstr - Behringstr. 97 - POS - 1 / 1 | Kiosk Behringstr - Behringstr. 97 - POS - 1 / 1 | S-DE-HH-2703-01 | 26 |
| 10008008 | 10008008 - Arnkiel kiosk - Arnkielstr.15 - POS - 1 / 1 | Arnkiel kiosk - Arnkielstr.15 - POS - 1 / 1 | S-DE-HH-2705-01 | 26 |
| 10008009 | 10008009 - G&C GBR - Borsteler Chaussee 113 - POS - 1 / 1 | G&C GBR - Borsteler Chaussee 113 - POS - 1 / 1 | S-DE-HH-2878-01 | 26 |
| 10008010 | 10008010 - Schreibwarengeschäft (Lotto) - Weidenallee 65 - POS - 1 / 1 | Schreibwarengeschäft (Lotto) - Weidenallee 65 - POS - 1 / 1 | S-DE-HH-2886-01 | 26 |
| 10008011 | 10008011 - Frischkauf E&F - Simon-von-Utrecht-Str. 23 - POS - 1 / 1 | Frischkauf E&F - Simon-von-Utrecht-Str. 23 - POS - 1 / 1 | S-DE-HH-2887-01 | 26 |
| 10008012 | 10008012 - Kiosk Ugur Zorlu - Schleestr. 5 - POS - 1 / 1 | Kiosk Ugur Zorlu - Schleestr. 5 - POS - 1 / 1 | S-DE-HH-2907-01 | 26 |
| 10008013 | 10008013 - Kiosk Agora - Holstenstr. 199 - POS - 1 / 1 | Kiosk Agora - Holstenstr. 199 - POS - 1 / 1 | S-DE-HH-2908-01 | 26 |
| 10008014 | 10008014 - Dostana Store - Stralsunder Str. 3 - POS - 1 / 1 | Dostana Store - Stralsunder Str. 3 - POS - 1 / 1 | S-DE-HH-2985-01 | 26 |
| 10008015 | 10008015 - Kiosk Dostana - Steindamm 31 - POS - 1 / 1 | Kiosk Dostana - Steindamm 31 - POS - 1 / 1 | S-DE-HH-2986-01 | 26 |
| 10008016 | 10008016 - 1A Kiosk - Elligersweg 3 - POS - 1 / 1 | 1A Kiosk - Elligersweg 3 - POS - 1 / 1 | S-DE-HH-2987-01 | 26 |
| 10008017 | 10008017 - Kiosk Lotto - Hein-Hoyer-Str. 32 - POS - 1 / 1 | Kiosk Lotto - Hein-Hoyer-Str. 32 - POS - 1 / 1 | S-DE-HH-3029-01 | 26 |
| 10008018 | 10008018 - Kiosk & Backshop - Süderstr. 63 - POS - 1 / 1 | Kiosk & Backshop - Süderstr. 63 - POS - 1 / 1 | S-DE-HH-3074-01 | 26 |
| 10008019 | 10008019 - Bartels-Kiosk - Bartelsstr. 39 - POS - 1 / 1 | Bartels-Kiosk - Bartelsstr. 39 - POS - 1 / 1 | S-DE-HH-3075-01 | 26 |
| 10008020 | 10008020 - LottoKiosk - Wandsbeker Chaussee 152 - POS - 1 / 1 | LottoKiosk - Wandsbeker Chaussee 152 - POS - 1 / 1 | S-DE-HH-3247-01 | 26 |
| 10008021 | 10008021 - Hüsso Shop - Wandsbeker Chaussee 276 - POS - 1 / 1 | Hüsso Shop - Wandsbeker Chaussee 276 - POS - 1 / 1 | S-DE-HH-3250-01 | 26 |
| 10008022 | 10008022 - Minni Markt - Wrangelstr. 104 - POS - 1 / 1 | Minni Markt - Wrangelstr. 104 - POS - 1 / 1 | S-DE-HH-3251-01 | 26 |
| 10008023 | 10008023 - Tabak Presse Lotto - Pilatuspool 1 - POS - 1 / 1 | Tabak Presse Lotto - Pilatuspool 1 - POS - 1 / 1 | S-DE-HH-3323-01 | 26 |
| 10008024 | 10008024 - Hafen Kiosk 1 - Davidstr. 3 - POS - 1 / 1 | Hafen Kiosk 1 - Davidstr. 3 - POS - 1 / 1 | S-DE-HH-3383-01 | 26 |
| 10008025 | 10008025 - Biggy's Kisosk - Reeperbahn 155 - POS - 1 / 1 | Biggy's Kisosk - Reeperbahn 155 - POS - 1 / 1 | S-DE-HH-3388-01 | 26 |
| 10008026 | 10008026 - SN-Stehcafe - Davidstr. 16 - POS - 1 / 1 | SN-Stehcafe - Davidstr. 16 - POS - 1 / 1 | S-DE-HH-3511-01 | 26 |
| 10008027 | 10008027 - Kiosk 104 - Osterstr. 104 - 1 / 1 | Kiosk 104 - Osterstr. 104 - 1 / 1 | S-DE-HH-3512-01 | 26 |
| 10008028 | 10008028 - Tobacco & More GmbH - 1 / 1 | Tobacco & More GmbH - 1 / 1 | S-DE-HH-4058-01 | 26 |
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_name_publisher ON screen (name_publisher); CREATE INDEX ix_screen_network ON screen (network); CREATE INDEX ix_screen_building ON screen (building);