media_variant

22 rows where media = 336

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8041 JazzRadio 336 DS 1 RHFJAZZ_ZT ok 134.21
8044 JazzRadio 336 HpT 4 RHFJAZZ_ZH ok 134.21
8045 JazzRadio 336 Ø 5 RHFJAZZ_ZD ok 13.49
8046 JazzRadio 336 0500-0600 6 RHFJAZZ_FAGA ok 3.9
8047 JazzRadio 336 0600-0700 7 RHFJAZZ_GAHA ok 6.19
8048 JazzRadio 336 0700-0800 8 RHFJAZZ_HAIA ok 18.82
8049 JazzRadio 336 0800-0900 9 RHFJAZZ_IAJA ok 22.74
8050 JazzRadio 336 0900-1000 10 RHFJAZZ_JAKA ok 10.63
8051 JazzRadio 336 1000-1100 11 RHFJAZZ_KALA ok 9.14
8052 JazzRadio 336 1100-1200 12 RHFJAZZ_LAMA ok 7.96
8053 JazzRadio 336 1200-1300 13 RHFJAZZ_MANA ok 9.62
8054 JazzRadio 336 1300-1400 14 RHFJAZZ_NAOA ok 6.58
8055 JazzRadio 336 1400-1500 15 RHFJAZZ_OAPA ok 6.81
8056 JazzRadio 336 1500-1600 16 RHFJAZZ_PAQA ok 6.52
8057 JazzRadio 336 1600-1700 17 RHFJAZZ_QARA ok 17.32
8058 JazzRadio 336 1700-1800 18 RHFJAZZ_RASA ok 13.89
8059 JazzRadio 336 1800-1900 19 RHFJAZZ_SATA ok 7.68
8060 JazzRadio 336 1900-2000 20 RHFJAZZ_TAUA ok 10.66
8061 JazzRadio 336 2000-2100 21 RHFJAZZ_UAVA ok 6.22
8062 JazzRadio 336 2100-2200 22 RHFJAZZ_VAWA ok 3.44
8063 JazzRadio 336 2200-2300 23 RHFJAZZ_WAXA ok 2.68
8064 JazzRadio 336 2300-2400 24 RHFJAZZ_XAYA ok 2.68

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