musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "female vocalist" and musiccaps_aspects contains "sentimental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- female vocalist · 3 ✖
- sentimental · 3 ✖
- emotional 2
- first love 2
- foreign language 2
- love song 2
- rhythmic acoustic guitar 2
- romantic 2
- amateur guitarist 1
- amateur singing 1
- asian music 1
- christian worship 1
- classic pop 1
- electric guitar 1
- flute 1
- groovy bass line 1
- home recording 1
- indonesian pop 1
- keyboard accompaniment 1
- keyboard harmony 1
- lullaby 1
- medium fast tempo 1
- medium tempo 1
- melancholic 1
- mellow 1
- melodic violin harmony 1
- melodious 1
- muffled recording 1
- nostalgic 1
- passionate 1
- pensive 1
- pop 1
- praise and worship 1
- romantic pop 1
- sleepy 1
- slow tempo 1
- soft 1
- soft pop 1
- soundtrack 1
- straight drumming 1
- subtle bass line 1
- synthesiser 1
- tambourine beats 1
- vivacious 1
- vivid 1
- vocal harmony 1
- young love 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 3
- Christmas music 1
- Happy music 1
- Tender music 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Still [Tagalog Version] | A female vocalist sings this emotional song. The tempo is slow with guitar accompaniment and vocal backup. The song is soft, mellow, emotional and sentimental in a foreign language that sounds like a lullaby.This is a Pop Folk song. | 2008-09-22T13:08:16Z | Carmina dela cruz | Eph 3:19, 20 Speak to one another with Psalms, hymns and spiritual songs. Sing and make music in your heart to the Lord. Always giving thanks to God and the Father for everything, in the name of our Lord Jesus Christ! ____________________________________________ sorry may konting sablay...but all honor and Glory to Jesus alone!! Words and music by Darlene Zchech [Hillsong] Tagalog Version by Richard bermudez and Carmina Dela cruz I do not own copyrights to translate these songs nor do I claim the melody as mine. I only translated them for my own enjoyment purposes. Thank You. | ["Music", "Ukulele"] | ["female vocalist", "slow tempo", "lullaby", "sleepy", "vocal harmony", "amateur guitarist", "amateur singing", "home recording", "muffled recording", "christian worship", "foreign language", "praise and worship", "soft", "mellow", "emotional", "sentimental"] | 7 | LEG7xkYOsWA | 2165 | |
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;