musiccaps

2 rows where aspect_list contains "gear review", audioset_ids contains "/m/04rlf" 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
MiWskwqOMrg This is the recording of a gear review video. There is a male voice describing the feel of a certain reverb amp. There is a static sound that can be heard while he is talking, because the guitar is still plugged in. A mellow tune can be heard playing from a clean sounding electric guitar in the background. ["gear review", "male voice", "talking", "amp static", "electric guitar", "mellow tune"] ["Reverberation", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] 9 30 40 0 0 ["/m/01b9nn", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/m/0fx80y"]
ihJT65fZaHY This is a gear review jam video. There is a male voice describing the tone that he achieves from using an amp with the electric guitar. The said amp applies an echo effect to the electric guitar, making it sound more dreamy. The performer is playing a simple tune. This piece could be sampled for use in an advertisement jingle or in beat-making. ["jam", "gear review", "male voice", "single instrument", "electric guitar", "guitar solo", "amp", "echo", "easygoing", "dreamy", "simple tune"] ["Echo", "Effects unit", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] 9 30 40 0 0 ["/m/01jnbd", "/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/m/0fx80y"]

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