musiccaps
1 row where aspect_list contains "acoustic rhythm guitar" and aspect_list contains "messy"
This data as json, CSV (advanced)
aspect_list (array) 14 ✖
- acoustic rhythm guitar · 1 ✖
- crowd clapping 1
- distorted 1
- emotional 1
- folk rock 1
- groovy bass guitar 1
- harmonizing vocals 1
- live performance 1
- low quality 1
- messy · 1 ✖
- muddy 1
- passionate 1
- shimmering hi hats 1
- snappy rimshots 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
aPQTrv2B1sw | The low quality recording features a live performance of a folk rock song that consists of harmonizing vocals singing over shimmering hi hats, snappy rimshots, groovy bass guitar and acoustic rhythm guitar, followed by some crowd claps. It sounds messy, muddy and distorted, but still emotional and passionate too. | ["low quality", "live performance", "folk rock", "distorted", "shimmering hi hats", "harmonizing vocals", "groovy bass guitar", "acoustic rhythm guitar", "snappy rimshots", "crowd clapping", "messy", "muddy", "emotional", "passionate"] | ["Singing", "Music", "/t/dd00003"] | 4 | 250 | 260 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/t/dd00003"] |
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 );