musiccaps_details (view)
2 rows where musiccaps_aspects contains "club" and musiccaps_aspects contains "passionate" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- club · 2 ✖
- female singer 2
- passionate · 2 ✖
- acoustic love song 1
- bad audio quality 1
- bass drum 1
- catchy vocal riff 1
- dance music 1
- disco rap 1
- distorted vocals 1
- dj 1
- drum machine 1
- electro rap 1
- electronic music 1
- emotional 1
- energetic 1
- enthusiastic 1
- female rapper 1
- hip-hop 1
- hissing noise 1
- insistent 1
- intense 1
- live performance 1
- medium fast tempo 1
- medium tempo 1
- melancholic 1
- missing you 1
- piano accompaniment 1
- poor audio quality 1
- pop cover 1
- pop rap 1
- pop songs 1
- psychedelic music 1
- punchy drumming 1
- rap 1
- rapper 1
- recurring beat 1
- romantic 1
- sad song 1
- song covers 1
- syncopated 1
- synthesiser arrangements 1
- with you forever 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
OPM Love Songs Medley by Kai Brosas | A female singer sings this beautiful melody. The tempo is medium with a piano or keyboard accompaniment and no other instrumentation. The song is emotional and passionate like a love song. The audio quality is very poor with a lot of hissing noise and distortion. | 2010-10-25T09:07:45Z | chelrada713 | ["Singing", "Bell", "Music"] | ["female singer", "poor audio quality", "hissing noise", "distorted vocals", "pop songs", "pop cover", "song covers", "piano accompaniment", "acoustic love song", "live performance", "club", "romantic", "emotional", "sad song", "passionate", "melancholic", "with you forever", "missing you", "passionate", "bad audio quality", "medium tempo"] | 1 | N8Fg3L1Cc5E | 2323 | ||
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;