musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "acoustic rhythm guitar", musiccaps_author = 4 and musiccaps_names contains "Yodeling"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, youtube_published (date)
musiccaps_aspects (array) 25 ✖
- acoustic rhythm guitar · 4 ✖
- low quality 4
- fun 2
- happy 2
- breathy flute melody 1
- compressed 1
- country 1
- cover 1
- electric guitar melody 1
- groovy bass 1
- kids song 1
- live performance 1
- mellow 1
- noisy 1
- passionate 1
- passionate male vocal 1
- regional mexican 1
- reverberant high register passionate male vocal 1
- reverberant yodel male vocal 1
- smooth double bass 1
- sweet girl vocal 1
- traditional 1
- unbalanced stereo image 1
- uptempo 1
- wide groovy clapping 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
He Taught Me How To Yodel(Alessandra) 7yrs Old | The low quality recording features a cover of a kids song that consists of sweet girl vocal singing over breathy flute melody, groovy bass and acoustic rhythm guitar. It sounds mellow, happy and fun. | 2013-02-02T02:10:57Z | Alessandra Riehl | Recorded and edited by Germaine Mashall David (gmdavidstudios.com) | ["Singing", "Yodeling", "Music", "Song"] | ["sweet girl vocal", "cover", "kids song", "breathy flute melody", "groovy bass", "acoustic rhythm guitar", "happy", "fun", "mellow", "low quality"] | 4 | 8hSmQpOPXJE | 936 | |
Dr Hook and the medicine show - Yodel Song | The low quality recording features an uptempo country song sung by passionate male vocalists, followed by acoustic rhythm guitar and electric guitar melody. It sounds really bad and imbalanced, as the left channel is louder than the right. | 2009-03-05T00:21:41Z | chiefskis | Dr Hook and the medicine show - Yodel Song | ["Singing", "Yodeling", "Music"] | ["low quality", "country", "acoustic rhythm guitar", "passionate male vocal", "compressed", "electric guitar melody", "uptempo"] | 4 | CHufyCHSF1U | 1348 | |
Frank Ifield - She Taught Me To Yodel | The low quality recording features a reverberant male vocal yodeling over acoustic rhythm guitar and smooth double bass, both located in the right channel of the stereo image. It sounds passionate, fun and happy - like something you would try to sing to when you are in a good mood. | 2009-11-30T11:18:46Z | Platon Snesar | One of the most popular yodel tunes in European music. Lyrics: I went across to Switzerland Where all the Yodellers be To try to learn to yodel With my yodel-oh-ee-dee I climbed a big high mountain On a clear and sunny day And met a yodellin' gal Up in a little Swiss chalet She taught me to yodel Yodel-oh-ee-dee Diddly-odel-oh-ee-dee Diddly-odel-oh-ee-dee She taught me to yodel Yodel-oh-ee-dee-ay-dee Yodel-oh-ee-dee-yodel-oh-dee [more yodelling] Well now I'm gonna teach you How to yodel just like me It's easy when you're singin' To go yodel-diddly-oh-oh-dee First you take a deep breath Then it's K.O. one, two, three And then you'll hear a yodel If you listen close to me Yeah, this is how to yodel Yodel-oh-ee-dee Diddly-odel-oh-ee-dee Diddly-odel-oh-ee-dee This is how to yodel Yodel-oh-ee-dee Diddly-odel-oh-ee-dee-yodel-oh-dee Thanks for watching! Would be glad if you folow me on YouTube and listen to me on SoundCloud: https://soundcloud.com/platonsnesar | ["Singing", "Yodeling", "Music"] | ["low quality", "reverberant yodel male vocal", "acoustic rhythm guitar", "noisy", "unbalanced stereo image", "smooth double bass", "passionate", "happy", "fun"] | 4 | LybSS4amIS0 | 2232 | |
tijeritas cantando x camaron | The low quality recording features a live performance of a regional Mexican song that consists of reverberant, high register, passionate male vocal singing over acoustic rhythm guitar and widely spread, groovy claps. It sounds passionate, traditional and emotional. Judging by the reverb, it was probably played in some huge concert hall. | 2010-02-15T20:29:23Z | juanjogitano | tijeritas . cantando por camaron ( potro de rabia y miel) | ["Yodeling", "Music"] | ["low quality", "regional mexican", "live performance", "wide groovy clapping", "reverberant high register passionate male vocal", "acoustic rhythm guitar", "traditional"] | 4 | rrWQd5SZK74 | 4905 |
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;