musiccaps_details (view)
18 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_author = 6 and musiccaps_names contains "Guitar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Doraemon guitar music | This audio contains an acoustic guitar. The piece is played in fingerstyle. Meaning that the chords and the melody are played at the same time. The guitar has some reverb on it. This song may be playing live at an art gallery. | 2006-07-14T12:51:19Z | fenderld | Doraemon music ,china men play guitar | ["Bass guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Happy music"] | ["fingerstyle-guitar", "acoustic guitar", "medium tempo", "classical atmosphere"] | 6 | 07FxCXxknY4 | 123 | |
| Bluegrass jam ( Rebecca) | An acoustic guitar is strumming chords while a banjo is playing a fast melody over it. In the background you can hear an upright bass playing a fast walking bassline. Also in the background noises of people speaking can be heard. This song may be playing live on the streets performed by buskers. | 2006-11-06T22:08:09Z | monrobro | Jamming at Memramcook Festival with True Blue Banjo- Dominic Cormier Bass- Jean-Marc Boucher Mandolin- Ron Girouard Guitar- 1st Break Michael Alain Guitar- 2nd Break Richard Bourque | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bluegrass"] | ["bluegrass", "amateur recording", "banjo", "acoustic guitar", "upright bass", "background voices", "medium to uptempo"] | 6 | 669Fk7afszw | 724 | |
| 君が好きだと叫びたい 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 | |
| 'Til I Can Make It On My Own - Pedal Steel Guitar Instrumental (orig. by David Hartley) | someone is picking and strumming a melody on the acoustic guitar while a slide guitar is playing the main melody on top of it. Then an acoustic drum comes with an e-bass providing the rhythmic support. | 2016-02-20T06:54:31Z | Freda01 | Pedal Steel Guitar: Guenther Dachs 'Til I can make it on my own" is a song co-written and recorded by the First Lady of Country Music Tammy Wynette in 1976. David Hartley does a wonderful instrumental version of that song and I am trying to get into the spirit of David's beautiful rendition. | ["Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar"] | ["country/folk/ballad", "acoustic guitar", "slide guitar", "acoustic drums", "e-bass", "slow tempo"] | 6 | AF7sah5a_DE | 1091 | |
| 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 | |
| Sleepwalk | This file contains someone playing a slide guitar melody over a backing track. The backing-track contains an e-bass playing the footnote of an acoustic guitar strumming chords. You can hear a shaker serving as a rhythmic instrument. | 2008-04-09T00:57:53Z | Usher Ben Ishay | Santo and Johnny Cover Played On my 58' Rickenbacker Lap Steel. | ["Guitar", "Music", "Steel guitar, slide guitar", "Plucked string instrument"] | ["amateur recording", "backing track", "slide guitar", "tambourine", "e-bass", "acoustic guitar", "slow tempo"] | 6 | EQHrQIaQNv8 | 1554 | |
| Sound Check Acoustic Guitar Walden T550.avi | Someone is playing an acoustic guitar ending his phrase. In the background you can hear high pitched noises. This song may be playing at home practicing guitar. | 2012-04-20T06:39:37Z | Chacross | Sound Check Acoustic Guitar Walden T550.avi | ["Guitar", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["amateur recording", "acoustic guitar", "slow tempo", "background noises"] | 6 | G4fTKotMoWI | 1690 | |
| timile ta haina | Someone is playing an acoustic guitar strumming chords on the backbeat while someone is holding the rhythm with a shaker and a percussion in the background. This song may be playing while having a jam session with your friends. | 2014-09-10T14:13:19Z | Jolon Deepanjali Joshi | rehearsal | ["Singing", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Maraca"] | ["reggae/pop", "amateur recording", "acoustic guitar", "shaker", "percussion", "medium tempo"] | 6 | Gow0TlxIx7U | 1755 | |
| LOTRO Music - The Bard's Song (band) | An acoustic guitar is finger-picking a tremolo melody along with a flute playing a melody on top. This song may be playing in an adventure video-game. | 2010-01-28T08:38:42Z | Matheus Eichelberger | Playing The Bard's Song with three instruments (lute, harp and flute) in Rivendell. Elcarandir, Elf Hunter Reidartyr Beowulfson, Man Guardian. Annr, Man Minstrel. Server: Landroval Kinship: House of Telperion - Brazil's RP Kinship | ["Guitar", "Acoustic guitar", "Music", "Plucked string instrument", "Tender music"] | ["folk", "acoustic guitar", "flute", "soothing", "uptempo"] | 6 | MfKSVJIcDK0 | 2287 | |
| BOLEROS CON GUITARRA FLAMENCA | Someone is playing an acoustic guitar flamenco style finger-picking while a female voice sings loud and emotionally. This song may be playing live in a restaurant. This is an amateur recording. | 2012-10-31T16:51:52Z | Olga Chito | NANI CANTANDO, Y JONI A LA GUITARRA | ["Guitar", "Music", "Musical instrument", "Opera", "Strum", "Plucked string instrument"] | ["flamenco", "acoustic guitar", "female voice singing", "sensual", "emotional"] | 6 | OjoDuBkPDM8 | 2463 | |
| Your Call [Guitar Lesson/Gitarren Tutorial] by SoundElement T#08 | This audio contains someone slowly finger picking a chord up and down ending on the root note. This is an amateur recording and may be used for educational purposes. | 2014-10-10T08:19:18Z | SoundElement | Gitarren/Guitar Tutorial T#08 by SoundElement ▼▼▼--------------Playlist-------------▼▼▼ ►Your Call - Second Serenade https://www.youtube.com/watch?v=GkuypwKUX2Y ►Playlist ________________________ 2x Intro 6x Verse 2x Chorus 2x Chorus 4x Bridge 4x Chorus _______________________ ►we would appreciate if you subscribe our channel https://www.youtube.com/channel/UC_iuZb3zICKWT454sInuWrA extra tags: how to play Your Call how to play Second Serenade how to learn to play Gitarre spielen lernen Gitarre lernen Spielen lernen Gitarre lernen Anfänger Gitarre anfänger gitarren kurs akkord einfache gitarren lieder easy guitar songs | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | ["amateur recording", "acoustic guitar", "slow tempo"] | 6 | PkkhCW04O9k | 2561 | |
| Guitar Rumba Flamenco Latin Jazz John Gilliat | Someone is playing an acoustic guitar with flamenco techniques and melodies. In the background you can hear someone playing shakers. This recording contains a little bit of reverb on the instruments. This song may be playing as a live performance. | 2007-10-18T07:29:08Z | John Gilliat | Would you like to learn HOW TO PLAY GUITAR WITHOUT AT GUITAR? Go to https://www.yourguitarschool.com for a FREE course!v For more information about John visit: https://www.johngilliat.com For Skype Guitar Lessons with John visit: https://www.johngilliat.com/lessons Performance Live, Solo Guitar with a Roland RC50 loop station. The song is Titled Nachos from John's cd Freedom. A special thanks to everyone at Spotlight: Pat Rogers, Janet Law, Alecis MacPherson & Kevin Adlem at Delta Cable. | ["Flamenco", "Guitar", "Jazz", "Music", "Musical instrument"] | ["flamenco", "acoustic guitar", "shakers", "medium tempo"] | 6 | Wgf7UYPVoAo | 3123 | |
| 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 | |
| Kjarkas - Yo no he nacido para sufrir HD | This song contains someone strumming a melody on a mandolin while more people are whistling along. Then a mandolin, an e-bass and an acoustic guitar are playing a short melody in a lower key before breaking into the next part along with flutes and percussions. This song may be played outside by musicians performing. | 2016-07-07T01:47:40Z | calacas555 | Tema que será parte de la nueva producción cdgráfica del grupo Kjarkas denominado la Leyenda Viva | ["Folk music", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "acoustic guitar", "e-bass", "mandolin", "flutes", "whistling", "percussion", "medium tempo"] | 6 | ZTVMsW1h3bI | 3379 | |
| Dans un coin le sapin | Someone is playing an acoustic guitar while a male voice in the mid range is singing accompanied by kids singing with him. This is an amateur recording. This song may be playing live in a school during music class. | 2013-12-21T06:09:35Z | Classe maternelle | ["Country", "Guitar", "Acoustic guitar", "Music", "Strum", "Plucked string instrument"] | ["kids song", "acoustic guitar", "male voice singing", "kids singing", "medium tempo", "amateur recording"] | 6 | dqJSTTS7HTY | 3816 | ||
| 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 | |
| GH5 en crunch | Someone is playing a distorted e-guitar solo along to a backing track containing a strummed acoustic guitar and a simple drum groove. This recording is of poor audio-quality. This song may be playing at home practicing guitar. | 2007-05-27T18:35:30Z | vitriol82 | jph94 encore une fois à contribution sur le petit GH5 Rdv sur www.projetg5.com | ["Electric guitar", "Guitar", "Music", "Wedding music", "Distortion"] | ["e-guitar", "acoustic guitar", "drums", "amateur recording", "medium tempo"] | 6 | oOlMzQpK690 | 4625 | |
| Flamenco Duo, Bulerías | Someone is playing a melody on an acoustic guitar and someone another melody on a oud. The two melodies complement each other. This song may be playing in a live presentation. | 2011-05-29T08:10:47Z | Mundo Flamenco | Mariano Martin and Amir John Haddad played this "Bulerías" in may 2011, during a recording session for the website of Mundo Flamenco. Mariano plays a Francisco Barba Caviuna guitar with top of spruce and Amir plays an old arabian lute (Ud) from his father. | ["Flamenco", "Guitar", "Music", "Mandolin", "Musical instrument"] | ["flamenco", "acoustic guitar", "oud", "medium to uptempo"] | 6 | t6jlx6jAb-Q | 5007 |
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;