musiccaps_details (view)
11 rows where search matches "guitar", musiccaps_aspects contains "groovy" and musiccaps_aspects contains "instrumental music"
This data as json
musiccaps_aspects (array) 167 ✖
- groovy · 11 ✖
- instrumental music · 11 ✖
- passionate 7
- medium tempo 6
- emotional 5
- energetic 5
- exciting 4
- guitar solo 4
- romantic 4
- soloist 4
- echoes 3
- groovy music 3
- melancholic 3
- adventurous 2
- average audio quality 2
- blues legends 2
- groovy bass line 2
- groovy rhythm 2
- inspiring 2
- medium fast tempo 2
- poignant 2
- poor audio quality 2
- positive 2
- spirited 2
- the blues 2
- ad jingle 1
- adrenaline rush 1
- amateur player 1
- ambient room noises 1
- bad audio quality 1
- bass guitar 1
- bass guitar demo 1
- bass guitar technique 1
- beautiful landscapes 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 music 1
- blues progression 1
- blues turn around 1
- booming bass line 1
- cash register click 1
- celtic music 1
- changing tones 1
- classic guitar hits 1
- classic rock music 1
- classical guitar hits 1
- comforting 1
- country music 1
- cowboys 1
- cymbal hits 1
- dance rhythm 1
- delay effects 1
- dissonant tones 1
- distortion guitars 1
- distortion tones 1
- documentary soundtrack 1
- dreamy 1
- drum roll 1
- effects pedal 1
- electric guitar 1
- electric guitar blues 1
- electric guitar lead 1
- electric guitar player 1
- emotional music 1
- enegetic 1
- enterprising 1
- epic stories 1
- excellent audio quality 1
- excited 1
- fast strumming rhythm 1
- fast tempo 1
- fret noises 1
- funk bass line 1
- funk jazz music 1
- guitar accompaniment style 1
- guitar band 1
- guitar demonstration 1
- guitar echo pedal 1
- guitar effects module demonstration 1
- guitar harmony 1
- guitar lessons online 1
- guitar licks 1
- guitar pick percussions 1
- guitar player 1
- guitar playing rhythm 1
- guitar rhythm 1
- guitarist 1
- gunslingers 1
- gypsy guitar music 1
- harmonica player 1
- harmony 1
- harpist 1
- healing music 1
- heroes and villains 1
- high gain 1
- high gain tones 1
- home music video 1
- home video 1
- homemjsic video 1
- hooting 1
- in love with you 1
- instrumental hits 1
- jazz blues 1
- jazz music influences 1
- legendary licks 1
- legends 1
- life is beautiful 1
- live audience 1
- live performance 1
- massive drum roll 1
- me 1
- meditation playlist 1
- medium fats tempo 1
- new age 1
- new orleans blues 1
- noisy 1
- nostalgia 1
- old memories 1
- out of tune 1
- overuse of effect 1
- people cheering 1
- piano accompaniment 1
- pleasant 1
- relaxing 1
- relaxing music 1
- rhythm guitars 1
- riffs 1
- science experiment 1
- scratching tones 1
- shakers percussions 1
- slap bass 1
- slow dance 1
- soaring melody 1
- solid intro 1
- song covers 1
- sophisticated 1
- soul music 1
- soundtrack 1
- spanish guitar 1
- steady drumming 1
- steady drumming rhythm 1
- story tellers 1
- strings scratched with plectrum percussions 1
- strong bass line 1
- strong rock drumming 1
- strumming rhythm 1
- subtle drum play 1
- suspense 1
- sustained bass line 1
- syncopation 1
- tense 1
- the good life 1
- the lush life 1
- the wild west 1
- tv show 1
- twilight 1
- virtuoso player 1
- virtuous guitarist 1
- walking bass line 1
- youthful 1
- youtube music video 1
musiccaps_names (array) 20 ✖
- Music 11
- Guitar 5
- Musical instrument 5
- Plucked string instrument 4
- Blues 3
- Electric guitar 3
- Tapping (guitar technique) 2
- Bass guitar 1
- Camera 1
- Distortion 1
- Folk music 1
- Heavy metal 1
- Independent music 1
- Inside, small room 1
- Progressive rock 1
- Punk rock 1
- Reverberation 1
- Rock music 1
- Sad music 1
- Strum 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;