media_variant

22 rows where media = 38

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
889 JAM FM 38 DS 1 RHZJAMF_ZT ok 683.06
892 JAM FM 38 HpT 4 RHZJAMF_ZH ok 683.06
893 JAM FM 38 Ø 5 RHZJAMF_ZD ok 77.47
894 JAM FM 38 0500-0600 6 RHZJAMF_FAGA ok 19.13
895 JAM FM 38 0600-0700 7 RHZJAMF_GAHA ok 65.92
896 JAM FM 38 0700-0800 8 RHZJAMF_HAIA ok 134.21
897 JAM FM 38 0800-0900 9 RHZJAMF_IAJA ok 144.21
898 JAM FM 38 0900-1000 10 RHZJAMF_JAKA ok 58.22
899 JAM FM 38 1000-1100 11 RHZJAMF_KALA ok 58.91
900 JAM FM 38 1100-1200 12 RHZJAMF_LAMA ok 49.87
901 JAM FM 38 1200-1300 13 RHZJAMF_MANA ok 46.16
902 JAM FM 38 1300-1400 14 RHZJAMF_NAOA ok 56
903 JAM FM 38 1400-1500 15 RHZJAMF_OAPA ok 64.06
904 JAM FM 38 1500-1600 16 RHZJAMF_PAQA ok 58.59
905 JAM FM 38 1600-1700 17 RHZJAMF_QARA ok 68.22
906 JAM FM 38 1700-1800 18 RHZJAMF_RASA ok 63.1
907 JAM FM 38 1800-1900 19 RHZJAMF_SATA ok 59.17
908 JAM FM 38 1900-2000 20 RHZJAMF_TAUA ok 32.41
909 JAM FM 38 2000-2100 21 RHZJAMF_UAVA ok 25.78
910 JAM FM 38 2100-2200 22 RHZJAMF_VAWA ok 14.99
911 JAM FM 38 2200-2300 23 RHZJAMF_WAXA ok 9.17
912 JAM FM 38 2300-2400 24 RHZJAMF_XAYA ok 9.84

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