musiccaps_details (view)
16 rows where musiccaps_aspects contains "viola" and musiccaps_author = 7
This data as json
musiccaps_aspects (array) 209 ✖
- viola · 16 ✖
- cello 14
- instrumental 11
- orchestra 8
- fast tempo 7
- violin symphony 7
- enthralling 6
- intense 6
- slow tempo 6
- brass band 5
- captivating 5
- symphony 5
- engaging 4
- violins 4
- celestial 3
- cheerful 3
- compelling 3
- ethereal 3
- grim 3
- orchestral music 3
- piano accompaniment 3
- spirited 3
- violin 3
- violin harmony 3
- baroque 2
- burgeoning 2
- classical 2
- classical music 2
- concert 2
- dangerous 2
- delicate 2
- dreamy 2
- enchanting 2
- enthusiastic drumming 2
- exquisite 2
- falsetto 2
- female singer 2
- fiddle 2
- harpsichord 2
- high notes 2
- live performance 2
- melancholic 2
- mellifluous 2
- mesmerising 2
- playful 2
- powerful vocals 2
- rich 2
- sinister 2
- static 2
- string instruments 2
- trumpets 2
- vibrant 2
- vocalisation 2
- western classical 2
- acoustic drums 1
- acoustic guitar 1
- allegro 1
- allergissimo 1
- ambient outdoor sounds 1
- amplified violin 1
- angelic 1
- animated 1
- animated voices 1
- anxious 1
- auto harp 1
- background 1
- bass drum 1
- bell ringing 1
- bleak 1
- bow string instrument 1
- bow stringed instrument 1
- bow stringed instruments 1
- bowed string instruments 1
- brass instrument 1
- brass instruments 1
- breezy 1
- bright 1
- bright trumpets 1
- celestial music 1
- chamber music 1
- chaotic 1
- cheerful melody 1
- child playing 1
- child’s voice 1
- choral harmonybright trumpet harmony 1
- church bell 1
- clarinet 1
- classic music 1
- commanding 1
- complex notes 1
- contrasting harmonies 1
- controlled singing 1
- country folk song 1
- country hits 1
- country movie 1
- country music 1
- country pop 1
- cowboy 1
- dark 1
- deep bass 1
- deep sound 1
- delightful 1
- descan 1
- descant 1
- dismal 1
- dreary 1
- droning 1
- dulcet 1
- eerie 1
- electric guitar 1
- electrifying 1
- elegant 1
- eloquent piano accompaniment 1
- emotional 1
- energetic 1
- english dance 1
- enigmatic 1
- enigmatic flutes 1
- euphonious 1
- exciting 1
- extravagant 1
- female vocalist 1
- flute 1
- frightening 1
- fun 1
- gloomy 1
- gripping 1
- happy 1
- heavy 1
- horror movie soundtrack 1
- instrumental ensemble 1
- interlude in song 1
- italian classical 1
- italian composition 1
- joyful 1
- keyboard harmony 1
- lilting 1
- live audience 1
- lively 1
- lively piano 1
- lively viloin 1
- lively violin 1
- loosely structured music 1
- low pitch 1
- male singer 1
- medium tempo 1
- melancholy 1
- mellow 1
- melodic 1
- melodic violin 1
- melodious violin symphony 1
- merry 1
- nostalgic 1
- opera singer 1
- paino accompaniment 1
- pensive 1
- people talking 1
- percussions 1
- performance 1
- philharmonic 1
- pleasant 1
- poor audio quality 1
- pop 1
- pulsating 1
- rapid changes in pitch 1
- regional pop 1
- restless 1
- ritardando 1
- romantic 1
- sentimental 1
- sentimental nostalgic 1
- serious 1
- snare drums 1
- soft 1
- sonic treat 1
- soothing 1
- soprano 1
- sound of galloping horse 1
- spectacular 1
- spike chilling 1
- spooky 1
- story telling 1
- string harmony 1
- string orchestra 1
- superimposed vocals 1
- suspenseful 1
- symphony orchestra 1
- synced harmonies 1
- syncopated harmony 1
- synthesiser articulation 1
- sythesiser arrangements 1
- tambourine 1
- triumphant 1
- triumphant music 1
- trombone 1
- trumpet 1
- trumpet flourish 1
- upbeat 1
- vibrant vocals 1
- vibrations 1
- violin plucking rhythm 1
- violin solo 1
- vivacious cello 1
- vocalisation in background 1
- whistling 1
- wind instrument 1
- woman speaking 1
- yodelling 1
- youthful 1
musiccaps_names (array) 23 ✖
- Music 12
- Scary music 3
- Bowed string instrument 2
- Cello 2
- Double bass 2
- Opera 2
- Orchestra 2
- Swing music 2
- Background music 1
- Classical music 1
- Harpsichord 1
- Jazz 1
- Keyboard (musical) 1
- Pizzicato 1
- Singing 1
- Soundtrack music 1
- Speech 1
- Tender music 1
- Theme music 1
- Timpani 1
- Violin, fiddle 1
- Wedding 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;