musiccaps_details (view)
4 rows where musiccaps_aspects contains "ballad" and musiccaps_aspects contains "mellow"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- ballad · 4 ✖
- mellow · 4 ✖
- emotional 2
- acoustic drums 1
- acoustic guitar 1
- acoustic guitar arpeggio 1
- acoustic rhythm guitar 1
- arabic inspired 1
- bass guitar 1
- bongo drums 1
- electric bass guitar bassline 1
- electric guitar arpeggio 1
- electric guitar melody 1
- ethereal female vocal 1
- female vocal 1
- flat male vocal 1
- gentle male vocal 1
- groovy bass 1
- heartfelt 1
- live performance 1
- low quality 1
- mellow harmonizing reverberant female vocals 1
- mellow keys melody 1
- melodic singing 1
- open-mouthed humming 1
- passionate 1
- percussive chime 1
- pop ballad 1
- pop music 1
- relaxing 1
- reverb 1
- shimmering hi hats 1
- slow tempo 1
- soft kick hits 1
- soft rimshots 1
- soft rock ballad 1
- traditional middle eastern music 1
- vocables 1
musiccaps_names (array) 7 ✖
- Music 3
- Chant 1
- Happy music 1
- Singing 1
- Soul music 1
- Vocal music 1
- Wedding music 1
youtube_published (date) 4 ✖
- 2008-12-02 1
- 2010-01-21 1
- 2013-08-11 1
- 2014-09-11 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joe Dassin - Et si tu n ' existais pas | The low quality recording features a ballad that contains a flat male vocal, alongside mellow harmonizing, reverberant female vocals, singing over acoustic rhythm guitar located in the left channel, electric guitar melody in the right channel of the stereo image, groovy bass, shimmering hi hats, soft rimshots, soft kick hits and mellow keys melody. It sounds mellow, emotional, passionate and heartfelt. | 2008-12-02T21:40:48Z | melenia1 | Tu es mon amour... | ["Soul music"] | ["low quality", "ballad", "flat male vocal", "mellow harmonizing reverberant female vocals", "groovy bass", "acoustic rhythm guitar", "electric guitar melody", "shimmering hi hats", "soft rimshots", "soft kick hits", "mellow keys melody", "mellow", "emotional", "passionate", "heartfelt"] | 4 | 4kZ0EZg5JRU | 600 | |
Rasulullah - The Malay Chanting Group | This is a live performance of what sounds like a Middle Eastern. The female singer has a calm and soothing voice which she uses to sing vocables - or open mouthed humming. There are percussive chimes, and an acoustic guitar arpeggio which adds to the calm and soothing feel of the song. | 2014-09-11T13:42:13Z | Che Mat Merah Muda | sejuk nya qalbu... by Iman Farrar | ["Singing", "Chant", "Music", "Vocal music"] | ["live performance", "traditional middle eastern music", "open-mouthed humming", "vocables", "arabic inspired", "ethereal female vocal", "reverb", "ballad", "mellow", "percussive chime", "acoustic guitar arpeggio"] | 3 | AobHGHJSd-s | 1172 | |
On Your Wedding Day (A Stepdad's Song) | The song features a calm, gentle male vocalist. It feels like a soft pop ballad, with a slight rock influence. There's an electric guitar arpeggio, bongo drums, and a prominent bassline. The song feels like it would be suitable as a loving dedication to someone. | 2013-08-11T02:29:43Z | Joe M | ©Copyright 2012 Joe Manzella All Rights Reserved This song is for Melissa: Happy First Anniversary, Sweetie! - Love Joe On Your Wedding Day (A Stepdad's Song) It wasn't really long ago that you were just a girl. I came into your life by chance and slowly shared your world. Through good times and some bad, still always proud to be your stepdad. And now here on your wedding day, as you dance by my side, I'm so thrilled 'cause I get to be stepfather of the bride. So as I hold your hand, this love for you is from your stepdad. (Bridge) Just call on me anytime, it's no bother Always know you'll be my daughter and I'll be there. Wherever this life shall choose to lead us there's a bond always between us,a tie we share and I'll always care. And so here on your wedding day I'm truly blessed to be your stepdad. | ["Music", "Wedding music"] | ["soft rock ballad", "ballad", "pop ballad", "electric bass guitar bassline", "gentle male vocal", "electric guitar arpeggio", "bongo drums", "relaxing", "mellow"] | 3 | OR_YbeqV5tA | 2439 | |
insomnia female version (acoustic) | This is a pop music piece. There is a female vocalist singing melodically in the lead. The acoustic guitar is playing the main tune while the bass guitar is playing in the background. The rhythm is provided by a slow tempo acoustic drum beat. The atmosphere is emotional. This piece could be used in the soundtrack of a romance movie where the characters are missing each other at night. | 2010-01-21T06:26:22Z | drauf | insomnia female version | ["Music", "Happy music"] | ["pop music", "ballad", "female vocal", "melodic singing", "acoustic guitar", "bass guitar", "acoustic drums", "slow tempo", "mellow", "emotional"] | 9 | bxF2vxTzlvo | 3666 |
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;