musiccaps

1 row where aspect_list contains "dance rock", aspect_list contains "electrifying" and aspect_list contains "rock"

✎ 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
j8z9a9A8LV4 A male voice speaks in a menacing voice over a pop song in the background. The song is fast tempo with synthesiser articulation , digital arrangements and electronic sounds with subtle male vocals. The music is upbeat, energetic, enthusiastic, youthful, chilling, vibrating, exciting and pulsating. This song is a hit by Dance Pop. ["male vocalist", "fast tempo", "famous song", "thrilling", "vibrating", "pulsating", "electrifying", "youthful", "chilling", "super hit song", "male voice superimposed over song", "rock", "classic rock", "dance pop", "dance rock", "disco pop", "funk", "pop soul", "synth funk", "terror", "horror", "hit", "king of pop", "synthesiser articulation", "digital music", "electronic music", "pulsating", "electrifying", "pop hit"] ["Disco"] 7 230 240 0 0 ["/m/026z9"]

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