musiccaps_details (view)
2 rows where musiccaps_aspects contains "percussive bass line" and musiccaps_aspects contains "techno dance music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- dj 2
- keyboard accompaniment 2
- percussive bass line · 2 ✖
- techno dance music · 2 ✖
- backup singers 1
- careless nights 1
- cheerful 1
- couples dancing 1
- dance club 1
- dance floor 1
- dance with you 1
- disc scarring tones 1
- dj face off 1
- dj lessons online 1
- electronic dance music 1
- enthusiastic 1
- exciting 1
- fast percussion rhyme 1
- fast tempo 1
- female singer 1
- groovy 1
- ibiza nights 1
- instrumental music 1
- medium tempo 1
- party night 1
- passionate 1
- percussive hits 1
- piano accompaniment 1
- positive 1
- romantic 1
- scratch tutorials 1
- scratching disc tones 1
- screaming josies 1
- slow dance 1
- steady drumming rhythm 1
- sundowner 1
- syncopated rhythms 1
- tropical beach party 1
- vinyls 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 3 ✖
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 | |
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 |
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;