musiccaps

1 row where aspect_list contains "emotional", aspect_list contains "heavy metal" and aspect_list contains "sonic power"

✎ 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
_0-2meOf9qY This music is an electronic guitar instrumental. The tempo is slow with a melancholic , resounding harmony on the guitar. It is mellow, soft, poignant, sentimental and emotional. ["instrumental", "slow tempo", "electric guitar harmony", "electric guitar solo", "electric guitar lead", "amplified guitar", "loud", "emphatic", "resounding", "sonic power", "loud feedback", "rock", "hard rock", "metal", "heavy metal", "soft rock", "pop", "youthful", "pensive", "melancholy", "sentimental", "emotional"] ["Echo", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] 7 10 20 0 0 ["/m/01jnbd", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/t/dd00125"]

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