musiccaps_details (view)
3 rows where musiccaps_aspects contains "accordion", musiccaps_aspects contains "percussion" 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 | |
Banjo-Tooie Music: Glitter Gulch Mine | This children's song features an accordion playing chords. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. An instrument like the xylophone plays the main melody on the low frequencies. There are no voices in this song. This song is an instrumental. The mood of this song is happy. This song can be played in a children's animation series. | 2007-10-29T03:32:40Z | southernpickle | The theme to Glitter Gulch Mine from the game Banjo-Tooie. | ["Music", "Tender music"] | ["children's song", "quirky sounds", "percussion", "bass", "happy mood", "accordion", "croaking sound", "slow tempo", "instrumental", "no voice", "xylophone family instrument"] | 0 | 2UnlMwW8nyI | 372 | |
Justin BIEBER YODELLING! | A male voice is singing/yodeling along to an accordion playing a melody and chords while an upright bass is playing a simple line along with a minimal drum playing along. In the background the crowd is clapping along to the beat. This song may be playing at a folk fest. | 2010-04-23T22:06:18Z | nikhil5556 | OMG ITS JUSTIN BIEBER YODELING FOR ESMEE DENTERS!!!! - I do not hate Justin Bieber in anyway this is just a JOKE. The actual song is franz lang - einin jodler hor I gern ... Are you stupid writing Fake? Of course it's not real... | ["Singing", "Yodeling", "Music"] | ["yodeling/folk", "male voice yodeling", "accordion", "upright bass", "crowd clapping", "percussion", "medium to uptempo", "good mood"] | 6 | Es9FNjZ-SHI | 1595 |
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;