musiccaps_details (view)
1 row where musiccaps_aspects contains "melodic piano playing", musiccaps_author = 3 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 |
---|---|---|---|---|---|---|---|---|---|---|
Yiruma - Kiss the Rain - Piano Tutorial - How to Play + Sheet Music | This is an emotional, melodic piano piece. It brings about sombre and reflective feelings. It has a slow tempo, and it is not intricate but it is captivating. The empty spaces between the motifs allows for thoughts to flow. | 2012-02-12T10:37:07Z | DPSM | Kiss the Rain piano tutorial & Kiss the Rain piano sheet music ✔ Sheet music: http://bit.ly/2tiCe8H ✔ Want to get the midi file? Please, consider to donate: http://bit.ly/donatemidi. Don't forget to type the title of the song while donating. ✔ The quickest and simplest way to learn piano: http://bit.ly/dpsmflowkey ✔ Beginner? Download this free app: http://m.onelink.me/93043514 ✔ Deep and thorough lessons to learn piano for all genres: http://bit.ly/dpsmpianoforall ✔ Support me on Patreon and get rewards: https://bit.ly/dpsmpatreon ✔ Follow me on Facebook: http://bit.ly/dpsmfacebook ✔ Follow me on Instagram: https://bit.ly/dpsminsta ✔ Follow me on Loudr: https://bit.ly/dpsmloudr Keep in mind that you are free to change a part of the arrangement to suit your skill / technique, needs or even taste. Feel free to post your rendition of this arrangement on YouTube or use it as an accompaniment to your singing if you're doing a song cover. Just put a link back to my video or my channel in your video description. Don't forget to poke me, I'd love to see them. If you want different piano tutorials from the one I have uploaded, feel free to leave a comment in the comment section or just hit the thumb of an existing comment so that I can figure out what songs you need me to make the tutorial videos. I am unable to assure that I will be able to get to them but I will at the very least give some thought to your recommendations. It takes many hours to make such tutorial video and it takes only few seconds to thumb up. :) Happy learning and don't forget to subscribe. I do not own the song. All credits go to the respective owners. © If you think you are the copyright holder of any of the footage, material used in this video just email me at: [dpsmpianist@gmail.com] and let's resolve the situation. Likewise, I will delete them ASAP if you ask me to. | ["Music", "Sad music"] | ["melodic piano playing", "sombre piano playing", "slow melody", "slow tempo", "reflective"] | 3 | 2y1QnNBaxAU | 424 |
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;