musiccaps_details (view)
1 row where musiccaps_aspects contains "aggressive", musiccaps_aspects contains "male vocal" and "youtube_published" is on date 2009-11-08
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;