musiccaps
1 row where aspect_list contains "cozy" and aspect_list contains "female vocal"
This data as json, CSV (advanced)
aspect_list (array) 13 ✖
- acoustic guitar 1
- acoustic sounding drums 1
- bass guitar 1
- country music 1
- cozy · 1 ✖
- easygoing 1
- electric guitar 1
- female vocal · 1 ✖
- joyful 1
- live performance 1
- male vocals 1
- simple tune 1
- upbeat 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
QSaX7QfeWog | This is the live performance of a country music piece. There is a female vocal and two male vocals taking turns and sometimes singing the words at the same time. The melody consists of an electric guitar, an acoustic guitar and a bass guitar while in the rhythmic background there is an acoustic sounding upbeat drum beat. The atmosphere is cozy. There is an easygoing aura to it. This piece could be used in the soundtrack of a movie or a TV show that takes place in rural USA. | ["country music", "female vocal", "male vocals", "electric guitar", "acoustic guitar", "acoustic sounding drums", "bass guitar", "simple tune", "easygoing", "cozy", "joyful", "upbeat", "live performance"] | ["Singing", "Country", "Music", "Mandolin", "Ska", "Song"] | 9 | 30 | 40 | 1 | 1 | ["/m/015lz1", "/m/01lyv", "/m/04rlf", "/m/04rzd", "/m/06rqw", "/m/074ft"] |
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 );