musiccaps_details (view)
4 rows where musiccaps_aspects contains "acoustic rhythm guitar", musiccaps_aspects contains "low quality", musiccaps_aspects contains "passionate" and musiccaps_names contains "Singing"
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 |
---|---|---|---|---|---|---|---|---|---|---|
DAVID ALLAN COE interview - part 1 | The low quality recording features a flat male vocal singing over acoustic rhythm guitar chords, after which that same vocal is talking. The song sounds passionate, while the recording, overall, is noisy and in mono. | 2008-07-26T19:53:24Z | BubbaTheLawnJockey | DAVID ALLAN COE interview - part 1 | ["Singing", "Country", "Music", "Strum"] | ["low quality", "noisy", "mono", "acoustic rhythm guitar", "flat male vocal", "passionate", "country"] | 4 | -UuEBhule84 | 52 | |
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 | |
loretta lynn "when the roll is called" | The low quality recording features a passionate male vocal, alongside harmonizing mixed vocals, singing over acoustic rhythm guitar, accordion melody and groovy bass. It sounds passionate and joyful. The recording is noisy and in mono - the sound is coming from the right channel only. | 2007-07-17T06:19:50Z | lorettafan1 | with teddy and doyle and the willis brothers | ["Singing", "Music", "Middle Eastern music"] | ["low quality", "noisy", "mono", "harmonizing mixed vocals", "passionate male vocal", "accordion melody", "acoustic rhythm guitar", "groovy bass", "passionate", "joyful"] | 4 | _2P_EJsnBls | 3437 | |
Tracy Chapman and Bruce Springsteen - My Hometown (Live 2004) | The low quality recording features a live performance of a folk rock song that consists of harmonizing vocals singing over shimmering hi hats, snappy rimshots, groovy bass guitar and acoustic rhythm guitar, followed by some crowd claps. It sounds messy, muddy and distorted, but still emotional and passionate too. | 2010-09-19T11:10:04Z | Tracy Chapman Online | ♥ Subscribe our newsletter ► https://www.about-tracy-chapman.net/newsletter/ ♥ ♥ Subscribe Tracy Chapman Youtube Channel ► http://www.youtube.com/tchapmanfan ♥ See also ► Fan website : http://www.about-tracy-chapman.net/ ► Facebook: https://www.facebook.com/tracychapmanonline ► Instagram https://instagram.com/tracychapmanonline ► Twitter: https://twitter.com/tchapmanonline Order Tracy Chapman’s "Greatest Hits" on iTunes http://apple.co/1RtSdDu | Amazon: http://hyperurl.co/TC-GH Tracy Chapman and Bruce Springsteen perform "My hometown" in 2004. Low Quality rare video. | ["Singing", "Music", "/t/dd00003"] | ["low quality", "live performance", "folk rock", "distorted", "shimmering hi hats", "harmonizing vocals", "groovy bass guitar", "acoustic rhythm guitar", "snappy rimshots", "crowd clapping", "messy", "muddy", "emotional", "passionate"] | 4 | aPQTrv2B1sw | 3536 |
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;