musiccaps_details (view)
1 row where musiccaps_aspects contains "digital bass", musiccaps_aspects contains "riser" and musiccaps_names contains "Dubstep"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;