musiccaps_details (view)
3 rows where musiccaps_aspects contains "techno", musiccaps_names contains "Disco" and musiccaps_names contains "Electronic dance music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
DJ JUANCHO LA CHANGA SOUND CAR 2015 | This song contains digital drums with a deep low kick sound, a sharp hi hat and a loud bellsound with its own rhythm. A synthesizer is playing a lead sound in the mid range before jumping up an octave after a male scratched vocal sample is being played. This song may be playing in a club. | 2015-02-16T20:07:44Z | DJ WUILLIAN CAR AUDIO EL ORIGINAL | ["Disco", "Music", "Techno", "Electronic dance music"] | ["techno", "synthesizer", "digital drums", "male voice sample", "uptempo", "minimal"] | 6 | 1lgqqW5TsJk | 308 | ||
TECKTONIK vs SHUFFLE.. | This music is an electronic instrumental. The tempo is fast with synthesiser arrangements, electronic beats , Dj mixer and a repetitive vocal riff. The music is incessant, psychedelic, hypnotic, trippy and trance like with a dance groove. This music is Techno Pop/EDM. | 2010-05-01T19:39:05Z | cireduard | hermano vs hermano familia TELLO | ["Disco", "Music", "Dubstep", "Electronic dance music", "Dance music"] | ["instrumental", "fast tempo", "electronic music", "house music", "progressive trance", "repetitive beats", "high energy", "tech trance", "ambient music", "hardcore", "psytrance", "edm", "electronica", "techno", "techno pop", "trippy", "trance droning", "dance pop", "psychedelic", "vocal riff", "dance music", "club music", "dj", "dj mixer", "digital drumming", "synthesiser arrangement", "hypnotic", "trance music", "trippy", "youthful"] | 7 | ITg9o6Gwsbo | 1910 | |
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;