musiccaps_details (view)

1 row where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "repeating theme" and "youtube_published" is on date 2006-09-07

✎ 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
Flamenco guitar lesson - Triplet rasgueado This is an instructive flamenco guitar piece. The player is depicting how the piece must be played by starting it slow and eventually getting faster. The theme is repeated by the player. 2006-09-07T16:33:45Z Sal Bonavita Flamenco guitar lesson - Triplet rasgueado This triplet (abanico) style rasgueado is one the most effective but easiest to learn. This video shows the triplet rasgueado at various speeds - Very slow (practice speed) to very fast (playing speed). it also shows a continuous rasgueado gradually building up speed and then slowing down to very slow again. Visit my website and for a more detailed description on how to play triplet rasgueado - using just the thumb (P) and middle finger (m) http://nylonguitarist.com/triplet_rasgueado_p_m_p.html Don't forget to leave something in the tip jar. ______________________________ ..// Show your SUPPORT HERE http://nylonguitarist.com/donate.html Everything I have to share is FREE for everybody. My inner voice tells me not to do the Patreon thing or start a membership. If you want something... just ask. But I will not refuse a donation if you can afford it. Enjoy your stay. ...// //WATCH NEXT: Annie's song - https://youtu.be/Y34oRHDt4_M Feelings - https://youtu.be/eE_suKEwJn4 Yesterday - https://youtu.be/rRmZgVMlskU Classical Gas - https://youtu.be/zOzVNC14b8Y The Godfather - flamenco stylehttps://youtu.be/ZsQYYiWT6Ms Take Five - https://youtu.be/4qRhbGJB6gQ La Playa - https://youtu.be/ejBnFm1msPk //KEYWORD RESEARCH TOOL (Tubebuddy) https://www.tubebuddy.com/hersoveela //CAMERA AND AUDIO GEAR I USE: - My video camera - https://amzn.to/3ptTVfD - My audio recorder - https://amzn.to/3ov876O - My microphone - https://amzn.to/2YspSsQ DISCLAIMER: Links in this description may be affiliate links. If you buy a product from these links I may receive a small commission. There is no extra charge to you. Thank you for supporting my channel. ["Flamenco", "Acoustic guitar", "Music", "Strum", "Plucked string instrument"] ["flamenco", "acoustic guitar", "instrumental", "exercise", "rising", "repeating theme", "spanish"] 9 r43WrKA6ppI 4846

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;