media_variant

22 rows where media = 41

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
961 RMS SUPER KOMBI 41 DS 1 RHZRS24_ZT ok 29521.78
964 RMS SUPER KOMBI 41 HpT 4 RHZRS24_ZH ok 29521.78
965 RMS SUPER KOMBI 41 Ø 5 RHZRS24_ZD ok 6526.04
966 RMS SUPER KOMBI 41 0500-0600 6 RHZRS24_FAGA ok 2820.07
967 RMS SUPER KOMBI 41 0600-0700 7 RHZRS24_GAHA ok 5839.5
968 RMS SUPER KOMBI 41 0700-0800 8 RHZRS24_HAIA ok 8503.11
969 RMS SUPER KOMBI 41 0800-0900 9 RHZRS24_IAJA ok 7735.14
970 RMS SUPER KOMBI 41 0900-1000 10 RHZRS24_JAKA ok 6481.53
971 RMS SUPER KOMBI 41 1000-1100 11 RHZRS24_KALA ok 5826.83
972 RMS SUPER KOMBI 41 1100-1200 12 RHZRS24_LAMA ok 5480.84
973 RMS SUPER KOMBI 41 1200-1300 13 RHZRS24_MANA ok 5559.57
974 RMS SUPER KOMBI 41 1300-1400 14 RHZRS24_NAOA ok 5252.6
975 RMS SUPER KOMBI 41 1400-1500 15 RHZRS24_OAPA ok 5264.28
976 RMS SUPER KOMBI 41 1500-1600 16 RHZRS24_PAQA ok 5361.16
977 RMS SUPER KOMBI 41 1600-1700 17 RHZRS24_QARA ok 5906.2
978 RMS SUPER KOMBI 41 1700-1800 18 RHZRS24_RASA ok 5588.75
979 RMS SUPER KOMBI 41 1800-1900 19 RHZRS24_SATA ok 4584.11
980 RMS SUPER KOMBI 41 1900-2000 20 RHZRS24_TAUA ok 3031.27
981 RMS SUPER KOMBI 41 2000-2100 21 RHZRS24_UAVA ok 1741.23
982 RMS SUPER KOMBI 41 2100-2200 22 RHZRS24_VAWA ok 1143.78
983 RMS SUPER KOMBI 41 2200-2300 23 RHZRS24_WAXA ok 973.63
984 RMS SUPER KOMBI 41 2300-2400 24 RHZRS24_XAYA ok 630.02

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