musiccaps_details (view)
8 rows where musiccaps_aspects contains "love song" and musiccaps_aspects contains "melancholic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 104 ✖
- love song · 8 ✖
- melancholic · 8 ✖
- romantic 6
- emotional 5
- sentimental 5
- slow tempo 4
- keyboard accompaniment 3
- poignant 3
- alternative rock 2
- classic rock 2
- female singer 2
- foreign language 2
- heart break 2
- instrumental 2
- lonely 2
- medium tempo 2
- mellow 2
- melodic 2
- nostalgic 2
- passionate 2
- pensive 2
- pop 2
- rhythmic acoustic guitar 2
- sad 2
- violin harmony 2
- young love 2
- acoustic music 1
- alternative dance 1
- asian music 1
- beautiful 1
- breakup 1
- captivating 1
- classic composers 1
- classic pop 1
- conductor 1
- dance like 1
- dreamy 1
- dulcet 1
- dynamics 1
- electric guitar melody 1
- elvis presley 1
- engaging 1
- enthusiastic 1
- ethereal 1
- euphonious 1
- exquisite 1
- female vocalist 1
- first love 1
- flute 1
- folk rock 1
- forever classics 1
- funk rock 1
- funky bass lines 1
- geek rock 1
- groovy bass line 1
- groovy electric guitar lead 1
- in love 1
- incessant 1
- infectious drumming 1
- instrumental music 1
- introspective 1
- keyboard accomapniment 1
- keyboard harmony 1
- lullaby 1
- male singer 1
- male vocalist 1
- medium fast tempo 1
- mellifluous 1
- melodic violin harmony 1
- melodious 1
- middle eastern influences 1
- minimalist 1
- pain 1
- piano accompaniment 1
- piano playing 1
- piano solo 1
- poor audio quality 1
- pop rock 1
- quirky music 1
- reflective 1
- repetitive 1
- rhythmic 1
- rock music 1
- romantic pop 1
- serene 1
- simple harmony 1
- simple melody 1
- soft 1
- soft piano accompaniment 1
- soft pop 1
- soft rock 1
- song cover 1
- song introduction 1
- soundtrack 1
- steady bass lines 1
- steady bassline 1
- straightforward drumming 1
- subtle bass line 1
- vocal backup 1
- western classical masterpieces 1
- western classical music 1
- winter 1
- wistful 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
خالد برزنجي . موسيقى خواطر khalid barzanji.. khawater music .. | This music is a mellow, dulcet instrumental. The tempo is slow with a beautiful violin harmony, piano accompaniment and steady bassline with synthesiser arrangements. The music is serene, calming,soothing, sentimental,emotional, wistful,poignant,melancholic and euphonious. This song is an exquisite middle eastern instrumental. | 2012-11-15T13:15:33Z | khalid barzanji | موسيقى خواطر توزيع وعزف خالد برزنجي لحن المنشد الاماراتي احمد بوخاطر | ["Music", "Sad music"] | ["instrumental", "slow tempo", "ethereal", "exquisite", "middle eastern influences", "euphonious", "poignant", "reflective", "violin harmony", "piano accompaniment", "steady bassline", "beautiful", "serene", "mellifluous", "dulcet", "serene", "melancholic", "romantic", "wistful", "love song", "captivating"] | 7 | 1FnT0RrfMEA | 251 | |
戴愛玲Princess Ai 《This Is How a Heart Breaks》Official Music Video | A female vocalist sings this melancholic melody in a foreign language.The tempo is slow with a romantic piano accompaniment. The song is soft, mellow, poignant, emotional,sentimental, romantic, melancholic , sad, lonely,and wistful. This song is a Pop/ Love song. | 2015-08-31T14:00:00Z | 戴愛玲 Princess Ai | 以鋼琴開場的心碎,像是在心臟的哀傷悠悠地發出悲鳴;微弱的求救聲,在迴盪。戴愛玲用最細微的嗓音輕唱著心碎的聲音,像下雪的聲音,寧靜卻深深落在心底。歌曲以豐富的編曲層次烘托著愛玲的歌聲,從最小的聲量,到最高亢的吶喊,用獨特的音樂意識形態,呈現出心碎的意象,而名詞人姚若龍的歌詞,更是以充滿詩的文字,描繪出唯美而殘酷,浪漫而痛楚的愛戀心情。 這首是戴愛玲專輯裡最愛的一首歌,更難得的是這首歌的製作人是「對的人」、「千年之戀」的製作人Keith,也是錄音過程耗時最久的一首,當初在北京錄完後,回來台北,因為環境改變、空氣改變,聽了又覺得可以升key再重錄;而這首歌的合聲更是特別以美聲天籟的方式,營造出一種晶瑩剔透、天堂般的感覺,讓戴愛玲非常喜愛,沒有用太多的歌唱技巧,只是很直接的用歌聲表達出情緒,讓戴愛玲錄得很快,也因此錄了很多版本,讓她覺得錄得很過癮! ●戴愛玲 Princess Ai 官方Facebook● https://www.facebook.com/sonyprincesstai ●戴愛玲 Princess Ai 官方微博● http://www.weibo.com/u/1781184057 線上購買 ◎iTunes https://goo.gl/Ok3AE1 ◎kkbox http://goo.gl/5JBwmp ◎Mymusic http://goo.gl/gXZUjT ◎Omusic http://goo.gl/FhVZTV ●更多活動詳情請上● Sony Music官方網站 http://www.sonymusic.com.tw/main Sony Music Taiwan CPOP-華語粉絲團 https://www.facebook.com/sonymusiccpop 作詞:姚若龍/李華章 作曲:李華章 First you say First you say I love you 我深信不疑 和世界對賭 苦也不肯服輸 加倍付出了全部 看愛的狂徒感動哭 自認選了對的路 This is how a heart breaks 深情的人逃不過落淚 This is how a heart breaks 太過逞強注定會破碎 越愛越頭痛欲裂~ 還想醉~ A second chance A second chance I give you 渴望幸福 不就得執著守護 重溫你擁抱的濃度 最美好的回憶是魔術 讓新謊言 都像諾言 禮物 This is how a heart breaks 天使放膽愛上了魔鬼 This is how a heart breaks 迷信的直覺竟然是錯覺 再浪漫的人 也要面對 愛從來不能 克服一切 Hum… | ["Music", "Sad music"] | ["female singer", "slow tempo", "soft piano accompaniment", "lonely", "pain", "heart break", "sad", "pop", "dreamy", "love song", "young love", "emotional", "sentimental", "foreign language", "romantic", "lonely", "melancholic", "pensive", "pop"] | 7 | 1IK4OeOqAEo | 253 | |
Swan Lake for piano, Tchaikovsky + sheet music | The song is instrumental music. The song is medium tempo with just a piano playing pensively and no other instrumentation. The song is emotional and poignant. The song is a western classical masterpiece, but with bad audio quality issues. | 2011-01-22T16:54:57Z | ken | Swan Lake by Tchaikovsky. Sheet music available here: https://sowl.co/bgZ9cg | ["Music", "Sad music"] | ["western classical music", "poor audio quality", "poor audio quality", "western classical masterpieces", "piano playing", "love song", "forever classics", "poignant", "melancholic", "winter", "classic composers", "conductor", "piano solo", "emotional", "medium tempo", "dynamics", "instrumental music", "in love", "dance like", "lullaby"] | 1 | 1WlvXneu6oY | 284 | |
Kenny Rogers & Dolly Parton - Sometimes When We Touch | This music is a soft instrumental. The tempo is slow with a beautiful keyboard harmony. The music is soft, mellow, sentimental, nostalgic, melancholic and romantic. This song is classic pop. | 2009-06-23T23:40:32Z | Kristin Tehvan | One of the best love songs ever. | ["Electric piano", "Keyboard (musical)", "Piano"] | ["instrumental", "slow tempo", "keyboard harmony", "pop", "classic pop", "melancholic", "nostalgic", "minimalist", "song introduction", "soft", "mellow", "romantic", "melodic", "emotional", "sentimental", "love song"] | 7 | BMxgDBoPv_0 | 1233 | |
Kiss - Because I'm A Girl (Chinese Version) | A female vocalist sings this soft love song in a foreign language. The tempo is medium with a mellifluous violin harmony, keyboard accompaniment, subtle bass, steady drumming and rhythmic acoustic guitar. The song is sweet, youthful, simple, romantic, sentimental, melancholic and pensive. This song is Romantic Pop. | 2007-03-17T01:24:14Z | Joel Lee | Comments and Rating Plz.. | ["Music", "Tender music"] | ["female vocalist", "medium tempo", "foreign language", "romantic pop", "soft pop", "subtle bass line", "asian music", "soundtrack", "melodic violin harmony", "keyboard accompaniment", "flute", "romantic", "love song", "young love", "first love", "sentimental", "nostalgic", "pensive", "melancholic", "rhythmic acoustic guitar"] | 7 | FGoDfNZezh0 | 1632 | |
CAKE - Never There (Official HD Video) | A male vocalist sings this quirky Rock melody. The tempo is medium fast with groovy electric guitar harmony, funky, intense bass lines, infectious drumming, keyboard accompaniment and vocal backup. The song is catchy, rhythmic, emotional, incessant, sentimental, melancholic, lonely, romantic , unconventional, quirky and upbeat. This song is classic rock. | 2011-03-18T00:20:30Z | CakeVEVO | ”Never There” by CAKE in HD Listen to CAKE: https://Cake.lnk.to/listenYD Watch more videos by CAKE: https://Cake.lnk.to/listenYD/youtube Subscribe to the official CAKE YouTube channel: https://Cake.lnk.to/subscribeYD Follow CAKE Facebook: https://Cake.lnk.to/followFI Instagram: https://Cake.lnk.to/followII Twitter: https://Cake.lnk.to/followTI Website: https://Cake.lnk.to/followWI Spotify: https://Cake.lnk.to/followSI YouTube: https://Cake.lnk.to/subscribeYD Ask your voice device to play CAKE! Lyrics: Never there You're never there You're never ever, ever, ever there Hey! #CAKE #NeverThere #OfficialHDVideo #HD #Remastered #ProlongingTheMagic #Rock | ["Funk", "Music"] | ["male vocalist", "medium fast tempo", "vocal backup", "funky bass lines", "groovy electric guitar lead", "keyboard accompaniment", "infectious drumming", "passionate", "emotional", "sentimental", "love song", "alternative rock", "funk rock", "alternative dance", "rhythmic", "melancholic", "sad", "lonely", "repetitive", "incessant", "breakup", "heart break", "classic rock", "quirky music", "engaging", "youthful", "enthusiastic"] | 7 | FRZzUh9hcTo | 1642 | |
Barenaked Ladies - Sound of Your Voice [Official Music Video] | A male vocalist sings this simple pop. The tempo is medium with an electric guitar melody, keyboard accompaniment, steady drumming, steady bass lines and acoustic guitar rhythm. The song is a simple, melodic, earnest, engaging Soft Rock; | 2007-02-06T16:45:04Z | Barenaked Ladies (official) | "Sound of Your Voice" by Barenaked Ladies from Barenaked Ladies Are Men, available now. Download on iTunes: http://smarturl.it/kk3vd8 Links: http://www.facebook.com/barenakedladies http://twitter.com/barenakedladies "Sound Of Your Voice" Lyrics: The moon is full but there is an incompleteness The days are beautiful but I feel a bitter sweetness If I had a wish, or even a choice I'd wake up to the sound of your voice How I miss waking up to the sound of your voice I let you down and fell right off of your good list I hope each day you'll find peace and forgiveness The alarm clock rings, What a lonely noise And I long for the sound of your voice Oh, how I miss waking up to the sound of your voice Take it from me: there's not much to see In this void The saying goes there will be other dances (don't give up) This little song is about second chances Just say the word and I will rejoice And wake up to the sound of your voice Oh, how I miss waking up to the sound To the sound (sound) To the sound (to the sound) To the sound Waking up to the sound of your voice Take it from me: there's not much to see In this void Subscribe to Nettwerk's YouTube channel: http://smarturl.it/nettwerkyoutube | ["Music", "Exciting music"] | ["male singer", "electric guitar melody", "folk rock", "pop rock", "rock music", "acoustic music", "alternative rock", "introspective", "melancholic", "poignant", "geek rock", "simple harmony", "classic rock", "straightforward drumming", "keyboard accompaniment", "simple melody", "soft rock", "pop rock", "mellow", "melodic", "romantic", "love song", "steady bass lines"] | 7 | FoFMRXlNJ6Y | 1666 | |
"And I love You So" - ( Elvis Presley and Gigliola Cinquetti ) | A female vocalist sings this romantic love song. The tempo is slow with a melodic violin harmony, groovy bass line, rhythmic acoustic guitar and keyboard accompaniment. The song is soft, mellow, romantic, emotional, sentimental, melancholic and gentle. This. The song is a cover of a Classic Elvis Presley song. | 2012-06-11T17:01:57Z | LeCommedieDellArte | "And I love You So" - ( Elvis Presley and Gigliola Cinquetti ) (Songwriters: MCLEAN, DON ) And I love you so, The people ask me how, How I've lived till now I tell them I don't know I guess they understand How lonely life has been Life began again The day you took my hand And yes I know how lonely life can be The shadows follow me And the night won't set me free But I don't let the evening get me down Now that you're around me And you love me too Your thoughts are just for me You set my spirit free I'm happy that you do The book of life is brief Once the page is read All but love is dead This is my belief And yes I know how lonely life can be The shadows follow me And the night won't set me free But I don't let the evening get me down Now that you're around me | ["Music", "Sad music"] | ["female singer", "slow tempo", "violin harmony", "song cover", "elvis presley", "love song", "sentimental", "emotional", "melancholic", "melodious", "groovy bass line", "keyboard accomapniment", "romantic", "passionate", "rhythmic acoustic guitar"] | 7 | Inuq5W98ktA | 1942 |
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;