musiccaps_details (view)

5 rows where musiccaps_aspects contains "fingerstyle"

✎ 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
君が好きだと叫びたい Slam Dunk Acoustic guitar 灌籃高手 吉他 演奏 Someone is strumming an acoustic guitar while playing a fingerstyle melody and percussive sounds. This is an amateur recording. This song may be playing at a bonfire. 2007-12-25T19:34:44Z 吉他補給-左營店 高雄吉他教學 http://www.guitar.com.tw ["Guitar", "Music", "Musical instrument", "Slam", "Plucked string instrument"] ["amateur recording", "acoustic guitar", "fingerstyle", "uptempo"] 6 9mIDP_OT1uM 1040
Bell’s Harmonic This instrumental pop song features an acoustic guitar being played fingerstyle. The notes are being plucked. Guitar harmonics are played in between the plucked notes. This song is played at a moderate tempo. There is no percussion in this song. There are no other instruments in this song. The mood of this song is relaxing. This song can be played in a coffee shop. 2015-12-10T22:08:52Z Alan Gogoll Become a Supporter: https://www.youtube.com/channel/UC8NhGqX78q_bsuYtP-K9Oig/join Bell's Harmonic by Alan Gogoll 💿 Stream/Support → https://open.spotify.com/playlist/37i9dQZF1DZ06evO4C2uGb 🌅 Website → https://www.alangogoll.com Seahorse Bells is the fifth studio album from Australian Solo Acoustic Guitarist Alan Gogoll. Each of the five original compositions showcases Alan's original 'Bell Harmonics' technique and guitar tunings that have become his signature sound and featuring for the first time his signature Paul Mineur guitar. ["Guitar", "Acoustic guitar", "Music", "Strum", "Harmonic", "Plucked string instrument"] ["pop song", "acoustic guitar", "fingerstyle", "harmonics", "moderate tempo", "no percussion", "no other instruments", "no voices", "easy listening", "relaxing song"] 0 9xV0nmojVeg 1051
diane cluck - focus on their eyes Intentionally lo-fi bedroom recording of acoustic guitar strumming, knocking and fingerstyle playing. Finger snaps can also be heard. There is a slightly muffled room reverb over everything. Has an indie folk DIY aesthetic. 2010-05-20T23:30:43Z frinkianz focus on their eyes ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] ["diy", "solo guitar", "acoustic guitar strumming", "room reverb", "lo-fi", "knocking on guitar", "fingerstyle", "finger snapping", "bedroom recording", "indie", "slightly", "hazy muffled", "folk"] 8 BI8YQ3ueD24 1226
AC-33 Acoustic Chorus Guitar Amplifier featuring Alex Hutchings solo acoustic nylon string guitar playing in a fingerstyle Brazilian bossa nova style. 2010-02-25T05:59:50Z RolandChannel http://www.roland.com/products/en/AC-33/ Worlds First AA Battery-Powered Acoustic Guitar Amp! Rich, deep, stereo sound to go — introducing the AC-33, the worlds first AA battery-powered amp made specifically for acoustic guitar. Portable yet powerful, the AC-33 provides true stereo sound, Guitar and Mic/Line channels, custom-tailored effects, anti-feedback, and a Phrase Looper. But this amp was made to go places no amp has gone before. Thanks to its battery-power capability, the AC-33 lets you take your act anywhere — into the backwoods, onto the streets, or wherever your imagination leads you. ["Effects unit", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] ["solo guitar", "nylon string acoustic", "fingerstyle", "bossa nova", "brazilian"] 8 ZVvX2-ldhvY 3387
Flamenco guitar - Livio Gianola - Sicomoro Solo nylon string acoustic guitar played fingerstyle in a flamenco tradition. The guitar has lower bass notes than a regular 6 string guitar. 2010-02-17T13:39:12Z Veojam Livio Ganola plays his tarantas "Sicomoro" on eight strings flamenco guitar. Check https://www.veojam.com/spanish_flamenco for more flamenco guitar videos ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] ["solo guitar", "nylon string acoustic guitar", "fingerstyle", "flamenco", "low bass notes", "extended range guitar", "free time"] 8 n3EeS2mVU5w 4514

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;