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 Paloma 53 DS 1 RHERAPA_ZT ok 571.03
1252 Radio Paloma 53 HpT 4 RHERAPA_ZH ok 571.03
1253 Radio Paloma 53 Ø 5 RHERAPA_ZD ok 82.19
1254 Radio Paloma 53 0500-0600 6 RHERAPA_FAGA ok 10.93
1255 Radio Paloma 53 0600-0700 7 RHERAPA_GAHA ok 32.43
1256 Radio Paloma 53 0700-0800 8 RHERAPA_HAIA ok 39.62
1257 Radio Paloma 53 0800-0900 9 RHERAPA_IAJA ok 83.68
1258 Radio Paloma 53 0900-1000 10 RHERAPA_JAKA ok 99.14
1259 Radio Paloma 53 1000-1100 11 RHERAPA_KALA ok 82.05
1260 Radio Paloma 53 1100-1200 12 RHERAPA_LAMA ok 90.32
1261 Radio Paloma 53 1200-1300 13 RHERAPA_MANA ok 103.84
1262 Radio Paloma 53 1300-1400 14 RHERAPA_NAOA ok 103.82
1263 Radio Paloma 53 1400-1500 15 RHERAPA_OAPA ok 94.47
1264 Radio Paloma 53 1500-1600 16 RHERAPA_PAQA ok 90.95
1265 Radio Paloma 53 1600-1700 17 RHERAPA_QARA ok 77.7
1266 Radio Paloma 53 1700-1800 18 RHERAPA_RASA ok 59.1
1267 Radio Paloma 53 1800-1900 19 RHERAPA_SATA ok 50.65
1268 Radio Paloma 53 1900-2000 20 RHERAPA_TAUA ok 33.17
1269 Radio Paloma 53 2000-2100 21 RHERAPA_UAVA ok 27.4
1270 Radio Paloma 53 2100-2200 22 RHERAPA_VAWA ok 20.97
1271 Radio Paloma 53 2200-2300 23 RHERAPA_WAXA ok 22.54
1272 Radio Paloma 53 2300-2400 24 RHERAPA_XAYA ok 16.46

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