musiccaps_details (view)
1 row where musiccaps_aspects contains "instrumental", musiccaps_author = 0, musiccaps_names contains "Plucked string instrument" and "youtube_published" is on date 2011-02-11
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Intermediate Rhythm Guitar 5 - How To Play Rhythm Guitar - Stage 5 Guitar Lesson [IM-155] | This song features a guitar being played. One guitar chord is struck per bar. This song lasts for 4 bars and four chords are played. There are no voices in this song. There are no other instruments in this song. | 2011-02-11T02:25:22Z | JustinGuitar | This lesson we check out chips, spreads and splangs and some muted strumming! Interesting techniques to add some variety to your rhythm playing! Find the related course notes on the following link: http://justinguitar.com/en/IM-155-Rhythm-5-SplangsSpreadsChipsEtc.php This is part of Justin's Intermediate Guitar Method, Foundation. A series of lessons available free online! http://justinguitar.com/en/IM-000-IntermediateMethod.php Please SUBSCRIBE ►http://bit.ly/jgtr-sub ♥️ Your Support Appreciated! See JustinGuitar.com for over 1500 completely free lessons - not random stuff like you find on YouTube, but well structured courses so you can see your progress. Register on the site (still free) get PDF downloads for many lesson, your own dashboard to keep track of your practice, get help with lessons and make requests. It's nearly all 100% free and card details are not needed to register. You have everything to gain, and nothing to lose! My theory course is the best on the web (and one of the very few paid parts of the site) and it's awesome - if your theory is lacking and you wanna fix it - that's the place to go! At my store, you'll find a huge range of super cool guitar themed t-shirts, all my (paper) books, merch and lots more 🙂 and we got proper fun backing tracks for you to jam along with too! • Website https://www.justinguitar.com • Theory Course http://bit.ly/jgtr-theory • JustinGuitar Beginner Song App https://go.onelink.me/3065804798/jgtryt • Exclusive Guitar T-Shirts: https://bit.ly/jgtr-tees • Jam Tracks http://bit.ly/jgtr-jams • Instagram http://bit.ly/jgtr-instagram • Facebook http://bit.ly/jgtr-facebook • Twitter http://bit.ly/jgtr-twitter • Forum http://bit.ly/jgtr-community • Workshops http://bit.ly/jgtr-workshops -~-~~-~~~-~~-~- Please watch: "The Justin Guitar Beginner Song Course by FourChords for iOS & Android JustinGuitar Easy Guitar Song" https://www.youtube.com/watch?v=0I2F8CDpqWU -~-~~-~~~-~~-~- | ["Reverberation", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["guitar song", "instrumental", "no percussion", "no other instruments", "chords", "slow tempo", "no voice"] | 0 | RdKQGIzKZ_c | 2716 |
Advanced export
JSON shape: default, array, newline-delimited
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;