musiccaps_details (view)
3 rows where musiccaps_aspects contains "blues", musiccaps_author = 9 and musiccaps_names contains "Blues"
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 | |
| ♫ Blues Music - Relaxing Romantic Sexy Slow Blues - Instrumental Guitar Blues Chill Out | This is an instrumental blues music piece. A clean electric guitar is playing a groovy solo while the bass guitar plays in the background. The acoustic drums are playing a slow tempo blues beat. The piece has a relaxing atmosphere. It could be playing in the background at a rock bar. This piece could also be playing in the soundtrack of a romantic movie especially during flirting scenes. | 2013-09-27T22:08:24Z | BLUES GUITAR NATION by KENNETH ST. KING | Blues Music, Blues songs. Blues Guitar. Sweet Old School slow Blues vibe for your enjoyment. Fashioned in the classic style of BB King, Eric Clapton, Peter Green, Mick Taylor, Mike Bloomfield and all my other boyhood Blues guitar hero's! Thanks! ~KJ St. King Gear used: Fender Hot Rod Telecaster, Fender Jeff Beck Strat, Fender Super Champ XD. Recorded using Garageband. A little sexy musica de striptrips! Photo use: Rodrigo Gianesi @ http://www.flickr.com/photos/perfectsonnet/ Photo use: My Huy Streetphotography @ http://www.flickr.com/photos/myhuyphoto/with/8685713769/ Photos used via Creative Commons License 2.0 @ http://creativecommons.org/licenses/by/2.0/deed.en_CA Great old school Blues guitar. Romantic, sexy and sensual sounding. Rich top notch tones from two of Fender's best guitars played through a superb Fender Amp. Best Relaxing Blues. Best Romantic Blues Guitar. Top Instrumental Blues Guitar. Best Blues Guitar. Blues Guitar Solo. Blues Music Guitar. Instrumental Blues. Blues Guitar Solo. Blues Licks. Blues Riffs. Hot Blues. Best Blues Solo. Blues Tones. For my overseas friends and friends from Non-English speaking countries, here are some descriptives in order to assist you in finding our sweet Blues! Blues Music la música blues موسيقى البلوز блюз Blues müzik muzica blues blues musikk ブルース音楽 blues μουσική Blues-Musik blues musika bluesmuziek Blues Guitar guitarra de blues Блюз гітара guitarra de blues blues gitar блюзової гітари blues gitarr blues gitara блюзовой гитары chitara blues guitarra blues Blues-Gitarre la guitare blues blues gitaar blues kytara | ["Blues", "Music"] | ["blues", "no singer", "instrumental", "clean electric guitar", "guitar solo", "bass guitar", "acoustic drums", "groovy", "chill", "relaxing", "easygoing", "slow tempo"] | 9 | QIjShFhrp6w | 2610 | |
| Epiphone Les Paul Blues in G | This is an instrumental rock music piece recording in the style of blues. There is an electric guitar playing a solo using the shredding technique. The backing track consists of a piano, a bass guitar and acoustic drums. There is a groovy feel to it. Parts of this recording could be sampled for use in beat-making. | 2006-02-22T07:39:48Z | Raúl Cabezalí | Download my tunes for free from http://www.jamendo.com/en/artist/353294/raulin-de-los-bosques Raulin de los Bosques plays some blues licks over a g-blues backing track on a Epiphone 'Les Paul' Standard through his Behringer V-amp2. | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["rock music", "jam", "no singer", "instrumental", "electric guitar", "guitar solo", "shredding", "backing track", "piano", "bass guitar", "acoustic drums", "groovy", "blues"] | 9 | hVVrl9FkKnY | 4113 |
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;