musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Scratching (performance technique)"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- energetic · 3 ✖
- medium tempo · 3 ✖
- dance floor 2
- dj turntable 2
- electronic dance music 2
- groovy music 2
- all night party 1
- ambient noises 1
- arpeggios 1
- average audio quality 1
- dance music 1
- dance party 1
- dance rhythm 1
- digital drums 1
- disc scratching noises 1
- discotheque 1
- dj 1
- dj face off 1
- dubstep 1
- exciting 1
- female singer 1
- groovy rhythm 1
- male vocals 1
- people dancing 1
- poor audio quality 1
- rapping vocals 1
- repeated vocal phrases 1
- retro electronica 1
- scratching disc 1
- spinning discs 1
- …
musiccaps_names (array) 6 ✖
- Music 3
- Scratching (performance technique) · 3 ✖
- Speech 2
- Drum and bass 1
- Electronic music 1
- Hip hop music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1st Place DJ NIFFTY - 2010 World DMC DJ Championships - South African Final | A male singer sings this rapping vocals with a backup singer. The song is medium tempo with a groovy drum rhythm, disc scratching sounds, strong bass line and string accompaniment. The song is groovy and has a dance rhythm. The song audio quality is poor. | 2010-09-30T14:21:46Z | edptv | Produced by: www.blackbirdproductions.co.za 2010 South African DMC DJ Championships Final. MULTI-CAM of Live Set - DJ NIFFTY - Club Atmospheer - Cape Town - South Africa. RESULTS: 1st - DJ NIFFTY (2010 South African DMC DJ Champion) http://www.youtube.com/watch?v=6YXjJ6ABnZU 2nd - DJ CODAX http://www.youtube.com/watch?v=dibExyXfC3c 3rd - DJ ON Q http://www.youtube.com/watch?v=rCIoFNNOdOE FINALISTS: DJ CALCULUS http://www.youtube.com/watch?v=kvmBoL-tmtA DJ SHAMELESS http://www.youtube.com/watch?v=Uo5YJZ6RFbI DJ MARV D http://www.youtube.com/watch?v=1NqCsKCitfA DJ JUICE http://www.youtube.com/watch?v=J4xzSdnnFLM | ["Scratching (performance technique)", "Electronic music", "Music", "Speech"] | ["techno pop music", "male vocals", "rapping vocals", "dance party", "all night party", "discotheque", "dance floor", "dance rhythm", "energetic", "exciting", "medium tempo", "dj turntable", "ambient noises", "poor audio quality", "dance music", "electronic dance music", "groovy music", "dj face off", "disc scratching noises"] | 1 | 6YXjJ6ABnZU | 766 | |
DJ Shortee - "Watch Out Now" Beatjuggle Routine 2003 | A DJ plays a cool groove with some female vocals. The song is medium tempo with a steady drumming rhythm, scratch disc percussions, and percussive bass line. The song is exciting and groovy. The audio quality is average. | 2006-08-07T01:33:25Z | DJ Shortee | Turntablist beat juggle routine performed by Shortee in 2003 with the Beatnuts' song "Watch Out Now". Featured on "Shortee's DJ 202" Instructional DVD available on www.how2dj.com. Learn more about shortee at www.djshortee.com! | ["Scratching (performance technique)", "Music", "Speech", "Hip hop music"] | ["dj", "female singer", "repeated vocal phrases", "techno dance music", "average audio quality", "groovy music", "dj turntable", "spinning discs", "scratching disc", "energetic", "groovy rhythm", "strong bass line", "steady rhythm", "medium tempo", "people dancing", "retro electronica", "electronic dance music", "dance floor"] | 1 | J0t4VMnXDNM | 1960 | |
Vinyl Scratch - Think Again Loosa | This song contains digital, dubstep drums with a straight hi hat playing 8th notes. An aggressive bass sound full of modulation and other samples is playing a melody with a lot of pitch shifts and stutter effects. A voice sample is being used with a lot of reverb and delay as an atmospheric element. Some sounds are being arpeggiated playing a fast melody before leaving the scenario again. This song may be playing in an extreme sports advertisement. | 2012-12-27T23:30:08Z | YourDailyMusicz | ✖ Connect with the Artist YouTube: http://www.youtube.com/user/VinylScratchDjPony Facebook: http://www.facebook.com/VinylScratchOfficial Twitter: https://twitter.com/vinyl_scratchdj ✖ Connect with YDL Network Apply for Partnership & Directorship [No View Minimum] [Music only]: http://bit.ly/OYUZWp Apply for standard Partnership: http://www.yourdailylaughz.tv/apply * Notice: YDM Channel is Not a 'non-copyright' channel. Uploading such materiel from YDM or the Artist themselves will result in infringement upon the third party. --- | ["Scratching (performance technique)", "Drum and bass", "Music"] | ["dubstep", "digital drums", "synth bass sound", "voice sample", "arpeggios", "medium tempo", "energetic"] | 6 | dsf3agfkJDY | 3823 |
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;