home / MAAudio_2022_II

Menu
  • Log in

media_variant

22 rows where media = 360

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8617 80s80s Radio 360 DS 1 RHGANMV_ZT ok 706.46
8620 80s80s Radio 360 HpT 4 RHGANMV_ZH ok 706.46
8621 80s80s Radio 360 Ø 5 RHGANMV_ZD ok 124.21
8622 80s80s Radio 360 0500-0600 6 RHGANMV_FAGA ok 49.11
8623 80s80s Radio 360 0600-0700 7 RHGANMV_GAHA ok 82.09
8624 80s80s Radio 360 0700-0800 8 RHGANMV_HAIA ok 167.78
8625 80s80s Radio 360 0800-0900 9 RHGANMV_IAJA ok 201.13
8626 80s80s Radio 360 0900-1000 10 RHGANMV_JAKA ok 192.57
8627 80s80s Radio 360 1000-1100 11 RHGANMV_KALA ok 99.15
8628 80s80s Radio 360 1100-1200 12 RHGANMV_LAMA ok 90.84
8629 80s80s Radio 360 1200-1300 13 RHGANMV_MANA ok 88.18
8630 80s80s Radio 360 1300-1400 14 RHGANMV_NAOA ok 76.95
8631 80s80s Radio 360 1400-1500 15 RHGANMV_OAPA ok 68.74
8632 80s80s Radio 360 1500-1600 16 RHGANMV_PAQA ok 88.98
8633 80s80s Radio 360 1600-1700 17 RHGANMV_QARA ok 117.34
8634 80s80s Radio 360 1700-1800 18 RHGANMV_RASA ok 196.76
8635 80s80s Radio 360 1800-1900 19 RHGANMV_SATA ok 158.55
8636 80s80s Radio 360 1900-2000 20 RHGANMV_TAUA ok 62.46
8637 80s80s Radio 360 2000-2100 21 RHGANMV_UAVA ok 38.24
8638 80s80s Radio 360 2100-2200 22 RHGANMV_VAWA ok 17.44
8639 80s80s Radio 360 2200-2300 23 RHGANMV_WAXA ok 23.63
8640 80s80s Radio 360 2300-2400 24 RHGANMV_XAYA ok 5.44

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);
Powered by Datasette · Queries took 1.2ms