media

18 rows where touchpoint = 17

✎ 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
BJ_0_000 Mall Touchpoint Shopping Mall 17 Brand Community Network (BCN) 1 39 309 1 45
CC_0_000 Mall Channel Shopping Mall 17 Goldbach Germany 9 41 776 1 48
FB_A_000 Mall Video Deutschland Shopping Mall 17 Ströer 12 119 2345 1 128
FB_B_000 Mall Video Baden-Württemberg Shopping Mall 17 Ströer 12 7 104 1 129
FB_C_000 Mall Video Bayern Shopping Mall 17 Ströer 12 13 283 1 130
FB_D_000 Mall Video Berlin Shopping Mall 17 Ströer 12 13 251 1 131
FB_E_000 Mall Video Brandenburg Shopping Mall 17 Ströer 12 3 56 1 132
FB_F_000 Mall Video Bremen Shopping Mall 17 Ströer 12 2 20 1 133
FB_G_000 Mall Video Hamburg Shopping Mall 17 Ströer 12 11 243 1 134
FB_H_000 Mall Video Hessen Shopping Mall 17 Ströer 12 11 190 1 135
FB_I_000 Mall Video Mecklenburg-Vorpommern Shopping Mall 17 Ströer 12 3 51 1 136
FB_J_000 Mall Video Niedersachsen Shopping Mall 17 Ströer 12 10 190 1 137
FB_K_000 Mall Video Nordrhein-Westfalen Shopping Mall 17 Ströer 12 22 496 1 138
FB_L_000 Mall Video Rheinland-Pfalz Shopping Mall 17 Ströer 12 4 86 1 139
FB_M_000 Mall Video Saarland Shopping Mall 17 Ströer 12 2 54 1 140
FB_N_000 Mall Video Sachsen Shopping Mall 17 Ströer 12 11 190 1 141
FB_O_000 Mall Video Sachsen-Anhalt Shopping Mall 17 Ströer 12 4 85 1 142
FB_P_000 Mall Video Schleswig-Holstein Shopping Mall 17 Ströer 12 3 46 1 143

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