musiccaps

1 row where aspect_list contains "afrodance/funk", aspect_list contains "good vibrations" and aspect_list contains "percussion's"

✎ 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
dkGXJ6BlCd4 This song is full of fast paced rhythm being played by percussion and a drumset. An e-guitar is playing a fast repeating melody with little changes along with an e-piano playing chords and melody. The e-bass is playing a groove along with the drums that sounds inviting to dance along. In the background you can hear voices cheering. This song may be playing live. ["afrodance/funk", "e-guitar", "e-bass", "acoustic drums", "percussion's", "background cheering", "piano", "upbeat", "good vibrations"] ["Swing music", "Music", "Ska", "Music of Latin America", "Salsa music"] 6 30 40 0 1 ["/m/015y_n", "/m/04rlf", "/m/06rqw", "/m/0g293", "/m/0ln16"]

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