nielsen_medias

10 rows where gattung = 15

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ mediaDetailCodeId code title gattung idTb studyCode noTablesGesamt time factorDefault costPerGroup
2804   980472 FACEBOOK MOBILE SOCIAL 15 1          
2805   980474 X (TWITTER) MOBILE SOCIAL 15 1          
2806   980800 FACEBOOK DESKTOP SOCIAL 15 1          
2807   980892 INSTAGRAM MOBILE SOCIAL 15 1          
2808   980801 X (TWITTER) DESKTOP SOCIAL 15 1          
3077   981111 TIKTOK MOBILE SOCIAL 15 1          
3078   981124 PINTEREST MOBILE SOCIAL 15 1          
3079   981134 LINKEDIN MOBILE SOCIAL 15 1          
3080   981530 LINKEDIN DESKTOP SOCIAL 15 1          
3081   981587 REDDIT DESKTOP SOCIAL 15 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);