media_variant

22 rows where media = 340

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8137 Radio Paradiso 340 DS 1 RHFRAPA_ZT ok 469.41
8140 Radio Paradiso 340 HpT 4 RHFRAPA_ZH ok 469.41
8141 Radio Paradiso 340 Ø 5 RHFRAPA_ZD ok 59.2
8142 Radio Paradiso 340 0500-0600 6 RHFRAPA_FAGA ok 17.12
8143 Radio Paradiso 340 0600-0700 7 RHFRAPA_GAHA ok 57.61
8144 Radio Paradiso 340 0700-0800 8 RHFRAPA_HAIA ok 84.25
8145 Radio Paradiso 340 0800-0900 9 RHFRAPA_IAJA ok 62.19
8146 Radio Paradiso 340 0900-1000 10 RHFRAPA_JAKA ok 72.27
8147 Radio Paradiso 340 1000-1100 11 RHFRAPA_KALA ok 59.28
8148 Radio Paradiso 340 1100-1200 12 RHFRAPA_LAMA ok 57
8149 Radio Paradiso 340 1200-1300 13 RHFRAPA_MANA ok 62.58
8150 Radio Paradiso 340 1300-1400 14 RHFRAPA_NAOA ok 61.91
8151 Radio Paradiso 340 1400-1500 15 RHFRAPA_OAPA ok 50.69
8152 Radio Paradiso 340 1500-1600 16 RHFRAPA_PAQA ok 33.07
8153 Radio Paradiso 340 1600-1700 17 RHFRAPA_QARA ok 37.14
8154 Radio Paradiso 340 1700-1800 18 RHFRAPA_RASA ok 51.94
8155 Radio Paradiso 340 1800-1900 19 RHFRAPA_SATA ok 42.38
8156 Radio Paradiso 340 1900-2000 20 RHFRAPA_TAUA ok 20.07
8157 Radio Paradiso 340 2000-2100 21 RHFRAPA_UAVA ok 15.43
8158 Radio Paradiso 340 2100-2200 22 RHFRAPA_VAWA ok 6.34
8159 Radio Paradiso 340 2200-2300 23 RHFRAPA_WAXA ok 6.61
8160 Radio Paradiso 340 2300-2400 24 RHFRAPA_XAYA ok 3.08

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