musiccaps
2 rows where aspect_list contains "electric guitar solo melody" and aspect_list contains "funky"
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"] | |
aCTm1TcL7z8 | The low quality recording features an electric guitar solo melody played over groovy bass guitar, shimmering tambourine, punchy kick and tinny wooden percussion. It sounds groovy, funky and passionate. | ["low quality", "electric guitar solo melody", "groovy bass guitar", "shimmering tambourine", "punchy kick", "tinny wooden percussions", "groovy", "funky", "passionate"] | ["Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | 4 | 30 | 40 | 0 | 0 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/06w87", "/m/0fx80y"] |
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 );