musiccaps
2 rows where aspect_list contains "arpeggiated guitar melody" and aspect_list contains "happy"
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 |
---|---|---|---|---|---|---|---|---|---|---|
YcWJUHWt-64 | The low quality recording features a Twoubadou song that consists of flat male vocal singing over acoustic guitar melody, arpeggiated guitar melody, syncopated rimshots, shimmering shakers, smooth bass and wooden percussive elements. Even though it is noisy, it sounds fun and happy - like something you would want to dance to. | ["twoubadou", "low quality", "wooden percussive elements", "acoustic guitar melody", "noisy", "shimmering shakers", "syncopated rimshots", "flat male vocal", "groovy keys", "arpeggiated guitar melody", "smooth bass", "happy", "fun"] | ["Music", "Rattle (instrument)"] | 4 | 0 | 10 | 1 | 1 | ["/m/04rlf", "/m/05r5wn"] | |
ecS6SJGkhIw | The low quality recording features a flat girl vocal talking over a folk song that consists of an arpeggiated guitar melody played over groovy bass, shimmering shakers and "4 on the floor" kick pattern. There are some birds chirping sounds in the background. It sounds energetic, fun and happy. | ["low quality", "flat girl vocal", "folk", "arpeggiated guitar melody", "shimmering shaker", "groovy bass", "\"4 on the floor\" kick pattern", "energetic", "fun", "happy", "birds chirping"] | ["Banjo", "Country"] | 4 | 40 | 50 | 0 | 0 | ["/m/018j2", "/m/01lyv"] |
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 );