musiccaps_details (view)
3 rows where musiccaps_aspects contains "female voice singing" and musiccaps_aspects contains "r&b"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- female voice singing · 3 ✖
- r&b · 3 ✖
- digital drums 2
- sub bass 2
- acoustic guitar 1
- amateur recording 1
- digital strings 1
- medium tempo 1
- percussive snare sound 1
- slower tempo 1
- synth pad 1
- triangle 1
- ukulele 1
- uptempo 1
- xylophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lullaby - Lateeya ( Lyrics ) | This song contains someone playing ukulele along with a xylophone sound playing the melody along. A female voice is singing in a higher key sounding soulful. You can hear a rimshot sound. That sound is maybe coming from the ukulele. This song may be playing live entertaining your friends and family. | 2012-02-17T06:41:35Z | TeddyBearwuvsmusic | I DONT OWN NOTHING! NO COPYRIGHTS INTENDED! Subscribe & Like? | ["Music", "Lullaby"] | ["amateur recording", "r&b", "ukulele", "female voice singing", "xylophone", "percussive snare sound", "slower tempo"] | 6 | THhptTKMr9U | 2826 | |
No Scrubs by TLC [Lyrics] | This song contains a digital drum with a shaker sound and a triangle. A soft sub bass is playing along. In the background you can hear one continuous high tone from a digital string sound. Other strings and a piano are playing a simple repeating melody. The female voice is singing along with backing vocals in the background. This song may be playing loud while driving a car. | 2008-07-21T13:52:45Z | heartbraeker | LYRICS HERE, SUB FOR SUB :) A scrub is a guy that can't get no love from me And is also known as a buster Always talkin' about what he wants And just sits on his broke ass So (no) I don't want your number (no) I don't want to give you mine and (no) I don't want to meet you nowhere (no) I don't want none of your time and (no) [Chorus:] I don't want no scrub A scrub is a guy that can't get no love from me Hanging out the passenger side Of his best friend's ride Trying to holler at me I don't want no scrub A scrub is a guy that can't get no love from me Hanging out the passenger side Of his best friend's ride Trying to holler at me But a scrub is checkin' me But his game is kinda weak And I know that he cannot approach me Cuz I'm lookin' like class and he's lookin' like trash Can't get wit' no deadbeat ass So (no) I don't want your number (no) I don't want to give you mine and (no) I don't want to meet you nowhere (no) I don't want none of your time (no) [Chorus] If you don't have a car and you're walking Oh yes son I'm talking to you If you live at home wit' your momma Oh yes son I'm talking to you (baby) If you have a shorty but you don't show love Oh yes son I'm talking to you Wanna get with me with no money Oh no I don't want no (oh) No scrub No scrub (no no) No scrub (no no no no no) No scrub (no no) No [Chorus] [Chorus] [Chorus] [Chorus] | ["Funk"] | ["r&b", "digital drums", "digital strings", "sub bass", "triangle", "female voice singing", "medium tempo"] | 6 | VP1cB_AVu6c | 2999 | |
Diam's - DJ (Clip officiel) | This song contains digital drums with a soft sub bass playing along every kick hit. An acoustic guitar/sitar is playing a melody with a synth sound playing a high counter melody panned to the left side of the speakers. A synth pad is playing a long note melody in a higher register. A female voice is singing the main melody. Her voice is doubled and backing voices are adding harmonies. This song may be playing in a hip-hop club. | 2009-02-26T21:52:50Z | Diam's officiel | Music video by Diam's performing Dj. | ["Singing", "Music", "Exciting music"] | ["r&b", "acoustic guitar", "synth pad", "digital drums", "sub bass", "female voice singing", "uptempo"] | 6 | oRVivXC83hA | 4629 |
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;