musiccaps_details (view)
3 rows where musiccaps_aspects contains "sub bass" and musiccaps_names contains "Electronic music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- sub bass · 3 ✖
- dubstep 2
- arcade 1
- digital bass 1
- digital drum 1
- digital drums 1
- electronic drums 1
- industrial 1
- lofi melody 1
- medium tempo 1
- medium to uptempo 1
- saw wave pad sounds 1
- synth sound 1
- techno 1
- uptempo 1
musiccaps_names (array) 6 ✖
- Electronic music · 3 ✖
- Music 3
- Dubstep 2
- Drum and bass 1
- Soundtrack music 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
Tetris Theme (Techno Remix) | This song contains digital drums with an overdrive kick going together with a digital bass. Another synth sub bass is playing a melody. On top of that a lofi bitrate sound is playing a melody in the higher register. This song may be playing during a videogame. | 2008-11-15T19:05:56Z | TechnoHeroine | A great remix of the classic Tetris theme! (Just so everyone knows, I DID NOT remix this song, I just uploaded it.) | ["Electronic music", "Music", "Techno", "Soundtrack music"] | ["techno", "lofi melody", "digital bass", "digital drums", "sub bass", "uptempo", "arcade"] | 6 | v3wR3aIQ23w | 5150 |
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;