home / NielsenimportMapping

Menu
  • Log in

nielsen_medias

489 rows where gattung = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: idTb

id ▼ mediaDetailCodeId code title gattung idTb studyCode noTablesGesamt time factorDefault costPerGroup
522 1211 971881 RTL.DE Computer 7 1 AGOF_rtl 0   0.0 0
523 1212 971886 N-TV.DE Computer 7 1 AGOF_ntv 0   0.0 0
524 1213 971889 VOX.DE Computer 7 1 AGOF_vox 0   0.0 0
525 1214 971890 WETTER.DE Computer 7 1 AGOF_IPN10045 0   0.0 0
526 1218 971896 MOBILE.DE Computer 7 1 AGOF_mobile 0   0.0 0
527 1220 971898 NETP.ROT. Computer 7 1   0   0.0 0
528 1221 971899 NETP.ROT.AZUBIS, STUDENTE Computer 7 1   0   0.0 0
529 1223 971930 TAGESSPIEGEL.DE Computer 7 1 AGOF_tagspieg 0   0.0 0
530 1234 971950 HANDELSBLATT.COM Computer 7 1 AGOF_handbl 0   0.0 0
531 1239 971956 WIWO.DE Computer 7 1 AGOF_wirtwoch 0   0.0 0
532 1241 971958 ZEIT.DE Computer 7 1 AGOF_zeitonl 0   0.0 0
533 1243 971961 GLAMOUR.DE Computer 7 1 AGOF_glamour 0   0.0 0
534 1245 971963 GQ-MAGAZIN.DE Computer 7 1 AGOF_gqcom 0   0.0 0
535 1246 971964 JETZT.DE Computer 7 1 AGOF_YAH71015 0   0.0 0
536 1247 971965 KICKER.DE Computer 7 1 AGOF_kicker 0   0.0 0
537 1248 971966 MANAGER-MAGAZIN.DE Computer 7 1 AGOF_managerm 0   0.0 0
538 1249 971968 MOTORSPORT-TOTAL.COM Computer 7 1   0   0.0 0
539 1252 971972 SPIEGEL.DE Computer 7 1 AGOF_spiegel 0   0.0 0
540 1253 971973 SUEDDEUTSCHE.DE Computer 7 1 AGOF_sueddeut 0   0.0 0
541 1256 971979 KABELEINS.DE Computer 7 1 AGOF_kabel1 0   0.0 0
542 1261 971984 PROSIEBEN.DE Computer 7 1 AGOF_pro7 0   0.0 0
543 1262 971985 SAT1.DE Computer 7 1 AGOF_sat1 0   0.0 0
544 1263 971986 WETTER.COM Computer 7 1 AGOF_wetter 0   0.0 0
545 1264 971987 GMX.NET Computer 7 1 AGOF_gmx 0   0.0 0
546 1266 971989 WEB.DE Computer 7 1 AGOF_webdessl 0   0.0 0
547 1267 971990 HOME.1UND1.DE Computer 7 1 AGOF_1und1 0   0.0 0
548 1271 971999 BRIGITTE.DE Computer 7 1 AGOF_brigitte 0   0.0 0
549 1273 972001 CAPITAL.DE Computer 7 1 AGOF_capital 0   0.0 0
550 1276 972004 ELTERN.DE Computer 7 1 AGOF_eltern 0   0.0 0
551 1278 972009 GEO.DE Computer 7 1 AGOF_geo 0   0.0 0
552 1280 972013 LIVINGATHOME.DE Computer 7 1 AGOF_livingat 0   0.0 0
553 1284 972018 STERN.DE Computer 7 1 AGOF_stern 0   0.0 0
554 1294 972049 CHIP.DE Computer 7 1 AGOF_chip 0   0.0 0
555 1295 972053 FREUNDIN.DE Computer 7 1 AGOF_freundin 0   0.0 0
556 1296 972055 ELLE.DE Computer 7 1 AGOF_elle 0   0.0 0
557 1297 972059 FOCUS.DE Computer 7 1 AGOF_focus 0   0.0 0
558 1299 972062 GUTER-RAT.DE Computer 7 1 AGOF_guterrat 0   0.0 0
559 1300 972063 HAUS.DE Computer 7 1   0   0.0 0
560 1301 972064 HOLIDAYCHECK.DE Computer 7 1 AGOF_holidayc 0   0.0 0
561 1304 972074 MEINE-FAMILIE-UND-ICH.DE Computer 7 1   0   0.0 0
562 1306 972080 PLAYBOY.DE Computer 7 1 AGOF_playboy 0   0.0 0
563 1307 972085 SUPERILLU.DE Computer 7 1 AGOF_superill 0   0.0 0
564 1308 972087 BU.FO. ROT. Computer 7 1   0   0.0 0
565 1310 972090 TVSPIELFILM.DE Computer 7 1 AGOF_tvspielf 0   0.0 0
566 1312 972095 SPORT.DE Computer 7 1   0   0.0 0
567 1316 972107 NETP.ROT.NEWS, WIRTSCHAFT Computer 7 1   0   0.0 0
568 1321 972122 BOERSE.DE Computer 7 1 AGOF_boersely 0   0.0 0
569 1322 972123 CHEFKOCH.DE Computer 7 1 AGOF_chefkoch 0   0.0 0
570 1323 972124 CLEVER-TANKEN.DE Computer 7 1   0   0.0 0
573 1349 972057 FITFORFUN.DE Computer 7 1 AGOF_fitforfu 0   0.0 0
574 1353 972224 BUNTE.DE Computer 7 1 AGOF_bunteton 0   0.0 0
575 1354 972227 LUST-AUF-GENUSS.DE Computer 7 1 SKKU 0   0.0 0
578 1365 972253 FAZ.NET Computer 7 1 AGOF_faz 0   0.0 0
580 1371 972008 GALA.DE Computer 7 1 AGOF_gala 0   0.0 0
581 1372 972021 VODAFONELIVE.DE Computer 7 1   0   0.0 0
582 1375 972100 ESSEN-UND-TRINKEN.DE Computer 7 1 AGOF_esundtri 0   0.0 0
583 1394 972051 CINEMA.DE Computer 7 1 AGOF_cinema 0   0.0 0
587 1408 972078 MUSIKEXPRESS.DE Computer 7 1 AGOF_AXL11105 0   0.0 0
588 1409 972089 TVTODAY.DE Computer 7 1   0   0.0 0
591 1422 972006 EMOTION.DE Computer 7 1   0   0.0 0
592 1425 972168 PRINZ.DE Computer 7 1 AGOF_prinz 0   0.0 0
595 1438 972076 MEIN-SCHOENER-GARTEN.DE Computer 7 1 AGOF_msg 0   0.0 0
596 1439 972277 GOLEM.DE Computer 7 1 AGOF_golem 0   0.0 0
597 1440 972296 NETMOMS.DE Computer 7 1 AGOF_anetmoms 0   0.0 0
599 1468 972096 VIP.DE Computer 7 1 AGOF_viprtl 0   0.0 0
600 1470 972345 KOCHBAR.DE Computer 7 1 AGOF_kochbar 0   0.0 0
601 1473 972393 MAMIWEB.DE Computer 7 1 AGOF_mamiweb 0   0.0 0
608 1506 972897 SCHOENER-WOHNEN.DE Computer 7 1 AGOF_schowohn 0   0.0 0
609 1507 972898 VODAFONE.DE Computer 7 1 AGOF_vodafone 0   0.0 0
610 1522 972478 AUTOSCOUT24.DE Computer 7 1 AGOF_INT10182 0   0.0 0
611 1524 972908 LECKER.DE Computer 7 1 AGOF_leckerde 0   0.0 0
612 1536 972385 RTLNOW.DE Computer 7 1 AGOF_IPN10115 0   0.0 0
613 1540 972916 9MONATE.DE Computer 7 1 AGOF_BUR10526 0   0.0 0
615 1552 972932 WUNDERWEIB.DE Computer 7 1 AGOF_wuweib 0   0.0 0
619 1567 972995 TVTV.DE Computer 7 1 AGOF_HIM10393 0   0.0 0
620 1573 972956 FINANZEN100.DE Computer 7 1 AGOF_finan100 0   0.0 0
622 1577 972957 VOXNOW.DE Computer 7 1 AGOF_IPN10359 0   0.0 0
628 1611 972043 SPORT1.DE Computer 7 1 AGOF_sport1 0   0.0 0
675 1671 973094 SIXX.DE Computer 7 1 AGOF_fem 0   0.0 0
679 1719 971888 RTL2.DE Computer 7 1 AGOF_rtl2 0   0.0 0
680 1721 972065 JOLIE.DE Computer 7 1 AGOF_jolie 0   0.0 0
681 1724 972297 NETDOKTOR.DE Computer 7 1 AGOF_netdok 0   0.0 0
682 1726 972374 DASKOCHREZEPT.DE Computer 7 1 AGOF_kochzept 0   0.0 0
683 1731 972556 T-ONLINE.DE Computer 7 1 AGOF_toi 0   0.0 0
684 1737 972691 COSMOPOLITAN.DE Computer 7 1 AGOF_cosmopol 0   0.0 0
685 1749 973136 RADIO.DE Computer 7 1 AGOF_radiode 0   0.0 0
686 1751 973147 INSTYLE.DE Computer 7 1 AGOF_instyle 0   0.0 0
689 1775 973288 KAUFDA.DE Computer 7 1   0   0.0 0
690 1784 972754 GESUNDHEIT.DE Computer 7 1 AGOF_gesundde 0   0.0 0
693 1790 973302 SDM RON Computer 7 1 AGOF_INT25021 0   0.0 0
695 1805 973349 SDM ROC SPORTS Computer 7 1 AGOF_INT80023 0   0.0 0
696 1808 972415 11FREUNDE.DE Computer 7 1 AGOF_11freu 0   0.0 0
701 1835 972822 MOTORVISION.TV Computer 7 1 AGOF_motorvis 0   0.0 0
702 1849 972105 NETPOINT MEDIA SONSTIGE Computer 7 1   0   0.0 0
704 1858 973536 HI MEDIA VERMARKTER Computer 7 1   0   0.0 0
705 1861 972324 FREENET.DE Computer 7 1 AGOF_freenet 0   0.0 0
706 1866 973107 WINFUTURE.DE Computer 7 1 AGOF_winfut 0   0.0 0
708 1885 972553 TRANSFERMARKT.DE Computer 7 1 AGOF_transfer 0   0.0 0
710 1897 974061 DOODLE.COM Computer 7 1 AGOF_doodle 0   0.0 0
711 1903 972759 GIGA.DE Computer 7 1 AGOF_giga 0   0.0 0

Next page

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);
Powered by Datasette · Queries took 1.2ms