media_variant

22 rows where media = 337

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8065 Schlager Radio 337 DS 1 RHZSCRD_ZT ok 479.28
8068 Schlager Radio 337 HpT 4 RHZSCRD_ZH ok 479.28
8069 Schlager Radio 337 Ø 5 RHZSCRD_ZD ok 83.96
8070 Schlager Radio 337 0500-0600 6 RHZSCRD_FAGA ok 22.1
8071 Schlager Radio 337 0600-0700 7 RHZSCRD_GAHA ok 63.12
8072 Schlager Radio 337 0700-0800 8 RHZSCRD_HAIA ok 95.07
8073 Schlager Radio 337 0800-0900 9 RHZSCRD_IAJA ok 111.49
8074 Schlager Radio 337 0900-1000 10 RHZSCRD_JAKA ok 98.26
8075 Schlager Radio 337 1000-1100 11 RHZSCRD_KALA ok 99.04
8076 Schlager Radio 337 1100-1200 12 RHZSCRD_LAMA ok 88.37
8077 Schlager Radio 337 1200-1300 13 RHZSCRD_MANA ok 83.95
8078 Schlager Radio 337 1300-1400 14 RHZSCRD_NAOA ok 76.55
8079 Schlager Radio 337 1400-1500 15 RHZSCRD_OAPA ok 66.41
8080 Schlager Radio 337 1500-1600 16 RHZSCRD_PAQA ok 64.44
8081 Schlager Radio 337 1600-1700 17 RHZSCRD_QARA ok 75.32
8082 Schlager Radio 337 1700-1800 18 RHZSCRD_RASA ok 67.41
8083 Schlager Radio 337 1800-1900 19 RHZSCRD_SATA ok 65.33
8084 Schlager Radio 337 1900-2000 20 RHZSCRD_TAUA ok 46.17
8085 Schlager Radio 337 2000-2100 21 RHZSCRD_UAVA ok 22.48
8086 Schlager Radio 337 2100-2200 22 RHZSCRD_VAWA ok 21.22
8087 Schlager Radio 337 2200-2300 23 RHZSCRD_WAXA ok 19.72
8088 Schlager Radio 337 2300-2400 24 RHZSCRD_XAYA ok 6.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);