musiccaps_details (view)
2 rows where musiccaps_aspects contains "enthusiastic", musiccaps_aspects contains "exciting", musiccaps_aspects contains "fast tempo" and musiccaps_aspects contains "groovy"
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 | |
HARLEM SHAKE BEATBOX:: electro :: ChrizpyBBX | A male musician vocalises this energetic rhythm. The tempo is fast with rhythmic beats. The music has no instrumentation. It is youthful, energetic, groovy, enthusiastic and upbeat.This music is a Vocal percussion imitation. | 2013-02-12T21:44:34Z | oOchrizpyOo | Guys my name is Chrizpy, I am a beatboxer based out of B.C. I hope you all enjoy my videos and my new age style of beatboxing. Please show some support and subscibe to my channel!! I love you all!!! Please like my Facebook page: https://www.facebook.com/Chizpy.Beatbox?ef=hl Check out my YouTube channel: https://www.youtube.com/use/oOchizpyOo Follow me on Twitter: https://twitter.com/ChrizpyBBX Vine: @ChisGouchie Instagram: @ChrizpyBBX Bookings: chrizpybookings@hotmail.com | ["Beatboxing", "Music"] | ["male vocalist", "fast tempo", "beat boxing", "exciting", "enthusiastic", "energetic", "dance rhythm", "hip-hop", "rap", "no instrumentation", "vocal percussion", "mimicking drum machine", "vocal drum simulation", "groovy", "upbeat", "catchy", "rhythmic", "drum pads"] | 7 | y9hdu9iMBG8 | 5387 |
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;