media_variant

22 rows where media = 343

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8209 Radio TEDDY 343 DS 1 RHFRATE_ZT ok 571.41
8212 Radio TEDDY 343 HpT 4 RHFRATE_ZH ok 571.41
8213 Radio TEDDY 343 Ø 5 RHFRATE_ZD ok 57.15
8214 Radio TEDDY 343 0500-0600 6 RHFRATE_FAGA ok 36.41
8215 Radio TEDDY 343 0600-0700 7 RHFRATE_GAHA ok 93.67
8216 Radio TEDDY 343 0700-0800 8 RHFRATE_HAIA ok 133.25
8217 Radio TEDDY 343 0800-0900 9 RHFRATE_IAJA ok 70.55
8218 Radio TEDDY 343 0900-1000 10 RHFRATE_JAKA ok 14.71
8219 Radio TEDDY 343 1000-1100 11 RHFRATE_KALA ok 16.63
8220 Radio TEDDY 343 1100-1200 12 RHFRATE_LAMA ok 11.79
8221 Radio TEDDY 343 1200-1300 13 RHFRATE_MANA ok 46.92
8222 Radio TEDDY 343 1300-1400 14 RHFRATE_NAOA ok 26.18
8223 Radio TEDDY 343 1400-1500 15 RHFRATE_OAPA ok 39.99
8224 Radio TEDDY 343 1500-1600 16 RHFRATE_PAQA ok 57.37
8225 Radio TEDDY 343 1600-1700 17 RHFRATE_QARA ok 65.9
8226 Radio TEDDY 343 1700-1800 18 RHFRATE_RASA ok 81.15
8227 Radio TEDDY 343 1800-1900 19 RHFRATE_SATA ok 81.12
8228 Radio TEDDY 343 1900-2000 20 RHFRATE_TAUA ok 39.66
8229 Radio TEDDY 343 2000-2100 21 RHFRATE_UAVA ok 16.5
8230 Radio TEDDY 343 2100-2200 22 RHFRATE_VAWA ok 11.75
8231 Radio TEDDY 343 2200-2300 23 RHFRATE_WAXA ok 3.94
8232 Radio TEDDY 343 2300-2400 24 RHFRATE_XAYA ok 3.92

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