musiccaps_details (view)
5 rows where musiccaps_aspects contains "love song", musiccaps_aspects contains "romantic" and musiccaps_names contains "Happy music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 79 ✖
- love song · 5 ✖
- romantic · 5 ✖
- backup singers 3
- keyboard accompaniment 3
- medium tempo 3
- passionate 3
- vocal harmony 3
- emotional 2
- groovy bass line 2
- guitar lead 2
- keyboard harmony 2
- male singer 2
- melodious 2
- sentimental 2
- acoustic guitar 1
- average audio quality 1
- bad audio quality 1
- bongos 1
- bouncy drum rhythm 1
- cajun 1
- cajun beat 1
- cheerful 1
- chimes 1
- clapping percussions 1
- classic pop 1
- country guitar band 1
- country singer 1
- country super hits 1
- crooning vocals 1
- cymbals crashing 1
- duet 1
- dulcet 1
- electric guitar 1
- energetic 1
- entertaining 1
- falling in love 1
- female vocalist 1
- first love 1
- forgive me 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar leads 1
- guitar strumming 1
- heartfelt 1
- indonesian pop 1
- i’m sorry 1
- keybiard accompaniment 1
- latin dance song 1
- latin pop song 1
- madly in love 1
- male latin singer 1
- medium fast tempo 1
- modern country love songs 1
- modern pop hits 1
- pepeasant 1
- percussive bass line 1
- pleasant 1
- poor audio quality 1
- pop 1
- proposal song 1
- reggae music influences 1
- rhythmic acoustic guitar 1
- simple bass lines violin hamony 1
- slick percussion clicks 1
- soft piano accompaniment 1
- soft vocals 1
- steady drumming 1
- steady drumming rhythm 1
- straight drumming 1
- string section playing rhythmically 1
- strong bass line 1
- synthesiser 1
- tambourine beats 1
- together for ever 1
- violins 1
- vivacious 1
- vivid 1
- vocalisation 1
- youthful 1
musiccaps_names (array) 4 ✖
- Happy music · 5 ✖
- Music 5
- Christmas music 1
- Exciting music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
One Republic - Apologize (Lyrics) | A male singer sings this beautiful melody with backup singers in vocal harmony. The song is medium tempo with a percussive string section, strong bass line, guitar lead, steady drumming rhythm , keyboard accompaniment and various percussion clicks. The song is emotional and romantic. The song is of poor audio quality. | 2013-12-06T06:01:44Z | Giz Ruar | "Apologize" belongs to One Republic. From the "Dreaming Out Loud" album, 2006. http://onerepublic.com/ Please, suscribe to my channel. TY! My Facebook Official Page: https://www.facebook.com/GizelleSixxJ If you want a special lyric video, just let me know in a comment below the video and I'll try to make it. Thanks for watching. | ["Music", "Happy music"] | ["male singer", "backup singers", "guitar lead", "medium tempo", "steady drumming rhythm", "string section playing rhythmically", "cymbals crashing", "slick percussion clicks", "strong bass line", "keyboard harmony", "modern pop hits", "emotional", "romantic", "together for ever", "i’m sorry", "forgive me", "love song", "poor audio quality", "heartfelt", "vocal harmony", "clapping percussions"] | 1 | -wymN80CiYU | 105 | |
'Kiss a Girl Sessions' Video Keith Urban AOL Music | A male country singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a strong drumming rhythm, guitar accompaniment, guitar lead, percussive bass line and percussion hits. The song is passionate and romantic. The song has bad audio quality. | 2009-04-16T00:03:13Z | Nick Czapiewski | http://nickwinch.blogspot.com/ Keith Urban singing Kiss a Girl on AOL music. Make sure you pick up "Defying Gravity" in stores and online now!! ***NO INFRINGEMENT INTENDED*** just spreading the good news of Keith Urban | ["Music", "Happy music", "Exciting music"] | ["male singer", "country singer", "backup singers", "vocal harmony", "crooning vocals", "medium tempo", "guitar leads", "guitar strumming", "percussive bass line", "keyboard accompaniment", "energetic", "passionate", "love song", "romantic", "country guitar band", "modern country love songs", "country super hits", "madly in love", "bad audio quality"] | 1 | 9uToez74x_M | 1048 | |
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 | |
Bowl for Two - The Expendables | A male singer sings this cheerful melody with backup singers in vocal harmony. The song is medium tempo with a reggae style drum and guitar accompaniment, guitar lead and a groovy bass line. The song is romantic and cheerful . The song is a Latin pop dance song. The audio quality is average. | 2007-09-02T03:29:08Z | P3DRO2 | lovin it | ["Music", "Happy music"] | ["male latin singer", "backup singers", "vocal harmony", "keyboard accompaniment", "average audio quality", "groovy bass line", "guitar accompaniment", "guitar lead", "bouncy drum rhythm", "reggae music influences", "keybiard accompaniment", "entertaining", "cheerful", "romantic", "love song", "latin pop song", "latin dance song", "groovy rhythm"] | 1 | euAQCWBX6ns | 3904 | |
Ten2Five - My World Is Full With You | A female vocalist sings this beautiful pop melody. The tempo is medium fast with rhythmic acoustic guitar, keyboard harmony, electric guitar melody, straight drumming;steady bass and tambourine beats. The song is mellow, sweet, passionate,emotional, youthful, romantic, simple and tender. This song is a hit Indonesian Pop. | 2012-10-13T23:03:56Z | Xily Gina | Indonesian indie band | ["Christmas music", "Music", "Happy music"] | ["female vocalist", "medium fast tempo", "pop", "straight drumming", "classic pop", "passionate", "emotional", "romantic", "first love", "indonesian pop", "melodious", "rhythmic acoustic guitar", "electric guitar", "groovy bass line", "keyboard harmony", "tambourine beats", "synthesiser", "vivid", "vivacious", "youthful", "love song", "emotional", "sentimental"] | 7 | zTtZH-Q61Ik | 5480 |
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;