musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "amateur recording", musiccaps_names contains "Heavy metal" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- amateur recording · 3 ✖
- heavy metal 2
- acoustic drums 1
- aggressive 1
- blues guitar 1
- dangerous 1
- descending chords 1
- distortion guitars 1
- e-bass 1
- e-guitar 1
- eerie 1
- goth metal 1
- guitar fills 1
- heavy percussion 1
- instrumental song 1
- male voice 1
- minimal instruments 1
- moderate tempo 1
- no voice 1
- screaming voice sample 1
- suspenseful mood 1
- synth backing 1
- tambourine backing 1
musiccaps_names (array) 13 ✖
- Heavy metal · 3 ✖
- Music 3
- Rock music · 3 ✖
- Angry music 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Grunge 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 | |
Two Pin Din - Screaming Blue Murder live - Nov 15th, 2008 | This amateur recording features two guitars being played. One guitar is playing a blues rhythm. The other guitar is strumming the main chord once and then playing fills on the higher register. This is accompanied by a tambourine as the percussion. There are no voices in this song. This is an instrumental blues rock song. The mood of this song is suspenseful. This song can be used in a detective movie. | 2008-11-18T20:01:48Z | twopindin | When in doubt, follow the advice of Nick Lowe. Namely, "bash it out then tart it up later". Where's Deja Voodoo when you need them? Yet another song offered up off of Two Pin Din's oh-so-fab-you-just-don't-know-it-yet album "In Case Of Fire Break Glass". | ["Heavy metal", "Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock", "Grunge"] | ["amateur recording", "blues guitar", "guitar fills", "tambourine backing", "minimal instruments", "no voice", "instrumental song", "suspenseful mood", "moderate tempo"] | 0 | gp7j9o2x9co | 4055 | |
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;