musiccaps_details (view)
23 rows where musiccaps_aspects contains "female voice" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 127 ✖
- female voice · 23 ✖
- electronic drums 4
- melodic singing 4
- strong bass 4
- acoustic drums 3
- acoustic guitar 3
- amateur recording 3
- ambient synth 3
- energetic 3
- flute 3
- instructive speaking 3
- kids song 3
- loud 3
- pop music 3
- sound effects 3
- vibrant 3
- bass guitar 2
- dance 2
- electric guitar 2
- generic 2
- joyful 2
- live performance 2
- loud electronic drums 2
- male vocal 2
- male voice 2
- meditation 2
- mellow 2
- poor quality 2
- sentimental 2
- shouting 2
- shouting-like singing 2
- spanish 2
- synth 2
- synthesizer 2
- acoustic 1
- arpa jarocha 1
- bass 1
- beatboxing 1
- birds singing 1
- brushing teeth 1
- calm 1
- calming 1
- catchy 1
- cebuano language 1
- chant 1
- cheerful 1
- child male voice 1
- child-like vocal 1
- christmas music 1
- clicks 1
- clown horn 1
- comedic 1
- crowd cheering 1
- crowd sounds 1
- crying 1
- danceable 1
- def 1
- devotional 1
- disco 1
- drum & pipe band 1
- easygoing 1
- educational 1
- eerie 1
- electric piano 1
- electronic 1
- emotional 1
- festive 1
- funk 1
- funny 1
- goofy 1
- hardcore 1
- harp 1
- heart-touching 1
- high-pitched 1
- hindi film music 1
- hip-hop music 1
- introduction 1
- irritating 1
- keyboard 1
- latin dance music 1
- lesson recording 1
- lively 1
- maximalist 1
- medium tempo 1
- melodic 1
- mexican folk music 1
- music documentary 1
- music show 1
- narrating 1
- pakistani sufi music 1
- percussion 1
- piano 1
- plucking 1
- rapping 1
- rave 1
- relaxed 1
- relaxing 1
- religious 1
- repeated theme 1
- robotic voice 1
- romantic 1
- scottish bagpipes 1
- scratching 1
- sensual 1
- simple 1
- simple tune 1
- sitar 1
- soap opera soundtrack 1
- speech 1
- spiritual 1
- squeaking sound effects 1
- street performance 1
- strings 1
- synth bass 1
- talking 1
- tuning 1
- turntable 1
- tutorial 1
- tv series 1
- ukulele 1
- unsettling 1
- urban sound 1
- vocoder 1
- walking 1
- wind chimes 1
- xylophone 1
- zumba 1
musiccaps_names (array) 42 ✖
- Music 19
- Speech 7
- Harp 2
- Inside, large room or hall 2
- Music for children 2
- Musical instrument 2
- Singing 2
- Vocal music 2
- Acoustic guitar 1
- Bagpipes 1
- Beatboxing 1
- Bowed string instrument 1
- Chant 1
- Child singing 1
- Christian music 1
- Christmas music 1
- Dance music 1
- Electronic tuner 1
- Funk 1
- Guitar 1
- Happy music 1
- Harmonic 1
- Hip hop music 1
- House music 1
- Inside, small room 1
- Jingle (music) 1
- Mandolin 1
- Middle Eastern music 1
- Music of Latin America 1
- New-age music 1
- Pizzicato 1
- Plucked string instrument 1
- Scratch 1
- Scratching (performance technique) 1
- Sigh 1
- Soul music 1
- Synthetic singing 1
- Television 1
- Toothbrush 1
- Traditional music 1
- Wind instrument, woodwind instrument 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;