musiccaps
2 rows where aspect_list contains "passionate solo acoustic guitar melody" and audioset_ids contains "/m/04rzd"
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 |
---|---|---|---|---|---|---|---|---|---|---|
36ToDxW_hns | The low quality recording features a cover of a rock and it consists of passionately played solo acoustic guitar melody over staccato strings melody playing in the background on playback. Even though the recording is noisy, it sounds emotional and passionate. | ["low quality", "staccato strings melody", "passionate solo acoustic guitar melody", "noisy", "cover", "rock", "playback", "emotional", "passionate"] | ["Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | 4 | 90 | 100 | 0 | 1 | ["/m/0342h", "/m/04rlf", "/m/04rzd", "/m/04szw", "/m/0fx80y"] | |
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 );