musiccaps
1 row where aspect_list contains "champeta", aspect_list contains "funky electric rhythm guitar chords" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 );