musiccaps_details (view)
12 rows where musiccaps_aspects contains "accordion" and musiccaps_aspects contains "amateur recording"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- accordion · 12 ✖
- amateur recording · 12 ✖
- folkmusic 5
- acoustic drums 4
- medium to uptempo 4
- bass 3
- e-bass 3
- medium tempo 3
- acoustic guitar 2
- cheerful atmosphere 2
- e-guitar 2
- percussion 2
- uptempo 2
- acoustic piano 1
- background cheering 1
- choir 1
- comedic 1
- dreamy 1
- fast tempo 1
- female voice singing 1
- female voices singing 1
- flute 1
- folk song 1
- gospel/folk 1
- higher pitch 1
- higher register 1
- instrumental 1
- jingle 1
- male deep voice singing 1
- male singer 1
- male voice samples 1
- male voice singing 1
- male voices yodeling 1
- melancholy 1
- moderate tempo 1
- no voices 1
- piano 1
- popmusic 1
- screaming 1
- shakers 1
- shouting 1
- triangle 1
- uplifting mood 1
- upright bass 1
- yodel/folkmusic 1
musiccaps_names (array) 16 ✖
youtube_published (date) 12 ✖
- 2007-02-16 1
- 2007-09-30 1
- 2008-02-06 1
- 2008-06-26 1
- 2009-12-13 1
- 2010-04-17 1
- 2011-03-06 1
- 2012-06-01 1
- 2013-08-04 1
- 2013-09-19 1
- 2014-01-18 1
- 2015-02-07 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Afghan Original Music Pashto Tappe Bannu Afghan Kaliwal Majlas Lar aw Bar Afghan Loy Afghanistan | Someone is playing a percussive instrument that reminds a little bit of a tabla while someone else is playing a fast melody on an accordion. A male voice is singing at a higher pitch. This song may be playing live. | 2012-06-01T07:34:58Z | TheOriginalAfghan | http://larawbar.com/Loy_Afghanistan/ Pashto song, Pashto Music, Afghani Music , Afghan song, Afghan Music, Afghani song.,Pashtunistan , Pakhtunkhwa , Bannu ,Pashtunkhwa, Pakhto song, Pukhto song. Afghanistan song, Loy Afghanistan song Lar aw Bar Afghanan, Pakhton song, Pashton song, Pashtun Song, Pakhtunen , http://larawbar.com/Loy_Afghanistan/ Pashto song, Pashto Music, Afghani Music , Afghan song, Afghan Music, Afghani song. Pakhto song, Pukhto song. Afghanistan song, Loy Afghanistan song Lar aw Bar Afghanan, Pakhton song, Pashton song, Pashtun Song, Pakhtunen , Pashtunen , Afghan , Afghanan , Pathan, Pathanan, Pakhtunkhwa song. Pashtunkhwa song, Pashtoonkhwa, Pakhtoonkhwa, Pashtunistan, Pakhtunistan,Pashto song Afghani song & Music Pashto Song & Music * Attan* Lar aw bar Afghanan Loy afghanistan song Pashtunkhwa song Afghani music afghan Music Pashto Sandara* Attan* Abdali * . Durrani * Achakzai * Alekuzei * Afridi * Ahmadzai * Bangasch * Baraksai * Chamkani * Ghilzai * Ishaqsai * Kakar * Kharot * Khattak * Lodhi * Mahsud * Mangal * Marwat * Mohamedsai * Mohmand * Niazi * Noorzai * Oroksai * Popalsai * Karzai * Safi * Shinwari * Swati * Tanoli * Wasir * Wazir * Banisai * Yousufsai * Zadran * Zazai "afghan music"پښتو ښکلی سندري kabul,peshawar.Afganistan PAKHTOONsDEDICATED TO AFGHANISTAN, JALALABAD, KABUL,PAKIA, LAGHMAN,HILMAND,PTV NATIONAL,ARY ONE WORLD,THE MUSIC,MTV,SHAMSHAD TV,TULU,TOLO,LAMAR,KHYBER AGENCY,WAZIRISTAN AGENCY,MIRALI,BANNU,KARAK,D.I.KHAN,LUCKY MARWAT,KOHAT,PESHAWAR,BHATKHELA,MALAKAND ss,SWAT,MARRI,KOHAT,PARACHINAR,HANGU,TAL,M IRANSHAN,ANP,NWFP,SANDARE,FUN,ENJOY,OLD TRADITION MUSIC,ATTARN,ATTAR,ATARN,DANCE,FM101,FM1 04,FM106,FM BURAQ,DUBAI,DAWAR,MASOOD,SARDAR ALI TAKKER,HAROON BACHA,SANGEEN AFRIDI,AMJAD KHAN,SARFARAZ,KHALID MALIK,ASHRAF GULZAR,GULZARALAM,FARHAD DARYA,NAGMA,WAGMA,NAZIA IQBAL,RANI,SHAHINSHAH,ZEEK AFRIDI,HAMAYUN KHAN,FAZA FIAZ,BAKHTIYAR KHATTAK,ADNAN SAMI,SONU NIGAM,UDIT NARAYAN,LATA MANGESHKAR,ASHA BOSLE,SHAHRUKH KHAN,AAMIR KHAN,PASHTO,PUSHTO,NEWS,BBC,FUNNY,ENTERT AINMENT,MOVIE,GA… | ["Folk music", "Music"] | ["folkmusic", "amateur recording", "accordion", "percussion", "male voice singing", "higher register", "medium to uptempo"] | 6 | -ZHpNr_KRXU | 62 | |
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 | |
Simone e Simaria - Ela namora hum - Lovina João Pessoa | This song contains an acoustic drum playing along with a bass and an accordion melody creating a cheerful atmosphere. The crowd is so loud. Cheering, screaming and laughing. This song may be playing at a local event. | 2014-01-18T17:11:01Z | Anne Michelle | Show realizado no dia 17/01/2014 | ["Crowd", "Music", "Speech", "Music of Latin America"] | ["amateur recording", "popmusic", "e-bass", "e-guitar", "accordion", "female voice singing", "acoustic drums", "background cheering", "screaming", "shouting", "medium tempo", "cheerful atmosphere"] | 6 | HvOSaS8sXQM | 1848 | |
A Kaj-tastic Musical The Pylons are TRAP BALLS | An acoustic drum is playing a faster groove along with a walking bassline. An accordion is playing a melody on top of another instrument supported with short rhythmic chords on the offbeat. Male voice samples are used to create a simple melody. This song may be playing in a funny video. This is an amateur recording. | 2007-02-16T07:33:31Z | Kajetokun | Not quite sure if it'll sync up properly... I hope it does. Windows Movie Maker could not handle to massive amounts of scene changes. You can download this song here http://rapidshare.com/files/52574569/PYLON_BALLS_TRAP.mp3.html | ["Music", "/t/dd00032"] | ["folkmusic", "accordion", "acoustic drums", "male voice samples", "bass", "medium to uptempo", "amateur recording"] | 6 | LzSWdj4izHM | 2233 | |
Franzl Lang- Rambling in the mountains | Male voices are yodeling with a lot of reverb on their voices. They are loud and the speakers of the recording are speaking. An accordion is playing a fast melody that is panned to the right side of the speakers. A guitar is strumming a rhythmic chord on the backbeat. An upright bass is playing a walking bassline. This song may be playing at a folksfest. This is an amateur recording. | 2007-09-30T11:52:30Z | Spiciu | Let's listen to a lovely jodler sung by Franzl Lang, the jodler's king. | ["Yodeling", "Music"] | ["yodel/folkmusic", "male voices yodeling", "accordion", "acoustic guitar", "upright bass", "fast tempo", "amateur recording"] | 6 | Y8wHDcVCGa0 | 3259 | |
Thomas the tank engine (Shitty flute version) | This audio contains acoustic drums playing with an e-bass. An accordion is playing a short chord melody on the backbeat while someone is playing a flute melody completely out of tune and all over the place. This is an amateur recording. This song may be playing at home while practicing playing the flute. | 2015-02-07T18:59:32Z | shittyflute | Support my Channel on - https://www.patreon.com/shittyflute follow the shit in other places if you want : Twitter - https://twitter.com/shittyflute Facebook - https://www.facebook.com/Shitty-1723911674493449 Instagram - https://www.instagram.com/shittyflute/ Shirts - https://shop.spreadshirt.com/shitty/ may peace be upon you | ["Wind instrument, woodwind instrument", "Flute"] | ["amateur recording", "flute", "accordion", "e-bass", "acoustic drums", "shakers", "comedic"] | 6 | a-P0p_UtagM | 3511 | |
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 | |
Santa Claus Mic Ebay Item # 290505104184 | A male deep voice is singing along to an accordion sound and a choir providing backing vocals. This song sounds cheerful. This is an amateur recording and of poor audio-quality. This song may be playing at a celebration. | 2009-12-13T12:36:28Z | SantaClaus47579 | Search item # 290505104184 on Ebay for latest. 11-11-2010. This Santa Claus sings and dances to 5 songs. Use the microphone to talk and sing through Santa's mouth and the aux input to play your recorded songs. | ["Christmas music", "Christian music", "Music", "Synthetic singing"] | ["jingle", "amateur recording", "male deep voice singing", "accordion", "choir", "bass", "medium tempo"] | 6 | qKOsbyT8GCU | 4776 | |
Myanmar Gospel Song New: ဆာလံ ၂၃ | This song contains acoustic drums playing along with a bass creating a folksong atmosphere along with an accordion like sounding instrument. A piano and guitar are playing a melody along with an accordion -like instrument taking the main melody from the instruments. Female voices are singing at a higher pitch. This song is in poor audio-quality. This song may be playing live at a church. | 2013-09-19T14:11:27Z | Samuel Thio | Let's sing joyfully and praise our Lord. May the Lord bless you dear friend. ဒီသီခ်င္းကို ၾကည္ခဲ့ရင္ ၾကည့္ခဲ့တဲ့ အေၾကာင္းအသိေပးေပးပါ။ | ["Gospel music", "Christian music", "Music"] | ["gospel/folk", "amateur recording", "acoustic drums", "e-bass", "female voices singing", "piano", "e-guitar", "accordion", "medium to uptempo"] | 6 | yOVaak2hemM | 5405 |
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;