musiccaps
2 rows where aspect_list contains "festive" and audioset_ids contains "/m/0gg8l"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
_RrA-0lfIiU | This is a live acoustic performance of an Irish folk music piece. The chords of the piece are being played by two acoustic guitars in the background while a violin is playing the main theme which is in medium-to-high range. Since the piece is being played at a pub, the sounds of the place can also be heard in the recording. There is a jovial atmosphere. This piece can be played at Irish pubs. | ["irish", "folk", "acoustic", "live performance", "acoustic guitar", "violin", "jovial", "playful", "festive"] | ["Traditional music", "Flamenco", "Music", "Bluegrass"] | 9 | 30 | 40 | 0 | 1 | ["/m/02p0sh1", "/m/0326g", "/m/04rlf", "/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 );