musiccaps
2 rows where aspect_list contains "arpeggiated electric guitar melody" and audioset_ids contains "/t/dd00034"
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 |
---|---|---|---|---|---|---|---|---|---|---|
JOhK7oq9KtU | The low quality recording features a live performance of an indie song and it contains passionate female vocal singing over arpeggiated electric guitar melody and shimmering shakers. It is a bit noisy, there are some crowd noises and it sounds passionate, emotional and like an intro section of the song. | ["low quality", "crowd noises", "noisy", "indie", "live performance", "passionate female vocal", "shimmering shakers", "arpeggiated electric guitar melody", "emotional", "passionate", "intro"] | ["Music", "Vocal music", "Tender music"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/0y4f8", "/t/dd00034"] | |
bBGcQ2-W768 | The Soft Rock song features a flat male vocal singing over arpeggiated electric guitar melody, punchy kick, groovy bass, shimmering hi hats and snappy rimshots. It sounds emotional and easygoing. | ["soft rock", "flat male vocal", "arpeggiated electric guitar melody", "punchy kick", "groovy bass guitar", "shimmering hi hats", "snappy rimshots", "emotional", "easygoing"] | ["Music", "Sad music", "Tender music"] | 4 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/t/dd00033", "/t/dd00034"] |
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 );