musiccaps_details (view)
2 rows where musiccaps_aspects contains "dj", musiccaps_aspects contains "pop rap" and musiccaps_names contains "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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| Smack Wooo Riddim Freestyle | A male vocalist sings this energetic rap. The tempo is fast with electronic music and synthesiser arrangements with digital drum rhythm and boomy bass. The song is upbeat, energetic, buoyant, punchy and youthful with a bright dance groove. This song is an EDM/Synth pop. | 2012-02-04T03:16:37Z | ILOVEUKGRIME1 | ["Music", "Rapping"] | ["male singer", "fast tempo", "synth pop", "punchy", "atmospheric music", "vibrant", "edm", "drum machine", "synthesiser arrangements", "digital drumming", "reverb", "rhythmic patter", "vigorous rhythmic speech", "pop rap", "disco rap", "dance pop", "energetic", "enthusiastic", "punch", "youthful", "bouncy", "hip-hop", "rap", "dj", "punk rap", "club music"] | 7 | u6tgeRXOxnU | 5090 |
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;