musiccaps_details (view)
4 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "male singer" and musiccaps_names contains "Afrobeat"
This data as json, CSV (advanced)
musiccaps_aspects (array) 67 ✖
- cheerful · 4 ✖
- male singer · 4 ✖
- afro beats 2
- exciting 2
- fast tempo 2
- guitar rhythm 2
- happy 2
- keyboard accompaniment 2
- nigerian music 2
- youthful 2
- akuba 1
- animated vocals 1
- backup singer 1
- bad audio quality 1
- bright drumming 1
- captivating 1
- carefree 1
- catchy 1
- celebratory 1
- clave 1
- colourful 1
- conga 1
- dance all night long 1
- dance club 1
- dance floor 1
- dance groove 1
- dominant music 1
- energetic 1
- entertaining 1
- festive 1
- foreign language 1
- groovy rhythm 1
- hand percussions 1
- horns playing 1
- infectious 1
- inspirational 1
- latin dance groove 1
- latin dance hits 1
- latin dance music 1
- latin percussions 1
- latin pop star 1
- latin singer 1
- medium fast tempo 1
- medium tempo 1
- organ accompaniment 1
- party time 1
- passionate 1
- people dancing 1
- pleasant 1
- pop song 1
- positive 1
- propulsive percussion 1
- reflective 1
- reggae 1
- romantic 1
- spirited drumming 1
- steady bass line 1
- story telling 1
- strong bass line 1
- synthesiser arrangements 1
- ugandan song 1
- upstroke rhythm guitar 1
- vibrant 1
- video sound track 1
- vivacious 1
- vocal harmony 1
- world music 1
musiccaps_names (array) 4 ✖
- Afrobeat · 4 ✖
- Music 4
- Music of Africa 4
- Dance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
พ่อพันธุ์วัวไทยพื้นเมือง | A male singer sings this cool and animated melody with backup singers in vocal harmony. The song is medium tempo with steady drumming rhythm, groovy bass line, organ accompaniment and horns playing. The song is entertaining and cheerful. The audio quality is bad. | 2012-07-22T11:31:33Z | thanandorn limlek | ขออนุญาตเจ้าของวัวครับ | ["Afrobeat", "Music of Africa", "Music"] | ["male singer", "backup singer", "vocal harmony", "cheerful", "positive", "animated vocals", "video sound track", "guitar rhythm", "horns playing", "organ accompaniment", "steady bass line", "groovy rhythm", "energetic", "entertaining", "bad audio quality", "pop song", "medium tempo", "keyboard accompaniment"] | 1 | Ipow026xzVw | 1945 | |
15. 1MILLION SOUNDS - JUNIO 2016 (BRUNO TORRES) | A male singer sings this exciting melody. The song is medium fast tempo with a groovy bass line, latin percussion, steady drum rhythm, groovy bass line and keyboard accompaniment. The song is exciting and fun. The song is a modern Latin pop dance hit. | 2016-06-02T12:05:11Z | TemazosMusic TV | Temazos Music 2.0: https://www.youtube.com/channel/UCjCqUvKSd1A8aUnhZekclvA Descargar: http://www92.zippyshare.com/v/pdlnpgp4/file.html FACEBOOK: https://www.facebook.com/TemazosMusicTV TWITTERS: https://twitter.com/TemazosMusicYT https://twitter.com/puchidj | ["Afrobeat", "Music of Africa", "Music"] | ["male singer", "latin singer", "latin pop star", "latin percussions", "story telling", "medium fast tempo", "latin dance music", "latin dance groove", "strong bass line", "guitar rhythm", "people dancing", "dance club", "dance floor", "passionate", "cheerful", "exciting", "romantic", "dance all night long", "party time", "latin dance hits", "keyboard accompaniment"] | 1 | L1s-oPHsOac | 2144 | |
Sitya Loss Remix - Eddy Kenzo | 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. | 2014-02-20T13:25:19Z | Eddy Kenzo | big talent young managment | ["Afrobeat", "Music of Africa", "Music", "Dance music"] | ["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"] | 7 | Xaq-segSEsQ | 3200 | |
Sona - Ijo Sona Official Video | 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. | 2014-06-06T18:01:55Z | sona man | Download HERE: http://bit.ly/ijosonamp3 With the music video for his latest single "No Wahala" garnering nearly 100,000 views on Youtube, and receiving massive support from the likes of BBC 1Xtra and Bang Radio, fast-rising British Nigerian artist SONA is without a doubt one of the stand-out UK-based Afrobeats artists of 2014 so far. His brand new single "Ijo Sona" has already been streamed over 100,000 times on SoundCloud and now, the London-based rising star is proud to debut the exciting and infectious new music video for "Ijo Sona", directed by Alexx Adjei, for our viewing pleasure. The refreshing visuals capture Sona in his performance element, as the life of an 'Owambe' party right in the heart of London. | ["Afrobeat", "Music of Africa", "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"] | 7 | dKJk3JavNzo | 3775 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;