media_variant

22 rows where media = 271

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
6481 RADIO KOMBI BAYERN 271 DS 1 RHERB11_ZT ok 6081.03
6484 RADIO KOMBI BAYERN 271 HpT 4 RHERB11_ZH ok 6081.03
6485 RADIO KOMBI BAYERN 271 Ø 5 RHERB11_ZD ok 1142.57
6486 RADIO KOMBI BAYERN 271 0500-0600 6 RHERB11_FAGA ok 476.11
6487 RADIO KOMBI BAYERN 271 0600-0700 7 RHERB11_GAHA ok 995.34
6488 RADIO KOMBI BAYERN 271 0700-0800 8 RHERB11_HAIA ok 1418.35
6489 RADIO KOMBI BAYERN 271 0800-0900 9 RHERB11_IAJA ok 1243.03
6490 RADIO KOMBI BAYERN 271 0900-1000 10 RHERB11_JAKA ok 1157.42
6491 RADIO KOMBI BAYERN 271 1000-1100 11 RHERB11_KALA ok 1054.11
6492 RADIO KOMBI BAYERN 271 1100-1200 12 RHERB11_LAMA ok 1005.11
6493 RADIO KOMBI BAYERN 271 1200-1300 13 RHERB11_MANA ok 1053.33
6494 RADIO KOMBI BAYERN 271 1300-1400 14 RHERB11_NAOA ok 993.19
6495 RADIO KOMBI BAYERN 271 1400-1500 15 RHERB11_OAPA ok 936.89
6496 RADIO KOMBI BAYERN 271 1500-1600 16 RHERB11_PAQA ok 948.79
6497 RADIO KOMBI BAYERN 271 1600-1700 17 RHERB11_QARA ok 1036.88
6498 RADIO KOMBI BAYERN 271 1700-1800 18 RHERB11_RASA ok 1054.75
6499 RADIO KOMBI BAYERN 271 1800-1900 19 RHERB11_SATA ok 836.82
6500 RADIO KOMBI BAYERN 271 1900-2000 20 RHERB11_TAUA ok 543.29
6501 RADIO KOMBI BAYERN 271 2000-2100 21 RHERB11_UAVA ok 349.98
6502 RADIO KOMBI BAYERN 271 2100-2200 22 RHERB11_VAWA ok 232.04
6503 RADIO KOMBI BAYERN 271 2200-2300 23 RHERB11_WAXA ok 173.34
6504 RADIO KOMBI BAYERN 271 2300-2400 24 RHERB11_XAYA ok 127.44

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