musiccaps_details (view)
2 rows where musiccaps_names contains "Christian music" and musiccaps_names contains "Rhythm and blues" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- beat boxing 1
- bouncy 1
- cheerful 1
- christian rap 1
- clapping hands 1
- clean lyrics 1
- dance song 1
- digital drum rhythm 1
- drum machine 1
- duet 1
- emotional 1
- four on the floor drum beat 1
- fun 1
- happy 1
- hip-hop 1
- impactful 1
- insightful 1
- intense 1
- keyboard harmony 1
- male and female vocalists 1
- male singer 1
- medium tempo 1
- passionate 1
- portuguese pop r&b music 1
- positive 1
- punchy 1
- r&b vocals 1
- rap 1
- rhythmic patter 1
- rhythmic speech 1
- simple lyrics 1
- steady bass 1
- teen rap 1
- youthful 1
musiccaps_names (array) 9 ✖
- Christian music · 2 ✖
- Music 2
- Rhythm and blues · 2 ✖
- Afrobeat 1
- Christmas music 1
- Hip hop music 1
- Rapping 1
- Reggae 1
- Singing 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
NEW Christian Rap - J-Tru Soldier4Christ ft. Gigglez - "Never Give Up" (@ChristianRapz) | A male vocalist sings this rap. The tempo is medium with the keyboard harmony, digital drum rhythm and boomy bass. The song is passionate, youthful, emotional, buoyant, insightful, intense and story telling in a rhythmic patter. This song is contemporary Rap/Hip. | 2015-10-07T12:29:47Z | Christian Hip Hop | CLICK HERE TO SUBSCRIBE - https://www.youtube.com/subscription_center?add_user=christianrapz Follow Christian Hip Hop Hits Just as Hard! Twitter - http://www.christianrapz.org Facebook - http://www.christianrapz.us Matt Bold - http://www.christianrapz.info YouTube - http://www.christianrapz.com Soundcloud - https://soundcloud.com/christianraps Visit http://www.christianraps.com for more Christian Hip-Hop & Rap Not for selling purposes all honor and glory to God http://www.evelutionbeats.com http://www.soundcloud.com/jtrujillo220 NEW Christian Rap - J-Tru Soldier4Christ ft. Gigglez - "Never Give Up" (@ChristianRapz) | ["Afrobeat", "Christian music", "Music", "Rapping", "Reggae", "Rhythm and blues", "Hip hop music"] | ["male singer", "medium tempo", "hip-hop", "rap", "insightful", "clean lyrics", "simple lyrics", "christian rap", "youthful", "teen rap", "bouncy", "punchy", "steady bass", "beat boxing", "keyboard harmony", "drum machine", "digital drum rhythm", "rhythmic patter", "rhythmic speech", "passionate", "emotional", "impactful", "intense"] | 7 | dwAo0dKCyBI | 3828 | |
Música de Natal Unitel (video Clip) | This is a pop R&B song in Portuguese. The song has a cheerful and fun effect to it, and the four on the floor style helps in creating the feeling of dancing. The singers are a man and woman with smooth vocals, singing a duet - harmonically. | 2014-11-20T08:31:22Z | tvUNITEL | Música de Natal Unitel 2014. "Mais próximo do meu coração” de Anselmo Ralph e Anna Joyce Unitel. O próximo mais próximo. ====================================== "Mais próximo do meu coração” Eu trago embrulhado numa caixa, Forrado com papel azul e laranja, E quando toca a meia noite, tu... Podes abrir, vá lá, vem ver o que eu escolhi para ti, É para ti com muito amor, Eu dei o meu melhor, Para o próximo, mais próximo do meu coração. (Refrão x2) Pois neste Natal Eu posso não te dar de tudo Mas o meu pouco é muito No Natal, vai ser dado com amor. Família reunida numa mesa, De fora fica a mágoa e a tristeza, No meu peito eu trago a prenda mais preciosa, Nas mãos eu trago algo que eu escolhi para ti. É para ti com muito amor, Eu dei o meu melhor, Para o próximo mais próximo do meu coração. | ["Christmas music", "Singing", "Christian music", "Music", "Rhythm and blues"] | ["portuguese pop r&b music", "dance song", "four on the floor drum beat", "duet", "male and female vocalists", "r&b vocals", "cheerful", "positive", "happy", "clapping hands", "fun"] | 3 | yqb4GenP8gs | 5443 |
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;