musiccaps_details (view)
1 row where musiccaps_aspects contains "jazz percussion", musiccaps_author = 0 and musiccaps_names contains "Wind instrument, woodwind instrument"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Harmonica - Nature Boy - Music Sheet - Nat King Cole | This song features a harmonica playing the main melody. This is accompanied by percussion playing a simple beat with the focus on the snare. The bass plays the root note of the chord. Due to the low quality of the audio, the other instruments cannot be heard. T. | 2008-01-31T13:16:17Z | alliax | http://www.ALLIAX.net Please comment my videos. Nature Boy by Eden Ahbez played on chromatic harmonica. There's a famous version by Nat King Cole, search for it on YouTube, you'll like it. I've added the music sheet to the video, but at the end there was a glitch and it's all black now. Doesn't matter much since it's three times the same melody... Ahbez composed the song which told a fantasy of a "strange enchanted boy... who wandered very far" only to learn that "the greatest thing... was just to love and be loved in return." The Yiddish songwriter Herman Yablakoff alleged that the melody to "Nature Boy" came from his song "Sveig Mein Hartz" ("Be Still My Heart"); his legal action was settled out of court. Actually, one needs go further back to Antonin Dvorak's Piano Quintet No. 2 in A, Opus 81 (1887). The melody of Nature Boy sits there loud and clear in multiple passages. This Dvorak piece is considered by some to be the greatest piece of chamber music ever composed. There were most probably Yiddish theaters in Prague during that period in history ... or perhaps Mr. Yablakoff was influenced by the classics. If you play the harmonica and have videos on YouTube then join the Harmonica Group: http://www.youtube.com/group/harmonica | ["Harmonica", "Wind instrument, woodwind instrument"] | ["jazz song", "pop", "harmonica", "jazz percussion", "no voices", "instrumental", "amateur recording", "bass", "slow tempo"] | 0 | sEIn8YYD9jw | 4932 |
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;