musiccaps
1 row where aspect_list contains "claps" and aspect_list contains "melancholic"
This data as json, CSV (advanced)
aspect_list (array) 12 ✖
- alternative/indie 1
- claps · 1 ✖
- easygoing 1
- electric guitar melody 1
- groovy bass guitar 1
- intimate wide mixed vocals 1
- melancholic · 1 ✖
- noisy snare 1
- punchy kick 1
- short snare roll 1
- synth lead melody 1
- tinny wide hi hats 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
-BHPu-dPmWQ | The Alternative/Indie song features an intimate, widely spread, mixed vocals singing over noisy snare, punchy kick, wide tinny hi hats, electric guitar melody, synth lead melody and groovy bass guitar. At the end of the loop there is a short snare roll and some claps. It sounds easygoing and melancholic thanks to those vocals. | ["intimate wide mixed vocals", "synth lead melody", "punchy kick", "noisy snare", "claps", "groovy bass guitar", "tinny wide hi hats", "short snare roll", "alternative/indie", "electric guitar melody", "easygoing", "melancholic"] | ["Music", "/t/dd00032"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00032"] |
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 );