musiccaps
2 rows where aspect_list contains "snare roll" and audioset_ids contains "/m/08cyft"
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 |
---|---|---|---|---|---|---|---|---|---|---|
JZWJlUdYpCU | The Electro House song features sustained organ keys, chords, filtered drums, punchy kick hits layered with energetic crash and addictive synth lead melody. Right before the drop, there is a short snare roll. It sounds energetic, intense and exciting, as the song is preparing to drop. | ["electro house", "sustained organ synth keys chords", "snare roll", "filtered drums", "punchy kick", "addictive synth lead melody", "energetic", "exciting", "intense", "energetic crash cymbal"] | ["House music", "Music", "Techno", "Trance music", "Dubstep", "Electronic dance music", "Dance music", "Soundtrack music"] | 4 | 80 | 90 | 0 | 1 | ["/m/03mb9", "/m/04rlf", "/m/07gxw", "/m/07lnk", "/m/07s72n", "/m/08cyft", "/m/0ggx5q", "/m/0l14gg"] | |
JsHTGDW5dgw | The low quality recording features an electro song that consists of percussive elements, echoing hi hats, shimmering shakers, cowbell, claps and repetitive percussive bass loop. At the end of the loop, there are snare rolls and risers layered together, building up tension for the drop. It sounds exciting and suspenseful. | ["low quality", "electro", "percussive elements", "echoing hi hats", "shimmering shakers", "cowbell", "clapping", "repetitive percussive bass loop", "snare roll", "riser", "exciting", "suspenseful"] | ["Music", "Rattle", "Electronic dance music"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07qn4z3", "/m/08cyft"] |
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 );