musiccaps_details (view)
10 rows where musiccaps_aspects contains "festive" and musiccaps_author = 7
This data as json
musiccaps_aspects (array) 142 ✖
- festive · 10 ✖
- happy 7
- cheerful 5
- fast tempo 5
- celebratory 4
- instrumental 4
- medium tempo 4
- celebration 3
- enthusiastic 3
- spirited 3
- folk music 2
- hand percussions 2
- inferior audio quality 2
- joyful 2
- live performance 2
- male vocalists 2
- punjabi song 2
- regional music 2
- shakers 2
- simple 2
- tambourine beats 2
- vivacious 2
- world music 2
- youthful 2
- acoustic guitar 1
- afro beats 1
- amateur recording 1
- ambient noises 1
- ambient outdoor sounds 1
- announcement 1
- authoritative 1
- auto harp 1
- banjo 1
- barrel drum 1
- bells 1
- bluegrass 1
- bouncy 1
- bugle like sound 1
- captivating 1
- cheering 1
- children’s songs 1
- christmas carols 1
- christmas music 1
- christmas popular song 1
- clapping 1
- colourful 1
- concert 1
- country folk music 1
- country music 1
- dhol 1
- dholak beat 1
- dholaki 1
- distorted music 1
- duet 1
- ektara 1
- ektare 1
- energetic 1
- exciting 1
- experiments 1
- female backup 1
- female vocalisation 1
- female vocalist 1
- folk dance 1
- foreign language 1
- funny 1
- ghungaroos 1
- gig 1
- guiro 1
- guiro accompaniment 1
- hand drums 1
- happy occasion 1
- high notes 1
- high-spirited 1
- horn blowing 1
- important 1
- indian festivities 1
- indian folk music 1
- indian folk song 1
- indian music 1
- indian song 1
- infectious 1
- jewish horn 1
- jingle bells 1
- jolly 1
- keyboard harmony 1
- latin dance music 1
- latin music 1
- latin regional music 1
- laughter 1
- live music 1
- lively 1
- lively acordion 1
- lively singing 1
- loud 1
- male singer 1
- male vocal 1
- mandolin 1
- merry 1
- metallic sounds 1
- metalophone 1
- minimal instruments 1
- minimalist 1
- nigerian music 1
- oud rhythm 1
- people talking 1
- peppy 1
- percussive instrument 1
- playful 1
- punjabi folk song 1
- punjabi wedding song 1
- ram’s horn 1
- regional folk 1
- religious significance 1
- resounding 1
- reverberating 1
- ritual music 1
- sapp 1
- scraper instrument 1
- shaker 1
- sharp sounds 1
- simple joys 1
- sound of tapping 1
- sound of water in background 1
- spirited congas 1
- spirited drumming 1
- static 1
- string instrument 1
- stringed instrument harmony 1
- sunny 1
- synthesiser arrangements 1
- tano indian festivities 1
- tanpura 1
- upbeat 1
- vibrant 1
- vigorous banjo 1
- vocal battle 1
- vocal jugalbandi 1
- vocalisation 1
- wake up call 1
- wedding rituals 1
- xylophone 1
- xylophonist 1
musiccaps_names (array) 17 ✖
- Music 8
- Music of Africa 3
- Musical instrument 2
- Rattle (instrument) 2
- Wedding music 2
- Accordion 1
- Afrobeat 1
- Banjo 1
- Bell 1
- Bluegrass 1
- Brass instrument 1
- Country 1
- Folk music 1
- Maraca 1
- Rock and roll 1
- Synthetic singing 1
- Trumpet 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;