musiccaps
2 rows where aspect_list contains "cymbals", aspect_list contains "energetic", aspect_list contains "enthusiastic" and aspect_list contains "lively"
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"] | |
Aak-VLHtFPM | This music is a lively instrumental. The tempo is fast with an enthusiastic Brass and wind instrument harmony. The vigorous trumpets, trombone and tuba accompaniment, along with clanging cymbals and playful clarinet make for an upbeat, cheerful, happy, energetic and Perky Band Music. | ["instrumental", "fast tempo", "enthusiastic", "brass band", "cheerful", "happy", "bright", "fun", "engaging", "perky", "peppy", "bright", "energetic", "lively", "spirited", "cymbals", "clarinet", "trumpet", "tuba", "trombone", "wind instrument", "brass", "band", "engaging"] | ["Brass instrument", "Clarinet"] | 7 | 70 | 80 | 0 | 0 | ["/m/01kcd", "/m/01wy6"] |
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 );