musiccaps
1 row where aspect_list contains "alternative rock" and aspect_list contains "powerful"
This data as json, CSV (advanced)
aspect_list (array) 17 ✖
- alternative rock · 1 ✖
- classic rock 1
- engaging 1
- fast tempo 1
- female vocalist 1
- groovy bass lines 1
- powerful · 1 ✖
- progressive rock 1
- rock 1
- slick drumming 1
- soft rock 1
- symphonic rock 1
- synthesiser articulation 1
- vibrant 1
- vibrant electric guitars 1
- vivacious 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
pp6eSGANq0Y | A female vocalist sings this spirited song. The tempo is fast with enthusiastic electric guitar harmony, slick drumming, groovy bass lines and synthesiser arrangements. The song is energetic, youthful, fun, pulsating, engaging and emphatic. This song is Alternative Rock. | ["female vocalist", "fast tempo", "vibrant electric guitars", "progressive rock", "symphonic rock", "alternative rock", "slick drumming", "synthesiser articulation", "vivacious", "youthful", "vibrant", "groovy bass lines", "engaging", "powerful", "rock", "classic rock", "soft rock"] | ["Singing", "Heavy metal", "Music", "Independent music", "Pop music", "Rock music", "Song", "Progressive rock"] | 7 | 80 | 90 | 1 | 1 | ["/m/015lz1", "/m/03lty", "/m/04rlf", "/m/05rwpb", "/m/064t9", "/m/06by7", "/m/074ft", "/m/0dl5d"] |
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 );