musiccaps

1 row where aspect_list contains "amateur sound recording", aspect_list contains "electronic pop" and aspect_list contains "vocal riff"

✎ 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
KWpsFxRTGkI This song is an electronic instrumental. It is medium tempo with a recurring vocal riff, steady drumming, table turner arrangement and distorted sounds like metal scratching. The audio is muffled, making it difficult to hear the finer elements of the song.The repetitive beats and rhythm give it a trippy, psychedelic and trance vibe. ["distorted sound", "vocal riff", "groovy beat", "table turner", "muffled music", "steady drumming", "catchy beat", "electronic pop", "trap", "psychedelic", "trance", "incoherent sounds", "metal scratching", "loud", "unpleasant", "amateur sound recording", "reverb"] ["Beatboxing", "Music", "Scratch", "Drum machine"] 7 30 40 0 1 ["/m/02cz_7", "/m/04rlf", "/m/07qb_dv", "/m/0cfdd"]

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