media_variant

22 rows where media = 326

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
7801 JazzRadio 326 DS 1 RHFJAZZ_ZT ok 123.32
7804 JazzRadio 326 HpT 4 RHFJAZZ_ZH ok 123.32
7805 JazzRadio 326 Ø 5 RHFJAZZ_ZD ok 11.11
7806 JazzRadio 326 0500-0600 6 RHFJAZZ_FAGA ok 2.94
7807 JazzRadio 326 0600-0700 7 RHFJAZZ_GAHA ok 6.32
7808 JazzRadio 326 0700-0800 8 RHFJAZZ_HAIA ok 20.42
7809 JazzRadio 326 0800-0900 9 RHFJAZZ_IAJA ok 17.88
7810 JazzRadio 326 0900-1000 10 RHFJAZZ_JAKA ok 6
7811 JazzRadio 326 1000-1100 11 RHFJAZZ_KALA ok 7.06
7812 JazzRadio 326 1100-1200 12 RHFJAZZ_LAMA ok 5.07
7813 JazzRadio 326 1200-1300 13 RHFJAZZ_MANA ok 5.45
7814 JazzRadio 326 1300-1400 14 RHFJAZZ_NAOA ok 4.59
7815 JazzRadio 326 1400-1500 15 RHFJAZZ_OAPA ok 4.97
7816 JazzRadio 326 1500-1600 16 RHFJAZZ_PAQA ok 7.44
7817 JazzRadio 326 1600-1700 17 RHFJAZZ_QARA ok 10.98
7818 JazzRadio 326 1700-1800 18 RHFJAZZ_RASA ok 10.13
7819 JazzRadio 326 1800-1900 19 RHFJAZZ_SATA ok 9.76
7820 JazzRadio 326 1900-2000 20 RHFJAZZ_TAUA ok 8.47
7821 JazzRadio 326 2000-2100 21 RHFJAZZ_UAVA ok 3.65
7822 JazzRadio 326 2100-2200 22 RHFJAZZ_VAWA ok 2.51
7823 JazzRadio 326 2200-2300 23 RHFJAZZ_WAXA ok 2.51
7824 JazzRadio 326 2300-2400 24 RHFJAZZ_XAYA ok 5.53

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