media_variant

17 rows where media = 167

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
3985 WFS Saarland Kombi 167 DS 1 RHCWFS1_ZT ok 1450.21
3988 WFS Saarland Kombi 167 HpT 4 RHCWFS1_ZH ok 1450.21
3989 WFS Saarland Kombi 167 Ø 5 RHCWFS1_ZD ok 358.97
3991 WFS Saarland Kombi 167 0600-0700 7 RHCWFS1_GAHA ok 360.08
3992 WFS Saarland Kombi 167 0700-0800 8 RHCWFS1_HAIA ok 503.87
3993 WFS Saarland Kombi 167 0800-0900 9 RHCWFS1_IAJA ok 461.6
3994 WFS Saarland Kombi 167 0900-1000 10 RHCWFS1_JAKA ok 380.36
3995 WFS Saarland Kombi 167 1000-1100 11 RHCWFS1_KALA ok 317.38
3996 WFS Saarland Kombi 167 1100-1200 12 RHCWFS1_LAMA ok 273.93
3997 WFS Saarland Kombi 167 1200-1300 13 RHCWFS1_MANA ok 314.22
3998 WFS Saarland Kombi 167 1300-1400 14 RHCWFS1_NAOA ok 278.48
3999 WFS Saarland Kombi 167 1400-1500 15 RHCWFS1_OAPA ok 277.62
4000 WFS Saarland Kombi 167 1500-1600 16 RHCWFS1_PAQA ok 275.26
4001 WFS Saarland Kombi 167 1600-1700 17 RHCWFS1_QARA ok 314.72
4002 WFS Saarland Kombi 167 1700-1800 18 RHCWFS1_RASA ok 305.96
4003 WFS Saarland Kombi 167 1800-1900 19 RHCWFS1_SATA ok 272.65
4004 WFS Saarland Kombi 167 1900-2000 20 RHCWFS1_TAUA ok 164.8

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