musiccaps_details (view)

3 rows where search matches "guitar", musiccaps_names contains "Blues" and musiccaps_names contains "Jazz"

✎ View and edit SQL

This data as json, CSV (advanced)

musiccaps_names (array) 8 ✖

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
Josh Rouse - Love vibration (live in Madrid 2007) A male vocalist sings this lively pop rock. The tempo is medium with an intense electric guitar harmony, punchy drumming, groovy bass lines and keyboard harmony. The song is muffled as the audio quality is inferior but it sounds enthusiastic, youthful, passionate and vibrant. This could be a live performance as there are background sounds of people talking, coughing, rustling. This song is Pop Rock. 2007-11-23T05:28:53Z ruben garrido Josh Rouse en directo en Madrid - 22 noviembre 2007 (live in Madrid) Mi cronica del concierto pinchando aqui: http://40formasdeintimidad.wordpress.com/2007/11/23/en-joy-josh-rouse/ ["Blues", "Country", "Jazz", "Music"] ["male vocalist", "medium tempo", "popnrock", "live performance", "gig", "acoustic pop rock", "pop rock", "youthful", "energetic", "vibrant", "enthusiastic", "people talking", "coughing", "rustling", "lively electric guitar", "intense drumming", "synthesiser harmony", "groovy bass line", "muffled audio", "inferior audio quality", "static", "boomy", "loud"] 7 SwaqANBpZGY 2797
Jam Track - Jazzy Funk Blues - Bm7 (rhythm guitar track) The Low quality recording features a groovy acoustic rhythm guitar melody that occasionally has some audio cuts out in the stereo image - making it sound unbalanced. 2013-11-28T08:13:31Z Randy Struble Backing Tracks A play on the Bm7 chord in a funk, jazz, blues kinda way!! Listen! Be inspired! Create! Improvise! Enjoy!! You can DOWNLOAD this and any of my other Jam/Backing Tracks @ https://bluegrassbackingtracks.bandcamp.com/track/jam-track-jazzy-funky-blues-bm7-rhythm-guitar-track Thanks for using a Backing Track by Randy Struble Produced with CyberLink PowerDirector 10 ["Blues", "Funk", "Guitar", "Jazz", "Acoustic guitar", "Music", "Strum"] ["unbalanced stereo", "audio cutout", "groovy acoustic rhythm guitar melody", "low quality"] 4 VOWGbyg4KZY 2998

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;