musiccaps_details (view)
2 rows where musiccaps_aspects contains "exciting", musiccaps_aspects contains "youthful" and musiccaps_names contains "Music of Africa"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- exciting · 2 ✖
- youthful · 2 ✖
- afro beats 1
- captivating 1
- celebratory 1
- cheerful 1
- colourful 1
- dance groove 1
- dance hits 1
- dj 1
- energetic 1
- fast tempo 1
- festive 1
- gasping vocals sounds 1
- hand percussions 1
- happy 1
- infectious 1
- instrumental music 1
- keyboard accompaniment 1
- live session 1
- madly in love sexy 1
- male singer 1
- nigerian music 1
- party all night 1
- passionate 1
- romantic 1
- spirited drumming 1
- steady drumming rhythm 1
- synthesiser arrangements 1
- techno dance music 1
- thumping bas slime 1
- trance music 1
- triangle percussions 1
- vibrant 1
- vivacious 1
musiccaps_names (array) 6 ✖
- Music 2
- Music of Africa · 2 ✖
- Afrobeat 1
- Drum and bass 1
- Electronic dance music 1
- House music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Makossa & Megablast feat. Hubert Tubbs - Coming Home (Skwerl's Throbbing Jet Lag Mix) | The song is an instrumental. The tempo is medium with a strong bass line, steady drumming rhythm, triangle percussion, keyboard accompaniment and a male vocalist making guttural noises. The song is a modern techno pop dance tune. | 2014-04-24T20:48:17Z | Tajak | Artist: Makossa & Megablast feat. Hubert Tubbs (Skwerl remix) Single: Coming Home (2010) Label: G-Stone Recordings http://www.beatport.com/release/coming-home/285482 | ["Music of Africa", "Drum and bass", "House music", "Music", "Electronic dance music"] | ["techno dance music", "gasping vocals sounds", "trance music", "dance hits", "triangle percussions", "instrumental music", "dj", "live session", "thumping bas slime", "keyboard accompaniment", "youthful", "energetic", "exciting", "party all night", "dance groove", "madly in love sexy", "romantic", "passionate", "steady drumming rhythm"] | 1 | IMnh-TIyFuE | 1898 | |
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;