musiccaps

1 row where aspect_list contains "entertaining" and aspect_list contains "instrumentalist"

✎ 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
0HXYdGGKV2k The song is an instrumental. The song is medium tempo with a groovy rhythm and fast fingers playing this banjo solo. The song is entertaining and exciting. The song is of poor audio quality and a live performance video. ["banjo player", "fast tempo", "groovy music", "love video performance", "instrumental music", "virtuoso", "walking bass line", "entertaining", "love performance", "soloist", "country blue grass", "entertaining", "energetic", "passionate", "spirited", "instrumentalist", "poor audio quality", "live performance"] ["Banjo", "Music", "Bluegrass"] 1 30 40 0 1 ["/m/018j2", "/m/04rlf", "/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
);