musiccaps
2 rows where aspect_list contains "ambient", aspect_list contains "female vocalist" and aspect_list contains "melodic"
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 |
---|---|---|---|---|---|---|---|---|---|---|
7qaRlUc4fb0 | A female vocalist sings this beautiful melody in soprano . The tempo is slow with a harp accompaniment. The song is mellow, soothing, sentimental,calming, ethereal, and dulcet. | ["female vocalist", "slow tempo", "harp", "female harpist", "soprano", "solo", "minimalist", "melodic", "celestial", "ethereal harmony", "peaceful", "soothing calming", "performance", "ambient", "soulful"] | ["Gospel music", "Music", "Opera"] | 7 | 30 | 40 | 0 | 1 | ["/m/016cjb", "/m/04rlf", "/m/05lls"] | |
c9tRbWSk7c4 | This song is a vocalisation by a female singer. The tempo is medium with an upbeat electronic guitar harmony, funky bass guitar, slick drumming and acoustic guitar accompaniment. The music is simple, engaging, pleasant, melodic, engaging and has a perky groove. | ["female vocalist", "vocalisation", "groovy", "perky", "no lyrics", "medium tempo", "groovy electric guitar", "funky bass line", "rhythmic acoustic guitar", "mellow", "melodic", "engaging", "slick drumming", "pop", "no lyrics", "simple beat", "ambient", "smooth", "acoustic guita"] | ["Electric guitar", "Music", "Song", "/t/dd00032"] | 7 | 30 | 40 | 0 | 1 | ["/m/02sgy", "/m/04rlf", "/m/074ft", "/t/dd00032"] |
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 );