musiccaps_details (view)
24 rows where musiccaps_aspects contains "acoustic guitar" and musiccaps_aspects contains "mellow"
This data as json
musiccaps_aspects (array) 173 ✖
- acoustic guitar · 24 ✖
- mellow · 24 ✖
- slow tempo 12
- soft 11
- emotional 9
- sentimental 9
- male vocal 7
- melodic singing 6
- acoustic drums 5
- bass guitar 5
- dulcet 5
- easygoing 4
- instrumental 4
- male singer 4
- medium tempo 4
- melancholic 4
- pop 4
- romantic 4
- cello 3
- country hits 3
- country pop 3
- dreamy 3
- electric guitar 3
- female vocal 3
- gentle 3
- keyboard harmony 3
- mandolin 3
- mellifluous 3
- melodic 3
- nostalgia 3
- poignant 3
- simple melody 3
- simple tune 3
- steady drumming 3
- story telling 3
- acoustic 2
- alternative rock 2
- auto harp 2
- banjo 2
- calming 2
- country music 2
- cover 2
- fiddle 2
- folk music 2
- gentle playing 2
- minimalist 2
- piano 2
- pop music 2
- regional pop 2
- resonator 2
- serene 2
- string harmony 2
- violin harmony 2
- violin symphony 2
- acoustic bass 1
- acoustic folk 1
- amateur recording 1
- amateur singer 1
- ambient synth 1
- american 1
- atmospheric synthesiser 1
- backup harmony 1
- ballad 1
- baritone 1
- beautiful 1
- bluegrass 1
- boomy bass lines 1
- busking 1
- calm 1
- captivating 1
- celtic 1
- chant 1
- charming 1
- children’s song 1
- chimes 1
- christian 1
- christmas carol 1
- christmas time 1
- chrost 1
- colourful 1
- country folk song 1
- country folk songs 1
- country song 1
- cozy 1
- dobro 1
- downtempo 1
- duet 1
- enchanting 1
- euphonious 1
- female singer 1
- female singing 1
- female vocalisation 1
- female vocalist 1
- female voice 1
- flute like instrument 1
- flute melody 1
- folk 1
- folk lyrics 1
- folk pop 1
- foreign language 1
- french carols 1
- french song 1
- gospel 1
- harmonic singing 1
- heart-touching 1
- hillbilly music 1
- home recording 1
- home video 1
- husky voice 1
- idyllic 1
- indie 1
- intuitive folk 1
- karaoke 1
- keyboard accompaniment 1
- kindergarten song 1
- korean indie rock 1
- lonely 1
- lonely sad 1
- lullaby 1
- malaysian 1
- male vocalist 1
- meditation 1
- melancholy 1
- melodious 1
- melodious harmony 1
- muffled guitar quality 1
- neo-folk 1
- no percussions 1
- no singer 1
- nostalgic 1
- nursery rhyme 1
- old-time country rock 1
- optimistic 1
- pensive 1
- people talking in background 1
- performance 1
- pleasant 1
- poor quality 1
- pure 1
- recorder 1
- regional music 1
- relaxing 1
- religious 1
- resonator guitar 1
- reverb 1
- rock music 1
- room acoustics 1
- sad 1
- sentimental nostalgic 1
- shakers 1
- simplicity 1
- soft piano 1
- soothing 1
- soulful 1
- story-telling mood 1
- straight bass lines 1
- string instruments 1
- string orchestra 1
- strings 1
- tambourine 1
- tender 1
- ukelele 1
- viola 1
- violin 1
- vocal backup 1
- vocal emphasis 1
- vocalisation 1
- warm 1
- wedding music 1
- whistling 1
- white christmas 1
- wind instrument 1
- xylophone 1
musiccaps_names (array) 28 ✖
- Music 22
- Singing 4
- Independent music 3
- Ukulele 3
- Wedding music 3
- Acoustic guitar 2
- Christian music 2
- Flamenco 2
- Mandolin 2
- Song 2
- A capella 1
- Blues 1
- Chant 1
- Christmas music 1
- Country 1
- Echo 1
- Flute 1
- Folk music 1
- Happy music 1
- Mantra 1
- New-age music 1
- Plucked string instrument 1
- Pop music 1
- Sad music 1
- Steel guitar, slide guitar 1
- Strum 1
- Vocal music 1
- Wind instrument, woodwind instrument 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;