musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "home video", musiccaps_names contains "Guitar" and musiccaps_names contains "Music"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Fender FSR Limited Edition Deluxe Reverb RI | A male guitarist plays a cool guitar like on an electric guitar. The song is medium tempo with a guitar solo with heavy a[echoes played though a guitar amplifier and no other instrumentation. The song is bluesy and passionate. The song is a casual blue slick played on a guitar. | 2012-05-09T06:39:38Z | Thomas Fargo | Testing the amp with Lollar P-90s | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument"] | ["home video", "poor audio quality", "sound check", "deep", "emotional", "passionate", "blues influences", "instrumental music", "guitar solo", "tremolo effect", "guitar amplifier", "guitar lead", "echo tone", "solo guitar", "bad audio recording", "no other instrumentation", "guitar technique", "moody blues", "spirited", "passionate", "medium tempo", "blues lick"] | 1 | 6_zzu2KON6c | 768 | |
| ギター レスポールを弾いてみた | The song is an instrumental guitar solo. The song tempo is medium with a racy electric guitar solo with a show of technique of note bending, tremolo and playing rhythmically. The song is home video and an average quality recording. | 2013-05-08T08:11:45Z | RDRGuitarBass | エレキギター RDRを弾いてみた | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Distortion"] | ["electric guitar lead", "note bending", "playing rhythm guitar", "solo guitarist", "soloist", "no other instrumentation", "no percussions", "home video", "poor quality video", "guitar technique", "guitar a", "plification", "medium tempo", "spirited", "emotional", "youthful", "groovy", "energetic"] | 1 | 7V0G65FK2VQ | 850 | |
| 1964 Fender Deluxe Reverb + 1999 Fender 52 Vintage Telecaster Part2 | The song is an instrumental. The song is medium tempo with a guitar playing solo accompaniment style, with a subtle bass line. The song is entertaining and passionate. The song audio quality is poor with a lot of ambient echoes. | 2010-03-17T17:54:45Z | GregsGuitars | 1964 Fender Deluxe Reverb is an original vintage amp - not Reissue. Tele has a Texas Special Pickup at the neck and a nocaster bridge pickup. Okko Diablo Custom made overdrive pedal with 3 channels www.gregorhilden.de | ["Reverberation", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental music", "poor audio quality", "guitar solo", "ambient echoes", "guitar played accompaniment style", "guitar amplifier", "tone generator", "subtle bass line", "home video", "youtube music video", "soloist", "guitar solo", "exciting", "adventurous", "guitar demo", "passionate", "medium tempo", "emotional", "adventure music"] | 1 | DUNOn71oGCw | 1482 | |
| 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;