musiccaps

1 row where aspect_list contains "dance groove", aspect_list contains "hip-hop" and aspect_list contains "party music"

✎ 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
Brc_nOquNbY A male vocalist sings this spirited rap. The tempo is fast with an animated piano accompaniment, groovy bass lines, intense drumming, cymbal rides and vocal backup. The song is youthful, vibrant, vivacious, animated, compelling ,enthusiastic and passionate . This song is contemporary Hip-Hop/Rap. ["male singer", "fast tempo", "rap", "rapper", "dance groove", "club music", "party music", "funk", "dance pop", "dance rap", "disco rap", "hip-hop", "hip-hop hits", "energetic", "enthusiastic", "rhythmic patter", "passionate emotional", "animated piano harmony", "vigorous drumming", "cymbals", "digital drumming", "punchy bass lines", "vocal backup", "street vernacular", "punk rap", "funk rap", "dance groove", "youthful", "compelling", "persuasive"] ["Jazz", "Music"] 7 30 40 0 1 ["/m/03_d0", "/m/04rlf"]

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