musiccaps

1 row where aspect_list contains "party night", aspect_list contains "retro dance" and aspect_list contains "techno dance 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
6cQjwXNY4sc The song is an instrumental. The song is medium tempo with a steady drumming rhythm, cymbal crashes, groovy bass line and various percussion hits. The song is youthful and energetic. The song has an average audio quality. ["instrumental music", "techno dance music", "underground music", "cheerful", "teenagers dancing", "retro dance", "cymbal crashes", "steady drumming rhythm", "instrumental music", "dj", "keyboard tones", "discotheque", "dance floor", "dance club", "dance all night", "party night", "groovy bass line", "keyboard accompaniment"] ["Sampler", "Drum and bass", "Music", "Drum machine", "Electronica"] 1 30 40 0 1 ["/m/01v1d8", "/m/0283d", "/m/04rlf", "/m/0cfdd", "/m/0m0jc"]

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