musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "upright bass" and musiccaps_names contains "Musical instrument" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- acoustic guitar 3
- upright bass · 3 ✖
- amateur recording 2
- medium to uptempo 2
- accordion 1
- background voices 1
- banjo 1
- bluegrass 1
- country/folk 1
- folk music 1
- joy 1
- male and female voices 1
- male and female voices singing 1
- mandolin 1
- violin 1
- yodeling 1
musiccaps_names (array) 12 ✖
- Music 3
- Musical instrument · 3 ✖
- Banjo 2
- Bluegrass 1
- Bowed string instrument 1
- Country 1
- Guitar 1
- Plucked string instrument 1
- Singing 1
- Speech 1
- Violin, fiddle 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bluegrass jam ( Rebecca) | An acoustic guitar is strumming chords while a banjo is playing a fast melody over it. In the background you can hear an upright bass playing a fast walking bassline. Also in the background noises of people speaking can be heard. This song may be playing live on the streets performed by buskers. | 2006-11-06T22:08:09Z | monrobro | Jamming at Memramcook Festival with True Blue Banjo- Dominic Cormier Bass- Jean-Marc Boucher Mandolin- Ron Girouard Guitar- 1st Break Michael Alain Guitar- 2nd Break Richard Bourque | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bluegrass"] | ["bluegrass", "amateur recording", "banjo", "acoustic guitar", "upright bass", "background voices", "medium to uptempo"] | 6 | 669Fk7afszw | 724 | |
Rooster Song | This song contains an upright bass playing a simple bassline along with an acoustic guitar strumming chords and a mandolin playing a fast paced melody. A violin is ending the phrase in the mid range. Then male and female voices are singing with the female voice being the lead voice. In the background you can hear the crowd laughing. This song may be playing as a local concert. | 2007-01-11T22:59:38Z | Phil Greer | Timberline's most requested song... | ["Banjo", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | ["country/folk", "upright bass", "acoustic guitar", "violin", "mandolin", "male and female voices singing", "medium to uptempo", "amateur recording"] | 6 | j0UMI2DrnMA | 4229 | |
김홍철과 친구들 / 아름다운 스위스 아가씨 | 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;