media_variant

22 rows where media = 348

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8329 Schlager Radio 348 DS 1 RHFOLST_ZT ok 518.67
8332 Schlager Radio 348 HpT 4 RHFOLST_ZH ok 518.67
8333 Schlager Radio 348 Ø 5 RHFOLST_ZD ok 88.84
8334 Schlager Radio 348 0500-0600 6 RHFOLST_FAGA ok 27.3
8335 Schlager Radio 348 0600-0700 7 RHFOLST_GAHA ok 57.78
8336 Schlager Radio 348 0700-0800 8 RHFOLST_HAIA ok 82.07
8337 Schlager Radio 348 0800-0900 9 RHFOLST_IAJA ok 114.39
8338 Schlager Radio 348 0900-1000 10 RHFOLST_JAKA ok 123.4
8339 Schlager Radio 348 1000-1100 11 RHFOLST_KALA ok 115.93
8340 Schlager Radio 348 1100-1200 12 RHFOLST_LAMA ok 89.27
8341 Schlager Radio 348 1200-1300 13 RHFOLST_MANA ok 85.48
8342 Schlager Radio 348 1300-1400 14 RHFOLST_NAOA ok 79.44
8343 Schlager Radio 348 1400-1500 15 RHFOLST_OAPA ok 74.09
8344 Schlager Radio 348 1500-1600 16 RHFOLST_PAQA ok 84.25
8345 Schlager Radio 348 1600-1700 17 RHFOLST_QARA ok 90.89
8346 Schlager Radio 348 1700-1800 18 RHFOLST_RASA ok 56.08
8347 Schlager Radio 348 1800-1900 19 RHFOLST_SATA ok 72.38
8348 Schlager Radio 348 1900-2000 20 RHFOLST_TAUA ok 33.7
8349 Schlager Radio 348 2000-2100 21 RHFOLST_UAVA ok 22.49
8350 Schlager Radio 348 2100-2200 22 RHFOLST_VAWA ok 12.63
8351 Schlager Radio 348 2200-2300 23 RHFOLST_WAXA ok 12.08
8352 Schlager Radio 348 2300-2400 24 RHFOLST_XAYA ok 5.69

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