musiccaps

1 row where aspect_list contains "emotional", aspect_list contains "hissing tones" and aspect_list contains "techno drum rhythm"

✎ 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
AU1l1i0H0j0 The song is an instrumental. The song is medium tempo with a groovy bass line, techno drumming rhythm, keyboard synth string accompaniment and other percussive hits. The song is energetic and passionate. The song is a techno dance tune and has poor audio quality, ["techno dance music", "poor audio quality", "medium tempo", "poor audio quality", "groovy rhythm", "ad jingle", "hissing tones", "instrumental music", "keyboard synth harmony", "strong bass line", "techno drum rhythm", "hissing tones", "energetic", "emotional", "passionate", "dance groove", "tv advertisement sound track"] ["Music", "Spray"] 1 30 40 0 1 ["/m/04rlf", "/m/07qlf79"]

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