musiccaps_details (view)
8 rows where search matches "guitar", musiccaps_aspects contains "amateur recording", musiccaps_names contains "Acoustic guitar" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- amateur recording · 8 ✖
- acoustic guitar 4
- medium tempo 4
- uptempo 3
- e-guitar 2
- abrupt end 1
- acoustic drums 1
- acoustic guitars 1
- amateur 1
- amplified guitar 1
- blues 1
- boomy 1
- chord progression 1
- chords 1
- classical 1
- comedic 1
- country 1
- crowd laughing 1
- digital soundeffects 1
- e-bass 1
- ecstatic 1
- electric guitar 1
- fast tempo 1
- fingerstile acoustic guitar 1
- folk rock 1
- higher register singing 1
- home video 1
- instrumental 1
- loud 1
- loud feedback 1
- male voice 1
- male voice talkin 1
- melancholy 1
- melodic 1
- of static 1
- people talking 1
- sharp 1
- singer-songwriter 1
- soft stomping noise 1
- sonic power 1
- static 1
- string instrument 1
- tremolo 1
- uplifting vibe 1
- uprightbass 1
- vibrations 1
musiccaps_names (array) 17 ✖
- Acoustic guitar · 8 ✖
- Music 8
- Musical instrument · 8 ✖
- Plucked string instrument 8
- Guitar 7
- Strum 4
- Bluegrass 2
- Blues 2
- Steel guitar, slide guitar 2
- Chorus effect 1
- Country 1
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Flamenco 1
- Mandolin 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
W. A. Mozart - Rondo alla Turca (Turkish March), solo classical guitar | This audio contains someone playing a classical melody on an acoustic guitar using fingerstyle. This audio is full of reverb. This song may be playing at a talent show. | 2012-02-14T18:40:10Z | Los Angeles Guitar Academy | In Mozart's time, the Ottoman Empire still ruled Turkey (Anatolia). Their military bands, called Janissary bands, were quite popular, even in Europe. Mozart borrowed from their sound and rhythm to produce this work, which became one of the big hits of Mozart's day. Its popularity has rarely waned since then. The final movement of the sonata, Rondo Alla Turca, captures the military bands' brassy sound. In its whirling feel, it can evoke another aspect of Turkish culture which has captivated Westerners--the whirling motion of the Sufi dervishes as they perform their ancient ritual of peace and wholeness, though the Rondo whirls at light speed, in contrast to the gentle movement of the Mevlevi. Arranged and performed by Emre Sabuncuoglu. Copyright © 2012 Los Angeles Guitar Academy Publishing. All rights reserved. 𝄞 Purchase sheet music and tabs: https://onlineguitaracademy.net/classical-guitar-sheet-music 🔔 Subscribe for more great pieces and tutorials: https://www.youtube.com/user/LAGuitarAcademy?sub_confirmation=1 🐢 Slow walkthrough videos available on our online lesson program: https://onlineguitaracademy.net/online-classical-guitar-lessons 🍀 Free trial for online programs: https://onlineguitaracademy.net/register/laga-free-trial https://onlineguitaracademy.net/pricing-comparison ❤️ Love our work? Join our Patreon community and access dozens of patron-only posts and exclusive releases: https://www.patreon.com/LAGuitarAcademy ❤️ Or join our channel: https://www.youtube.com/channel/UC3eQeaR786C8HCGFMqtCUSw/join Recommended videos: ✔️ Complete list of our Mozart arrangements: https://www.youtube.com/playlist?list=PL18tTu-0TnfqPbL8O1OFBXEWx5j1QAdkj ✔️ Spring (the Four Seasons) for solo guitar: https://www.youtube.com/watch?v=fENuHRAPEmA ✔️ Maple Leaf Rag by Scott Joplin on solo guitar: https://www.youtube.com/watch?v=xRjXafdabzc ✔️ Eine kleine Nachtmusik for solo guitar: https://www.youtube.com/watch?v=_fxyXLZ65gw | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["amateur recording", "classical", "fingerstile acoustic guitar", "fast tempo"] | 6 | 26HLgXWF-Co | 332 | |
Kong Solo Guitar Blues Rock | This audio contains someone playing a distorted e-guitar solo in a higher register along with acoustic drums with cymbal hits and a half open hit. An e-bass is underlining the rhythm. There are digital comedic noises and laughter that seem not to be part of the musical composition. This song may be playing in a comedic tv-show. | 2012-02-13T13:30:54Z | nut3128 | ["Blues", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "comedic", "crowd laughing", "digital soundeffects", "e-guitar", "acoustic drums", "e-bass", "medium tempo", "ecstatic"] | 6 | 3jLef5eHgzU | 494 | ||
Cours de guitare The sound of silence | Someone is playing acoustic guitar. While a higher pitched male voice is singing a sad song. This is an amateur recording. This song may be playing at home on a rainy day. | 2011-08-06T09:41:42Z | bluesbosse1 | ..des tablatures pour débutants au : www.partition-guitare-tablature.com | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["singer-songwriter", "acoustic guitar", "male voice", "higher register singing", "soft stomping noise", "melancholy", "amateur recording", "medium tempo"] | 6 | DroAzooK4yw | 1514 | |
Beginners, VERY EASY Country Lead Guitar Lesson With Scott Grove | This recording contains a male voice talking and then playing a blues riff on a clean e-guitar. This song may be playing as part of a video tutorial. | 2013-05-03T11:45:35Z | Groovy Music Lessons | Donations Via Paypal: mrmrswoodworker@aol.com Merchandise: https://www.doctorgroovymerch.com/ http://www.groovymusiclessons.com You can purchase the 200 plus hours of lessons for only $25. The deal of the century! NONE of my YouTube videos are in these 200 hours. Merchandise: https://www.doctorgroovymerch.com/ Donations Via Paypal: mrmrswoodworker@aol.com | ["Country", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument", "Bluegrass"] | ["blues", "amateur recording", "male voice talkin", "e-guitar", "medium tempo"] | 6 | JDWPJ1AiDKc | 1981 | |
Careless Love Guitar Improvisation - Pentatonic Scale - Harmonic Minor - Major Scale Usage | One acoustic guitar is strumming chords while the other one is playing a solo melody on top with bending notes in a pentatonic scale. This song may be playing at home practicing guitar. | 2012-03-03T19:14:55Z | YourGuitarSage | This video is a guitar improvisation jam using the classic swing tune, "Careless Love". If you want the form for the pentatonic scale, go to http://www.yourguitarsage.com and get the free Ultimate Guitar Guide. If you like free guitar lessons, your mom will be so proud of you for subscribing to my channel. That is if Free and Guitar are things you like... Your $1 UGS membership trial is right here: http://www.yourguitarsage.com/1-dollar Feel free to ask me guitar questions on Twitter at: http://www.twitter.com/yourguitarsage and Facebook at http://www.facebook.com/yourguitarsage Now go swing that guit fiddle! :) e | ["Blues", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["folk rock", "acoustic guitars", "amateur recording", "uptempo", "uplifting vibe"] | 6 | RSryuuvUfDM | 2703 | |
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 | |
Danelectro FAB Chorus D 5 | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | 2010-11-01T07:01:01Z | musicnbooksdotcom | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | 7 | bqvl7IbPteU | 3659 | ||
Will the Circle Be Unbroken - Guitar Lesson- Hot Bluegrass Lead | This audio contains someone playing an acoustic guitar fingerstyle. An upright bass is playing a line in the background. This song may be playing guitar to someone. | 2014-07-22T00:35:03Z | Music With Ryan | This lesson comes with over 30 minutes of video, PDF tabs and four audio backing tracks! Become a Premiere member to access this full-length video and ALL of the instruction at my site. Learn more here - https://musicwithryan.com/courses/will-circle-unbroken-advanced/ Premiere members get access to over 350 full-length video lessons, all three courses, and my Video Exchange Program for a monthly, quarterly, or yearly fee. Learn more here - https://www.musicwithryan.com/memberships | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "Bluegrass"] | ["amateur recording", "country", "acoustic guitar", "uprightbass", "uptempo"] | 6 | kmZFn-CQ19A | 4356 |
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;