media
43 rows where publisher = 1
This data as json, copyable, CSV (advanced)
Suggested facets: touchpoint, count_locations
| id ▼ | title | touchpoint | publisher | count_locations | count_screens | extern | order |
|---|---|---|---|---|---|---|---|
| BA_0_000 | BCN gesamt | Gesamt 12 | Brand Community Network (BCN) 1 | 377 | 3868 | 1 | 2 |
| BB_0_000 | Airport Touchpoint Classic Gesamt | Airport 1 | Brand Community Network (BCN) 1 | 7 | 688 | 1 | 3 |
| BB_1_000 | Airport Touchpoint Classic Departure | Airport 1 | Brand Community Network (BCN) 1 | 6 | 462 | 1 | 4 |
| BB_2_000 | Airport Touchpoint Classic Arrival | Airport 1 | Brand Community Network (BCN) 1 | 6 | 120 | 1 | 5 |
| BB_3_000 | Airport Touchpoint Classic Sicherheitsbereich | Airport 1 | Brand Community Network (BCN) 1 | 6 | 580 | 1 | 6 |
| BB_4_000 | Airport Touchpoint Classic Öffentlicher Bereich | Airport 1 | Brand Community Network (BCN) 1 | 5 | 95 | 1 | 7 |
| BB_5_000 | Airport Touchpoint Düsseldorf Sicherheitsbereich | Airport 1 | Brand Community Network (BCN) 1 | 1 | 124 | 1 | 8 |
| BB_6_000 | Airport Touchpoint Düsseldorf Departure | Airport 1 | Brand Community Network (BCN) 1 | 1 | 76 | 1 | 9 |
| BB_7_000 | Airport Touchpoint Düsseldorf Arrival | Airport 1 | Brand Community Network (BCN) 1 | 1 | 48 | 1 | 10 |
| BC_0_000 | Airport Touchpoint Hamburg Gesamt | Airport 1 | Brand Community Network (BCN) 1 | 1 | 94 | 1 | 11 |
| BC_1_000 | Airport Touchpoint Hamburg Sicherheitsbereich | Airport 1 | Brand Community Network (BCN) 1 | 1 | 83 | 1 | 12 |
| BC_2_000 | Airport Touchpoint Hamburg Öffentlicher Bereich | Airport 1 | Brand Community Network (BCN) 1 | 1 | 11 | 1 | 13 |
| BC_3_000 | Airport Touchpoint Hamburg Departure | Airport 1 | Brand Community Network (BCN) 1 | 1 | 78 | 1 | 14 |
| BC_4_000 | Airport Touchpoint Hamburg Arrival | Airport 1 | Brand Community Network (BCN) 1 | 1 | 5 | 1 | 15 |
| BD_0_000 | Airport Touchpoint Hannover Gesamt | Airport 1 | Brand Community Network (BCN) 1 | 1 | 100 | 1 | 16 |
| BD_1_000 | Airport Touchpoint Hannover Sicherheitsbereich | Airport 1 | Brand Community Network (BCN) 1 | 1 | 58 | 1 | 17 |
| BD_2_000 | Airport Touchpoint Hannover Öffentlicher Bereich | Airport 1 | Brand Community Network (BCN) 1 | 1 | 42 | 1 | 18 |
| BD_3_000 | Airport Touchpoint Hannover Departure | Airport 1 | Brand Community Network (BCN) 1 | 1 | 44 | 1 | 19 |
| BD_4_000 | Airport Touchpoint Hannover Arrival | Airport 1 | Brand Community Network (BCN) 1 | 1 | 14 | 1 | 20 |
| BE_0_000 | Airport Touchpoint München Gesamt | Airport 1 | Brand Community Network (BCN) 1 | 1 | 200 | 1 | 21 |
| BE_1_000 | Airport Touchpoint München Sicherheitsbereich | Airport 1 | Brand Community Network (BCN) 1 | 1 | 190 | 1 | 22 |
| BE_2_000 | Airport Touchpoint München Öffentlicher Bereich | Airport 1 | Brand Community Network (BCN) 1 | 1 | 10 | 1 | 23 |
| BE_3_000 | Airport Touchpoint München Departure | Airport 1 | Brand Community Network (BCN) 1 | 1 | 174 | 1 | 24 |
| BE_4_000 | Airport Touchpoint München Arrival | Airport 1 | Brand Community Network (BCN) 1 | 1 | 16 | 1 | 25 |
| BF_0_000 | Airport Touchpoint Nürnberg Gesamt | Airport 1 | Brand Community Network (BCN) 1 | 1 | 42 | 1 | 26 |
| BF_1_000 | Airport Touchpoint Nürnberg Sicherheitsbereich | Airport 1 | Brand Community Network (BCN) 1 | 1 | 28 | 1 | 27 |
| BF_2_000 | Airport Touchpoint Nürnberg Öffentlicher Bereich | Airport 1 | Brand Community Network (BCN) 1 | 1 | 14 | 1 | 28 |
| BF_3_000 | Airport Touchpoint Nürnberg Departure | Airport 1 | Brand Community Network (BCN) 1 | 1 | 22 | 1 | 29 |
| BF_4_000 | Airport Touchpoint Nürnberg Arrival | Airport 1 | Brand Community Network (BCN) 1 | 1 | 8 | 1 | 30 |
| BG_0_000 | Airport Touchpoint Stuttgart Gesamt | Airport 1 | Brand Community Network (BCN) 1 | 1 | 115 | 1 | 31 |
| BG_1_000 | Airport Touchpoint Stuttgart Sicherheitsbereich | Airport 1 | Brand Community Network (BCN) 1 | 1 | 97 | 1 | 32 |
| BG_2_000 | Airport Touchpoint Stuttgart Öffentlicher Bereich | Airport 1 | Brand Community Network (BCN) 1 | 1 | 18 | 1 | 33 |
| BG_3_000 | Airport Touchpoint Stuttgart Departure | Airport 1 | Brand Community Network (BCN) 1 | 1 | 68 | 1 | 34 |
| BG_4_000 | Airport Touchpoint Stuttgart Arrival | Airport 1 | Brand Community Network (BCN) 1 | 1 | 29 | 1 | 35 |
| BH_0_000 | Airport Touchpoint Dresden | Airport 1 | Brand Community Network (BCN) 1 | 1 | 13 | 1 | 36 |
| BI_0_000 | Autobahn Touchpoint Gesamt | Autobahn 4 | Brand Community Network (BCN) 1 | 359 | 4430 | 1 | 37 |
| BI_1_000 | Autobahn Touchpoint Classic Gesamt | Autobahn 4 | Brand Community Network (BCN) 1 | 331 | 2871 | 1 | 38 |
| BI_2_000 | Autobahn Touchpoint Classic Kasse | Autobahn 4 | Brand Community Network (BCN) 1 | 319 | 361 | 1 | 39 |
| BI_3_000 | Autobahn Touchpoint Classic Kühltheke | Autobahn 4 | Brand Community Network (BCN) 1 | 332 | 1018 | 1 | 40 |
| BI_4_000 | Autobahn Touchpoint Classic Gondel | Autobahn 4 | Brand Community Network (BCN) 1 | 279 | 1492 | 1 | 41 |
| BI_5_000 | Autobahn Touchpoint Digitale CLP | Autobahn 4 | Brand Community Network (BCN) 1 | 239 | 276 | 1 | 42 |
| BI_6_000 | Autobahn Touchpoint Travelboard | Autobahn 4 | Brand Community Network (BCN) 1 | 252 | 252 | 1 | 43 |
| BJ_0_000 | Mall Touchpoint | Shopping Mall 17 | Brand Community Network (BCN) 1 | 39 | 309 | 1 | 45 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE media ( id VARCHAR(8) NOT NULL, title VARCHAR(250), touchpoint INTEGER, publisher INTEGER, count_locations INTEGER, count_screens INTEGER, extern BOOLEAN, "order" INTEGER, PRIMARY KEY (id), UNIQUE (id), FOREIGN KEY(touchpoint) REFERENCES touchpoint (id), FOREIGN KEY(publisher) REFERENCES publisher (id) ); CREATE INDEX ix_media_extern ON media (extern); CREATE INDEX ix_media_touchpoint ON media (touchpoint); CREATE INDEX ix_media_publisher ON media (publisher);