musiccaps
1 row where aspect_list contains "cheering" and aspect_list contains "country folk music"
This data as json, CSV (advanced)
aspect_list (array) 27 ✖
- acoustic guitar 1
- amateur recording 1
- ambient noises 1
- auto harp 1
- bluegrass 1
- celebratory 1
- cheerful 1
- cheering · 1 ✖
- clapping 1
- concert 1
- country folk music · 1 ✖
- country music 1
- enthusiastic 1
- fast tempo 1
- festive 1
- gig 1
- happy 1
- inferior audio quality 1
- live performance 1
- lively 1
- male vocalists 1
- mandolin 1
- people talking 1
- spirited 1
- vigorous banjo 1
- vivacious 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
0XxinBtKouQ | A group of male vocalists sing this happy, upbeat country /bluegrass song. The tempo is fast with vigorous and animated acoustic guitar, banjo, mandolin and auto harp lead and harmony. The song is a live performance with ambient sounds of clapping, cheering and people talking. This song is a cheerful Country Pop/Bluegrass song. | ["male vocalists", "fast tempo", "cheerful", "happy", "acoustic guitar", "vigorous banjo", "auto harp", "mandolin", "ambient noises", "clapping", "cheering", "people talking", "live performance", "gig", "concert", "cheering", "country music", "country folk music", "bluegrass", "inferior audio quality", "amateur recording", "lively", "spirited", "enthusiastic", "vivacious", "youthful", "happy", "celebratory", "festive"] | ["Banjo", "Country", "Music", "Rock and roll", "Bluegrass"] | 7 | 30 | 40 | 0 | 1 | ["/m/018j2", "/m/01lyv", "/m/04rlf", "/m/07sbbz2", "/m/0gg8l"] |
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 );