musiccaps_details (view)
4 rows where musiccaps_aspects contains "no other instruments", musiccaps_names contains "Acoustic guitar", musiccaps_names contains "Guitar" and musiccaps_names contains "Musical 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 |
---|---|---|---|---|---|---|---|---|---|---|
Yellow Ledbetter Tab How to Play Pearl Jam guitar Lesson - Eddie Vedder | This clip features a guitar chord being strummed in the beginning. This is followed by a male voice narrating a song. There are no other instruments in this song. There is no vocal melody in this clip. | 2009-12-18T08:33:21Z | GuitarJamz | click here to request your song http://www.guitarjamz.com/new_requests/ Great Lessons at http://www.guitarjamz.com/shop/ | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["electric guitar", "male voice", "narration", "no other instruments", "no vocal melody"] | 0 | 1o7iTDLNTFk | 312 | |
Man with no arms playing freebird on guitar | A handicapped musician plays the guitar with his feet and sings and jokes about. The song is medium tempo and retro pop with just a guitar strumming and no other instrumentation. The song is inspiring and relaxing. The song audio quality is very poor. | 2008-03-18T04:45:05Z | elfchild42 | Man with no arms playing freebird on guitar with his feet! This dude was cool. Freebird was played by request from the crowd. He said he hadn't played it in years. He rocks it out in Balboa Park in San Diego, CA on the weekends. Proof that the only handicaps people have are the ones they give to themselves. BTW his name is Mark Goffeney | ["Bass guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["emotional", "powerful", "strength", "never give", "inspiring", "motivational", "retro pop", "handicapped man", "guitar rhythm", "guitar strumming", "male singer", "man talking", "medium tempo", "crowds laughing", "ambient street noise", "no other instruments", "funny", "jovial", "cheerful", "positive", "song cover", "poor audio quality", "amateur tourist video", "look ma no hands"] | 1 | 33LJ36nAozM | 438 | |
5 Amazing Guitar Chords You Must Learn! - Creating Your Own Collection Of Favourite Chords | This guitar instruction audio features an acoustic guitar. This starts off with a male voice giving instructions on how to play the guitar. The bass note is played on the open string and the chord is strummed once. This is the Hendrix chord being played on the acoustic guitar. There are no other instruments in this song. There is no vocal melody in this song. This audio can be used in a guitar instruction video. | 2013-10-12T00:11:40Z | Nail Guitar Skills | https://nailguitar.com/ld2 ◄ Download a free PDF of the 5 amazing chords. https://nailguitar.com/tools/ ◄ You can also get a blank chord sheet to build your own list of favorite chords. Examples of these chords in songs: Cm11 - Cool #9 by Joe Satriani https://youtu.be/FlbUUKN4KR0?t=256 Em11 - Little Wing as covered by The Corrs https://www.youtube.com/watch?v=HhsacepElvA Em9 - Little Wing as covered by The Corrs https://www.youtube.com/watch?v=HhsacepElvA E7#9 - Loads of Hendrix songs Note he sometimes used a version of this chord lower down the neck. https://www.youtube.com/results?search_query=jimi+hendrix+live G13 - No references for this one sorry... I learnt it at uni while studying under great jazz guitarist, so check out some jazz :) Instagram - http://www.twitter.com/Andymuzic Facebook - http://www.facebook.com/NailGuitar Twitter - http://www.twitter.com/NailGuitar Check out my youtube channels: http://www.youtube.com/NailGuitar - Song Lessons http://www.youtube.com/NailGuitarSkills - Guitar Skills http://www.youtube.com/NailGuitarLicks - Lead Guitar Licks http://www.youtube.com/NailDrums - Drum Lessons http://www.youtube.com/NailPiano - Piano Lessons Details on guitar gear I use: http://www.nailguitar.com/links.html Cheers, Andy Looking for a complete step-by-step guitar learning system? Check out this awesome affordable guitar course http://beginnergtrcourse.nailguitar.com 5 Amazing Guitar Chords You Must Learn! - Creating Your Own Collection Of Favourite Chords | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["guitar instruction", "acoustic guitar", "male voice", "single strum", "7th chord", "no other instruments", "no vocal melody"] | 0 | 3OLeJZF4oI0 | 460 | |
The Girl From Ipanema - Solo Acoustic Guitar - Adam Rafferty | This fingerstyle guitar song features a guitar playing at a slow tempo. The bass notes are also played by the same guitar. The picking pattern involves a percussive style of guitar playing. There are no other instruments in this song. This is an instrumental song. There are no voices in this song. This song has a romantic feel. This song can be played in a luxury hotel lobby. | 2013-01-13T10:18:08Z | Adam Rafferty | ► Start learning my solo arrangements and get personal guitar coaching - FREE 14 day trial: http://studywithadam.com ► Get more cool FREE lessons here: http://adamrafferty.com/lessons Hey Gang! I've had so many requests for this song, it was time to arrange this gorgeous tune for solo guitar - "The Girl From Ipanema" by Antonio Carlos Jobim. My apologies for the painful "guitar faces" - I was digging VERY hard for a deep slow, sexy groove - that took internal work & concentration - big time! If you have never heard the famous version with Astrud Gilberto, João Gilberto and Stan Getz - go listen to it. It's one of my fave recordings of all time! I know it's not a traditional boss the way I play it, it's a NY Adam type groove - I still need to learn the real Brazilian way to groove! Love Adam ------- Follow me! ► Facebook: https://www.facebook.com/adamraffertyguitar ► Instagram: https://www.instagram.com/rafferty.adam/ ► Fingerstyle Guitar HANGOUT - iTunes Podcast: https://apple.co/2GVDWoR ► Twitter: https://twitter.com/adamrafferty ► NEW - Join the "Fingerstyle Guitar Hangout Community" on Facebook ► Post your videos, chat and hang out with me and other guitar players here: ► https://www.facebook.com/groups/fingerstyleguitarhangout ► NEW book "The Inner Game of Fingerstyle Guitar" available on Amazon ► https://www.adamrafferty.com/book/ =============== | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | ["acoustic guitar", "pop song", "fingerstyle guitar", "percussive strumming", "instrumental", "no voices", "no other instruments", "slow tempo"] | 0 | yw6uqQQF5Ig | 5447 |
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;