musiccaps
2 rows where aspect_list contains "groovy bass", aspect_list contains "shimmering cymbals" and is_balanced_subset = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|
S_Z7o4OmU30 | The Reggae/Dub song features a subtle funky electric guitar melody with echoing guitar pedal effects on, punchy snare, soft kick hits, groovy bass and shimmering cymbals, while the wide harmonizing male vocals are singing over it. It sounds easygoing and chill, like something you would listen to on a beautiful Sunday afternoon. | ["reggae/dub", "punchy snare", "subtle funky electric guitar melody", "wide harmonizing male vocals", "echoing guitar pedal effects", "shimmering cymbals", "soft kick", "easygoing", "chill", "groovy bass"] | ["Music of Africa", "Music", "Song", "/t/dd00032"] | 4 | 30 | 40 | 1 | 1 | ["/m/0164x2", "/m/04rlf", "/m/074ft", "/t/dd00032"] | |
ZsmfIMEzrQs | The low quality recording features harmonizing mixed vocals singing over groovy bass, shimmering cymbals, soft snare hits, funky guitar melody and bright brass melody. The recording is very noisy, in mono, with some crackles in it and it sounds funky and addictive - thanks to those vocals. Sounds like something you would hear in clubs during the 60s and 70s. | ["funk/soul", "low quality", "harmonizing mixed vocals", "groovy bass", "shimmering cymbals", "soft snare hits", "bright brass melody", "funky guitar melody", "funky", "noisy", "crackles", "addictive", "mono"] | ["Singing", "Swing music", "Music", "Psychedelic rock", "Rock and roll"] | 4 | 30 | 40 | 1 | 1 | ["/m/015lz1", "/m/015y_n", "/m/04rlf", "/m/05w3f", "/m/07sbbz2"] |
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 );