musiccaps

1 row where aspect_list contains "auto harp", aspect_list contains "people talking" and aspect_list contains "youthful"

✎ View and edit SQL

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"]

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);