musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "male voice", musiccaps_aspects contains "single strum" and musiccaps_names contains "Plucked string instrument"

✎ 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
5 Amazing Guitar Chords You Must Learn! - Creating Your Own Collection Of Favourite Chords This guitar instruction audio features an acoustic guitar. This starts off with a male voice giving instructions on how to play the guitar. The bass note is played on the open string and the chord is strummed once. This is the Hendrix chord being played on the acoustic guitar. There are no other instruments in this song. There is no vocal melody in this song. This audio can be used in a guitar instruction video. 2013-10-12T00:11:40Z Nail Guitar Skills https://nailguitar.com/ld2 ◄ Download a free PDF of the 5 amazing chords. https://nailguitar.com/tools/ ◄ You can also get a blank chord sheet to build your own list of favorite chords. Examples of these chords in songs: Cm11 - Cool #9 by Joe Satriani https://youtu.be/FlbUUKN4KR0?t=256 Em11 - Little Wing as covered by The Corrs https://www.youtube.com/watch?v=HhsacepElvA Em9 - Little Wing as covered by The Corrs https://www.youtube.com/watch?v=HhsacepElvA E7#9 - Loads of Hendrix songs Note he sometimes used a version of this chord lower down the neck. https://www.youtube.com/results?search_query=jimi+hendrix+live G13 - No references for this one sorry... I learnt it at uni while studying under great jazz guitarist, so check out some jazz :) Instagram - http://www.twitter.com/Andymuzic Facebook - http://www.facebook.com/NailGuitar Twitter - http://www.twitter.com/NailGuitar Check out my youtube channels: http://www.youtube.com/NailGuitar - Song Lessons http://www.youtube.com/NailGuitarSkills - Guitar Skills http://www.youtube.com/NailGuitarLicks - Lead Guitar Licks http://www.youtube.com/NailDrums - Drum Lessons http://www.youtube.com/NailPiano - Piano Lessons Details on guitar gear I use: http://www.nailguitar.com/links.html Cheers, Andy Looking for a complete step-by-step guitar learning system? Check out this awesome affordable guitar course http://beginnergtrcourse.nailguitar.com 5 Amazing Guitar Chords You Must Learn! - Creating Your Own Collection Of Favourite Chords ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] ["guitar instruction", "acoustic guitar", "male voice", "single strum", "7th chord", "no other instruments", "no vocal melody"] 0 3OLeJZF4oI0 460

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;