musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "snappy rimshot"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 18 ✖
- flat male vocal · 2 ✖
- low quality · 2 ✖
- snappy rimshot · 2 ✖
- arpeggiated electric guitar melody 1
- easygoing 1
- electric guitar solo melody 1
- emotional 1
- fun 1
- groovy 1
- groovy bass 1
- groovy bass guitar 1
- live performance 1
- rock 1
- shimmering bright cymbals 1
- shimmering hi hats 1
- simple piano chord progression 1
- soft kick 1
- sustained electric guitar melody 1
musiccaps_names (array) 5 ✖
- Music 2
- Punk rock 1
- Rock music 1
- Sad music 1
- Salsa music 1
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 | |
Si Tus Amigas Te Cuentan || La Timba Criolla || PERÚ MUSIC 2016 || SALSA KING | The low quality recording features a live performance with flat male vocals talking over electric guitar solo melody, shimmering and bright drums cymbals, snappy rimshots, groovy bass and simple piano chord progression. Sounds fun and groovy - like something you would dance to with your friends. | 2016-07-09T20:26:50Z | PERÚ MUSIC | AUDIO EXCELENTE SÍGUENOS EN FACEBOOK COMO PERÚ MUSIC https://www.facebook.com/Per%C3%BA-Music 865450980253654/?fref=ts | ["Music", "Punk rock", "Rock music", "Salsa music"] | ["low quality", "live performance", "electric guitar solo melody", "shimmering bright cymbals", "snappy rimshot", "groovy bass", "simple piano chord progression", "flat male vocal", "groovy", "fun"] | 4 | usrzF-0GbLY | 5141 |
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;