musiccaps_details (view)

2 rows where musiccaps_names contains "Guitar" and "youtube_published" is on date 2011-02-02

✎ 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
Guitar Lesson: Hey Joe Chords (Jimi Hendrix) Someone is playing a rock/funk riff on an e-guitar with a lot of low end. Then a male voice starts speaking. This song may be playing during a guitar lesson. 2011-02-02T12:52:33Z RiffNinjaSongLessons http://www.RiffNinja.com The Hey Joe chords were not written by Jimi Hendrix, although he really made the song famous. The Hey Joe chords are C G D A E, then the signature riff. Make sure you checkout the other lesson on the tab for Hey Joe. For more guitar lessons, visit our other Youtube channel: http://www.youtube.com/RiffNinjaGuitar or http://www.RiffNinja.com ["Reverberation", "Guitar", "Musical instrument", "Plucked string instrument"] ["amateur recording", "rock", "e-guitar", "male voice talking", "medium tempo"] 6 URM1QgX5Ar4 2917
Guitar Lesson - Hallelujah by Jeff Buckley - Simple How to Play Tutorial This is the recording of a guitar lesson video. There is a male speaking in an instructive manner, giving the name of the chord he is about to play next. The chords are being played gently on a clean sounding electric guitar. There is a mellow feel to the sound. Parts of this recording can be sampled for use in beat-making. 2011-02-02T23:22:19Z FullDistortionDotCom http://www.FullDistortion.com - Lesson on how to play Hallelujah by Jeff Buckley. To view this lesson with the tab go to http://www.FullDistortion.com. To join the Full Distortion Players' Club go to http://www.FullDistortion.com/players-club Copyrights to any songs mentioned or used are the property of the artist and its promoters, producers and/or affiliates and is used here for informational and educational purposes only as outlined in the Fair Use provision of Title 17 of the United States Code as amended by the Digital Millennium Copyright Act of 1998. No copyright infringement intended. ["Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument", "Inside, small room"] ["guitar lesson", "male voice", "instructive speaking", "electric guitar", "clean sound", "gentle playing", "mellow"] 9 WvaIypMvAHY 3149

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;