musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "keyboard accompaniment", musiccaps_aspects contains "medium tempo" and musiccaps_author = 7
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
STEPHEN CURRY I SOULJA BOY I OFFICAL MUSIC VIDEO HD 2015 🎵 | A male vocalist sings this HIp-hop. The tempo is medium with subdued keyboard accompaniment, slick drumming, boomy bass drops, synthesised arrangements and vocal backup. The song is youthful; enthusiastic, passionate, insistent, repetitive, groovy,rhythmic chanting with a dance groove. This song is Contemporary Hip-Hop/Rap. | 2016-01-25T22:24:17Z | Mike P | (No copyright infringement is intended) All rights belong to the NBA & ESPN. Entertainment. Music: Soulja Boy - Stephen Curry This for my boy Steph Curry We did it Yeah [Hook] I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish, swish Stephen Curry, Stephen Curry, Steph Curry Stephen Curry, Steph Curry, swish Steph Curry I'm stuntin' on 'em like I'm Stephen Curry [Verse 1] Steph Curry Number 30 I was stuntin' on 'em, they wouldn't believe me Shootin' 3's from half court, make it look easy I'm the best point guard in the league NBA All day I cross Lebron, shot a 3 in his face Steph Curry, I be Curry with the shot boy I be Chef Curry with pot boy [Hook] I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish, swish Stephen Curry, Stephen Curry, Steph Curry Stephen Curry, Steph Curry, swish Steph Curry I'm stuntin' on 'em like I'm Stephen Curry [Verse 2] I know that they hate Cause this dope nation Ghost, they want me (?) we made it All we had to do was be some patience So we been patient And I done haters Steph Curry pullin' up with a new drop Steph Curry, make a half court jump shot Hop up out the 'Rari with a lot of guap I'm team Curry (?) [Hook] I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish, swish Stephen Curry, Stephen Curry, Steph Curry Stephen Curry, Steph Curry, swish Steph Curry I'm stuntin' on 'em like I'm Stephen Curry [Outro] Aye, aye, aye, swish Aye, aye, aye, aye Aye, aye, aye, aye Congratulations my boys Keep doin' your thing boo Know I'm a big fan, nigga Congratulations my boys Forreal Copyright Disclaimer Unde… | ["Music", "Zing", "Hip hop music"] | ["male vocalist", "medium tempo", "rap", "raper", "vocal riff", "reverb", "syncopated background harmony", "hip-hop", "pop rap", "rhythmic patter", "boomy bass lines", "slick drumming", "drum machine", "digital drums", "rhythmic", "chanting", "repetitive", "passionate", "insistent", "keyboard accompaniment", "synthesiser arrangements", "electronic music", "groovy", "dance music", "trap", "trippy", "youthful", "female vocal backup"] | 7 | GwTXkfuc5v8 | 1764 | |
Israel Vibration African Unification | A male vocalist sings the Lord’s Prayer. The tempo is medium with Keyboard harmony, steady drumming, groovy basslines, rhythmic guitar,beat of shakers, vocal backup and a trumpet flourish. The music is simple, rhythmic, pleasant, catchy, soulful and punchy Reggae. There are sounds of people clapping and cheering in the background indicating that this is a live performance. | 2007-02-25T01:52:21Z | David Ruiz | Israel Vibration African Unification | ["Music", "Reggae", "Ska"] | ["male singer", "medium tempo", "reggae", "live performance", "stage performance", "concert", "rhythmic acousitc guitar", "clapping cheering", "vocal backup", "shakers", "pleasant", "punchy", "groovy", "happy", "simple", "pleasant", "reggae tones", "groovy bass lines", "trumpets", "brass band", "shakers", "steady drumming", "keyboard accompaniment", "the lord’s prayer", "carrie an music", "african music", "r&b", "world music", "catchy"] | 7 | blsYgo-B1k8 | 3650 |
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;