musiccaps_details (view)
7 rows where musiccaps_aspects contains "love song" and musiccaps_aspects contains "pleasant"
This data as json, CSV (advanced)
musiccaps_aspects (array) 104 ✖
- love song · 7 ✖
- pleasant · 7 ✖
- emotional 5
- romantic 5
- sentimental 4
- melodic 3
- passionate 3
- romantic piano 3
- slow tempo 3
- steady drumming 3
- ambient 2
- chimes 2
- duet 2
- dulcet 2
- foreign language 2
- gentle 2
- k-pop 2
- keyboard accompaniment 2
- korean song 2
- male singer 2
- male vocalist 2
- medium tempo 2
- piano accompaniment 2
- proposal song 2
- soft pop 2
- world music 2
- young love 2
- acoustic guitar 1
- ambient music 1
- amplified keyboard 1
- atmospheric synthesiser 1
- avant-garde 1
- avante-garde 1
- blues 1
- bongos 1
- boy band 1
- bright electric guitar 1
- buoyant 1
- cajun 1
- cajun beat 1
- calm 1
- carefree 1
- cheerful 1
- children’s song 1
- complex harmony 1
- dreamy 1
- energetic drumming 1
- enthusiastic vocals 1
- falling in love 1
- female singer 1
- female vocalist 1
- female vocals 1
- foreign music 1
- french jazz 1
- groovy bass line 1
- it’s a wonderful life 1
- jazz 1
- k-pop hips 1
- keyboard harmony 1
- korean love song 1
- lilting melody 1
- lullaby 1
- mellifluous 1
- mellow 1
- melodic piano accompaniment 1
- melodious 1
- melodious acoustic guitar rhythm 1
- minimal instruments 1
- no percussions 1
- pepeasant 1
- pop 1
- pop hit 1
- r&b 1
- retro hits 1
- retro jazz 1
- retro pop hits 1
- saxophone harmony 1
- simple 1
- simple bass lines violin hamony 1
- snare playing 1
- soft piano accompaniment 1
- soft rock 1
- soft soothing 1
- soft vocals 1
- soothing 1
- soul 1
- sound of static 1
- steady drumming rhythm 1
- straightforward bass lines 1
- string section accompaniment 1
- synchronous singing 1
- syncopated 1
- teen pop 1
- vintage jazz 1
- vintage pop 1
- violins 1
- vocal backup 1
- vocal choral harmony 1
- vocal treat 1
- vocal vibrato 1
- vocalisation 1
- wedding song 1
- youthful 1
- youtube video 1
musiccaps_names (array) 11 ✖
- Music 7
- Song 2
- Blues 1
- Happy music 1
- Independent music 1
- Lullaby 1
- Pop music 1
- Punk rock 1
- Soul music 1
- Tender music 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 |
---|---|---|---|---|---|---|---|---|---|---|
2013 Wedding Song (You Are) Derek Rusel | A male vocalist sings this soft love song. The tempo is slow with a romantic piano accompaniment, groovy bass line, steady drumming and ambient saxophone harmony. The song is a romantic, emotional, mellow, sentimental, proposal or wedding song. This song is a R&B/Soul song. | 2011-01-14T10:13:18Z | Vent Music | ["Music", "Wedding music"] | ["male singer", "slow tempo", "romantic piano", "ambient music", "saxophone harmony", "steady drumming", "groovy bass line", "r&b", "soul", "blues", "jazz", "complex harmony", "syncopated", "pleasant", "romantic", "emotional", "sentimental", "love song", "wedding song", "proposal song"] | 7 | 07xGXxIHOL4 | 125 | ||
BEAST/B2ST - Clenching A Fist Tight | A male vocalist sings this soft Korean Melody. The tempo is medium with a romantic piano accompaniment, steady drumming, simple bass lines, chimes, synthesiser arrangements and male vocal backup. The song is a soft, mellow, romantic, emotional, sentimental, dulcet, melodic love song. This song is a Korean Soft Pop/K-pop song. | 2010-09-17T04:03:08Z | megcapati | BEAST's 3rd Mini Album MASTERMIND. SUPPORT BEAST BUY BUYING THEIR 3RD MINI ALBUM MASTERMIND! :D :D :D ~~ Another awesome ballad. Perfect song to listen to if you want to cry. ~~ CHECK OUT MY OTHER VIDEOS :D Twitter: http://www.twitter.com/meggiewegsss Tumblr: http://www.meggiewegsss.tumblr.com Facebook: http://www.facebook.com/meggiewegsss B2STLYB2UTIES website coming soon~♥ Twitter: http://www.twitter.com/B2STLYB2UTIES Facebook: http://www.facebook.com/pages/B2stlyb2uties/144520828909598 Every 2 weeks is the birth of a new parody made by EMDEE Parodies ^_^v Twitter: http://www.twitter.com/EMDEEparodies YouTube: http://www.youtube.com/user/EMDEEparodies | ["Music", "Pop music", "Soul music"] | ["male vocalist", "medium tempo", "dulcet", "sentimental", "emotional", "love song", "melodic", "world music", "k-pop hips", "youthful", "young love", "soft soothing", "romantic piano", "steady drumming", "straightforward bass lines", "chimes", "atmospheric synthesiser", "boy band", "vocal backup", "ambient", "pop", "soft pop", "romantic", "pleasant", "emotional", "melodic", "foreign language", "korean song", "k-pop"] | 7 | 0F-Z0zF1504 | 138 | |
Bella's Lullaby (with lyrics) | A female vocalist sings this pleasant melody. The tempo is slow with a melodic piano accompaniment. There is minimal instrumentation with emphasis on vocals. The song is soft, mellow, soothing, calming, mellifluous, pleasant, and dreamy. This song is a love song, children’s song or a lullaby. | 2008-11-30T03:54:32Z | Camille Chen | Song: Bella's Lullaby Artist: the BELLA CULLEN PROJECT | ["Music", "Song", "Lullaby"] | ["female vocalist", "slow tempo", "vocal choral harmony", "love song", "children’s song", "calm", "soothing", "gentle", "sound of static", "dreamy", "lullaby", "melodic piano accompaniment", "amplified keyboard", "no percussions", "vocal treat", "synchronous singing", "pleasant", "mellifluous", "romantic", "passionate", "sentimental", "melodic", "simple"] | 7 | 1rhsnmWLeGw | 314 | |
[MV] 이수민, 신동우 '달리기' 뮤직비디오 ('Cheer up' Music Video) | A male vocalist sings this soft melody. The tempo is slow with soft , ambient piano /keyboard accompaniment. The song is mellow,melodic, romantic, soothing, emotional, idyllic, charming and dreamy. There is a female vocal at the onset of this clip indicating that this could be a duet. | 2016-06-08T00:07:17Z | 현대자동차그룹(HYUNDAI) | 현대자동차그룹 '현이와 대니의 뉴스룸' 의 MC 이수민, 신동우 출연! 윤상의 '달리기'를 10대의 감성으로 부른 새로운 뮤직비디오 공개! MC Lee Soo-Min, Shin Dong-Woo are on Hyundai Motor Group 'Newsroom of Hyuni and Dani'! Yoon Sang 'Cheer Up', reinterpreted in teen unique style is open! [KOR] 지겨운가요 힘든가요 숨이 턱까지 찼나요 할 수 없죠 어차피 시작해 버린 것을 쏟아지는 햇살 속에 입이 바싹 말라와도 할 수 없죠 창피하게 멈춰 설 순 없으니 단 한가지 약속은 틀림없이 끝이 있다는 것 끝난 뒤에 지겨울 만큼 오랫동안 쉴 수 있다는 것 쏟아지는 햇살 속에 입이 바싹 말라와도 할 수 없죠 창피하게 멈춰 설 순 없으니 이유도 없이 가끔은 눈물나게 억울하겠죠 일등아닌 보통들에겐 박수조차 남의 일인걸 단 한가지 약속은 틀림없이 끝이 있다는 것 끝난 뒤에 지겨울 만큼 오랫동안 쉴 수 있다는 것 It′s good enough for me bye bye bye bye "꿈을 향한 여러분의 달리기를 응원합니다." [ENG] Are you bored? Or are you tired? Otherwise are you out of breath now? Even if it is, there's no way around,cause you've already started. Even though your mouth is dried up in the middle of pouring sunshine, you can't just suddenly stop cause it will be embarrassing. The one and only promise is that you will definitely achieve something. After everything is over,you can take a rest as much as you want. Even though your mouth is dried up in the middle of pouring sunshine, you can't suddenly just stop cause it will be embarrassing. Sometimes without any reason you'll feel something is unfair, and burst into tears. For ordinary people, who are not at the top,it is not easy to get a big hand. The one and only promise is that you will definitely achieve something. After everything is over, you can take a rest as much as you want. It′s good enough for me bye bye bye bye "We support your race towards your own dream" | ["Music", "Tender music"] | ["male singer", "slow tempo", "love song", "korean song", "duet", "female vocals", "foreign language", "foreign music", "world music", "soft pop", "keyboard harmony", "ambient", "korean love song", "k-pop", "mellow", "emotional", "gentle", "melodic", "piano accompaniment", "minimal instruments", "emotional", "pleasant", "young love", "romantic piano"] | 7 | 7LGLhQFiE0s | 833 | |
Gaby Moreno - "Blues de mar" (Audio Single) | A female singer sings this beautiful vintage French melody. The song is medium tempo with a steady drum rhythm, steady bass line, piano accompaniment , string section harmony and some lush snare play. The song is romantic and cheerful with an avant-garde nature. | 2012-10-18T23:56:00Z | Gaby Moreno | @Gaby_Moreno | ["Blues", "Music"] | ["female singer", "lilting melody", "vocal vibrato", "avant-garde", "string section accompaniment", "piano accompaniment", "steady drumming rhythm", "snare playing", "retro pop hits", "avante-garde", "french jazz", "retro jazz", "pleasant", "emotional", "it’s a wonderful life", "carefree", "love song", "retro hits", "vintage pop", "vintage jazz", "cheerful", "romantic"] | 1 | DgqPgNqW2hE | 1504 | |
Pig Rock - อ่าง (SD Version) | A male singer sings this melodic pop song. The tempo is fast with an acoustic guitar accompaniment, keyboard harmony, enthusiastic electric guitar melody and intense drumming. The vocals are emphatic and the song is pleasant, catchy, melodious, youthful, buoyant and fresh. This song is Soft Rock/ Pop. | 2010-02-07T21:32:43Z | PigRockBand | PIG ROCK - Arng : The first official music video of new Thais rock band named PIG ROCK. Their first album will be launched in March, 2010. For more info please visit www.sabarnrecords.com Music Video Director / Cinematographer : Sornpat Prakaranunt | ["Music", "Punk rock", "Independent music", "Song"] | ["male vocalist", "bright electric guitar", "buoyant", "soft rock", "teen pop", "pop hit", "youtube video", "melodious acoustic guitar rhythm", "keyboard accompaniment", "pleasant", "teen pop", "love song", "passionate", "emotional", "enthusiastic vocals", "energetic drumming"] | 7 | QutCXtWmzIs | 2649 | |
Heaven - Nu Flavor(lyrics) | This song is a romantic duet.the tempo is medium with a soft keyboard harmony, steady drumming, violin harmony, chimes, Cajun beat, bongos rhythm, steady bass line and acoustic guitar .the song is a proposal song.it is romantic, emotional, passionate, soft, ambient, mellifluous and dulcet. This song is a Soft Pop song. | 2010-07-29T07:11:49Z | Escanor | Heaven, heaven oh heaven can't you help me? I looked in her eyes, now she's all I see... Heaven oh heaven can't you help me? First time i saw you girl, You turn me upside down I can't stop thinking bout you My head is spinning round I got to find away to get with you somehow Girl i'm so crazy for you You know i want you now And everyminute of every single day I'm dreaming of how it could be And everynight before i go to sleep I'm praying that soon you'll be here with me Chorus Heaven, heaven oh heaven can't you help I looked in her eyes now she's all i see Heaven oh heaven can't you help me I'm down on my knees please help me Cant fall alseep tonight I don't know what to do I hold my pillow but i wanna be holding you And when close my eyes i always see your face I know my happiness is only kiss away And every hour here in the dark Everyday of my lonely heart Tells me that i need to be with you Heaven oh heaven what can i do Chorus Heaven, heaven oh heaven can't you help me I'm giving my love for eternity Heaven oh heaven can't you help me I'm down on my knees help me Instrumental Girl i'd give anything if you were here with me Give anything you want and anything you need I never thought that i could feel the way i do But now i wanna spend the rest of my with you And every day that we are apart I'm saving this love here in my heart And every night before i go to sleep I'm praying that soon you'll be here with me Chorus Heaven, heaven oh heaven cant you help me I looked in her eyes now shes all i see Heaven oh heaven cant you help me I'm down on my knees please, heaven Heaven....(repeat until fade) Heaven by Nu Flavor Copyright not intended | ["Music", "Happy music"] | ["duet", "medium tempo", "acoustic guitar", "pleasant", "simple bass lines violin hamony", "soft piano accompaniment", "soft vocals", "vocalisation", "cajun beat", "dulcet", "steady drumming", "bongos", "keyboard accompaniment", "violins", "chimes", "cajun", "pepeasant", "love song", "romantic", "passionate", "sentimental", "proposal song", "melodious", "falling in love", "love song", "proposal song"] | 7 | e2tZmQI8ICw | 3838 |
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;