musiccaps_details (view)
5 rows where musiccaps_aspects contains "accordion", musiccaps_author = 6 and musiccaps_names = "["Accordion"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Clip #4 Walter Eriksson , Hasse Tellemar " Lörda mé Larssons " SWEDISH TV | This song contains acoustic drums playing together with an e-bass. An accordion is playing the main melody together with a flute playing in a higher register. This song may be playing while waiting in line for a phone call. | 2009-11-07T17:35:31Z | Scandinavian Echoes | www.WalterEriksson.com - Walter Eriksson , Hasse Telemar , Kjell Wigren " Lorda Me Larssons " SWEDISH TV | ["Accordion"] | ["folksong", "accordion", "acoustic drums", "e-bass", "flute", "medium to uptempo", "happy mood"] | 6 | dCCh6POPUeA | 3769 | |
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;