musiccaps
2 rows where aspect_list contains "emotional", aspect_list contains "female singers", aspect_list contains "groovy" and aspect_list contains "steady drumming rhythm"
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 |
---|---|---|---|---|---|---|---|---|---|---|
1xhwyUVSRQk | A female singer sings this cool pop melody with backup singers in vocal harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, and keyboard accompaniment . The song is exciting and youthful. The audio quality with a lot of ambient crowd noises. | ["k-pop", "j-pop", "female singers", "female backup singers", "pop love hits", "pop dance hits", "whistling tones", "live performance", "vocal harmony", "groovy bass line", "steady drumming rhythm", "keyboard harmony", "emotional", "exciting", "enthusiastic", "passionate", "party song", "dance hit", "pop hits", "pop divas", "party all night", "people cheering", "groovy"] | ["Music of Asia", "Music"] | 1 | 170 | 180 | 0 | 0 | ["/m/028sqc", "/m/04rlf"] | |
Ekoh6TJpA88 | Female singers sing this Christmas carol in vocal harmony. The song is medium tempo with bells percussions, keyboard accompaniment, steady drumming rhythm and a percussive bass line. The song is a Christmas carol that doubles as a lullaby. The song is cheerful and festive. | ["female singers", "bells harmony", "medium tempo", "emotional", "winter wonderland", "christmas carols", "lullaby", "babies sleeping", "exciting", "festive cheer", "steady drumming rhythm", "percussive bass line", "groovy", "calming", "relaxing", "holidays", "holiday fun", "children dancing", "snow", "christmas presents", "e emotional", "cheerful", "happiness", "dancing", "santa claus", "backup singers", "vocal harmony"] | ["Christmas music", "Singing", "Music", "Song", "Choir"] | 1 | 60 | 70 | 0 | 0 | ["/m/0140xf", "/m/015lz1", "/m/04rlf", "/m/074ft", "/m/0l14jd"] |
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 );