musiccaps

1 row where aspect_list contains "busy", aspect_list contains "hard hitting drums" and aspect_list contains "spirited"

✎ 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
dHGAXJ9RPJs A male vocalist sings this spirited Rock song. The tempo is fast with an upbeat Amplified keyboard harmony, hard hitting drums, punchy bass lines and a dominating electric guitar accompaniment. The vocals are subdued for a Rock song. The song is youthful, vibrant, energetic, enthusiastic, buoyant, punchy and vivacious. This song is Classic Hard Rock. ["male singer", "fast tempo", "rock", "hard rock", "dominating electric guitar", "punchy", "buoyant", "vivacious", "video game music", "animated", "chaotic", "busy", "rock hits", "concert", "hard hitting drums", "loud electric guitar feedback", "amplified keyboard harmony", "funky bass line", "subdued vocals", "imposing music", "youthful", "energetic", "enthusiastic", "spirited", "vivacious", "classic rock", "intense"] ["Music", "Grunge"] 7 30 40 0 1 ["/m/04rlf", "/m/0dls3"]

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