musiccaps

1 row where aspect_list contains "keyboard harmony", aspect_list contains "passionate" and aspect_list contains "wedding song"

✎ 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
AagemOzvoZE This song is a romantic duet. The tempo is medium with a plethora of instruments like the auto harp, fiddle, acoustic guitar, electric guitar, bass guitar, banjo,intense drumming, cello, violin harmony and vocal harmony. The song is a romantic, charming,emotional, passionate love song. The instrumentation style and music decibels indicate that this is the climax of a country love song. ["duet", "medium tempo", "country song", "fiddle", "auto harp", "song climax", "country love song", "first love", "wedding song", "proposal song", "banjo", "mandolin", "acoustic guitar", "intense drumming", "keyboard harmony", "cello", "violins", "electric guitar", "bass guitar", "love song", "romantic", "passionate", "emotional", "country song hits", "country pop", "folk music"] ["Singing", "Country", "Music"] 7 30 40 0 0 ["/m/015lz1", "/m/01lyv", "/m/04rlf"]

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