musiccaps_details (view)
6 rows where musiccaps_aspects contains "accordion" and musiccaps_aspects contains "upright bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- accordion · 6 ✖
- upright bass · 6 ✖
- acoustic guitar 4
- fiddle 2
- instrumental 2
- live performance 2
- percussion 2
- amateur recording 1
- chill 1
- coffee shop music 1
- crowd clapping 1
- fast tempo 1
- folk music 1
- gentle 1
- good mood 1
- guitar strumming 1
- jazz 1
- jazz ballad 1
- jazz guitar 1
- joy 1
- joyful 1
- lively 1
- male and female voices 1
- male voice yodeling 1
- male voices yodeling 1
- medium to uptempo 1
- no drums 1
- romanian folk music 1
- solo 1
- upbeat 1
- violin solo 1
- walking bassline 1
- western swing 1
- yodel/folkmusic 1
- yodeling 1
- yodeling/folk 1
musiccaps_names (array) 7 ✖
youtube_published (date) 6 ✖
- 2007-09-30 1
- 2007-11-14 1
- 2008-12-17 1
- 2010-04-23 1
- 2010-10-02 1
- 2013-10-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Justin BIEBER YODELLING! | A male voice is singing/yodeling along to an accordion playing a melody and chords while an upright bass is playing a simple line along with a minimal drum playing along. In the background the crowd is clapping along to the beat. This song may be playing at a folk fest. | 2010-04-23T22:06:18Z | nikhil5556 | OMG ITS JUSTIN BIEBER YODELING FOR ESMEE DENTERS!!!! - I do not hate Justin Bieber in anyway this is just a JOKE. The actual song is franz lang - einin jodler hor I gern ... Are you stupid writing Fake? Of course it's not real... | ["Singing", "Yodeling", "Music"] | ["yodeling/folk", "male voice yodeling", "accordion", "upright bass", "crowd clapping", "percussion", "medium to uptempo", "good mood"] | 6 | Es9FNjZ-SHI | 1595 | |
2013 NorthWest Western Swing Festival - The Jangles Band | An instrumental western swing group featuring a violin or fiddle solo. The upright bass lays down a steady walking bassline while two jazz guitars accompanied by strumming chords. Accordion is also present, but drums are not. | 2013-10-17T08:36:09Z | Jeanne Yearian | In this video clip, The Jangles Band performs "I'm an Old Cowhand," "Sweet Sue" and "I'm a Long, Tall Texan" at the NorthWest Western Swing Music Society's 23rd Annual Western Swing Festival, held August 8-11, 2013. Billed as Seattle's premier Western Swing Band, The Jangles entertain around the northwest. For more information, check out their website at www.mikefaast.com/bands/jangles or look for them on Facebook. The NorthWest Western Swing Music Society's annual festival and Hall of Fame induction ceremony are held on the second week-end in August, at the Auburn Eagles Club in Auburn, Washington. For more information about western swing or the western swing music societies across the United States, please visit the Society's website at www.nwwsms.com. | ["Swing music", "Music", "Bowed string instrument"] | ["fiddle", "guitar strumming", "western swing", "accordion", "violin solo", "upright bass", "jazz guitar", "violin solo", "jazz", "walking bassline", "no drums", "instrumental"] | 8 | S2u5IE0n1ws | 2735 | |
김홍철과 친구들 / 아름다운 스위스 아가씨 | The folk music excerpt features a group of male and female voices singing the same melody in unison which consists of yodeling. The instrumental consists of a few accordions, an acoustic guitar and an upright bass. The atmosphere is one of joy. | 2008-12-17T04:06:12Z | Kane Kang | OBS 경인TV http://www.obs.co.kr 주철환 김미화의 문화전쟁 라이브. http://www.culturewars.tv/ 1983년 요들가수 김홍철을 중심으로 결성된 '김홍철과 친구들'은 알프스 지방의 요들송과 스위스 민속 음악을 연주하는 아시아의 유일한 그룹이었으나, 1993년 김홍철의 캐나다 이민으로 해체되었다가 2003년 재결성되었습니다. '김홍철과 친구들'이 영국의 요들러 'Frank Ifield'의 원곡 'She taught me how to yodel'을 개사한 '아름다운 스위스 아가씨'를 라이브로 부릅니다. Live stage from OBS Culturewars. Korean yodel group "Kim Hong-Chul & Friends" sing Frank Ifield's yodel song 'She taught me how to yodel'. | ["Singing", "Yodeling", "Music", "Musical instrument"] | ["male and female voices", "accordion", "acoustic guitar", "upright bass", "folk music", "yodeling", "joy"] | 2 | TEoDtxjlctA | 2823 | |
Franzl Lang- Rambling in the mountains | Male voices are yodeling with a lot of reverb on their voices. They are loud and the speakers of the recording are speaking. An accordion is playing a fast melody that is panned to the right side of the speakers. A guitar is strumming a rhythmic chord on the backbeat. An upright bass is playing a walking bassline. This song may be playing at a folksfest. This is an amateur recording. | 2007-09-30T11:52:30Z | Spiciu | Let's listen to a lovely jodler sung by Franzl Lang, the jodler's king. | ["Yodeling", "Music"] | ["yodel/folkmusic", "male voices yodeling", "accordion", "acoustic guitar", "upright bass", "fast tempo", "amateur recording"] | 6 | Y8wHDcVCGa0 | 3259 | |
ROUGE "Fin des Vacances"nice jazz accordion solo: Steve Rice | This is a live performance of a jazz ballad music piece. The accordion is playing a solo as the main melody. There is an acoustic guitar playing the chords of the piece. The bass line is being played by the upright bass. The atmosphere is gentle. This piece is the perfect music to be played in the background at a coffee shop. | 2007-11-14T09:55:52Z | sricenw | A French jazz ballad by Henri Salvador sung beautifully by Janet Rayor with some great jazz accordion colorations by Steve Rice. This video also features John Miller-guitar, Ruthie Dornfeld-violin and Cary Black-bass. Rouge is a Seattle WA based french cabaret ensemble. Links: http://www.myspace.com/stevericemusic http://www.RougeMusic.com http://www.youtube.com/rougemusic | ["Accordion"] | ["jazz ballad", "live performance", "accordion", "solo", "acoustic guitar", "upright bass", "gentle", "chill", "coffee shop music"] | 9 | gp1DYuoQH08 | 4054 | |
dorel bass boss si lilian de la craiova | This is the live performance of a Romanian folk music piece. It is instrumental. There is an accordion playing the leading melody while the fiddle, acoustic guitar and the upright bass play in the background. There is a percussive element in the rhythmic background. The atmosphere is lively and joyful. | 2010-10-02T11:31:13Z | bosssbosssmihaita | la o terasa in las palmas de gran canarias | ["Accordion"] | ["romanian folk music", "live performance", "instrumental", "accordion", "upright bass", "acoustic guitar", "percussion", "fiddle", "lively", "upbeat", "joyful"] | 9 | xR2p3UED4VU | 5328 |
Advanced export
JSON shape: default, array, newline-delimited
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;