musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "aggressive" and musiccaps_aspects contains "loud acoustic drums" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 22 ✖
- aggressive · 3 ✖
- bass guitar 3
- distorted electric guitar 3
- loud acoustic drums · 3 ✖
- energetic 2
- violent 2
- alternative rock 1
- dub 1
- fast tempo 1
- fry scream 1
- grunge rock 1
- industrial effects 1
- industrial metal 1
- instrumental 1
- loud 1
- male vocal 1
- medium tempo 1
- nu metal 1
- powerful 1
- punk rock 1
- rebellious 1
- vigorous 1
musiccaps_names (array) 14 ✖
- Music 2
- Angry music 1
- Bass drum 1
- Cymbal 1
- Disco 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Hi-hat 1
- Jazz 1
- Percussion 1
- Pop music 1
- Rimshot 1
- Snare drum 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 | |
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 | |
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 |
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;