musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "energetic", musiccaps_aspects contains "heavy metal" and musiccaps_aspects contains "male vocalist"
This data as json, CSV (advanced)
musiccaps_aspects (array) 62 ✖
- energetic · 4 ✖
- enthusiastic 4
- heavy metal · 4 ✖
- male vocalist · 4 ✖
- youthful 3
- boisterous 2
- fast tempo 2
- hard rock 2
- intense 2
- keyboard harmony 2
- metal 2
- passionate 2
- vibrant 2
- vigorous 2
- amplified instruments 1
- amplified keyboard 1
- animated electric guitar harmony 1
- assertive 1
- car racing sounds 1
- concert 1
- concert performance 1
- dominating vocals 1
- double neck guitar 1
- electric bass guitar 1
- electric guitar lead 1
- electric guitar lead and harmony 1
- energetic drumming 1
- enthusiastic vocal backup 1
- excited vocals 1
- forceful 1
- gig 1
- groovy bass line 1
- groovy bass lines 1
- hard hitting drumming 1
- hard hitting drums 1
- high pitch 1
- impactful 1
- infectious drumming 1
- insistent 1
- instrumental 1
- intense bass line 1
- intense electric guitar harmony 1
- live performance 1
- loud 1
- loud electric guitar feedback 1
- loud vocals 1
- medium fast tempo 1
- powerful 1
- punchy drumming 1
- rapid 1
- retro 1
- retro rock 1
- rock 1
- rock and roll 1
- rock music 1
- sonic power 1
- spirited 1
- vehement 1
- vigorous electric guitar lead 1
- vivacious 1
- vociferous 1
- voracious 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Truth Be Told "Let It Go" Official Music Video | A male vocalist sings this vigorous Rock song. The tempo is fast with enthusiastic electric guitar lead and harmonies, electric bass guitar and hard hitting drumming with cymbal rides. The song is passionate, youthful, enthusiastic, intense, compelling, boisterous and vigorous. This song is a Hard Rock/Heavy Metal song. | 2012-10-04T18:11:26Z | TruthBeToldProject | Produced by: FlareSoul Entertainment Group Directed by Norberto Peña (http://www.npenaphoto.com) Truth Be Told www.Facebook.com/TruthBeToldProject Twitter: @TruthBeToldProj Official Release on iTunes, Spotify, AmazonMp3 on 10/25/12 Lyrics: A total change of mind A total change of life Its necessary to achieve these goals to reach, the desires of our heart. So much sacrifice Wasting money and time Left so many things behind Hope this is, Hope this is worth our while NO! We won't lose our faith, no we won't! So we let it go, let it go Fearless and committed Cause we gotta, go gotta go Find that place where we belong Losing all, winning all Find the purpose, of our, lives Hope this is worth our while Maybe loosing some friends so far from our loved ones Working hard Can't be left behind Using all, using all our might Giving what we are We put together all our strength Hope this is, Hope this is worth our while Be strong and courageous. Do not be frightened; do not be dismayed, for the Lord your God will be with you wherever you go So we let it go, let it go Cause we gotta, go gotta go Losing all, winning all Losing all, winning all All Rights Reserved by Truth Be Told --------------------------------------------------------------------- Additional Tags: Victory Records, Facedown Records, Tooth And Nail, Come & Live, Universal, Lyrics, Metal Blade, Road Runners, Indie, Post Punk, Post Hardcore | ["Music", "Punk rock", "Progressive rock", "/t/dd00032"] | ["male vocalist", "energetic drumming", "loud electric guitar feedback", "electric guitar lead and harmony", "enthusiastic vocal backup", "youthful", "enthusiastic", "energetic", "vibrant", "boisterous", "voracious", "intense", "passionate", "metal", "hard rock", "rock music", "heavy metal", "electric bass guitar"] | 7 | 3nbB3F-OdSM | 501 | |
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 | |
FM3 Drag Racing: N/A C6 Vs Race engine C6 HD | A male vocalist sings this vigorous heavy metal song. The tempo is fast with intense electric guitar lead ,hard hitting drumming, steady bass lines, keyboard harmony and vocal backup. There is a sound of racing cars at the onset of the song followed by a vigorous male vocal harmony. The song is energetic, enthusiastic, gripping, intense, vital and youthful. This song is Heavy Metal. | 2010-07-27T11:16:35Z | Coleman McFarland | If you want to get in on the action, send a friend request to MoDeRNxSoCiEtY. Be sure to include a message about the car you will be driving because if you don't, you WILL NOT be accepted. The details about your car should include NOTE: we DO NOT allow drive train conversions any longer. NO AWD Mustangs, NO RWD CRX'S. your car HAS to have the STOCK drive train or you will also NOT be accepted Horsepower Class (B-S) Modifications list (NOT needed if fully built) Hope to get you on the Channel later later | ["Music", "Accelerating, revving, vroom", "Grunge", "Heavy engine (low frequency)"] | ["instrumental", "fast tempo", "vigorous", "loud vocals", "rapid", "boisterous", "vociferous", "car racing sounds", "heavy metal", "intense bass line", "hard hitting drums", "keyboard harmony", "vigorous electric guitar lead", "male vocalist", "impactful", "insistent", "youthful", "energetic", "enthusiastic"] | 7 | UzT20Rf8RPA | 2966 | |
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 |
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;