musiccaps
1 row where aspect_list contains "aggressive tom rolls" and aspect_list contains "rock"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- aggressive tom rolls · 1 ✖
- energetic 1
- groovy bass guitar 1
- low quality 1
- punchy kick 1
- punchy snare 1
- reverberant 1
- rock · 1 ✖
- shimmering shakers 1
- soft ride cymbals 1
- wide electric guitar melody 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
Wu3LKQG1fwU | The low quality recording features a rock song that consists of wide electric guitar melodies, groovy bass guitar, shimmering shakers, punchy snare and kick hits, followed by aggressive tom rolls. It sounds energetic and the drums are reverberant, as they were probably recorded in a medium size drum room. | ["low quality", "rock", "aggressive tom rolls", "wide electric guitar melody", "punchy kick", "groovy bass guitar", "shimmering shakers", "soft ride cymbals", "punchy snare", "energetic", "reverberant"] | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 4 | 40 | 50 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/02k_mr", "/m/03qtq", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] |
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 );