home / MAAudio_2022_II

Menu
  • Log in

media_variant

22 rows where media = 375

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8977 radio SAW 375 DS 1 RHGRSAW_ZT ok 1082.05
8980 radio SAW 375 HpT 4 RHGRSAW_ZH ok 1082.05
8981 radio SAW 375 Ø 5 RHGRSAW_ZD ok 213.88
8982 radio SAW 375 0500-0600 6 RHGRSAW_FAGA ok 121.24
8983 radio SAW 375 0600-0700 7 RHGRSAW_GAHA ok 231.28
8984 radio SAW 375 0700-0800 8 RHGRSAW_HAIA ok 297.12
8985 radio SAW 375 0800-0900 9 RHGRSAW_IAJA ok 265.41
8986 radio SAW 375 0900-1000 10 RHGRSAW_JAKA ok 262.7
8987 radio SAW 375 1000-1100 11 RHGRSAW_KALA ok 234.57
8988 radio SAW 375 1100-1200 12 RHGRSAW_LAMA ok 218.96
8989 radio SAW 375 1200-1300 13 RHGRSAW_MANA ok 200.03
8990 radio SAW 375 1300-1400 14 RHGRSAW_NAOA ok 164.1
8991 radio SAW 375 1400-1500 15 RHGRSAW_OAPA ok 193.69
8992 radio SAW 375 1500-1600 16 RHGRSAW_PAQA ok 151.49
8993 radio SAW 375 1600-1700 17 RHGRSAW_QARA ok 177.4
8994 radio SAW 375 1700-1800 18 RHGRSAW_RASA ok 134.07
8995 radio SAW 375 1800-1900 19 RHGRSAW_SATA ok 113.6
8996 radio SAW 375 1900-2000 20 RHGRSAW_TAUA ok 83.14
8997 radio SAW 375 2000-2100 21 RHGRSAW_UAVA ok 54.05
8998 radio SAW 375 2100-2200 22 RHGRSAW_VAWA ok 28.17
8999 radio SAW 375 2200-2300 23 RHGRSAW_WAXA ok 21.74
9000 radio SAW 375 2300-2400 24 RHGRSAW_XAYA ok 10.48

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