musiccaps_details (view)
5 rows where musiccaps_aspects contains "keyboard accompaniment", musiccaps_aspects contains "techno dance music" and musiccaps_author = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|
Spliff Boy (N.B.T. Sound System) -Still In Da Place- (Trust In Records 01) | The song is an instrumental. The song is medium tempo with a steady drumming rhythm, cymbal crashes, groovy bass line and various percussion hits. The song is youthful and energetic. The song has an average audio quality. | 2013-03-24T22:46:29Z | KireKet | track A1 taken from N.B.T. Sound System "Trust In Records 01" (2009)...enJOY!!! | ["Sampler", "Drum and bass", "Music", "Drum machine", "Electronica"] | ["instrumental music", "techno dance music", "underground music", "cheerful", "teenagers dancing", "retro dance", "cymbal crashes", "steady drumming rhythm", "instrumental music", "dj", "keyboard tones", "discotheque", "dance floor", "dance club", "dance all night", "party night", "groovy bass line", "keyboard accompaniment"] | 1 | 6cQjwXNY4sc | 772 | |
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 | |
Makossa & Megablast feat. Hubert Tubbs - Coming Home (Skwerl's Throbbing Jet Lag Mix) | The song is an instrumental. The tempo is medium with a strong bass line, steady drumming rhythm, triangle percussion, keyboard accompaniment and a male vocalist making guttural noises. The song is a modern techno pop dance tune. | 2014-04-24T20:48:17Z | Tajak | Artist: Makossa & Megablast feat. Hubert Tubbs (Skwerl remix) Single: Coming Home (2010) Label: G-Stone Recordings http://www.beatport.com/release/coming-home/285482 | ["Music of Africa", "Drum and bass", "House music", "Music", "Electronic dance music"] | ["techno dance music", "gasping vocals sounds", "trance music", "dance hits", "triangle percussions", "instrumental music", "dj", "live session", "thumping bas slime", "keyboard accompaniment", "youthful", "energetic", "exciting", "party all night", "dance groove", "madly in love sexy", "romantic", "passionate", "steady drumming rhythm"] | 1 | IMnh-TIyFuE | 1898 | |
Chirp Scratch DJ Tutorial - How To Scratch | The song is an instrumental. The tempo is medium, with a dj creating vinyl scratch tones to a steady drumming rhythm, groovy bass line and a keyboard accompaniment. The song is youthful and groovy. The song is a techno dance rhythm. | 2009-11-17T16:11:29Z | Studio Scratches / School of Scratch | NEW updated HD video tutorials at: http://www.schoolofscratch.com For more info please visit: http://www.studioscratches.com/scratchy-100-chirp-scratch-tutorial/ Chirp Scratch Tutorial by DJ Short-e. One of Short-e's fav scratches! Short-E Scratches with her fader reversed or hamster style. See (http://www.studioscratches.com/hamster-reverse-vs-regular-scratching/) DJ Short-e teaches you how to do the Chirp scratch. Named because it sounds like a bird chirping away, this scratch is attained by playing the sample forwards and cutting the end of the sample off, then bringing the record back and turning the fader on. Repeat. You probably heard DJ Premier use this scratch loads and it can be really funky. Although relatively simple you can achieve much with this scratch, combining it with flares for the chirp flare. Beat # 8528 used in this clip is available here: http://studioscratches.bandcamp.com/album/85-bpm-hip-hop-instrumental-beats Happy Scratching! :D | ["Scratching (performance technique)", "Music"] | ["dj", "instrumental music", "medium tempo", "scratch tutorials", "dj lessons online", "scratching disc tones", "vinyls", "piano accompaniment", "screaming josies", "disc scarring tones", "syncopated rhythms", "steady drumming rhythm", "percussive bass line", "youthful", "positive", "cheerful", "dj face off", "techno dance music", "slow dance", "couples dancing", "dance floor", "dance club", "keyboard accompaniment"] | 1 | Kojo5khAAS0 | 2121 | |
Yalla Yalla Arabic House Music يَلا يَلا | A male singer sings Arabic vocals with backup singers in vocal harmony. The song is medium tempo with a steady drumming rhythm, percussive bass line, keyboard accompaniment and percussive hits. The song is an Arabic dance song. | 2009-07-14T19:44:28Z | Samuelinooo | Yalla Yalla .... With DJ Garphie feat KASRANI more from DJ Garphie http://www.traxsource.com/index.php?act=search&ss=dj+garphie&sc=artists&cf=all&gf=0 and http://soundcloud.com/djgarphie and http://www.facebook.com/pages/Dj-Garphie/70205312638 and http://www.facebook.com/pages/Think-House-Music-Deep-and-Soulful-house-music/178168948716 | ["Sampler", "Electronic music", "House music", "Music"] | ["techno dance music", "male singer", "male backup singers", "pulsating rhythm", "enegetic", "exciting", "youthful", "fun cheerful", "bad audio quality", "vocal harmony", "steady drumming rhythm", "groovy bass line", "steady drumming rhythm", "keyboard accompaniment", "dance music", "arabic electronic music", "arabic pop", "medium tempo"] | 1 | _8OIugVSFeE | 3446 |
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;