musiccaps_details (view)
3 rows where musiccaps_aspects contains "digital bass" and musiccaps_aspects contains "techno"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- digital bass · 3 ✖
- techno · 3 ✖
- electronic drums 2
- uptempo 2
- arcade 1
- dance 1
- digital drums 1
- electronic noises 1
- fast tempo 1
- lofi melody 1
- male voice samples 1
- monoton 1
- riser 1
- sound-effects 1
- sub bass 1
- synthesizer sound 1
musiccaps_names (array) 11 ✖
youtube_published (date) 3 ✖
- 2008-11-15 1
- 2012-11-01 1
- 2013-12-31 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Goa Gil in Moscow @ Open Air 27.07.2013 (Live Video) | This song is full of electronic, percussive noises and effects. A kick is playing on every beat with some sharp hits. A bass is playing along with the kick. Male voice samples with delay can be heart to spice up the mix. This song may be playing at a rave in the woods. | 2013-12-31T03:15:03Z | TLNpromotion | Goa Gil in Moscow (Live Video) Org: T.L.N. Promotion Russia, Moscow, Open Air / 27.07.2013 Official Website: http://tlnpromo.com | ["Scratching (performance technique)", "Music", "Song", "Trance music"] | ["techno", "electronic noises", "digital bass", "electronic drums", "male voice samples", "dance", "fast tempo"] | 6 | EL2DtgPD4J4 | 1547 | |
Set On Fire - Swedish Revolution | This song is full of reverb and delay in the beginning. A riser effect is rising up to break into the next part of the song. Then a digital drum with kick and snare comes in along with a monotone bassline. A synthesizer is playing a rhythmic, very simple and monotone melody on top. The sound-elements are all panning from left to right with a ping pong delay. | 2012-11-01T03:34:40Z | 1.7m Views Aria Records | My wild InstaGram: http://goo.gl/bnSfC Top Rated Christian Dance & Christian Dubstep Producer/DJ. Swedish Revolution @swedrevolution and my aliases: ARIA, Slovack, Christian t. Dubstep, ARIA Records. Follow on soundcloud for A-LOT of free music http://snd.sc/XUidyC TWITTER: @Swedrevolution FB: http://goo.gl/2tzYF Song: Set On Fire Artist: Swedish Revolution (Christian t. Dubstep Dance mix) .................................................. Twitter-- http://twitter.com/#!/AAABandProd FB label-- http://www.facebook.com/AAAElectrodubstep FB Swedish Revolution-- http://www.facebook.com/pages/Swedish-Xian-Revolution/208268712636259 FB Slovack-- http://www.facebook.com/SlovackMusic FB Christian t.-- http://www.facebook.com/pages/Christian-t-Dubstep/232924330163285 Instagram-- http://www.gramfeed.com/aaabandproductions FREE MUSIC!: http://soundcloud.com/aaabandproductions (scroll down) AAA Band and Swedish Revolution. Slowly becoming the largest Christian Dance, Dubstep, Electro, Techno Record Label in the world. Slovack is AAA's premier Producer-DJ. ARE YOU AN ARTIST WHO WANTS TO GET ON SIGNED? Website-- http://www.AAABand.net Best Christian Dubstep site 1: http://www.christian-dubstep.com Best Christian Dubstep site 2: http://www.dubstepchristian.com We Support Recycling: http://www.AVArecycling.com Become a part of the CEDM Alliance and help support Christian EDM http://www.ChristianEDM.com/ FB Aria Christian Dubstep: http://www.facebook.com/christiandubstep ALL Right Reserved We support Recycling http://www.avarecycling.com http://www.mr-advocate.com http://www.servicehawk.co http://www.it-asset.net http://www.escrap.org http://www.tvjunk.co http://www.2guys.co http://www.e-scrap.net http://www.my-itad.com http://www.chicagoshredder.com http://www.recyclecomputerchicago.com http://www.oakbrookcomputerrecycling.com http://www.schaumburgcomputerrecycling.com http://www.cincyrecycling.com http://www.microant.co | ["Disco", "Music", "Dubstep", "Electronic dance music", "Dance music"] | ["techno", "riser", "sound-effects", "electronic drums", "digital bass", "monoton", "synthesizer sound", "uptempo"] | 6 | RQbNC1J4Jfk | 2701 | |
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;