musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "bass", musiccaps_aspects contains "instrumental" and musiccaps_author = 0
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 |
---|---|---|---|---|---|---|---|---|---|---|
DOMINGUINHOS: VOZ, SANFONA E HISTÓRIAS DE VIDA | This folk song features an accordion playing the main melody. Another accordion plays a backing melody and chords. The bass plays a groovy lick based around the root note of the chord. A triangle plays the part of the percussion. This is a low quality audio and the percussion is not audible. This song can be played in a village fair. | 2013-08-04T16:20:08Z | MACÍLIO GOMES | Imagens cedidas pela TV Ceará Canal 5, de especial gravado com Dominguinhos para o programa Ceará Caboclo, apresentado aos domingos (10h) pelo nosso amigo Dilson Pinheiro, reprisado em 28/07/2013, em homenagem póstuma a um dos maiores sanfoneiros do Brasil (senão o maior). Músico nato virtuoso, cantor e compositor, mundialmente conhecido, querido e respeitado por todos. Conhecido como o pai dos sanfoneiros, pelos quais era reverenciado, mestre dos mestres, sua humildade e simplicidade eram do tamanho de sua grandeza. Dominguinhos fala de suas origens, da infância simples e humilde; das primeiras letras; do início da carreira; como conheceu Luiz Gonzaga. Na qualidade de mestre da sanfona, repassa lições de ritmo, a diferença da batida do baião e do forró. E por aí vai... | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["folk song", "accordion", "no voices", "triangle", "bass", "instrumental", "amateur recording", "moderate tempo"] | 0 | AJTU5RhF3S4 | 1102 | |
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;