media

10 rows where publisher = 5

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: touchpoint, extern

id ▼ title touchpoint publisher count_locations count_screens extern order
DA_0_000 EAM Gesamt Gesamt 12 Edgar Ambient Media Group GmbH 5 3350 41041 0 60
DB_0_000 Campus TV Universität/ Hochschule 21 Edgar Ambient Media Group GmbH 5 16 40 1 61
DC_0_000 Active TV Fitnessstudio 10 Edgar Ambient Media Group GmbH 5 613 613 0 62
DD_0_000 Cinema Channel Kino 15 Edgar Ambient Media Group GmbH 5 184 191 1 63
DE_0_000 Public Video Scene Gastronomie 11 Edgar Ambient Media Group GmbH 5 917 947 1 64
DF_0_000 McDonalds Fast Food 8 Edgar Ambient Media Group GmbH 5 678 1060 1 65
DG_0_000 Media Markt Elektronikmarkt 6 Edgar Ambient Media Group GmbH 5 248 19840 1 66
DH_0_000 Saturn Elektronikmarkt 6 Edgar Ambient Media Group GmbH 5 132 10560 1 67
DI_0_000 Medimax Elektronikmarkt 6 Edgar Ambient Media Group GmbH 5 85 6800 0 68
DJ_0_000 Retail TV Food Neo Supermarkt 18 Edgar Ambient Media Group GmbH 5 740 2400 1 69

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