musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "groovy", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "romantic"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Sad Classical Guitar Music - Lost Melody | The song is an instrumental. The song is in medium tempo with a classical guitar playing a lilting melody in accompaniment style. The song is emotional and romantic. The song is a romantic instrumental song. | 2013-10-16T02:38:43Z | Graham Daniel McLaughlin | Instruments used: Acoustic Guitar (Classical), Violin Soundcloud: https://soundcloud.com/graham-daniel-mclaughlin/sad-classical-guitar-music (Free Download) Spotify: https://open.spotify.com/track/5KceXwi3K9TiRaw6JCbB0I Apple Music: https://music.apple.com/us/album/lost-melody/1457733757?i=1457733762 iTunes: https://music.apple.com/us/album/lost-melody/1457733757?i=1457733762&app=itunes Amazon Music: https://music.amazon.com/albums/B07Q2KSY5S?trackAsin=B07Q2KF8RW&ref=dm_sh_b07e-7fb5-dmcp-49ae-e76f6&musicTerritory=US&marketplaceId=ATVPDKIKX0DER Facebook: https://www.facebook.com/DreamsOfGraham Guitar Tabs: https://docs.google.com/document/d/14OOCK3J1SYLxRuwKfnAvQcS70mbRWrJ6eQuIY5Bf20E/edit?usp=sharing ______________________________ Made this song today, just thinking about schooling and all what's expected of people to be part of a society. Sometimes I just can't live up to the robotic terms, and I may end up creating stuff like this. ______________________________ All audio material owned by © Graham Daniel McLaughlin ℗ Graham Daniel McLaughlin Song inspired by this artwork: http://reyed33.deviantart.com/art/1-Lost-Melody-207902132 The artist of the picture used is unknown, I really wish I could give them credit and a thanks. I downloaded it from nik.bot.nu. | ["Music", "Sad music"] | ["spanish guitar", "guitar solo", "soloist", "emotional music", "beautiful landscapes", "twilight", "pleasant", "the good life", "instrumental hits", "celtic music", "classical guitar hits", "harmony", "instrumental music", "fret noises", "emotional", "relaxing", "in love with you", "melancholic", "life is beautiful", "comforting", "romantic", "groovy"] | 1 | KHjEIheD-Cg | 2072 | |
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 | |
Kitty (Pogues Cover) | The song is an instrumental. The song is medium tempo with an accordion playing in an accompaniment style with both medley and harmony and no other instrumentation. The music is romantic and melancholic. The audio quality is poor. | 2007-08-03T07:52:34Z | Hale Bopp | A cover of the song Kitty by the incredible Irish punk band The Pouges on my accordion. (in a different key though) Lyrics: Oh Kitty, My Darling, remember That the doom will be mine if I stay 'Tis far better to part, though it's hard to Than to rot in their prison away 'Tis far better to part, though it's hard to Than to rot in their prison away So softly he kissed her pale lips 'Twas the same story over an o'er Hush Mavourneen, the Police are watching And you know that I must go ashore Hush now Bernie, the Police are watching And you know that I must go ashore Any day I'll be over the mountain There'll be time enough left for to cry So good night and God gaurd you forever And write to me once you get by So good night and God gaurd you forever And write to me once you get by | ["Accordion"] | ["accordion player", "accordion harmony", "youtube music video", "accordion lessons", "high gain music", "bad audio quality", "soloist", "home recording", "slow tempo", "lilting music", "emotional", "cheerful", "melancholic", "groovy", "romantic", "instrumental music", "emotional", "screechy tones"] | 1 | o1E579RL33w | 4603 |
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;