media_variant

22 rows where media = 53

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
1249 Radio Schlagerparadies 53 DS 1 RHZSCHL_ZT ok 902.12
1252 Radio Schlagerparadies 53 HpT 4 RHZSCHL_ZH ok 902.12
1253 Radio Schlagerparadies 53 Ø 5 RHZSCHL_ZD ok 120.31
1254 Radio Schlagerparadies 53 0500-0600 6 RHZSCHL_FAGA ok 33.65
1255 Radio Schlagerparadies 53 0600-0700 7 RHZSCHL_GAHA ok 57.87
1256 Radio Schlagerparadies 53 0700-0800 8 RHZSCHL_HAIA ok 115.34
1257 Radio Schlagerparadies 53 0800-0900 9 RHZSCHL_IAJA ok 119.42
1258 Radio Schlagerparadies 53 0900-1000 10 RHZSCHL_JAKA ok 109.18
1259 Radio Schlagerparadies 53 1000-1100 11 RHZSCHL_KALA ok 142.28
1260 Radio Schlagerparadies 53 1100-1200 12 RHZSCHL_LAMA ok 116.2
1261 Radio Schlagerparadies 53 1200-1300 13 RHZSCHL_MANA ok 125.69
1262 Radio Schlagerparadies 53 1300-1400 14 RHZSCHL_NAOA ok 120.09
1263 Radio Schlagerparadies 53 1400-1500 15 RHZSCHL_OAPA ok 126.99
1264 Radio Schlagerparadies 53 1500-1600 16 RHZSCHL_PAQA ok 122.2
1265 Radio Schlagerparadies 53 1600-1700 17 RHZSCHL_QARA ok 138.54
1266 Radio Schlagerparadies 53 1700-1800 18 RHZSCHL_RASA ok 115.78
1267 Radio Schlagerparadies 53 1800-1900 19 RHZSCHL_SATA ok 92.29
1268 Radio Schlagerparadies 53 1900-2000 20 RHZSCHL_TAUA ok 65.63
1269 Radio Schlagerparadies 53 2000-2100 21 RHZSCHL_UAVA ok 48.55
1270 Radio Schlagerparadies 53 2100-2200 22 RHZSCHL_VAWA ok 30.15
1271 Radio Schlagerparadies 53 2200-2300 23 RHZSCHL_WAXA ok 23.12
1272 Radio Schlagerparadies 53 2300-2400 24 RHZSCHL_XAYA ok 14.52

Advanced export

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

CSV options: 

CREATE TABLE media_variant (
	id INTEGER NOT NULL, 
	media INTEGER, 
	variant INTEGER, 
	study_code VARCHAR(100), 
	study_status VARCHAR(7), 
	raw_sample INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(media) REFERENCES media (id), 
	FOREIGN KEY(variant) REFERENCES variant (id)
);
CREATE INDEX ix_media_variant_media ON media_variant (media);
CREATE INDEX ix_media_variant_variant ON media_variant (variant);
CREATE INDEX ix_media_variant_study_status ON media_variant (study_status);
CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);