musiccaps_details (view)
1 row where musiccaps_aspects contains "arabic dance music", musiccaps_aspects contains "medium tempo" and "youtube_published" is on date 2013-11-22
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 |
---|---|---|---|---|---|---|---|---|---|---|
سرو خرامان از گروه مهربانو فقط حال کنید Traditional Persian Folk Music Iran - | The song is an instrumental. The song is medium tempo with various traditional Arabian stringed instruments playing in harmony along with Arabic percussion instruments. The song is traditional and emotional. The song is an ancient folk song but in poor audio quality. | 2013-11-22T01:55:06Z | Saboor Tabish Official | Amazing Persian Music by a group of female musicians :) Enjoy omid moin googoosh گوگوش reza sadeghi Faramarz Asef kamar barik رضا صادقی Leila Forouhar andy اندی امید next persian star Afghan Classic Songs 2014 Afghan High Definition Songs Afghan Hits Songs 2014 Afghan New Videos 2014 Afghan Pop Songs 2014 Afghan songs Afghan songs 1080p waidscreen Afghan Songs 2014 Afghan Songs1080p HD Afghan Star 2014 Afghani Songs 2014 Afghanstar 2014 Dari Songs 2014 Del Agha Surood New Song 2014 Edris New Songs 2014 Farsi Songs 2014 Fayaz Hamid Fayaz Hamid New Songs 2014 Fayaz Hamid Songs Hazargi Songs 2014 Irani songs 2014 Jawid Sharif Jawid Sharif New songs Jawid Sharif New Songs 2014 Jawid Sharif Songs Mirwais Hamrah New Song 2014 New Afghan Ghazal Songs 2014 New Afghan Mast Songs 2014 New Afghan Singers 2014 New Afghan Singers 2014 New Afghan Songs 2014 New Afghan Songs 2014 1080p New Afghan Video Clip 2014 New Afghani Songs 2014 New Ghazal Songs 2014 New Irani songs 2014 New Persian songs 2014 New Qataghani Song 2014 Persian Songs 2014 Persian Songs 2014 Persian Songs 2014 Ramin Mansour Suliman khan Live Songs 2014 Suliman khan Songs Suliman khan Songs 2014 Tajiki Songs 2014 Tolo tv News Tolo Tv show Uzbaki Songs 2014 Uzbaki Songs 2014 persian فارسی پارسی دری افغانی اصفهانی samad agha basanti kam kamaki Нозияи Кароматулло Nozia Karomatullo valy Sadriddin Nigina Amonkulova shabnam soraya Таджички Парвина Шукрулаева tojik pomeri pomiri persian music pamir pamiri | ["Traditional music", "Music", "Middle Eastern music"] | ["instrumental music", "arabic music", "generational heritage", "arabic culture", "passionate", "arabic dance music", "ancient folk music", "stringed instruments", "percussion instruments", "traditional music", "medium tempo", "poor audio quality", "emotional", "desert sands", "persia", "arabic string band", "folk music", "folk musicians"] | 1 | zwfo7wnXdjs | 5518 |
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;