musiccaps_details (view)
3 rows where musiccaps_aspects contains "soulful female vocal"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Shain Caw - No Mercy | The song feels funky and soulful. There's a rumbling funky bassline, and an electric guitar playing intermittent licks. The drumming sticks on the hi-hats for the feeling of a build-up;. The female vocalist has a powerful, soulful voice. | 2010-07-12T21:30:43Z | Marc de Groot | From Shain Caws new album The Incredible Decibel. Filmed, directed and edited by Marc de Groot. | ["Funk", "Music", "Soul music"] | ["funky", "soulful", "groovy", "funky rhythmic bassline", "twangy electric guitar", "soulful female vocal", "powerful rich female vocal", "crackling effect", "hi-hats", "build-up", "electric guitar licks"] | 3 | KPnIFb7T7VM | 2080 | |
| Tyler Perry Laugh To Stop From Crying Play in Philadelphia-The Whole Cast Singing | This is a low quality recording of a motown style song. The song seems to have been recorded using a cellphone. The lead female vocalist has a soulful and powerful voice. The song is upbeat and jovial. | 2009-10-29T06:19:52Z | Sylvia Lawton | October 25th -The whole cast singing The Jackson's Five I Want You Back. | ["Music", "/t/dd00004", "Synthetic singing"] | ["live performance", "low quality recording", "cellphone recording", "low quality audio", "motown song", "upbeat", "soulful female vocal"] | 3 | MocXmVbat3s | 2298 | |
| We Are the Reason | Avalon | The clip is of a Christian worship song - a gospel song. It's a powerful ballad with violins which add an uplifting emotional effect. The male singer has a smooth and gentle voice. There's an uplifting and soulful choir performing backing vocals. | 2012-02-29T23:03:50Z | ForGodSoLoved777 | VERSE 1: As little children we would dream of Christmas morn Of all the gifts and toys we knew we'd find But we never realized a baby born one blessed night Gave us the greatest gift of our lives CHORUS: We are the reason that He gave His life We were the reason that He suffered and died To a world that was lost He gave all He could give To show us the reason to live VERSE 2: As the years went by we learned more about gifts The giving of ourselves and what that means On a dark and cloudy day a man hung crying in the rain All because of love All because of love CHORUS: We are the reason that He gave His life We were the reason that He suffered and died To a world that was lost He gave all He could give To show us the reason to live BRIDGE: I finally found the reason for living It's in giving every part of my heart to Him In all that I do every word that I say I'll be giving my all just for Him, for Him CHORUS: We are the reason that He gave His life We were the reason that He suffered and died To a world that was lost He gave all He could give To show us the reason to live #ForGodSoLoved777 #Avalan #WeAreTheReason #praise #worship #praiseandworship #christian #christianity #bible #christiansongs #christianmusic #jesus #jesuschrist #god #christianmotivation #christianmusic #holyspirit #church #churchonline #faith | ["Christian music"] | ["christian music", "christian ballad", "worship music", "gospel", "string instruments", "ballad", "soulful choir", "smooth gentle male vocal", "soulful female vocal", "uplifting", "inspiring"] | 3 | cMhajmOBr0c | 3701 |
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;