musiccaps

1 row where aspect_list contains "hard hitting drums", audioset_ids contains "/m/011k_j" and author_id = 7

✎ 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
si_IAMPOXlQ This music is an intense instrumental. The tempo is medium with hard hitting drums, ceremonial big drums, amplified piano and violin harmony. The music is syncopated and intense. It is like a background score for a movie. ["instrumental", "fast tempo", "amplified piano", "movie background score", "hard hitting drums", "ceremonial drums", "bass drum", "dissonant beats", "violin harmony", "ost", "enthusiastic", "intense"] ["Timpani", "Music"] 7 170 180 1 1 ["/m/011k_j", "/m/04rlf"]

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