musiccaps_details (view)
15 rows where musiccaps_aspects contains "folk song" and musiccaps_author = 7
This data as json
musiccaps_aspects (array) 184 ✖
- folk song · 15 ✖
- foreign language 9
- regional music 8
- medium tempo 6
- world music 6
- fast tempo 5
- happy 4
- male singer 4
- cheerful 3
- country music 3
- emotional 3
- energetic 3
- enthusiastic 3
- folk music 3
- keyboard harmony 3
- live performance 3
- lively 3
- male vocalist 3
- melodic 3
- people talking 3
- peppy 3
- regional song 3
- soothing 3
- steady drumming 3
- vocal backup 3
- acoustic guitar 2
- amateur recording 2
- ambient sounds 2
- charming 2
- classical 2
- female singer 2
- female vocalist 2
- folk pop 2
- hand percussion 2
- instrumental 2
- lilting 2
- love song 2
- medium fast tempo 2
- mellow 2
- middle eastern music 2
- pop 2
- regional pop 2
- romantic 2
- shakers 2
- simple 2
- slow tempo 2
- spanish song 2
- spirited 2
- steady bass lines 2
- upbeat 2
- accordion harmony 1
- acordion accompaniment 1
- afghan music 1
- afghan song 1
- ambient auditorium sounds 1
- ambient outdoor sounds 1
- animated acoustic guitar rhythm 1
- animated percussions 1
- auto harp 1
- banjo 1
- banjo lead 1
- bells chining 1
- bluegrass 1
- breakup 1
- breakup song 1
- bright 1
- bright violin 1
- buoyant 1
- calm 1
- catchy 1
- celebration 1
- chant like 1
- chanting 1
- cheering 1
- chirpy 1
- clapping 1
- classic 1
- classical music 1
- classical song 1
- conga 1
- country 1
- country pop 1
- country song 1
- dance groove 1
- dance music 1
- despondent 1
- dhol 1
- dobro 1
- droning 1
- dutch 1
- earnest singing 1
- emphatic vocals 1
- emphatic singing 1
- emphatic vocals 1
- engaging 1
- enthusiastic vocals 1
- extemporaneous 1
- female vocals 1
- flute 1
- flute melody 1
- folk 1
- fun 1
- funky bass line 1
- german song 1
- groovy bass line 1
- groovy bass lines 1
- hand percussions 1
- harmonica 1
- haunting melody 1
- high pitched sounds 1
- home recording 1
- home video 1
- hooting 1
- hynoptic 1
- incoherent music 1
- inferior audio quality 1
- lao folk music 1
- laos classical song 1
- laos folk song 1
- laotian classical music 1
- latin music 1
- latin song 1
- lilting melody 1
- live audience 1
- lively mandolin 1
- lively spanish guitar 1
- lively trumpets 1
- lonely 1
- madal 1
- male vocalists 1
- mandolin 1
- march like drumming 1
- meditative 1
- mellifluous 1
- melodious 1
- melodious tune 1
- merry 1
- metallic clicking sound 1
- middle eastern influences 1
- minimalist 1
- mystic vibe 1
- no accompaniment 1
- organ accomapniment 1
- outdoor singing 1
- pandeireta rhythm 1
- party songs 1
- passionate 1
- percussive instruments 1
- perky 1
- piano accompaniment 1
- poor audio quality 1
- pop hits 1
- popular folk music 1
- popular songs 1
- powerful vocals 1
- resonator guitar 1
- rhythmic oud 1
- rustling 1
- sad song 1
- sarangi 1
- sentimental 1
- slick drumming 1
- smal hand drum 1
- small hand cymbals 1
- soft 1
- soulfu 1
- soulful 1
- soulfulromantic 1
- spanish 1
- spanish guitar harmony 1
- steady bass line 1
- straight bass lines 1
- string instrument 1
- stringed instrument 1
- synthesiser arrangement 1
- tabla 1
- tambourine 1
- tambourine used as hand drum 1
- vibrant 1
- violin harmony 1
- vocal emphasis 1
- vocals 1
- xylophone like instrument 1
- youthful 1
musiccaps_names (array) 22 ✖
- Music 14
- Music of Latin America 3
- Flamenco 2
- Folk music 2
- Musical instrument 2
- Rattle (instrument) 2
- Singing 2
- Traditional music 2
- Accordion 1
- Banjo 1
- Bluegrass 1
- Bowed string instrument 1
- Christian music 1
- Christmas music 1
- Happy music 1
- Jingle (music) 1
- Mantra 1
- Music of Africa 1
- Percussion 1
- Ska 1
- Tender music 1
- Yodeling 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;