nielsen_medias

9 rows where medimach_code = 78

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ code title medimach_code
114 906000 BAYERISCHER RUNDF. TV TARD 78
575 903000 HESSISCHER RUNDFUNK TV TARD 78
738 900700 MITTELDEUTSCH.RUNDF.TV TARD 78
823 901000 NORDDEUTSCHER RUNDF.TV TARD 78
909 909000 RADIO BREMEN TV TARD 78
973 905000 SAARLAEND.RUNDFUNK TV TARD 78
994 907000 RBB TV TARD 78
1081 904000 SWR WERBEFERNSEHEN TARD 78
1193 902000 WESTDT.RUNDFUNK TV TARD 78

Advanced export

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

CSV options: 

CREATE TABLE nielsen_medias (
	id INTEGER NOT NULL, 
	code VARCHAR(100), 
	title VARCHAR(250), 
	medimach_code INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(medimach_code) REFERENCES medimach_codes (id)
);
CREATE UNIQUE INDEX ix_nielsen_medias_code ON nielsen_medias (code);
CREATE INDEX ix_nielsen_medias_medimach_code ON nielsen_medias (medimach_code);