musiccaps_details (view)

5 rows where search matches "guitar", musiccaps_aspects contains "country blues" and musiccaps_names contains "Blues"

✎ View and edit SQL

This data as json, CSV (advanced)

musiccaps_author 3 ✖

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Rosie and The Originals - Angel Baby - Rare FULL Version We hear a twangy electric guitar on which some arpeggiated chords are played. The music style is a bluesy country rock style. 2013-06-07T03:47:56Z PJDooWop Here's the full version. For some reason there are a lot of edited versions floating around that cut off the instrumental break and the ending. I don't think I ever heard the full ending of this on NY radio, but here is the entire recording for your enjoyment ["Blues", "Jazz"] ["twangy electric guitar arpeggios", "country rock", "country blues", "southern"] 3 KikHXfUanJk 2110
Blues, Country Blues, Rhythm & Blues The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. 2010-06-04T21:51:03Z StrontiumDawg 3 fine slices of blues music. Got my mojo workin' - Muddy Waters, Frankie - Missisipi John Hurt, Crawling up a hill - John Mayall ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] 4 ZzyWbehtt0M 3433
Country blues music This music is instrumental. The tempo is slow with an acoustic guitar harmony, loud electric guitar feedback and fiddle. The music is intense, rugged, vivid, melancholic, pensive, raw, powerful, emphatic and strong. This music is classic Blues Country Music. 2012-07-29T11:41:29Z PROMETHEUS Country, blues song :D ["Blues", "Country", "Music", "Bluegrass"] ["instrumental", "slow tempo", "melancholy", "vivid", "empahtic melody", "rugged", "powerful", "country blues", "blues", "country music", "country song", "regional music", "empahtic electric guitar feedback", "acoustic guitar harmony", "country music", "intense", "rugged", "fiddle"] 7 cGorUmWMrwo 3693
Blues & Decker - Till Dawn (Official Music Video) This is a high-octane blues song, with layers of intricate bluesy acoustic guitar playing. There's a slide guitar involved, and other layers of potent intense guitar playing. There's a distant filtered vocal hum which sounds like it is coming through a telephone. 2013-06-17T07:20:31Z Blues & Decker Videoclip del tema "Till Dawn", extraído del disco "Stealin' the blues" de Blues & Decker. Una historia de Blues y Muerte. Protagonizado por Eve MyVestal. Dirigido y realizado por Titi Muñoz. No dejes de visitar la web oficial de la banda: www.bluesdecker.com ["Blues", "Guitar", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Plucked string instrument"] ["slide guitar", "blues", "blues guitar", "country blues", "intricate acoustic guitar playing", "guitar layers", "dense guitar playing", "foot stomping percussion", "filtered vocal humming"] 3 m7i4g_o-znQ 4445
I've Got a New Heartache This is a bluesy country style song played on a lap steel guitar. There is a walking bassline, and slide guitar being played. The singer has a burly, calm voice. The song would be heard in an old school bar in Texas - which might be called a "saloon". 2008-02-16T09:58:41Z Brian Folks A Real Good Swingin' Country Song...Has Lots of Pedal Steel Guitar in it...Enjoy. Brian... ["Blues", "Music", "Steel guitar, slide guitar"] ["lap steel guitar", "blues", "upright bass guitar", "country blues", "twangy high pitched licks", "slide guitar"] 3 nU7x170OvJ4 4543

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;