musiccaps
1 row where aspect_list contains "maracas" and aspect_list contains "ukulele"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- accordeon 1
- joyful 1
- latin folk 1
- live recording 1
- lively 1
- male vocal 1
- maracas · 1 ✖
- off-key singing 1
- ukulele · 1 ✖
- venezuelan 1
- vibrant 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
ZahBai58_Ec | This is a latin folk piece performed at a home setting. There is a male vocalist singing off-key in a shout-like manner. An accordion and a ukulele are providing the melodic background for the piece. A pair of maracas is being played for the rhythmic background. The piece has a joyful atmosphere. The instrumentals can be used for sampling to put them in a beat. | ["latin folk", "live recording", "male vocal", "off-key singing", "accordeon", "ukulele", "maracas", "lively", "joyful", "vibrant", "venezuelan"] | ["Music", "Musical instrument", "Rattle (instrument)", "Accordion"] | 9 | 330 | 340 | 0 | 1 | ["/m/04rlf", "/m/04szw", "/m/05r5wn", "/m/0mkg"] |
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 );