musiccaps_details (view)
4 rows where musiccaps_aspects contains "exciting", musiccaps_author = 4 and musiccaps_names contains "Dubstep"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- exciting · 4 ✖
- energetic 3
- low quality 3
- punchy kick 3
- electro 2
- energetic crash cymbal 2
- punchy snare 2
- 4 on the floor kick 1
- addictive synth lead 1
- addictive synth lead melody 1
- aggressive synth lead melody 1
- arpeggiated synth melody 1
- build up 1
- claps 1
- dubstep 1
- electro house 1
- filtered drums 1
- hard synth bass 1
- intense 1
- intense siren sound effect 1
- man yelling sound effect 1
- manic laughing sound effect 1
- punchy synth stabs 1
- shimmering hi hat 1
- snare roll 1
- snare rolls 1
- speeding up wide synth lead 1
- suspenseful 1
- sustained organ synth keys chords 1
- synth bass swell 1
- synth pad chords 1
- white noise riser 1
musiccaps_names (array) 11 ✖
- Dubstep · 4 ✖
- Music 4
- Electronic dance music 3
- Techno 3
- Dance music 2
- Drum and bass 2
- Electronica 2
- House music 2
- Buzz 1
- Soundtrack music 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Game Grumps Remix - Zombies Ate My Dubstep [Atpunk] | The low quality recording features a dubstep song that consists of manic laughing sound effects, man yelling sound effects, punchy snare and kick hits, shimmering hi hats, hard synth bass, aggressive synth lead melody and energetic crash cymbals. The mix of the song is not very good, thus the quality of the recording is lower - although it sounds energetic and exciting. | 2012-09-20T15:55:59Z | Atpunk | Zombies Ate My Dubstep is a Game Grumps remix inspired by the Zombies Ate My Neighbors play though. Free Download at SoundCloud and Media Fire http://soundcloud.com/atpunk/game-grumps-zombies-ate-my http://www.mediafire.com/?exiu8zi2zwmmcvj Instrumental on Bandcamp http://atpunk.bandcamp.com/ CLIPS USED: Zombies Ate My Neighbors, Episode 5 & 6 LYRICS: Oh no Oh here he comes....Oh NO! GO GO! OH GOD! (repeat) (I don't wanna play this game anymore) (I can't deal with the stress) What is happening? Dude I can't deal. Dude, you know what my secret is? I'M ALWAYS ANGRY! Ooooh Punchin' blobs, and I don't even care what's goin' on (Jibberish) Blow that cabinet up This one was breakable apparently....And I don't ask why. (repeated) SHOW SUPPORT! Game Grumps: http://www.youtube.com/user/GameGrumps?feature=watch Jon Tron: http://www.youtube.com/user/JonTronShow Egoraptor: http://www.youtube.com/user/egoraptor | ["Drum and bass", "Music", "Buzz", "Dubstep"] | ["low quality", "dubstep", "punchy kick", "punchy snare", "shimmering hi hat", "manic laughing sound effect", "man yelling sound effect", "hard synth bass", "aggressive synth lead melody", "energetic crash cymbal", "energetic", "exciting"] | 4 | DlVgHV1UobM | 1510 | |
Misanthrop - Rotor [RAM Records] | The Electro song loop features a build up section that consists of intense siren sound effect, synth bass swell, arpeggiated synth melody, punchy kick layered with synth stabs, snare rolls and some claps. It sounds suspenseful, intense and exciting. | 2015-09-30T11:59:03Z | NeurofunkGrid | I've waited so long for this tune. Out on the 16th of October via RAM Records. Pre-order: http://po.st/CollapseRAM - Misanthrop - Like ► http://www.facebook.com/Misanthrop.Neosignal Follow ► http://www.twitter.com/MisanthropNSGNL - RAM Records - Like ► https://www.facebook.com/RAMrecordsltd Follow ► https://twitter.com/RAMrecordsltd - NeurofunkGrid - Like ► http://www.facebook.com/NeurofunkGrid Follow ► http://www.twitter.com/NeurofunkGrid Watch ► http://www.youtube.com/NeurofunkGrid Listen ► http://www.soundcloud.com/NeurofunkGrid Get down ► http://www.mixcloud.com/NeurofunkGrid Party ► http://plug.dj/the-neurofunkgrid Merch Store ► http://neurofunkgrid.spreadshirt.fr/ Subscribe ► http://www.youtube.com/subscription_center?add_user=neurofunkgrid Logo by http://kay486.deviantart.com Animation by http://waysh.deviantart.com/ | ["Drum and bass", "Music", "Techno", "Dubstep", "Electronic dance music", "Electronica"] | ["low quality", "build up", "intense siren sound effect", "synth bass swell", "arpeggiated synth melody", "punchy kick", "claps", "punchy synth stabs", "snare rolls", "suspenseful", "exciting", "electro"] | 4 | JIoA1KsfioQ | 1989 | |
Phantom of The Opera (OSODOPEO Electro-house / Dubstep Remix) | The Electro House song features sustained organ keys, chords, filtered drums, punchy kick hits layered with energetic crash and addictive synth lead melody. Right before the drop, there is a short snare roll. It sounds energetic, intense and exciting, as the song is preparing to drop. | 2012-04-30T01:06:08Z | OSODOPEO (Official) | Check out my originals and other remixes! www.soundcloud.com/osodopeo | ["House music", "Music", "Techno", "Trance music", "Dubstep", "Electronic dance music", "Dance music", "Soundtrack music"] | ["electro house", "sustained organ synth keys chords", "snare roll", "filtered drums", "punchy kick", "addictive synth lead melody", "energetic", "exciting", "intense", "energetic crash cymbal"] | 4 | JZWJlUdYpCU | 2018 | |
Best Dance Music 2012 New Electro House Music May June 2012 - Mixed by DJ Hell Rider | The electro song features a speeding up, widely spread, synth lead, white noise riser and punchy snare going from left to the right channel in the stereo image. At the very beginning there is a short snippet of a bit more energetic part which contains "4 on the floor" kick pattern, synth pad chords and addictive synth lead. Overall it sounds energetic and exciting. | 2012-05-29T03:33:15Z | Petr K. | Best New House and Electro Music Mix June 2012 - Mixed by DJ Hell Rider - http://www.facebook.com/HellRiderDJ - thanks for likes:) Download link: on facebook: http://www.facebook.com/HellRiderDJ Tracklist: = Coming soon or 50 likes | ["House music", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music", "Electronica"] | ["electro", "punchy snare", "speeding up wide synth lead", "white noise riser", "low quality", "addictive synth lead", "4 on the floor kick", "synth pad chords", "energetic", "exciting"] | 4 | OwukabRF7I4 | 2484 |
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;