musiccaps
2 rows where aspect_list contains "soft bass guitar" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
LbQ4zHxhoSI | The Acoustic song features an arpeggiated acoustic melody, wide synth pad chords, soft bass guitar, mellow synth keys melody, soft percussive drums loop and mellow female vocal singing on top. It sounds very relaxing and calming - almost like you can do yoga to it. | ["acoustic", "arpeggiated acoustic guitar melody", "wide synth pad chords", "soft bass guitar", "soft percussive drums loop", "mellow female vocal", "calming", "relaxing", "mellow synth keys"] | ["Mantra", "Chant", "Music"] | 4 | 30 | 40 | 0 | 1 | ["/m/01c194", "/m/02bk07", "/m/04rlf"] | |
eyFBIA_HOmE | The low quality recording features a steel guitar solo melody playing over smooth instrumental on playback that consists of snappy rimshots, wide acoustic rhythm guitar, groovy piano chords, soft bass guitar, soft kick hits and shimmering hi hats. It sounds easygoing and chill - something you would hear in a restaurant or a coffee shop. | ["low quality", "steel guitar solo melody", "smooth instrumental playback", "snappy rimshot", "wide acoustic rhythm guitar", "soft bass guitar", "soft kick", "shimmering hi hats", "groovy piano chords", "easygoing"] | ["Music", "Steel guitar, slide guitar"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/06w87"] |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );