musiccaps

2 rows where aspect_list contains "simple tunes" and audioset_ids contains "/m/0g12c5"

✎ 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
Kd7aHdOwh0I This is an instrumental jam. The only instrument being played is a clean sounding electric guitar. The guitar solo has simple, groovy tunes played in an improvised manner. The atmosphere is easygoing. Parts of this recording could be sampled to be used in beat-making. ["jam", "no singer", "instrumental", "single instrument", "electric guitar", "guitar solo", "easygoing", "groovy", "clean sounding", "simple tunes"] ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] 9 30 40 0 1 ["/m/01b9nn", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0g12c5"]
n179cK8EubU This is a gear showcase jam. There is a male voice talking in between the sounds giving information about a reverb pedal. There is an electric guitar playing random tunes with the reverb effect. The tunes in the recording are simple. Sounds from this recording could be sampled for use in beat-making. ["jam", "instrumental", "single instrument", "male voice", "instructive", "electric guitar", "guitar solo", "effect pedal", "reverb", "simple tunes"] ["Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Distortion"] 9 320 330 0 0 ["/m/01jnbd", "/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/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
);