musiccaps_details (view)

5 rows where musiccaps_aspects contains "djembe"

✎ 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
reggae.avi People are playing the same groove on a lot of percussive instruments. In the background you can hear shakers. Someone is strumming chords with an effect on an e-guitar and someone is playing fill-ins on acoustic drums. This song may be playing at a local live concert from a music school. 2010-09-10T18:11:18Z pchedy Primer contacto en la composicion de un reggae de la escuela de percusion de Santa Ursula bajo la direccion de Chedy Perera ["Music", "Rattle (instrument)", "Percussion"] ["amateur recording", "reggae", "shaker", "bongos", "djembe", "congas", "bongos", "acoustic drums", "e-guitar", "medium to uptempo"] 6 9Tl2l3bsLpE 1011
Stonewall - bagpipe medley - Scots Irish / Ulster Scots folk music - slotpb Someone is playing a big djembe along to a fast paced melody in a higher register played on a bagpipe. This song may be playing during a traditional holiday in Ireland. 2010-02-25T23:51:09Z Andrew Cornett Taken from the new album "Built in Belfast" by County Armagh folk group, Stonewall. Check out www.stonewallmusic.co.uk for more information. Arranged and performed by Richard Magowan of St Laurence O'Toole Pipe Band ["Bagpipes", "Wind instrument, woodwind instrument"] ["irish-folk", "djembe", "bagpipe", "uptempo", "traditional"] 6 I5CBPhpimtg 1872
king kong sound system - zagiyo (jgn gado-gado) To male voices are singing a melody. Someone is playing acoustic drums together with a djembe. A ukulele is being strummed on the offbeat along with a piano playing the same chords. This is an amateur recording. This song may be playing live at a small festival. 2011-09-20T04:58:55Z Rahseed269 live at babylon ["Keys jangling", "Music"] ["reggae", "piano", "djembe", "acoustic drums", "male voices singing", "ukulele", "medium to uptempo", "amateur recording"] 6 MdYXznF3Eac 2283
Tartan Terrors - Stump the Piper This song contains someone playing a rhythm on a djembe along with a frame drum. Someone is strumming chords on guitar while the bagpipes are taking the main melody. Then a male voice starts speaking and the crowd is cheering and clapping their hands. This song may be playing live at a traditional concert. 2006-10-20T03:14:46Z jayedeye Bagpipes with flair... from the Pennsylvania Rennaissance Faire 10-14-06. This is stump the bagpiper ["Harmonica", "Wind instrument, woodwind instrument"] ["traditional/folkmusic", "acoustic guitar", "djembe", "frame drum", "bagpipe", "male voice speaking", "crowd cheering and clapping", "medium to uptempo", "amateur recording"] 6 Q2Omtt4A8ls 2591
Cherokee Shuffle on mandolin Someone is playing an acoustic guitar along with someone playing a solo melody on top with another plucked string instrument. They are accompanied by someone playing a djembe or another percussive instrument. This song may be playing sitting around a bonfire. 2009-04-19T19:44:26Z Bill Macy Cherokee Shuffle on mandolin ["Acoustic guitar", "Music", "Mandolin", "Plucked string instrument"] ["rock/country", "acoustic guitar", "guitar-like instrument", "djembe", "medium to uptempo", "amateur recording"] 6 vgpV6F9tge8 5197

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;