musiccaps_details (view)
5 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "passionate", musiccaps_aspects contains "r&b" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Pieter T - If My Girl | The low quality recording features a R&B song that consists of passionate male vocals, alongside background harmonizing male vocals, singing over tinny bells melody, synth strings melody, tinny high pitched synth lead melody, shimmering hi hats, gliding bass, punchy kick and claps. It sounds passionate and emotional, even though the mix of the song is poor. | 2011-10-30T05:12:06Z | IceFrettz | Pieter T - If My Girl From the album Life, Love & Lessons. Available now on itunes. | ["Music", "Happy music"] | ["low quality", "r&b", "passionate male vocal", "background harmonizing male vocals", "tinny bells melody", "synth strings melody", "tinny high pitched synth lead melody", "shimmering hi hats", "gliding bass", "punchy kick", "claps", "passionate", "emotional", "poor quality mix"] | 4 | 3IYd8cCmUkQ | 454 | |
H-Town - Part Time Lover | The low quality recording features a R&B song that consists of echoing harmonizing vocals, alongside passionate male vocal singing over noisy percussion, punchy snare and kick hits, pulsating synth melody, synth pad chord, shimmering shakers and sizzling triangle. It sounds romantic, passionate and emotional - like something you would slow dance to with your partner. | 2009-04-25T19:56:38Z | ManUtdAL3X | Above The Rim Soundtrack [1994] http://www.imdb.com/title/tt0109035/ "Part Time Lover" Performed by H-Town Written by DeVante DeGrate (as Devante Swing) and Darryl Pearson Courtesy of Luke Records | ["Music", "Soul music"] | ["low quality", "r&b", "noisy percussion", "punchy snare", "pulsating synth melody", "synth pad chord", "echoing harmonizing vocals", "passionate male vocal", "punchy kick", "shimmering shakers", "sizzling triangle", "romantic", "emotional", "passionate"] | 4 | 5mLYN-F2Oek | 692 | |
Faith Evans- Mesmerized | The R&B song features a passionate female vocal, alongside wide background female vocals, singing over shimmering cymbals, punchy kick and snare hits, groovy bass guitar and wide electric guitar melody. It sounds passionate, emotional and addictive - like something you would hear in clubs a lot. | 2007-04-16T15:46:14Z | Amanda Ab | Faith evans video | ["Music", "Rhythm and blues"] | ["r&b", "wide background female vocals", "passionate female vocal", "shimmering cymbals", "punchy kick", "punchy snare", "groovy bass guitar", "wide electric guitar melody", "passionate", "emotional", "addictive"] | 4 | NC5tIv4-8fg | 2325 | |
"Be My" Best Wedding Song | A male vocalist sings this smooth Soul melody. The tempo is medium with a mellow piano accompaniment, steady drum machine beats, atmospheric synthesiser and subtle bass with backup vocals. The song is soft, ambient, passionate, emotional, mellifluous ,sentimental and warm. This song is a contemporary R&B/Soul. | 2010-02-21T22:49:47Z | STUDIO8MILE | None | ["Music", "Wedding music"] | ["male vocalist", "medium tempo", "piano accompaniment", "soft", "passionate", "emotional", "sentimental", "warm", "young love", "wedding song", "slick drumming", "atmospheric synthesiser", "digital drums", "funky bass lines", "soul", "r&b", "ambient", "soulful", "melodic", "smooth", "lush", "vocal backup", "resounding"] | 7 | ZUkh168Nyus | 3384 | |
Lana del Rey - Kill Kill | The R&B song features a melancholic female vocal singing over mellow piano melody, electric guitar chords, synth lead melody, groovy bass, organ keys chords, shimmering hi hats, punchy snare and soft kick hits. It sounds emotional, passionate and heartfelt. | 2011-11-03T15:59:06Z | zentalau | Lana del Rey - Kill Kill ound up the stairs I'm in the shower Do you know I am going to leave you? Do you know I am going To leave you? I'm in love with a dying man I'm in love with a dying man All our love's flying in the sand I'm in love with a dying man I'm in love with a dying man I have done everything I can Tell me about Brian and his girl Do I know, Brian is going to meet you? Love you, I do Stay here, I won't As stars fade from your eyes I'm in love with a dying man I'm in love with a dying man All our love flying in the sand I'm in love with a dying man I'm in love with a dying man I have done everything I can Want to Make it fun Don't trust Anyone I'm in love with a dying man I'm in love with a dying man I have done everything I can I'm in love with a dying man I'm in love with a dying man I have done everything I can... | ["Electronic organ", "Music", "Independent music"] | ["r&b", "synth lead melody", "melancholic female vocal", "mellow piano melody", "electric guitar chords", "groovy bass", "organ keys chords", "shimmering hi hats", "punchy snare", "soft kick hits", "emotional", "passionate", "heartfelt"] | 4 | hHS5C0RKa8A | 4091 |
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;