musiccaps

1 row where aspect_list contains "electronic", aspect_list contains "repeated theme" and aspect_list contains "trippy"

✎ 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
tUBTRs7Avk0 This is an electronic/downtempo house music piece. There is a male vocalist singing melodically under heavy effects. There is a synth and an acoustic guitar playing the repeated main tune. The rhythmic background consists of an acoustic drum beat. The atmosphere is trippy. This piece could be used in the soundtrack of an animation movie, especially during vivid dream sequences. ["electronic", "downtempo", "house", "male vocal", "heavy effects", "synth", "acoustic guitar", "repeated theme", "acoustic drums", "chill", "trippy"] ["Funk", "Music"] 9 130 140 0 0 ["/m/02x8m", "/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
);