media

14 rows where touchpoint = 20

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: publisher, count_locations, count_screens

id ▼ title touchpoint publisher count_locations count_screens extern order
CF_0_000 CityNet Tube Bochum U-Bahnhof 20 Goldbach Germany 9 2 20 1 51
CJ_0_000 Berlin DigitalNet U-Bahnhof 20 WallDecaux 15 25 92 1 59
EF_1_000 X-City Hannover Station U-Bahnhof 20 X-City Marketing 16 6 33 1 83
FA_A_000 Infoscreen Deutschland U-Bahnhof 20 Ströer 12 129 769 1 117
FA_B_000 Infoscreen Baden-Württemberg U-Bahnhof 20 Ströer 12 14 114 1 118
FA_C_000 Infoscreen Bayern U-Bahnhof 20 Ströer 12 30 187 1 119
FA_D_000 Infoscreen Berlin U-Bahnhof 20 Ströer 12 6 25 1 120
FA_F_000 Infoscreen Bremen U-Bahnhof 20 Ströer 12 1 1 1 121
FA_G_000 Infoscreen Hamburg U-Bahnhof 20 Ströer 12 16 144 1 122
FA_H_000 Infoscreen Hessen U-Bahnhof 20 Ströer 12 11 98 1 123
FA_J_000 Infoscreen Niedersachsen U-Bahnhof 20 Ströer 12 8 38 1 124
FA_K_000 Infoscreen Nordrhein-Westfalen U-Bahnhof 20 Ströer 12 39 150 1 125
FA_N_000 Infoscreen Sachsen U-Bahnhof 20 Ströer 12 3 11 1 126
FA_O_000 Infoscreen Sachsen-Anhalt U-Bahnhof 20 Ströer 12 1 1 1 127

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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