home / NielsenimportMapping

Menu
  • Log in

nielsen_medias

46 rows where gattung = 8

✎ 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
629 1617 970908 WERBESEND. ADRESS. BY Websender 8 13   0   0.0 335000
630 1618 970909 WERBESEND. ADRESS. BB Websender 8 16   0   0.0 335000
631 1619 970910 WERBESEND. ADRESS. BE Websender 8 14   0   0.0 335000
632 1620 970911 WERBESEND. ADRESS. HB Websender 8 7   0   0.0 335000
633 1621 970912 WERBESEND. ADRESS. BW Websender 8 12   0   0.0 335000
634 1622 970913 WERBESEND. ADRESS. HE Websender 8 9   0   0.0 335000
635 1623 970914 WERBESEND. ADRESS. HH Websender 8 5   0   0.0 335000
636 1624 970915 WERBESEND. ADRESS. MV Websender 8 15   0   0.0 335000
637 1625 970916 WERBESEND. ADRESS. NI Websender 8 6   0   0.0 335000
638 1626 970917 WERBESEND. ADRESS. NW Websender 8 8   0   0.0 335000
639 1627 970918 WERBESEND. ADRESS. RP Websender 8 10   0   0.0 335000
640 1628 970919 WERBESEND. ADRESS. SL Websender 8 11   0   0.0 335000
641 1629 970920 WERBESEND. ADRESS. SH Websender 8 4   0   0.0 335000
642 1630 970921 WERBESEND. ADRESS. SN Websender 8 19   0   0.0 335000
643 1631 970922 WERBESEND. ADRESS. ST Websender 8 17   0   0.0 335000
644 1632 970923 WERBESEND. ADRESS. TH Websender 8 18   0   0.0 335000
645 1633 970924 WERBESEND. TEILADRESS. BY Websender 8 13   0   0.0 100000
646 1634 970925 WERBESEND. TEILADRESS. BB Websender 8 16   0   0.0 100000
647 1635 970926 WERBESEND. TEILADRESS. BE Websender 8 14   0   0.0 100000
648 1636 970927 WERBESEND. TEILADRESS. HB Websender 8 7   0   0.0 100000
649 1637 970928 WERBESEND. TEILADRESS. BW Websender 8 12   0   0.0 100000
650 1638 970929 WERBESEND. TEILADRESS. HE Websender 8 9   0   0.0 100000
651 1639 970930 WERBESEND. TEILADRESS. HH Websender 8 5   0   0.0 100000
652 1640 970931 WERBESEND. TEILADRESS. MV Websender 8 15   0   0.0 100000
653 1641 970932 WERBESEND. TEILADRESS. NI Websender 8 6   0   0.0 100000
654 1642 970933 WERBESEND. TEILADRESS. NW Websender 8 8   0   0.0 100000
655 1643 970934 WERBESEND. TEILADRESS. RP Websender 8 10   0   0.0 100000
656 1644 970935 WERBESEND. TEILADRESS. SL Websender 8 11   0   0.0 100000
657 1645 970936 WERBESEND. TEILADRESS. SH Websender 8 4   0   0.0 100000
658 1646 970937 WERBESEND. TEILADRESS. SN Websender 8 19   0   0.0 100000
659 1647 970938 WERBESEND. TEILADRESS. ST Websender 8 17   0   0.0 100000
660 1648 970939 WERBESEND. TEILADRESS. TH Websender 8 18   0   0.0 100000
661 1649 970940 WERBESEND. UNADRESS. BY Websender 8 13   0   0.0 16000
662 1650 970941 WERBESEND. UNADRESS. BB Websender 8 16   0   0.0 16000
663 1651 970942 WERBESEND. UNADRESS. BE Websender 8 14   0   0.0 16000
664 1653 970944 WERBESEND. UNADRESS. BW Websender 8 12   0   0.0 16000
665 1654 970945 WERBESEND. UNADRESS. HE Websender 8 9   0   0.0 16000
666 1655 970946 WERBESEND. UNADRESS. HH Websender 8 5   0   0.0 16000
667 1656 970947 WERBESEND. UNADRESS. MV Websender 8 15   0   0.0 16000
668 1657 970948 WERBESEND. UNADRESS. NI Websender 8 6   0   0.0 16000
669 1658 970949 WERBESEND. UNADRESS. NW Websender 8 8   0   0.0 16000
670 1659 970950 WERBESEND. UNADRESS. RP Websender 8 10   0   0.0 16000
671 1661 970952 WERBESEND. UNADRESS. SH Websender 8 4   0   0.0 16000
672 1662 970953 WERBESEND. UNADRESS. SN Websender 8 19   0   0.0 16000
673 1663 970954 WERBESEND. UNADRESS. ST Websender 8 17   0   0.0 16000
674 1664 970955 WERBESEND. UNADRESS. TH Websender 8 18   0   0.0 16000

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