musiccaps_details (view)
7 rows where musiccaps_aspects contains "amateur recording" and musiccaps_names contains "Accordion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- amateur recording · 7 ✖
- accordion 5
- folkmusic 3
- uptempo 2
- acoustic guitar 1
- acoustic piano 1
- bass 1
- cheerful atmosphere 1
- clarinet 1
- crickets chirping 1
- digital accordion 1
- dreamy 1
- folk song 1
- higher pitch 1
- horn 1
- instrumental 1
- male singer 1
- medium tempo 1
- medium to uptempo 1
- melancholy 1
- moderate tempo 1
- no voices 1
- percussion 1
- triangle 1
- trumpet 1
- uplifting mood 1
youtube_published (date) 7 ✖
- 2008-02-06 1
- 2008-06-26 1
- 2009-07-16 1
- 2010-04-17 1
- 2011-03-06 1
- 2013-08-04 1
- 2014-04-09 1
musiccaps_names (array) 6 ✖
- Accordion · 7 ✖
- Music 2
- Foghorn 1
- Inside, large room or hall 1
- Musical instrument 1
- Traditional music 1
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 | |
Födelsedagsvals till Mona | Someone is playing a piece of music on an accordion. The song sounds uplifting. This song may be playing live at a local theater. | 2008-06-26T16:44:08Z | Sven Fredriksson | Konsert på Roslagens Sparbank, Norrtälje, 1988-11-12. Sven Fredriksson dragspel och Torbjörn Eklund flöjt. | ["Accordion"] | ["amateur recording", "folkmusic", "accordion", "uptempo", "uplifting mood"] | 6 | AareFwTIg1s | 1143 | |
Yann Tiersen - La valse d'Amelie (Piano - Accordion) | This audio contains someone playing a fast paced piece with a fast left hand and a slower melody in the right hand playing in the midrange. Someone starts playing an accordion alone. This song may be playing live jamming with your friend. | 2008-02-06T13:38:35Z | Andrea Rossi | Beautiful song from "Le fabuleux destin d'Amelie Poulain" by Yann Tiersen, executed with piano and accordion. Enjoy it. Ora anche su myspace e facebook! Now available on myspace and facebook! http://www.myspace.com/vitedarte http://www.facebook.com/pages/Vite-darte/115844915145405 | ["Accordion"] | ["amateur recording", "acoustic piano", "accordion", "medium tempo", "dreamy", "melancholy"] | 6 | FMjUGdTn7lU | 1639 | |
A Hawk and a Hacksaw - Serbian Cocek | This piece contains someone playing a trumpet, a clarinet and a horn all playing the same note in different octaves. The horn is playing a bassnote. This song may be playing live as a school concert. | 2009-07-16T08:11:54Z | videochemist | Duke of York's, Brighton 16/06/09 (3 of 11) From their 2007 album A Hawk and A Hacksaw and the Hun Hangár Ensemble. | ["Foghorn", "Music", "Accordion", "Inside, large room or hall"] | ["amateur recording", "trumpet", "horn", "clarinet"] | 6 | Q8QXzYpl6Tw | 2598 | |
Melodeon - Villana De Cuento instruccional | This audio contains crickets chirping. Then someone starts playing a digital accordion. This is an amateur recording. | 2014-04-09T18:30:25Z | Fernando Padilla osuna | De Alfredito Olivas... Espero y les guste | ["Accordion"] | ["amateur recording", "crickets chirping", "digital accordion"] | 6 | VkXLtUx-RmI | 3027 | |
Cotton Fields Back Home (Creedence Clearwater Revival) - Accordion Duet | This audio contains two people playing accordion. One is playing the foundation as rhythmical chords while the other person is playing the lead melody in a higher pitch. This song may be playing live in the countryside. | 2010-04-17T08:12:39Z | bertosvids | Hello folks! Bob and Hector here for yet another series. (April, 2010). We hope you enjoy our friendly squeeze box duets. Series 9. April, 2010. | ["Accordion"] | ["amateur recording", "folkmusic", "accordion", "uptempo"] | 6 | mKIapkfnAGY | 4460 | |
GETULIO VARGAS cavalo amarelo. | This song contains someone playing an accordion melody and chords along with an acoustic guitar strumming the same chords. Someone is playing an acoustic instrument while a male voice is singing in a higher key. This song may be playing in the countryside. | 2011-03-06T17:18:58Z | ALOCHECULTURAGAUCHA | CLIP gravado por NELSON OLIVEIRA para o programa Alô Chê do IVAN TABORDA. | ["Accordion"] | ["folkmusic", "accordion", "acoustic guitar", "male singer", "higher pitch", "percussion", "medium to uptempo", "amateur recording", "cheerful atmosphere"] | 6 | nJ3tuDmcdTs | 4531 |
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;