musiccaps_details (view)
2 rows where musiccaps_aspects contains "distorted electric guitar" and musiccaps_aspects contains "progressive metal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- distorted electric guitar · 2 ✖
- progressive metal · 2 ✖
- violent 2
- acoustic drums 1
- aggressive 1
- bass guitar 1
- chaotic 1
- complex 1
- cover 1
- guitar solo 1
- instrumental 1
- male vocal 1
- melodic death metal 1
- pig squeal 1
- poor quality 1
- rapid 1
- shredding 1
- speed metal 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Disarmonia Mundi - Perdition Haze | This is a melodic death metal music piece. There is a male vocal singing using the pig squeal technique in the lead. The electric guitar with heavy distortion is playing a hard-hitting riff. There is a bass guitar playing in the background. The acoustic drums are playing a loud but simple beat. The atmosphere of the piece is violent. It could be used in the soundtrack of a horror movie or a horror video game. | 2009-11-08T04:32:50Z | chaosxgr | Perdition Haze single from the The Isolation Game. I do not own this music at all. Its copyright to the band and their record label. This song is owned completely by Disarmonia Mundi and the song is featured on the album The Isolation Game. | ["Music", "Angry music"] | ["melodic death metal", "progressive metal", "male vocal", "pig squeal", "distorted electric guitar", "bass guitar", "acoustic drums", "aggressive", "violent", "chaotic"] | 9 | 0ZXWSO_Y2C0 | 181 | |
Through The Fire And Flames - AGAIN! | This is the guitar cover of a speed metal/progressive metal piece. The distorted electric guitar is playing a solo. There is a rapid and complex procession of notes in the solo which is played by the shredding technique. There is a loud and violent atmosphere to the recording. The quality is quite poor since the recording is a bit dated. | 2007-06-11T07:06:05Z | longestsoloever | I try the DragonForce song again, this time with my clone! That handsome guy on the left is off by a split second, but thats one of the hazards of compositing! | ["Heavy metal", "Music", "Rock music"] | ["cover", "speed metal", "progressive metal", "instrumental", "distorted electric guitar", "guitar solo", "shredding", "complex", "rapid", "violent", "poor quality"] | 9 | DYp8940tHso | 1492 |
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;