musiccaps

1 row where aspect_list contains "energetic" and audioset_ids = "["/m/04rlf", "/m/07rwj3x", "/m/07sr1lc"]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: audioset_ids (array)

ytid ▼ url caption aspect_list audioset_names author_id start_s end_s is_balanced_subset is_audioset_eval audioset_ids
qpt3umHYfmY A female singer sings this soulful melody with backup singers in vocal harmony. The song is fast tempo with a quick drumming rhythm, percussive bass line, guitar strumming rhythm and keyboard accompaniment. The song has black gospel roots. ["female singers", "vocal harmony", "backup singers", "passionate", "music you", "need your loving", "soul singers", "percussive horn section", "keyboard accompaniment", "crooners", "stro telling", "love song", "emotional", "choral harmony", "black gospel influences", "emotional", "exciting", "energetic", "jazz music influences", "retro pop influences", "music", "fast tempo", "groovy bass line"] ["Music", "Whoop", "Yell"] 1 30 40 1 1 ["/m/04rlf", "/m/07rwj3x", "/m/07sr1lc"]

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