musiccaps
1 row where aspect_list contains "cymbal ride" and aspect_list contains "vivacious"
This data as json, CSV (advanced)
aspect_list (array) 23 ✖
- acoustic guitar 1
- booming sounds 1
- cymbal ride · 1 ✖
- dissonant booming sounds 1
- edm 1
- electronic music 1
- electronically arranged sounds 1
- energetic 1
- fast tempo 1
- funky bass line 1
- groovy 1
- hissing sound 1
- instrumental 1
- keyboard harmony 1
- punch digital drum beat 1
- punchy drumming 1
- sound of bubbling 1
- steady drumming 1
- synthesiser arrangements 1
- vibrant 1
- vivacious · 1 ✖
- water boiling 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
hmkPWxTIwwU | This music is an electronic instrumental. The tempo is fast with punchy drumming rhythm, keyboard harmony, vigorous guitar rhythm and electronically arranged sounds like a dissonant booming drum, water bubbling, hissing and whistle like instrument playing harmony. The song is youthful, energetic, enthusiastic, vigorous, vivacious and youthful with a dance groove. This music is EDM. | ["instrumental", "fast tempo", "punchy drumming", "funky bass line", "electronic music", "acoustic guitar", "keyboard harmony", "sound of bubbling", "water boiling", "electronically arranged sounds", "groovy", "youthful", "energetic", "vibrant", "vivacious", "edm", "booming sounds", "synthesiser arrangements", "cymbal ride", "steady drumming", "hissing sound", "dissonant booming sounds", "punch digital drum beat"] | ["Music", "Spray", "Dubstep", "Electronic dance music"] | 7 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07qlf79", "/m/07s72n", "/m/08cyft"] |
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 );