73 rows

View and edit SQL

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

CSV options:

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);