musiccaps_details (view)
3 rows where musiccaps_aspects contains "claps", musiccaps_aspects contains "electro" and musiccaps_aspects contains "punchy snare"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- claps · 3 ✖
- electro · 3 ✖
- energetic 3
- punchy snare · 3 ✖
- groovy 2
- low quality 2
- punchy kick 2
- 4 on the floor kick 1
- bouncy cowbell 1
- build up 1
- buzzy synth bass 1
- dj scratching sounds 1
- exciting 1
- exciting synth riser 1
- gliding synth lead melody 1
- groovy bass 1
- groovy synth keys chords 1
- metallic percussions 1
- repetitive male vocal 1
- shimmering hi hats 1
- shimmering shakers 1
- stretched low pitched male vocal 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
URF Kassadin - 1s Riftwalk CD | The low quality recording features an electro song that consists of a gliding synth lead melody played over groovy synth keys chords, exciting synth riser, punchy snare layered with claps, shimmering shakers and punchy kick hits. It sounds energetic and exciting, due to the fact that it is a build up section of the song. | 2016-04-11T15:06:37Z | Vandiril | Instant Gaming (PC Games -70%) - http://www.instant-gaming.com/igr/Vandiril/ Send me your replays here: vandiril88@gmail.com Follow me on Twitch, Facebook and Twitter: http://www.twitch.tv/vandiril https://www.facebook.com/Vandiril https://twitter.com/vandiril If you want to support me even more, you can donate here :) http://bit.ly/1tJNpmL Music: Dutty Moonshine - Takin' It Back https://www.youtube.com/watch?v=v4pTPigj0Gk https://soundcloud.com/duttymoonshine https://www.facebook.com/duttymoonshine | ["Sampler", "Electronic music", "Music", "Electronica"] | ["low quality", "electro", "gliding synth lead melody", "groovy synth keys chords", "exciting synth riser", "punchy snare", "claps", "shimmering shakers", "punchy kick", "energetic", "exciting", "build up"] | 4 | 7ym-LzgwSPE | 894 | |
Straight Outta Compton Scratch (IT'S TIME) Hashim - Al Naafiysh | The low quality recording features an electro song scratched by a DJ. The song consists of buzzy synth bass, bouncy cowbells, stretched low pitched male vocals, punchy kick, punchy snare layered with claps and shimmering hi-hats. It sounds energetic and groovy, like something you would hear in an underground club during the 90s. | 2016-02-04T01:31:26Z | kendo512 | This is my take on the popular juggle of Hashim - Al-Naafiysh (as seen in the scene with Dre in Straight Outta Compton). It's not perfect and there are better versions on YouTube, but it's hella fun and I wanted to upload it. This was done on the original Numark Mixtrack controller, and the crossfader is an absolute piece of trash, which made this way more difficult than it should be. Enjoy, and keep scratching! | ["Scratching (performance technique)", "Music", "Scratch"] | ["low quality", "electro", "stretched low pitched male vocal", "bouncy cowbell", "dj scratching sounds", "punchy kick", "claps", "punchy snare", "shimmering hi hats", "energetic", "groovy", "buzzy synth bass"] | 4 | NSS9_2FFVeo | 2338 | |
Fail, bloopers and funny accidents - Compilation 4 | The Electro song features a "4 on the floor" kick pattern, punchy snare, claps, groovy bass, metallic percussion and repetitive male vocal singing over it. It sounds groovy and energetic - like something you would hear in clubs. | 2011-05-22T16:49:16Z | Arneeeuh | Compilation of fresh failures, funny accidents, bloopers and more awesome stuff on camera. Video's gathered from all over the internet, and made a compilation of the best around nowadays. This is the fourth compilation, the other 3 can be found here: First compilation: http://www.youtube.com/watch?v=LocjTZhY95A Second compilation: http://www.youtube.com/watch?v=xl0DZR7f8H0 Third compilation: http://www.youtube.com/watch?v=cY3cdSPEvek If you liked the video please SUBSCRIBE since I'm going to create a lot more on a very frequent basis! So yes, more is coming very soon! Stay tuned! Music: Dead or Alive - You Spin Me Round (Like a Record) (Remix) Intro music by Pervy Panda: http://soundcloud.com/pervypanda http://www.schermbeschermers.com Fail, bloopers and funny accidents - Arne's Compilation 4 | ["Disco", "House music", "Music", "Dance music"] | ["electro", "4 on the floor kick", "punchy snare", "claps", "groovy bass", "metallic percussions", "repetitive male vocal", "groovy", "energetic"] | 4 | m-S-yqzlOj4 | 4436 |
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;