musiccaps_details (view)
4 rows where musiccaps_aspects contains "guitar solo", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "slow tempo" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Josh Gooch: Guitar Center King of the Blues '09 Finalist | This is the live performance of a blues music piece. It is an instrumental performance. The lead electric guitar is playing a blues solo while another electric guitar and a bass guitar are playing in the background. The rhythmic background consists of a slow tempo blues acoustic drum beat. There is a groovy atmosphere to this performance. This piece could be playing in the background at a rock bar. | 2010-02-05T23:29:42Z | Guitar Center | Guitar Center King of the Blues finalist, Josh Gooch's performance from the GC King of the Blues Grand FInals - Nov 12th, 2009 at the House of Blues Sunset. For more information on Guitar Center or King of the Blues visit www.guitarcenter.com | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["live performance", "blues", "instrumental", "electric guitar", "guitar solo", "bass guitar", "acoustic drums", "groovy", "crunchy", "slow tempo"] | 9 | 4bXb6GLm6zg | 589 | |
Lindsey Stirling - Phantom of the Opera(Guitar Cover) | This song features a distortion guitar playing a guitar solo. The solo is played at a high pitch. It is a slow tempo solo. The guitarist plays a lot of vibrato when the notes are allowed to ring for a while. The pattern follows three ascending notes followed by three strikes on a lower note. This is followed by one higher note, the lower note and a hammer on to a higher note. A synth plays backing chords. There are no other instruments in this song. The mood of this song is romantic. | 2012-11-06T21:02:35Z | Łukasz Stemler - MusiC | Fell free to add me on facebook https://www.facebook.com/update_security_info.php?wizard=1#!/pages/ManieK/180841045311104 Here's my band http://www.facebook.com/pages/MossaD-Masters-of-speed-strength-and-Disorder/179106888791919 Hey, my friends ! Check out my fanpage on facebook ! I would like to present you my band .M.o.s.s.a.D ! Click the button ' like it ' :D It would be great ;) Greetings ^ ^ It's a new cover of Lindsey. Everything is playing by ear plus some of my ideas :)This is the second version on youtube I guess :) Hope you gonna like that one . All the best. Axelek666 | ["Guitar", "Music", "Musical instrument", "Opera", "Plucked string instrument"] | ["distortion guitar", "guitar solo", "synth backing", "vibrato", "hammer on", "no other instruments", "no percussion", "no voice", "instrumental", "slow tempo", "romantic theme"] | 0 | NKDBwJIwWoU | 2331 | |
Fur Elise on classical guitar performed by Eddie Blatt | This music is instrumental. The tempo is slow with a melodic acoustic guitar solo. The music is soft, euphonious, dreamy, romantic , warm ,ambient and soothing. This is a Classical acoustic instrumental. | 2007-01-23T06:40:15Z | Eddie Blatt | Eddie Blatt plays Fur Elise on classical guitar live at the Byron Bay Community Centre. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["instrumental", "slow tempo", "acoustic guitar melody", "western classical", "classical", "beautiful", "mellow", "euphonious", "captivating", "mesmerising", "guitar solo", "guitar lead", "string instrument", "live performance", "gentle", "emotional", "atmospheric", "ambient music", "romantic"] | 7 | p2sXdmex3xQ | 4683 | |
Jazzed Blues Solo | This slow blues song features a solo played on a guitar. The tempo of this song is slow. This is accompanied by percussion playing a simple beat. The bass follows the 12 bar blues pattern. The piano plays chords in the background. The mood of this song is romantic and the pattern played on the guitar is similar to a call-response theme. This song can be played in a bar. | 2006-07-17T14:30:15Z | looptruefire | My favorite solo from TrueFire's Jazz ed Blues course with Mark Stefani. | ["Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument"] | ["slow blues song", "instrumental", "guitar solo", "bass", "simple percussion", "12 bar blues", "piano", "slow tempo", "no voices"] | 0 | qAgZ__fk9LY | 4760 |
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;