musiccaps

1 row where aspect_list contains "acoustic guitar", aspect_list contains "american", aspect_list contains "easygoing" and aspect_list contains "mandolin"

✎ 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
DAPGvg8qOAU This is an acoustic folk piece. The main melody is being played with a mandolin while there is an acoustic guitar backing. A male vocalist is singing in a story-telling mood. The overall atmosphere of the piece is mellow. This piece could definitely be used in the soundtracks of romantic movies. It could also be played in sequences that emphasize longing and loneliness. ["acoustic folk", "mandolin", "acoustic guitar", "male vocal", "story-telling mood", "mellow", "gentle", "cozy", "easygoing", "american"] ["Singing", "Music", "Mandolin", "Ukulele"] 9 0 10 1 1 ["/m/015lz1", "/m/04rlf", "/m/04rzd", "/m/07xzm"]

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