musiccaps_details (view)

3 rows where musiccaps_aspects contains "medium tempo" and musiccaps_author = 3

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
GHANA GOSPEL MUSIC PROJECT 2008 AKWAABA JUNIOR LTJBM BAND Ayeyie oo! This is a live performance by an African music group in a gospel style. The drum pattern is intricate and there are other percussive elements like an occasional bongo and a wooden percussion instrument. The melodic elements are the vintage sounding electric piano as well as the vibrant and fun brass melody played on the trumpets. 2008-09-09T12:42:40Z livegospelbandghana SHILOH EVANGELICAL GOSPEL MUSIC ACADEMY presente to the world Afric's No. 1 juvenile live gospel band, playing three fusions. African gospel music revolution fusion, playing high life reggea jazz etc. contact: neelante@journalist.com, tel: (+233) 244 654 400 / 277 338 172 ["Gospel music", "Music", "Middle Eastern music"] ["african music", "gospel", "trumpets", "upbeat", "vibrant", "electric bass guitar", "bongo drums", "intricate drum pattern", "wooden percussion instrument", "electric keyboard", "mellow groove", "medium tempo"] 3 C0eCERYt4bA 1317
Hees Wadani This is a traditional middle eastern song from an older era. The recording quality suggests that this is a vintage song. There is a group of children singing the same melody in unison, and then there is a male with a soothing vocal. The song comes in at a medium tempo and is suitable for dancing. 2012-09-30T16:51:45Z MS QARANIMO HEES KOOXDA HEEGAN IYO MAXAMUUD CIISE TIMAJILIC AY IsLA QADAYAAN ["Music", "Middle Eastern music"] ["middle eastern music", "arabic music", "vintage middle eastern song", "traditional middle eastern instruments", "children vocal group singing", "soothing male vocal", "unison children's vocals", "medium tempo", "dance"] 3 nBiHncFD0dM 4525
Brighter Days Riddim Megamix - prod. by Silly Walks Discotheque This is a contemporary reggae song. The vocalist has a smooth and silky voice, the song sounds romantic and intimate. We hear electric guitar chord stabs on the off-beats which characterise the reggae pop style. There are also licks on the electric guitar and a simple drum beat suitable for laid-back dancing. The song has a tropical feel. 2013-11-15T16:41:16Z Silly Walks Discotheque Taken from the BRIGHTER DAYS RIDDIM prod. by Silly Walks Discotheque Composed by Silly Walks Discotheque & Jr Blender Programmed, arranged and mixed by Jr Blender Please support the music and buy it f.e. from I Tunes: http://bit.ly/177DTMq www.sillywalksdisco.com www.facebook.com/sillywalksdisco www.twitter.com/sillywalksdisco ["Afrobeat", "Music", "Reggae"] ["reggae pop", "smooth male r&b vocal", "medium tempo", "electric guitar licks", "electric guitar stabs", "smooth dance", "tropical"] 3 qlklggFvAZs 4816

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;