musiccaps
2 rows where aspect_list contains "percussive wooden elements" and aspect_list contains "soulful"
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 |
---|---|---|---|---|---|---|---|---|---|---|
hVPQu1UJ2N8 | The low quality recording features a traditional song that consists of wooden percussive elements, addictive accordion melody, smooth bass and some metallic buzzing sounds. Even though it is mono and noisy, it still sounds soulful and addictive. | ["low quality", "mono", "noisy", "percussive wooden elements", "addictive accordion melody", "smooth bass", "metallic buzzing", "soulful", "addictive", "traditional"] | ["Music", "Music of Latin America", "Salsa music"] | 4 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/0g293", "/m/0ln16"] | |
pQWpa484HQM | The low quality recording features a live performance of bagpipe melodies played over some percussive wooden elements. The recording is muffled, noisy, in mono and it sounds soulful and passionate. | ["low quality", "live performance", "mono", "noisy", "muffled", "bagpipe melody", "percussive wooden elements", "soulful", "passionate"] | ["Bagpipes", "Wind instrument, woodwind instrument"] | 4 | 40 | 50 | 0 | 0 | ["/m/0192l", "/m/085jw"] |
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 );