musiccaps
3 rows where aspect_list contains "drums solo", aspect_list contains "punchy kick" and aspect_list contains "punchy snare"
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 |
---|---|---|---|---|---|---|---|---|---|---|
3Yc7_n6mDsI | The low quality recording features a drum solo that consists of punchy snare hits and occasional snare roll, punchy kick and shimmering hi-hats. It sounds energetic and the recording is in mono and noisy. | ["low quality", "noisy", "mono", "uptempo", "drums solo", "punchy snare", "shimmering hi hats", "punchy kick", "snare roll", "energetic"] | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 4 | 40 | 50 | 0 | 0 | ["/m/026t6", "/m/02hnl", "/m/02k_mr", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] | |
MrMXYO2fzJ4 | The low quality recording features a latin jazz song played in the background over which a drums solo is played. The solo consists of shimmering hi hats, punchy snare and kick hits and low tom rolls, while the latin jazz song consists of groovy piano chords and wooden percussion. It sounds energetic and exciting. | ["low quality", "latin jazz", "groovy piano chords", "wooden percussion", "drums solo", "punchy kick", "punchy snare", "low tom roll", "shimmering hi hats", "energetic", "exciting"] | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Bass drum", "Percussion"] | 4 | 140 | 150 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/03qtq", "/m/03t3fj", "/m/0bm02", "/m/0l14md"] | |
P39x5dOsJ40 | The low quality recording features a drummer playing his solo over a weird repetitive electric guitar solo melody. The drums consist of punchy kick and snare hits and shimmering cymbals. Overall it sounds energetic and exciting. | ["low quality", "weird repetitive electric guitar melody", "punchy kick", "punchy snare", "shimmering cymbals", "energetic", "drums solo", "exciting"] | ["Drum", "Drum kit", "Jazz", "Music", "Musical instrument"] | 4 | 80 | 90 | 0 | 0 | ["/m/026t6", "/m/02hnl", "/m/03_d0", "/m/04rlf", "/m/04szw"] |
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 );