musiccaps_details (view)
2 rows where musiccaps_aspects contains "techno", musiccaps_aspects contains "uptempo" and musiccaps_names contains "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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Madonna - Living For Love (Dirty Pop Dubinstrumental) | This song contains a female voice sample that is repeating itself. A digital drum is playing snare hits that are building up in speed along with synthesizer pads with a ping pong delay panning to both sides of the speaker along with other synth sounds rising up in pitch creating tension. This song may be playing in a techno club. | 2015-01-21T03:11:58Z | Madonna | Download the new album now! http://smarturl.it/RebelHeart | ["House music", "Music", "Burst, pop", "Electronic dance music", "Dance music"] | ["techno", "pop", "digital drums", "female voice sample", "synth pads/plucks", "uptempo"] | 6 | RBniJk6GKK0 | 2675 | |
| 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;