musiccaps_details (view)
41 rows where musiccaps_aspects contains "poignant"
This data as json
musiccaps_aspects (array) 436 ✖
- poignant · 41 ✖
- emotional 29
- slow tempo 23
- instrumental music 15
- melancholic 15
- medium tempo 13
- sad 12
- mellow 11
- sentimental 10
- pensive 9
- instrumental 8
- keyboard accompaniment 7
- movie soundtrack 7
- passionate 7
- piano accompaniment 7
- poor audio quality 7
- romantic 7
- soft 7
- keyboard harmony 6
- male singer 6
- documentary soundtrack 5
- love song 5
- spirited 5
- strong bass line 5
- acoustic guitar 4
- folk music 4
- inspiring 4
- melodic 4
- motivational 4
- no percussions 4
- reflective 4
- violin harmony 4
- western classical music 4
- wistful 4
- groovy 3
- groovy bass line 3
- guitar accompaniment 3
- heart break 3
- home video 3
- inspirational 3
- live performance 3
- lonely 3
- male vocalist 3
- sombre 3
- steady drumming rhythm 3
- string section harmony 3
- ambient room noises 2
- arabic music 2
- arabic percussions 2
- bad audio quality 2
- blues 2
- cello 2
- christian music 2
- conductor 2
- depressed 2
- desert sands 2
- dreamy 2
- dulcet 2
- echoes 2
- electric guitar lead 2
- electric guitar melody 2
- ethereal 2
- gospel music 2
- groovy rhythm 2
- harp accompaniment 2
- heartfelt 2
- home music video 2
- lilting music 2
- meditational 2
- meditative 2
- melancholy 2
- music video 2
- no percussion instruments 2
- nostalgia 2
- nostalgic 2
- philharmonic orchestra 2
- piano playing 2
- piano solo 2
- pizzicato 2
- pop rock 2
- relaxing 2
- smooth jazz 2
- soloist 2
- soothing 2
- story telling 2
- stringed instruments 2
- suspense 2
- together forever 2
- traditional music 2
- vocalisation 2
- youthful 2
- a warrior’s end 1
- aboriginal instruments 1
- aboriginal music 1
- abstract 1
- acoustic guitar accompaniment 1
- acoustic guitar harmony 1
- acoustic music 1
- acoustic song 1
- adventurous 1
- alap 1
- alternative rock 1
- amateur music production 1
- amateur player 1
- ambient 1
- ambient piano 1
- ambient sounds of nature 1
- amplified organ 1
- ancient 1
- applied guitar 1
- arabian nights 1
- arabic dance music 1
- arabic drums 1
- art music 1
- atmospheric 1
- auto harp 1
- auto tuned vocals 1
- average audio quality 1
- bass solo 1
- beautiful 1
- beautiful and relaxing 1
- beauty 1
- beauty of life 1
- bedouin tribes 1
- birds chirping 1
- bitter 1
- blues-rock 1
- blues-rockvigorous electric guitar 1
- boomy bass lines 1
- bowing technique 1
- breakup 1
- breakup song 1
- breathing technique 1
- breeze 1
- calming 1
- camels 1
- captivating 1
- cellist 1
- centuries old music 1
- changing tones 1
- chanting 1
- charming 1
- cheerful 1
- chimes 1
- chinese stringed instrument 1
- christian contemporary music 1
- christian gospel music 1
- christian pop 1
- christian praise and worship 1
- christian rock 1
- christian song 1
- christian worship song 1
- church 1
- church music 1
- classic composers 1
- classic rock 1
- classic rock music 1
- classic romance 1
- classical music 1
- classical music influences 1
- classical vocalist 1
- clear 1
- colourful 1
- comforting 1
- composers 1
- contemplative 1
- cool melody 1
- cultural heritage music 1
- dance club 1
- dance like 1
- dance mix 1
- dance music 1
- deep 1
- deep breaths 1
- defeated 1
- delay effects 1
- delicate 1
- desert people 1
- devotional 1
- didgeridoo 1
- didgeridoo solo 1
- discomforting effect 1
- discotheque 1
- dissonant tambourine beats 1
- dissonant tones 1
- distortion guitars 1
- distortion tones 1
- dream pop 1
- driving song 1
- droning keyboard harmony 1
- drum brushes percussions 1
- drum machine 1
- drum roll 1
- dynamics 1
- eerie 1
- effects pedal 1
- electric guitar 1
- electric guitar rhythm 1
- energetic 1
- energetic drumming 1
- enigmatic 1
- entertaining 1
- euphonious 1
- euro pop 1
- experimental 1
- exquisite 1
- faint vocals 1
- female singer 1
- female singing 1
- female vocalisation 1
- female vocalist 1
- fight to the end 1
- flute countermelody 1
- flute playing 1
- folk dancing 1
- folk instrumental music 1
- folk rock 1
- folk singers 1
- foreign language 1
- forever classics 1
- fretboard sounds 1
- fusion music 1
- geek rock 1
- gentle notes 1
- gentle wind 1
- gets adventure 1
- gratitude 1
- great adventure 1
- grief 1
- grim 1
- groovy music 1
- groovy solo 1
- guitar echo pedal 1
- guitar effects module demonstration 1
- guitar harmony 1
- hardship 1
- harp 1
- harsh desert sun 1
- haunting 1
- haunting harmony 1
- heart rending 1
- high gain 1
- high gain tones 1
- high pitched singing 1
- hip hop hits 1
- hip hop music 1
- hissing noise 1
- hissing tones 1
- historical 1
- home music video 1
- home recording 1
- homemjsic video 1
- hopeful 1
- horror film soundtrack 1
- humility 1
- hurt 1
- husky voice 1
- hustlers life 1
- in love 1
- indian bowed string instrument 1
- indian music influences 1
- indie music 1
- intense 1
- intense bass lines 1
- intense drumming 1
- introspective 1
- japanese folk music 1
- jazz band 1
- jazz music 1
- lilting melody 1
- live music 1
- loneliness 1
- lonely sad 1
- longing 1
- lost 1
- love music 1
- lucid vocals 1
- lullaby 1
- lyrical singing 1
- male rapper 1
- me 1
- medium 1
- melancholic melody 1
- melancholic music 1
- melancholic piano 1
- mellifluous 1
- melodic piano 1
- melodic violin harmony 1
- melodious 1
- memdium tempo 1
- middle eastern influences 1
- minimalist 1
- mode music video 1
- money problems 1
- moody blues 1
- moog bass 1
- mother earth 1
- movie theme music 1
- muffled guitar quality 1
- music demo 1
- music interlude 1
- musical trio 1
- myriad of emotions 1
- nature 1
- nature documentary 1
- never give up 1
- never say die 1
- new age 1
- new hope 1
- noisy 1
- offbeat 1
- ominous 1
- opera classics 1
- opera hall 1
- opera legend 1
- opera singer 1
- organ accompaniment 1
- out of tune 1
- overuse of effect 1
- peaceful 1
- people dancing 1
- people dancing around a fire 1
- percussive bass line 1
- percussive blowing patterns 1
- percussive drums 1
- piano playing chords 1
- piano playing lead 1
- playful 1
- ponderous 1
- pop 1
- positive 1
- prayerful 1
- purposeful 1
- quiet audience 1
- quirky 1
- r&b 1
- raaga 1
- raga 1
- raspy notes 1
- regret 1
- regretful 1
- relaxing playlist 1
- repentance 1
- resonator 1
- retro classic hits 1
- reverence 1
- rich ancestry 1
- rich culture 1
- rock 1
- rock music 1
- room acoustics 1
- russian hit songs 1
- russian rap music 1
- sadness 1
- sarangi 1
- science experiment 1
- serene 1
- shaker song 1
- shakers 1
- sharp piano lead 1
- simple 1
- simple harmony 1
- simple melody 1
- slick drumming 1
- slick drumming rhythm 1
- soft rock 1
- solemn 1
- solo instrument 1
- song cover 1
- song introduction 1
- sonorous tones 1
- sorrowful 1
- soul 1
- sound searching 1
- steady bass lines 1
- steady bassline 1
- steady drumming 1
- steady percussive rhythm 1
- steady rhythm 1
- straightforward drumming 1
- string bass line 1
- string instrument 1
- string section singing 1
- string synth accompaniment 1
- stringed instrument harmony 1
- strings plucked 1
- strong low notes 1
- strong rock drumming 1
- subdued harmony 1
- subtle bass 1
- subtle percussion rhythm 1
- swar 1
- sweet 1
- syncopated harmony 1
- synth arrangement 1
- synth countermelody 1
- synth horns playing 1
- synthesiser arrangement 1
- tambourine 1
- technique 1
- tempo 1
- the hood 1
- traditional dance music 1
- traditional japanese music 1
- traditional muscle 1
- trance like 1
- tremolo strings 1
- trendy 1
- triangle percussions 1
- tv show 1
- ukulele 1
- ukulele player 1
- underground music 1
- unsettling 1
- vibrato 1
- vigorous electric guitar riff 1
- vintage opera 1
- violin 1
- violin music 1
- violin playing 1
- violin playing emotionally 1
- violin solo 1
- violinist 1
- violins strings plucked 1
- virtuoso 1
- vocalist chanting 1
- warm 1
- waves 1
- western classic music legends 1
- western classical masterpieces 1
- wind instrument 1
- winter 1
- wonders of nature 1
- wondrous journey 1
- worship 1
- youtube music video 1
musiccaps_names (array) 58 ✖
- Music 37
- Sad music 7
- Tender music 5
- Background music 3
- Bowed string instrument 3
- Guitar 3
- Musical instrument 3
- New-age music 3
- Strum 3
- Acoustic guitar 2
- Ambient music 2
- Blues 2
- Cello 2
- Didgeridoo 2
- Double bass 2
- Folk music 2
- Mandolin 2
- Plucked string instrument 2
- Rock music 2
- Theremin 2
- Violin, fiddle 2
- Banjo 1
- Bass guitar 1
- Carnatic music 1
- Christmas music 1
- Classical music 1
- Electric guitar 1
- Electronic tuner 1
- Exciting music 1
- Grunge 1
- Happy music 1
- Harmonic 1
- Heavy metal 1
- Hip hop music 1
- Independent music 1
- Inside, small room 1
- Jingle (music) 1
- Mantra 1
- Music of Africa 1
- Opera 1
- Pizzicato 1
- Progressive rock 1
- Psychedelic rock 1
- Punk rock 1
- Rapping 1
- Reverberation 1
- Rhythm and blues 1
- Scary music 1
- Singing 1
- Song 1
- Soul music 1
- Speech 1
- Steel guitar, slide guitar 1
- Tapping (guitar technique) 1
- Theme music 1
- Vocal music 1
- Wedding music 1
- Zither 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;