musiccaps_details (view)
25 rows where search matches "guitar" and musiccaps_aspects contains "playful" sorted by youtube_published
This data as json
musiccaps_aspects (array) 190 ✖
- playful · 25 ✖
- bass guitar 14
- electric guitar 9
- acoustic drums 8
- acoustic guitar 7
- joyful 7
- live performance 7
- cheerful 6
- instrumental 6
- easygoing 5
- upbeat 5
- female vocal 4
- keyboard 4
- no singer 4
- banjo 3
- bluegrass 3
- emotional 3
- fast tempo 3
- happy 3
- lively 3
- male vocals 3
- melodic singing 3
- uplifting 3
- vibrant 3
- afrobeat 2
- colorful 2
- electronic drums 2
- energetic 2
- fun 2
- groovy 2
- instrumental music 2
- jazz 2
- keyboard accompaniment 2
- kids song 2
- latin percussion 2
- light 2
- male vocal 2
- male vocalist 2
- mandolin 2
- medium tempo 2
- percussion 2
- piano 2
- poor audio quality 2
- rural 2
- saxophone 2
- sound effects 2
- spirited 2
- steady drumming 2
- trumpets 2
- vocalisation 2
- youthful 2
- advertisement jingle 1
- affecting 1
- animated voices 1
- auto harp 1
- average audio quality 1
- banjo solo 1
- bass 1
- bass drum 1
- bollywood 1
- bollywood retro 1
- bongos 1
- brass 1
- breezy 1
- buoyant 1
- causal 1
- cello 1
- celtic music 1
- chewing 1
- child playing 1
- childlike 1
- childlike singing 1
- children talking 1
- children's song 1
- child’s voice 1
- choir 1
- choral harmony 1
- christmas carols 1
- christmas cheer 1
- christmas greeting 1
- christmas songs 1
- clarinet 1
- concert 1
- country music 1
- cover 1
- cumbia 1
- cymbals 1
- dance 1
- dance music 1
- distorted electric guitar 1
- drum brush hits 1
- drums 1
- duet 1
- educational 1
- exciting 1
- explosions 1
- fast-paced acoustic drums 1
- female vocal backup 1
- fiddle 1
- fiddle solo 1
- fiddler 1
- flamboyant singing 1
- fresh 1
- funk jazz 1
- funky 1
- funky bass line 1
- generic 1
- groovy bass line 1
- groovy music 1
- guitar playing 1
- guitar strumming 1
- harmonica 1
- harmonizing 1
- high tempo 1
- hindi song 1
- hip 1
- hip-hop 1
- home music video 1
- improvisation 1
- insightful 1
- intense 1
- irish folk music 1
- jam session 1
- japanese pop-punk 1
- jazz festival 1
- jazz music 1
- jovial 1
- keyboard harmony 1
- kids show theme 1
- korean 1
- latin 1
- latin dance 1
- latin folk music 1
- latin instrumental music 1
- latin pop 1
- lively tambourine beats 1
- loud 1
- love song 1
- major key 1
- male voice 1
- marimba 1
- medium fast tempo 1
- melodic 1
- memdium tempo 1
- mexican 1
- minimalist 1
- minimalist music 1
- mome music video 1
- organ 1
- passionate 1
- pastoral 1
- perky 1
- pipe organ 1
- pop 1
- pop rock 1
- reflective 1
- reggae 1
- relaxing 1
- repeated theme 1
- rhythmic acoustic guitar 1
- rock 1
- seductive singing 1
- shuffle 1
- simple 1
- spanish guitar 1
- speech like singing 1
- sprechstimme 1
- squeaking 1
- static 1
- subtle jazz drumming 1
- tapping 1
- teenage female vocal 1
- timeless 1
- traditional folk music 1
- traditional percussion instruments 1
- trumpet 1
- ukele 1
- upright bass 1
- urban 1
- viola 1
- violin 1
- violins 1
- violins playing 1
- vivacious 1
- vocal backup 1
- wind band 1
- wind chimes 1
- wind instrument 1
- xylophone 1
- young love 1
musiccaps_names (array) 44 ✖
- Music 21
- Bluegrass 4
- Musical instrument 4
- Blues 2
- Country 2
- Flamenco 2
- Happy music 2
- Jazz 2
- Music for children 2
- Music of Bollywood 2
- Music of Latin America 2
- Singing 2
- Acoustic guitar 1
- Afrobeat 1
- Banjo 1
- Bowed string instrument 1
- Brass instrument 1
- Cello 1
- Dance music 1
- Double bass 1
- Drum kit 1
- Folk music 1
- Funk 1
- Gospel music 1
- Guitar 1
- Hip hop music 1
- Mandolin 1
- Marimba, xylophone 1
- Oink 1
- Percussion 1
- Pizzicato 1
- Plucked string instrument 1
- Rapping 1
- Rock and roll 1
- Rock music 1
- Roll 1
- Ska 1
- Speech 1
- Steelpan 1
- Swing music 1
- Tender music 1
- Timpani 1
- Trumpet 1
- Violin, fiddle 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;