musiccaps_details (view)
1 row where musiccaps_aspects contains "keyboard accompaniment", musiccaps_aspects contains "positive", 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 |
---|---|---|---|---|---|---|---|---|---|---|
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;