musiccaps

1 row where aspect_list contains "demonstration", aspect_list contains "electric guitar" and aspect_list contains "vibrations"

✎ 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
4ls_8xIjBzM This music is instrumental. The tempo is medium with an electric guitar riff and the voice of a man giving instructions on electric guitar techniques. The music is loud, clear, amplified, vivid, emphatic and powerful. This is a tutorial/ lesson on electric guitar techniques. ["instrumental", "medium tempo", "male voice speaking", "demonstration", "electric guitar", "stringed instrument", "amplified instrument", "loud", "clear", "rich", "deep", "rock", "hard rock", "metal", "heavy metal", "pop", "powerful", "emphatic", "intense", "electric guitar lesson", "electric guitar tutorial", "learning electric guitar", "electric guitar techniques", "vibrations"] ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] 7 150 160 0 0 ["/m/01glhc", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/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
);