musiccaps
2 rows where aspect_list contains "punchy snare" and audioset_ids = "["/m/04rlf", "/m/07qb_dv"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
EzP7PB2x670 | The low quality recording features a hip hop song being scratched by the DJ. The song features a filtered flat male vocal, punchy snare, bouncy kick, widely spread shimmering cymbals, groovy bass and arpeggiated electric guitar melody. It sounds bouncy and groovy, as the DJ is probably practicing his scratching skills. | ["low quality", "hip hop", "dj scratching sound effects", "punchy snare", "groovy bass", "flat filtered male vocal", "arpeggiated electric guitar melody", "bouncy kick", "groovy", "bouncy", "wide shimmering cymbals"] | ["Music", "Scratch"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07qb_dv"] | |
Ikdb_jA9ehU | The low quality recording features a DJ scratching effect at the beginning of the loop, after which a synth wave song drops. The song consists of groovy synth bass, percussive tinny elements, shimmering hi-hats, punchy snare and kick hits, soft crash cymbals and wide simple bells melody. It sounds energetic and judging by the arrangement, it's a background song for some kind of video. | ["synth wave", "dj scratching sound effect", "groovy synth bass", "wide simple bells melody", "punchy snare", "shimmering hi hats", "soft crash cymbal", "low quality", "energetic", "tinny percussive elements", "punchy kick"] | ["Music", "Scratch"] | 4 | 0 | 10 | 1 | 1 | ["/m/04rlf", "/m/07qb_dv"] |
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 );