musiccaps

2 rows where aspect_list contains "punchy kick", aspect_list contains "shimmering hi hats" and aspect_list contains "synth pad chords"

✎ View and edit SQL

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
-tmY1GEH3_Y The low quality recording features a pop song that consists of an echoing male vocal singing over punchy kick and snare hits, shimmering hi hats, metallic percussions, synth lead melody, synth pad chords and groovy synth bass. It sounds energetic, nostalgic and exciting - like something you would hear in clubs during the 80s. ["low quality", "pop", "echoing male vocal", "punchy snare", "shimmering hi hats", "punchy kick", "metallic percussions", "synth lead melody", "synth pad chords", "groovy synth bass", "energetic", "exciting", "nostalgic"] ["Music", "Exciting music"] 4 30 40 0 0 ["/m/04rlf", "/t/dd00035"]
WE0JqjuhaQI The low quality recording features a passionate female vocalist singing over dissonant brass stabs, groovy bass, wooden snare hits, synth pad chords, punchy kicks and shimmering hi-hats. It sounds groovy and passionate. ["low quality", "dissonant brass stabs", "groovy bass", "passionate female vocal", "wooden snare hits", "punchy kick", "shimmering hi hats", "groovy", "passionate", "synth pad chords"] ["Electronic music", "Music", "Opera", "Techno"] 4 30 40 0 0 ["/m/02lkt", "/m/04rlf", "/m/05lls", "/m/07gxw"]

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);