media_variant

22 rows where media = 320

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
7657 105'5 Spreeradio 320 DS 1 RHFSPRE_ZT ok 562.72
7660 105'5 Spreeradio 320 HpT 4 RHFSPRE_ZH ok 562.72
7661 105'5 Spreeradio 320 Ø 5 RHFSPRE_ZD ok 89.64
7662 105'5 Spreeradio 320 0500-0600 6 RHFSPRE_FAGA ok 32.75
7663 105'5 Spreeradio 320 0600-0700 7 RHFSPRE_GAHA ok 99.3
7664 105'5 Spreeradio 320 0700-0800 8 RHFSPRE_HAIA ok 118.58
7665 105'5 Spreeradio 320 0800-0900 9 RHFSPRE_IAJA ok 109.54
7666 105'5 Spreeradio 320 0900-1000 10 RHFSPRE_JAKA ok 103.6
7667 105'5 Spreeradio 320 1000-1100 11 RHFSPRE_KALA ok 72.61
7668 105'5 Spreeradio 320 1100-1200 12 RHFSPRE_LAMA ok 71.34
7669 105'5 Spreeradio 320 1200-1300 13 RHFSPRE_MANA ok 63.43
7670 105'5 Spreeradio 320 1300-1400 14 RHFSPRE_NAOA ok 66.42
7671 105'5 Spreeradio 320 1400-1500 15 RHFSPRE_OAPA ok 101.41
7672 105'5 Spreeradio 320 1500-1600 16 RHFSPRE_PAQA ok 86.41
7673 105'5 Spreeradio 320 1600-1700 17 RHFSPRE_QARA ok 85.85
7674 105'5 Spreeradio 320 1700-1800 18 RHFSPRE_RASA ok 66.42
7675 105'5 Spreeradio 320 1800-1900 19 RHFSPRE_SATA ok 53.14
7676 105'5 Spreeradio 320 1900-2000 20 RHFSPRE_TAUA ok 32.86
7677 105'5 Spreeradio 320 2000-2100 21 RHFSPRE_UAVA ok 24.15
7678 105'5 Spreeradio 320 2100-2200 22 RHFSPRE_VAWA ok 14.44
7679 105'5 Spreeradio 320 2200-2300 23 RHFSPRE_WAXA ok 11.77
7680 105'5 Spreeradio 320 2300-2400 24 RHFSPRE_XAYA ok 11.75

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