media_variant

22 rows where media = 195

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
4657 Rockland Radio 195 DS 1 RHCROLA_ZT ok 341.99
4660 Rockland Radio 195 HpT 4 RHCROLA_ZH ok 341.99
4661 Rockland Radio 195 Ø 5 RHCROLA_ZD ok 46.8
4662 Rockland Radio 195 0500-0600 6 RHCROLA_FAGA ok 11.21
4663 Rockland Radio 195 0600-0700 7 RHCROLA_GAHA ok 42.5
4664 Rockland Radio 195 0700-0800 8 RHCROLA_HAIA ok 72.75
4665 Rockland Radio 195 0800-0900 9 RHCROLA_IAJA ok 52.32
4666 Rockland Radio 195 0900-1000 10 RHCROLA_JAKA ok 42.79
4667 Rockland Radio 195 1000-1100 11 RHCROLA_KALA ok 42.51
4668 Rockland Radio 195 1100-1200 12 RHCROLA_LAMA ok 30.04
4669 Rockland Radio 195 1200-1300 13 RHCROLA_MANA ok 41.57
4670 Rockland Radio 195 1300-1400 14 RHCROLA_NAOA ok 39.02
4671 Rockland Radio 195 1400-1500 15 RHCROLA_OAPA ok 41.07
4672 Rockland Radio 195 1500-1600 16 RHCROLA_PAQA ok 46.84
4673 Rockland Radio 195 1600-1700 17 RHCROLA_QARA ok 47.95
4674 Rockland Radio 195 1700-1800 18 RHCROLA_RASA ok 43.61
4675 Rockland Radio 195 1800-1900 19 RHCROLA_SATA ok 34.51
4676 Rockland Radio 195 1900-2000 20 RHCROLA_TAUA ok 20.51
4677 Rockland Radio 195 2000-2100 21 RHCROLA_UAVA ok 15.73
4678 Rockland Radio 195 2100-2200 22 RHCROLA_VAWA ok 3.52
4679 Rockland Radio 195 2200-2300 23 RHCROLA_WAXA ok 5.62
4680 Rockland Radio 195 2300-2400 24 RHCROLA_XAYA ok 2.68

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