musiccaps
2 rows where audioset_ids contains "/m/02rr_" and audioset_ids contains "/m/042v_gx"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ZVvX2-ldhvY | solo acoustic nylon string guitar playing in a fingerstyle Brazilian bossa nova style. | ["solo guitar", "nylon string acoustic", "fingerstyle", "bossa nova", "brazilian"] | ["Effects unit", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | 8 | 30 | 40 | 0 | 0 | ["/m/02rr_", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y"] | |
bqvl7IbPteU | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | 7 | 30 | 40 | 0 | 1 | ["/m/02rr_", "/m/02sgy", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/07s0s5r", "/m/0fx80y", "/m/0g12c5"] |
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 );