musiccaps

1 row where aspect_list contains "energetic" and audioset_ids = "["/m/015lz1", "/m/04rlf", "/m/07pp8cl", "/m/0glt670"]"

✎ 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
DCFrCX4HPO8 A female singer sings this passionate melody. The song is a medium tempo with a groovy bass line , steady drumming, keyboard accompaniment, Indian percussion and tambourine accompaniment. The song is playful and romantic. The song is a modern Bollywood pop song with average quality audio. ["telephone ringing", "hindi pop music", "medium tempo", "indian percussions", "tambourine percussions", "female singers", "romantic", "love song", "hindi pop song", "guitar rhythm", "strong bass line", "energetic", "passionate", "bollywood dance music", "average audio quality", "keyboard accompaniment"] ["Singing", "Music", "Telephone bell ringing", "Hip hop music"] 1 120 130 1 1 ["/m/015lz1", "/m/04rlf", "/m/07pp8cl", "/m/0glt670"]

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