musiccaps_details (view)
7 rows where musiccaps_aspects contains "female vocal" and musiccaps_aspects contains "urban"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- female vocal · 7 ✖
- urban · 7 ✖
- electronic drums 5
- groovy 5
- keyboard 4
- melodic singing 4
- bass guitar 3
- hip-hop 3
- r&b 3
- acoustic drums 2
- electric guitar 2
- hip 2
- live performance 2
- male vocal 2
- rap-like singing 2
- acoustic guitar 1
- alternative r&b 1
- bass 1
- cheerful 1
- christian pop 1
- crowd cheering 1
- female choir 1
- funky 1
- gospel 1
- groovy bass 1
- kids song 1
- male vocals 1
- modern 1
- piano 1
- playful 1
- rapping 1
- religious 1
- scracthing 1
- seductive singing 1
- sensual 1
- sentimental 1
- soul 1
- southern rap sound 1
- strong bass 1
- telephone sound effect 1
- turntable 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Brandy Sings: "Long Distance" | This is a live performance of an R&B music piece. There is a female vocalist singing melodically in the lead. Three female supporting vocals can be heard singing in the back. The melody is being played by the piano while the bass guitar plays a groovy bass line. The rhythm is provided by an acoustic drum beat. The atmosphere is sentimental. This piece can be used in the soundtrack of a romance movie involving a couple in a long distance relationship. | 2008-12-10T19:16:12Z | CBS | Brandy performs the single "Long Distance" from her much anticipated album, "Human." | ["Singing", "Christian music", "Music"] | ["r&b", "live performance", "female vocal", "melodic singing", "female choir", "piano", "bass guitar", "acoustic drums", "sentimental", "groovy", "urban"] | 9 | 3u9OO9Og0Gc | 517 | |
Z-Ro Ft. Mya - Tired Official video (with lyrics) Widescreen and HD | This is a hip-hop music piece. There is a duo of one male and one female vocal singing in a way that resembles rapping. The beat has an electric guitar and a bass guitar playing a groovy tune. The rhythmic background consists of an electronic drum beat. The atmosphere is urban. This piece could be playing in the soundtrack of a crime movie where the characters are doubting their actions. | 2009-03-11T22:15:57Z | 99esteban | 2nd video off crack God Damn When will a nigga get a brake I work so damn hard but I never come up I do worse with ever breath I take Sunshine is a leauxry Just to see another day is enough for me Cause I'm livin on borrowed time Every funeral I go to it might be mine it might be mine God Damn, I'm trying to hold on to my faith They use to tell me it was going to get greater later later Now it's later and I'm still I'm the same place Anytime I get off the ground Some crab in the bucket ass niggas pull me back down Bald fade on my fade Feeling helpless and it's written all over my face Here we go again just to live another season I keep my faith in god to peace these demons Sometimes I win the battle it doesnt mean I win the war I got to laugh to keep from crying good times I really wonder what they are Even if I fell there's no reason to feel asamed Cause I use to lose I had an opertuntly to play in the game I can't be stopped 98 percent from the field But they won't pass the rock Even tho I'm wide open for the shot Got me ready to scream fuck my team Seem like the players I'm running with don't want me to touch my dream With my own hands I'm tierd of makeing money in the name of brothers I'm trying to touch it with my own hands Make me wanna rob a bank somtimes But then I have to spend my life my life my life my life Dunken one time And end up back in the pen So I'm stuck as starter paid as if I was riden a bench I know it look like I rich but it's not I just how to take what I got and wipe it so it looks like alot Sometimes I wanna give up but when I look at my daughter I got to survive Here we go again just to live another season I keep my faith in god to peace these demons Sometimes I win the battle it doesnt mean I win the war I got to laugh to keep from crying good times I really wonder what they are To many niggas trying to take me off of my game I'm trying to do somthing good but beacuse I'm from the hood I always end up in these chains When you see m… | ["Reggae"] | ["hip-hop", "male vocal", "female vocal", "rap-like singing", "electric guitar", "bass guitar", "electronic drums", "groovy", "hip", "urban", "southern rap sound"] | 9 | GRdzFvQezUE | 1723 | |
Learn with Little Baby Bum | Pet a Cake | Nursery Rhymes for Babies | ABCs and 123s | This is a kids music piece in the style of hip-hop. There is a female vocalist singing in a rap-like manner in the lead. The keyboard is playing the melody while there is a simple bass line in the background. A hip-hop electronic drum beat provides the rhythm. The atmosphere is playful. This piece can be used in the soundtrack of a kids TV show. | 2015-04-24T07:55:02Z | Little Baby Bum - Nursery Rhymes & Kids Songs | We're available on Spotify! https://open.spotify.com/playlist/05tdW3fw1NDaqVELGgYuWm?si=Z-alZcFWQGWFsJ1TX1TpSw SUBSCRIBE for new videos every week! ►https://goo.gl/59WdSj Watch More Little Baby Bum ► Songs About Numbers, ABC's and shapes: https://www.youtube.com/watch?v=wwdqK_XNBNM&list=PL0VE_cI7-AYRotjbI1cGFg8zscyzgFClS LBB TV: https://www.youtube.com/watch?v=fQTDpa_c-nk&list=PL0VE_cI7-AYRx9Qbz5C0oQix0AO6YdCtw LBB and friends: https://www.youtube.com/watch?v=J3htU652mBY&list=PL0VE_cI7-AYSuxGdfT5N15Aks-y_HbNg7 Ten little animals | Counting for kids: https://www.youtube.com/watch?v=lX2NvIQS8iM ABC song: https://www.youtube.com/watch?v=ezdzxieXJvc 0:04 Pat A Cake 1:04 Wheels On The Bus - part 5 2:57 The Grand Old Duke Of York 4:14 Row Row Row Your Boat - part 2 6:55 Hickory Dickory Dock 8:12 Mr Sun 9:56 Numbers Song 1-20 12:06 The Bear Went Over The Mountain 13:56 One Potato, Two Potato 15:53 Days Of The Week 17:31 Hey Diddle Diddle 19:46 Baa Baa Black Sheep - part 1 20:38 Twinkle Twinkle Little Star 22:46 Brush Teeth Song 24:29 Shapes Song 26:27 Wheels On The Bus - part 6 28:24 Head, Shoulders, Knees & Toes 30:25 Five Little Monkeys - part 2 32:39 BINGO 34:36 Old MacDonald Had A Farm - part 1 35:51 Old MacDonald Had A Farm - part 2 38:06 ABC Phonics 39:35 Baa Baa Black Sheep - part 2 40:50 Wash Hands Song 42:31 Mary Had A Little Lamb 44:12 Ten In The Bed 46:41 Three Little Kittens 48:57 Potty Song 50:19 Rainbow Colors Song 51:50 Ten Little Animals 53:10 Row Row Row Your Boat - part 1 #nurseryrhymes #littlebabybum | ["Music", "Music for children"] | ["kids song", "hip-hop", "female vocal", "rap-like singing", "keyboard", "bass", "electronic drums", "playful", "cheerful", "urban"] | 9 | SMjYheNdAzg | 2763 | |
Tinashe Performs '2 On' Live At The Viper Room | This is a live performance of an alternative R&B music piece. There is a female vocalist singing in a seductive manner in the lead. Later on, a male vocalist starts rapping. There is a groovy bass line in the background. The DJ is scratching the turntable. The rhythmic background is provided by an R&B acoustic drum beat. The atmosphere is sensual and the sound is urban. Sounds of the crowd cheering can be heard in the recording. | 2014-05-28T20:28:16Z | xoNecole | New artist Tinashe performs her hit song 2 On Live At The Viper Room in Los Angeles | ["Singing", "Scratching (performance technique)", "Music"] | ["alternative r&b", "live performance", "female vocal", "seductive singing", "male vocal", "rapping", "turntable", "scracthing", "groovy bass", "acoustic drums", "crowd cheering", "sensual", "groovy", "urban"] | 9 | _GQnXfIGNKY | 3455 | |
Does He Love Me by Keshia Chante | This is an R&B/hip-hop music piece. There is a female vocalist singing melodically. The melody is being played by the keyboard which has a crisp sound. There is a strong bass sound in the background. The rhythm is provided by a loud acoustic drum beat. The atmosphere is hip and urban. This piece could be used in the soundtrack of a drama movie that takes place in the big city. | 2007-06-13T22:08:12Z | Keshia Chante | Official "Does He Love Me" Video by Keshia Chante. Directed by Little X. Made in 2004; Keshia was 16. | ["Funk", "Music"] | ["r&b", "hip-hop", "female vocal", "melodic singing", "keyboard", "strong bass", "electronic drums", "hip", "groovy", "urban"] | 9 | dsVzafZik3c | 3822 | |
saray danez es mejor musica cristiana | This is a Christian pop piece. There is a telephone sound effect in the opening. There is a female vocalist singing melodically as the lead. The melody is being played on the acoustic guitar and the keyboard. The rhythm is provided by an electronic drum beat. There is a modern feel to this piece. It could be used in the background of social media content related to Christianity. | 2008-12-27T19:08:53Z | cristianoactur | ["Busy signal", "Music"] | ["christian pop", "gospel", "telephone sound effect", "female vocal", "melodic singing", "keyboard", "acoustic guitar", "electronic drums", "religious", "modern", "urban"] | 9 | hlquKjPgxmY | 4138 | ||
LOOSE ENDS HANGIN ON A STRING | This is a soul/R&B music piece. There is a trio of two male vocalists and a female vocalist singing melodically. The keyboard is holding the chords in the background while the electric guitar and the bass guitar are playing a groovy tune. The rhythmic background contains an electronic drum beat. The atmosphere is urban. The piece could be played during a retro-themed party at a nightclub. | 2011-05-05T23:25:50Z | PaulinaDePoros559 | I've waited oh so long for you to come to me What did I do wrong It's all a mystery to me Baby I feel it too What am I supposed to do Maybe I've just changed Or could I be wrong for you You,you've got me hangin' on a string now I'm not your plaything You,you've got me hangin' on a string now Am I your plaything You never told me you were waiting,contemplating With my heart,my love You never told me you were waiting,contemplating With my heart,my love Do you mean to say that after all this time i've waited like a fool now who's been changin' you You,you've got me hangin' on a string now I'm not your plaything You,you've got me hangin' on a string now I aint your plaything You,you've got me hangin' on a string now I'm masquerading You,you've got me hangin' on a string now I aint your plaything,whoa You never told me you were waiting,contemplating You never told me you were waiting,contemplating Come on, child Take me by the hand You,you've got me hangin' on a string now I'm not your plaything,no,no,no You,you've got me hangin' on a string now Hang on,hang on, yeah You,you've got me hangin' on a string now I'm not your plaything You,you've got me hangin' on a string now You never told me You,you've got me hangin' on a string now You never told me you were waiting,contemplating You,you've got me hangin' on a string now You never told me you were waiting,contemplating (I'm not your plaything) You,you've got me hangin' on a string now You never told me you were waiting,contemplating You,you've got me hangin' on a string now You never told me you were waiting,contemplating | ["Music", "Reggae"] | ["soul", "r&b", "male vocals", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "groovy", "funky", "urban"] | 9 | j8FYy5YfK7k | 4237 |
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;