musiccaps_details (view)
8 rows where musiccaps_aspects contains "santa claus" sorted by youtube_link
This data as json
musiccaps_aspects (array) 130 ✖
- santa claus · 8 ✖
- christmas carols 7
- medium tempo 6
- cheerful 4
- steady drumming rhythm 4
- christmas presents 3
- emotional 3
- exciting 3
- instrumental music 3
- movie soundtrack 3
- philharmonic orchestra 3
- snow 3
- winter wonderland 3
- carols 2
- christmas song 2
- christmas time 2
- groovy 2
- happy 2
- male singer 2
- passionate 2
- peppy 2
- poor audio quality 2
- adventurous 1
- animated 1
- animated piano 1
- babies sleeping 1
- backup singers 1
- bad audio quality 1
- bass clarinet 1
- bells 1
- bells harmony 1
- bells percussions 1
- bells playing 1
- brass instruments playing triumphantly 1
- calming 1
- celebration 1
- children dancing 1
- children’s favourite christmas song 1
- children’s song 1
- choral harmony 1
- christmas 1
- christmas ade nature 1
- christmas adventure 1
- christmas cheer 1
- christmas classics 1
- christmas night 1
- christmas songs 1
- christmas tree 1
- clarinet playing 1
- conductor 1
- couples dancing 1
- dancing 1
- devotional 1
- e emotional 1
- eerie 1
- elves 1
- fast tempo 1
- female singers 1
- festive 1
- festive cheer 1
- festivities 1
- fun 1
- gifts time 1
- granular sounds 1
- groovy bass line 1
- guitar accompaniment 1
- guitar rhythm 1
- happiness 1
- hissing noise 1
- holiday fun 1
- holidays 1
- horn section 1
- inspiring 1
- instrumental 1
- jingle bells 1
- joyful 1
- keybiard harmony 1
- keyboard accompaniment 1
- live audience 1
- live performance 1
- lullaby 1
- marching rhythm 1
- medium fast tempo 1
- melancholic 1
- merry 1
- miracles 1
- mirth 1
- motivational 1
- mysterious 1
- nostalgia 1
- opera hall 1
- orchestra playing 1
- percussive bass line 1
- perky 1
- piano accompaniment 1
- piano melody 1
- poor quality audio 1
- pop hits 1
- pop song 1
- presents 1
- reggae music influence 1
- reindeer 1
- reindeers 1
- relaxing 1
- rhythmic acoustic guitar 1
- saxophone playing medley 1
- snowfall 1
- soaring harmonies 1
- soaring vocals 1
- solo violin 1
- steady bass line 1
- steady drumming 1
- string section 1
- string section harmony 1
- strong bas slime 1
- strong bass line 1
- suspense 1
- tambourine beats 1
- tempo 1
- the 1
- theremin 1
- theremin player 1
- trumelts playing 1
- trumpets playing 1
- vivacious 1
- vocal backup 1
- vocal harmony 1
- war 1
- warmth 1
- wintertime 1
musiccaps_names (array) 10 ✖
- Music 8
- Christian music 3
- Christmas music 3
- Song 2
- Choir 1
- Jazz 1
- Jingle (music) 1
- Singing 1
- Theme music 1
- Theremin 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;