musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "heavy metal", musiccaps_names contains "Heavy metal" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- heavy metal · 3 ✖
- amateur recording 2
- distortion guitars 2
- acoustic drums 1
- aggressive 1
- dangerous 1
- descending chords 1
- e-bass 1
- e-guitar 1
- eerie 1
- goth metal 1
- heavy percussion 1
- keyboards 1
- male voice 1
- no voices 1
- palm muted arpeggios 1
- powerful percussion 1
- screaming voice sample 1
- synth backing 1
musiccaps_names (array) 12 ✖
- Heavy metal · 3 ✖
- Music 3
- Rock music · 3 ✖
- Angry music 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Musical instrument 1
- Progressive rock 1
- Psychedelic rock 1
- Pulse 1
- Punk rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dark Sermon - Intro / In Tongues Live Drum Cam - Bryson St. Angelo | Someone is playing acoustic drums with a lot of loud cymbal hits along with a screaming male vocal. A distorted e-guitar is playing long low notes. The atmosphere sounds dangerous and aggressive. This song may be playing in the band room practicing drumming. | 2013-05-23T16:42:07Z | DarkSermonTV | Dark Sermon live at The 7 Venue in Douglasville, GA. | ["Cymbal", "Drum", "Drum kit", "Heavy metal", "Music", "Musical instrument", "Rock music", "Pulse"] | ["heavy metal", "amateur recording", "screaming voice sample", "acoustic drums", "e-guitar", "e-bass", "dangerous", "aggressive"] | 6 | bkQrvXXIRng | 3644 | |
Kettlespider - The Kettle Spider - Australian Prog Metal - Triple J | This heavy metal song features distortion guitars. One guitar plays power chords. Another guitar is playing a repetitive riff using palm muted arpeggiated notes. The keyboard plays chords in the background. The bass plays the root notes of the chords. The percussion plays a simple beat in common time. It starts off playing the kick and crash followed by three beats on the kick and ride. After four bars, a rock drum roll is played. This song can be played in a superhero movie. | 2011-10-10T02:31:19Z | Kettlespider | Nice solid prog ala Dream Theater style! Lots of promise here so keep an eye out! Hornz! Haugy \m/ Andrew Haug, triple j 'Avadante', the debut album from Kettlespider, is available on iTunes: http://itunes.apple.com/au/album/avadante/id524530770 Also, check out our CD if you like the music! http://kettlespider.bandcamp.com www.facebook.com/kettlespider | ["Heavy metal", "Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock"] | ["heavy metal", "no voices", "distortion guitars", "palm muted arpeggios", "powerful percussion", "keyboards"] | 0 | dO3VsX4rKNc | 3782 | |
WWF Forceable Entry:The Beautiful People(Smackdown old theme) | This goth metal song features a male voice singing the main melody. The voice is deep. Toward the end, there are other male voices singing vocables. This is accompanied by heavy percussion using a five-beat common time pattern played on floor toms with a shuffle note each note creating a triplet feel. The distortion guitars play heavy descending chord riffs using palm muting technique. The bass guitar plays the root notes of the chords. At the background, there is an high pitched sound played on a synth that gives this song an eerie feel. This song can be played at the end credits of a horror movie. | 2009-07-06T22:15:51Z | cactuar64 | Song:"The Beautiful People" Song By:Marilyn Manson | ["Heavy metal", "Music", "Rock music", "Angry music"] | ["heavy metal", "goth metal", "male voice", "amateur recording", "distortion guitars", "heavy percussion", "descending chords", "synth backing", "eerie"] | 0 | vy2gUzgmBzQ | 5222 |
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;