musiccaps_details (view)
18 rows where search matches "guitar", musiccaps_aspects contains "groovy" and musiccaps_names contains "Blues"
This data as json
musiccaps_aspects (array) 188 ✖
- groovy · 18 ✖
- instrumental 8
- acoustic drums 7
- bass guitar 7
- electric guitar 6
- medium tempo 6
- blues 5
- guitar solo 5
- emotional 3
- instrumental music 3
- live performance 3
- low quality 3
- passionate 3
- romantic 3
- slow tempo 3
- steady drumming 3
- youthful 3
- bad audio quality 2
- blues legends 2
- catchy 2
- chill 2
- crunchy 2
- electric guitar lead 2
- energetic 2
- exciting 2
- funky 2
- funky bass line 2
- groovy bass 2
- groovy bass line 2
- jam 2
- jazz 2
- keyboard 2
- melancholic 2
- no singer 2
- noisy 2
- nostalgia 2
- piano 2
- relaxing 2
- rock music 2
- shimmering cymbals 2
- the blues 2
- upbeat 2
- 80s feel 1
- acoustic 1
- acoustic rhythm guitar chord progression 1
- adventurous 1
- afrobeat 1
- amateur recording 1
- ambient 1
- amplified guitar 1
- amplified guitar riff 1
- atmospheric 1
- backing track 1
- bass guitar accompaniment 1
- bass guitar solo 1
- big band 1
- blue band 1
- blues giants 1
- blues guitar lessons 1
- blues guitar licks 1
- blues guitar tutorial 1
- blues harmonica 1
- blues harp 1
- blues hits 1
- blues lessons 1
- blues progression 1
- blues turn around 1
- brass band 1
- brass stab 1
- burgeoning harmony 1
- calm 1
- captivating 1
- clapping 1
- classic rock 1
- clean electric guitar 1
- complex harmony 1
- concert 1
- cool 1
- country blues 1
- crowd talking 1
- cymbal hits 1
- danceable 1
- dissonant harmony 1
- distorted 1
- dull 1
- easygoing 1
- electric guitar blues 1
- electric guitar lesson 1
- electric guitar melody 1
- energetic drumming 1
- engaging 1
- enthusiastic 1
- enthusiastic electric guitar lead 1
- excellent audio quality 1
- external amplification 1
- fast tempo 1
- flat male vocal 1
- fruity male vocal 1
- fun 1
- funk pop 1
- funk rock 1
- groovy electric guitar melodies 1
- groovy rhythm 1
- guitar harmony 1
- guitar lead 1
- guitar playing rhythm 1
- guitar rhythm 1
- happy 1
- hard 1
- hard rock 1
- harmonica player 1
- harpist 1
- healing music 1
- infectious drumming 1
- inspiring 1
- intense 1
- keyboard accompaniment 1
- legendary licks 1
- loud 1
- loud electric guitar feedback 1
- love song 1
- male singer 1
- male vocal 1
- massive drum roll 1
- meditation playlist 1
- mellow snare 1
- melodic 1
- missing you 1
- modern sound 1
- nasal male vocal 1
- neo soul 1
- new age 1
- new orleans blues 1
- noir style 1
- old memories 1
- percussion 1
- percussion hits 1
- percussions 1
- piano accompaniment 1
- pleasant 1
- pop rock 1
- positive 1
- punchy snare 1
- punk rock 1
- r&b 1
- raw 1
- reggae 1
- relaxing music 1
- repeated theme 1
- retro pop hits 1
- retro rock 1
- rhythm guitar 1
- rhythmic acoustic guitar 1
- rock 1
- sad 1
- saxophone 1
- sentimental 1
- shredding 1
- simple melody 1
- slow dance 1
- smooth double bass 1
- soaring melody 1
- soft kick hits 1
- soft rock 1
- solid intro 1
- somber 1
- sonic power 1
- sonic treat 1
- soothing 1
- sophisticated 1
- soul 1
- spirited 1
- story telling 1
- strong bass guitar 1
- subtle drum play 1
- sustained bass line 1
- tambourine percussions 1
- the lush life 1
- together forever 1
- tropical 1
- trumpets 1
- upbeat catchy 1
- uptempo 1
- vibrant 1
- vibrations 1
- vintage 1
- walking bass line 1
- wistful 1
musiccaps_names (array) 23 ✖
- Blues · 18 ✖
- Music 16
- Guitar 7
- Musical instrument 7
- Plucked string instrument 7
- Electric guitar 4
- Bass guitar 2
- Country 2
- Rhythm and blues 2
- Singing 2
- Acoustic guitar 1
- Dance music 1
- Distortion 1
- Effects unit 1
- Flamenco 1
- Harmonic 1
- Music of Latin America 1
- Reggae 1
- Rock and roll 1
- Rock music 1
- Speech 1
- Strum 1
- Swing music 1
0 records
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;