musiccaps
1 row where aspect_list contains "cymbal crashes" and aspect_list contains "virtuoso guitar lead"
This data as json, CSV (advanced)
aspect_list (array) 24 ✖
- arcade game soundtrack 1
- building tension 1
- cymbal crashes · 1 ✖
- dangerous journey 1
- distortion guitar playing lead 1
- dragon quest 1
- drum rolls 1
- energetic 1
- game play 1
- groovy music 1
- instrumental music 1
- intense battle 1
- medium fast tempo 1
- metal music 1
- passionate 1
- percussive bass line 1
- poor audio quality 1
- retro game tracks 1
- spirited 1
- suoerfats drumming rhythm 1
- valour and pride 1
- video games 1
- virtuoso guitar lead · 1 ✖
- warriors fight 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
nT_R3O0OK6U | The song is an instrumental. The tempo is medium fast with a percussive bass line, super fast metal drumming with cymbal crashes and fast drum rolls and a distorted guitar playing a virtuoso lead. The song is energetic and animated. The song has poor audio quality. | ["instrumental music", "metal music", "poor audio quality", "energetic", "passionate", "building tension", "warriors fight", "dragon quest", "dangerous journey", "valour and pride", "groovy music", "intense battle", "medium fast tempo", "arcade game soundtrack", "suoerfats drumming rhythm", "distortion guitar playing lead", "percussive bass line", "virtuoso guitar lead", "spirited", "cymbal crashes", "drum rolls", "game play", "video games", "retro game tracks"] | ["Heavy metal", "Music", "Cacophony"] | 1 | 190 | 200 | 0 | 1 | ["/m/03lty", "/m/04rlf", "/m/07szfh9"] |
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 );