media_variant

22 rows where media = 148

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
3529 HIT RADIO FFH 148 DS 1 RHCRFFH_ZT ok 1626.21
3532 HIT RADIO FFH 148 HpT 4 RHCRFFH_ZH ok 1626.21
3533 HIT RADIO FFH 148 Ø 5 RHCRFFH_ZD ok 248.04
3534 HIT RADIO FFH 148 0500-0600 6 RHCRFFH_FAGA ok 112.13
3535 HIT RADIO FFH 148 0600-0700 7 RHCRFFH_GAHA ok 206.73
3536 HIT RADIO FFH 148 0700-0800 8 RHCRFFH_HAIA ok 333.86
3537 HIT RADIO FFH 148 0800-0900 9 RHCRFFH_IAJA ok 337.44
3538 HIT RADIO FFH 148 0900-1000 10 RHCRFFH_JAKA ok 307.94
3539 HIT RADIO FFH 148 1000-1100 11 RHCRFFH_KALA ok 231.11
3540 HIT RADIO FFH 148 1100-1200 12 RHCRFFH_LAMA ok 234.15
3541 HIT RADIO FFH 148 1200-1300 13 RHCRFFH_MANA ok 208.07
3542 HIT RADIO FFH 148 1300-1400 14 RHCRFFH_NAOA ok 197.06
3543 HIT RADIO FFH 148 1400-1500 15 RHCRFFH_OAPA ok 202.95
3544 HIT RADIO FFH 148 1500-1600 16 RHCRFFH_PAQA ok 180.27
3545 HIT RADIO FFH 148 1600-1700 17 RHCRFFH_QARA ok 249.77
3546 HIT RADIO FFH 148 1700-1800 18 RHCRFFH_RASA ok 233.41
3547 HIT RADIO FFH 148 1800-1900 19 RHCRFFH_SATA ok 185.32
3548 HIT RADIO FFH 148 1900-2000 20 RHCRFFH_TAUA ok 110.94
3549 HIT RADIO FFH 148 2000-2100 21 RHCRFFH_UAVA ok 68.03
3550 HIT RADIO FFH 148 2100-2200 22 RHCRFFH_VAWA ok 36.64
3551 HIT RADIO FFH 148 2200-2300 23 RHCRFFH_WAXA ok 26.61
3552 HIT RADIO FFH 148 2300-2400 24 RHCRFFH_XAYA ok 19.22

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