musiccaps

1 row where aspect_list contains "duet", aspect_list contains "dulcet", aspect_list contains "proposal song" and aspect_list contains "soft piano accompaniment"

✎ 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
e2tZmQI8ICw This song is a romantic duet.the tempo is medium with a soft keyboard harmony, steady drumming, violin harmony, chimes, Cajun beat, bongos rhythm, steady bass line and acoustic guitar .the song is a proposal song.it is romantic, emotional, passionate, soft, ambient, mellifluous and dulcet. This song is a Soft Pop song. ["duet", "medium tempo", "acoustic guitar", "pleasant", "simple bass lines violin hamony", "soft piano accompaniment", "soft vocals", "vocalisation", "cajun beat", "dulcet", "steady drumming", "bongos", "keyboard accompaniment", "violins", "chimes", "cajun", "pepeasant", "love song", "romantic", "passionate", "sentimental", "proposal song", "melodious", "falling in love", "love song", "proposal song"] ["Music", "Happy music"] 7 230 240 1 1 ["/m/04rlf", "/t/dd00031"]

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