musiccaps_details (view)
10 rows where musiccaps_aspects contains "melancholic", musiccaps_aspects contains "romantic" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 121 ✖
- melancholic · 10 ✖
- romantic · 10 ✖
- sentimental 7
- slow tempo 7
- emotional 6
- love song 6
- instrumental 4
- mellow 4
- dulcet 3
- keyboard accompaniment 3
- nostalgic 3
- pensive 3
- simple melody 3
- soft 3
- dreamy 2
- female singer 2
- foreign language 2
- male singer 2
- medium tempo 2
- mellifluous 2
- melodic 2
- minimalist 2
- poignant 2
- pop 2
- rhythmic acoustic guitar 2
- sad 2
- violin harmony 2
- wistful 2
- young love 2
- acoustic 1
- acoustic guitar 1
- acoustic guitar accompaniment 1
- acoustic music 1
- alternative rock 1
- amateur recording 1
- ambient 1
- asian music 1
- bass guitar accompaniment 1
- beautiful 1
- blues 1
- blues lessons 1
- buskers 1
- busking 1
- cajun percussion 1
- captivating 1
- cello 1
- classic pop 1
- classic rock 1
- country folk song 1
- country hits 1
- country music 1
- country pop 1
- dissonant harmony 1
- earnest 1
- electric guitar lead 1
- electric guitar lesson 1
- electric guitar melody 1
- elvis presley 1
- emphatic lead 1
- ethereal 1
- euphonious 1
- exquisite 1
- female vocalist 1
- fiddle 1
- first love 1
- fluid 1
- flute 1
- folk rock 1
- geek rock 1
- groovy 1
- groovy bass line 1
- groovy bass lines 1
- heart break 1
- introspective 1
- jazz 1
- keyboard accomapniment 1
- keyboard harmony 1
- lonely 1
- male vocalist 1
- mellow acoustic guitar 1
- melodic electric guitar lead 1
- melodic violin harmony 1
- melodious 1
- middle eastern influences 1
- mood 1
- nostalgia 1
- pain 1
- passionate 1
- performance 1
- piano accompaniment 1
- pleasant 1
- pop rock 1
- r&b 1
- reflective 1
- regional pop 1
- retro pop 1
- rock and roll 1
- rock music 1
- romantic pop 1
- sentimental nostalgic 1
- serene 1
- simple 1
- simple harmony 1
- soft piano accompaniment 1
- soft pop 1
- soft rock 1
- somber 1
- song cover 1
- song introduction 1
- soundtrack 1
- steady bass lines 1
- steady bassline 1
- steady drumming 1
- story telling 1
- straightforward drumming 1
- string harmony 1
- string orchestra 1
- subtle bass line 1
- unplugged 1
- viola 1
- violin 1
musiccaps_names (array) 14 ✖
- Music 9
- Sad music 3
- Blues 1
- Electric piano 1
- Exciting music 1
- Guitar 1
- Keyboard (musical) 1
- Musical instrument 1
- Piano 1
- Plucked string instrument 1
- Swing music 1
- Tender music 1
- Tick 1
- Wedding music 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 | |
Pumped up Kicks Jazz Style | A male vocalist sings this mellow country song. The tempo is medium with fiddle, cello and viola harmony with acoustic guitar rhythm.The song is mellow, soft, dulcet,emotional , melancholic and nostalgic . This song is Country Pop. | 2013-07-10T00:12:19Z | Red Soda Band | A jazz style cover of Pumped up Kicks by Foster the People. This is quite a controversial tune but has been very popular for a long time which is why we recorded a cover version of it. Pumped Up Kicks Lyrics (Foster the People) Robert's got a quick hand. He'll look around the room, he won't tell you his plan. He's got a rolled cigarette hanging out his mouth, he's a cowboy kid. Yeah, he found a six shooter gun in his dad's closet hidden with a box of fun things. And I don't even know what but he's coming for you, yeah, he's coming for you. [Chorus 2x:] All the other kids with the pumped up kicks you better run, better run, outrun my gun. All the other kids with the pumped up kicks you better run, better run faster than my bullet. Dad -- he works a long day. He'll be coming home late, he's coming home late. And he's bringing me a dark surprise. 'Cause dinner's in the kitchen and it's packed in ice. I've waited for a long time. Yeah, the sleight of my hand is now a quick-pull trigger. I reason with my cigarette And say, "Your hair's on fire, you must have lost your wits, yeah." [Chorus 2x:] All the other kids with the pumped up kicks you better run, better run, outrun my gun. All the other kids with the pumped up kicks you better run, better run faster than my bullet. Ru-ru-run, run, run, run [4x] [Whistling] [Chorus 4x:] All the other kids with the pumped up kicks you better run, better run, outrun my gun. All the other kids with the pumped up kicks you better run, better run faster than my bullet. Live Wedding Band: https://redsoda.com Wedding Entertainment: https://www.facebook.com/RedSodaBand/ Wedding Singers: https://www.instagram.com/redsodaband/ Sydney Wedding Band: https://www.google.com/maps/place/Red+Soda+Band+Sydney/@-33.9118834,151.1329694,15z/data=!4m2!3m1!1s0x0:0xb2508b5ae82a53cf?sa=X&ved=2ahUKEwjuvcT3pbbwAhXpwjgGHVUtCfMQ_BIwGHoECCMQBQ Phone: 02 8006 2234 | ["Music", "Wedding music"] | ["male singer", "medium tempo", "violin", "country music", "sentimental", "melancholic", "string orchestra", "string harmony", "country folk song", "country hits", "country pop", "regional pop", "fiddle", "cello", "viola", "acoustic guitar", "dulcet", "mellifluous", "mellow", "emotional", "romantic", "dreamy", "sentimental nostalgic", "story telling", "performance"] | 7 | 40xkia7fwEM | 534 | |
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 | |
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 | |
Blues Guitar Lesson Larry Carlton @ Videoguitarlessons.com | This music is instrumental , the tempo is slow with an electric guitar lead and a strong bass guitar accompaniment. The music is assertive and emphatic but sounds sad, melancholic,nostalgic, romantic , wistful and sentimental. This music is Blues Harmony. | 2008-03-20T18:05:26Z | eikohtiek | This is a blues jam that Larry did for my favorite website. A little taste of what kinds of things you can learn from his course. Larry is a master of Blues, Jazz, and fusion. He's played on some of your favorite Rock and Roll tracks too such as Steely Dan's, "Kid Charlemagne," He has shared studios and stages with the like of The Crusaders, Joni Mitchell, Sammy Davis Jr., Quincy Jones, John Lennon, Jerry Garcia, Michael Jackson, Stanley Clark, Billy Cobham, Bobby Bland, and many more. He also plays in the group Fouplay with Nathan East, Bob James, and Harvey Macon. I have taken these lessons and they really show you how to phrase well and make every note count. | ["Blues", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "slow tempo", "electric guitar lead", "melancholic", "nostalgia", "sad", "wistful", "romantic", "sentimental", "emotional", "bass guitar accompaniment", "groovy", "blues", "r&b", "jazz", "dissonant harmony", "melancholic", "somber", "blues lessons", "electric guitar lesson", "simple melody"] | 7 | NlUf1ppoSG4 | 2359 | |
Walking On Cars - Tick Tock (acoustic) 4.2.16 | A male vocalist sings this soft pop. The tempo is slow with a simple piano accompaniment, mellow acoustic guitar and rhythmic Cajun beats. The song is a simple, unaffected, romantic, melodic, sentimental, emotional and pensive Pop. | 2016-02-05T11:40:49Z | Kerri Loughney | Walking On Cars performing an acoustic version of Tick Tock from their new album Everything This Way. Performed in Banquet Records, Kingston for the album release on the 4th of February 2016. Enjoy! Check out my other videos from the Walking On Cars acoustic in-store show at Banquet Records: Always Be With You - https://www.youtube.com/watch?v=FG-wYSnmEwo Hand In Hand - https://www.youtube.com/watch?v=oaEMyV_dOXw Flying High Falling Low - https://www.youtube.com/watch?v=6M6AcVAQJMI Catch Me If You Can - https://www.youtube.com/watch?v=6nhEE5NpglQ Speeding Cars - https://www.youtube.com/watch?v=1YDNRlYRahs Plus check out Banquet's videos from the night! In-store - https://www.youtube.com/watch?v=aid6nk5I5Bw New Slang - https://www.youtube.com/watch?v=e-WkwnHWUJE | ["Music", "Tick"] | ["male vocalist", "slow tempo", "acoustic", "minimalist", "busking", "buskers", "simple", "earnest", "emotional", "sentimental", "keyboard accompaniment", "mellow acoustic guitar", "cajun percussion", "soft", "melancholic", "romantic", "pensive", "unplugged", "amateur recording"] | 7 | UDN11Q90Fa4 | 2895 | |
Ritchie Valens "MEMORIES" ((R.I.P.Tribute)) | This song is an instrumental. The tempo is medium with a melodious lead on the electric guitar, steady drumming, groovy bass lines and acoustic guitar accompaniment. The melody is simple, mellow, pleasant, melancholic, nostalgic and ambient. This instrumental song is a Classic Rock and Roll. | 2008-02-16T02:42:07Z | JESSE OROS | R.I.P.†DOLORES MARTINEZ† 12/26/12 QUERIDA MADRE http://www.ritchievalens.com/ Ritchie Valens "MEMORIES" (SLEEP-WALK) | ["Swing music", "Music"] | ["retro pop", "slow tempo", "instrumental", "acoustic guitar accompaniment", "emphatic lead", "simple melody", "dulcet", "mood", "fluid", "romantic", "ambient", "melodic electric guitar lead", "steady drumming", "groovy bass lines", "acoustic guitar accompaniment", "mellow", "soft", "pleasant", "melancholic", "nostalgic", "rock and roll"] | 7 | xKc_9B3RiOc | 5318 |
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;