musiccaps_details (view)
9 rows where musiccaps_author = 4, musiccaps_names contains "Guitar" and musiccaps_names contains "Mandolin"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 35 ✖
- low quality 8
- noisy 7
- mono 4
- passionate 4
- cover 3
- emotional 3
- arpeggiated acoustic guitar melody 2
- happy 2
- joyful 2
- passionate solo acoustic guitar melody 2
- rock 2
- acoustic bass guitar 1
- acoustic guitar melody 1
- acoustic rhythm guitar chords 1
- arpeggiated banjo melody 1
- blues 1
- cars passing 1
- chorus pedal effect 1
- electric guitar solo melody 1
- elegant 1
- flat female vocal 1
- fun 1
- jazz 1
- picked mandolin solo melody 1
- playback 1
- ragtime 1
- roomy 1
- shimmering hi hats 1
- simple double bass 1
- smooth 1
- soft 1
- soft female vocal 1
- staccato strings melody 1
- voice crack 1
- wide acoustic guitars melody 1
musiccaps_names (array) 15 ✖
- Guitar · 9 ✖
- Mandolin · 9 ✖
- Music 9
- Musical instrument 8
- Plucked string instrument 8
- Acoustic guitar 3
- Banjo 3
- Bluegrass 2
- Singing 2
- Bowed string instrument 1
- Country 1
- Distortion 1
- Effects unit 1
- Strum 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"September" by Andy Timmons | The low quality recording features a cover of a rock and it consists of passionately played solo acoustic guitar melody over staccato strings melody playing in the background on playback. Even though the recording is noisy, it sounds emotional and passionate. | 2006-04-17T07:15:29Z | aristocrap | A beautiful song by the tone king himself. | ["Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["low quality", "staccato strings melody", "passionate solo acoustic guitar melody", "noisy", "cover", "rock", "playback", "emotional", "passionate"] | 4 | 36ToDxW_hns | 441 | |
Going to California (Led Zeppelin) | The low quality recording features a cover of a rock song and it consists of an arpeggiated acoustic guitar melody over which there is a soft female vocal singing. The recording is noisy, in mono and it sounds emotional, soft and passionate. | 2011-01-17T17:58:17Z | iLoveSHELmusic | I haven't been able to get this song out of my head the last few months, so I decided to play with it a little using my friend Wendy's bright little Fender mando. -Eva Keep in touch with SHEL - http://shelmusic.com Facebook: http://on.fb.me/1X7qCMV Twitter: http://bit.ly/1UinXkS instagram: http://bit.ly/1KnWWb0 iTunes: http://apple.co/1fS1zvB | ["Singing", "Guitar", "Music", "Mandolin", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "soft female vocal", "arpeggiated acoustic guitar melody", "noisy", "mono", "passionate", "emotional", "soft", "cover", "rock"] | 4 | 62L5kn1qFeY | 719 | |
Maxwell Swing by Texas Gypsies | The Jazz song features a passionate solo acoustic guitar melody and acoustic rhythm guitar chords, followed by simple double bass. It sounds smooth and elegant, something you would hear in fancy restaurants or good jazz clubs. | 2012-07-31T05:33:50Z | maxwellswing | Original Gypsy Jazz tune by Texas Gypsies from the Cafe du Swing CD! www.texasgypsies.com Photos by John Heiman, Bruce Buhrow, Chad Windham,David Meadows | ["Banjo", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["jazz", "passionate solo acoustic guitar melody", "acoustic rhythm guitar chords", "simple double bass", "smooth", "elegant"] | 4 | AmAThmRphk0 | 1168 | |
The Grateful Dead Ripple Banjo Cover by Kathleen and Ashley Adams | The low quality recording features a covered song with arpeggiated banjo melody and flat female vocal that is occasionally out of tune. The recording is noisy and in mono, as if it was recorded with a phone, but it is also emotional, regardless of the voice crack. | 2010-08-18T23:49:22Z | MissDJAshes | take 1 LOL just having fun/good times with a banjo and an afternoon (all we are missing is a rocking chair :)) | ["Singing", "Banjo", "Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["low quality", "arpeggiated banjo melody", "noisy", "mono", "flat female vocal", "emotional", "voice crack"] | 4 | H4rdJlSSt5Y | 1772 | |
CO600, CO 600 Behringer Chorus orchestra efekt gitarowy test review - RockDay Pietraszek | The low quality recording features a passionately played electric guitar solo melody with a chorus pedal effect on. The recording is in mono and it is noisy. | 2013-02-21T19:25:42Z | Rockdaypl | CO600, CO 600 Behringer Chorus orchestra efekt gitarowy test review - RockDay Pietraszek | ["Effects unit", "Guitar", "Music", "Mandolin", "Musical instrument", "Distortion"] | ["low quality", "noisy", "mono", "chorus pedal effect", "electric guitar solo melody", "passionate"] | 4 | _hYBs0xee9Y | 3484 | |
Izaías e Seus Chorões | Remelexo (Jacob do Bandolim) | Instrumental Sesc Brasil | The low quality recording features wide acoustic guitar melodies playing over shimmering hi hats, followed by acoustic bass guitar. It sounds passionate and joyful. | 2011-02-04T21:27:43Z | Instrumental Sesc Brasil | Izaías Bueno de Almeida começou a tocar bandolim com 10 anos de idade. Quando foi apresentado por Jacob do Bandolim, tornou-se o mais respeitado bandolinista de São Paulo. Israel passou depois para o violão, tocando bossa-nova, e para a guitarra, integrando conjuntos de iê-iê-iê. O começo dos anos 70 marcou também o nascimento de Izaías e Seus Chorões, com a atual formação, junta há mais de dez anos. Formação: Izaías Bueno de Almeida - bandolim Israel Bueno de Almeida - violão 7 cordas Edmilson Capelupi - violão 6 e 7 cordas Arnaldinho do Cavaco - cavaquinho José Reli - pandeiro Gênero: Choro Show que ocorreu no Teatro Anchieta do Sesc Consolação dia 24/01/2011 • site oficial: https://www.instrumentalsescbrasil.org.br/ • assista aos shows ao vivo pelo https://www.youtube.com/instrumentalsescbrasil 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. | ["Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["low quality", "wide acoustic guitars melody", "shimmering hi hats", "acoustic bass guitar", "passionate", "joyful"] | 4 | cYSW6Y884dA | 3718 | |
Salty Dog Blues: Piedmont Blues Fingerstyle | The low quality recording features an acoustic guitar blues melody. The recording is very noisy, roomy and you can hear cars passing by in the background. | 2008-12-17T22:33:33Z | bostonteabagger71739 | My version of the old blues song. A little sloppy I know haha | ["Country", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["low quality", "blues", "acoustic guitar melody", "noisy", "roomy", "cars passing"] | 4 | g_bgmnJ1b_g | 4039 | |
The Entertainer (S.Joplin) Advanced Slide Guitar Version - Marc Athlan | The low quality recording features a cover of a ragtime song and it consists of arpeggiated acoustic guitar melody. The recording is noisy, but it sounds happy and fun regardless. | 2014-07-27T15:55:10Z | Marc Athlan | This is an attempt to adapt the famous Scott Joplin tune (whole version) on slide guitar. If it has been said that it's a challenge to play this song on guitar, it's even more challenging on slide guitar ! I tried to be as close as possible to the original version. Played on resonator guitar with Diamond Bottleneck (The BEST in the world !). Thanks to Nathalie Athlan, Ian McWee and others at Diamond Bottlenecks.com. Thanks to Keni Lee Burgess for having inspired me with his video (https://youtu.be/X0VL_js9sWs) to do my version of this tune. Thanks for watching ! | ["Banjo", "Guitar", "Music", "Mandolin", "Musical instrument", "Strum", "Plucked string instrument"] | ["low quality", "cover", "arpeggiated acoustic guitar melody", "noisy", "happy", "fun", "ragtime"] | 4 | iCIa_pmLDqs | 4168 | |
Cooley's Reel and The Wise Maid | The low quality recording features a picked mandolin solo melody. Even though the recording is noisy and in mono, it gives off joyful and happy vibes. | 2008-07-10T22:49:46Z | tantoonie0 | Again, I play slow through this reel the first couple of times than pick it up to a session tempo (maybe a little faster). The second tune is one I've done on the tenor guitar, but which goes really well in this set, which I learned from a session in Knoxville, Tennessee. | ["Guitar", "Music", "Mandolin", "Plucked string instrument", "Bluegrass"] | ["low quality", "noisy", "mono", "picked mandolin solo melody", "joyful", "happy"] | 4 | pxEmmUYLHrE | 4744 |
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;