musiccaps

1 row where aspect_list contains "dance club", aspect_list contains "groovy rhythms" and aspect_list contains "instrumental 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
diSfkEkTVkE The song is an instrumental. The tempo is medium with a DJ creating cool rhythmic structures; groovy drum rhythm, percussion hits, grunge tones and staccato notes. The song is exciting and energetic. The song is a techno dance tune. ["dj", "electronic dance music", "groovy rhythms", "sensuous", "dance all night", "ibiza party", "turntable", "cool and sophisticated", "syncopated rhythms", "grunge tones", "instrumental music", "medium tempo", "people dancing", "pulsating tones", "groovy sounds", "dance club", "dance floor", "people dancing", "staccatto tones", "home studio", "song fade"] ["Electronic music", "House music", "Music", "Electronic dance music"] 1 160 170 0 0 ["/m/02lkt", "/m/03mb9", "/m/04rlf", "/m/08cyft"]

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