musiccaps

1 row where aspect_list contains "blues mood", aspect_list contains "instrumental", aspect_list contains "moderate tempo" and aspect_list contains "percussion"

✎ 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
W4nQpOHIPEw This song features a solo played on a pedal steel guitar. This is a country blues melody. This involves slides on the guitar. This is accompanied by percussion playing a simple beat in common time. The bass plays 12 bar blues style bassline. An organ outlines chords in the background. This is an instrumental song. There are no voices. This song can be played in a bar. ["pedal steel guitar solo", "slide guitar", "country song", "percussion", "bass", "organ", "no voices", "instrumental", "moderate tempo", "blues mood"] ["Blues", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] 0 30 40 0 0 ["/m/0155w", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/06w87", "/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
);