media_variant

22 rows where media = 222

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
5305 HITRADIO OHR 222 DS 1 RHDHROH_ZT ok 202.26
5308 HITRADIO OHR 222 HpT 4 RHDHROH_ZH ok 202.26
5309 HITRADIO OHR 222 Ø 5 RHDHROH_ZD ok 34.22
5310 HITRADIO OHR 222 0500-0600 6 RHDHROH_FAGA ok 13.2
5311 HITRADIO OHR 222 0600-0700 7 RHDHROH_GAHA ok 48.1
5312 HITRADIO OHR 222 0700-0800 8 RHDHROH_HAIA ok 49.39
5313 HITRADIO OHR 222 0800-0900 9 RHDHROH_IAJA ok 37.32
5314 HITRADIO OHR 222 0900-1000 10 RHDHROH_JAKA ok 24.99
5315 HITRADIO OHR 222 1000-1100 11 RHDHROH_KALA ok 31.77
5316 HITRADIO OHR 222 1100-1200 12 RHDHROH_LAMA ok 26.26
5317 HITRADIO OHR 222 1200-1300 13 RHDHROH_MANA ok 37.02
5318 HITRADIO OHR 222 1300-1400 14 RHDHROH_NAOA ok 36.21
5319 HITRADIO OHR 222 1400-1500 15 RHDHROH_OAPA ok 29.43
5320 HITRADIO OHR 222 1500-1600 16 RHDHROH_PAQA ok 25.86
5321 HITRADIO OHR 222 1600-1700 17 RHDHROH_QARA ok 31.23
5322 HITRADIO OHR 222 1700-1800 18 RHDHROH_RASA ok 25.96
5323 HITRADIO OHR 222 1800-1900 19 RHDHROH_SATA ok 18.21
5324 HITRADIO OHR 222 1900-2000 20 RHDHROH_TAUA ok 17.36
5325 HITRADIO OHR 222 2000-2100 21 RHDHROH_UAVA ok 11.69
5326 HITRADIO OHR 222 2100-2200 22 RHDHROH_VAWA ok 4.05
5327 HITRADIO OHR 222 2200-2300 23 RHDHROH_WAXA ok 1.1
5328 HITRADIO OHR 222 2300-2400 24 RHDHROH_XAYA ok 1.11

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