musiccaps_details (view)
24 rows where musiccaps_aspects contains "violin" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 110 ✖
- violin · 24 ✖
- instrumental 11
- live performance 7
- cello 6
- classical music 6
- orchestra 6
- piano 6
- banjo 4
- folk 4
- male vocal 4
- percussion 4
- vibrant 4
- acoustic guitar 3
- dramatic 3
- emotional 3
- gentle 3
- lively 3
- movie music 3
- no singer 3
- acoustic drums 2
- amateur recording 2
- american 2
- arabic 2
- bass guitar 2
- bluegrass 2
- eastern sounding 2
- female vocal 2
- festive 2
- flute 2
- melancholic 2
- mellow 2
- oud 2
- playful 2
- profound 2
- qanun 2
- repeated theme 2
- sentimental 2
- strings 2
- viola 2
- accordion 1
- acoustic 1
- action 1
- andean harp 1
- baroque 1
- bizarre 1
- brazilian portuguese 1
- chamber music 1
- cheerful 1
- christian 1
- cimbalom 1
- claps 1
- contemporary classical 1
- contrabass 1
- country music 1
- cozy 1
- dance 1
- darbuka 1
- easygoing 1
- eccentric 1
- eerie 1
- electric guitar 1
- electronic music 1
- epic 1
- gloomy 1
- gospel 1
- hard-hitting 1
- harp 1
- heart-touching 1
- high-pitch singing 1
- hopeful 1
- huayno music 1
- impressionist 1
- intense 1
- intriguing 1
- irish 1
- jovial 1
- khaliji music 1
- marching band 1
- melodic 1
- melodic singing 1
- moroccan 1
- mysterious 1
- ney 1
- optimistic 1
- oriental 1
- peruvian folk music 1
- peruvian harp 1
- preach-like singing 1
- religious 1
- religious music 1
- resolution 1
- riq 1
- rising and falling pattern 1
- romanian folk music 1
- romantic 1
- simple tune 1
- slightly poor quality 1
- snare drums 1
- soap opera soundtrack 1
- soprano 1
- sound effects 1
- spiritual 1
- string quartet 1
- suspense 1
- suspenseful 1
- tambourine 1
- trumpets 1
- tuba 1
- unsettling 1
- upright bass 1
musiccaps_names (array) 39 ✖
- Music 15
- Bowed string instrument 10
- Violin, fiddle 9
- Musical instrument 5
- Bluegrass 4
- Traditional music 4
- Cello 3
- Classical music 3
- Double bass 3
- Harp 3
- Pizzicato 3
- Banjo 2
- Middle Eastern music 2
- Plucked string instrument 2
- Song 2
- Accordion 1
- Ambient music 1
- Background music 1
- Country 1
- Drum 1
- Electronic music 1
- Flamenco 1
- Gospel music 1
- Guitar 1
- Inside, small room 1
- Keyboard (musical) 1
- Music of Africa 1
- Opera 1
- Orchestra 1
- Percussion 1
- Piano 1
- Rock and roll 1
- Sad music 1
- Scary music 1
- Ska 1
- Tabla 1
- Theme music 1
- Theremin 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;