musiccaps

3 rows where aspect_list contains "energetic" and audioset_ids = "["/m/04rlf", "/m/05rwpb"]"

✎ 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
J48F0e0guSQ A female vocalist sings this energetic song. The tempo is fast with furiously energetic drumming, intense electric guitar, groovy bass lines, keyboard harmony, vocal backup and synthesiser arrangements. The song is passionate, spirited,youthful, buoyant, punchy, energetic and animated. The audio is muddy and incoherent. This song is Pop Rock. ["female vocalist", "loud singing", "fast tempo", "pop rock", "hard rock", "dance groove", "buoyant", "spirited", "passionate", "vibrant", "enthusiastic", "energetic", "intense", "vigorous drumming", "intense electric guitar feed back", "groovy bass lines", "synth arrangements", "digital drums", "muffled audio", "inferior quality audio", "rock"] ["Music", "Independent music"] 7 30 40 0 1 ["/m/04rlf", "/m/05rwpb"]
ZOzavOPeuJQ The low quality recording features a metal song that contains a flat male vocal, alongside harmonizing high pitched female vocal, singing over punchy kick and snare hits, shimmering hi hats, distorted bass guitar, mellow synth bells melody and groovy wide electric guitar riff. It sounds energetic, groovy, aggressive. ["low quality", "metal", "flat male vocal", "harmonizing high pitched female vocal", "punchy kick", "punchy snare", "distorted bass guitar", "groovy wide electric guitar riff", "shimmering hi hats", "aggressive", "groovy", "energetic", "mellow synth bells melody"] ["Music", "Independent music"] 4 100 110 0 0 ["/m/04rlf", "/m/05rwpb"]
m-e3w2yZ6sM A male singer sings this rock melody. The tempo is medium with a groovy bass line, guitar rhythm , keyboard accompaniment, and heavy rock drumming with cymbals crashing. The song is energetic and passionate. The song is a retro pop-rock song. ["male singer", "classic rock band", "cymbals crashing", "rock band", "emotional", "steady drumming rhythm", "medium tempo", "guitar rhythm", "keyboard accompaniment", "romantic", "emotional", "love song", "energetic", "youthful", "passionate", "retro pop hits", "percussive bass line"] ["Music", "Independent music"] 1 30 40 0 1 ["/m/04rlf", "/m/05rwpb"]

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