musiccaps

2 rows where aspect_list contains "acoustic rhythm guitar", aspect_list contains "happy", aspect_list contains "joyful" and aspect_list contains "passionate male vocal"

✎ 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
Aro-HcWNsHI The low quality recording features an acoustic rhythm guitar playing over a pop song played on playback in the background. It sounds joyful and happy, while the recording is in mono and noisy. ["low quality", "playback", "pop", "passionate male vocal", "snappy snare", "synth pad", "acoustic rhythm guitar", "noisy", "mono", "joyful", "happy"] ["Country", "Music", "Strum", "Bluegrass"] 4 30 40 0 0 ["/m/01lyv", "/m/04rlf", "/m/07s0s5r", "/m/0gg8l"]
UJA5AWbt6HM The Regional Mexican song features a passionate male vocal singing over guiro percussion, followed by wooden percussion, shimmering cymbals, acoustic rhythm guitar in the left channel of the stereo image and bright brass melody in the right channel. It sounds joyful, happy and passionate. ["regional mexican", "passionate male vocal", "guiro percussion", "wooden percussions", "shimmering cymbals", "bright brass melody", "groovy bass", "acoustic rhythm guitar", "passionate", "happy", "joyful"] ["Music", "Music of Latin America", "Salsa music"] 4 70 80 0 0 ["/m/04rlf", "/m/0g293", "/m/0ln16"]

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