musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy music", musiccaps_aspects contains "poor audio quality" and musiccaps_names contains "Guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- groovy music · 3 ✖
- instrumental music 3
- poor audio quality · 3 ✖
- emotional 2
- medium tempo 2
- acoustic guitar lead 1
- amateur recording 1
- amplification 1
- audio units 1
- bad audio quality 1
- blues dance music 1
- blues guitar 1
- blues legends 1
- country blues band 1
- country blues hits 1
- country blues music 1
- couples dancing 1
- dance rhythm 1
- demo video 1
- effects pedal demonstration 1
- energetic 1
- enthusiastic 1
- erotic 1
- exciting 1
- flamenco guitar style 1
- grunge tones 1
- guitar distortion 1
- guitar effects pedal 1
- guitar lead 1
- guitar playing 1
- …
musiccaps_names (array) 12 ✖
- Guitar · 3 ✖
- Music 3
- Plucked string instrument 2
- Acoustic guitar 1
- Blues 1
- Chorus effect 1
- Country 1
- Distortion 1
- Effects unit 1
- Flamenco 1
- Musical instrument 1
- Steel guitar, slide guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Roy Rogers (slide guitar) - Look Over Yonders Wall | The song is an instrumental. The song is medium tempo, with an acoustic guitar playing blues, strong drumming rhythm, walking bass line and keyboard harmony. The song is exciting and has a dance rhythm. The audio quality is poor. | 2007-11-22T23:21:53Z | Vladimir BluesJammer | Roy Rogers (slide guitar) - performance from his video "Slide Guitar For Rock & Blues" http://www.homespuntapes.com | ["Blues", "Guitar", "Music", "Steel guitar, slide guitar"] | ["acoustic guitar lead", "country blues music", "poor audio quality", "instrumental music", "blues legends", "blues legends", "live performance", "live audience", "live in concert", "country blues band", "retro blues hits", "bad audio quality", "strong walking bass", "blues guitar", "steady rock drumming", "exciting", "enthusiastic", "retro blues", "country blues hits", "emotional", "enthusiastic", "groovy music", "blues dance music"] | 1 | hzznbzry5R8 | 4156 | |
MXR Black Label Chorus | The song is an instrumental. The tempo is medium fast with a guitar playing lead with a guitar effects pedal producing a distorted grunge tone. The song is energetic and passionate with no other instrumentation. The song audio quality is very poor. | 2010-02-24T00:53:01Z | ProGuitarShopDemos | Buy Now: https://goo.gl/ez26hw The MXR Black Label Chorus is not your typical chorus pedal, because it is crafted and modeled after Zakk Wyldes own tone and style. This is Zakks secret weapon a stereo chorus that thickens up solos and adds some lush texture to the cleans, without taking away from his monstrous tone. This is a true bypass analog chorus pedal that is completely vintage in its tone, but thoroughly modern in its abilities. The tone shaping abilities of the MXR Black Label Chorus are amazing, with separate high and low tone cut controls. Add to the Level, Depth, and Rate knobs, and you can get some astounding chorus tones. From lush analog chorus effects to Leslie styled sounds, the MXR Black Label Chorus provides an amazing array of chorus effects. The tone cuts can really shape your tone, and with some creative knob tweaking, you can muster some utterly original and startling chorus effects. This wouldnt mean a whole lot unless the sound was pristine. This is a vintage sounding chorus pedal with high quality analog circuitry that delivers astounding chorus effects. Add this chorus effect to some thundering solos, and you have unlocked the secret of rich and thick solo tones. - http://proguitarshop.com/store/chorus-pedals-c-70/mxr-black-label-chorus-p-1580 | ["Effects unit", "Guitar", "Music", "Chorus effect", "Plucked string instrument", "Distortion"] | ["instrumental music", "guitar playing", "audio units", "tech gear demos", "demo video", "rock music", "amateur recording", "poor audio quality", "guitar effects pedal", "amplification", "guitar distortion", "guitar rhythm", "groovy music", "grunge tones", "poor audio quality", "effects pedal demonstration", "energetic", "youthful", "passionate", "spirited", "solo", "soloist", "home studio", "amateur recording", "rock music", "medium tempo"] | 1 | merGvga39Yo | 4484 | |
Nancy 🇮🇳 Rumba 🇮🇳 (Juan Serrano) | The song is an instrumental. The tempo is medium with a guitarist playing traditional flamenco style guitar in a rhumba rhythm. The song has a Latin dance groove and sounds delightful. The song has a poor audio quality. | 2015-07-07T18:32:38Z | Aman (Flamenco Guitarist) | Nancy (Rumba Flamenca) composed by Juan Serrano played by me on YAMAHA CG172SF Flamenco guitar. | ["Country", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["rhumba music", "latin guitar player", "instrumental music", "medium tempo", "emotional", "romantic", "erotic", "madly in love", "couples dancing", "tango", "guitar lead", "guitar strumming", "music lesson ideo", "poor audio quality", "latin dance music", "groovy music", "solo instrumental", "groovy music", "dance rhythm", "flamenco guitar style"] | 1 | w4Z1QuBOMWU | 5236 |
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;