musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "hard rock" and musiccaps_names contains "Rock music" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 76 ✖
- hard rock · 6 ✖
- energetic 4
- metal 3
- youthful 3
- aggressive 2
- amplified instruments 2
- enthusiastic 2
- fast tempo 2
- groovy bass lines 2
- heavy metal 2
- keyboard harmony 2
- live performance 2
- male singer 2
- rock 2
- sonic power 2
- acoustic drums 1
- addictive 1
- animated electric guitar harmony 1
- animated vocal backup 1
- bass 1
- bass guitar 1
- boisterous 1
- chainsaw 1
- compelling 1
- concert 1
- cymbals 1
- dance groove 1
- distorted bass guitar 1
- distortion guitar 1
- down sweep 1
- echoing electric guitar licks 1
- electric guitar 1
- electric guitar lead 1
- electrifying 1
- emphatic 1
- emphatic drumming 1
- excited vocals 1
- funky electri guitar feedback 1
- funky electric guitar feedback 1
- gig 1
- goth 1
- goth rock 1
- guitar lick 1
- hard metal 1
- hard-hitting 1
- high pitched singing 1
- infectious drumming 1
- instrumental 1
- intense 1
- intense electric guitar lead 1
- loud 1
- male vocal 1
- male vocalist 1
- medium fast tempo 1
- moderate tempo 1
- no voice 1
- passionate 1
- pop rock 1
- progressive 1
- psychedelic 1
- pulsating 1
- punchy drumming 1
- punchy kick 1
- punchy snare 1
- punk rock 1
- repetitive filtered male vocal 1
- retro 1
- retro rock 1
- rock drums 1
- shimmering hi hats 1
- shouting 1
- spirited 1
- upbeat 1
- upbeat song 1
- vigorous drumming 1
- wide aggressive electric guitar chords 1
musiccaps_names (array) 13 ✖
- Music 6
- Rock music · 6 ✖
- Grunge 3
- Heavy metal 2
- Progressive rock 2
- Punk rock 2
- Burst, pop 1
- Chainsaw 1
- Drum 1
- Drum machine 1
- Guitar 1
- Musical instrument 1
- Psychedelic rock 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
GODZILLA 1998 / Puff Daddy Feat. Jimmy Page - Come With Me (Morello Mix) | The Hard Rock song features a repetitive filtered male vocal over shimmering hi hats, down sweep, wide aggressive electric guitar chords, distorted bass guitar, echoing electric guitar licks, punchy kick and punchy snare hits. It sounds energetic, aggressive and addictive. | 2009-03-23T02:05:43Z | sideskroll | A track from the "Come With Me" single by Puff Daddy and Jimmy Page for the GODZILLA 1998 movie. With Tom Morello producing it, playing guitar and bass. If you liked this movie go to http://www.godzilla1998.org where you can find some interesting info about the movie and join other people who enjoyed the film. [b]Download MP3 Track[/b] Puff Daddy Feat. Jimmy Page - Come With Me (Morello Mix): http://www.megaupload.com/?d=XU7YGDSI Password: sideskroll | ["Music", "Rock music", "Grunge"] | ["hard rock", "shimmering hi hats", "wide aggressive electric guitar chords", "distorted bass guitar", "echoing electric guitar licks", "repetitive filtered male vocal", "punchy kick", "punchy snare", "down sweep", "energetic", "aggressive", "addictive"] | 4 | KKgYvcfrxj4 | 2074 | |
Cold Metal - Iggy Pop.mp4 | A male vocalist sings this energetic Rock song. The tempo is medium fast with an animated electric guitar harmony and lead, groovy bass lines,infectious drumming and keyboard harmony. The song is electric,pulsating, youthful, energetic, enthusiastic, passionate and powerful with emphatic vocals. This song is Heavy Metal. | 2010-01-13T20:14:33Z | wotsitooyou | Iggy Pop live does Cold Metal | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Burst, pop"] | ["male vocalist", "medium fast tempo", "live performance", "gig", "concert", "retro", "retro rock", "keyboard harmony", "infectious drumming", "animated electric guitar harmony", "groovy bass lines", "punchy drumming", "electric guitar lead", "retro", "rock", "heavy metal", "hard rock", "metal", "sonic power", "amplified instruments", "excited vocals", "youthful", "spirited", "enthusiastic", "energetic"] | 7 | NxdQtpceXaI | 2381 | |
Led Zeppelin - Rock and Roll (Madison Square Garden 1973) | This hard rock song features a distortion guitar playing aggressive riffs. This is accompanied by a rock percussion playing a simple rock beat with a roll at the end. The bass guitar plays the root notes of the chord with a flourish to move to the subsequent note. There are no voices in this song. This is an instrumental song. | 2011-11-30T15:18:24Z | Led Zeppelin | Watch Led Zeppelin perform their song 'Rock And Roll' live at Madison Square Garden in New York City in July 1973 from The Song Remains the Same. The Song Remains the Same has been reissued with audio remastered by Jimmy Page! Order your copy here https://lnk.to/TSRTS More info about this show: http://www.ledzeppelin.com/show/july-... ► Listen to Mothership https://lnk.to/StreamMothership ♪ Watch all episodes of Led Zeppelin History https://lnk.to/LedZeppelinHistoryID 🕭 Subscribe to the Led Zeppelin channel https://lnk.to/YTLedZeppelinSubID Official Led Zeppelin Playlists: ☑ Led Zeppelin - Essentials https://lnk.to/YTLedZeppelinEssentialsID 📽 The Led Zeppelin Rare Film Series https://lnk.to/LedZeppelinRareFilmID 🎚 Led Zeppelin - Alternative Mixes & Deep Cuts https://lnk.to/LedZeppelinAltMixID Stay Connected with Led Zeppelin: ♪ Website http://www.ledzeppelin.com 🎛 Facebook http://www.facebook.com/ledzeppelin 🎙 Twitter http://www.twitter.com/ledzeppelin 🎞 Instagram https://www.instagram.com/ledzeppelin --------------------------------------------------------------------------------------------------------------------- The Led Zeppelin channel is the band’s official YouTube home, featuring a catalog of official live performances, official music videos, Led Zeppelin History, archival footage, and Zeppelin-approved playlists. 🕭 Subscribe to join the Led Zeppelin YouTube community and check back for new uploads, product announcements, and updates from the band Led Zeppelin formed in 1968 and went on to become one of the most influential, innovative, and successful groups in modern music, having sold more than 300 million albums worldwide. The band rose from the ashes of The Yardbirds, when Jimmy Page brought in John Bonham, John Paul Jones, and Robert Plant to tour as The New Yardbirds. In 1969, Led Zeppelin released its self-titled debut which was produced by Page, as were all the subsequent albums. It marked the beginning of a 12-year reign, during which the group was widely considered to be the … | ["Music", "Punk rock", "Rock music"] | ["hard rock", "distortion guitar", "guitar lick", "no voice", "instrumental", "rock drums", "bass", "moderate tempo", "upbeat song"] | 0 | XgXOW3lX25Y | 3212 | |
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 |
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;