musiccaps_details (view)
3 rows where musiccaps_aspects contains "sub bass" and musiccaps_names contains "Dubstep" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- dubstep 3
- sub bass · 3 ✖
- dark 1
- digital drum 1
- digital drums 1
- electronic drums 1
- industrial 1
- medium tempo 1
- medium to uptempo 1
- saw wave pad sounds 1
- slow to medium tempo 1
- synth saw sound 1
- synth sound 1
musiccaps_names (array) 8 ✖
- Dubstep · 3 ✖
- Music 3
- Electronic music 2
- Drum and bass 1
- Electronic dance music 1
- Electronica 1
- Hip hop 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 |
---|---|---|---|---|---|---|---|---|---|---|
Charlie Sheen Bi-Winning Dubstep - Ephixa (Official) With MP3 Download Dubstep=Winning | This song contains digital drums playing a simple dubstep groove with a strong snare sound. A subbass along with an aggressive synth sound playing the same melody one octave higher. This song may be playing in a Dubstep/Drum&Bass club. | 2011-03-02T14:59:03Z | DjEphixa | Dubstep. Get the quotes on a shirt @ http://charliesheen.viralprints.com Dubstep remix of Charlie Sheens interview about his coke and hooker parties. Video by Going Quantum. Mp3: http://www.mediafire.com/?63lx43ifjcqgx0d Charlie Sheens Youtube: http://www.youtube.com/user/charliesheen Video Editing by Going Quantum. http://www.youtube.com/user/goingquantum *Important Links* Livestream: http://www.ephixalive.com Facebook: http://www.facebook.com/ephixamusic Twitter: http://www.twitter.com/ephixa Soundcloud: http://www.soundcloud.com/ephixa Youtube: http://www.youtube.com/djephixa Artwork http://www.monstercatdesign.com Go check out his channel if you're into quality mixes of dubstep, hard electro, trance, hardstyle. I put the track together in 3 hours for the lols. This is what I did instead of studying for an exam. Enjoy and tigerblood Website: http://www.ephixa.com Facebook: http://www.facebook.com/pages/Ephixa/137145782681 Twitter: http://www.twitter.com/ephixa Soundcloud: http://www.soundcloud.com/ephixa P.S. Charlie Sheen is a GOD | ["Electronic music", "Music", "Dubstep"] | ["dubstep", "digital drum", "synth sound", "sub bass", "medium to uptempo"] | 6 | c1hLduV1p88 | 3674 | |
Dark Dubstep/Rap Beat - Psychos (RockItPro.com) | A digital drum beat repeats the same pattern with a strong and reverbed snare sound. An aggressive low to mid range sound is playing a melody underlined by a sub bass. On top of that a synth lead sound is playing a melody in the higher register that repeats itself the whole time. This song may be playing in an action video-game. | 2013-04-20T22:34:03Z | RockItPro | "Psychos" - Purchase at http://buybe.at/IGiG3y Visit our website for hundreds of Rap Beats, R&B Beats, Hip Hop Instrumentals, and Beats with Hooks https://www.RockItPro.com ► Website: https://www.RockItPro.com ► Facebook: https://www.facebook.com/RockItProductions ► Instagram: https://instagram.com/rockitpro/ ► Twitter: https://twitter.com/RockItPro ► Soundcloud: https://soundcloud.com/rockitpro | ["Music", "Trance music", "Dubstep", "Electronic dance music", "Hip hop music", "Electronica"] | ["dubstep", "dark", "digital drums", "synth saw sound", "sub bass", "slow to medium tempo"] | 6 | B41tuPoJ61c | 1202 | |
Optimus Prime (Dubstep dance) | In the foreground you can hear a saw wave pad playing along with a sub bass. This sound got some reverb and delay on it. The drums sound electronic and repeat a rhythm that leaves a lot of space for the bass sounds. This song may be played at a dance battle or an underground club. | 2010-05-01T18:00:45Z | JayGarderis | Music: Cookie Monsta - Optimus Prime http://www.facebook.com/JayGarderis | ["Drum and bass", "Electronic music", "Music", "Dubstep"] | ["dubstep", "industrial", "saw wave pad sounds", "sub bass", "electronic drums", "medium tempo"] | 6 | Q0KwG3ynscI | 2587 |
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;