musiccaps
1 row where aspect_list contains "acoustic rhythm guitar chords" and aspect_list contains "passionate solo acoustic guitar melody"
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 |
---|---|---|---|---|---|---|---|---|---|---|
AmAThmRphk0 | The Jazz song features a passionate solo acoustic guitar melody and acoustic rhythm guitar chords, followed by simple double bass. It sounds smooth and elegant, something you would hear in fancy restaurants or good jazz clubs. | ["jazz", "passionate solo acoustic guitar melody", "acoustic rhythm guitar chords", "simple double bass", "smooth", "elegant"] | ["Banjo", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | 4 | 30 | 40 | 0 | 1 | ["/m/018j2", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04rzd", "/m/04szw", "/m/0fx80y", "/m/0gg8l"] |
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 );