musiccaps_details (view)
3 rows where musiccaps_aspects contains "moderate tempo" and musiccaps_names contains "Accordion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- moderate tempo · 3 ✖
- accordion 2
- folk song 2
- instrumental 2
- no voices 2
- accordion music 1
- acoustic guitar 1
- amateur recording 1
- bass 1
- double base 1
- flute 1
- hammered dulcimer 1
- happy mood 1
- male voices 1
- no voice 1
- triangle 1
- tuba 1
- violin 1
- waltz song 1
musiccaps_names (array) 4 ✖
- Accordion · 3 ✖
- Music 2
- Musical instrument 2
- Traditional music 2
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 | |
Sile de la Cernica, Marius Turneanu, Cezar Cazanoi - Hora re minor | This folk song features a variety of instruments. The main melody is played on a violin, flute and accordion. The double bass plays a running bass pattern. An acoustic guitar strums chords. A hammered dulcimer plays parts that give a percussive feel. There are no voices in this song. This is an instrumental song. This song can be played in a luxurious and lively brunch. | 2013-04-30T22:01:22Z | Ionascu George Florian | Sile de la Cernica, Marius Turneanu, Cezar Căzănoi, George Miu, Marius Gore, Victor de la Tr. Severin | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["folk song", "accordion", "violin", "double base", "flute", "hammered dulcimer", "no voices", "instrumental", "no voice", "moderate tempo", "happy mood"] | 0 | u68Ghaf_Phs | 5089 | |
Ansambel Lojze Slak / Dezelica sonca in grozdja. | This waltz song features accordions playing in harmony. Male voices sing the main melody. The voices sing in harmony. When the voices start to sing, the accordions play the same melody as the voices. The bass is played on a tuba. An acoustic guitar strums chords. A tambourine plays the part of the percussion. There are trumpets and clarinets playing in this song. This is a folk song. The mood of this song is happy. | 2012-08-09T23:11:27Z | Johan Hopman | Lojzeta Slaka Was A Great Diatonic Button Accordion Player From Slovenia. Born: 23 July 1932 In Jordankal,Near Mirna Pec Died: 29 September 2011 In Ljubliana. Lojzeta Was Burried In Sentvid,He Was 79 Jears Old. | ["Accordion"] | ["accordion music", "tuba", "acoustic guitar", "male voices", "waltz song", "moderate tempo"] | 0 | zj2G-KVw4N4 | 5506 |
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;