home / MAAudio_2022_II

Menu
  • Log in

media_variant

22 rows where media = 278

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
6649 HOT FUNKPAKET 278 DS 1 RHEHOT5_ZT ok 2910.59
6652 HOT FUNKPAKET 278 HpT 4 RHEHOT5_ZH ok 2910.59
6653 HOT FUNKPAKET 278 Ø 5 RHEHOT5_ZD ok 460.11
6654 HOT FUNKPAKET 278 0500-0600 6 RHEHOT5_FAGA ok 170.75
6655 HOT FUNKPAKET 278 0600-0700 7 RHEHOT5_GAHA ok 387.53
6656 HOT FUNKPAKET 278 0700-0800 8 RHEHOT5_HAIA ok 547.41
6657 HOT FUNKPAKET 278 0800-0900 9 RHEHOT5_IAJA ok 489.36
6658 HOT FUNKPAKET 278 0900-1000 10 RHEHOT5_JAKA ok 458.41
6659 HOT FUNKPAKET 278 1000-1100 11 RHEHOT5_KALA ok 441.66
6660 HOT FUNKPAKET 278 1100-1200 12 RHEHOT5_LAMA ok 415.23
6661 HOT FUNKPAKET 278 1200-1300 13 RHEHOT5_MANA ok 431.5
6662 HOT FUNKPAKET 278 1300-1400 14 RHEHOT5_NAOA ok 426.48
6663 HOT FUNKPAKET 278 1400-1500 15 RHEHOT5_OAPA ok 396.88
6664 HOT FUNKPAKET 278 1500-1600 16 RHEHOT5_PAQA ok 414.52
6665 HOT FUNKPAKET 278 1600-1700 17 RHEHOT5_QARA ok 410.55
6666 HOT FUNKPAKET 278 1700-1800 18 RHEHOT5_RASA ok 453.91
6667 HOT FUNKPAKET 278 1800-1900 19 RHEHOT5_SATA ok 382.66
6668 HOT FUNKPAKET 278 1900-2000 20 RHEHOT5_TAUA ok 247.44
6669 HOT FUNKPAKET 278 2000-2100 21 RHEHOT5_UAVA ok 166.78
6670 HOT FUNKPAKET 278 2100-2200 22 RHEHOT5_VAWA ok 118.51
6671 HOT FUNKPAKET 278 2200-2300 23 RHEHOT5_WAXA ok 95.44
6672 HOT FUNKPAKET 278 2300-2400 24 RHEHOT5_XAYA ok 66.84

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