home / MAAudio_2023_I_valid_medias

Menu
  • Log in

media_variant

22 rows where media = 208

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
4969 Hitradio antenne 1 208 DS 1 RHDHRA1_ZT ok 1279.69
4972 Hitradio antenne 1 208 HpT 4 RHDHRA1_ZH ok 1279.69
4973 Hitradio antenne 1 208 Ø 5 RHDHRA1_ZD ok 193.07
4974 Hitradio antenne 1 208 0500-0600 6 RHDHRA1_FAGA ok 84.51
4975 Hitradio antenne 1 208 0600-0700 7 RHDHRA1_GAHA ok 218.43
4976 Hitradio antenne 1 208 0700-0800 8 RHDHRA1_HAIA ok 288.04
4977 Hitradio antenne 1 208 0800-0900 9 RHDHRA1_IAJA ok 203
4978 Hitradio antenne 1 208 0900-1000 10 RHDHRA1_JAKA ok 157.03
4979 Hitradio antenne 1 208 1000-1100 11 RHDHRA1_KALA ok 158.34
4980 Hitradio antenne 1 208 1100-1200 12 RHDHRA1_LAMA ok 153.09
4981 Hitradio antenne 1 208 1200-1300 13 RHDHRA1_MANA ok 173.63
4982 Hitradio antenne 1 208 1300-1400 14 RHDHRA1_NAOA ok 180.98
4983 Hitradio antenne 1 208 1400-1500 15 RHDHRA1_OAPA ok 148.3
4984 Hitradio antenne 1 208 1500-1600 16 RHDHRA1_PAQA ok 184.4
4985 Hitradio antenne 1 208 1600-1700 17 RHDHRA1_QARA ok 199.35
4986 Hitradio antenne 1 208 1700-1800 18 RHDHRA1_RASA ok 169.73
4987 Hitradio antenne 1 208 1800-1900 19 RHDHRA1_SATA ok 135.54
4988 Hitradio antenne 1 208 1900-2000 20 RHDHRA1_TAUA ok 100.12
4989 Hitradio antenne 1 208 2000-2100 21 RHDHRA1_UAVA ok 43.8
4990 Hitradio antenne 1 208 2100-2200 22 RHDHRA1_VAWA ok 28.77
4991 Hitradio antenne 1 208 2200-2300 23 RHDHRA1_WAXA ok 42.23
4992 Hitradio antenne 1 208 2300-2400 24 RHDHRA1_XAYA ok 16.45

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 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);
CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);
Powered by Datasette · Queries took 1.2ms