musiccaps_details (view)
6 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_names contains "Flamenco", musiccaps_names contains "Guitar" and musiccaps_names contains "Plucked string instrument"
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 METHOD by atrafana | This is a compilation of various flamenco recordings. The acoustic guitar is being played at first with the picado technique and then with the free stroke technique. There is a percussive backing track in each part. The music has an exotic feel to it. These separate parts could be used as an advertisement jingle or they could be sampled for use in beat-making. | 2015-06-02T13:05:38Z | atrafanaSchool | Get the Flamenco Guitar Method: https://gumroad.com/l/DFrI ---------------------------------------------------------------- FLAMENCO GUITAR METHOD contents: The method addresses beginner and intermediate players. Instructional videos are accompanied by both interactive and PDF sheet music in both standard notation and tablature. 46 videos in total with associated tabs Contents Overview: How to Develop Picado Speed The Comprehensive Picado Package Free Stroke Fundamentals Pulgar Training Package Alzapua Training Package Arpeggio Package Tremolo Training Package Legato Mastery Package Compas Strumming Developing Rasgueado Detailed Contents: FLAMENCO 01 The Comprehensive Picado Package (4 videos) Video: How to Develop Picado Speed 10 Picado Agility Exercises- video + tabs (tef, pdf) Daily Picado Routine - video + tabs (tef, pdf) Picado Speed Drill - Sextuplets - video + tabs (tef, pdf) Free Stroke Fundamentals (3 videos) Video: Free Stroke Fundamentals; free stroke action, producing good tone, combining free stroke with the rest stroke thumb Basic Free Stroke Exercise 01 - video + tabs (tef, pdf) Basic Free Stroke Exercise 02 - video + tabs (tef, pdf) Pulgar Training Package (7 videos) Basic Flamenco Pulgar Instructional video pulgar buleria 01 - video + tabs (tef, pdf) pulgar buleria 02 - video + tabs (tef, pdf) pulgar solea 01 - video + tabs (tef, pdf) pulgar solea 02 - video + tabs (tef, pdf) pulgar tangos 01 - video + tabs (tef, pdf) pulgar tangos 02 - video + tabs (tef, pdf) FLAMENCO 02 Alzapua Training Package (6 videos) Video: Alzapua Basics Alzapua Exercise - 1 - Malaguena - video + tabs (tef, pdf) Alzapua Exercise - 11 - Fandangos de Huelva - video + tabs (tef, pdf) Alzapua Exercise - 12 - Solea - video + tabs (tef, pdf) Alzapua Exercise - 13 - Solea por Buleria - video + tabs (tef, pdf) Alzapua Exercise - 00 - Buleria - video + tabs (tef, pdf) Arpeggio Package (5 videos) Arpeggio Exercise - 1 - El Vito - video + tabs (tef, pdf) Arpeggio Exercise - 3 - Malaguena - video + tabs (tef, … | ["Flamenco", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["flamenco", "acoustic guitar", "picado", "free stroke", "instrumental", "compilation", "percussion", "exotic", "sensual"] | 9 | EptdhC17avY | 1593 | |
| Faraon - Flamenco Rumba_20/11/2011@Barceloan | This is a recording of two flamenco guitarists playing a captivating latin american rhythm. It's upbeat and suitable for dancing. The one guitarist strums chords in the percussive flamenco style, while the other guitarist plays flamenco lead with arpeggios and licks. The performance is live and outside. There is reverb applied to the lead guitar. Both are playing on nylon strings. | 2011-11-24T17:50:51Z | Julian Kan | Spanish Guitar - Adrian Roman & Martin Sazandeh's performance at Cathedral, Gothic Quarter, Barcelona | ["Folk music", "Flamenco", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["live performance", "flamenco guitarists", "acoustic guitar", "nylon string guitar", "latin american music", "upbeat", "energetic", "dance", "reverb"] | 3 | KChjW89XOF0 | 2064 | |
| Flamenco Guitar Farruca | This is a flamenco music piece. The only instrument being played is an acoustic guitar. The acoustic guitar is playing exotic tunes. There is a sensual atmosphere. This piece could be used in the soundtrack of a romance movie, especially during the more intimate scenes. | 2010-11-24T21:03:32Z | Mundo Flamenco | Amir John Haddad played this "Farruca" in october 2010, during a recording session for the Website of Mundo Flamenco. He plays a Andrés Daniel Marvi rosewood/spruce guitar from 2010. | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "Music of Latin America"] | ["flamenco", "no singer", "instrumental", "single instrument", "acoustic guitar", "exotic", "sensual", "romantic"] | 9 | S2yXmXUJ5xU | 2736 | |
| How to Play the Guitar Tremolo Classical & Flamenco Style | An acoustic guitar being played walking down the fretboard using a tremolo finger picking technique. This song may be playing at home practicing guitar. This is an amateur recording. | 2012-11-02T22:27:52Z | Play & Sing With Alexandros | Hey guys! :} Well here ~it~ is! :D The Video that hundreds of you have requested from me. ;) Tremolo Guitar and how to Practice, Play ~it~ AND Develop ~it~ with some extra Exercises to further develop your Technique! Stay 'tuned' for MORE & MORE Guitar Videos by Subscribing to my Channel: http://www.youtube.com/giveorlooseit Thank you for watching my Guitar Friend! See ~you~ on the next Video! God Bless~ ----------------------------------------------------------------- If you like to help & Support me Please consider Donating ANY amount to Paypal here: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=YHKP93QNB87LN&source=url ~~Thank YOU MY GUITAR FRIEND~~ * PS: Want to learn this AND many more Picking Styles & Sing HUNDREDS of Songs??? Have NO fear! My E-Book is here: 25 Fingerstyle Techniques & Over 10 Styles of Music + 50 MP3's: http://store.payloadz.com/go?id=766057 (Paypal SAFE & 40% OFF!!) * Life is Music & Music is Life.. Without Music there can be no Life! God Bless~ * #GiveOrLooseIt #Guitar_Tremolo_Lesson #Classical_Guitar_Techniques | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["acoustic guitar", "tremolo", "amateur recording", "uptempo"] | 6 | X_nfMNpw9SA | 3197 | |
| Paco de Lucia plays an Erez Perelman Flamenco Guitar Part 1 | This is an instrument review jam that is played in the style of flamenco music. There is an acoustic guitar being played while a male voice gives his opinion concerning the instrument. The character of the sound is sensual. The guitar sounds can be sampled for use in beat-making. | 2011-11-22T11:13:27Z | Erez Perelman | Order Your Handmade Classical or Flamenco Guitar Here: http://erez-perelman.com/contact/ Paco de Lucias playing Erez Perelman flamenco guitar. | ["Bass guitar", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["jam", "flamenco", "acoustic guitar", "male voice", "review", "exotic", "sensual"] | 9 | axqtExFY5-s | 3590 | |
| Fred Stitz Plays Dobro Lap Steel part .1 open D tuning | This is an intricate country guitar performance. The guitarist plays slide guitar. The playing is complex. There is a tambourine as a percussive element on every beat. It's a live recording. | 2012-05-06T12:03:29Z | James Quinn | Fred came over to Dublin for 1 nite Razorlight gig got pulled so we hung out did a busk and made 2V ids Fred playing Dorbo lapsteel with bottle slide in open D Tuning enjoy filmed by Wascana | ["Flamenco", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["country", "country guitar", "acoustic guitar", "slide guitar", "acoustic guitar arpeggio", "tambourine", "live recording", "intricate guitar playing"] | 3 | rfa-iUp5UQc | 4892 |
Advanced export
JSON shape: default, array, newline-delimited
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;