musiccaps_details (view)
1 row where musiccaps_aspects contains "average audio quality", musiccaps_aspects contains "guitar accompaniment style", musiccaps_aspects contains "passionate" and musiccaps_names contains "Plucked string instrument"
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 |
---|---|---|---|---|---|---|---|---|---|---|
SLAP GUITAR • Slapping Solo Guitar Composition • Peter Luha | The song is an instrumental. The song is medium fast tempo with a bass guitar soloist playing a cool accompaniment groove with no other instrumentation. The song is passionate and energetic. The song is a bass guitar demo or a home music video. | 2011-10-26T19:29:21Z | Peter Luha - Guitarist | Enjoy my Solo Slap Guitar composition, played on my custom Framus Tennessee guitar! 😎👍🎸 🔔 If you enjoy - 𝗟𝗜𝗞𝗘, 𝗦𝗛𝗔𝗥𝗘 and 𝗦𝗨𝗕𝗦𝗖𝗥𝗜𝗕𝗘 for more, 𝗖𝗟𝗜𝗖𝗞 𝗧𝗛𝗘 𝗕𝗘𝗟𝗟 to be notified of my new videos! https://youtube.com/peterluha?sub_confirmation=1😉🎸🤘 ▶ 𝗖𝗛𝗘𝗖𝗞 𝗢𝗨𝗧 𝗠𝗬 𝗣𝗟𝗔𝗬𝗟𝗜𝗦𝗧𝗦: 𝐂𝐥𝐚𝐬𝐬𝐢𝐜𝐚𝐥 𝐌𝐮𝐬𝐢𝐜 𝐨𝐧 𝐄𝐥𝐞𝐜𝐭𝐫𝐢𝐜 𝐆𝐮𝐢𝐭𝐚𝐫: https://youtube.com/playlist?list=PL23D875E21629F892 𝐒𝐥𝐚𝐩 & 𝐓𝐚𝐩𝐩𝐢𝐧𝐠: https://youtube.com/playlist?list=PLC535FE0C41C0633B 𝐅𝐫𝐞𝐞 𝐆𝐮𝐢𝐭𝐚𝐫 𝐕𝐢𝐝𝐞𝐨 𝐋𝐞𝐬𝐬𝐨𝐧𝐬: https://youtube.com/playlist?list=PLE8F62A930572D159 𝐆𝐮𝐢𝐭𝐚𝐫 𝐋𝐨𝐨𝐩𝐬: https://youtube.com/playlist?list=PL7538637FA18C7AD1 𝐂𝐨𝐯𝐞𝐫𝐬 𝐨𝐟 𝐏𝐨𝐩𝐮𝐥𝐚𝐫 𝐒𝐨𝐧𝐠𝐬: https://youtube.com/playlist?list=PLTpm4YerEHJ1kh7McsoCiWnh4krzCUzwE 𝐀𝐜𝐨𝐮𝐬𝐭𝐢𝐜 𝐆𝐮𝐢𝐭𝐚𝐫 𝐏𝐥𝐚𝐲𝐢𝐧𝐠: https://youtube.com/playlist?list=PLTpm4YerEHJ0K_jAsR4x3pXa6ekBUPzrM 𝐌𝐮𝐬𝐢𝐜 𝐂𝐨𝐥𝐥𝐚𝐛𝐬: https://youtube.com/playlist?list=PLTpm4YerEHJ35wko5yuBPP1EwdbYsTHO7 𝐆𝐮𝐢𝐭𝐚𝐫 𝐓𝐞𝐬𝐭𝐬, 𝐑𝐞𝐯𝐢𝐞𝐰𝐬: https://youtube.com/playlist?list=PLTpm4YerEHJ3w5p8X47XuCIMsS44gsIx6 =============================== ▶ Download my eBooks/pdf 𝗠𝗢𝗗𝗘𝗥𝗡 𝗚𝗨𝗜𝗧𝗔𝗥 𝗧𝗘𝗖𝗛𝗡𝗜𝗤𝗨𝗘𝗦 𝗜𝗡 𝗣𝗥𝗔𝗖𝗧𝗜𝗖𝗘 (sheet music + TAB), that also contain this exercise: here: https://peterluha.com/product-category/sheet-pdf Each lesson is based on one guitar technique (guitar slap, tapping, arpeggios, sweep picking, legato, alternate picking..). In practicing these types of guitar lessons you can get a better idea how to use various techniques in specific songs. So keep practicing! 😉🎸 =============================== ▶ 𝗖𝗢𝗡𝗧𝗔𝗖𝗧 & 𝗕𝗢𝗢𝗞𝗜𝗡𝗚: https://peterluha.com/contact ▶ 𝗙𝗢𝗟𝗟𝗢𝗪 𝗠𝗘: Peter Luha - Guitarist 𝐖𝐞𝐛: https://peterluha.com 𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: https://instagram.com/peterluha 𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: https://facebook.com/peterluha.guitart 𝐓𝐰𝐢𝐭𝐭𝐞𝐫: https://twitter.com/peterluha 𝐢𝐓𝐮𝐧𝐞𝐬: https://itunes.apple.com/us/artist/peter-luha/563042778 𝐘𝐨𝐮𝐭𝐮𝐛𝐞: https://youtube.com/peterluha =============================== ▶ Feel free to write me for 𝗢𝗡𝗟𝗜𝗡𝗘 𝗚𝗨𝗜𝗧𝗔𝗥 𝗟𝗘𝗦𝗦𝗢𝗡𝗦: https://peterluha.com/online-guitar-lessons ▶ Check out my website for downloadable eBooks/pdf - 𝗚𝗨𝗜𝗧𝗔𝗥 𝗟𝗘𝗦𝗦𝗢𝗡𝗦 & 𝗦𝗢𝗡𝗚𝗦 with 𝗧𝗔𝗕𝗦: https://peterluha.com/product-category/sh… | ["Bass guitar", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["bass guitar", "slap bass", "energetic", "echoes", "home video", "average audio quality", "passionate", "virtuoso player", "bass guitar technique", "bass guitar demo", "instrumental music", "emotional", "romantic", "groovy", "funk bass line", "guitar accompaniment style", "instrumental music", "syncopation", "enegetic", "medium fast tempo"] | 1 | eM0PkfqGmIE | 3857 |
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;