musiccaps_details (view)
2 rows where musiccaps_aspects contains "booming sounds", musiccaps_aspects contains "electro pop" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- booming sounds · 2 ✖
- electro pop · 2 ✖
- instrumental · 2 ✖
- aggressive 1
- anger 1
- buoyant 1
- chaotic 1
- cheering 1
- confusion 1
- cunfusion 1
- cymbal rides 1
- dance music 1
- distorted voice 1
- dj mixer 1
- drum machine 1
- edm 1
- eerie 1
- electrifying 1
- electro rock 1
- electronic instrumentation 1
- electronic music 1
- fast tempo 1
- fourth world music 1
- futuristic 1
- goth 1
- goth rock 1
- inferior audio quality 1
- intense 1
- live performance 1
- medium fast tempo 1
- muffled audio 1
- people talking 1
- pulsating 1
- punchy 1
- sinister 1
- sound of guns 1
- syncopated melody 1
- synthesiser arrangements 1
- threatening 1
- video game music 1
- vigorous drumming 1
- whistling 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Best Mehndi Dance 2012 - DhoomBros | This music is an electronic dance instrumental. The tempo is fast with synthesiser arrangements, digital drumming, DJ mixer and electronic effects. The sound quality is inferior and muffled with static and booming sounds. The performance is live with ambient sounds of people whistling, cheering and talking. This is an Electro Pop instrumental. | 2012-09-11T20:59:32Z | DhoomBros | https://www.facebook.com/DhoomBrosOfficial http://www.dhoombros.com/ https://www.facebook.com/IHussainAsif https://www.facebook.com/ishehry https://www.facebook.com/iAtifKhan https://www.facebook.com/iWaqasRiaz https://twitter.com/iHussainAsif http://twitter.com/#!/oyeshehry http://twitter.com/#!/atifron http://twitter.com/l3films Subscribe, Comment, Share, Thumbs UP! | ["Scratching (performance technique)", "Music", "Inside, large room or hall"] | ["instrumental", "fast tempo", "electronic music", "futuristic", "fourth world music", "punchy", "buoyant", "electrifying", "pulsating", "inferior audio quality", "booming sounds", "muffled audio", "drum machine", "dj mixer", "whistling", "people talking", "cheering", "live performance", "dance music", "electro pop", "edm"] | 7 | KyjeM7J-Pz4 | 2137 | |
BORN OF OSIRIS - Two Worlds Of Design | A male vocalist sings this aggressive song. The tempo is medium fast with electronic music; vigorous drumming, cymbal ride; synthesiser arrangements, distorted menacing vocals and electronic music. The song is angry, aggressive, sinister, menacing, spine-chilling and chaotic. This song is a Goth Rock/Hard Metal song. | 2011-06-07T23:49:14Z | Sumerian Records | FOLLOW BORN OF OSIRIS https://www.facebook.com/bornofosiris https://twitter.com/booofficial https://www.instagram.com/boocrue FOLLOW SUMERIAN RECORDS http://sumerianrecords.com http://facebook.com/sumerianrecords https://twitter.com/SumerianRecords https://www.instagram.com/sumerianrecords — — Lyrics: Will we ever really learn of our creation Or will this century Claim the natural domain Breakaway at a point when it's too late Now the course is set And our destination is our fate A lesson learned will not remain Gone past your call See the complex set You must explorate Toward the promise land The purity has taken leave with The modern age supremacy Manipulate the siege Grant me the means to Render useless, the machines We are falling into the circles The smallest pieces Are taking shape and taking charge We combine two worlds of design Never thought connecting I left myself inside the wires We combine to worlds of design Try living out in the open The slightest change Equals time inside the wires The harmony of nature Within the body of knowledge Find life in the consequence of discovery But there's still a mystery that blinds. | ["Music", "Angry music"] | ["instrumental", "medium fast tempo", "booming sounds", "chaotic", "cunfusion", "intense", "anger", "threatening", "goth rock", "electronic instrumentation", "synthesiser arrangements", "vigorous drumming", "sound of guns", "distorted voice", "sinister", "eerie", "goth", "aggressive", "syncopated melody", "chaotic", "confusion", "video game music", "electro pop", "electro rock", "cymbal rides"] | 7 | M2iOUwFHv9Q | 2238 |
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;