musiccaps
1 row where aspect_list contains "groovy bass guitar", aspect_list contains "rock" and aspect_list contains "soft ride cymbals"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 );