media_variant

22 rows where media = 282

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
6745 ENERGY München 282 DS 1 RHEENER_ZT ok 231.1
6748 ENERGY München 282 HpT 4 RHEENER_ZH ok 231.1
6749 ENERGY München 282 Ø 5 RHEENER_ZD ok 22.64
6750 ENERGY München 282 0500-0600 6 RHEENER_FAGA ok 1.92
6751 ENERGY München 282 0600-0700 7 RHEENER_GAHA ok 28.31
6752 ENERGY München 282 0700-0800 8 RHEENER_HAIA ok 51.66
6753 ENERGY München 282 0800-0900 9 RHEENER_IAJA ok 18.42
6754 ENERGY München 282 0900-1000 10 RHEENER_JAKA ok 17.68
6755 ENERGY München 282 1000-1100 11 RHEENER_KALA ok 9.57
6756 ENERGY München 282 1100-1200 12 RHEENER_LAMA ok 15.95
6757 ENERGY München 282 1200-1300 13 RHEENER_MANA ok 16.29
6758 ENERGY München 282 1300-1400 14 RHEENER_NAOA ok 14.69
6759 ENERGY München 282 1400-1500 15 RHEENER_OAPA ok 8.95
6760 ENERGY München 282 1500-1600 16 RHEENER_PAQA ok 24.26
6761 ENERGY München 282 1600-1700 17 RHEENER_QARA ok 25.49
6762 ENERGY München 282 1700-1800 18 RHEENER_RASA ok 25.37
6763 ENERGY München 282 1800-1900 19 RHEENER_SATA ok 27.19
6764 ENERGY München 282 1900-2000 20 RHEENER_TAUA ok 15.26
6765 ENERGY München 282 2000-2100 21 RHEENER_UAVA ok 5.7
6766 ENERGY München 282 2100-2200 22 RHEENER_VAWA ok 3.37
6767 ENERGY München 282 2200-2300 23 RHEENER_WAXA ok 9.4
6768 ENERGY München 282 2300-2400 24 RHEENER_XAYA ok 5.7

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