musiccaps_details (view)
1 row where musiccaps_aspects contains "accordion", musiccaps_aspects contains "folkmusic", musiccaps_aspects contains "higher register" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;