musiccaps

1 row where aspect_list contains "groovy", aspect_list contains "powerful" and aspect_list contains "rich"

✎ 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
ouVuF-y8bog This music is an electric guitar instrumental. The tempo is medium with a smooth electric guitar lead harmony. The music is clear, emphatic, smooth, groovy, youthful, crisp, edgy and dominant. ["instrumental", "electric guitars", "medium tempo", "demonstration", "tutorial", "learning electric", "electric guitar lesson", "clear", "loud", "powerful", "empahtic", "amplified guitar", "electric guitar", "stringed instrument", "loud feed back", "blues", "rock", "jazz", "resonating", "reverb", "youthful", "groovy", "catchy riff", "smooth", "electric guitar lead", "electric guitar solo", "dense", "rich", "crisp", "edgy"] ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] 7 30 40 0 0 ["/m/01b9nn", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0g12c5"]

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