nielsen_medias

35 rows where gattung = 13

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: idTb, costPerGroup

id ▼ mediaDetailCodeId code title gattung idTb studyCode noTablesGesamt time factorDefault costPerGroup
2484   971672 OUTLETS UEBERREGIONAL AT-RETAIL-MEDIA 13 1 A__FG       21240
2485   971673 OUTLETS BY AT-RETAIL-MEDIA 13 13 A__FG       21131
2486   971674 OUTLETS BB AT-RETAIL-MEDIA 13 16 A__FG       21262
2487   971675 OUTLETS BE AT-RETAIL-MEDIA 13 14 A__FG       21000
2488   971676 OUTLETS HB AT-RETAIL-MEDIA 13 7 A__FG       21327
2489   971677 OUTLETS BW AT-RETAIL-MEDIA 13 12 A__FG       21305
2490   971678 OUTLETS HE AT-RETAIL-MEDIA 13 9 A__FG       20957
2491   971679 OUTLETS HH AT-RETAIL-MEDIA 13 5 A__FG       21153
2492   971680 OUTLETS MV AT-RETAIL-MEDIA 13 15 A__FG       21196
2493   971681 OUTLETS NI AT-RETAIL-MEDIA 13 6 A__FG       21175
2494   971682 OUTLETS NW AT-RETAIL-MEDIA 13 8 A__FG       21305
2495   971683 OUTLETS RP AT-RETAIL-MEDIA 13 10 A__FG       21196
2496   971684 OUTLETS SL AT-RETAIL-MEDIA 13 11 A__FG       21458
2497   971686 OUTLETS SN AT-RETAIL-MEDIA 13 19 A__FG       21480
2498   971687 OUTLETS ST AT-RETAIL-MEDIA 13 17 A__FG       21589
2499   971689 TANKSTELLEN UEBERREGIONAL AT-RETAIL-MEDIA 13 1 A__FG       21240
2500   971690 TANKSTELLEN BY AT-RETAIL-MEDIA 13 13 A__FG       21131
2501   971691 TANKSTELLEN BB AT-RETAIL-MEDIA 13 16 A__FG       21262
2502   971692 TANKSTELLEN BE AT-RETAIL-MEDIA 13 14 A__FG       21000
2503   971693 TANKSTELLEN HB AT-RETAIL-MEDIA 13 7 A__FG       21327
2504   971694 TANKSTELLEN BW AT-RETAIL-MEDIA 13 12 A__FG       21305
2505   971695 TANKSTELLEN HE AT-RETAIL-MEDIA 13 9 A__FG       20957
2506   971696 TANKSTELLEN HH AT-RETAIL-MEDIA 13 5 A__FG       21153
2507   971697 TANKSTELLEN MV AT-RETAIL-MEDIA 13 15 A__FG       21196
2508   971698 TANKSTELLEN NI AT-RETAIL-MEDIA 13 6 A__FG       21175
2509   971699 TANKSTELLEN NW AT-RETAIL-MEDIA 13 8 A__FG       21305
2510   971700 TANKSTELLEN RP AT-RETAIL-MEDIA 13 10 A__FG       21196
2511   971701 TANKSTELLEN SL AT-RETAIL-MEDIA 13 11 A__FG       21458
2512   971702 TANKSTELLEN SH AT-RETAIL-MEDIA 13 4 A__FG       21196
2513   971703 TANKSTELLEN SN AT-RETAIL-MEDIA 13 19 A__FG       21480
2514   971704 TANKSTELLEN ST AT-RETAIL-MEDIA 13 17 A__FG       21589
2515   971705 TANKSTELLEN TH AT-RETAIL-MEDIA 13 18 A__FG       21545
2516   977353 SONSTIGE AT-RETAIL-MEDIA AT-RETAIL-MEDIA 13 1 A__FG       21240
2638   971685 OUTLETS SH AT-RETAIL-MEDIA 13 4 A__FG       21196
2839   971688 OUTLETS TH AT-RETAIL-MEDIA 13 18 A__FG       21545

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