musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "heavy metal" and musiccaps_names contains "Heavy metal"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 15 ✖
- amateur recording · 2 ✖
- heavy metal · 2 ✖
- acoustic drums 1
- aggressive 1
- dangerous 1
- descending chords 1
- distortion guitars 1
- e-bass 1
- e-guitar 1
- eerie 1
- goth metal 1
- heavy percussion 1
- male voice 1
- screaming voice sample 1
- synth backing 1
musiccaps_names (array) 9 ✖
- Heavy metal · 2 ✖
- Music 2
- Rock music 2
- Angry music 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Musical instrument 1
- Pulse 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 | |
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;