musiccaps_details (view)

6 rows where musiccaps_aspects contains "passionate" and musiccaps_names contains "Music of Africa"

✎ 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
el grillo enamorado A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. 2008-09-05T17:39:10Z Piko el grillo enamorado con imagenes de grillos ["Music of Africa", "Music", "Ska"] ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] 1 2cxvYC9QZac 391
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
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
salsa cubana musica cubana inoel regeaton The low quality recording features a salsa song that consists of a passionate male vocal singing over shimmering chime bells, wooden percussion, shimmering shakers and groovy piano melody. It sounds passionate, emotional and addictive. 2008-08-02T01:08:58Z InoelQuiros New song by Inoel Quiros for the "Pura Salsa Na Ma" CD. Visit Inoel on MySpace @ www.myspace.com/inoelquiros. ["Music of Africa", "Music", "Salsa music"] ["low quality", "salsa", "groovy piano melody", "shimmering chime bells", "wooden percussion", "shimmering shakers", "passionate", "male vocal", "passionate", "emotional", "addictive"] 4 bTlp5Qr99RY 3628
Chab Khaled " Had el Aïne âliha jite " ( 1er festival Raï Oran 1985 ) A male Arab singer sings this cool melody. The tempo is medium with Arabic percussion instruments and various stringed instruments. The song is passionate and romantic. The song has bad audio quality. 2008-12-18T19:26:24Z Old Raï - Le Raï d'antan Old Raï ["Singing", "Music of Africa", "Music", "Middle Eastern music"] ["male singer", "arabic music", "arabic percussions", "medium tempo", "groovy music", "dance song", "belly dancing", "traditional music", "arabic superstar", "movie soundtrack", "bad audio quality", "stringed instruments", "romantic", "passionate", "arabic retro hits", "arabic pop hits", "spirited", "excitement", "love songs"] 1 qIxpfaeZ-zs 4775
Lee 'Scratch' Perry = Word Sound A male vocalist sings this spirited song. The tempo is fast with keyboard harmony, piano accompaniment,groovy bass lines, digital drum and synthesiser arrangement. The song is catchy, enjoyable, youthful, energetic and vivacious with recurring and insistent rhythm and a dance groove. This song is a Reggae song. 2010-06-12T15:29:53Z mrmsclvr From Lee Perry 'Smoking' - VPCD1358 - ["Music of Africa", "Music", "Reggae"] ["male singer", "fast tempo", "boomy bass lines", "vibrant", "enthusiastic", "energetic", "passionate", "piano accompaniment", "reggae", "folk", "jamaican folk", "catchy vocal riff", "keyboard harmony", "repetitive rhythm", "insistent", "synthesiser arrangements", "raspy vocals", "upbeat", "vibrant", "enthusiastic", "energetic", "minimal instruments", "electronic instruments", "digital drum"] 7 sgwvhvkNELc 4973

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;