musiccaps

1 row where aspect_list contains "enegetic" and audioset_ids contains "/m/02sgy"

✎ 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
eM0PkfqGmIE The song is an instrumental. The song is medium fast tempo with a bass guitar soloist playing a cool accompaniment groove with no other instrumentation. The song is passionate and energetic. The song is a bass guitar demo or a home music video. ["bass guitar", "slap bass", "energetic", "echoes", "home video", "average audio quality", "passionate", "virtuoso player", "bass guitar technique", "bass guitar demo", "instrumental music", "emotional", "romantic", "groovy", "funk bass line", "guitar accompaniment style", "instrumental music", "syncopation", "enegetic", "medium fast tempo"] ["Bass guitar", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] 1 30 40 1 1 ["/m/018vs", "/m/01glhc", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0g12c5"]

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