musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "hip" and musiccaps_aspects contains "urban" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_description, musiccaps_names, youtube_published (date)
musiccaps_aspects (array) 24 ✖
- electronic drums 4
- hip · 4 ✖
- urban · 4 ✖
- male vocal 3
- bass 2
- bass guitar 2
- electric guitar 2
- groovy 2
- hip-hop 2
- rapping 2
- acoustic guitar 1
- british hip-hop music 1
- dance music 1
- dance-pop 1
- energetic 1
- female vocal 1
- female vocals 1
- flamboyant singing 1
- keyboard 1
- melodic singing 1
- playful 1
- rap-like singing 1
- shuffle 1
- southern rap sound 1
musiccaps_names (array) 7 ✖
- Music 2
- Reggae 2
- Hip hop music 1
- Music for children 1
- Music of Asia 1
- Pop music 1
- Rapping 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PlayDefo x30 Sound Party | This is a dance-pop music piece. There are two female vocalists singing melodically and rapping. The keyboard is playing the main tune while there is a bass guitar playing in the background. The rhythm consists of an electronic drum beat. There is a hip atmosphere. This piece could be used in the soundtrack of a teenage drama TV series as an opening theme. | 2013-12-25T12:38:16Z | iMiriaPWNZ | ["Music of Asia", "Music", "Music for children", "Pop music"] | ["dance-pop", "female vocals", "melodic singing", "rapping", "keyboard", "bass guitar", "electronic drums", "hip", "urban"] | 9 | 5JqTvKNXzOw | 653 | ||
Scorcher-My Diary | This is a British hip-hop music piece. There is a male vocal rapping in the lead. The beat in the background has its main melody being played by the acoustic guitar. A faint bass sound can be heard in the background. The rhythm is provided by an electronic drum beat. The atmosphere is hip and the sound is urban. This piece could be used in the soundtrack of a teenage drama movie that takes place in Great Britain. | 2007-11-06T16:36:28Z | lozyido4life | The Best version of this song | ["Reggae"] | ["british hip-hop music", "male vocal", "rapping", "acoustic guitar", "bass", "electronic drums", "hip", "urban"] | 9 | 5s0yPPrQWxs | 701 | |
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 | |
Hip Hop Academy Sid Shuffle | This is a hip-hop dance music piece. There is a male vocalist who is singing in a flamboyant manner. There is an electric guitar playing the melody joined by a strong bass sound. There is a groovy, urban atmosphere. This piece can be used as an accompaniment piece in modern dancing courses. | 2013-09-15T18:15:10Z | HipHopAcademy08 | ["Music", "Rapping", "Hip hop music"] | ["hip-hop", "dance music", "shuffle", "male vocal", "flamboyant singing", "electric guitar", "bass", "electronic drums", "playful", "groovy", "hip", "urban", "energetic"] | 9 | V9EFYFKlYbE | 2976 |
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;