home / MAAudio_2022_II

Menu
  • Log in

media_variant

22 rows where media = 171

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
4081 RADIO SALÜ 171 DS 1 RHCRASA_ZT ok 641.48
4084 RADIO SALÜ 171 HpT 4 RHCRASA_ZH ok 641.48
4085 RADIO SALÜ 171 Ø 5 RHCRASA_ZD ok 105.95
4086 RADIO SALÜ 171 0500-0600 6 RHCRASA_FAGA ok 39.8
4087 RADIO SALÜ 171 0600-0700 7 RHCRASA_GAHA ok 151.03
4088 RADIO SALÜ 171 0700-0800 8 RHCRASA_HAIA ok 213.59
4089 RADIO SALÜ 171 0800-0900 9 RHCRASA_IAJA ok 128.2
4090 RADIO SALÜ 171 0900-1000 10 RHCRASA_JAKA ok 135.14
4091 RADIO SALÜ 171 1000-1100 11 RHCRASA_KALA ok 109.36
4092 RADIO SALÜ 171 1100-1200 12 RHCRASA_LAMA ok 70.1
4093 RADIO SALÜ 171 1200-1300 13 RHCRASA_MANA ok 75.55
4094 RADIO SALÜ 171 1300-1400 14 RHCRASA_NAOA ok 71.54
4095 RADIO SALÜ 171 1400-1500 15 RHCRASA_OAPA ok 55.91
4096 RADIO SALÜ 171 1500-1600 16 RHCRASA_PAQA ok 79.33
4097 RADIO SALÜ 171 1600-1700 17 RHCRASA_QARA ok 86.1
4098 RADIO SALÜ 171 1700-1800 18 RHCRASA_RASA ok 81.93
4099 RADIO SALÜ 171 1800-1900 19 RHCRASA_SATA ok 59.06
4100 RADIO SALÜ 171 1900-2000 20 RHCRASA_TAUA ok 53.06
4101 RADIO SALÜ 171 2000-2100 21 RHCRASA_UAVA ok 29.7
4102 RADIO SALÜ 171 2100-2200 22 RHCRASA_VAWA ok 17.88
4103 RADIO SALÜ 171 2200-2300 23 RHCRASA_WAXA ok 25.88
4104 RADIO SALÜ 171 2300-2400 24 RHCRASA_XAYA ok 13.15

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