musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "keyboard accompaniment" and musiccaps_aspects contains "passionate"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| DJ Snake & AlunaGeorge - You Know You Like It (T-Mass & Arman Cekin Remix) | A female singer sings this cool melody with backup singers in vocal harmony. The song is fast tempo with a percussive bass line, steady drumming with various percussion hits, keyboard harmony and other sonic effects. The song is groovy and exciting. The song is a modern techno dance hit. | 2015-05-09T16:08:18Z | Trap City | PREMIERE: DJ Snake & AlunaGeorge - You Know You Like It (T-Mass & Arman Cekin Remix) Subscribe here: http://trapcity.tv/subscribe Free Download: http://trapcity.tv/uvjbX ➥ Become a fan of Trap City: http://trapcity.tv/soundcloud http://trapcity.tv/facebook http://trapcity.tv/twitter http://trapcity.tv/instagram http://trapcity.tv/vine http://trapcity.tv/plugdj http://www.trapcity.net ➥ Follow T-Mass: http://www.soundcloud.com/t-mass http://www.facebook.com/tmassofficial http://www.twitter.com/tmassofficial http://www.instagram.com/tmassofficial ➥ Follow Arman Cekin: http://www.soundcloud.com/armancekin http://www.facebook.com/arman.cekin http://www.twitter.com/cekinarman http://www.instagram.com/armancekin | ["Disco"] | ["female singer", "backup singers", "vocal harmony", "techno dance music", "electronic dance music", "percussive bass line", "percussive hits", "keyboard accompaniment", "exciting", "dj", "party night", "dance with you", "careless nights", "exciting", "enthusiastic", "groovy", "passionate", "romantic", "ibiza nights", "tropical beach party", "sundowner", "fast percussion rhyme", "fast tempo"] | 1 | B2yLFcmZ51I | 1197 | |
| 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 |
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;