musiccaps_details (view)
3 rows where musiccaps_aspects contains "backup singers" and musiccaps_aspects contains "inspiring" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- backup singers · 3 ✖
- groovy bass line 3
- inspiring · 3 ✖
- motivational 3
- female singer 2
- groovy rhythm 2
- male singer 2
- medium tempo 2
- average audio quality 1
- choral harmony 1
- christian praise songs 1
- clapping percussions 1
- congregational 1
- congregational singing 1
- dance rhythm 1
- devotional 1
- emotional 1
- female singers 1
- guitar accompaniment 1
- guitar lead 1
- guitar rhythm 1
- high spirits 1
- hip hop dance music 1
- hip hop music 1
- hissing vocals 1
- home studio 1
- keybiard accompaniment 1
- keyboard accompaniment 1
- keyboard harmony 1
- life lessons 1
- love song 1
- meditative 1
- modern hip hop hits 1
- passionate 1
- poor audio quality 1
- praise and worship 1
- prayer 1
- retro pop hits 1
- romantic 1
- self discovery 1
- slow tempo 1
- song cover 1
- spirited 1
- steady percussive rhythm 1
- story telling 1
- string drumming rhythm 1
- vocal duet 1
musiccaps_names (array) 7 ✖
- Music 2
- Christian music 1
- Independent music 1
- Pop music 1
- Rhythm and blues 1
- Singing 1
- Song 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jakes List Jun 2012 Top 10 Independent Music Video Uploads | Male and female singers sing this vocal harmony. The song is medium tempo with a groovy bass-line, keyboard accompaniment, guitar rhythm and a steady drumming rhythm with clapping percussions. The song is exciting and groovy. The song is a classic pop hit cover with an average quality sound. | 2012-06-30T22:34:02Z | Jake Niall Foster | The top 10 music video uploads for the month of June 2012 (with a cut-off date of 22 Jun) for Independent and Unsigned artists. | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["male singer", "backup singers", "female singers", "clapping percussions", "groovy bass line", "medium tempo", "guitar accompaniment", "keybiard accompaniment", "song cover", "home studio", "average audio quality", "hissing vocals", "spirited", "passionate", "dance rhythm", "groovy rhythm", "life lessons", "motivational", "inspiring", "retro pop hits"] | 1 | lR8am4rK7qQ | 4395 | |
Mighty To Save | A male and female singer sing this vocal duet with a choral vocal harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, guitar lead, guitars playing rhythm and keyboard harmony. The song is devotional and congregational. The song is a Christian praise and worship song with poor audio quality. | 2007-01-03T22:51:34Z | Rachel Thomson | PLEASE READ - Comments have been disabled. If you do have any positive comments you would like to share, please do mail me. I’d be really encouraged to hear from you. John 13 v 34-35 "A new command I give you: Love one another. As I have loved you, so you must love one another. 35 By this everyone will know that you are my disciples, if you love one another." I know the reference should be 2 Chronicles 7:14, at the end, not 2 Corinthians 7:14. Sorry for that mistake, but I can't amend it. This is one of my favourite songs ever , the message is fantastic, it speaks of how God is mighty to save us and how is so mighty that he can move mountains. Also, there is no copyright infringement intended here, just the spreading of Gods word. Also, I don't own the bible verses, they're from God's word, which He wants the whole world to hear, so no fear of copyright there! Haha. His Word is unique :) Enjoy, | ["Christian music", "Music"] | ["poor audio quality", "male singer", "female singer", "guitar lead", "choral harmony", "backup singers", "vocal duet", "congregational singing", "christian praise songs", "praise and worship", "medium tempo", "guitar rhythm", "groovy bass line", "keyboard harmony", "meditative", "congregational", "devotional", "inspiring", "prayer", "motivational", "string drumming rhythm"] | 1 | sR8rlTIU8_Y | 4949 | |
Won-G feat. Rick Ross and Dwyntercold "Rich Together" OFFICIAL VIDEO | A female singer sings this passionate melody backed up by singers in vocal harmony. The tempo is slow with a strong bass line, steady percussive rhythm and keyboard accompaniment. The song is emotional and spirited. The song is a modern hip hop hit. | 2015-10-10T14:09:19Z | officialwong | ["Rhythm and blues"] | ["female singer", "hip hop music", "backup singers", "modern hip hop hits", "slow tempo", "groovy bass line", "steady percussive rhythm", "keyboard accompaniment", "story telling", "emotional", "motivational", "inspiring", "groovy rhythm", "hip hop dance music", "emotional", "romantic", "love song", "high spirits", "self discovery"] | 1 | PBMfPDei93s | 2516 |
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;