musiccaps
2 rows where aspect_list contains "punchy snare" and audioset_ids contains "/m/0l14qv"
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 |
---|---|---|---|---|---|---|---|---|---|---|
OMcoFfaCaGM | The low quality recording features a digital drum machine playing tinny syncopated percussion, shimmering hi hats, soft crash cymbals, punchy kick and snare hits. It sounds energetic, groovy and the rhythm of the hi hats is being modulated in the second half of the loop. | ["low quality", "mono", "digital drum machine", "upbeat", "tinny syncopated percussions", "shimmering hi hats", "modulating rhythm", "soft crash cymbal", "punchy kick", "punchy snare", "energetic", "groovy"] | ["Sampler", "Music", "Musical instrument", "Drum machine", "Synthesizer"] | 4 | 30 | 40 | 0 | 1 | ["/m/01v1d8", "/m/04rlf", "/m/04szw", "/m/0cfdd", "/m/0l14qv"] | |
zNgRUFOj3HI | The low quality recording features a DJ scratching the vinyl of a hip hop instrumental that consists of punchy kick and snare hits and sustained filter modulated bass. The recording is muffled, noisy, mono and muddy, as it was probably recorded with a phone. | ["low quality", "dj scratching", "hip hop", "sustained filter mod bass", "punchy kick", "punchy snare", "muffled", "noisy", "mono", "muddy"] | ["Scratching (performance technique)", "Sampler", "Music", "Scratch", "Drum machine", "Synthesizer"] | 4 | 30 | 40 | 1 | 1 | ["/m/01hgjl", "/m/01v1d8", "/m/04rlf", "/m/07qb_dv", "/m/0cfdd", "/m/0l14qv"] |
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 );