musiccaps_details (view)
1 row where musiccaps_aspects contains "catchy vocal riff", musiccaps_aspects contains "disco rap", musiccaps_aspects contains "hip-hop" and musiccaps_aspects contains "rap"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Glory Official Music Video - Christian / Gospel Music | A female vocalist sings this spirited rap. The tempo is medium with punchy drumming and synthesiser arrangements. The song is youthful,energetic,spirited with a catchy recurring vocal riff. The song is an Electro Rap/Hip-Hop song. | 2012-08-09T04:53:39Z | hillinamusic | Buy "Into the Light" now on iTunes http://itunes.apple.com/us/album/into-the-light-ep/id543561227 To find out more about Hillina or for booking / contact information go to:- http://www.hillinamusic.com "Glory" Everyone suffers in this world, in one form or another. But, for what purpose do we suffer?! The believer is called to share in the sufferings of Christ, so that we may also share in His glory. Paul explains that the sufferings we endure for baring His name are "not worthy to be compared" to the glory that He will reveal in us! Thus, we are to keep our focus on Jesus; the rock of our salvation, as we pass through this earth as pilgrims. Knowing that 'He makes all things work together for the good of those who love Him and are called according to His purpose' (Romans 8:28). Nothing we do qualifies us for His work because He chose 'the foolish to shame the wise'. The work was completed on the cross! Our objective is to give Him what we have (our brokenness, weakness...) so that He may exalt Himself through the most unlikely people and situations and receive ALL the glory and honor through our lives! For Only He is worthy! "... if indeed we suffer with Him, that we may also be glorified together. For I consider that the sufferings of this present time are not worthy to be compared with the glory which shall be revealed in us." -- Romans 8:17-18 "And He said to me, "My grace is sufficient for you, for My strength is made perfect in weakness." Therefore most gladly I will rather boast in my infirmities, that the power of Christ may rest upon me." -- 2nd Corinthians 12:9 "To them God willed to make known what are the riches of the glory of this mystery among the Gentiles: which is Christ in you, the hope of glory." -- Colossians 1:27 "Therefore let those who suffer according to the will of Yahweh commit their souls to Him in doing good, as to a faithful Creator" -- 1st Peter 4:19 "The LORD is my rock, my fortress and my deliverer; my God is my rock, in whom I take refuge. He is my shield and the horn of… | ["Afrobeat", "Music", "Hip hop music"] | ["female singer", "medium fast tempo", "rap", "hip-hop", "female rapper", "passionate", "intense", "rapper", "synthesiser arrangements", "electronic music", "electro rap", "punchy drumming", "drum machine", "bass drum", "psychedelic music", "syncopated", "youthful", "energetic", "enthusiastic", "pop rap", "disco rap", "insistent", "catchy vocal riff", "recurring beat", "dance music", "club", "dj"] | 7 | f8nysknTFUo | 3926 |
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;