musiccaps
2 rows where aspect_list contains "acoustic guitar" and audioset_ids contains "/m/0g12c5"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 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"] | |
| oOlMzQpK690 | Someone is playing a distorted e-guitar solo along to a backing track containing a strummed acoustic guitar and a simple drum groove. This recording is of poor audio-quality. This song may be playing at home practicing guitar. | ["e-guitar", "acoustic guitar", "drums", "amateur recording", "medium tempo"] | ["Electric guitar", "Guitar", "Music", "Wedding music", "Distortion"] | 6 | 30 | 40 | 1 | 1 | ["/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04wptg", "/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 );