musiccaps

1 row where aspect_list contains "gentle", audioset_ids contains "/m/0g12c5" and author_id = 9

✎ 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
J0RzvGnQxD0 This is an instrumental rock music jam. The only instrument is a clean-sounding electric guitar playing an arpeggio with an added echo effect. The atmosphere is calming. Although the recording quality is a bit low, this piece could be playing in the background of a rock bar after a decent mix is applied. ["jam", "rock music", "electric guitar", "clean sound", "single instrument", "no singer", "instrumental", "echo", "gentle", "calm"] ["Echo", "Effects unit", "Guitar", "Heavy metal", "Music", "Musical instrument", "Distortion"] 9 60 70 0 1 ["/m/01jnbd", "/m/02rr_", "/m/0342h", "/m/03lty", "/m/04rlf", "/m/04szw", "/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
);