spotset
73 rows
This data as json, copyable, CSV (advanced)
Suggested facets: publisher, extern
| id ▼ | name | publisher | extern |
|---|---|---|---|
| 1 | Brand Community Network (BCN) | Brand Community Network (BCN) 1 | 1 |
| 2 | Brand Community Network (BCN) (1) | Brand Community Network (BCN) 1 | 1 |
| 3 | Brand Community Network (BCN) (2) | Brand Community Network (BCN) 1 | 1 |
| 4 | Brand Community Network (BCN) (3) | Brand Community Network (BCN) 1 | 1 |
| 5 | Brandstifter AG | Brandstifter AG 2 | 1 |
| 6 | Diverse | Diverse 4 | 1 |
| 7 | Edgar Ambient Media Group GmbH | Edgar Ambient Media Group GmbH 5 | 1 |
| 8 | Edgar Ambient Media Group GmbH (1) | Edgar Ambient Media Group GmbH 5 | 1 |
| 9 | El Cartel Media | El Cartel Media 6 | 1 |
| 10 | Executive Channel Deutschland GmbH | Executive Channel Deutschland GmbH 7 | 1 |
| 11 | Goldbach Germany | Goldbach Germany 9 | 1 |
| 12 | Goldbach Germany (1) | Goldbach Germany 9 | 1 |
| 13 | Goldbach Germany (2) | Goldbach Germany 9 | 1 |
| 14 | Goldbach Germany (3) | Goldbach Germany 9 | 1 |
| 15 | Goldbach Germany (4) | Goldbach Germany 9 | 1 |
| 16 | Hygh Mobile Media GmbH | Hygh Mobile Media GmbH 10 | 1 |
| 17 | SK2 Solutions GmbH | SK2 Solutions GmbH 11 | 1 |
| 18 | Ströer | Ströer 12 | 1 |
| 19 | Ströer (1) | Ströer 12 | 1 |
| 20 | Ströer (2) | Ströer 12 | 1 |
| 21 | Ströer (3) | Ströer 12 | 1 |
| 22 | Ströer (4) | Ströer 12 | 1 |
| 23 | Ströer (5) | Ströer 12 | 1 |
| 24 | Ströer (6) | Ströer 12 | 1 |
| 25 | Ströer (7) | Ströer 12 | 1 |
| 26 | TV Wartezimmer | TV Wartezimmer 13 | 1 |
| 27 | VIEWENTO GmbH | VIEWENTO GmbH 14 | 1 |
| 28 | WallDecaux | WallDecaux 15 | 1 |
| 29 | X-City Marketing | X-City Marketing 16 | 1 |
| 30 | X-City Marketing (1) | X-City Marketing 16 | 1 |
| 31 | airtango media GmbH | airtango media GmbH 17 | 1 |
| 32 | echion Corporate Communication AG | echion Corporate Communication AG 18 | 1 |
| 33 | inovisco Mobile Media GmbH | inovisco Mobile Media GmbH 19 | 1 |
| 34 | mcR&D | mcR&D 20 | 1 |
| 35 | mcR&D (1) | mcR&D 20 | 1 |
| 36 | Brand Community Network (BCN) (4) | Brand Community Network (BCN) 1 | 0 |
| 37 | Brand Community Network (BCN) (5) | Brand Community Network (BCN) 1 | 0 |
| 38 | Brand Community Network (BCN) (6) | Brand Community Network (BCN) 1 | 0 |
| 39 | Brand Community Network (BCN) (7) | Brand Community Network (BCN) 1 | 0 |
| 40 | Brandstifter AG (1) | Brandstifter AG 2 | 0 |
| 41 | DUS Airport Media | DUS Airport Media 3 | 0 |
| 42 | Diverse (1) | Diverse 4 | 0 |
| 43 | Diverse (2) | Diverse 4 | 0 |
| 44 | Diverse (3) | Diverse 4 | 0 |
| 45 | Edgar Ambient Media Group GmbH (2) | Edgar Ambient Media Group GmbH 5 | 0 |
| 46 | Edgar Ambient Media Group GmbH (3) | Edgar Ambient Media Group GmbH 5 | 0 |
| 47 | Edgar Ambient Media Group GmbH (4) | Edgar Ambient Media Group GmbH 5 | 0 |
| 48 | El Cartel Media (1) | El Cartel Media 6 | 0 |
| 49 | Executive Channel Deutschland GmbH (1) | Executive Channel Deutschland GmbH 7 | 0 |
| 50 | Flughafen Hamburg GmbH | Flughafen Hamburg GmbH 8 | 0 |
| 51 | Goldbach Germany (5) | Goldbach Germany 9 | 0 |
| 52 | Goldbach Germany (6) | Goldbach Germany 9 | 0 |
| 53 | Goldbach Germany (7) | Goldbach Germany 9 | 0 |
| 54 | Goldbach Germany (8) | Goldbach Germany 9 | 0 |
| 55 | Hygh Mobile Media GmbH (1) | Hygh Mobile Media GmbH 10 | 0 |
| 56 | Hygh Mobile Media GmbH (2) | Hygh Mobile Media GmbH 10 | 0 |
| 57 | SK2 Solutions GmbH (1) | SK2 Solutions GmbH 11 | 0 |
| 58 | Ströer (8) | Ströer 12 | 0 |
| 59 | Ströer (9) | Ströer 12 | 0 |
| 60 | Ströer (10) | Ströer 12 | 0 |
| 61 | Ströer (11) | Ströer 12 | 0 |
| 62 | Ströer (12) | Ströer 12 | 0 |
| 63 | Ströer (13) | Ströer 12 | 0 |
| 64 | Ströer (14) | Ströer 12 | 0 |
| 65 | TV Wartezimmer (1) | TV Wartezimmer 13 | 0 |
| 66 | VIEWENTO GmbH (1) | VIEWENTO GmbH 14 | 0 |
| 67 | WallDecaux (1) | WallDecaux 15 | 0 |
| 68 | X-City Marketing (2) | X-City Marketing 16 | 0 |
| 69 | airtango media GmbH (1) | airtango media GmbH 17 | 0 |
| 70 | echion Corporate Communication AG (1) | echion Corporate Communication AG 18 | 0 |
| 71 | inovisco Mobile Media GmbH (1) | inovisco Mobile Media GmbH 19 | 0 |
| 72 | mcR&D (2) | mcR&D 20 | 0 |
| 73 | mcR&D (3) | mcR&D 20 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE spotset ( id INTEGER NOT NULL, name VARCHAR(250), publisher INTEGER, extern BOOLEAN, PRIMARY KEY (id), UNIQUE (id), FOREIGN KEY(publisher) REFERENCES publisher (id) ); CREATE UNIQUE INDEX ix_spotset_name ON spotset (name); CREATE INDEX ix_spotset_extern ON spotset (extern); CREATE INDEX ix_spotset_publisher ON spotset (publisher);