musiccaps_details (view)
76 rows where musiccaps_aspects contains "emotional" and musiccaps_author = 7
This data as json
musiccaps_aspects (array) 567 ✖
- emotional · 76 ✖
- sentimental 39
- slow tempo 34
- passionate 29
- medium tempo 27
- mellow 27
- male singer 23
- romantic 22
- soft 22
- love song 19
- keyboard harmony 18
- male vocalist 18
- steady drumming 18
- foreign language 16
- instrumental 16
- acoustic guitar 14
- melodic 13
- youthful 13
- melancholic 12
- keyboard accompaniment 11
- pensive 11
- pop 11
- poignant 10
- minimalist 9
- sad 9
- soothing 9
- fast tempo 8
- female singer 8
- groovy bass line 8
- hip-hop 8
- pleasant 8
- rhythmic acoustic guitar 8
- vocal backup 8
- country pop 7
- dulcet 7
- intense 7
- nostalgic 7
- rap 7
- ambient 6
- engaging 6
- mandolin 6
- persuasive 6
- r&b 6
- rhythmic patter 6
- auto harp 5
- calm 5
- christian song 5
- dreamy 5
- electric guitar 5
- female vocalist 5
- fiddle 5
- live performance 5
- lonely 5
- mellifluous 5
- piano accompaniment 5
- soft pop 5
- soul 5
- story telling 5
- synthesiser arrangements 5
- wistful 5
- world music 5
- young love 5
- acoustic guitar accompaniment 4
- amateur recording 4
- ambient sounds 4
- cello 4
- christian praise and worship 4
- classical music 4
- country song 4
- duet 4
- lively 4
- meditative 4
- medium fast tempo 4
- melodious 4
- regional music 4
- resonator 4
- rhythmic speech 4
- simple melody 4
- vocalisation 4
- atmospheric synthesiser 3
- banjo 3
- blues 3
- calming 3
- chimes 3
- classic pop 3
- country hits 3
- country music 3
- dance music 3
- dobro 3
- drum machine 3
- electronic music 3
- emphatic 3
- folk music 3
- folk song 3
- funky bass lines 3
- groovy 3
- heart break 3
- inferior audio quality 3
- intense drumming 3
- k-pop 3
- loud 3
- melancholy 3
- nostalgia 3
- pleasant melody 3
- regional pop 3
- reverence 3
- romantic piano 3
- soft rock 3
- soulful 3
- static 3
- synthesiser articulation 3
- tambourine 3
- violin 3
- violin harmony 3
- violin symphony 3
- wedding song 3
- western classical 3
- alternative rock 2
- ambient music 2
- atmospheric 2
- bagpiper 2
- baritone 2
- bass 2
- bass guitar 2
- bass guitar accompaniment 2
- beseeching 2
- bongos 2
- breakup 2
- breakup song 2
- captivating 2
- christian gospel music 2
- christian gospel song 2
- christian music 2
- classic rock 2
- club music 2
- contemplative 2
- dance pop 2
- devotion 2
- devotional 2
- digital drum rhythm 2
- digital drums 2
- disco rap 2
- earnest 2
- electric guitar harmony 2
- electric guitar lead 2
- electric guitar melody 2
- electro pop 2
- electroni music 2
- emphatic vocals 2
- energetic drumming 2
- enthusiastic 2
- ethereal 2
- euphonious 2
- fingers snapping 2
- first love 2
- gentle 2
- gospel music 2
- groovy bass lines 2
- high notes 2
- home recording 2
- impactful 2
- inspiring 2
- jazz 2
- keyboard arrangement 2
- korean song 2
- lilting melody 2
- live audience 2
- male harmony 2
- mesmerising 2
- middle eastern music 2
- minimalist music 2
- movie soundtrack 2
- muddled audio 2
- muffled vocals 2
- passioante 2
- peaceful 2
- pleading 2
- pop rap 2
- pop rock 2
- praise and worship 2
- proposal song 2
- reflective 2
- reggae 2
- resounding 2
- rock 2
- simple 2
- slick drumming 2
- smooth 2
- soft melody 2
- soft piano 2
- soft piano accompaniment 2
- sombre 2
- spirited 2
- steady bass 2
- steady bass lines 2
- straight bass lines 2
- string instrument 2
- string instruments 2
- synth pop 2
- synthesiser arrangement 2
- upbeat 2
- violins 2
- vocal harmony 2
- warm 2
- accordion harmony 1
- acordian harmony 1
- acousitc guitar 1
- acoustic 1
- acoustic guitar harmony 1
- acoustic guitar melody 1
- acoustic guitar riff 1
- african 1
- alap 1
- alternative 1
- alternative dance 1
- alternative metal 1
- alternative rap 1
- amateur guitarist 1
- amateur singer 1
- amateur singing 1
- ambient piano 1
- amplified guitar 1
- amplified organ 1
- amplified piano 1
- angelic 1
- anthem 1
- applied guitar 1
- arabic music 1
- auditorium acoustics 1
- backup harmony 1
- beat boxing 1
- beautiful 1
- bellows 1
- bellows-blown bagpipe 1
- blues lessons 1
- bollywood 1
- bollywood retro 1
- boomy 1
- boomy bass 1
- boomy bass drops 1
- boomy bass line 1
- boomy bass lines 1
- bouncy 1
- boy band 1
- brass band 1
- bright 1
- bright electric guitar 1
- buoyant 1
- burgeoning music 1
- burgeoning note 1
- buskers 1
- busking 1
- cajun percussion 1
- catchy 1
- catchy melody 1
- celestial 1
- chamber instrument 1
- chanting 1
- charming 1
- cheerful 1
- cheerful chimes 1
- choral backup 1
- choral harmony 1
- choral symphony 1
- christian pop 1
- christian rap 1
- christian rock 1
- christian worship 1
- christian worship song 1
- christmas carol 1
- christmas song 1
- christmas time 1
- chrost 1
- church 1
- church organ 1
- classic 1
- classic melody 1
- classical 1
- clean lyrics 1
- clear 1
- colourful 1
- compelling 1
- complex harmony 1
- congas 1
- contemporary christian music 1
- contemporary hip-hop 1
- contemporary pop 1
- contrast song fade 1
- country folk song 1
- country love song 1
- country song hits 1
- country songs 1
- crowd chatter 1
- dance groove 1
- dance groover 1
- deliberate 1
- delicate 1
- despondent 1
- dexterous 1
- digital beats 1
- digital drumming 1
- digital instrumentation 1
- dissonant harmony 1
- dissonant tambourine beats 1
- distorted audio 1
- distorted sound 1
- dj 1
- dog barking sound 1
- double reed instrument 1
- dream pop 1
- drone pipes 1
- droning 1
- droning keyboard harmony 1
- easter song 1
- electric guitar lesson 1
- electric guitar rhythm 1
- electric guitar riff 1
- electric guitar solo 1
- electronic instruments 1
- eloquent 1
- eloquent vocals 1
- elvis presley 1
- emotional punchy bass line 1
- enchanting 1
- enigmatic 1
- enthusiastic vocal backup 1
- enthusiastic vocals 1
- expressive vocals 1
- female backup 1
- female power 1
- female vocal backup 1
- female vocalisation 1
- female vocals 1
- feminism 1
- feminist 1
- fervent 1
- fog horn 1
- folk pop 1
- foreign music 1
- french carols 1
- french song 1
- funk rock 1
- funky bass line 1
- funky drumming 1
- funky snare drumming 1
- gangsta rap 1
- german song 1
- girl power 1
- good friday 1
- gratitude 1
- greek song 1
- grim 1
- groovy bass 1
- groovy electric guitar lead 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar lead 1
- guitar solo 1
- hand drums 1
- hand percussion 1
- happy 1
- hard rock 1
- harmonica 1
- harmony 1
- harp 1
- haunting 1
- heavenly 1
- heavy metal 1
- high-spirited 1
- hindi song 1
- hip-hop hits 1
- holy 1
- humility 1
- humming melody 1
- hymn 1
- hymns 1
- imploring 1
- inaudible lyrics 1
- incessant 1
- indian bowed string instrument 1
- indistinct chatter 1
- indonesian pop 1
- infectious drumming 1
- inferior sound quality 1
- insightful 1
- insistent rhythm 1
- inspirational 1
- instrumental cover 1
- intense cello 1
- intense electric guitar 1
- intense organ music 1
- k-pop hips 1
- k-pop hits 1
- karaoke 1
- keyboard accomapniment 1
- korean love song 1
- korean pop 1
- longing 1
- loud feedback 1
- love 1
- loyalty 1
- lucid vocals 1
- lullaby 1
- lush 1
- magical 1
- magicalvocalisation 1
- male singers 1
- male vocal backup 1
- male voice speaking 1
- medium 1
- melancholic cello 1
- mellow acoustic guitar 1
- mellow electric guitar 1
- mellow guitar 1
- melodious acoustic guitar rhythm 1
- melodious tune 1
- melody keyboard 1
- melody pie 1
- metal 1
- minimal instruments 1
- minimal music 1
- movie theme music 1
- moving 1
- muffled 1
- muffled audio 1
- muffled recording 1
- muffled sounds 1
- mystical 1
- objectionable lyrics 1
- opera 1
- opera singer 1
- orchestra 1
- organ accomapniment 1
- ost 1
- oud 1
- oud melody 1
- pain 1
- passionate singing 1
- patriotic 1
- patriotism 1
- people talking 1
- percussion 1
- performance 1
- piano harmony 1
- piper 1
- playful 1
- plucking 1
- ponderous 1
- pop hit 1
- pop hits 1
- powerful 1
- prayer 1
- prayerful 1
- progressive 1
- psychedelic synthesiser 1
- punchy 1
- punchy bass 1
- punchy drums 1
- punk rap 1
- quirky music 1
- raga 1
- rapper 1
- recurring 1
- reflective lyrics 1
- regional song 1
- regretful 1
- repentance 1
- repetitive 1
- request 1
- resonator guitar 1
- retro 1
- retro rock and roll 1
- reverb 1
- rhythmic 1
- rhythmic chanting 1
- rhythmic drumming 1
- rhythmic electric guitar 1
- rhythmic foot tapping 1
- rhythmic speechlow notes 1
- rich 1
- rock and rock 1
- sad song 1
- sad vibe 1
- salsa music 1
- sarangi 1
- saxophone harmony 1
- sentimental nostalgic 1
- sere 1
- serene 1
- serious 1
- shakers 1
- sharp sounds 1
- shofar like instrument 1
- simple groove 1
- simple lyrics 1
- slang 1
- sleepy 1
- small pipe harmony 1
- smooth jazz 1
- soft acoustic guitar accompaniment 1
- soft keyboard harmony 1
- soft lilting flute 1
- soft melodious 1
- soft soothing 1
- solemn 1
- somber 1
- song climax 1
- song cover 1
- song fade 1
- song introduction 1
- sonic power 1
- soprano 1
- soulfu 1
- soulfulromantic 1
- sound of horn 1
- sound of picture being clicked 1
- soundtrack 1
- speech like singing 1
- spirited string arrangement 1
- sprechstimme 1
- steady rhythm 1
- sticks 1
- straight drumming 1
- straightforward bass lines 1
- string harmony 1
- string orchestra 1
- stringed instrument 1
- subtle bass 1
- subtle bass line 1
- subtle bass lines 1
- super imposed male voice 1
- swar 1
- sweet 1
- syncopated 1
- syncopated piano accompaniment 1
- syncopated rhythm 1
- synth arrangement 1
- synth arrangements 1
- synth rap 1
- synthesiser 1
- syth pop 1
- tambourine beats 1
- teen pop 1
- teen rap 1
- tempo 1
- tenor 1
- three part harmony 1
- thumping beats 1
- trombone harmony 1
- trumpets 1
- tuba accompaniment 1
- turn table effects 1
- ukelele 1
- unity 1
- unplugged 1
- upbeat ukelele 1
- vibrant 1
- vigorous introduction 1
- viola 1
- vivacious 1
- vivid 1
- vocal emphasis 1
- vocal riff 1
- white christmas 1
- woodwind 1
- worship 1
- youtube video 1
musiccaps_names (array) 77 ✖
- Music 70
- Singing 9
- Soul music 7
- Guitar 6
- Musical instrument 6
- Plucked string instrument 6
- Reggae 5
- Sad music 5
- Song 5
- Tender music 5
- Wedding music 5
- Christian music 4
- Christmas music 4
- Hip hop music 4
- Independent music 4
- Mantra 4
- Rapping 4
- Blues 3
- Country 3
- Folk music 3
- Middle Eastern music 3
- Pop music 3
- Rhythm and blues 3
- Acoustic guitar 2
- Bagpipes 2
- Funk 2
- Gospel music 2
- Happy music 2
- Inside, small room 2
- Mandolin 2
- Music of Asia 2
- New-age music 2
- Rock music 2
- Ukulele 2
- Wind instrument, woodwind instrument 2
- /m/05zppz 1
- /t/dd00003 1
- /t/dd00004 1
- Accordion 1
- Afrobeat 1
- Bluegrass 1
- Bowed string instrument 1
- Brass instrument 1
- Carnatic music 1
- Cello 1
- Chant 1
- Choir 1
- Crowd 1
- Double bass 1
- Echo 1
- Electric piano 1
- Electronic tuner 1
- Exciting music 1
- Flamenco 1
- French horn 1
- Grunge 1
- Heart murmur 1
- Jingle (music) 1
- Keyboard (musical) 1
- Music of Africa 1
- Music of Bollywood 1
- Opera 1
- Piano 1
- Ping 1
- Psychedelic rock 1
- Punk rock 1
- Rattle 1
- Roll 1
- Speech 1
- Strum 1
- Theremin 1
- Tick 1
- Traditional music 1
- Violin, fiddle 1
- Vocal music 1
- Yip 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;