musiccaps
2 rows where aspect_list contains "shimmering shakers" and audioset_ids contains "/m/026t6"
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"] | |
y3Pqe5DLvok | The low quality recording features a live performance of groovy hi hats, wide marimba melody, shimmering shakers and a punchy kick pattern. It sounds reverberant, probably because they performed in a medium size space, exotic and passionate. | ["low quality", "live performance", "groovy hi hats", "wide marimba melody", "shimmering shakers", "punchy kick", "reverberant", "exotic", "passionate"] | ["Drum", "Music", "Musical instrument", "Marimba, xylophone", "Vibraphone", "Percussion"] | 4 | 70 | 80 | 0 | 0 | ["/m/026t6", "/m/04rlf", "/m/04szw", "/m/0dwsp", "/m/0dwt5", "/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 );