musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "melancholic", musiccaps_aspects contains "piano" 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 |
---|---|---|---|---|---|---|---|---|---|---|
เพลงจาก Silence of Love โฆษณาไทยประกันชีวิต | This is an advertisement jingle music piece. It is an instrumental piece. The main theme is being played by the piano while there is a synth string sound in the melodic background. There is an emotional, heart-touching atmosphere. This piece could be used in the soundtrack of a drama movie during scenes of tragedy. It could also work well as an advertisement jingle where there is an attempted appeal to emotion. | 2011-07-29T14:09:42Z | Verynoobest | - เพลงประกอบโฆษณาไทยประกันชีวิต Silence of Love - เพลงนี้ชื่อว่า Ee Jook Il Nom Eh Sarang (เป็น Instrumental Version) ของ Lee Soo Young เป็นเพลงประกอบซีรีย์เกาหลี A Love to kill / แค้นเพื่อรัก หรือที่เป็นเวอร์ชั่นไทยก็คือเพลง ผิดที่เธอ ของ ปนัดดา เรืองวุฒิ ครับ ู^ ^ | ["Music", "Sad music"] | ["advertisement jingle", "no singer", "instrumental", "piano", "synth strings", "emotional", "melancholic", "heart-touching"] | 9 | 5ieMy-PAKA0 | 687 | |
1 year on T Picture and Video Montage | This is an edited version of a pop music piece. The song is in minor key which gives it a melancholic aura. There is a male vocalist singing emotionally in a sigh-like manner accompanied with a piano tune and atmospheric strings in the background. However, due to the artificially added gain, the piece is too loud and the audio is distorted. | 2010-12-13T03:56:54Z | ThatsWickedFunny | No copyright infringement intended.** 1 year on Testosterone. WOW. What an amazing and remarkable year. It was unforgettable and I am so thankful to everyone who has stuck by my side through all I have endured this past year-both the good, and bad. I have not only become complete as becoming my individual self inside and out, but I have realized who my true friends are and who truly is genuine. I have met some amazing new people that have become close, basically family and I am blessed. I am now engaged to my wonderful Fiance Kelsey, and can honestly say that I am on my way down the right path to ultimate happiness and success. It takes courage to travel through this journey, to face it head on, to no longer avoid what is so special- that of which you are. I am now seen as a son, a brother, nephew, their "boy" and a Fiance soon to be husband. I uploaded this video to show everyone how far I have come and where I continue to go. Everyone has a past and I am not ashamed for I always knew who I was. Thank you so much youtube, and to all of my subscribers and guys on here in our community who have watched my videos, helped me out tremendously with their own transitions that they shared, and have come together to learn from each other. I love you all. | ["Music", "Harmonic"] | ["pop music", "male vocal", "sigh-like singing", "melancholic", "piano", "strings", "loud", "distorted", "emotional"] | 9 | cf-IIqhveKw | 3729 | |
Hästpojken Gitarrer & Bas, Trummor & Hat | The male voice singing sounds emotional and sad while a piano is playing a minor chord progression along with an acoustic guitar strumming chords. Then a fat sounding acoustic drum comes in with a simple groove along with an e-bass. This song may be playing on headphones while sitting in the bus riding downtown being lost in thoughts. | 2009-11-26T17:51:55Z | TussilagoSwe | Hästpojken Gitarrer & Bas, Trummor & Hat. Musikvideo: Tussilago, Theo Gabay Skivbolag: Roxy Recordings | ["Music", "Independent music", "Song"] | ["pop/rock/ singer-songwriter", "piano", "acoustic guitar", "acoustic drums", "male voice singing", "higher register", "emotional", "melancholic", "medium tempo"] | 6 | qRCjs90-1RQ | 4784 |
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;