musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "energetic male vocal" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 28 ✖
- energetic male vocal · 3 ✖
- distorted bass guitar 2
- energetic 2
- low quality 2
- metal 2
- punchy kick 2
- punchy snare 2
- aggressive 1
- chaotic 1
- crushed 1
- dirty 1
- distorted 1
- drum roll 1
- electric guitar chords 1
- energetic crash cymbal 1
- energetic drums 1
- groovy bass 1
- live performance 1
- messy 1
- noisy 1
- passionate 1
- repetitive electric guitar melody 1
- rock 1
- shimmering cymbals 1
- shimmering hi hats 1
- short drums roll 1
- wide electric guitar melody 1
- wide soft whispering male vocals 1
musiccaps_names (array) 4 ✖
- Music · 3 ✖
- Angry music 1
- Ska 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Red Hot Chili Peppers - Nothing To Lose - B-Side [HD] | The Rock song features an energetic male vocal singing over repetitive electric guitar melody, groovy bass, punchy kick and snare, shimmering hi hats and energetic crash cymbal. There is a short drum roll that represents a variation in a repetitive loop. It sounds energetic and passionate. | 2011-07-31T19:54:18Z | llllphaserllll | "Nothing To Lose" is a live jam B-Side of the Red Hot Chili Peppers single "Can't Stop" from their 2002 album "By The Way". [HD VIDEOS] + RHCP Live in Koln 2011 - http://www.youtube.com/user/IIIIphaserIIII + RHCP B-Sides + Bonus Tracks - http://www.youtube.com/user/llllphaserllll + RHCP Live Off The Map - http://www.youtube.com/user/IIphaserII + RHCP Live at the BBC - http://www.youtube.com/user/Iphaserl + RHCP Live at Slane Castle - http://www.youtube.com/user/IlasterixIl + RHCP Live in Poland - http://www.youtube.com/user/lllasterixlll + RHCP Live in Red Square Moscow - http://www.youtube.com/user/llphaserll + Radiohead In Rainbows Live From The Basement - http://www.youtube.com/user/IIIphaserIII + Radiohead The King Of Limbs Live From The Basement - http://www.youtube.com/user/lllphaserlll + Radiohead TV Performances / Live At The Grammys - http://www.youtube.com/user/lIphaserlI + Radiohead HD Official Videos http://www.youtube.com/user/lphaserI Tags: Red Hot Chili Peppers Nothing To Lose Rare B-Side Bonus Track 2002 Can't Stop Single By The Way HD High Definition HQ Quality 1080p Anthony Kiedis Flea John Frusciante Chad Smith | ["Music", "Ska"] | ["rock", "energetic male vocal", "repetitive electric guitar melody", "groovy bass", "punchy snare", "punchy kick", "shimmering hi hats", "short drums roll", "energetic crash cymbal", "energetic", "passionate"] | 4 | 0EzWmAPwoTs | 137 | |
Atreyu - Right Side Of The Bed ( LYRICS ) | The low quality recording features a wide, soft whispering male vocals singing over a wide electric guitar melody, shimmering cymbals and drum roll. In the second part of the loop there is an energetic male vocal singing over more energetic electric guitar chords, distorted bass, punchy kick and snare hits and shimmering cymbals. It sounds energetic, aggressive, but also messy and kind of chaotic, since the mix is dirty. | 2008-04-27T17:45:40Z | ShadowsxxProductions | Lyrics For Atreyu's Right Side Of The Bed | ["Music", "Angry music"] | ["metal", "wide soft whispering male vocals", "energetic male vocal", "wide electric guitar melody", "distorted bass guitar", "shimmering cymbals", "drum roll", "punchy kick", "punchy snare", "low quality", "energetic", "aggressive", "dirty", "messy", "chaotic"] | 4 | 2aPVOidHLXI | 386 | |
Motley Crue - Shout at the Devil - 9-7-2006 - Hartford, Ct. | The low quality recording features a live performance of a metal song and it consists of energetic male vocal singing over energetic drums, distorted bass guitar and electric guitar riff. It sounds crushed, energetic, distorted and noisy, as it was probably recorded with a phone. | 2007-06-28T16:44:41Z | evilcartman420 | Another great show by the Crue. | ["Music", "Whoop"] | ["low quality", "crushed", "metal", "live performance", "energetic male vocal", "electric guitar chords", "distorted bass guitar", "energetic drums", "distorted", "noisy"] | 4 | Ime3FHuQG4k | 1937 |
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;