musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "folk music", musiccaps_aspects contains "upright bass" and musiccaps_aspects contains "yodeling"
This data as json, CSV (advanced)
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 |
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;