musiccaps_details (view)

2 rows where musiccaps_aspects contains "accordion", musiccaps_aspects contains "folkmusic", musiccaps_names contains "Folk music" and musiccaps_names contains "Music"

✎ View and edit SQL

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
Дунаю, Дунаю A female choir is singing a melody. The instruments are playing the same melody. The percussion- section contains a bassline being played along with a tambourine. This song may be playing at a public folkfest. 2009-10-10T22:36:29Z ArattaMedia Українська народна пісня у виконанні народного ансамблю "Вишня". Художній керівник - Адам Дзюба. Інформація про колектив - http://www.aratta-ukraine.com/text_ua.php?id=1401 DVD - http://opensharing.org/torrent/94519/ ["Folk music", "Music", "Musical instrument"] ["folkmusic", "violin", "accordion", "female choir", "bass", "tambourine", "flute", "acoustic guitar", "uptempo"] 6 O6QyYC7Tt2A 2399

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;