musiccaps_details (view)
5 rows where musiccaps_aspects contains "folk song" and musiccaps_names contains "Accordion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- folk song · 5 ✖
- accordion 4
- instrumental 4
- no voices 4
- bass 2
- moderate tempo 2
- slow tempo 2
- violin 2
- acordion accompaniment 1
- acoustic guitar 1
- amateur recording 1
- clarinet 1
- country music 1
- double base 1
- dutch 1
- flute 1
- folk pop 1
- foreign language 1
- guitar 1
- hammered dulcimer 1
- happy mood 1
- low quality audio 1
- male singer 1
- metallic clicking sound 1
- no other instruments 1
- no percussion 1
- no voice 1
- pop 1
- regional music 1
- triangle 1
- trumpet 1
- tuba 1
- vocal emphasis 1
- waltz 1
- world music 1
musiccaps_names (array) 4 ✖
- Accordion · 5 ✖
- 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 |
---|---|---|---|---|---|---|---|---|---|---|
Boudewijn de Groot - Verdronken vlinder | A male vocalist sings this passionate song in Dutch. The tempo is slow with vocal emphasis and an accordion harmony. The song is a simple, narrative, slow Folk song. | 2007-08-01T21:46:42Z | Thijs Hanrath | Lied van Boudewijn de groot: verdronken vlinder. A dutch song of Boudewijn de groot about jealousy at a butterfly | ["Accordion"] | ["male singer", "slow tempo", "foreign language", "world music", "country music", "acordion accompaniment", "vocal emphasis", "dutch", "folk song", "pop", "folk pop", "regional music", "metallic clicking sound"] | 7 | 2Q20hVyYjBM | 361 | |
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 | |
Б.Тихонов вальс "Пушинка" | This folk song features a quarter. The main melody starts off with the accordion playing an ascending run. This is accompanied by the bass playing the root and fifth of the chords. An acoustic guitar strums chords in waltz time. After the accordion part, the violin plays the main melody and the same instruments back the violin. This song can be played in a village fair. | 2010-05-26T14:23:55Z | Сергей Боганов | Концерт в К/З МГИМ им. Шнитке 27.11.09г.: "Emotion Orchestra" под руководством Ю.Медяника | ["Accordion"] | ["folk song", "waltz", "no voices", "instrumental", "violin", "accordion", "bass", "acoustic guitar", "no percussion", "no other instruments"] | 0 | pDgWT99uaJ0 | 4691 | |
Salzburg Quintett - Oberkrainer Medley | This folk song features a clarinet playing the main melody. A trumpet plays a similar melody in harmony. This is accompanied by a tuba playing the bass notes. An acoustic guitar plays chords for this song. There are no voices in this song. This is an instrumental song. There is no percussion in this song. This song can be played at an Oktoberfest party. | 2009-01-31T20:58:16Z | Salzburg Quintett ursprünglich | Salzburg Quintett - Oberkrainer Medley, Festzelt in Inzing/Tirol 1984 | ["Accordion"] | ["low quality audio", "folk song", "guitar", "accordion", "tuba", "no voices", "instrumental", "slow tempo", "clarinet", "trumpet"] | 0 | qRgefptkDeo | 4786 | |
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 |
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;