musiccaps
1 row where aspect_list contains "fruity male vocal" and aspect_list contains "mellow piano melody"
This data as json, CSV (advanced)
aspect_list (array) 13 ✖
- emotional 1
- fruity male vocal · 1 ✖
- gospel 1
- groovy bass 1
- harmonizing choir 1
- low quality 1
- mellow piano melody · 1 ✖
- passionate 1
- punchy kick 1
- punchy tom 1
- shimmering cymbals 1
- snappy rimshots 1
- soulful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
lSbCqHZy_l4 | The low quality recording features a fruity male vocal talking, after which he starts singing over harmonizing choir, groovy bass, mellow piano melody, shimmering cymbals, punchy kick, punchy tom and snappy rimshots. It sounds emotional, soulful and passionate. | ["low quality", "fruity male vocal", "gospel", "harmonizing choir", "groovy bass", "mellow piano melody", "shimmering cymbals", "punchy kick", "punchy tom", "snappy rimshots", "emotional", "soulful", "passionate"] | ["Singing", "Gospel music", "Choir"] | 4 | 110 | 120 | 0 | 0 | ["/m/015lz1", "/m/016cjb", "/m/0l14jd"] |
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 );