musiccaps
2 rows where aspect_list contains "instrumental", aspect_list contains "piano accompaniment" and aspect_list contains "sentimental"
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 |
---|---|---|---|---|---|---|---|---|---|---|
7OjXHfVoI64 | This song is an instrumental interlude of the Gospel song ‘Thorns in the Straw. The music is slow with a melancholic trombone and tuba harmony, acoustic guitar accompaniment , bass, steady drumming,and synthesiser arrangements. The music is soft, mellow, poignant,pensive, sentimental,emotional, reflective and serene. This song is a Gospel Instrumental. | ["instrumental", "slow tempo", "rhythmic acoustic guitar", "trumpets", "trombone harmony", "tuba accompaniment", "bass", "piano accompaniment", "synthesiser arrangement", "soft", "mellow", "gospel music", "instrumental cover", "christian song", "christian praise and worship", "easter song", "good friday", "christmas song", "contemporary christian music", "mellow", "dulcet", "euphonious", "sentimental", "sere", "calm", "soothing", "emotional"] | ["Brass instrument", "French horn"] | 7 | 200 | 210 | 0 | 0 | ["/m/01kcd", "/m/0319l"] | |
EkmHGd0U8yE | This music is instrumental. The tempo is slow with a melancholic cello harmony, and a piano and violin accompaniment. The music is soft, pensive, melancholic, sentimental, sad, reflective, meditative and delicate. This music is a Violin Instrumental. | ["instrumental", "slow tempo", "cello", "violin", "sad", "reflective", "delicate", "poignant", "meditative", "reflective", "piano accompaniment", "soft", "mellow", "ambient", "pensive", "ponderous", "sentimental", "emotional"] | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | 7 | 100 | 110 | 0 | 0 | ["/m/01xqw", "/m/02fsn", "/m/07y_7", "/m/0l14_3"] |
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 );