musiccaps_details (view)
2 rows where musiccaps_aspects contains "aggressive", musiccaps_aspects contains "keyboard", musiccaps_names contains "Angry music" and musiccaps_names contains "Heavy metal"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Illidiance - New Millenium Crushers music video HD | This is an industrial metal/alternative metal music piece. There is a male vocal singing in a harsh manner using the guttural technique. The melody is being played by the keyboard and the distorted electric guitar while the bass guitar is playing in the background. The acoustic drums are playing a loud and fast-paced metal beat with heavy use of twin pedals on the kick drum. The atmosphere is violent. This piece could be used in the soundtrack of a gruesome horror video game. | 2010-12-24T09:52:38Z | ModernMelodicMetal | Illidiance new music video for ''New Millenium Crushers'' in High Definition from their latest album ''Damage Theory''. © Mazzar Records 2010 | ["Singing", "Heavy metal", "Music", "Angry music", "Inside, large room or hall"] | ["industrial metal", "alternative metal", "male vocal", "guttural singing", "distorted electric guitar", "keyboard", "bass guitar", "acoustic drums", "loud", "aggressive", "violent"] | 9 | U3TpCc2zHrI | 2884 | |
Heavenly - Lust For Life | This is a power metal/speed metal music piece. The melody is being performed by the distorted electric guitar and the keyboard while the bass guitar is playing in the background. The rhythmic background consists of a loud metal acoustic drum beat. The atmosphere is aggressive and upbeat. This music would suit perfectly in the soundtrack of an adventure video game. It could also work well in the soundtrack of an action-filled cartoon series. | 2008-05-30T19:02:47Z | MetalMajestie | From their album Dust to Dust ▀▄▀▄▀▄▀▄▀▄ Link to buy Dust to Dust http://www.amazon.com/Dust-Heavenly/dp/B0000YRJ28/ref=sr_1_2?ie=UTF8&s=music&qid=1224215134&sr=1-2 ▀▄▀▄▀▄▀▄▀▄ Strange this sensation in my mind Creature i will become one On my way, there's no sun But i have to carry on Look my force is more powerfull Piece by piece vampire rules On my way, in my world I realize past life has gone. Future's changing again Impulses're driving me away in hell no tears in my eyes there's no beat in my heart I just feel the pain Growin' into my brain I'm still the son, The abandoned child of eternity I don't belong to the sky I just follow my way Ready to roam in the night I hear this symphony Running after the devil The prince of immortals Feared by everyone I am strong as hard as metal Innocent blood I must take on the crime is in my soul lust for life I don't belong to the sky I just follow my way Ready to roam in the night I hear this symphony Running after the devil The prince of immortals freak for every one I am proud as srtong as metal Creature of flesh I must devour To be free Lust for life Every night the realm is mine Beware until the sunrise in the sky In the night I stay here to bite Take care of you, blood thirsty I am one Eternalle. And in my dream All victims forgive me They watch me in the sky They light my way from the other side. No tears in my eyes there's no beat in my heart I just feel the pain Growin' into my brain I'm still the son. The abandoned child of eternity I don't belong to the sky I just follow my way Ready to roam in the night I hear this symphony Running after the devil The prince of immortals Feared by everyone I am strong as hard as metal Innocent blood I must take on the crime is in my soul lust for life I don't belong to the sky I just follow my way Ready to roam in the night I hear this symphony Running after the devil The prince of immortals freak for every one I am proud as srtong as metal Cr… | ["Heavy metal", "Music", "Rock music", "Angry music"] | ["power metal", "speed metal", "distorted electric guitar", "keyboard", "bass guitar", "acoustic drums", "loud", "aggressive", "upbeat"] | 9 | mwwnfWgV_5U | 4504 |
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;