musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "male vocalist", musiccaps_author = 7 and musiccaps_names contains "Soul music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
God Must be Loved / Rich Moore - Praise Song / Lyrics | A male vocalist sings this emotional Christian Worship Song. The tempo is medium with energetic drumming,harmonious electric guitar , acoustic Guiana keyboard accompaniment and subtle bass. The song is a soft, mellow, emotional, pensive, devotional, Christian music. | 2014-01-15T17:06:38Z | Christian Sermons and Audio Books | God Must be Loved / Rich Moore - Praise Song / Lyrics My original Christian music facebook page: https://www.facebook.com/richmoorechristianmusic I am a singer, guitarist, and songwriter. This is a new original contemporary Christian song I recently wrote and recorded. May those who listen find it a great blessing, to the glory of the Lord Jesus Christ...praise God. (Music and video owned and copyrighted by stack45ny) My Original Contemporary Christian Songs (playlist): http://www.youtube.com/playlist?list=PLzOwqed_gET0JkRfjd1-xm_BGrCYaJqVR Christian Praise and Worship Songs playlist: https://www.youtube.com/playlist?list=PL4D0533BC00E40EA4 Matthew 10:34 "Do not think that I came to bring peace on earth. I did not come to bring peace but a sword. 35 For I have come to 'set a man against his father, a daughter against her mother, and a daughter-in-law against her mother-in-law'; 36 and 'a man's enemies will be those of his own household.' 37 He who loves father or mother more than Me is not worthy of Me. And he who loves son or daughter more than Me is not worthy of Me. 38 And he who does not take his cross and follow after Me is not worthy of Me. -~-~~-~~~-~~-~- Please watch: "A Call to Separation - A. W. Pink Christian Audio Books / Don't be Unequally Yoked / Be Ye Separate" https://www.youtube.com/watch?v=CBDg7u21cKY -~-~~-~~~-~~-~- | ["Christmas music", "Jingle (music)", "Music", "Psychedelic rock", "Rock music", "Song", "Soul music"] | ["male vocalist", "medium", "emotional", "sentimental", "soft", "subtle bass", "mellow", "pensive", "poignant", "repentance", "gratitude", "worship", "reverence", "church", "humility", "tempo", "slick drumming", "acoustic guitar harmony", "keyboard accompaniment", "christian song", "christian gospel music", "christian praise and worship", "christian worship song", "gospel music", "christian pop", "christian rock", "electric guitar", "christian music"] | 7 | RceCfg1FQq4 | 2713 |
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;