musiccaps_details (view)

2 rows where musiccaps_names contains "Guitar" and "youtube_published" is on date 2013-11-28

✎ View and edit SQL

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
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
Jimi Hendrix - The Wind Cries Mary (w/Solo) - Blues/Rock Guitar Cover This slow rock song features a male voice singing the main melody. This song starts off with a guitar playing hammer ons over three chords. The main part of the song starts off after this sequence. It starts off with a drum roll and a pentatonic run on the guitar. The voice comes in after the roll and the bass starts playing with the voice. The bass plays the root notes of the chords. The voice sings an emotional line. This song can be played in a movie based on the hippie culture. 2013-11-28T20:01:28Z GuitarForceCovers Support me on PATREON - https://www.patreon.com/user?u=2903854&ty=h Hey, guys! This is a cover of a beautiful song by Jimi Hendrix - The Wind Cries Mary. Simple, but very unique song, the solo is just amazing. You can tell so much with just few notes. Jimi was just unique musician, human (although I'm not sure :) and a guitarist. Enjoy this cover! Watch in HD! A lesson on this song can be found HERE - https://www.youtube.com/watch?v=1L4TvB-5-cI and lesson on the Solo HERE - https://www.youtube.com/watch?v=CyKJeroyPnM ["Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] ["slow rock", "electric guitar", "male voice", "simple percussion", "bass guitar", "moderate tempo", "emotional voice"] 0 fYvUB-qy4IM 3959

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;