media_variant

22 rows where media = 228

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
5449 HITRADIO OHR 228 DS 1 RHDHROH_ZT ok 209.89
5452 HITRADIO OHR 228 HpT 4 RHDHROH_ZH ok 209.89
5453 HITRADIO OHR 228 Ø 5 RHDHROH_ZD ok 32.41
5454 HITRADIO OHR 228 0500-0600 6 RHDHROH_FAGA ok 9.99
5455 HITRADIO OHR 228 0600-0700 7 RHDHROH_GAHA ok 49.65
5456 HITRADIO OHR 228 0700-0800 8 RHDHROH_HAIA ok 52.4
5457 HITRADIO OHR 228 0800-0900 9 RHDHROH_IAJA ok 35.07
5458 HITRADIO OHR 228 0900-1000 10 RHDHROH_JAKA ok 23.75
5459 HITRADIO OHR 228 1000-1100 11 RHDHROH_KALA ok 24.47
5460 HITRADIO OHR 228 1100-1200 12 RHDHROH_LAMA ok 29.95
5461 HITRADIO OHR 228 1200-1300 13 RHDHROH_MANA ok 30.85
5462 HITRADIO OHR 228 1300-1400 14 RHDHROH_NAOA ok 33.55
5463 HITRADIO OHR 228 1400-1500 15 RHDHROH_OAPA ok 21.69
5464 HITRADIO OHR 228 1500-1600 16 RHDHROH_PAQA ok 22.1
5465 HITRADIO OHR 228 1600-1700 17 RHDHROH_QARA ok 29.53
5466 HITRADIO OHR 228 1700-1800 18 RHDHROH_RASA ok 30.03
5467 HITRADIO OHR 228 1800-1900 19 RHDHROH_SATA ok 21.8
5468 HITRADIO OHR 228 1900-2000 20 RHDHROH_TAUA ok 11.48
5469 HITRADIO OHR 228 2000-2100 21 RHDHROH_UAVA ok 11.69
5470 HITRADIO OHR 228 2100-2200 22 RHDHROH_VAWA ok 7.61
5471 HITRADIO OHR 228 2200-2300 23 RHDHROH_WAXA ok 4.11
5472 HITRADIO OHR 228 2300-2400 24 RHDHROH_XAYA ok 1.17

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