musiccaps_details (view)
21 rows where search matches "guitar", musiccaps_aspects contains "playful" and musiccaps_names contains "Music"
This data as json
musiccaps_aspects (array) 158 ✖
- playful · 21 ✖
- bass guitar 12
- acoustic drums 7
- electric guitar 7
- joyful 7
- live performance 7
- acoustic guitar 6
- easygoing 5
- instrumental 4
- keyboard 4
- upbeat 4
- banjo 3
- bluegrass 3
- cheerful 3
- emotional 3
- female vocal 3
- happy 3
- lively 3
- male vocals 3
- melodic singing 3
- no singer 3
- uplifting 3
- vibrant 3
- afrobeat 2
- colorful 2
- energetic 2
- fast tempo 2
- instrumental music 2
- keyboard accompaniment 2
- latin percussion 2
- male vocal 2
- mandolin 2
- medium tempo 2
- percussion 2
- piano 2
- rural 2
- saxophone 2
- sound effects 2
- spirited 2
- average audio quality 1
- banjo solo 1
- bass 1
- bollywood 1
- bollywood retro 1
- bongos 1
- brass 1
- causal 1
- celtic music 1
- chewing 1
- childlike 1
- childlike singing 1
- children's song 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
- dance 1
- dance music 1
- distorted electric guitar 1
- drum brush hits 1
- drums 1
- duet 1
- educational 1
- electronic drums 1
- exciting 1
- explosions 1
- fast-paced acoustic drums 1
- fiddle 1
- fiddle solo 1
- fiddler 1
- flamboyant singing 1
- fresh 1
- fun 1
- funk jazz 1
- groovy 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
- irish folk music 1
- jam session 1
- japanese pop-punk 1
- jazz 1
- jazz festival 1
- jazz music 1
- jovial 1
- kids show theme 1
- kids song 1
- korean 1
- latin 1
- latin dance 1
- latin folk music 1
- latin instrumental music 1
- latin pop 1
- light 1
- lively tambourine beats 1
- loud 1
- love song 1
- male vocalist 1
- male voice 1
- marimba 1
- memdium tempo 1
- mexican 1
- minimalist 1
- minimalist music 1
- mome music video 1
- passionate 1
- pastoral 1
- perky 1
- poor audio quality 1
- pop rock 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
- steady drumming 1
- subtle jazz drumming 1
- tapping 1
- teenage female vocal 1
- timeless 1
- traditional folk music 1
- traditional percussion instruments 1
- trumpet 1
- trumpets 1
- ukele 1
- upright bass 1
- urban 1
- violin 1
- violins playing 1
- vivacious 1
- vocal backup 1
- vocalisation 1
- wind instrument 1
- xylophone 1
- young love 1
- youthful 1
musiccaps_names (array) 37 ✖
- Music · 21 ✖
- Bluegrass 4
- Musical instrument 4
- Blues 2
- Country 2
- Flamenco 2
- Happy music 2
- Jazz 2
- Music of Bollywood 2
- Music of Latin America 2
- Singing 2
- Acoustic guitar 1
- Afrobeat 1
- Banjo 1
- Dance music 1
- Drum kit 1
- Folk music 1
- Gospel music 1
- Guitar 1
- Hip hop music 1
- Mandolin 1
- Marimba, xylophone 1
- Music for children 1
- Oink 1
- Percussion 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
- 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;