musiccaps_details (view)
1 row where musiccaps_aspects contains "female vocalist", musiccaps_aspects contains "home recording", musiccaps_aspects contains "lullaby" and musiccaps_author = 7
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;