musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- acoustic guitar · 6 ✖
- amateur recording · 6 ✖
- uptempo · 6 ✖
- country 2
- banjo 1
- bluegrass 1
- clarinet 1
- cuatro 1
- e-bass 1
- female duo singing 1
- fingerstyle 1
- harmonica 1
- slide guitar 1
- tambourine 1
- tremolo 1
- upright bass 1
- uprightbass 1
musiccaps_names (array) 15 ✖
- Music 4
- Guitar 3
- Musical instrument 3
- Plucked string instrument 3
- Acoustic guitar 2
- Bluegrass 2
- Banjo 1
- Brass instrument 1
- Clarinet 1
- Country 1
- Flamenco 1
- Harmonica 1
- Slam 1
- Strum 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bluegrass When the Roll Is Called Up Yonder (Bruce Weeks) | Someone is playing an acoustic guitar strumming chords on the backbeat along with a banjo doing the same. A slide guitar is playing a melody along. An upright bass is playing a simple bassline. Two female voices are singing as a duo. The second one creates harmony in the higher register. This song is an amateur recording. This song may be playing at a local event. | 2008-10-31T14:30:29Z | Bruce Weeks | www.bruceweeksfamilyband.com More music from our Jasper Meeting on Thursday nights now meeting at 3530 Salem Church Rd 3 miles from Jasper Jeep on the right. | ["Banjo", "Country", "Music", "Bluegrass"] | ["bluegrass", "acoustic guitar", "slide guitar", "upright bass", "banjo", "female duo singing", "amateur recording", "uptempo"] | 6 | 40sAH2ZB0Pg | 532 | |
Roda de Choro | Perigoso (Orlando Silveira) | Instrumental SESC Brasil | This audio contains someone playing a melody on a guitar in the midrange while someone else is strumming a melody on a cuatro in a higher key. Someone is playing a tambourine while a clarinet is playing a fast lead melody. This audio may be playing as a live concert. | 2010-10-07T06:12:32Z | Instrumental Sesc Brasil | A Roda de Choro nasceu na Virada Cultural de 2007, no Auditório Ibirapuera, sob organização de Danilo Brito. Desde sua criação, já aconteceu em diversos teatros e recebeu convidados como Carlos Malta, Laércio de Freitas, Toninho Ferragutti, Ricardo Herz, Danilo Brito, Alessandro Penezzi, Nelson Ayres, Oswaldinho do Acordeon e Gabriel Grossi, entre outros. No repertório, choros clássicos, passando por Pixinguinha, Jacob do Bandolim e algumas composições próprias. Formação: Alexandre Ribeiro - clarinete Léo Rodrigues - pandeiro Milton Mori - cavaquinho Luizinho 7 Cordas - violão 7 cordas Nelson Ayres - piano Toninho Ferragutii - acordeon Gênero: Choro Show que ocorreu no Teatro do Sesc Paulista dia 13/09/2010 • site oficial: http://instrumentalsescbrasil.org.br • assista aos shows ao vivo pelo http://facebook.com/sescsp Inscreva-se no canal http://www.youtube.com/sescsp e fique por dentro de toda a programação que acontece nas unidades do Sesc no estado de São Paulo. Basta ter uma conta gratuita no Google. | ["Brass instrument", "Clarinet"] | ["amateur recording", "acoustic guitar", "tambourine", "cuatro", "clarinet", "e-bass", "uptempo"] | 6 | 6uIOGE36tWo | 795 | |
君が好きだと叫びたい 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 | |
The Times They Are a-Changin' - Bob Dylan (Cover w/ Harmonica) | Someone is strumming chords on an e-guitar while playing a melody with the harmonica in a higher register. This song may be playing gathered around a bonfire. | 2014-10-16T15:18:47Z | Christy Myers | SoundCloud: https://soundcloud.com/christymyers | ["Harmonica", "Wind instrument, woodwind instrument"] | ["amateur recording", "acoustic guitar", "harmonica", "uptempo", "country"] | 6 | ODRAYQE9GXs | 2412 | |
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 | |
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;