musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "groovy" and aspect_list contains "shimmering shakers"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
bxZeGrM_0ac | The low quality recording features a jazz song that consists of a saxophone solo melody played over hollow snare, groovy double bass, shimmering hi hats, shimmering shakers and brass melody. It sounds uptempo, groovy and passionate - like something you would hear in a jazz club. | ["low quality", "jazz", "uptempo", "groovy", "passionate", "saxophone solo melody", "hollow snare", "groovy double bass", "shimmering hi hats", "shimmering shakers", "brass melody", "energetic"] | ["Brass instrument", "Saxophone"] | 4 | 400 | 410 | 0 | 0 | ["/m/01kcd", "/m/06ncr"] | |
vpU4XIISXtM | The Electro song features a "4 on the floor" boomy 808 bass, shimmering shakers, muffled syncopated snare, repetitive short male vocal chants, high pitched female vocal and frequency sweep riser. It sounds funny, groovy and energetic. The drums are stuttering at one point, which serves as a transition to the next section. | ["low quality", "electro", "high pitched female vocal", "4 on the floor boomy 808 bass", "shimmering shakers", "stuttering drums", "frequency sweep riser", "repetitive short male vocal chant", "muffled syncopated snare", "funny", "groovy", "energetic"] | ["Music", "Microwave oven"] | 4 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/0fx9l"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [musiccaps] ( [ytid] TEXT PRIMARY KEY, [url] TEXT, [caption] TEXT, [aspect_list] TEXT, [audioset_names] TEXT, [author_id] TEXT, [start_s] TEXT, [end_s] TEXT, [is_balanced_subset] INTEGER, [is_audioset_eval] INTEGER, [audioset_ids] TEXT );