musiccaps_details (view)
58 rows where search matches "guitar" and musiccaps_aspects contains "female vocal" sorted by youtube_description
This data as json
musiccaps_aspects (array) 205 ✖
- female vocal · 58 ✖
- bass guitar 44
- electric guitar 30
- melodic singing 29
- acoustic drums 27
- acoustic guitar 17
- keyboard 17
- electronic drums 14
- easygoing 10
- emotional 10
- male vocal 9
- live performance 8
- simple tune 8
- piano 7
- r&b 7
- sentimental 7
- slow tempo 7
- groovy 6
- pop music 6
- drums 5
- energetic 5
- generic 5
- loud 5
- pop 5
- vibrant 5
- playful 4
- religious 4
- rock 4
- urban 4
- calming 3
- cheerful 3
- chill 3
- country music 3
- dance 3
- gospel 3
- hip 3
- male vocals 3
- medium tempo 3
- mellow 3
- rebellious 3
- repeated theme 3
- rock music 3
- soul 3
- upbeat 3
- aggressive 2
- amateur recording 2
- banjo 2
- christian 2
- christian pop 2
- compilation 2
- danceable 2
- educational 2
- electronic percussion 2
- female choir 2
- grandiose 2
- heart-touching 2
- heavy metal 2
- hip-hop 2
- joyful 2
- kids song 2
- latin dance 2
- latin percussion 2
- lullaby 2
- major key 2
- medium-to-high pitch singing 2
- melancholic 2
- mellow singing 2
- normal tempo 2
- pad 2
- pop rock 2
- rap-like singing 2
- reggae 2
- relaxing 2
- seductive singing 2
- simple 2
- sleep-inducing 2
- spanish 2
- strings 2
- 80s pop 1
- accordion 1
- acoustic 1
- acoustic sounding drums 1
- advertisement jingle 1
- afro percussion 1
- afropop 1
- agitated 1
- airy synth 1
- alternative 1
- amp 1
- anime music 1
- ballad 1
- bland 1
- cajon 1
- calm 1
- carnatic music 1
- cartoon theme 1
- childlike singing 1
- children talking 1
- children's song 1
- chipmunk effect 1
- choir 1
- christmas music 1
- church 1
- claps 1
- clicks 1
- comedic 1
- complex 1
- country 1
- country pop 1
- cozy 1
- cumbia 1
- dancehall 1
- devotional 1
- disco funk 1
- disorganized 1
- distorted electric guitar 1
- downtempo 1
- dramatic 1
- duet 1
- eccentric 1
- erotic 1
- eurodance 1
- exhilarating 1
- female back vocal 1
- female child vocal 1
- festive music 1
- festive singing 1
- fiddle 1
- flamenco 1
- french language 1
- funky 1
- gentle singing 1
- gothic 1
- harmonic singing 1
- harmonica 1
- haunting 1
- high tempo 1
- hollering 1
- hopeful 1
- hungarian pop 1
- indian 1
- indian pop music 1
- indo-european fusion 1
- inspiring 1
- intuitive folk 1
- jamaican accent 1
- japanese 1
- japanese jazz 1
- japanese pop 1
- jingle 1
- karaoke 1
- korean 1
- latin 1
- latin pop 1
- lighthearted 1
- lively 1
- longing 1
- mandolin 1
- medium-to-high pitch 1
- minor key 1
- modern 1
- monotonous 1
- movie music 1
- neo-folk 1
- out-of-tune singing 1
- passionate singing 1
- percussion 1
- poor quality 1
- positive 1
- random 1
- remix 1
- reverb 1
- romanian 1
- romantic 1
- sensual 1
- serene 1
- sleigh bells 1
- slightly melodic 1
- slightly slow tempo 1
- soft rock 1
- soothing 1
- soprano 1
- sound effects 1
- southern rap sound 1
- spiritual 1
- static sound effect 1
- strong bass 1
- swing 1
- synth strings 1
- tambourine 1
- tambourine dance 1
- telephone sound effect 1
- thai 1
- touching 1
- trap 1
- trumpets 1
- unique 1
- uplifting 1
- upright bass 1
- video game theme 1
- virtual sounding brass 1
- vocal performance 1
- vocal sample 1
- wind chimes 1
- xylophone 1
musiccaps_names (array) 59 ✖
- Music 53
- Singing 10
- Happy music 7
- Christian music 6
- Pop music 5
- Music for children 4
- Music of Asia 4
- Song 4
- /t/dd00004 3
- Country 3
- Lullaby 3
- Reggae 3
- Child singing 2
- Exciting music 2
- Funk 2
- Independent music 2
- Jazz 2
- Mandolin 2
- Music of Africa 2
- Progressive rock 2
- Radio 2
- Rhythm and blues 2
- Rock music 2
- Soul music 2
- Tambourine 2
- /t/dd00003 1
- /t/dd00032 1
- A capella 1
- Ambient music 1
- Angry music 1
- Banjo 1
- Busy signal 1
- Carnatic music 1
- Christmas music 1
- Crowd 1
- Dance music 1
- Disco 1
- Distortion 1
- Flamenco 1
- Guitar 1
- Heavy metal 1
- Humming 1
- Inside, small room 1
- Jingle (music) 1
- Music of Bollywood 1
- Music of Latin America 1
- Musical instrument 1
- Outside, rural or natural 1
- Pink noise 1
- Psychedelic rock 1
- Reverberation 1
- Salsa music 1
- Ska 1
- Swing music 1
- Synthetic singing 1
- Tender music 1
- Tick-tock 1
- Vocal music 1
- Zing 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;