musiccaps
2 rows where aspect_list contains "alternative rock", aspect_list contains "energetic" and aspect_list contains "fast tempo"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
5xBfKiQcMZQ | A male vocalist sings this enthusiastic song. The tempo is fast with infectious drumming, groovy bass lines, funky electric guitar harmony and an energetic keyboard accompaniment with vocal backup. The song is energetic, high-spirited, youthful, infectious, pulsating and vigorous. This song is a popular Alternative Rock. | ["male vocalist", "fast tempo", "male vocal backup", "cymbals", "bass drum", "bright drumming", "funky keyboard harmony", "groovy electric guitar accompaniment", "funky bass line", "youthful", "spirited", "enthusiastic", "energetic", "lively", "vigorous", "rock", "hard rock", "alternative rock"] | ["Singing", "Music", "Ska"] | 7 | 100 | 110 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/m/06rqw"] | |
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 );