musiccaps

2 rows where aspect_list contains "arpeggiated acoustic guitar melody", aspect_list contains "emotional" and aspect_list contains "mono"

✎ 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
62L5kn1qFeY The low quality recording features a cover of a rock song and it consists of an arpeggiated acoustic guitar melody over which there is a soft female vocal singing. The recording is noisy, in mono and it sounds emotional, soft and passionate. ["low quality", "soft female vocal", "arpeggiated acoustic guitar melody", "noisy", "mono", "passionate", "emotional", "soft", "cover", "rock"] ["Singing", "Guitar", "Music", "Mandolin", "Musical instrument", "Ukulele", "Plucked string instrument"] 4 150 160 0 0 ["/m/015lz1", "/m/0342h", "/m/04rlf", "/m/04rzd", "/m/04szw", "/m/07xzm", "/m/0fx80y"]
cOgNXgF21u4 The low quality song features a cover of a ballad song and it consists of arpeggiated acoustic guitar melody and passionate male vocal singing over it. The recording is very noisy and in mono, like it was recorded with a phone, but regardless it sounds emotional and passionate. ["low quality", "arpeggiated acoustic guitar melody", "noisy", "passionate male vocal", "cover", "ballad", "passionate", "emotional", "mono"] ["Country", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum"] 4 30 40 0 1 ["/m/01lyv", "/m/042v_gx", "/m/04rlf", "/m/06w87", "/m/07s0s5r"]

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