musiccaps_details (view)
4 rows where musiccaps_aspects contains "hard rock", musiccaps_names contains "Grunge" and musiccaps_names contains "Progressive rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- hard rock · 4 ✖
- energetic 3
- fast tempo 3
- heavy metal 2
- male singer 2
- metal 2
- youthful 2
- aggressive drum kit 1
- amplified instruments 1
- animated vocal backup 1
- boisterous 1
- compelling 1
- cymbals 1
- dance groove 1
- dark 1
- dark ambience background 1
- distortion guitar 1
- electrifying 1
- emphatic 1
- emphatic drumming 1
- enthusiastic 1
- funky electri guitar feedback 1
- funky electric guitar feedback 1
- glam rock 1
- goth 1
- goth rock 1
- groovy bass lines 1
- gurtural vocals 1
- happy mood 1
- hard metal 1
- heavily distorted aggressive electric guitar 1
- high pitched singing 1
- intense 1
- intense electric guitar lead 1
- keyboard harmony 1
- loud 1
- male voice 1
- mid tempo 1
- passionate 1
- pop rock 1
- progressive 1
- psychedelic 1
- pulsating 1
- punk rock 1
- rock 1
- rock bass 1
- rock percussion 1
- sonic power 1
- upbeat 1
- vigorous drumming 1
musiccaps_names (array) 7 ✖
- Grunge · 4 ✖
- Music 4
- Progressive rock · 4 ✖
- Heavy metal 3
- Rock music 2
- Drum machine 1
- Punk rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
chopping new zealand maize 2014 | This hard rock song features a male voice singing the main melody. The song starts with a distortion guitar playing a riff. The percussion plays a simple beat in common time. Once the voice starts singing, the guitars play power chords using down strokes. The bass follows the root notes of the chords. The mood of this song is happy. This song can be played in a car chase sequence in a movie. | 2014-06-15T20:17:58Z | snoopfizzel | john Austin maize season new Zealand | ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Grunge"] | ["hard rock", "glam rock", "male voice", "happy mood", "distortion guitar", "rock percussion", "fast tempo", "rock bass"] | 0 | Gde1fn1Y1uM | 1745 | |
Forgotten Suns - Walk On | A male vocalist sings this enthusiastic Rock. The tempo is fast and upbeat with a vigorous electric guitar lead and harmony, hard hitting drums and amplified keyboard. The music is an energetic, boisterous, youthful, enthusiastic, engaging, pulsating and electrifying Hard Rock. | 2006-12-13T08:02:40Z | tyepennington | Footage taken from a gig at The Mandarin Club on 5th August 2006. | ["Music", "Rock music", "Progressive rock", "Grunge"] | ["male singer", "fast tempo", "rock", "hard rock", "sonic power", "cymbals", "youthful", "pulsating", "electrifying", "enthusiastic", "amplified instruments", "vigorous drumming", "intense electric guitar lead", "keyboard harmony", "upbeat", "energetic", "loud", "boisterous", "enthusiastic", "metal", "heavy metal", "pop rock", "dance groove"] | 7 | J9ZlahUawkg | 1975 | |
A Static Lullaby "Toxic" Official Music Video HQ | Director: Robby Starbuck | A male vocalist sings this energetic rock song. The song is fast tempo with emphatic drumming, groovy bass lines, funky electric guitar feedback and keyboard accompaniment, with animated, high pitched backup. The song is youthful, energetic,spirited, intense, psychedelic and passionate. This song is Hard Rock. | 2009-03-02T21:57:13Z | RobbyStarbuck | Please watch after clicking "High quality" button Directed By: Robby Starbuck (follow on twitter @robbystarbuck) Song: Toxic Label: Fearless Album: Punk Goes Pop 2 Released March 2, 2009! www.robbystarbuck.com | ["Heavy metal", "Music", "Rock music", "Drum machine", "Progressive rock", "Grunge"] | ["male singer", "fast tempo", "youthful", "progressive", "compelling", "passionate", "funky electric guitar feedback", "emphatic drumming", "groovy bass lines", "animated vocal backup", "high pitched singing", "funky electri guitar feedback", "youthful", "progressive", "hard rock", "metal", "hard metal", "goth rock", "punk rock", "energetic", "emphatic", "intense", "goth", "psychedelic"] | 7 | JrOV2Xz2djA | 2039 | |
Solemn Promise - Leave The Rats Behind | The heavy metal music features a guttural male voice. The sound is aggressive and energetic. The background has a dark tonality that contrasts the heavily distorted guitars that strum chords. An aggressive drum kit plays a common heavy metal beat in the background. This is a song you could hear at a monster truck show. | 2013-10-14T19:37:15Z | SolemnPromiseMusic | Get Solemn Promise's debut EP 'Worse Than Death' DOWNLOAD (name your price / free): http://www.solemnpromise.bandcamp.com PHYSICAL COPY / MERCH: http://www.solemnpromise.bigcartel.com LYRICS: Eyes burn green. Staring at me. Get what you earn. You want what you can't have. You're too weak to carry the weight of your words. Your teeth are blunt and blunt teeth don't dig deep. This is true heart, you have no heart. A poison mouth and glare won't stop me. So clear out your mouth and avert your eyes. Leave the rats in the sewer like the filth they are. You're on higher ground. Leave the rats behind. Say it to my fucking face. Sever the tongue and burn the roots. Eyes burn green. Get what you earn. Leave the fucking rats behind, leave you in the fucking dust. Your words mean nothing. FACEBOOK: http://www.facebook.com/SolemnPromiseMusic TWITTER: http://www.twitter.com/SolemnPromise BANDCAMP: http://www.solemnpromise.bandcamp.com BIGCARTEL: http://www.solemnpromise.bigcartel.com | ["Heavy metal", "Music", "Progressive rock", "Grunge"] | ["heavy metal", "hard rock", "aggressive drum kit", "heavily distorted aggressive electric guitar", "dark ambience background", "gurtural vocals", "dark", "energetic", "mid tempo"] | 5 | Wu-Oh9OJIlI | 3146 |
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;