musiccaps_details (view)
3 rows where musiccaps_aspects contains "dangerous" and musiccaps_aspects contains "goth rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 62 ✖
- dangerous · 3 ✖
- fast tempo 3
- goth rock · 3 ✖
- instrumental 3
- eerie 2
- intense 2
- sinister 2
- spooky 2
- suspenseful 2
- vigorous drumming 2
- aggressive 1
- aggressive electric guitar 1
- ambulance siren 1
- belligerent 1
- boisterous 1
- club music 1
- combative 1
- creepy 1
- dance music 1
- death core 1
- death metal 1
- deep growling 1
- dissonant harmony 1
- dj 1
- extreme 1
- frightening 1
- goth 1
- groovy bass line 1
- grunting 1
- hard metal 1
- hard rock 1
- heavy metal 1
- hostile 1
- incoherent vocals 1
- inferior audio quality 1
- keyboard harmony 1
- loud 1
- menacing sounds 1
- menacing voices 1
- metal 1
- no vocals 1
- police van siren 1
- pulsating 1
- roaring 1
- rock 1
- scary 1
- sinister keyboard harmony 1
- siren 1
- spine chilling 1
- spirited 1
- steady drumming 1
- syncopated harmony 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- thumping beat 1
- trance 1
- trap 1
- trippy music 1
- vigorous beat 1
- violent 1
- vocal riff 1
- youthful 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
TF2 - 7 brothers (broder) frag movie | This song is a Rock instrumental. The tempo is medium fast with an aggressive electric guitar harmony, steady drumming, keyboard accompaniment, groovy bass lines. The audio quality is inferior so the finer aspects; are hard to detect. Overall the vibe of the song is intense,dangerous, sinister, spooky, goth, threatening and suspenseful. This song is Hard Rock/Metal. | 2010-02-19T23:16:14Z | Sivert Bakkeng | This is a fragvid for my TF2 Team, 7 Brothers who aren't brothers (broder). Duration: 6m 33s Direct HQ 720p download .mp4: http://www.fakkelbrigade.eu/torden/7brothers_720pHighB.mp4 (438mb, "right click + save link as") Direct HQ 720p download .wmv: http://www.fakkelbrigade.eu/torden/7brothers_720pHigh.wmv (294mb, will play in browser, or "save link as...)" Most of the footage is shown in its entity with real time kills, and speed ups between some (during the same spree). And yes, the hiding in spawn before kritzing is real. We apologize to the following teams (in order of appearance): Monster Munch (RAWR) Un de Watever-their-name-is Team Coolermaster (TCM) Power gaming (PwR) Notag Empire Blight Mister (Mr) Rage Multigaming Idk? (fakenicking asswipes) Outsiders who contributed to this short film: Salmon, support and improvements on the pldx movie recording tool. Tuna and Jh ("from the movies"). Fakkelbrigade and Arie, providing direct download All footage is from PCWs/Scrims, mid Jan. to mid Feb. 2010. Team members (by order of appearance) Sneis (Currently travelling South America) Fanva Torden Weqo Macisum Braffle Berserker Codcrille Borrowed music: the Stooges - I Wanna be Your Dog Pixies - Wave of Mutilation + there goes my gun Vitamin String Quartet - Wave of Mutilation (cover) Anyone interested learning about the competitive side of TF2, visit www.ETF2L.org or www.RESUPPLY.eu. Ill allow it. | ["Music", "Angry music"] | ["instrumental", "fast tempo", "hard rock", "no vocals", "inferior audio quality", "metal", "suspenseful", "dangerous", "youthful", "spirited", "intense", "hard metal", "aggressive electric guitar", "sinister keyboard harmony", "steady drumming", "groovy bass line", "eerie", "suspenseful", "spooky", "goth rock"] | 7 | 0fCpAuxrQ_I | 196 | |
DJ VENGEANCE - ZOMP STOMP [Jump Up Drum & Bass] | This song is an instrumental. The tempo is fast with vigorous drumming, thumping bass lines and keyboard arrangement with sounds of an ambulance or police van, menacing voices, grunting, incoherent vocal riff and whooshing sound of wind. This song is aggressive, vigorous, energetic trippy, trance like with the syncopated music giving it a eerie, sinister, creepy vibe. This song is a Hard Rock/Goth Rock. | 2008-12-21T08:14:58Z | Vengeance Music UK | DJ Vengeance - Nu Urban Artists 001 Track: Zomp Stomp sample:its a zombie Nu Artists is for, well, exactly that, new artists with plenty of potential on display. And that's precisely why Vengeance is hitting hard with his first release on this brand new imprint. First comes the Electro inspired 'Dancehall Slayer', all synthetic bubbles before the bass drops, and by then it's all over! 'Zomp Stomp' on the flip is full of beans too. This boy will go far! - Nu Urban Music Sales: http://www.nu-urbanmusic.co.uk/drum_and_bass/shop/product_info.php?products_id=11102 | ["Drum and bass", "Music", "Trance music", "Dubstep", "Electronic dance music"] | ["instrumental", "fast tempo", "trance", "trap", "police van siren", "intense", "dj", "dance music", "club music", "incoherent vocals", "trippy music", "vigorous beat", "syncopated harmony", "thumping beat", "vigorous drumming", "synthesiser arrangements", "ambulance siren", "menacing voices", "roaring", "grunting", "vocal riff", "rock", "goth rock", "sinister", "eerie", "creepy", "dangerous", "frightening"] | 7 | ItLWKIhe58c | 1950 | |
20 Heartstopping Deathcore Breakdowns! HQ | This music is an aggressive instrumental. The tempo is fast with hard hitting, vigorous drumming, keyboard harmony and synthesiser arrangements with siren sounds and a menacing, deep growl. The music is angry, aggressive, passionate, extreme,scary, sinister, suspenseful, gothic , hostile, belligerent, violent and combative. This music is Death metal/Death Core. | 2012-09-08T18:16:57Z | Fictiion | An other Breakdown video that you will enjoy. Some heavy vocals, technical instruments, bassdrops. Most of the bands are underground, facebooks links are below. NOTE: I don't own any music, all credits goes to the bands. This is for promoting only. Bands: Intro: Up in smoke - You me & the wall you built between us [http://www.facebook.com/UpInSmokeAR] 1. Creatures of Habit - Myriad [http://www.facebook.com/CreaturesFl] 2. Surroundings - Dominatrix (Feat. Chris Fronzak of ATTILA) 3. Surroundings - The Further (Ft. Grayson Rhine) [http://www.facebook.com/SurroundingsRVA] 4. So This Is Suffering - Wait to Exhale [http://www.facebook.com/sothisissuffering?ref=ts] 5. Misanthropic Tyrant- Images Ov Annihilation(Preproduction) [http://www.facebook.com/MisanthropicTyrant] 6. Keeper of the Sea - You Look Good Impaled [http://www.facebook.com/KeeperOfTheSeaNC] 7. Infant Annihilator - Devotion to the Child Rape Syndicate [http://www.facebook.com/InfantAnnihilator] 8. Defying The King - Killer (Unmastered) [http://www.facebook.com/pages/Defying-The-King/164912833536032] 9. Consequence - Drowned [http://www.facebook.com/ConsequenceOC] 10. Chains of Honor - Br00tz McG00tz [http://www.facebook.com/chainsofhonor] 11. AngelMaker - Decay [http://www.facebook.com/angelmakerband] 12. AEGAEON - The Memory [http://www.facebook.com/AegaeonUS] 13. A Hitman's Business - Dissonance Demo [http://www.facebook.com/pages/A-Hitmans-Business/169276909767153] 14. In Dying Arms - Bathed in Salt ft. Fronz from ATTILA [http://www.facebook.com/indyingarms] 15. PRESTIGE - 1134 [http://www.facebook.com/prestigeNW] 16. Crisis in Vain - You don't deserve to live [http://www.facebook.com/CrisisDeathcore] 17. Reborn Divided - Braveheart [http://www.facebook.com/Reborndivided] 18. Duat - Aberrant [http://www.facebook.com/duatbih] 19. The Boy Will Die - It Has Begun [http://www.facebook.com/TheBoyWillDie] 20. Untapped Market - A Profits Rising [http://www.facebook.com/UntappedMarket] Bonus track: Contagion - Pure Hate [http://www.fac… | ["Heavy metal", "Music", "Angry music"] | ["instrumental", "fast tempo", "vigorous drumming", "violent", "death metal", "heavy metal", "goth rock", "death core", "combative", "hostile", "belligerent", "extreme", "deep growling", "keyboard harmony", "synthesiser arrangement", "siren", "menacing sounds", "dissonant harmony", "sinister", "scary", "spooky", "goth", "pulsating", "aggressive", "loud", "boisterous", "dangerous", "spine chilling", "suspenseful"] | 7 | eVjcfdxSFKQ | 3867 |
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;