musiccaps

2 rows where aspect_list contains "passionate" and audioset_names contains "Electronic 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
66B46E_hrrk The song is an instrumental. The tempo is medium with a groovy drumming rhythm, percussive bass line, keyboard accompaniment and various percussive and sonic effects. The song is youthful and exciting with a trance element. The song is a modern tench pop dance tune. ["techno dance music", "electronic dance music", "trance dance music", "medium tempo", "groovy bas slime", "techno drumming rhythm", "keybiard accompaniment", "percussion hits", "sonic effects", "dj", "dance floor", "dance club", "people dancing", "groovy dance rhythm", "trance music", "enthusiastic", "passionate", "youthful", "exciting"] ["Drum and bass", "Electronic music", "Music", "Dubstep", "Electronic dance music"] 1 140 150 0 0 ["/m/0283d", "/m/02lkt", "/m/04rlf", "/m/07s72n", "/m/08cyft"]
WE0JqjuhaQI The low quality recording features a passionate female vocalist singing over dissonant brass stabs, groovy bass, wooden snare hits, synth pad chords, punchy kicks and shimmering hi-hats. It sounds groovy and passionate. ["low quality", "dissonant brass stabs", "groovy bass", "passionate female vocal", "wooden snare hits", "punchy kick", "shimmering hi hats", "groovy", "passionate", "synth pad chords"] ["Electronic music", "Music", "Opera", "Techno"] 4 30 40 0 0 ["/m/02lkt", "/m/04rlf", "/m/05lls", "/m/07gxw"]

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