musiccaps_details (view)
9 rows where search matches "guitar", musiccaps_author = 7 and musiccaps_names contains "Roll"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 142 ✖
- fast tempo 7
- male vocalist 7
- enthusiastic 5
- live performance 4
- energetic 3
- groovy bass line 3
- hard hitting drumming 3
- hard rock 3
- keyboard harmony 3
- loud 3
- rock 3
- rock and roll 3
- vigorous 3
- amplified instruments 2
- brass band 2
- clapping 2
- concert 2
- heavy metal 2
- inferior audio quality 2
- intense 2
- intense drumming 2
- keyboard accompaniment 2
- passionate 2
- people talking 2
- pop 2
- powerful 2
- rhythmic acoustic guitar 2
- sonic power 2
- vivacious 2
- youthful 2
- a keyboard harmony 1
- acoustic guitar 1
- acoustic guitar rhythm 1
- amateur drumming 1
- amateur singing 1
- ambient background sounds 1
- amplified guitar harmony 1
- amplified keyboard 1
- animated trumpets 1
- assertive 1
- banjo 1
- bass guitar 1
- beseeching 1
- boisterous 1
- bright 1
- bright trumpeting 1
- buoyant 1
- chaotic 1
- cheering 1
- choral harmony 1
- compelling 1
- concert performance 1
- country music 1
- country pop 1
- country song 1
- country songs 1
- crowd cheering 1
- dance groove 1
- dance music 1
- dissonant keyboard 1
- dissonant music playing over song 1
- dominating vocals 1
- double neck guitar 1
- electric bass guitar 1
- electric guitar riff 1
- electrifying 1
- emotional 1
- emphatic 1
- emphatic vocals 1
- energetic electric guitar lead 1
- enthusiastic electronic guitar melody 1
- enthusiastic vocals 1
- fans 1
- fiddle 1
- forceful 1
- funk 1
- gig 1
- groovy background bass 1
- groovy bass lines 1
- hard hitting drums 1
- high pitch 1
- high spirited 1
- infectious drumming 1
- instrumental 1
- intense electric guitar 1
- intense electric guitar feedback 1
- intense electric guitar harmony 1
- jarring 1
- jive 1
- karaoke 1
- loud electric guitar feedback 1
- male singer 1
- mandolin 1
- medium fast tempo 1
- melodic 1
- melodious background electric guitar harmony 1
- melodious background music 1
- metal 1
- muffled audio 1
- muffled music 1
- not in sync 1
- off key singing 1
- people cheering 1
- pleading 1
- poor audio quality 1
- pop rock 1
- prayer 1
- progressive 1
- pulsating 1
- punchy drumming 1
- r&b 1
- raucous 1
- regional music 1
- request 1
- resonator 1
- retro 1
- retro pop 1
- retro rock 1
- rhythmic background drumming 1
- rhythmic drumming 1
- rock concert 1
- rock hits 1
- sentimental 1
- singing along 1
- soft 1
- soul 1
- spirited 1
- spirited string arrangement 1
- steady bass 1
- string instruments 1
- strong beats 1
- trombone 1
- upbeat 1
- vehement 1
- vibrant 1
- vigorous instrumentation 1
- vigorous vivacious 1
- violin 1
- vital 1
- vocal backup 1
- vociferous 1
- wind instruments 1
musiccaps_names (array) 10 ✖
- Music 9
- Roll · 9 ✖
- Rock and roll 4
- Singing 3
- Drum 1
- Drum kit 1
- Inside, large room or hall 1
- Musical instrument 1
- Rock music 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rock 'n' Roll Girls -- John Fogerty | A male vocalist sings this spirited rock and rock song. The tempo is fast with bright drumming, intense electric guitar feedback, keyboard harmony and rhythmic acoustic guitar with vocal backup. The song is upbeat, spirited, enthusiastic, vibrant, vivacious, buoyant and youthful with a dance groove. The sound quality is inferior making it difficult to understand the lyrics or the finer elements of this Rock and Roll song. | 2008-09-03T02:10:47Z | zanzkantdance | John Fogerty performs "Rock and Roll Girls" from Centerfield live in Oakland in 1986, set to various background videos. | ["Singing", "Music", "Musical instrument", "Rock music", "Roll", "Inside, large room or hall"] | ["male vocalist", "fast tempo", "intense electric guitar", "punchy drumming", "keyboard harmony", "vocal backup", "rhythmic acoustic guitar", "groovy bass line", "loud", "jarring", "inferior audio quality", "people cheering", "people talking", "energetic", "enthusiastic", "vigorous vivacious", "bright", "enthusiastic", "dance music", "pop", "pop rock", "rock", "rock and roll"] | 7 | 1ZaxqZMs21M | 287 | |
Eric Clapton I've Got a Rock and Roll Heart Shreds | A male vocalist sings this song. The tempo is slow, with intense drumming; keyboard harmony, groovy bass lines and electric guitar harmony in the background. The vocalist is singing a dissonant tune along with syncopated music over the melodious and rhythmic background. This is probably karaoke. | 2010-01-30T00:00:05Z | boilingsand | Featuring Billy Joel during the middle portion. With respect to the great EC and Billy Joel, and also to StSanders. | ["Music", "Roll", "Rock and roll"] | ["male vocalist", "electric guitar riff", "intense drumming", "melodious background music", "rhythmic background drumming", "groovy background bass", "melodious background electric guitar harmony", "dissonant music playing over song", "dissonant keyboard", "karaoke", "amateur singing", "amateur drumming", "chaotic", "off key singing", "not in sync"] | 7 | 2BGzxAuetOA | 340 | |
Looking Out My Window - Tom Jones | A male vocalist sings this energetic funk pop. The audio quality is inferior and the song is not clear.The tempo is. Fast with animated trumpets, with a boomy trombone, infectious drumming, keyboard harmony, groovy bass lines, rhythmic electric and acoustic guitar and melodious choral backup. The song is melodic, enthusiastic, energetic, animated and captivating Retro Funk/Pop. | 2008-12-16T18:46:37Z | bomtraumusic | Looking Out My Window Tom Jones | ["Music", "Roll"] | ["male vocalist", "fast tempo", "pop", "retro", "retro pop", "muffled audio", "inferior audio quality", "vivacious", "vigorous", "vital", "funk", "r&b", "soul", "vigorous instrumentation", "brass band", "animated trumpets", "trombone", "hard hitting drumming", "keyboard harmony", "choral harmony", "groovy bass lines", "acoustic guitar rhythm", "brass band"] | 7 | DE6bdmnmPtg | 1454 | |
Judas Priest - Freewheel Burning (AC3 Stereo) | A male vocalist sings this spirited song. The song is medium tempo with energetic electric guitar lead, enthusiastic electric bass guitar , hard hitting drums and keyboard harmony. The vocals are passionate, youthful,energetic, vociferous, powerful and loud . This song is Hard Rock/Metal. | 2009-11-24T15:03:04Z | JudasPriestVEVO | Music video by Judas Priest performing Freewheel Burning. (c) 2003 Sony BMG Music Entertainment (UK) Limited | ["Singing", "Music", "Roll", "Yell"] | ["male vocalist", "fast tempo", "hard rock", "rock hits", "rock concert", "live performance", "spirited", "boisterous", "metal", "hard hitting drums", "energetic electric guitar lead", "electric bass guitar", "enthusiastic", "sonic power", "amplified instruments", "vigorous", "passionate", "intense", "vociferous", "a keyboard harmony"] | 7 | M_s-49rNCdw | 2282 | |
Avenged Sevenfold-Dear God Lyrics | A male vocalist sings this melodious country song. The tempo is medium with rhythmic acoustic guitar, fiddle, resonator, banjo, dobro and mandolin accompaniment, keyboard harmony, steady drumming and straight bass lines. The song is mellow, emotional, prayerful, pleading, sentimental, passionate and melodious. This song is Country Pop. | 2009-12-31T14:57:13Z | ComedyGHN | Avenged Sevenfold - Dear God Lyrics! AMAZING TUNE! SUBSCRIBE ;D | ["Music", "Roll"] | ["male singer", "medium fast tempo", "country song", "pleading", "request", "country pop", "spirited string arrangement", "acoustic guitar", "fiddle", "resonator", "banjo", "mandolin", "violin", "rhythmic drumming", "steady bass", "keyboard accompaniment", "country music", "country songs", "regional music", "soft", "melodic", "prayer", "beseeching", "emotional", "sentimental"] | 7 | OI7S7vaBT4I | 2424 | |
Led Zeppelin - Rock and Roll (Live) | A male vocalist sings this energetic Rock song. The tempo is fast with intense drumming, vigorous electric guitar, funky bass and keyboard harmony. The song is a vibrant, enthusiastic, youthful, animated, spirited, buoyant and electrifying Heavy Metal/Rock. There are sounds of people cheering, clapping and singing along, indicating that this is a live performance. | 2008-03-13T23:04:36Z | Rodolfo Baravalle | Rock and Roll en no sé donde.. Viva la pepa (?) | ["Music", "Roll", "Rock and roll"] | ["male vocalist", "fast tempo", "enthusiastic", "string instruments", "amplified instruments", "sonic power", "infectious drumming", "live performance", "gig", "intense electric guitar feedback", "amplified guitar harmony", "keyboard accompaniment", "emphatic vocals", "concert", "live performance", "hard rock", "heavy metal", "rock", "crowd cheering", "clapping", "singing along", "fans", "enthusiastic", "youthful", "electrifying", "compelling"] | 7 | QvwD7NEg3Mw | 2650 | |
Extreme/Paul Gilbert - Rock and Roll | A male vocalist sings this energetic Rock and Roll song. The song is fast tempo with enthusiastic electric guitar, hard hitting drums, groovy bass lines and keyboard harmony. The song is vibrant, high energy, powerfully,passionate, emphatic, vehement, intense and youthful. This song is classic rock. | 2010-04-19T23:22:03Z | fuzzionrestorock | Extreme/Paul Gilbert Fuzzion RestoRock | ["Music", "Roll", "Rock and roll"] | ["male vocalist", "fast tempo", "intense electric guitar harmony", "vehement", "energetic", "vigorous", "vivacious", "assertive", "intense", "forceful", "passionate", "amplified keyboard", "heavy metal", "double neck guitar", "loud", "powerful", "enthusiastic", "energetic", "groovy bass line", "dominating vocals", "high pitch", "rock and roll", "vibrant", "concert performance", "hard hitting drumming"] | 7 | cHGziT0hrZU | 3695 | |
Torvill and Dean 1983 Rock n Roll OSP | This music is a high energy Rock and Roll. The tempo is fast with a vivacious electric guitar melody, punchy drumming, animated trumpets, funky bass line, keyboard and acoustic guitar accompaniment . The music is high energy, vivacious, bright, groovy,enthusiastic and animated Rock and Roll instrumental. | 2007-11-18T01:14:20Z | BJH1981 | Torvill & Dean's Rock n Roll OSP from 1983 World Championships | ["Music", "Roll", "Rock and roll"] | ["instrumental", "fast tempo", "ambient background sounds", "clapping", "live performance", "poor audio quality", "muffled music", "cheering", "people talking", "enthusiastic electronic guitar melody", "hard hitting drumming", "bright trumpeting", "groovy bass line", "rhythmic acoustic guitar", "keyboard harmony", "brass band", "wind instruments", "dance groove", "jive", "rock and roll", "retro rock", "energetic", "enthusiastic", "pulsating", "buoyant", "upbeat", "high spirited"] | 7 | fEHsR679g1M | 3934 | |
GOD OF THUNDER - LIVE (6 year old Drummer) | A male vocalist sings this spirited song. The tempo is fast with intense drumming, loud harmonic electric guitar feedback, bass guitar , emphatic vocals and keyboard accompaniment. The song is a loud, progressive, powerful youthful and emphatic Hard Rock song. | 2013-06-28T12:30:57Z | Avery Drummer Molek | Dressed To Kill are Awesome! They even let me do the solo! VID of me PLAYING WITH KISS → http://bit.ly/AVERY-KISS-COVERS SUBSCRIBE THEN HIT THE 🔔 → http://bit.ly/SUB-AVERY 🔥 FACEBOOK → http://bit.ly/AVERY-FB WEB → http://bit.ly/AVERY-WEB __________ Since I have 100's of 🥁 vidoes on my channel, below are playlist for easy navigation. • CLASSIC ROCK → http://bit.ly/2vye76x • ROCK → http://bit.ly/2vW0nnt • HARD ROCK → http://bit.ly/2w7VZBu • HEAVY METAL → http://bit.ly/2xdvh7M • THRASH METAL → http://bit.ly/2KwBXnX • LIVE GIGS → http://bit.ly/2fyMPVq • REALLY HARD STUFF TO PLAY → http://bit.ly/2iANo2j • TV-INTERVIEWS → http://bit.ly/2mSqpon • POP → http://bit.ly/2jdeJXZ Covers of my Favorite Bands • A7X → http://bit.ly/2wr5jjI • AC/DC → http://bit.ly/2gUdkYY • BOSTON → http://bit.ly/2rPJNBj • DEF LEPPARD → http://bit.ly/2jI1wqX • DREAM THEATER → http://bit.ly/2uWe5SM • GUNS N ROSES → http://bit.ly/2yvwdp5 • IRON MAIDEN → http://bit.ly/2BPyKzY • KISS → http://bit.ly/Playing-with-KISS • LED ZEPPELIN → http://bit.ly/2AiuacD • METALLICA → http://bit.ly/2xEyi1O • MOTLEY CRUE → http://bit.ly/2AXzZZ2 • QUEEN → http://bit.ly/2GPs5HX • RUSH → http://bit.ly/2CsOXM1 • SLAYER → http://bit.ly/2rOD5wt • SOAD → http://bit.ly/2z4zDzd • VAN HALEN → http://bit.ly/2xmgfgB Watch as I grow through the years, in drumming not height. 😉 • 3,4,5 Years Old → http://bit.ly/AGES-3-4-5 • 6 Years Old → http://bit.ly/AGE-6 • 7 Years Old → http://bit.ly/AGE-7 • 8 Years Old → http://bit.ly/AGE-8 • 9 Years Old → http://bit.ly/AGE-9 • 10 Years Old → http://bit.ly/AGE-10 • 11 Years Old → http://bit.ly/AGE–11 Avery “Drummer” Molek is young growing musician. He started playing drums at age 2. He now loves to play everything: classic, rock, jazz, metal and progressive music. Avery also plays bass, guitar & piano. Subscribe to get NEW VIDS! Covers, LIVE Shows, Solos and Originals. Thank you & keep Rockin! 🤘 SUBSCRIBE THEN HIT THE 🔔 → http://bit.ly/SUB-AVERY 🔥 Dressed To Kill & Avery Molek (6 year old drummer) LIVE cove… | ["Singing", "Drum", "Drum kit", "Music", "Roll"] | ["male vocalist", "fast tempo", "intense drumming", "loud electric guitar feedback", "bass guitar", "enthusiastic vocals", "rock", "hard rock", "live performance", "concert", "loud", "raucous", "progressive", "strong beats", "emphatic", "powerful", "youthful"] | 7 | zayC5mUo7sY | 5496 |
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;