musiccaps_details (view)
54 rows where musiccaps_aspects contains "accordion"
This data as json
musiccaps_aspects (array) 220 ✖
- accordion · 54 ✖
- instrumental 14
- amateur recording 12
- acoustic drums 10
- acoustic guitar 10
- upbeat 9
- bass 7
- e-bass 7
- percussion 7
- bass guitar 6
- folkmusic 6
- medium to uptempo 6
- no voices 6
- upright bass 6
- uptempo 6
- violin 6
- cheerful 5
- flute 5
- folk song 5
- live performance 5
- male voice 5
- slow tempo 5
- lively 4
- low quality audio 4
- medium tempo 4
- moderate tempo 4
- vibrant 4
- dance 3
- e-guitar 3
- happy mood 3
- joyful 3
- tambourine 3
- acoustic piano 2
- cheerful atmosphere 2
- clarinet 2
- comedic 2
- contrabass 2
- fast tempo 2
- female voice singing 2
- fiddle 2
- folk dance 2
- folk music 2
- fun 2
- good mood 2
- guitar 2
- hindi 2
- jingle 2
- live recording 2
- male voice singing 2
- no singer 2
- no voice 2
- piano 2
- romanian folk music 2
- shakers 2
- shouting 2
- yodel/folkmusic 2
- yodeling 2
- acoustic drums/percussion's 1
- acoustic guitars 1
- acoustic sounding drums 1
- advertisement 1
- alpine folk music 1
- american 1
- arabic music 1
- background cheering 1
- background cheering and clapping 1
- bagpipes 1
- balkan music 1
- bass drum 1
- bed creaking 1
- belly dance 1
- bowed strings 1
- call and response 1
- celebration 1
- cello 1
- children's song 1
- chill 1
- choir 1
- cimbalom 1
- clean electric guitar 1
- coffee shop music 1
- country music vibes 1
- country/folk 1
- croaking sound 1
- crowd cheering 1
- crowd clapping 1
- deeper voice singing 1
- distortion 1
- double base 1
- double bass 1
- dreamy 1
- drum kit 1
- drums 1
- eastern european 1
- easy listening 1
- electric guitar 1
- electronic drums 1
- emotional song 1
- energetic 1
- erotic 1
- eurodance 1
- exciting 1
- female choir 1
- female singing quarter 1
- female vocal 1
- female voice crying 1
- female voices singing 1
- flamenco style guitar playing 1
- folk inspired 1
- folksong 1
- foreign language 1
- french inspired 1
- gentle 1
- glass smashing sound 1
- goofy tune 1
- gospel/folk 1
- guitar strumming 1
- hammered dulcimer 1
- happy 1
- harmonies 1
- higher pitch 1
- higher register 1
- higher register yodeling 1
- hindi/pop 1
- intricate percussion 1
- irish traditional music 1
- jazz 1
- jazz ballad 1
- jazz guitar 1
- joy 1
- keyboard 1
- latin dance 1
- latin inspired 1
- latin music 1
- latin percussion 1
- laughter 1
- low quality recording 1
- male 1
- male and female voices 1
- male choir 1
- male deep voice singing 1
- male ethnic vocals 1
- male mid range voice singing 1
- male singer 1
- male sounds 1
- male vocal 1
- male voice high register singing 1
- male voice samples 1
- male voice yodeling 1
- male voices yodeling 1
- marimba 1
- melancholy 1
- mexican folk music 1
- middle eastern 1
- musical/opera 1
- no drums 1
- no other instruments 1
- no percussion 1
- oompah 1
- orchestra 1
- passionate male vocalist 1
- pastoral 1
- percussion played on contrabass 1
- playful 1
- polka 1
- poor audio quality 1
- poor quality recording 1
- pop song 1
- popmusic 1
- positive energy 1
- positive vibe 1
- punching sounds 1
- punjabi film music 1
- quiet recording 1
- quirky sounds 1
- rapid singing 1
- romantic mood 1
- rubab 1
- sad 1
- scottish tenor drum 1
- screaming 1
- seductive 1
- seductive singing 1
- sensual 1
- silly 1
- simple chord progression 1
- simple percussion 1
- single instrument 1
- slow jazz ensemble 1
- solo 1
- somali music 1
- sound effects 1
- south asian music 1
- spanish pop 1
- string instrument 1
- tabla 1
- tablas 1
- tango 1
- timid boy voice 1
- traditional african arabic music 1
- traditional dance 1
- traditional percussion instruments 1
- triangle 1
- trombone 1
- trumpet 1
- tuba 1
- two female vocalists 1
- two male vocalists 1
- uplifting mood 1
- upright/e-bass 1
- vintage european 1
- violin solo 1
- violins 1
- virtual sounds 1
- walking bassline 1
- waltz 1
- western swing 1
- xylophone family instrument 1
- yodeling duet 1
- yodeling/folk 1
musiccaps_names (array) 40 ✖
- Music 34
- Accordion 19
- Musical instrument 7
- Wind instrument, woodwind instrument 6
- Yodeling 6
- Folk music 5
- Music of Latin America 5
- Singing 4
- Traditional music 4
- Bowed string instrument 3
- /t/dd00032 2
- Christian music 2
- Classical music 2
- Flute 2
- Jingle (music) 2
- Percussion 2
- Swing music 2
- Tabla 2
- A capella 1
- Applause 1
- Bagpipes 1
- Blues 1
- Child singing 1
- Christmas music 1
- Crowd 1
- Gospel music 1
- Harp 1
- Middle Eastern music 1
- Music of Africa 1
- Music of Bollywood 1
- Pizzicato 1
- Reggae 1
- Shatter 1
- Ska 1
- Speech 1
- Synthetic singing 1
- Tender music 1
- Thunk 1
- Violin, fiddle 1
- Wedding music 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;