musiccaps_details (view)
4 rows where musiccaps_aspects contains "dj", musiccaps_aspects contains "drum machine", musiccaps_aspects contains "rap" 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Hadiya Deville..Make it Ping Pong...mpg | A male vocalist sings this spirited hip-hop. The tempo is fast with synthesiser articulation, digital drum arrangements and vocal backup. The music is a youthful , enthusiastic, bouncy, punchy rhythmic patter with a dance groove. This song is contemporary Hip-Hop/ Rap. | 2011-11-26T16:20:24Z | Loc Deville | This is a Must See Video..2 Year old Hadiya Shaheed..aka Hadiya Deville..Rocks Out, to her Fathers New Single ''Make it Ping Pong''.. ---Talent is in the D.N.A..--SEE FOR YOUR SELF :) | ["Music", "Rapping", "Hip hop music"] | ["male vocalist", "fast tempo", "hip-hop", "rap", "bouncy", "punchy", "funk rap", "punk rap", "rhythmic patter", "rhythmic speech", "engaging", "passionate", "energetic", "enthusiastic", "vocal backup", "recurring beat", "youthful", "keyboard harmony", "digital drum arrangement", "drum machine", "synth articulation", "vocal backup", "dance groove", "dj", "club music", "dance music", "hip-hop hits"] | 7 | QBMM1ocXkhY | 2602 | |
| 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 | ||
| I'm N Luv (Wit A Stripper) 2 -Tha Remix (Official HD Video) | A male vocalist sings this catchy Hip-Hop. The tempo is medium with an acoustic guitar riff, boomy bass drops, punchy drumming, digital beats and synthesiser arrangement with enthusiastic vocal backup. The song is youthful, buoyant, punchy, groovy, pulsating with a dance groove. This song is Contemporary Hip-Hop. | 2009-10-25T19:59:01Z | TPainVEVO | "I’m In Luv With A Stripper" by T-Pain (Remix) Listen to T-Pain: https://tpain.lnk.to/listenYD Watch more T-Pain videos: https://tpain.lnk.to/listenYD/youtube Subscribe to the official T-Pain YouTube channel: https://tpain.lnk.to/subscribeYD Follow T-Pain: Facebook: https://tpain.lnk.to/followFI Instagram: https://tpain.lnk.to/followII Twitter: https://tpain.lnk.to/followTI Website: https://tpain.lnk.to/followWI Spotify: https://tpain.lnk.to/followSI YouTube: https://tpain.lnk.to/subscribeYD Lyrics: She poppin, she rollin, she rollin She climbin that pole and I'm in love with a stripper She trippin, she playin, she playin I'm not goin nowhere girl, I'm stayin, I'm in love with a stripper She poppin, she rollin, she rollin She climbin that pole and I'm in love with a stripper She trippin, she playin, she playin I'm not goin nowhere girl, I'm stayin, I'm in love with a stripper #TPain #ImInLuvWithAStripper #OfficialHDVideo #HD | ["Singing", "Music", "Rhythm and blues", "Hip hop music"] | ["male vocalist", "medium tempo", "emotional", "passioante", "rhythmic patter", "groovy", "dance pop", "dance groover", "dj", "club music", "dance music", "enthusiastic vocal backup", "digital drums", "punchy drums", "drum machine", "boomy bass line", "acoustic guitar riff", "synthesiser arrangement", "hip-hop", "rap", "contemporary hip-hop", "alternative"] | 7 | vqRFzhWik2c | 5210 |
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;