media_variant

22 rows where media = 51

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
1201 Klassik Radio 51 DS 1 RHZKLAR_ZT ok 1945.11
1204 Klassik Radio 51 HpT 4 RHZKLAR_ZH ok 1945.11
1205 Klassik Radio 51 Ø 5 RHZKLAR_ZD ok 230.12
1206 Klassik Radio 51 0500-0600 6 RHZKLAR_FAGA ok 44.25
1207 Klassik Radio 51 0600-0700 7 RHZKLAR_GAHA ok 111.03
1208 Klassik Radio 51 0700-0800 8 RHZKLAR_HAIA ok 243.82
1209 Klassik Radio 51 0800-0900 9 RHZKLAR_IAJA ok 279.7
1210 Klassik Radio 51 0900-1000 10 RHZKLAR_JAKA ok 278.93
1211 Klassik Radio 51 1000-1100 11 RHZKLAR_KALA ok 247.59
1212 Klassik Radio 51 1100-1200 12 RHZKLAR_LAMA ok 217.56
1213 Klassik Radio 51 1200-1300 13 RHZKLAR_MANA ok 210.29
1214 Klassik Radio 51 1300-1400 14 RHZKLAR_NAOA ok 178.77
1215 Klassik Radio 51 1400-1500 15 RHZKLAR_OAPA ok 140.73
1216 Klassik Radio 51 1500-1600 16 RHZKLAR_PAQA ok 187.53
1217 Klassik Radio 51 1600-1700 17 RHZKLAR_QARA ok 218.35
1218 Klassik Radio 51 1700-1800 18 RHZKLAR_RASA ok 235.15
1219 Klassik Radio 51 1800-1900 19 RHZKLAR_SATA ok 288.86
1220 Klassik Radio 51 1900-2000 20 RHZKLAR_TAUA ok 202.83
1221 Klassik Radio 51 2000-2100 21 RHZKLAR_UAVA ok 112.28
1222 Klassik Radio 51 2100-2200 22 RHZKLAR_VAWA ok 52.41
1223 Klassik Radio 51 2200-2300 23 RHZKLAR_WAXA ok 77.23
1224 Klassik Radio 51 2300-2400 24 RHZKLAR_XAYA ok 50.27

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 UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);
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);