spotset
65 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 | Brand Community Network (BCN) (4) | Brand Community Network (BCN) 1 | 1 |
| 6 | Brandstifter AG | Brandstifter AG 2 | 1 |
| 7 | Diverse | Diverse 3 | 1 |
| 8 | Edgar Ambient Media Group GmbH | Edgar Ambient Media Group GmbH 4 | 1 |
| 9 | Edgar Ambient Media Group GmbH (1) | Edgar Ambient Media Group GmbH 4 | 1 |
| 10 | El Cartel Media | El Cartel Media 5 | 1 |
| 11 | Executive Channel Deutschland GmbH | Executive Channel Deutschland GmbH 6 | 1 |
| 12 | Goldbach Germany | Goldbach Germany 7 | 1 |
| 13 | Goldbach Germany (1) | Goldbach Germany 7 | 1 |
| 14 | Goldbach Germany (2) | Goldbach Germany 7 | 1 |
| 15 | Goldbach Germany (3) | Goldbach Germany 7 | 1 |
| 16 | HYGH AG | HYGH AG 8 | 1 |
| 17 | ISM Intelligent Signage for Media GmbH | ISM Intelligent Signage for Media GmbH 9 | 1 |
| 18 | Piranha Media GmbH | Piranha Media GmbH 10 | 1 |
| 19 | SK2 Solutions GmbH | SK2 Solutions GmbH 11 | 1 |
| 20 | Ströer | Ströer 12 | 1 |
| 21 | Ströer (1) | Ströer 12 | 1 |
| 22 | Ströer (2) | Ströer 12 | 1 |
| 23 | Ströer (3) | Ströer 12 | 1 |
| 24 | Ströer (4) | Ströer 12 | 1 |
| 25 | Ströer (5) | Ströer 12 | 1 |
| 26 | Ströer (6) | Ströer 12 | 1 |
| 27 | TV-Wartezimmer | TV-Wartezimmer 13 | 1 |
| 28 | VIEWENTO GmbH | VIEWENTO GmbH 14 | 1 |
| 29 | WallDecaux | WallDecaux 15 | 1 |
| 30 | X-City Marketing | 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 | Brand Community Network (BCN) (5) | Brand Community Network (BCN) 1 | 0 |
| 36 | Brand Community Network (BCN) (6) | Brand Community Network (BCN) 1 | 0 |
| 37 | Brand Community Network (BCN) (7) | Brand Community Network (BCN) 1 | 0 |
| 38 | Brand Community Network (BCN) (8) | Brand Community Network (BCN) 1 | 0 |
| 39 | Brandstifter AG (1) | Brandstifter AG 2 | 0 |
| 40 | Diverse (1) | Diverse 3 | 0 |
| 41 | Edgar Ambient Media Group GmbH (2) | Edgar Ambient Media Group GmbH 4 | 0 |
| 42 | Edgar Ambient Media Group GmbH (3) | Edgar Ambient Media Group GmbH 4 | 0 |
| 43 | El Cartel Media (1) | El Cartel Media 5 | 0 |
| 44 | Executive Channel Deutschland GmbH (1) | Executive Channel Deutschland GmbH 6 | 0 |
| 45 | Goldbach Germany (4) | Goldbach Germany 7 | 0 |
| 46 | Goldbach Germany (5) | Goldbach Germany 7 | 0 |
| 47 | HYGH AG (1) | HYGH AG 8 | 0 |
| 48 | ISM Intelligent Signage for Media GmbH (1) | ISM Intelligent Signage for Media GmbH 9 | 0 |
| 49 | Piranha Media GmbH (1) | Piranha Media GmbH 10 | 0 |
| 50 | SK2 Solutions GmbH (1) | SK2 Solutions GmbH 11 | 0 |
| 51 | Ströer (7) | Ströer 12 | 0 |
| 52 | Ströer (8) | Ströer 12 | 0 |
| 53 | Ströer (9) | Ströer 12 | 0 |
| 54 | Ströer (10) | Ströer 12 | 0 |
| 55 | Ströer (11) | Ströer 12 | 0 |
| 56 | Ströer (12) | Ströer 12 | 0 |
| 57 | Ströer (13) | Ströer 12 | 0 |
| 58 | TV-Wartezimmer (1) | TV-Wartezimmer 13 | 0 |
| 59 | VIEWENTO GmbH (1) | VIEWENTO GmbH 14 | 0 |
| 60 | WallDecaux (1) | WallDecaux 15 | 0 |
| 61 | X-City Marketing (1) | X-City Marketing 16 | 0 |
| 62 | airtango media GmbH (1) | airtango media GmbH 17 | 0 |
| 63 | echion Corporate Communication AG (1) | echion Corporate Communication AG 18 | 0 |
| 64 | inovisco Mobile Media GmbH (1) | inovisco Mobile Media GmbH 19 | 0 |
| 65 | mcR&D (1) | 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 INDEX ix_spotset_publisher ON spotset (publisher); CREATE UNIQUE INDEX ix_spotset_name ON spotset (name); CREATE INDEX ix_spotset_extern ON spotset (extern);