musiccaps
2 rows where aspect_list contains "electric guitar", aspect_list contains "female vocal" and aspect_list contains "upbeat"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
suX7Cri4kAo | This is a country music piece. There is a female vocalist singing melodically at the forefront. The melodic background consists of the electric guitar, the bass guitar and the piano. The rhythmic background is provided by a simple acoustic drum beat. The atmosphere is upbeat and easygoing. This piece could be playing in the background at a rock bar. It could also work well as an advertisement jingle. | ["country music", "rock", "female vocal", "melodic singing", "electric guitar", "piano", "bass guitar", "acoustic drums", "simple tune", "upbeat", "easygoing"] | ["Music", "Happy music", "Exciting music"] | 9 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/t/dd00031", "/t/dd00035"] |
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 );