musiccaps_details (view)
102 rows where musiccaps_aspects contains "female singer"
This data as json, CSV (advanced)
musiccaps_aspects (array) 920 ✖
- female singer · 102 ✖
- medium tempo 42
- emotional 37
- romantic 28
- passionate 23
- poor audio quality 22
- youthful 20
- keyboard accompaniment 19
- steady drumming rhythm 17
- vocal harmony 17
- groovy bass line 16
- keyboard harmony 16
- love song 16
- slow tempo 15
- spirited 14
- energetic 13
- fast tempo 13
- backup singers 11
- inspiring 11
- live performance 11
- bad audio quality 10
- cheerful 10
- piano accompaniment 10
- club music 9
- dj 9
- electronic music 9
- enthusiastic 9
- medium fast tempo 9
- melancholic 9
- buoyant 8
- dance groove 8
- foreign language 8
- percussive bass line 8
- pop song 8
- story telling 8
- amateur recording 7
- dance rhythm 7
- guitar accompaniment 7
- motivational 7
- retro pop hits 7
- strong bass line 7
- vocal backup 7
- celestial 6
- dance hits 6
- dance music 6
- groovy rhythm 6
- pop 6
- punchy 6
- sentimental 6
- synthesiser arrangements 6
- vivacious 6
- exciting 5
- groovy music 5
- guitar rhythm 5
- male singer 5
- meditative 5
- melodic 5
- movie soundtrack 5
- people dancing 5
- peppy 5
- punchy drumming 5
- song cover 5
- steady drumming 5
- together forever 5
- violin harmony 5
- world music 5
- dance club 4
- devotional 4
- digital drumming 4
- dreamy 4
- electro pop 4
- electronic dance music 4
- emphatic vocals 4
- enigmatic 4
- ethereal 4
- groovy 4
- inferior audio quality 4
- live audience 4
- mellow 4
- people talking 4
- perky 4
- pleasant 4
- regional music 4
- slick drumming 4
- soothing 4
- soul music 4
- synth pop 4
- tambourine percussions 4
- teen pop 4
- vibrant 4
- ambient room noise 3
- animated 3
- auto harp 3
- average audio quality 3
- bongos 3
- bouncy 3
- captivating 3
- classical music 3
- country music 3
- country pop 3
- cymbals crashing 3
- dance floor 3
- dance pop 3
- diva 3
- e-bass 3
- enchanting 3
- enthusiastic drumming 3
- falsetto 3
- happy 3
- harp 3
- haunting 3
- heartfelt 3
- high notes 3
- latin music 3
- madly in love 3
- melodious 3
- memdium tempo 3
- orchestra 3
- percussion hits 3
- pop diva 3
- pop hits 3
- prayer 3
- resonator 3
- retro hits 3
- rhythmic acoustic guitar 3
- screaming vocals 3
- soft 3
- soprano 3
- steady bass line 3
- subtle bass line 3
- synthesiser arrangement 3
- synthesiser articulation 3
- upbeat 3
- uptempo 3
- various percussion hits 3
- vocal duet 3
- vocal vibrato 3
- acoustic drums 2
- acoustic guitar 2
- acoustic guitar accompaniment 2
- acoustic love song 2
- adoration 2
- amateur singing 2
- ambient sounds 2
- angelic 2
- arabic music 2
- atmospheric synthesiser 2
- auto tune 2
- banjo 2
- blues music 2
- catchy riff 2
- cello 2
- children’s song 2
- choir 2
- choral harmony 2
- choral music 2
- christmas carols 2
- clapping 2
- clapping rhythm 2
- classic pop hits 2
- club 2
- congas 2
- contemporary 2
- contemporary pop 2
- country hits 2
- crowd cheering 2
- dobro 2
- electronica 2
- enthralling 2
- female backup singers 2
- fiddle 2
- folk music 2
- folk song 2
- fresh 2
- funky bass line 2
- funky bass lines 2
- groovy drumming rhythm 2
- hip hop dance music 2
- hip hop music 2
- hip-hop 2
- hissing tones 2
- home video 2
- incoherent music 2
- intense 2
- jazz music 2
- karaoke 2
- keybiard accompaniment 2
- keybiard harmony 2
- life is good 2
- life lessons 2
- lilting melody 2
- lilting vocals 2
- lively 2
- lonely 2
- love songs 2
- lullaby 2
- male backup singers 2
- mandolin 2
- meditational 2
- mesmerising 2
- middle eastern music 2
- missing you 2
- mystical 2
- new age 2
- no percussion instruments 2
- no percussions 2
- nostalgia 2
- nostalgic 2
- opera 2
- opera singer 2
- party night 2
- pensive 2
- philharmonic orchestra 2
- pop music 2
- pop rock 2
- pop super hits 2
- positive 2
- powerful vocals 2
- praise and worship 2
- quirky 2
- regional pop 2
- retro dance hits 2
- retro pop song 2
- sad 2
- sad song 2
- simple 2
- simple melody 2
- small hand cymbals 2
- song ending 2
- soulful singing 2
- sound of chatter 2
- spirited drumming 2
- string bass 2
- string bass line 2
- string section 2
- string section harmony 2
- tambourine 2
- tambourine beats 2
- techno dance music 2
- video soundtrack 2
- viola 2
- vocal echoes 2
- vocal emphasis 2
- vocalisation 2
- winter wonderland 2
- 2000s pop 1
- acapella 1
- acapella band 1
- accompaniment 1
- acordion harmony 1
- acordion melody 1
- acoustic guitar lead 1
- acoustic guitar strumming 1
- acoustic piano 1
- acoustic pop hits 1
- adorable 1
- advent 1
- adventurous 1
- advertisement soundtrack 1
- alternative 1
- alternative rock 1
- alto 1
- alto sax 1
- always with you 1
- amateur music production 1
- amateur video 1
- ambient 1
- ambient auditorium sounds 1
- ambient crowd noise 1
- ambient room noises 1
- amplified 1
- amplified instruments 1
- ancient lineage instrument 1
- animated movie soundtrack 1
- animated piano 1
- animated singing 1
- animated voices 1
- aorangi vocals 1
- arabic dance music sultry vocals 1
- arabic dance song 1
- arabic percussion 1
- arabic percussions 1
- arabic pop song 1
- arabic singer 1
- asanas 1
- autoharp accompaniment 1
- avant-garde 1
- avante-garde 1
- background cheering 1
- backup female singers 1
- backup singer 1
- backup singers vocal harmony 1
- backup vocals 1
- ballad/pop 1
- bass drum 1
- bass guitar 1
- beach party 1
- beach party hits 1
- beachside party 1
- bell harmony 1
- bells percussions 1
- belly dancing music 1
- best day of my life 1
- big band plays 1
- big show 1
- big stage 1
- black gospel influences 1
- black gospel music influences 1
- blues turnaround 1
- body percussions 1
- boisterous 1
- bollywood music 1
- booming bass line 1
- boomy 1
- boomy bass drops 1
- brass band 1
- brass band harmony 1
- breakup 1
- breakup song 1
- bridal send off song 1
- bridal song 1
- bright bass lines 1
- bright vocals 1
- building tension 1
- bustling 1
- busy 1
- busy kick pattern 1
- busy music 1
- buzzing sound 1
- calming 1
- cameras clicking 1
- car repair video 1
- carefree 1
- careless nights 1
- caribbean music style 1
- caribbean percussions rhythm 1
- caring 1
- carols 1
- catchy 1
- catchy melody 1
- catchy tune 1
- catchy vocal riff 1
- catholic prayer 1
- catholic salutation 1
- celebratory 1
- celestial music 1
- celtic christmas 1
- celtic folk music 1
- celtic music 1
- celtic new age 1
- chant 1
- chant like 1
- chanting 1
- chaotic harmony 1
- cheerful courtship song 1
- cheerful positive 1
- cheering 1
- cheering sounds 1
- child tv stars 1
- children singing 1
- chimes 1
- choral backup 1
- choral band 1
- christian gospel song 1
- christian music 1
- christian praise songs 1
- christian song 1
- christmas music 1
- christmas time 1
- church bells 1
- church music 1
- classic hits 1
- classic latin songs 1
- classic pop song 1
- classic reverse hits 1
- classic rock 1
- classical ghazals 1
- classical song 1
- climactic 1
- college humour 1
- compelling 1
- composer 1
- concert 1
- concert hall reverb 1
- conductor 1
- confusion 1
- congas beat 1
- congregational 1
- congregational singing 1
- contemporary folk 1
- country love songs 1
- country romantic hits 1
- country side 1
- country song 1
- cowboys 1
- crowd hooting 1
- crowds clapping 1
- crowds sing along 1
- crowds talk 1
- crowds whistling 1
- crying 1
- cymbal crashes 1
- dance club mix 1
- dance tunes 1
- dance with you 1
- dancing with you 1
- dark 1
- dealing with depression 1
- death metal 1
- december 1
- delicate 1
- descan 1
- descant 1
- desk tapping rhythm 1
- despondent 1
- deteriorated audio 1
- deteriorated audio quality 1
- devotional music 1
- dholak percussions 1
- digital drums 1
- disco hits 1
- disco music 1
- disco pop 1
- disco rap 1
- disco romance hits 1
- discomforting effect 1
- discotheque 1
- dissonant sound 1
- distorted audio quality 1
- distorted guitar rhythm 1
- distorted harmony 1
- distorted vocals 1
- dj turntable 1
- dog barking sound 1
- doo-wop hits 1
- double reed solo 1
- downtempo 1
- dramatic 1
- dramatic finish 1
- dream of you 1
- dream scene music 1
- dreamscapes 1
- drone 1
- droning 1
- droning melody 1
- drum kit 1
- drum machine 1
- drum rolls 1
- drums 1
- duet 1
- dulcet 1
- e-guitars 1
- earnest 1
- edm 1
- eerie 1
- elec 1
- electric guitar 1
- electric guitar harmony 1
- electric guitar riff 1
- electric guitar strumming 1
- electric guitar tremolo tones 1
- electro rap 1
- electronic 1
- electronic instrumentation 1
- electronic bass 1
- electronic drum kit 1
- electronic flute 1
- electronic harmony tones 1
- electronic pop 1
- elegy 1
- eloquent piano accompaniment 1
- elvis presley 1
- emotional al 1
- emotional connection 1
- en wage hits 1
- encouraging crowd 1
- energetic electric guitar harmony 1
- engaging 1
- enjoy life 1
- enthusiastic vocals 1
- ethnic percussions 1
- euro pop hits 1
- excited 1
- experimental 1
- explore nature 1
- extemporaneous 1
- faint vocals 1
- fart jokes 1
- fast beats 1
- fast percussion rhyme 1
- feel good 1
- feeling good 1
- female choir 1
- female harpist 1
- female performer 1
- female rapper 1
- female vocalist 1
- feminist 1
- fervent 1
- finger snaps 1
- flute 1
- flute harmony 1
- flute melody 1
- foreign language introduction 1
- french jazz 1
- fresh punchy 1
- fret noise 1
- fun 1
- funk music 1
- funky 1
- funky groove 1
- funky music 1
- funny song 1
- funny videos 1
- fuzzy synth 1
- ghazal 1
- gig 1
- girl singing 1
- girl band 1
- girl metal band 1
- gospel 1
- grating female vocals 1
- groovy acoustic guitar accompaniment 1
- groovy bas line 1
- groovy bas slime 1
- groovy bass 1
- groovy bass lines 1
- groovy dance beat 1
- groovy drum rhythm 1
- groovy guitar rhythm 1
- groovy melody 1
- groovy mood bass line 1
- groovy rhtyhm 1
- group vocals 1
- grunge keyboard tones 1
- guiro 1
- guitar 1
- guitar bass line 1
- guitar lead 1
- guitar notes playing 1
- guitar playing 1
- guitar strumming 1
- hall reverb 1
- happening paces 1
- happy cheerful positive 1
- hard hitting 1
- hard hitting drums 1
- hard rock 1
- harmonica 1
- harmonious 1
- harp accompaniment 1
- haunting harmony 1
- having fun 1
- healing 1
- heart break 1
- heavy metal 1
- heavy reverb 1
- high pitch 1
- high pitched vocals 1
- high spirits 1
- hindi hits 1
- hissing ambient sound 1
- hissing and buzzing distortions 1
- hissing noise 1
- hissing noises 1
- home recording 1
- home videos 1
- hopeful 1
- horn section 1
- horror film soundtrack 1
- huge arena 1
- hymns 1
- hynoptic 1
- hypnotic 1
- ibiza nights 1
- improvisation 1
- in love with you 1
- indian classical 1
- indian god 1
- indian percussion instruments 1
- indian percussions 1
- indian traditional song 1
- indie 1
- infectious 1
- insistent 1
- inspirational love song 1
- intense electric guitar 1
- intense electric guitar feedback 1
- interlude in song 1
- it’s a wonderful life 1
- jazz and blues 1
- jazz drumming 1
- jazz drumming rhythm 1
- jazz music show 1
- jazz scatting 1
- k-pop 1
- keyboard accomapniment 1
- keyboard accompaniment poor audio quality 1
- keyboard arrangement 1
- keyboard string section 1
- kick 1
- killing time 1
- kindergarten song 1
- kindness 1
- korean pop 1
- lao folk music 1
- laos classical song 1
- laos folk song 1
- laotian classical music 1
- latin 1
- latin folk 1
- latin folk songs 1
- latin jazz music 1
- latin percussion rhythm 1
- latin percussions 1
- latin pop 1
- latin song 1
- laughing 1
- life is a dance 1
- life’s lessons 1
- life’s meanings 1
- life’s truths 1
- lilting 1
- lilting music 1
- live concert 1
- lively accordion 1
- lively trumpet 1
- loneliness 1
- loud feedback 1
- loud vocals 1
- love me 1
- love performance 1
- love you so badly 1
- loving 1
- low fidelity 1
- low fidelity recording 1
- low pitch 1
- low-fidelity recording 1
- lucid vocals 1
- lyrical singing 1
- made up songs 1
- make your own songs 1
- male backing voice 1
- male backing voices 1
- male backup 1
- male rapper 1
- march like beat 1
- marry me 1
- mediocre sound recording 1
- mehandi ceremony 1
- melisma 1
- mellifluous 1
- mellifluous dulcet 1
- mellow electric guitar 1
- melodic piano accompaniment 1
- melodic violin 1
- melodious tune 1
- melodipiano accompaniment 1
- metal 1
- miami larry 1
- middle eastern stringed instrument 1
- minimal music 1
- modern classical 1
- modern hip hop hits 1
- modern pop 1
- modern pop covers 1
- modern pop hits 1
- moog bass 1
- motown 1
- mouth percussions 1
- muddled audio 1
- muffled audio 1
- music concert 1
- music production 1
- muted vocals 1
- mysterious 1
- never give up 1
- new age hits 1
- no harmony instrumentation 1
- no instrumentation 1
- no instruments 1
- no percussion 1
- nursery rhyme 1
- odern pop hits 1
- off key singing 1
- offbeat 1
- old classics 1
- oldest instrument 1
- opera hall 1
- operatic theme 1
- orchestra plays 1
- orchestral accompaniment 1
- organ accompaniment 1
- outdoors 1
- pain 1
- paino accompaniment 1
- party all night 1
- party hits 1
- passionate spirited 1
- people clapping 1
- percussion hit 1
- percussion instrument 1
- percussion shakers 1
- percussive bas slime 1
- percussive hits 1
- perky vocals 1
- philharmonic 1
- piano 1
- piano chords 1
- piano playing accompaniment 1
- pleasant melody 1
- pleasant vocals 1
- plucking 1
- poignant 1
- poor quality 1
- pop cover 1
- pop dance hit 1
- pop dance hits 1
- pop hit 1
- pop rap 1
- pop songs 1
- poprock 1
- positive vibes 1
- powerful 1
- powerful voice 1
- powerfully voice 1
- prayerful 1
- presents 1
- promises 1
- proverbs 1
- psychedelic 1
- psychedelic background 1
- psychedelic harmony 1
- psychedelic music 1
- puja 1
- pulsating 1
- punk pop 1
- quality of 1
- quirky drum machine 1
- r&b 1
- r&b music 1
- r&b music influences 1
- radio buzzing tones 1
- rap 1
- rapper 1
- rapping vocals 1
- rebellious 1
- recurring beat 1
- reflective lyrics 1
- reggae groove 1
- reggae hits 1
- reggae style influences 1
- relaxing 1
- relaxing and comforting 1
- relaxing playlist 1
- relaxing playlists 1
- repeated vocal phrases 1
- resonator guitar 1
- retro 1
- retro dance music 1
- retro death metal hits 1
- retro electronica 1
- retro jazz 1
- retro new age hits 1
- retro pop 1
- retro pop music 1
- retro pop super hits 1
- retro super hits 1
- retro tv show tunes 1
- reverb 1
- rhythm section 1
- rich 1
- romantic emotional 1
- russian pop star 1
- rustling 1
- sadness 1
- saxophone 1
- say sorry 1
- scary 1
- scat improvisation 1
- sci-fi 1
- scratching disc 1
- scuffling 1
- seconds 1
- self discovery 1
- sensory experiences 1
- serene 1
- sexy 1
- shakers 1
- sharing 1
- shrill vocal quality 1
- silence 1
- simple bass lines 1
- singer talking 1
- slamming door percussion 1
- slowing down 1
- smooth 1
- snare playing 1
- snowfall 1
- soft lilting flute 1
- soft piano accompaniment 1
- soft pop 1
- soft rock 1
- something hard hitting a surface 1
- song climax 1
- song covers 1
- song fade 1
- song introduction 1
- song retarding 1
- sonic effects 1
- soul singer 1
- soulful singer 1
- spanish 1
- spanish music 1
- special someone 1
- spinning discs 1
- spirited singing 1
- spiritual 1
- standing bass line 1
- steady 1
- steady bass lines 1
- steady percussive rhythm 1
- steady rhythm 1
- steel drum 1
- steel pan percussion 1
- steel string guitar 1
- strength 1
- string bass drum kicks 1
- string drumming rhythm 1
- string ensemble 1
- string section accompaniment 1
- string section crescendo 1
- string synth pad harmony 1
- stringed instrument accompaniment 1
- strong 1
- strong bass drum hits 1
- strong bass drum kicks 1
- strong drumming rhythm 1
- strong percussive bass line 1
- strummed acoustic guitar 1
- sublime 1
- subtle bass lines 1
- sundowner 1
- suspense 1
- symphony 1
- symphony orchestra 1
- syncopated 1
- syncopated rhythms 1
- synth bass 1
- synthesised vocals 1
- synthesiser arpeggio 1
- synthesizer 1
- tabla 1
- tabla playing steadily 1
- tambourine percussion 1
- technically challenging melody 1
- techno music 1
- techno pop music 1
- teen age fun 1
- teenage age angst 1
- tenor sax 1
- theremin 1
- timeless hits 1
- together always 1
- traditional music influences 1
- traditional percussion rhythm 1
- trance 1
- trance music 1
- tropical beach party 1
- tropical dance hit 1
- trudging drum rhythm 1
- trumpets blaring 1
- turn table 1
- tv show tune 1
- two different tracks 1
- ukele melody 1
- ukelele accompaniment 1
- unconventional 1
- unique instrument 1
- unrelated 1
- unsettling 1
- upbeat electronic riff 1
- upbeat groove 1
- various frequency tones 1
- vibrato 1
- vic latin dance 1
- vigorous drumming 1
- vintage jazz 1
- vintage pop 1
- violin solo 1
- violin symphony 1
- vocal chanting 1
- vocal chants 1
- vocal crooning 1
- vocal jazz 1
- vocal monologue 1
- vocal vibrations 1
- vocal virtuosity 1
- walking bass line 1
- walking march tempo 1
- wedding dance 1
- wedding dance song 1
- wedding love song 1
- wedding song 1
- wedding songs 1
- wedding super hits 1
- wedding vows 1
- western classical 1
- whirring sound 1
- wide aggressive vibrato 1
- wild 1
- with you forever 1
- woo her 1
- workout playlist 1
- worship 1
- xylophone 1
- xylophone like instrument 1
- yoga 1
- young love 1
- young vocalist 1
musiccaps_names (array) 96 ✖
- Music 96
- Singing 25
- Folk music 7
- Song 7
- Pop music 6
- Christian music 5
- Disco 5
- Music of Asia 5
- Rhythm and blues 5
- /t/dd00003 4
- /t/dd00004 4
- Afrobeat 4
- Funk 4
- Happy music 4
- Opera 4
- Sad music 4
- Soul music 4
- Dance music 3
- Hip hop music 3
- Humming 3
- Independent music 3
- Inside, large room or hall 3
- Jazz 3
- Middle Eastern music 3
- Rattle (instrument) 3
- Tender music 3
- Wedding music 3
- Bell 2
- Blues 2
- Choir 2
- Christmas music 2
- Electronic music 2
- Electronica 2
- Grunge 2
- Inside, public space 2
- Jingle (music) 2
- Mantra 2
- Music of Bollywood 2
- Music of Latin America 2
- Musical instrument 2
- New-age music 2
- Percussion 2
- Reggae 2
- Sampler 2
- Scary music 2
- Ska 2
- Ukulele 2
- Vocal music 2
- Yodeling 2
- Zing 2
- /m/02zsn 1
- /m/05zppz 1
- A capella 1
- Angry music 1
- Applause 1
- Bass drum 1
- Burst, pop 1
- Buzz 1
- Church bell 1
- Clapping 1
- Classical music 1
- Crackle 1
- Crowd 1
- Drum 1
- Drum and bass 1
- Drum kit 1
- Drum machine 1
- Drum roll 1
- Electronic dance music 1
- Exciting music 1
- Flamenco 1
- Gospel music 1
- Groan 1
- Guitar 1
- Hands 1
- Inside, small room 1
- Lullaby 1
- Music of Africa 1
- Plucked string instrument 1
- Rapping 1
- Rimshot 1
- Rock music 1
- Salsa music 1
- Scratching (performance technique) 1
- Snare drum 1
- Speech 1
- Steelpan 1
- Strum 1
- Synthesizer 1
- Synthetic singing 1
- Tambourine 1
- Techno 1
- Theremin 1
- Traditional music 1
- Trance music 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Transistor OST - In Circles Mashup (Humming & Singing) | A female singer sings this poignant melody. The song is slow tempo with an electric guitar buzzing harmony, piano accompaniment, steady drumming rhythm, keyboard harmony, groovy bass line and Tambour percussions. The song is emotional and melancholic. The song is a poor quality recording of a classic pop song. | 2014-07-04T13:54:06Z | the Dragon Coffee | Lyrics: I hear you buzzing, a fly on the wall In through the window and up through the hall Flying in circles just trying to land I see you hurting I do what I can But I won't save you I won't save you Maybe you're looking for someone to blame Fighting for air while you circle the drain Never be sorry for your little time It's not when you get there, it's always the climb But I won't save you I won't save you I won't save you I won't save you ------------------------------------------------------ THANKS to the Supergiant Games for this AWESOME GAME, and Music! | ["Singing", "Humming", "Music", "Song"] | ["female singer", "grunge keyboard tones", "classic pop hits", "dreamscapes", "tambourine percussions", "steady drumming rhythm", "booming bass line", "traditional percussion rhythm", "chaotic harmony", "poor audio quality", "electric guitar tremolo tones", "piano accompaniment", "pop song", "classic pop song", "inspiring", "emotional", "slow tempo", "trudging drum rhythm", "sadness", "melancholic"] | 1 | z6SNngkMAug | 5457 | |
Dorit Chrysler | Sustain Me | Moog Sound Lab | A quirky drum machine and warm synth bass provide the accompaniment for a female singer with noticeable reverb. A wild theremin with delay and wide aggressive vibrato enters to give the music a wild sci-fi feel. | 2011-05-26T20:19:04Z | Moog Music Inc | Dorit Chrysler dynamically plays an original composition on her customized Moog Etherwave Pro, a theremin manufactured by Moog Music from 2004-2006, for an ethereal Moog Sound Lab. To function as a one woman band, Dorit triggers a prerecorded backtrack on her laptop, adding vocals and Etherwave Pro theremin in real time. At her feet are a MF-104Z Analog Delay and an Akai Head Rush looper to add depth to her sound. Voila! See other Moog Sound Lab performances: http://bit.ly/MoogSoundLabVideos | ["Singing", "Sampler", "Music", "Theremin", "Synthesizer"] | ["female singer", "synth bass", "reverb", "theremin", "unconventional", "retro", "sci-fi", "quirky drum machine", "wide aggressive vibrato", "wild"] | 8 | ztfegVzqeCI | 5515 |
Advanced export
JSON shape: default, array, newline-delimited
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;