musiccaps_details (view)
2 rows where musiccaps_aspects contains "chaotic", musiccaps_aspects contains "intense", musiccaps_aspects contains "video game music" and musiccaps_author = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Ace Pk Session 1 | Maxed Chaotic Pure | 100% Pure Hybridding | Eruption of Pures | A male vocalist sings this spirited Rock song. The tempo is fast with an upbeat Amplified keyboard harmony, hard hitting drums, punchy bass lines and a dominating electric guitar accompaniment. The vocals are subdued for a Rock song. The song is youthful, vibrant, energetic, enthusiastic, buoyant, punchy and vivacious. This song is Classic Hard Rock. | 2011-11-25T01:44:13Z | AceyFiasco | I tried my best guys, all feedback is appreciated. You can join the clan I'm in @ EoP-Rs.com Runescape is owned and operated by Jagex Limited ("JaGeX"), I Do Not own Runescape i make videos for entertainment purposes "Only" and not for the sake of profiting.All music used in my videos is purchased and not for the intent of redistributing it. You Can Play Runescape At: http://www.runescape.com IGNORE THE FOLOWING~~~~~~~~~~~~~ bounty hunter TERMPINATION TERMPINATIONZ BH VID # 1 blue stanger TERPINATIONownage range of ish PD OWN TRILE12 STR B0S 001 runescape bs bh pking bounty hunter pking blue bountyhunter bs bh rs runescape jagex ltd rs elvemage kids ranqe defil3d elf mage pka i ayzee i wildy owns1 spanjol 91 bloodhoun34zezima youbleedred i kasoy i xxphatmagexx dawgsaysftw skychi review best Bounty Hunter video armadylgodsword ownage ko pk whip pks barrow pks spartacus121 best pker in rs best pker pk vid. best pker bounty hunter vid Archer96 Letterbomb05's Dark Bow theunforgiving yogosun yogosun2 fat wrecked zeldagirl8 lvl126inrs sosolid2k maxboisen Tehnoobshow Runescape Zezima Interview max hits high hits Best Lure video ever purple 0wnz bloodhoun34 OMG runescape pking wild pker ownage zezima phat lure KIDS RANQE PURPLE 0WNZ ZEZIMA N0VALYFE PHAT LURE OWNAGE RUNESCAPE WILDY WILDERNESS ELVEMAGE ELVEMAGE RUNESCAPE PKING RUN3 4RR0WPK OWNAGE MAIKEL PRO I MAHATMA I EVO BLOODHOUN34 KIDS RANQE KRAZYFAKEN RUNESCAPE PKER RUNESCAPE PKING INTIATE PURE OWNAGE LURE PHAT 99 1337 PWNAGE PKING PKERS PK PARTYHAT ZEZIMA N0VALYFE RUNESCAPE WILDY BARRAGE ANCIENTS LURING FROSTYDAPKER JETCHIMP BLOOD SEASON BLOODHOUN34 I Mahatma I, Stonecoldpkr,P0ke N Die2, Sourpatchk1d, Krazyfaken, Kids Ranqe ,dragon claws maxxing 1 Pure Devil, Evilsexc, Dizzy Mauler, I Shonomercy, E4t F0od Nub, Im Easy Xp, Iminsan3, Pure insan3, and Xoxofuryxoxo.pvp best loots whipper whip elvemage sv3rige bloofhoun34 is elvemage bloodhoun34 hiei the pk lexmark78 6th outlaw i meleed i ultimate strength hybrid barrage blitz burst 99 range mage krazyfaken f… | ["Music", "Grunge"] | ["male singer", "fast tempo", "rock", "hard rock", "dominating electric guitar", "punchy", "buoyant", "vivacious", "video game music", "animated", "chaotic", "busy", "rock hits", "concert", "hard hitting drums", "loud electric guitar feedback", "amplified keyboard harmony", "funky bass line", "subdued vocals", "imposing music", "youthful", "energetic", "enthusiastic", "spirited", "vivacious", "classic rock", "intense"] | 7 | dHGAXJ9RPJs | 3773 |
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;