musiccaps
2 rows where aspect_list contains "cheerful", aspect_list contains "nigerian music" and aspect_list contains "youthful"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Xaq-segSEsQ | A male vocalist sings this energetic Nigerian song. The tempo is fast and upbeat with keyboard harmony and Afro beats of conga, clave, drums and akuba. The music is upbeat, catchy, spirited, energetic, youthful and pulsating with a dance groove. This song is a Reggae song. | ["male singer", "fast tempo", "nigerian music", "world music", "propulsive percussion", "upstroke rhythm guitar", "dominant music", "pleasant", "catchy", "youthful", "dance groove", "happy", "cheerful", "carefree", "conga", "clave", "akuba", "bright drumming", "reggae", "ugandan song", "foreign language", "afro beats", "reggae", "inspirational", "reflective"] | ["Afrobeat", "Music of Africa", "Music", "Dance music"] | 7 | 160 | 170 | 0 | 0 | ["/m/0145m", "/m/0164x2", "/m/04rlf", "/m/0ggx5q"] | |
dKJk3JavNzo | A male vocalist sings this lively African song. The tempo is fast with synthesiser arrangements, bright drumming and African percussive instruments. This song is a happy, cheerful, colourful, infectious ,captivating Nigerian Music. | ["male singer", "fast tempo", "synthesiser arrangements", "captivating", "vibrant", "spirited drumming", "vivacious", "exciting", "infectious", "hand percussions", "celebratory", "happy", "festive", "cheerful", "nigerian music", "afro beats", "youthful", "colourful", "spirited drumming"] | ["Afrobeat", "Music of Africa", "Music"] | 7 | 30 | 40 | 0 | 0 | ["/m/0145m", "/m/0164x2", "/m/04rlf"] |
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 );