musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "medium fast tempo" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- groovy · 3 ✖
- medium fast tempo · 3 ✖
- passionate 3
- emotional 2
- instrumental music 2
- romantic 2
- average audio quality 1
- backup singers 1
- bass guitar 1
- bass guitar demo 1
- bass guitar technique 1
- booming bass line 1
- crooners 1
- dance with you all night 1
- echoes 1
- electric guitar player 1
- enegetic 1
- energetic 1
- excited 1
- exciting 1
- finale singer 1
- funk bass line 1
- groovy music 1
- guitar accompaniment style 1
- guitar demonstration 1
- guitar lessons online 1
- guitar licks 1
- guitar rhythm 1
- guitar solo 1
- guitarist 1
- home video 1
- inspiring 1
- i’m in love 1
- love sing 1
- love song 1
- medium fats tempo 1
- modern day romance 1
- percussive bass line 1
- positive 1
- retro love songs 1
- retro pop 1
- riffs 1
- slap bass 1
- soloist 1
- soul singer 1
- steady drumming rhythm 1
- strumming rhythm 1
- syncopation 1
- together forever 1
- virtuoso player 1
- youthful 1
- youtube music video 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bill Lawrence "Wilde" L-45 pickups | The song is an instrumental. The song is medium tempo with an electric guitar playing guitar riffs with a nice low end; The audio quality is average. The song is passionate and exciting. | 2010-06-03T01:03:09Z | Flagrant Potato | Playing starts at 2:25. Quick sound test of the Bill and Becky "Wilde" L-45 strat pickups in my Warmoth guitar. Alnico V magnets, dual rail pole pieces (flat). Guitar is 1pc alder body with a goncalo alves neck and ebony fretboard. Guitar is plugged straight into a Yamaha Fifty (G50) 410 combo and was recorded with an active dual-ribbon mic. | ["Reverberation", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["electric guitar player", "guitarist", "riffs", "guitar licks", "passionate", "exciting", "guitar lessons online", "soloist", "youtube music video", "guitar demonstration", "excited", "positive", "medium fast tempo", "groovy music", "inspiring", "inspiring", "guitar solo", "medium fats tempo", "strumming rhythm", "groovy", "booming bass line", "instrumental music"] | 1 | Ta0GmXPnGWk | 2847 | |
Northern Soul .. I'll never stop loving you. | A female singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a percussive bass line, groovy drumming rhythm, keyboard accompaniment and other percussive hits. The song is a retro pop love song. | 2010-12-15T10:18:33Z | docludi | Once acclaimed the Queen of Memphis Soul. Carla Thomas, daughter of Rufus Thomas was born on December 21, 1942 in Memphis, Tennessee. This 1963 Fantasy recording remained unreleased until 1991. "I'll never stop loving you" Video excerpts from Story of the Who, Quadraphenia and other scooter oddments of the period. Twisted Wheel website. http://www.twistedwheel.co.uk | ["Music", "Ska"] | ["finale singer", "retro pop", "backup singers", "passionate", "love sing", "together forever", "i’m in love", "dance with you all night", "modern day romance", "youthful", "soul singer", "percussive bass line", "steady drumming rhythm", "guitar rhythm", "groovy", "romantic", "emotional", "love song", "retro love songs", "crooners", "medium fast tempo"] | 1 | ZwLfj7tvpdc | 3427 | |
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;