musiccaps
1 row where aspect_list contains "emphatic" and aspect_list contains "funky electric guitar feedback"
This data as json, CSV (advanced)
aspect_list (array) 22 ✖
- animated vocal backup 1
- compelling 1
- emphatic · 1 ✖
- emphatic drumming 1
- energetic 1
- fast tempo 1
- funky electri guitar feedback 1
- funky electric guitar feedback · 1 ✖
- goth 1
- goth rock 1
- groovy bass lines 1
- hard metal 1
- hard rock 1
- high pitched singing 1
- intense 1
- male singer 1
- metal 1
- passionate 1
- progressive 1
- psychedelic 1
- punk rock 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
JrOV2Xz2djA | A male vocalist sings this energetic rock song. The song is fast tempo with emphatic drumming, groovy bass lines, funky electric guitar feedback and keyboard accompaniment, with animated, high pitched backup. The song is youthful, energetic,spirited, intense, psychedelic and passionate. This song is Hard Rock. | ["male singer", "fast tempo", "youthful", "progressive", "compelling", "passionate", "funky electric guitar feedback", "emphatic drumming", "groovy bass lines", "animated vocal backup", "high pitched singing", "funky electri guitar feedback", "youthful", "progressive", "hard rock", "metal", "hard metal", "goth rock", "punk rock", "energetic", "emphatic", "intense", "goth", "psychedelic"] | ["Heavy metal", "Music", "Rock music", "Drum machine", "Progressive rock", "Grunge"] | 7 | 90 | 100 | 0 | 1 | ["/m/03lty", "/m/04rlf", "/m/06by7", "/m/0cfdd", "/m/0dl5d", "/m/0dls3"] |
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 );