musiccaps
2 rows where aspect_list contains "happy", aspect_list contains "live performance" and aspect_list contains "rhythmic acoustic guitar"
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 |
---|---|---|---|---|---|---|---|---|---|---|
QHCHK-NPO_U | A group of male vocalists sing this charming melody in a foreign language. The tempo is fast with accordion lead music and acoustic guitar accompaniment. The song is lively, happy, light , warm, cheerful and charming . The audio quality is inferior as it seems to be an amateur home recording with ambient sounds. This Song is a Folk song. | ["male singers", "male harmony", "fast tempo", "rhythmic acoustic guitar", "acordian harmony", "lively", "loud", "folk music", "emotional", "passionate singing", "three part harmony", "live performance", "ambient sounds", "inferior audio quality", "cheerful", "upbeat", "happy", "foreign language"] | ["Traditional music", "Music", "Musical instrument", "Accordion"] | 7 | 150 | 160 | 0 | 0 | ["/m/02p0sh1", "/m/04rlf", "/m/04szw", "/m/0mkg"] | |
c5NGOcNyF4g | This music is a lively instrumental. The tempo is fast with an animated clarinet lead, lively spanish guitar rhythm, ukulele accompaniment and bright tambourine /pandeireta beats. The music is upbeat, buoyant, peppy, cheerful, happy, playful and fun Latin Clarinet Instrumental. | ["instrumental", "fast tempo", "spirited", "clarinet", "ukele", "cheerful", "light", "perky", "happy", "playful", "latin instrumental music", "live performance", "concert", "wind instrument", "spanish guitar", "cheerful", "upbeat", "latin pop", "lively tambourine beats", "rhythmic acoustic guitar"] | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument", "Music of Latin America"] | 7 | 70 | 80 | 0 | 0 | ["/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0g293"] |
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 );