musiccaps_details (view)
36 rows where musiccaps_aspects contains "sentimental" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 135 ✖
- sentimental · 36 ✖
- male vocal 17
- bass guitar 15
- melodic singing 15
- piano 13
- acoustic drums 11
- acoustic guitar 10
- female vocal 9
- slow tempo 8
- electric guitar 7
- keyboard 7
- melancholic 7
- electronic drums 6
- live performance 6
- pop music 5
- strings 5
- easygoing 4
- flute 4
- vibrant 4
- ballad 3
- emotional 3
- heart-touching 3
- medium tempo 3
- mellow 3
- orchestra 3
- r&b 3
- romantic 3
- simple tune 3
- afropop 2
- classical music 2
- dramatic 2
- dreamy 2
- eastern sounding 2
- female voice 2
- gentle 2
- gentle playing 2
- gentle singing 2
- groovy 2
- instrumental 2
- longing 2
- oud 2
- profound 2
- sitar 2
- violin 2
- acoustic 1
- acoustic performance 1
- afro percussion 1
- alternative 1
- alternative rock 1
- americana 1
- amp 1
- arabic 1
- armenian 1
- autotune singing 1
- banjo 1
- carnatic classical 1
- catchy 1
- catchy tune 1
- chimes 1
- choir 1
- christian music 1
- clarinet 1
- clicks 1
- country 1
- country music 1
- cover 1
- crying 1
- drums 1
- electronic percussion 1
- female back vocal 1
- female choir 1
- fiddle 1
- folk rock 1
- french horn 1
- german romantic music 1
- glam metal 1
- gospel 1
- grand piano 1
- gravelly voice 1
- hard-hitting 1
- heavy metal 1
- hindi film music 1
- hmong pop 1
- indian pop music 1
- indie 1
- indie folk music 1
- instrument review 1
- khaliji music 1
- malaysian 1
- male back vocals 1
- male voice 1
- medium-to-high pitch 1
- medium-to-high pitch singing 1
- melancholic singing 1
- melodic pad 1
- minor key 1
- movie music 1
- neo-soul 1
- no singer 1
- normal tempo 1
- orchestral rock 1
- organ 1
- percussion 1
- piano sound 1
- poor quality 1
- pop rock 1
- progressive rock 1
- religious 1
- repeated theme 1
- reverb 1
- rock 1
- rock music 1
- rock opera 1
- romanian pop music 1
- shouting-like singing 1
- showcase 1
- simple 1
- slightly slow tempo 1
- soap opera theme 1
- soul 1
- spiritual 1
- steady tempo 1
- strings section 1
- strong bass 1
- synth sound 1
- tabla 1
- thai 1
- trombone 1
- tunisian folk music 1
- urban 1
- valentines 1
- veena-like singing 1
- vietnamese ballad 1
- vocal performance 1
- wedding 1
musiccaps_names (array) 48 ✖
- Music 26
- Singing 6
- Christian music 3
- Keyboard (musical) 3
- Music of Asia 3
- Bowed string instrument 2
- Brass instrument 2
- Country 2
- Electric piano 2
- Happy music 2
- Jazz 2
- Musical instrument 2
- Piano 2
- Plucked string instrument 2
- Sad music 2
- Song 2
- Soul music 2
- Violin, fiddle 2
- Wedding music 2
- /t/dd00004 1
- Acoustic guitar 1
- Bass guitar 1
- Bluegrass 1
- Carnatic music 1
- Cello 1
- Chant 1
- Classical music 1
- Double bass 1
- Exciting music 1
- Flamenco 1
- Folk music 1
- French horn 1
- Guitar 1
- Harpsichord 1
- Independent music 1
- Lullaby 1
- Middle Eastern music 1
- Music of Africa 1
- Pop music 1
- Radio 1
- Reverberation 1
- Rhythm and blues 1
- Rock and roll 1
- Roll 1
- Soundtrack music 1
- Traditional music 1
- Trumpet 1
- Vocal music 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;