musiccaps

1 row where aspect_list contains "pleasant vocals", aspect_list contains "punchy drumming" and aspect_list contains "song climax"

✎ 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
FGZ0sLt4dXA A female singer sings this spirited song. The tempo is fast with a lively piano accompaniment, punchy drumming, funky bass line, rhythmic acoustic guitar, and a droning synthesiser harmony. The music is loud, busy, chaotic and bustling and the vocals are subdued. This clip sounds like the song climax as the instrumentation is strong and powerful. The song is spirited, melodic,energetic, enthusiastic, youthful and engaging. This song is an Indie Pop song. ["female singer", "fast tempo", "electronic music", "melodious", "youthful", "energetic", "enthusiastic", "song climax", "busy", "bustling", "melodipiano accompaniment", "punchy drumming", "synthesiser arrangements", "funky bass lines", "rhythmic acoustic guitar", "psychedelic background", "droning melody", "synth pop", "electronica", "amplified instruments", "pleasant vocals", "indie", "pop", "alternative"] ["Folk music", "Music", "Independent music", "Pop music"] 7 80 90 0 0 ["/m/02w4v", "/m/04rlf", "/m/05rwpb", "/m/064t9"]

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