musiccaps
1 row where aspect_list contains "emphatic vocals" and aspect_list contains "powerful voice"
This data as json, CSV (advanced)
aspect_list (array) 17 ✖
- alternative rock 1
- alto sax 1
- bass guitar 1
- emphatic vocals · 1 ✖
- energetic 1
- fast tempo 1
- female singer 1
- keyboard harmony 1
- perky 1
- powerful voice · 1 ✖
- punk pop 1
- saxophone 1
- spirited drumming 1
- tambourine 1
- tenor sax 1
- vocal backup 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
kkjNpwNcMWI | A female vocalist sings this spirited song. The tempo is fast with an animated keyboard harmony, groovy bass lines, electric guitar, tenor and alto saxophone accompaniment, enthusiastic drumming and tambourine beats with vocal backup. The song is energetic, upbeat, youthful, enthusiastic with emphatic vocals. This song is contemporary alternative rock. | ["female singer", "fast tempo", "saxophone", "bass guitar", "energetic", "perky", "youthful", "spirited drumming", "tambourine", "keyboard harmony", "vocal backup", "tenor sax", "alto sax", "powerful voice", "emphatic vocals", "alternative rock", "punk pop"] | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 7 | 190 | 200 | 0 | 0 | ["/m/026t6", "/m/02hnl", "/m/02k_mr", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] |
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 );