musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate", musiccaps_author = 7 and musiccaps_names contains "Christian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- emotional 2
- medium tempo 2
- passionate · 2 ✖
- acoustic guitar 1
- beat boxing 1
- bouncy 1
- choral backup 1
- christian gospel song 1
- christian music 1
- christian rap 1
- christian song 1
- clean lyrics 1
- devotional 1
- digital drum rhythm 1
- drum machine 1
- earnest 1
- electric guitar 1
- female singer 1
- fervent 1
- groovy bass 1
- hip-hop 1
- hymns 1
- impactful 1
- insightful 1
- intense 1
- keyboard accompaniment 1
- keyboard harmony 1
- male singer 1
- praise and worship 1
- punchy 1
- rap 1
- rhythmic patter 1
- rhythmic speech 1
- simple lyrics 1
- steady bass 1
- teen rap 1
- youthful 1
musiccaps_names (array) 11 ✖
- Christian music · 2 ✖
- Music 2
- Afrobeat 1
- Choir 1
- Crowd 1
- Gospel music 1
- Hip hop music 1
- Rapping 1
- Reggae 1
- Rhythm and blues 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Coro Gospel AGUAVIVA en Albacete 1 | A female vocalist sings this Gospel song. The tempo is medium with groovy bass lines, keyboard accompaniment, electric guitar and acoustic guitar rhythm,tambourine beats and choral harmony. The song is a spirited,emotional,fervent, earnest and devotional Christian Worship Song. | 2010-02-07T02:22:15Z | MakinGospel | Video Oficial producido por MAKINGOSPEL del concierto del Coro Gospel Aguaviva en Albacete el 21-03-09, primera parte. | ["Singing", "Gospel music", "Christian music", "Crowd", "Music", "Choir"] | ["female singer", "medium tempo", "electric guitar", "groovy bass", "keyboard accompaniment", "choral backup", "christian music", "christian song", "hymns", "christian gospel song", "devotional", "praise and worship", "fervent", "earnest", "passionate", "emotional", "acoustic guitar"] | 7 | 0oIFGARD9xE | 210 | |
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 |
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;