musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "easygoing", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "low quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- easygoing · 4 ✖
- emotional · 4 ✖
- low quality · 4 ✖
- groovy bass guitar 2
- rock 2
- "4 on the floor" kick pattern 1
- alternative/indie 1
- arpeggiated acoustic flamenco guitar melody 1
- arpeggiated electric guitar melody 1
- cover 1
- crowd cheering 1
- crowd clapping 1
- crowd noises 1
- electric guitar feedback 1
- flat male vocal 1
- live performance 1
- mellow 1
- mono 1
- noisy 1
- passionate 1
- passionate male vocal 1
- punchy kick 1
- punchy snare 1
- repetitive synth bells melody 1
- sad 1
- shimmering cymbals 1
- shimmering hi hats 1
- shimmering tambourine 1
- smooth bass guitar 1
- snappy rimshot 1
- soft kick 1
- sustained electric guitar melody 1
- wide electric guitars melodies 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DEF LEPPARD - "Goodbye" (Official Music Video) | The low quality recording features a rock song that consists of flat male vocal singing over sustained and arpeggiated electric guitar melodies, followed by snappy rimshots, soft kick, shimmering hi hats and groovy bass guitar. It sounds emotional and easygoing. | 2013-10-18T15:47:22Z | DEF LEPPARD | Get tickets to Def Leppard's 2020 Stadium Tour with Mötley Crüe and special guests Poison & Joan Jett here: https://defleppard.com Subscribe to our channel for new videos: http://bit.ly/LeppardYT Def Leppard’s Full Catalog Now Available to Stream & Download Worldwide: https://UMe.lnk.to/DefLeppardDigital ___________ LISTEN TO DEF LEPPARD: Apple/iTunes: https://DefLeppard.lnk.to/itunesapple Spotify: https://ume.lnk.to/DefLeppardDigital/spotify Amazon: https://ume.lnk.to/DefLeppardDigital/Amazon Deezer: https://ume.lnk.to/DefLeppardDigital/Deezer Pandora: https://ume.lnk.to/DefLeppardDigital/pandora FOLLOW DEF LEPPARD: Website: http://www.DefLeppard.com/ YouTube: https://www.youtube.com/defleppard Instagram: http://instagram.com/DefLeppard Facebook: https://www.facebook.com/DefLeppard Twitter: https://twitter.com/DefLeppard Publisher: http://www.PrimaryWave.com | ["Music", "Sad music"] | ["low quality", "rock", "flat male vocal", "groovy bass guitar", "sustained electric guitar melody", "arpeggiated electric guitar melody", "snappy rimshot", "soft kick", "shimmering hi hats", "easygoing", "emotional"] | 4 | -M-6VinyMiY | 37 | |
FLAMENCO GUITAR CHILL-OUT | The low quality recording features an arpeggiated acoustic flamenco guitar melody. The recording is noisy, in mono, and it sounds sad, easygoing and emotional. | 2007-09-24T10:53:49Z | maitzegur | Flamenco Chill-Out | ["Flamenco", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "mono", "noisy", "arpeggiated acoustic flamenco guitar melody", "sad", "emotional", "easygoing"] | 4 | IKfmu7tAyUE | 1894 | |
Babyshambles - Gang of Gin | The low quality recording features an alternative/indie song that consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melodies, shimmering cymbals and "4 on the floor" kick pattern. It sounds mellow, easygoing, emotional and passionate. | 2009-01-25T10:38:31Z | ninsajala | Babyshambles Gang of Gin Lyrics: I get around to singing about That gang of gin I'm in Then you'll know most certainly The kind of game I'm in You sound around to swinging about The gang of gin I'm rolling in, oh Then you'll know The kind of state I'm in Who will buy my beautiful roses? Who will buy my beautiful songs? Who will buy my beautiful roses? Who will buy my beautiful songs? Oh in a nutshell Yeah in a nutshell, oh In a nutshell In a nutshell I get around to singing about That gang of gin I'm in Then you'll know The kind of game I'm in She was getting pally with a scally in the alley Giving head for gear She calls a spade a spade Got slit from ear to ear Who will buy my beautiful roses? Who will buy my beautiful songs? Who will buy my beautiful roses? Who will buy my beautiful songs? Well I showed no decorum Span my heart out on the forum Looked like a snapshot Of the most tragic day I'll tell you my story The treachery it bores me Carl and McGee both promised me It would not happen this way Carl is kept sedated The frontman elevated And McGee doing all he can to ruin my band And keep me out the way In this industry of fools Musclemen and ghouls If you're not a puppet or a muppet Then you might as well call it a day-ayay The truth here gets distorted The wall scrapings get snorted I'm welcome back if I give up crack But you gave me my first pipe anyway Can't show no decorum Posts left on the forum Was like a snapshot Of the most tragic day | ["Music", "Independent music"] | ["low quality", "alternative/indie", "passionate male vocal", "wide electric guitars melodies", "groovy bass guitar", "shimmering cymbals", "\"4 on the floor\" kick pattern", "mellow", "easygoing", "emotional", "passionate"] | 4 | XI-tRuDZ6HA | 3172 | |
Part 1: With or Without You (U2 Cover: Rattle & Hum) with Axe-Fx Ultra | The low quality recording features a cover of a rock song and it consists of an electric guitar feedback playing over a live performance instrumental that has crowd cheering, crowd clapping noises, smooth bass guitar, repetitive synth bells melody, punchy snare and kick hits and shimmering tambourine. It sounds emotional and easygoing. | 2010-03-29T04:08:11Z | U2 Guitar Tutorials | Cover of U2's With or Without You. Part 1 of guitar tutorial. Based on the live version from Rattle & Hum. Recorded entirely with Fractal Audio's Axe-Fx Ultra. See www.u2guitartutorials.com for more information. | ["Music", "Rattle"] | ["low quality", "live performance", "electric guitar feedback", "crowd noises", "crowd clapping", "crowd cheering", "smooth bass guitar", "repetitive synth bells melody", "punchy snare", "punchy kick", "shimmering tambourine", "cover", "rock", "emotional", "easygoing"] | 4 | d2gHgzfC-Oo | 3759 |
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;