musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic male vocal" and musiccaps_aspects contains "punchy kick" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- energetic 2
- energetic male vocal · 2 ✖
- punchy kick · 2 ✖
- punchy snare 2
- aggressive 1
- chaotic 1
- dirty 1
- distorted bass guitar 1
- drum roll 1
- energetic crash cymbal 1
- groovy bass 1
- low quality 1
- messy 1
- metal 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) 3 ✖
- Music 2
- Angry music 1
- Ska 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 |
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;