musiccaps_details (view)
2 rows where musiccaps_aspects contains "accordion" and musiccaps_aspects contains "male voice singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- accordion · 2 ✖
- male voice singing · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- amateur recording 1
- country/folk 1
- e-bass 1
- folkmusic 1
- higher register 1
- medium to uptempo 1
- percussion 1
- positive energy 1
- uptempo 1
musiccaps_names (array) 5 ✖
- Music 2
- Folk music 1
- Music of Africa 1
- Music of Latin America 1
- Ska 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 | |
Casar Hum Hum Gino e Geno Part Felipe Borges 2013 | A male voice is singing/shouting phrases while an acoustic drum is playing a dance groove along with an e-bass. On top of that a acoustic guitar is playing a melody and another one is strumming chords while an accordion is playing a loud melody that seems to be the lead. The drum fill-ins are panned to the left and right side of the speakers. This song sounds like the people are having fun. This song may be playing at a dance event in the countryside. | 2013-05-16T00:23:52Z | W Comunicação | Nova Música do Gino e Geno Lançamento | ["Music of Africa", "Music", "Ska", "Music of Latin America"] | ["country/folk", "acoustic drums", "e-bass", "accordion", "acoustic guitar", "male voice singing", "uptempo", "positive energy"] | 6 | Fv9swdLA-lo | 1674 |
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;