musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "female vocalist" and musiccaps_aspects contains "foreign language" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 33 ✖
- female vocalist · 2 ✖
- foreign language · 2 ✖
- sentimental 2
- amateur guitarist 1
- amateur singing 1
- asian music 1
- christian worship 1
- emotional 1
- first love 1
- flute 1
- home recording 1
- keyboard accompaniment 1
- love song 1
- lullaby 1
- medium tempo 1
- melancholic 1
- mellow 1
- melodic violin harmony 1
- muffled recording 1
- nostalgic 1
- pensive 1
- praise and worship 1
- rhythmic acoustic guitar 1
- romantic 1
- romantic pop 1
- sleepy 1
- slow tempo 1
- soft 1
- soft pop 1
- soundtrack 1
- subtle bass line 1
- vocal harmony 1
- young love 1
musiccaps_names (array) 3 ✖
- Music 2
- 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 |
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;