musiccaps_details (view)
4 rows where musiccaps_aspects contains "digital drums" and musiccaps_names contains "Rhythm and blues" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- digital drums · 4 ✖
- bass 2
- acoustic guitar riff 1
- alternative 1
- boomy bass line 1
- club music 1
- contemporary hip-hop 1
- cool attitude 1
- cowbell 1
- dance groover 1
- dance music 1
- dance pop 1
- dj 1
- drum machine 1
- e-piano 1
- emotional 1
- enthusiastic vocal backup 1
- female voice sample 1
- groovy 1
- higher register 1
- hip-hop 1
- hiphop 1
- keyboard strings 1
- male vocalist 1
- male voice rapping 1
- male voices singing 1
- male voices singing/rapping 1
- medium tempo 1
- passioante 1
- piano 1
- positive vibes 1
- punchy drums 1
- r&b/pop 1
- rap 1
- rhythmic patter 1
- salsa/hiphop 1
- slow tempo 1
- synthesiser arrangement 1
- trumped sample 1
- uptempo 1
musiccaps_names (array) 8 ✖
- Music 4
- Rhythm and blues · 4 ✖
- Rapping 2
- Zing 2
- Hip hop music 1
- Music of Africa 1
- Singing 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
CORREA BROTHERS INC, ESCOBAR MUSIC, MIXTER ED, PBM,AMY BELL | This song is a classical flamenco mixed with a HipHop groove drums playing a digital set along with a cowbell sound. A piano is playing a salsa melody in the low to high range. A trumpet sample is playing a short melody every fourth beat. A male voice is singing in a higher pitch along with backing vocals spread across both sides of the speakers. Then another male voice takes over rapping over the instrumental. This song may be playing with a speaker sitting on the bike cruising. | 2008-09-28T09:12:17Z | Ed Correa | CORREA BROTHERS INC, ESCOBAR MUSIC, MIXTER ED, PBM,AMY BELL | ["Music of Africa", "Music", "Rapping", "Rhythm and blues", "Soul music"] | ["salsa/hiphop", "digital drums", "cowbell", "trumped sample", "piano", "male voices singing/rapping", "uptempo", "positive vibes"] | 6 | LF-5BAUGvWI | 2166 | |
TC - Heres My Chance | The instrumental contains digital drums repeating a simple groove that is mostly kick and snare that sounds like a strong clap. In the background synthesizer sounds playing melodies all over the place being panned to the left and right side of the speakers. Male voices singing in a higher key and overlapping each other. The bass sounds digital and soft. This song may be playing while practicing dancing. | 2012-03-25T16:21:16Z | RnBberlin2 | NEW RNB SONG 2012!!!!! http://www.facebook.com/people/Marcus-Mustafi%C4%87/100003197870523 | ["Music", "Rhythm and blues", "Zing"] | ["r&b/pop", "bass", "keyboard strings", "digital drums", "higher register", "male voices singing", "slow tempo"] | 6 | jhQpTVVUQ9E | 4273 | |
Squeak Ru (Allfrumtha I) - Lockdown (1999) | A digital drum is playing a simple groove with a digital bass. An e-piano is playing 2 chords to add some color to the song. A male voice is rapping with light adults in the background. In the background a female voice sample is coming in singing a little melody. This song may be playing in a car slowly riding down the streets. | 2012-11-07T23:15:35Z | Banginmytrackzsucka | Mob Tales Compilation (1999) | ["Music", "Rapping", "Rhythm and blues", "Zing"] | ["hiphop", "digital drums", "e-piano", "bass", "male voice rapping", "female voice sample", "cool attitude"] | 6 | uy3nQ9VYE-Q | 5145 | |
I'm N Luv (Wit A Stripper) 2 -Tha Remix (Official HD Video) | A male vocalist sings this catchy Hip-Hop. The tempo is medium with an acoustic guitar riff, boomy bass drops, punchy drumming, digital beats and synthesiser arrangement with enthusiastic vocal backup. The song is youthful, buoyant, punchy, groovy, pulsating with a dance groove. This song is Contemporary Hip-Hop. | 2009-10-25T19:59:01Z | TPainVEVO | "I’m In Luv With A Stripper" by T-Pain (Remix) Listen to T-Pain: https://tpain.lnk.to/listenYD Watch more T-Pain videos: https://tpain.lnk.to/listenYD/youtube Subscribe to the official T-Pain YouTube channel: https://tpain.lnk.to/subscribeYD Follow T-Pain: Facebook: https://tpain.lnk.to/followFI Instagram: https://tpain.lnk.to/followII Twitter: https://tpain.lnk.to/followTI Website: https://tpain.lnk.to/followWI Spotify: https://tpain.lnk.to/followSI YouTube: https://tpain.lnk.to/subscribeYD Lyrics: She poppin, she rollin, she rollin She climbin that pole and I'm in love with a stripper She trippin, she playin, she playin I'm not goin nowhere girl, I'm stayin, I'm in love with a stripper She poppin, she rollin, she rollin She climbin that pole and I'm in love with a stripper She trippin, she playin, she playin I'm not goin nowhere girl, I'm stayin, I'm in love with a stripper #TPain #ImInLuvWithAStripper #OfficialHDVideo #HD | ["Singing", "Music", "Rhythm and blues", "Hip hop music"] | ["male vocalist", "medium tempo", "emotional", "passioante", "rhythmic patter", "groovy", "dance pop", "dance groover", "dj", "club music", "dance music", "enthusiastic vocal backup", "digital drums", "punchy drums", "drum machine", "boomy bass line", "acoustic guitar riff", "synthesiser arrangement", "hip-hop", "rap", "contemporary hip-hop", "alternative"] | 7 | vqRFzhWik2c | 5210 |
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;