musiccaps

1 row where aspect_list contains "advertisement jingle", aspect_list contains "electric guitar solo" and aspect_list contains "solemn"

✎ 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
Y_eh6C0EBP8 The song is an instrumental followed by a long pause. The song is medium tempo and features an electric guitar playing a solemn solo. The song is passionate and mysterious. The audio quality is poor. ["instrumental music", "long pause", "electric guitar solo", "poor audio quality", "song introduction", "soloist", "hissing tones", "ambient room sounds", "documentary sound track", "advertisement jingle", "amplified guitar solo", "solemn", "emotional", "energetic", "guitar amplifier tone", "medium tempo", "instrumental music"] ["Silence", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] 1 0 10 0 1 ["/m/028v0c", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0b_fwt", "/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
);