musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "accordion" and musiccaps_names contains "Musical instrument" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- accordion · 2 ✖
- acoustic guitar 1
- double base 1
- flute 1
- folk music 1
- folk song 1
- hammered dulcimer 1
- happy mood 1
- instrumental 1
- joy 1
- male and female voices 1
- moderate tempo 1
- no voice 1
- no voices 1
- upright bass 1
- violin 1
- yodeling 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
김홍철과 친구들 / 아름다운 스위스 아가씨 | 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 | |
Sile de la Cernica, Marius Turneanu, Cezar Cazanoi - Hora re minor | This folk song features a variety of instruments. The main melody is played on a violin, flute and accordion. The double bass plays a running bass pattern. An acoustic guitar strums chords. A hammered dulcimer plays parts that give a percussive feel. There are no voices in this song. This is an instrumental song. This song can be played in a luxurious and lively brunch. | 2013-04-30T22:01:22Z | Ionascu George Florian | Sile de la Cernica, Marius Turneanu, Cezar Căzănoi, George Miu, Marius Gore, Victor de la Tr. Severin | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["folk song", "accordion", "violin", "double base", "flute", "hammered dulcimer", "no voices", "instrumental", "no voice", "moderate tempo", "happy mood"] | 0 | u68Ghaf_Phs | 5089 |
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;