musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "loud acoustic drums" and musiccaps_author = 9 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- bass guitar 4
- loud acoustic drums · 4 ✖
- aggressive 3
- distorted electric guitar 3
- energetic 3
- fast tempo 2
- loud 2
- male vocal 2
- violent 2
- alternative rock 1
- dub 1
- electric guitar 1
- fry scream 1
- grunge rock 1
- hard-hitting 1
- heavy metal 1
- industrial effects 1
- industrial metal 1
- instrumental 1
- invigorating 1
- live performance 1
- medium tempo 1
- nu metal 1
- powerful 1
- powerful singing 1
- punk rock 1
- rebellious 1
- vigorous 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Static-X - Black And White | This is an industrial metal piece. The male vocalist in the lead is singing using the fry scream technique. The distorted electric guitar is playing a heavy riff while there is a groovy bass line. There is a loud metal beat being played by the acoustic drums in the rhythmic background. Industrial sound effects can be heard which are distinctive to the industrial and nu metal scenes. The atmosphere is aggressive and energetic. This piece could be played at a rock/metal bar. It could also be included in the soundtrack of an action movie/video game. | 2010-08-29T19:54:25Z | Triggerself | Lyrics: Lost in my own World Lost in my own World Lost in my Lost in my own World Lost in my own World Lost in my Getting to the right Getting to the wrong Getting mine Getting to the right Getting to the wrong Getting high Losing your mind Losing your mind It's bluring It's fading Your soul's on fire It's black and white Burning inside Burning inside Burning into white Burning inside Burning inside Burning into night Yourself collides Yourself collides Yourself into mine Yourself collides Yourself collides Yourself splinters like Losing your mind Losing your mind It's bluring It's fading Your soul's on fire It's black and white Blurring the light Blurring the light It's ours for the taking Flickering colors It's black and white | ["Disco", "Jazz", "Music", "Pop music"] | ["industrial metal", "nu metal", "male vocal", "fry scream", "distorted electric guitar", "bass guitar", "loud acoustic drums", "industrial effects", "aggressive", "energetic", "loud", "violent", "powerful"] | 9 | 7OgH3B49_E4 | 842 | |
DUB TRIO - ILLEGAL DUB | This is an instrumental punk rock/dub music piece. There is a distorted electric playing the main tune with a bass guitar in the background. The rhythmic background consists of a loud and rapid acoustic drum beat. The atmosphere is aggressive. This piece could be used in the soundtrack of a violent video game. | 2006-05-02T17:09:19Z | dubtrio | video for ILLEGAL DUB. from DUB TRIO's album, NEW HEAVY. video directed by: Jason Fried | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["punk rock", "dub", "instrumental", "distorted electric guitar", "bass guitar", "loud acoustic drums", "fast tempo", "aggressive", "energetic", "violent"] | 9 | JpMHnsdsCiY | 2036 | |
Butterfingers Royal Jelly | This is an alternative rock piece. The main theme is played through power chords by a distorted electric guitar. In the background, a bass guitar is playing a groovy bass line. The rhythmic background is provided by loud acoustic drums playing a rock drum beat with frequent usage of rapid fills. The atmosphere of the song is aggressive and rebellious. It could be used in the soundtrack of a teenage drama or a crime series. | 2012-10-23T07:50:02Z | AltMzk | My favorite band | ["Music", "Angry music"] | ["alternative rock", "grunge rock", "distorted electric guitar", "bass guitar", "loud acoustic drums", "medium tempo", "aggressive", "rebellious", "vigorous"] | 9 | okAn7kjxmes | 4656 | |
1983 Ronnie James Dio "Stand Up and Shout" (Rock Palace) | This is the live recording of a heavy metal music piece. The male vocalist in the lead has a powerful wide-ranged vocal. There is an overdriven electric guitar that is playing a repeated riff with a bass guitar supporting it in the background. The rhythm is provided by a loud, fast-paced metal beat on the acoustic drums. The atmosphere is hard-hitting and energetic. The piece could be playing in the background of a rock/metal bar. | 2007-06-01T01:16:31Z | music3874 | Ronnie James Dio performing "Stand Up And Shout" on a US late night television show, "The Rock Palace." I believe this was recorded very shortly after the release of the "Holy Diver" album. From the same show, also see: Rainbow in the Dark http://www.youtube.com/watch?v=LmSt1oEIshE Man On The Silver Mountain http://www.youtube.com/watch?v=vOyFE-1LAI0 | ["Music", "Whoop"] | ["heavy metal", "live performance", "male vocal", "powerful singing", "electric guitar", "bass guitar", "loud acoustic drums", "hard-hitting", "energetic", "loud", "invigorating", "fast tempo"] | 9 | zixIuxzCCvs | 5505 |
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;