musiccaps

1 row where aspect_list contains "steel acoustic guitar" and audioset_ids contains "/m/04rzd"

✎ 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
edKvAj0fYxQ The Alternative/Indie song cover features an acoustic ensemble that includes acoustic guitar chord progression, still guitar melody and tinny double bass playing it. It sounds narrow due to the fact that it is a mono recording. Everything, including the double bass, sounds kind of tinny and reverberant, because it was most likely recorded with one mono, room microphone. The sound could definitely be better, but it does not fall into the category of a low quality recording. ["alternative/indie", "mono", "acoustic ensemble", "acoustic guitar", "reverberant", "steel acoustic guitar", "tinny sounding double bass", "narrow"] ["Acoustic guitar", "Music", "Mandolin", "Plucked string instrument"] 4 30 40 0 1 ["/m/042v_gx", "/m/04rlf", "/m/04rzd", "/m/0fx80y"]

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