musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "aggressive", musiccaps_aspects contains "bass guitar" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- acoustic drums 3
- aggressive · 3 ✖
- bass guitar · 3 ✖
- distorted electric guitar 2
- male vocal 2
- amateur recording 1
- chainsaw 1
- cover 1
- electric guitar 1
- grunge rock 1
- grunt-like singing 1
- hard rock 1
- hard-hitting 1
- keyboard 1
- live performance 1
- loud 1
- noisy 1
- poor quality 1
- power metal 1
- rebellious 1
- shouting 1
- speed metal 1
- upbeat 1
musiccaps_names (array) 9 ✖
- Music 3
- Rock music · 3 ✖
- Heavy metal 2
- Musical instrument 2
- Angry music 1
- Chainsaw 1
- Drum 1
- Guitar 1
- Pulse 1
youtube_published (date) 3 ✖
- 2006-12-04 1
- 2008-05-30 1
- 2012-01-23 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Front row! Jackyl 'The Lumberjack Song' live in concert in California! Enjoy! NAMM | This is the live performance of a hard rock piece. There is a male vocal who is shouting at the crowd while revving up a chainsaw. The electric guitar is playing the melody while the bass guitar is playing in the background. The acoustic drums are playing a simple blues rock beat. The atmosphere is aggressive. | 2012-01-23T22:46:42Z | pasha28dio | Filmed at the 'Grove in Anaheim' during NAMM 2012 at the 3rd Annual Dean Guitars Namm Jamm. You just have to love any song that has a chainsaw solo. :-) Testament and Static X also played. Great night of jams. | ["Chainsaw", "Drum", "Guitar", "Heavy metal", "Music", "Musical instrument", "Rock music"] | ["hard rock", "live performance", "male vocal", "shouting", "electric guitar", "bass guitar", "acoustic drums", "chainsaw", "hard-hitting", "aggressive"] | 9 | MQ1Q7xydJPU | 2265 | |
Heavenly - Lust For Life | This is a power metal/speed metal music piece. The melody is being performed by the distorted electric guitar and the keyboard while the bass guitar is playing in the background. The rhythmic background consists of a loud metal acoustic drum beat. The atmosphere is aggressive and upbeat. This music would suit perfectly in the soundtrack of an adventure video game. It could also work well in the soundtrack of an action-filled cartoon series. | 2008-05-30T19:02:47Z | MetalMajestie | From their album Dust to Dust ▀▄▀▄▀▄▀▄▀▄ Link to buy Dust to Dust http://www.amazon.com/Dust-Heavenly/dp/B0000YRJ28/ref=sr_1_2?ie=UTF8&s=music&qid=1224215134&sr=1-2 ▀▄▀▄▀▄▀▄▀▄ Strange this sensation in my mind Creature i will become one On my way, there's no sun But i have to carry on Look my force is more powerfull Piece by piece vampire rules On my way, in my world I realize past life has gone. Future's changing again Impulses're driving me away in hell no tears in my eyes there's no beat in my heart I just feel the pain Growin' into my brain I'm still the son, The abandoned child of eternity I don't belong to the sky I just follow my way Ready to roam in the night I hear this symphony Running after the devil The prince of immortals Feared by everyone I am strong as hard as metal Innocent blood I must take on the crime is in my soul lust for life I don't belong to the sky I just follow my way Ready to roam in the night I hear this symphony Running after the devil The prince of immortals freak for every one I am proud as srtong as metal Creature of flesh I must devour To be free Lust for life Every night the realm is mine Beware until the sunrise in the sky In the night I stay here to bite Take care of you, blood thirsty I am one Eternalle. And in my dream All victims forgive me They watch me in the sky They light my way from the other side. No tears in my eyes there's no beat in my heart I just feel the pain Growin' into my brain I'm still the son. The abandoned child of eternity I don't belong to the sky I just follow my way Ready to roam in the night I hear this symphony Running after the devil The prince of immortals Feared by everyone I am strong as hard as metal Innocent blood I must take on the crime is in my soul lust for life I don't belong to the sky I just follow my way Ready to roam in the night I hear this symphony Running after the devil The prince of immortals freak for every one I am proud as srtong as metal Cr… | ["Heavy metal", "Music", "Rock music", "Angry music"] | ["power metal", "speed metal", "distorted electric guitar", "keyboard", "bass guitar", "acoustic drums", "loud", "aggressive", "upbeat"] | 9 | mwwnfWgV_5U | 4504 | |
Banda - Floyd The Barber (Nirvana) | This is an amateur cover of a grunge rock music piece. Both the recording and the playing are of poor quality. There is a male vocalist singing in a grunt-like manner as the lead. A crunchy riff is being played by the distorted electric guitar and the bass guitar while the acoustic drums are playing a simple rock beat. The atmosphere is rebellious and noisy. | 2006-12-04T17:57:48Z | drugstoremarc | Marco e Roberto unem-se a Joao Cassio e Benedito em sua banda para tocar "Floyd The Barber", do Nirvana. Marco and Roberto unite with Joao Cassio and Benedito on their band to play "Floyd The Barber", of Nirvana. | ["Music", "Musical instrument", "Rock music", "Pulse"] | ["cover", "amateur recording", "poor quality", "grunge rock", "male vocal", "grunt-like singing", "distorted electric guitar", "bass guitar", "acoustic drums", "rebellious", "aggressive", "noisy"] | 9 | oPiyXhxRGe4 | 4626 |
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;