musiccaps

1 row where aspect_list contains "ambulance siren", aspect_list contains "dj" and aspect_list contains "police van siren"

✎ 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
ItLWKIhe58c This song is an instrumental. The tempo is fast with vigorous drumming, thumping bass lines and keyboard arrangement with sounds of an ambulance or police van, menacing voices, grunting, incoherent vocal riff and whooshing sound of wind. This song is aggressive, vigorous, energetic trippy, trance like with the syncopated music giving it a eerie, sinister, creepy vibe. This song is a Hard Rock/Goth Rock. ["instrumental", "fast tempo", "trance", "trap", "police van siren", "intense", "dj", "dance music", "club music", "incoherent vocals", "trippy music", "vigorous beat", "syncopated harmony", "thumping beat", "vigorous drumming", "synthesiser arrangements", "ambulance siren", "menacing voices", "roaring", "grunting", "vocal riff", "rock", "goth rock", "sinister", "eerie", "creepy", "dangerous", "frightening"] ["Drum and bass", "Music", "Trance music", "Dubstep", "Electronic dance music"] 7 30 40 0 1 ["/m/0283d", "/m/04rlf", "/m/07lnk", "/m/07s72n", "/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
);