musiccaps
2 rows where aspect_list contains "engaging", aspect_list contains "melancholic" and aspect_list contains "youthful"
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 |
---|---|---|---|---|---|---|---|---|---|---|
C9e2k030QcY | The song is an instrumental. The tempo is medium with a Harpsichord being played by an elder gentleman in classic baroque style. The music is engaging and exciting. The song audio quality is poor. | ["harpsichord player", "harpsichord", "baroque music", "poor audio quality", "traditional music", "kings and queens", "western classical music", "slow tempo", "staggered play", "instrumental music", "engaging", "emotional", "melancholic", "youthful", "spirited", "passionate", "tragedy", "great composers", "sight reading"] | ["Harpsichord", "Keyboard (musical)"] | 1 | 30 | 40 | 0 | 0 | ["/m/03q5t", "/m/05148p4"] | |
FRZzUh9hcTo | A male vocalist sings this quirky Rock melody. The tempo is medium fast with groovy electric guitar harmony, funky, intense bass lines, infectious drumming, keyboard accompaniment and vocal backup. The song is catchy, rhythmic, emotional, incessant, sentimental, melancholic, lonely, romantic , unconventional, quirky and upbeat. This song is classic rock. | ["male vocalist", "medium fast tempo", "vocal backup", "funky bass lines", "groovy electric guitar lead", "keyboard accompaniment", "infectious drumming", "passionate", "emotional", "sentimental", "love song", "alternative rock", "funk rock", "alternative dance", "rhythmic", "melancholic", "sad", "lonely", "repetitive", "incessant", "breakup", "heart break", "classic rock", "quirky music", "engaging", "youthful", "enthusiastic"] | ["Funk", "Music"] | 7 | 130 | 140 | 0 | 0 | ["/m/02x8m", "/m/04rlf"] |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );