media_variant

22 rows where media = 380

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
9097 RADIO PSR 380 DS 1 RHHRPSR_ZT ok 1206.11
9100 RADIO PSR 380 HpT 4 RHHRPSR_ZH ok 1206.11
9101 RADIO PSR 380 Ø 5 RHHRPSR_ZD ok 197.62
9102 RADIO PSR 380 0500-0600 6 RHHRPSR_FAGA ok 161.88
9103 RADIO PSR 380 0600-0700 7 RHHRPSR_GAHA ok 250.85
9104 RADIO PSR 380 0700-0800 8 RHHRPSR_HAIA ok 291.03
9105 RADIO PSR 380 0800-0900 9 RHHRPSR_IAJA ok 227.44
9106 RADIO PSR 380 0900-1000 10 RHHRPSR_JAKA ok 217.9
9107 RADIO PSR 380 1000-1100 11 RHHRPSR_KALA ok 173.61
9108 RADIO PSR 380 1100-1200 12 RHHRPSR_LAMA ok 173.26
9109 RADIO PSR 380 1200-1300 13 RHHRPSR_MANA ok 163.71
9110 RADIO PSR 380 1300-1400 14 RHHRPSR_NAOA ok 168.3
9111 RADIO PSR 380 1400-1500 15 RHHRPSR_OAPA ok 149.96
9112 RADIO PSR 380 1500-1600 16 RHHRPSR_PAQA ok 171.07
9113 RADIO PSR 380 1600-1700 17 RHHRPSR_QARA ok 205.01
9114 RADIO PSR 380 1700-1800 18 RHHRPSR_RASA ok 140.7
9115 RADIO PSR 380 1800-1900 19 RHHRPSR_SATA ok 134.69
9116 RADIO PSR 380 1900-2000 20 RHHRPSR_TAUA ok 73.09
9117 RADIO PSR 380 2000-2100 21 RHHRPSR_UAVA ok 25.01
9118 RADIO PSR 380 2100-2200 22 RHHRPSR_VAWA ok 24.29
9119 RADIO PSR 380 2200-2300 23 RHHRPSR_WAXA ok 24.09
9120 RADIO PSR 380 2300-2400 24 RHHRPSR_XAYA ok 13.62

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