musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "fast tempo", aspect_list contains "female singer" and aspect_list contains "keyboard harmony"
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 |
---|---|---|---|---|---|---|---|---|---|---|
E16FgDFQI_w | A female vocalist sings this groovy pop song. The tempo is fast with accordion harmony, funky bass lines, punchy drumming and keyboard accompaniment. The song is youthful, infectious, catchy, bouncy, nifty and groovy with a dance rhythm. This song is Modern pop. | ["female singer", "fast tempo", "lively accordion", "synthesiser arpeggio", "bouncy", "infectious", "dance hits", "club music", "dance hits", "pop hits", "catchy riff", "simple melody", "energetic", "spirited", "groovy bass line", "punchy drumming", "keyboard harmony", "groovy melody", "buoyant", "youthful", "teen pop", "contemporary pop", "peppy", "youthful"] | ["Afrobeat", "Music of Asia", "Music", "Dance music"] | 7 | 30 | 40 | 0 | 1 | ["/m/0145m", "/m/028sqc", "/m/04rlf", "/m/0ggx5q"] | |
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 );