musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "groovy", aspect_list contains "shimmering hi hats" and aspect_list contains "upbeat"
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 |
---|---|---|---|---|---|---|---|---|---|---|
A5fPSkTvjmY | The low quality recording features a hip hop song that consists of a flat male vocal rapping over punchy kick and snare hits, shimmering hi hats, DJ scratching sound effects and groovy bass. It sounds energetic, upbeat and groovy. | ["low quality", "hip hop", "punchy snare", "dj scratching sounds", "punchy kick", "groovy bass", "flat male vocal", "shimmering hi hats", "upbeat", "groovy", "energetic"] | ["Scratching (performance technique)"] | 4 | 70 | 80 | 0 | 0 | ["/m/01hgjl"] | |
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"] |
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 );