musiccaps
1 row where aspect_list contains "funky" and aspect_list contains "wooden percussive elements"
This data as json, CSV (advanced)
aspect_list (array) 9 ✖
- champeta 1
- electric guitar solo melody 1
- funky · 1 ✖
- funky electric rhythm guitar chords 1
- low quality 1
- shimmering hi hats 1
- shimmering shakers 1
- smooth bass guitar 1
- wooden percussive elements · 1 ✖
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
2xGRCsW6-Bk | The low quality recording features a Champeta song that consists of wooden percussive elements, electric guitar solo melody, funky electric rhythm guitar chords, shimmering shakers and hi hats and smooth bass guitar. It sounds funky and like something you would dance to in a bar. | ["low quality", "champeta", "wooden percussive elements", "electric guitar solo melody", "funky electric rhythm guitar chords", "shimmering shakers", "shimmering hi hats", "smooth bass guitar", "funky"] | ["Music", "Rattle (instrument)"] | 4 | 100 | 110 | 1 | 1 | ["/m/04rlf", "/m/05r5wn"] |
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 );