musiccaps

2 rows where aspect_list contains "buoyant", aspect_list contains "infectious" and aspect_list contains "youthful"

✎ 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
CYZZIkEw_jY This music is an energetic drum solo. The tempo is fast with an enthusiastic, vigorous drumming riff. The drummer uses the snare and bass drum to create a thumping beat. It is youthful, rhythmic,vivacious, upbeat ,buoyant and infectious. ["instrumental", "percussion instrumental", "drumming", "bass drum pedal", "thumping", "buoyant", "punchy", "energetic", "enthusiastic", "youthful", "infectious", "emphatic", "upbeat", "rhythmic", "catchy riff", "drum solo", "snare", "bass drum", "acoustic drum"] ["Drum", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] 7 30 40 0 0 ["/m/026t6", "/m/02k_mr", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"]
E16FgDFQI_w A female vocalist sings this groovy pop song. The tempo is fast with accordion harmony, funky bass lines, punchy drumming and keyboard accompaniment. The song is youthful, infectious, catchy, bouncy, nifty and groovy with a dance rhythm. This song is Modern pop. ["female singer", "fast tempo", "lively accordion", "synthesiser arpeggio", "bouncy", "infectious", "dance hits", "club music", "dance hits", "pop hits", "catchy riff", "simple melody", "energetic", "spirited", "groovy bass line", "punchy drumming", "keyboard harmony", "groovy melody", "buoyant", "youthful", "teen pop", "contemporary pop", "peppy", "youthful"] ["Afrobeat", "Music of Asia", "Music", "Dance music"] 7 30 40 0 1 ["/m/0145m", "/m/028sqc", "/m/04rlf", "/m/0ggx5q"]

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