musiccaps_details (view)

4 rows where musiccaps_aspects contains "percussion" and musiccaps_names contains "Blues"

✎ 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
Afro Cuban Rumba music and dance -- havana, cuba This is an amateur recording of an Afro-cuban dance music performance. There are male vocals singing joyfully. There is a percussion orchestra made up of diverse elements such as the conga, the bongo and the timbales are playing in the rhythmic background. The atmosphere is lively and vibrant. Although the audio quality is not that great, this piece can still be sampled for use in beat-making. 2009-03-26T00:28:54Z mathmuse live at the palenque -- vedado, havana, cuba ["Blues", "Traditional music", "Music", "Speech", "Dance music"] ["afro cuban dance", "amateur recording", "street performance", "male vocals", "percussion", "conga", "bongo", "timbale", "lively", "vibrant"] 9 07mS0mSTDjY 124
Adabu Steven - "NANAI" [Official Music Video] This is a modern sounding Afrobeat music piece. There is a male vocal singing the same line repeatedly vocal with a male back vocal ad-libbing in the background. The electric guitar is playing a mellow tune. A low-to-medium range bass line that can be heard. The rhythm consists of an acoustic drum beat with supporting percussive elements. Brass stabs can be heard every now and then. The atmosphere is groovy. This piece could be played at African nightclubs or dance clubs. 2016-05-28T06:28:06Z Adabu Steven Adabu Steven - "Nanai" (Official Music Video) Music video by ADABU STEVEN performing NANAI Prod: by Njenga Giggz (xtrim record) Dir: by Dangfilms Adabu steven (c) 2016 ADABU THE BEST ENT . https://www.instagram.com/adabusteven/ https://www.facebook.com/Adabu-Steven-276248899191596/?ref=settings https://mobile.twitter.com/adabusteven #adabumusic #houston ["Blues", "Music", "Dance music"] ["afrobeat", "modern sound", "male vocal", "repeated theme", "electric guitar", "bass guitar", "acoustic drums", "percussion", "brass stab", "energetic", "groovy", "danceable"] 9 Ade0UZnb6dw 1147
Abeokuta Afrobeat na Ressaca do Bloco Uououou - Zombie This is the live performance of an afrobeat music piece. There is a male voice singing occasionally. The melody is being played by a wide variety of instruments such as the electric guitar, the keyboard and the bass guitar. There is a saxophone playing a solo. In the rhythmic background, there is an acoustic drum beat in the style of afrobeat. It is joined by percussive elements. There is a vibrant atmosphere in this recording. This piece could be playing in the background of a West African cuisine restaurant. 2014-03-12T03:57:41Z Jedson Nobre Abeokuta Afrobeat em apresentação na Ressaca do Bloco Uououou no Xinxim da Baiana, Olinda Interpretando Zombie, música de Fela Kuti. ["Blues", "Music"] ["afrobeat", "live performance", "male voice", "electric guitar", "bass guitar", "keyboard", "saxophone", "acoustic drums", "percussion", "vibrant", "colorful", "playful"] 9 Al_OdIuqoe0 1167
Lap Steel Lessons - Blues Licks Vol. 1 with Dave Anderson www.OnlineLessonVideos.com This song features a solo played on a pedal steel guitar. This is a country blues melody. This involves slides on the guitar. This is accompanied by percussion playing a simple beat in common time. The bass plays 12 bar blues style bassline. An organ outlines chords in the background. This is an instrumental song. There are no voices. This song can be played in a bar. 2010-01-29T00:33:04Z OnlineLessonVideos www.OnlineLessonVideos.com - Check it out for Full Lesson + TAB + Mp3 Backing Tracks! ["Blues", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] ["pedal steel guitar solo", "slide guitar", "country song", "percussion", "bass", "organ", "no voices", "instrumental", "moderate tempo", "blues mood"] 0 W4nQpOHIPEw 3061

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;