musiccaps

1 row where aspect_list contains "boisterous", aspect_list contains "chaotic" and aspect_list contains "energetic"

✎ 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
wIP7AqIOU1s A male vocalist sings this song. The tempo is medium with loud boomy singing.the audio quality is bad so the music and vocals are muffled. There are traces of tambourine beat, trumpet or some brass instrument,keyboard accompaniment, people talking, chanting and clapping. It is chaotic, confusing and noisy. ["male vocalist", "muffled audio", "inferior audio quality", "tambourine beats", "boisterous", "chaotic", "confusing", "noisy", "syncopated", "enthusiastic", "energetic", "brass instrument", "clapping", "tambirine", "keyboard accompaniment", "chanting", "talking", "incoherent lyrics", "amateur recording", "loud"] ["Singing", "Music", "Tambourine", "Vocal music"] 7 30 40 1 1 ["/m/015lz1", "/m/04rlf", "/m/07brj", "/m/0y4f8"]

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