media_variant

22 rows where media = 363

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8689 radio SAW 363 DS 1 RHGRSAW_ZT ok 1066.42
8692 radio SAW 363 HpT 4 RHGRSAW_ZH ok 1066.42
8693 radio SAW 363 Ø 5 RHGRSAW_ZD ok 201.39
8694 radio SAW 363 0500-0600 6 RHGRSAW_FAGA ok 144.24
8695 radio SAW 363 0600-0700 7 RHGRSAW_GAHA ok 232.24
8696 radio SAW 363 0700-0800 8 RHGRSAW_HAIA ok 262.27
8697 radio SAW 363 0800-0900 9 RHGRSAW_IAJA ok 257.48
8698 radio SAW 363 0900-1000 10 RHGRSAW_JAKA ok 212.85
8699 radio SAW 363 1000-1100 11 RHGRSAW_KALA ok 197.26
8700 radio SAW 363 1100-1200 12 RHGRSAW_LAMA ok 188.92
8701 radio SAW 363 1200-1300 13 RHGRSAW_MANA ok 171.2
8702 radio SAW 363 1300-1400 14 RHGRSAW_NAOA ok 154.17
8703 radio SAW 363 1400-1500 15 RHGRSAW_OAPA ok 207.8
8704 radio SAW 363 1500-1600 16 RHGRSAW_PAQA ok 159.92
8705 radio SAW 363 1600-1700 17 RHGRSAW_QARA ok 187.37
8706 radio SAW 363 1700-1800 18 RHGRSAW_RASA ok 144.37
8707 radio SAW 363 1800-1900 19 RHGRSAW_SATA ok 121.69
8708 radio SAW 363 1900-2000 20 RHGRSAW_TAUA ok 96.98
8709 radio SAW 363 2000-2100 21 RHGRSAW_UAVA ok 49.63
8710 radio SAW 363 2100-2200 22 RHGRSAW_VAWA ok 31.88
8711 radio SAW 363 2200-2300 23 RHGRSAW_WAXA ok 20.51
8712 radio SAW 363 2300-2400 24 RHGRSAW_XAYA ok 12.52

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