media_variant

22 rows where media = 362

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8665 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 DS 1 RHGOSTW_ZT ok 888.9
8668 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 HpT 4 RHGOSTW_ZH ok 888.9
8669 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 Ø 5 RHGOSTW_ZD ok 180.6
8670 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 0500-0600 6 RHGOSTW_FAGA ok 114.61
8671 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 0600-0700 7 RHGOSTW_GAHA ok 194.57
8672 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 0700-0800 8 RHGOSTW_HAIA ok 255.14
8673 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 0800-0900 9 RHGOSTW_IAJA ok 216.84
8674 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 0900-1000 10 RHGOSTW_JAKA ok 189.39
8675 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 1000-1100 11 RHGOSTW_KALA ok 178.84
8676 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 1100-1200 12 RHGOSTW_LAMA ok 161.53
8677 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 1200-1300 13 RHGOSTW_MANA ok 162.69
8678 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 1300-1400 14 RHGOSTW_NAOA ok 145.64
8679 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 1400-1500 15 RHGOSTW_OAPA ok 155.71
8680 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 1500-1600 16 RHGOSTW_PAQA ok 173.36
8681 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 1600-1700 17 RHGOSTW_QARA ok 165.09
8682 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 1700-1800 18 RHGOSTW_RASA ok 146.05
8683 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 1800-1900 19 RHGOSTW_SATA ok 99.05
8684 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 1900-2000 20 RHGOSTW_TAUA ok 49.96
8685 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 2000-2100 21 RHGOSTW_UAVA ok 29.78
8686 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 2100-2200 22 RHGOSTW_VAWA ok 19.85
8687 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 2200-2300 23 RHGOSTW_WAXA ok 24.24
8688 Ostseewelle HIT-RADIO Mecklenburg-Vorpommern 362 2300-2400 24 RHGOSTW_XAYA ok 15.96

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