media_variant

22 rows where media = 373

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8929 ENERGY Sachsen 373 DS 1 RHHENSA_ZT ok 543.68
8932 ENERGY Sachsen 373 HpT 4 RHHENSA_ZH ok 543.68
8933 ENERGY Sachsen 373 Ø 5 RHHENSA_ZD ok 69.29
8934 ENERGY Sachsen 373 0500-0600 6 RHHENSA_FAGA ok 20.03
8935 ENERGY Sachsen 373 0600-0700 7 RHHENSA_GAHA ok 67.58
8936 ENERGY Sachsen 373 0700-0800 8 RHHENSA_HAIA ok 98.47
8937 ENERGY Sachsen 373 0800-0900 9 RHHENSA_IAJA ok 75.78
8938 ENERGY Sachsen 373 0900-1000 10 RHHENSA_JAKA ok 79.39
8939 ENERGY Sachsen 373 1000-1100 11 RHHENSA_KALA ok 69.24
8940 ENERGY Sachsen 373 1100-1200 12 RHHENSA_LAMA ok 62.06
8941 ENERGY Sachsen 373 1200-1300 13 RHHENSA_MANA ok 57.03
8942 ENERGY Sachsen 373 1300-1400 14 RHHENSA_NAOA ok 50.66
8943 ENERGY Sachsen 373 1400-1500 15 RHHENSA_OAPA ok 53.28
8944 ENERGY Sachsen 373 1500-1600 16 RHHENSA_PAQA ok 67.57
8945 ENERGY Sachsen 373 1600-1700 17 RHHENSA_QARA ok 78.35
8946 ENERGY Sachsen 373 1700-1800 18 RHHENSA_RASA ok 47.42
8947 ENERGY Sachsen 373 1800-1900 19 RHHENSA_SATA ok 51.28
8948 ENERGY Sachsen 373 1900-2000 20 RHHENSA_TAUA ok 32.04
8949 ENERGY Sachsen 373 2000-2100 21 RHHENSA_UAVA ok 9.14
8950 ENERGY Sachsen 373 2100-2200 22 RHHENSA_VAWA ok 11.14
8951 ENERGY Sachsen 373 2200-2300 23 RHHENSA_WAXA ok 3.46
8952 ENERGY Sachsen 373 2300-2400 24 RHHENSA_XAYA ok 8.48

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