musiccaps_details (view)
13 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_author = 6 and musiccaps_names contains "Plucked string instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- acoustic guitar · 13 ✖
- amateur recording 11
- medium tempo 4
- uptempo 4
- e-bass 2
- medium to uptempo 2
- percussion 2
- slow tempo 2
- background noises 1
- background voices 1
- backing track 1
- banjo 1
- bluegrass 1
- country 1
- djembe 1
- emotional 1
- female voice singing 1
- fingerstyle 1
- flamenco 1
- flute 1
- flutes 1
- folk 1
- guitar-like instrument 1
- higher register singing 1
- kids singing 1
- kids song 1
- male voice 1
- male voice singing 1
- mandolin 1
- melancholy 1
- …
musiccaps_names (array) 19 ✖
- Music 13
- Plucked string instrument · 13 ✖
- Guitar 12
- Musical instrument 8
- Acoustic guitar 7
- Strum 4
- Steel guitar, slide guitar 3
- Bluegrass 2
- Country 2
- Banjo 1
- Flamenco 1
- Folk music 1
- Mandolin 1
- Maraca 1
- Opera 1
- Singing 1
- Slam 1
- Speech 1
- Tender music 1
youtube_published (date) 13 ✖
- 2006-11-06 1
- 2007-12-25 1
- 2008-04-09 1
- 2009-04-19 1
- 2010-01-28 1
- 2011-08-06 1
- 2012-04-20 1
- 2012-10-31 1
- 2012-11-02 1
- 2013-12-21 1
- 2014-07-22 1
- 2014-09-10 1
- 2016-07-07 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
Cherokee Shuffle on mandolin | Someone is playing an acoustic guitar along with someone playing a solo melody on top with another plucked string instrument. They are accompanied by someone playing a djembe or another percussive instrument. This song may be playing sitting around a bonfire. | 2009-04-19T19:44:26Z | Bill Macy | Cherokee Shuffle on mandolin | ["Acoustic guitar", "Music", "Mandolin", "Plucked string instrument"] | ["rock/country", "acoustic guitar", "guitar-like instrument", "djembe", "medium to uptempo", "amateur recording"] | 6 | vgpV6F9tge8 | 5197 |
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;