nielsen_medias

12 rows where gattung = 17

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ mediaDetailCodeId code title gattung idTb studyCode noTablesGesamt time factorDefault costPerGroup
3086   981550 PRIMEVIDEO.COM CTV CTV 17 1          
3087   981551 SKY.DE CTV CTV 17 1          
3088   981552 NETFLIX.COM CTV CTV 17 1          
3089   981553 DAZN.COM CTV CTV 17 1          
3090   981554 PLUTO.TV CTV CTV 17 1          
3091   981555 JOYN.DE CTV CTV 17 1          
3092   981588 DISNEYPLUS.COM CTV CTV 17 1          
3093   981589 PLUS.RTL.DE CTV CTV 17 1          
3094   981590 WOWTV.DE CTV CTV 17 1          
3095   981591 WAIPU.TV CTV CTV 17 1          
3096   981592 YOUTUBE.COM CTV CTV 17 1          
3097   981593 PARAMOUNTPLUS.COM CTV CTV 17 1          

Advanced export

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

CSV options: 

CREATE TABLE nielsen_medias (
	id INTEGER NOT NULL, 
	"mediaDetailCodeId" INTEGER, 
	code INTEGER, 
	title VARCHAR, 
	gattung INTEGER, 
	"idTb" INTEGER, 
	"studyCode" VARCHAR, 
	"noTablesGesamt" INTEGER, 
	time VARCHAR, 
	"factorDefault" FLOAT, 
	"costPerGroup" INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(gattung) REFERENCES media_gattung (id)
);
CREATE INDEX "ix_nielsen_medias_studyCode" ON nielsen_medias ("studyCode");
CREATE INDEX ix_nielsen_medias_time ON nielsen_medias (time);
CREATE INDEX ix_nielsen_medias_title ON nielsen_medias (title);