musiccaps
2 rows where aspect_list contains "funky electric guitar melody" and audioset_ids contains "/m/06j6l"
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 |
---|---|---|---|---|---|---|---|---|---|---|
8OsmFmhNjoA | The low quality recording features a latin urban song that consists of a passionate male vocal, alongside wide harmonizing vocals, singing over punchy kick and snare hits, shimmering cymbals, funky electric guitar melody, synth pad chords, groovy bass and synth keys melody. It sounds energetic and addictive. | ["low quality", "latin urban", "passionate male vocal", "punchy kick", "punchy snare", "shimmering cymbals", "funky electric guitar melody", "synth pad chords", "groovy bass", "wide harmonizing vocals", "synth keys melody", "energetic", "addictive"] | ["Folk music", "Music", "Rhythm and blues"] | 4 | 30 | 40 | 0 | 0 | ["/m/02w4v", "/m/04rlf", "/m/06j6l"] | |
JlzlNpttvVM | The Disco song features a passionate male vocalist singing over funky electric guitar melody, groovy bass, punchy kick and snare hits, shimmering hi hats and groovy synth keys melody. It sounds groovy, funky and passionate. | ["disco", "passionate male vocal", "funky electric guitar melody", "groovy bass", "punchy kick", "punchy snare", "shimmering hi hats", "groovy synth keys melody", "passionate", "groovy", "funky"] | ["Music", "Rhythm and blues"] | 4 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/m/06j6l"] |
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 );