musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "aggressive" and musiccaps_aspects contains "fast tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- acoustic drums · 4 ✖
- aggressive · 4 ✖
- fast tempo · 4 ✖
- bass guitar 2
- distorted electric guitar 2
- e-bass 2
- e-guitar 2
- loud 2
- alternative 1
- chaotic 1
- electronic elements 1
- energetic 1
- hard-rock 1
- harsh singing 1
- male vocal 1
- male voice screaming 1
- nu-metal 1
- percussive elements 1
- pop punk 1
- punkrock 1
- rebellious 1
- violent 1
youtube_published (date) 4 ✖
- 2009-05-22 1
- 2009-09-27 1
- 2010-05-11 1
- 2011-06-12 1
musiccaps_names (array) 2 ✖
- Angry music 4
- Music 4
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gazette - headache man subs + translations (eng) | A male voice is screaming aggressively and loud while a acoustic drum set is playing a drum&bass groove along with a distorted e-guitar and bass playing the bassnotes along with the drums: Than the drums breaks into another part changing the beat along with the guitar and the bass while the male voice is screaming in a high frequency. The music sounds energetic and aggressive. This song may be playing at a live concert. | 2009-05-22T01:46:23Z | thesachiba | I disabled comments cuz apparently, some people can't distinguish between Gazette and Dir en grey. ------------------------------------ GAZETTE ARE NOT DIR EN GREY, AND DIR EN GREY ARE NOT GAZETTE. NO BAND IS TRYING TO BE LIKE THE OTHER. KEEP THE COMMENTS NICE, PLEASE. I don't mind if you got something insightful to say about both bands, but if you're just gonna be like 'OmG RuKi iSh TrYiN' 2 b LyKe kYo CuZ hE sCrEaMs aLoT, aNd DiR iN GrAy IsH sUxZoRs nOw, sRsLy', then don't bother commenting. -------------------------------------- Haha, enjoy. This song is so fun. * Kannon is the Japanese pronounciation of 觀音, or Guanyin, a goddess from the east Asian Buddhist and Tao religions. I am only a fan subbing for other fans; I don't own the music. Credits to Gazette and PSCompany. | ["Music", "Angry music"] | ["punkrock", "acoustic drums", "e-guitar", "e-bass", "male voice screaming", "aggressive", "fast tempo"] | 6 | EPvnkbo5wrI | 1553 | |
Millencolin-Olympic | This is a pop punk music piece. There is a fast-paced distorted electric guitar playing the main tune. A bass guitar is supporting it in the background. The rhythm is being played by a loud acoustic drum beat. The atmosphere is rebellious and aggressive. This piece could be used in the soundtrack of a high school drama TV series, especially during scenes where acts of delinquency are committed. | 2011-06-12T21:11:27Z | imasstupidashell | ["Music", "Angry music"] | ["pop punk", "distorted electric guitar", "bass guitar", "acoustic drums", "fast tempo", "rebellious", "aggressive", "loud"] | 9 | Wvg5rlMbjJc | 3150 | ||
slipknot pulse of the maggots | This is a nu-metal/alternative metal music piece. There is a male vocalist singing in a harsh, shout-like manner in the lead. The main melody is being played by a distorted electric guitar with a strong bass guitar backing. There are various electronic elements such as a crowd cheering sample and an evolving synth sound adding texture to the piece. The rhythmic background consisted of a loud metal acoustic drum beat and secondary percussive elements such as steel percussion. The atmosphere is energetic and violent. This piece could be used in the soundtrack of an action-filled/shootout video game. It could also be playing in the background at a metal bar. | 2009-09-27T06:17:51Z | slayer4728 | I have a good faith belief that the material was disabled as a result of a mistake or misidentification, and that I am not intentionally abusing this dispute process. I do NOT own this video. It was recorded by SlipKnot, I do NOT take part in this video. Enjoy! | ["Music", "Angry music"] | ["nu-metal", "alternative", "male vocal", "harsh singing", "distorted electric guitar", "bass guitar", "electronic elements", "acoustic drums", "percussive elements", "loud", "energetic", "aggressive", "chaotic", "violent", "fast tempo"] | 9 | cCyfADwHiWs | 3688 | |
Melvins - The Brain Center at Whipples - Hostile Ambient Takeover (2002) | This song contains a complex drum groove with fill-ins and a loud groove on the ride cymbal. A distorted e-bass is playing a simple fast bassline along with a distorted e-guitar playing lower notes along with the bass. This song may be playing in a car racing video-game. | 2010-05-11T18:52:00Z | Instrument | music by: melvins - the brain center at whipples - hostile ambient takeover art by: feehan | ["Music", "Angry music"] | ["hard-rock", "e-bass", "acoustic drums", "e-guitar", "fast tempo", "aggressive"] | 6 | qUWYzx7pBSw | 4787 |
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;