musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "energetic crash cymbal" and musiccaps_aspects contains "groovy bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- energetic 3
- energetic crash cymbal · 3 ✖
- groovy bass · 3 ✖
- punchy kick 3
- punchy snare 2
- rock 2
- addictive 1
- alternative/indie 1
- arpeggiated electric guitar melody 1
- electric guitar licks 1
- energetic male vocal 1
- groovy 1
- halloween 1
- harmonizing background vocal 1
- haunting 1
- passionate 1
- passonate male vocal 1
- repetitive electric guitar melody 1
- reverberant percussion hit 1
- shimmering hi hats 1
- shimmering tambourine 1
- short drums roll 1
- synth keys chords 1
- tremolo electric guitar chord 1
musiccaps_names (array) 6 ✖
- Music 3
- Ska 2
- Grunge 1
- Rhythm and blues 1
- Singing 1
- Soul music 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 | |
José Cid- Mellotron - O Planeta Fantástico | The Alternative/Indie song features layered punchy kicks, energetic crash cymbals, groovy bass and synth key chords, followed by electric guitar licks. It sounds haunting and energetic, almost like a halloween themed song. | 2010-09-24T02:02:36Z | jerudoriginal91 | ["Music", "Rhythm and blues", "Ska", "Soul music"] | ["alternative/indie", "punchy kick", "groovy bass", "synth keys chords", "electric guitar licks", "energetic crash cymbal", "energetic", "haunting", "halloween"] | 4 | 1Xtkou9dtyA | 285 | ||
Aerosmith - Jaded | The rock song features a passionate male vocal, alongside harmonizing background vocal, singing over tremolo electric guitar located in the left channel, arpeggiated electric guitar melody in the right channel of the stereo image, shimmering tambourine, groovy bass guitar, punchy kick and snare hits, reverberant percussive hit and energetic crash cymbal. It sounds groovy, energetic and kind of addictive thanks to that cadence. | 2013-07-13T20:48:09Z | AerosmithVEVO | "Jaded" by Aerosmith Listen to Aerosmith: https://Aerosmith.lnk.to/listenYD Watch more Aerosmith videos: https://Aerosmith.lnk.to/listenYD/youtube Subscribe to the official Aerosmith YouTube channel: https://Aerosmith.lnk.to/subscribeYD Follow Aerosmith: Facebook: https://Aerosmith.lnk.to/followFI Instagram: https://Aerosmith.lnk.to/followII Twitter: https://Aerosmith.lnk.to/followTI Website: https://Aerosmith.lnk.to/followWI Spotify: https://Aerosmith.lnk.to/followSI Lyrics: My, my baby blue Yeah, I been thinking about you My, my baby blue Yeah, you're so jaded And I'm the one that jaded you #Aerosmith #Jaded #OfficialVideo #HD #Remastered | ["Singing", "Music", "Grunge"] | ["tremolo electric guitar chord", "harmonizing background vocal", "arpeggiated electric guitar melody", "punchy snare", "punchy kick", "groovy bass", "shimmering tambourine", "passonate male vocal", "reverberant percussion hit", "energetic crash cymbal", "groovy", "rock", "addictive", "energetic"] | 4 | qbexOeoH5hg | 4801 |
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;