nielsen_medias

15 rows where medimach_code = 74

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ code title medimach_code
96 511200 BAMS SBAS 74
97 90 BAMS ACN 1 SBAS 74
98 970571 BAMS ACN 1+2+3A SBAS 74
99 970107 BAMS ACN 1+3+4+5+6+7 SBAS 74
100 91 BAMS ACN 2 SBAS 74
101 970445 BAMS ACN 2-7 SBAS 74
102 970555 BAMS ACN 2+3A+4 SBAS 74
103 970115 BAMS ACN 3 SBAS 74
104 92 BAMS ACN 3A SBAS 74
105 93 BAMS ACN 3B SBAS 74
106 94 BAMS ACN 4 SBAS 74
107 970096 BAMS ACN 5+6+7 SBAS 74
108 970123 BAMS ACN_12 SBAS 74
109 970112 BAMS ACN_13A SBAS 74
110 970663 BAMS ACN_5 SBAS 74

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