musiccaps_details (view)
11 rows where musiccaps_aspects contains "romantic", musiccaps_aspects contains "steady drumming" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 142 ✖
- romantic · 11 ✖
- steady drumming · 11 ✖
- pleasant 7
- emotional 6
- love song 6
- male singer 6
- medium tempo 6
- sentimental 6
- dulcet 4
- melodic 4
- simple melody 4
- acoustic guitar 3
- ambient 3
- foreign language 3
- slow tempo 3
- soft pop 3
- world music 3
- bongos 2
- calm 2
- chimes 2
- groovy bass line 2
- instrumental 2
- keyboard accompaniment 2
- keyboard harmony 2
- mandolin 2
- mellow 2
- nostalgic 2
- passionate 2
- pop 2
- proposal song 2
- rock and roll 2
- romantic piano 2
- soft 2
- soothing 2
- synthesiser arrangements 2
- tambourine beats 2
- violins 2
- youthful 2
- acoustic guitar accompaniment 1
- african 1
- ambient music 1
- amplified flute 1
- amplified ney 1
- atmospheric synthesiser 1
- auto harp 1
- baby crying 1
- bass guitar 1
- blues 1
- boy band 1
- breezy fresh 1
- bulgarian 1
- cajun 1
- cajun beat 1
- catchy 1
- cheerful 1
- classic pop 1
- club music 1
- complex harmony 1
- congas 1
- country pop 1
- country song 1
- cymbals 1
- dance music 1
- dance pop 1
- dobro 1
- duet 1
- electric guitar 1
- electronic music 1
- emphatic lead 1
- engaging 1
- euphonious 1
- falling in love 1
- fast tempo 1
- female vocalist 1
- fiddle 1
- fingers snapping 1
- fluid 1
- folk song 1
- funky bass line 1
- groovy 1
- groovy bass lines 1
- hand percussion 1
- infectious drumming 1
- jazz 1
- k-pop 1
- k-pop hips 1
- korean song 1
- lingering 1
- male vocalist 1
- medium fast tempo 1
- melancholic 1
- melodic electric guitar lead 1
- melodious 1
- middle eastern music 1
- mood 1
- ney 1
- oud 1
- oud rhythm 1
- peaceful 1
- pepeasant 1
- perky 1
- pleasant melody 1
- pop folk 1
- pop hits 1
- punchy 1
- r&b 1
- regional pop 1
- resonator 1
- retro 1
- retro pop 1
- rhythmic acoustic guitar 1
- saxophone harmony 1
- sedate 1
- serene 1
- simple bass lines violin hamony 1
- simple groove 1
- soft keyboard harmony 1
- soft piano accompaniment 1
- soft rock 1
- soft soothing 1
- soft vocals 1
- soul 1
- soulfu 1
- soulful 1
- soulfulromantic 1
- static 1
- straight bass lines 1
- straightforward bass lines 1
- subtle bass line 1
- subtle bass lines 1
- superimposed noises 1
- syncopated 1
- synth arrangements 1
- synthesiser arrangement 1
- tambourine 1
- tapping sound 1
- upbeat 1
- vivacious 1
- vocal backup 1
- vocalisation 1
- wedding song 1
- young love 1
musiccaps_names (array) 20 ✖
- Music 11
- Soul music 4
- Music of Africa 2
- Wedding music 2
- /t/dd00004 1
- Baby cry, infant cry 1
- Crying, sobbing 1
- Distortion 1
- Electric guitar 1
- Exciting music 1
- Folk music 1
- Funk 1
- Happy music 1
- Inside, small room 1
- Pop music 1
- Reggae 1
- Rhythm and blues 1
- Singing 1
- Swing music 1
- Tender 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 | |
Michael ofori ogyegyentwie ghana gospel music | A male vocalist sings this sweet melody in a foreign language. The tempo is medium with keyboard accompaniment, steady drumming, synthesiser arrangement and acoustic guitar. The song has a simple, easy melody. It is earnest, emotional, calm and soothing. This song is a Regional Pop song. | 2009-04-20T09:40:57Z | gimwhp | Michael Ofori, Ghanaian born live in the United States. Singer of Gospel music. | ["Music of Africa", "Funk", "Music", "Reggae", "Rhythm and blues", "Soul music", "Exciting music"] | ["male singer", "medium tempo", "foreign language", "world music", "keyboard accompaniment", "steady drumming", "straight bass lines", "synth arrangements", "african", "melodic", "calm", "simple groove", "acoustic guitar", "romantic", "emotional", "peaceful", "serene"] | 7 | D3FyfFIKLVc | 1430 | |
Dave and John ....pedal steel and telecaster | This music is an electronic guitar instrumental. The tempo is medium with a harmonious electric guitar lead, steady drumming, subtle bass ,tambourine beats and synthesiser arrangement. The music is a pleasant, soothing, unhurried, calm, romantic, sentimental , sedate and lingering Electric Guitar, soft pop instrumental. | 2011-02-03T01:36:36Z | Bob Adams | David Hartley and John Stannard's duet on Chasing Rainbows.. super stuff as ever! At JD's steel meeting in the south of England Jan 2011 | ["Electric guitar", "Music", "Wedding music", "Distortion"] | ["instrumental", "medium tempo", "electric guitar", "lingering", "sedate", "romantic", "sentimental", "soft pop", "soft rock", "subtle bass lines", "steady drumming", "tambourine beats", "melodic", "pleasant", "soothing", "ambient", "romantic", "synthesiser arrangement", "steady drumming", "cymbals", "simple melody", "euphonious", "engaging", "cheerful", "sentimental", "ambient"] | 7 | bt7rDryN7G4 | 3663 | |
tsehay yohannes - Old music | A male vocalist sings this lilting melody. The tempo is medium with keyboard harmony, groovy bass line, steady drumming and mandolin harmony. The song is emotional, romantic, soulful, sentimental and soothing. This song is Regional Pop, | 2012-06-02T11:28:06Z | Banchi Avera | This song taking me back to my past ......... | ["Folk music", "Music", "Tender music"] | ["male singer", "medium tempo", "foreign language", "romantic", "soulful", "mandolin", "steady drumming", "soulfulromantic", "soulfu", "soothing", "calm", "soulful", "emotional", "love song", "folk song", "world music", "funky bass line", "keyboard harmony", "acoustic guitar"] | 7 | c9h4p6325Xo | 3684 | |
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 | |
Viggo Mortensen - Breathe A Sigh | A male vocalist sings this dulcet melody. The tempo is soft with acoustic guitar, resonator, fiddle, mandolin, banjo, dobro and auto harp accompaniment, steady drumming, tambourine beats , fingers snapping and funky bass lines. The song is soft, mellow, dulcet, emotional, sentimental, soothing , pleasant and simple. The song is Country Pop. | 2007-07-08T11:59:56Z | athelas51 | Again with my favorite Def Leppard's song. | ["Music", "Soul music"] | ["male singer", "slow tempo", "groovy bass line", "dulcet", "fingers snapping", "tambourine", "simple melody", "auto harp", "fiddle", "resonator", "dobro", "mandolin", "steady drumming", "soft", "mellow", "love song", "romantic", "passionate", "sentimental", "emotional", "country song", "country pop", "regional pop", "mellow", "pleasant melody"] | 7 | mJuJfKbcJcw | 4459 | |
RickRolling the Baby | A male singer sings this classic pop song. The tempo is fast with keyboard harmony, violins,infectious drumming,funky bass guitar and synthesiser arrangement. There are sounds of static, tapping and a baby crying loudly superimposed on the song. The audio quality is inferior and the recording is amateur. This song is Retro Rock and Roll. | 2008-01-26T06:05:33Z | DessertSage | http://www.marylowd.com | ["Crying, sobbing", "Music", "Baby cry, infant cry", "Inside, small room"] | ["male singer", "fast tempo", "baby crying", "youthful", "romantic", "upbeat", "superimposed noises", "synthesiser arrangements", "infectious drumming", "love song", "romantic", "vivacious", "violins", "bass guitar", "keyboard harmony", "tapping sound", "static", "steady drumming", "classic pop", "rock and roll", "retro"] | 7 | qMbGFWz9who | 4780 | |
ANDREA (SAHARA) ft Kristali - NA EKS - produced by COSTI 2011 | A female vocalist sings this spirited pop. The tempo is medium fast with percussion accompaniment like congas, bongos and drums , tambourine beats,along with amplified flute like the Ney and rhythmic oud. The music is catchy, youthful, groovy, breezy, romantic, pleasant and spirited. This music is contemporary Folk Pop. | 2011-04-27T13:59:10Z | FORZZA MUSIC | Subscribe to my channel: https://bit.ly/ForzzaMusic Subscribe 👉https://bit.ly/2Siqg8P 🔝🎶 NA EKS - produced by COSTI COSTI Grammy Nominated Producer Billboard Hot💯🇺🇸🇷🇴 producer, songwriter, top-liner, compozitor & artist. FORTZAAAA 🔝🎶 Powered by Doctor Music® 2017 Productions & Booking : drstudio@costi.ro International PR Department : office@doctormusic.ro http://www.facebook.com/DrCosti.TheProducer http://twitter.com/CostiOfficial https://instagram.com/costiofficial/ http://www.soundcloud.com/CostiOfficial Costi (The Music Producer) - the first Romanian producer with a Grammy Nomination (Grammy Awards 2012) All rights reserved. Unauthorized reproduction is a violation of applicable laws. | ["Music of Africa", "Music"] | ["female vocalist", "medium fast tempo", "simple melody", "romantic", "breezy fresh", "pleasant", "groovy", "dance music", "dance pop", "club music", "tambourine beats", "catchy", "punchy", "perky", "amplified flute", "ney", "oud", "electronic music", "pop folk", "bulgarian", "middle eastern music", "hand percussion", "congas", "bongos", "steady drumming", "synthesiser arrangements", "amplified ney", "oud rhythm"] | 7 | tJHFSRTPyew | 5026 | |
Arnel Pineda in AMO, 1988, singing "Lights" by Journey | A male vocalist sings this soft melody. The tempo is slow with a mellow keyboard harmony, steady drumming, subtle bass line and acoustic guitar accompaniment. The song is soft, romantic, melodic, emotional , sentimental, melancholic and pleasant. This song is classic Soft Rock. | 2008-03-22T11:10:43Z | ArnelPinedaFan | Audio only. Arnel Pineda with AMO, performing live "Lights" (originally by Journey) in 1998, almost 20 years before he became Journey's lead singer. Photos from Arnel's "journey" accompany the video. NOTE: Sorry I can't approve non-English comments because I don't understand them. | ["Singing", "Music", "Soul music", "/t/dd00004"] | ["male singer", "medium tempo", "soft keyboard harmony", "steady drumming", "subtle bass line", "rhythmic acoustic guitar", "romantic", "pleasant", "soft pop", "pop", "pop hits", "romantic", "sentimental", "emotional", "nostalgic", "melodic"] | 7 | thHSYzhoLo4 | 5057 | |
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;