media_variant

22 rows where media = 296

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
7081 Ballungsraumkombi 296 DS 1 RHZBRKB_ZT ok 1491.78
7084 Ballungsraumkombi 296 HpT 4 RHZBRKB_ZH ok 1491.78
7085 Ballungsraumkombi 296 Ø 5 RHZBRKB_ZD ok 196.76
7086 Ballungsraumkombi 296 0500-0600 6 RHZBRKB_FAGA ok 104.22
7087 Ballungsraumkombi 296 0600-0700 7 RHZBRKB_GAHA ok 239.72
7088 Ballungsraumkombi 296 0700-0800 8 RHZBRKB_HAIA ok 332.02
7089 Ballungsraumkombi 296 0800-0900 9 RHZBRKB_IAJA ok 246.53
7090 Ballungsraumkombi 296 0900-1000 10 RHZBRKB_JAKA ok 173.84
7091 Ballungsraumkombi 296 1000-1100 11 RHZBRKB_KALA ok 150.86
7092 Ballungsraumkombi 296 1100-1200 12 RHZBRKB_LAMA ok 137.39
7093 Ballungsraumkombi 296 1200-1300 13 RHZBRKB_MANA ok 155.98
7094 Ballungsraumkombi 296 1300-1400 14 RHZBRKB_NAOA ok 129.25
7095 Ballungsraumkombi 296 1400-1500 15 RHZBRKB_OAPA ok 162.52
7096 Ballungsraumkombi 296 1500-1600 16 RHZBRKB_PAQA ok 174.67
7097 Ballungsraumkombi 296 1600-1700 17 RHZBRKB_QARA ok 196.43
7098 Ballungsraumkombi 296 1700-1800 18 RHZBRKB_RASA ok 188.41
7099 Ballungsraumkombi 296 1800-1900 19 RHZBRKB_SATA ok 165.02
7100 Ballungsraumkombi 296 1900-2000 20 RHZBRKB_TAUA ok 92.84
7101 Ballungsraumkombi 296 2000-2100 21 RHZBRKB_UAVA ok 42.48
7102 Ballungsraumkombi 296 2100-2200 22 RHZBRKB_VAWA ok 31.31
7103 Ballungsraumkombi 296 2200-2300 23 RHZBRKB_WAXA ok 17.4
7104 Ballungsraumkombi 296 2300-2400 24 RHZBRKB_XAYA ok 13.63

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