media_variant

22 rows where media = 95

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
2257 Radio Hamburg 95 DS 1 RHARAHH_ZT ok 1071.49
2260 Radio Hamburg 95 HpT 4 RHARAHH_ZH ok 1071.49
2261 Radio Hamburg 95 Ø 5 RHARAHH_ZD ok 174.33
2262 Radio Hamburg 95 0500-0600 6 RHARAHH_FAGA ok 75.42
2263 Radio Hamburg 95 0600-0700 7 RHARAHH_GAHA ok 209.49
2264 Radio Hamburg 95 0700-0800 8 RHARAHH_HAIA ok 248.59
2265 Radio Hamburg 95 0800-0900 9 RHARAHH_IAJA ok 223.08
2266 Radio Hamburg 95 0900-1000 10 RHARAHH_JAKA ok 160.58
2267 Radio Hamburg 95 1000-1100 11 RHARAHH_KALA ok 149.64
2268 Radio Hamburg 95 1100-1200 12 RHARAHH_LAMA ok 151.68
2269 Radio Hamburg 95 1200-1300 13 RHARAHH_MANA ok 182.11
2270 Radio Hamburg 95 1300-1400 14 RHARAHH_NAOA ok 153.6
2271 Radio Hamburg 95 1400-1500 15 RHARAHH_OAPA ok 139.28
2272 Radio Hamburg 95 1500-1600 16 RHARAHH_PAQA ok 129.36
2273 Radio Hamburg 95 1600-1700 17 RHARAHH_QARA ok 161.31
2274 Radio Hamburg 95 1700-1800 18 RHARAHH_RASA ok 149.45
2275 Radio Hamburg 95 1800-1900 19 RHARAHH_SATA ok 141.64
2276 Radio Hamburg 95 1900-2000 20 RHARAHH_TAUA ok 103.47
2277 Radio Hamburg 95 2000-2100 21 RHARAHH_UAVA ok 54.37
2278 Radio Hamburg 95 2100-2200 22 RHARAHH_VAWA ok 20.53
2279 Radio Hamburg 95 2200-2300 23 RHARAHH_WAXA ok 26.96
2280 Radio Hamburg 95 2300-2400 24 RHARAHH_XAYA ok 11.16

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