media_variant

22 rows where media = 105

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
2497 radio ffn 105 DS 1 RHARFFN_ZT ok 1377.03
2500 radio ffn 105 HpT 4 RHARFFN_ZH ok 1377.03
2501 radio ffn 105 Ø 5 RHARFFN_ZD ok 176.26
2502 radio ffn 105 0500-0600 6 RHARFFN_FAGA ok 82.03
2503 radio ffn 105 0600-0700 7 RHARFFN_GAHA ok 201.63
2504 radio ffn 105 0700-0800 8 RHARFFN_HAIA ok 265.04
2505 radio ffn 105 0800-0900 9 RHARFFN_IAJA ok 228.97
2506 radio ffn 105 0900-1000 10 RHARFFN_JAKA ok 162.36
2507 radio ffn 105 1000-1100 11 RHARFFN_KALA ok 137.94
2508 radio ffn 105 1100-1200 12 RHARFFN_LAMA ok 161.49
2509 radio ffn 105 1200-1300 13 RHARFFN_MANA ok 151.65
2510 radio ffn 105 1300-1400 14 RHARFFN_NAOA ok 161.43
2511 radio ffn 105 1400-1500 15 RHARFFN_OAPA ok 155.79
2512 radio ffn 105 1500-1600 16 RHARFFN_PAQA ok 120.25
2513 radio ffn 105 1600-1700 17 RHARFFN_QARA ok 182.57
2514 radio ffn 105 1700-1800 18 RHARFFN_RASA ok 127.82
2515 radio ffn 105 1800-1900 19 RHARFFN_SATA ok 152.7
2516 radio ffn 105 1900-2000 20 RHARFFN_TAUA ok 121.28
2517 radio ffn 105 2000-2100 21 RHARFFN_UAVA ok 54.47
2518 radio ffn 105 2100-2200 22 RHARFFN_VAWA ok 43.1
2519 radio ffn 105 2200-2300 23 RHARFFN_WAXA ok 24.35
2520 radio ffn 105 2300-2400 24 RHARFFN_XAYA ok 18.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);