musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "traditional", musiccaps_aspects contains "wooden percussive elements" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- flat male vocal 2
- low quality 2
- traditional · 2 ✖
- wooden percussive elements · 2 ✖
- acoustic guitar melody 1
- addictive 1
- clapping 1
- energetic 1
- exciting background male vocals 1
- fun 1
- groovy bass 1
- joyful 1
- muffled 1
- noisy 1
- pop 1
- resonant 1
- steel guitar melody 1
- unbalanced stereo 1
- vintage 1
- wide 1
musiccaps_names (array) 7 ✖
- Music 2
- Carnatic music 1
- Folk music 1
- Middle Eastern music 1
- Music of Bollywood 1
- Singing 1
- Sitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ahmad Zahir - Shab Haye Zulmani - Vol 3 | The low quality recording features a traditional song that consists of at least steel guitar melody, wooden percussive elements and flat male vocal singing over it. The recording is very noisy and the stereo image is unbalanced - pretty much destroyed. It sounds vintage. | 2012-01-17T03:43:14Z | Ahmad Zahir | 🙏 PLEASE SUBSCRIBE OUR CHANNEL ✅ FOLLOW US: 🇦🇫 @dmin Fraydoon Hakimi ► Facebook: https://www.facebook.com/afghanlatests ►Instagram: https://www.instagram.com/afghanlatest ► Twitter: https://twitter.com/afghanlatest Ahmad Zahir King of Afghanistan Music Ahmad Zahir 2020 Ahmad Zaher 2020 Ahmad Zahir 2019 Ahmad Zaher 2019 Ahmad Zahir 2018 Ahmad Zaher 2018 A * Ahmad Zahir * Ahmad Wali * Aryana Sayeed * Abdul Rahim Sarban * Amir Jan Sabori * Awalmir * Asad Badie * Aziz Herawi B * Bakht Zamina * Beltoon * Burka Band D * Dawood Sarkhosh E * Ehsan Aman * Elaha Soroor F * Farhad Darya * Farid Rastagar * Faiz Karizi * Farid Zaland * Fereshta Samah H * Hangama * Haidar Salim I * Jalil Zaland K * Khyal Muhammad L * Latif Nangarhari M * Mohammad Din Zakhil * Mozhdah Jamalzadah * Mohammad Hussain Sarahang * Mahwash * Mohammad Hashem Cheshti * Miri Maftun * Mangal * Mariam Wafa * Mohammad Din Zakhil N * Nasrat Parsa * Naghma * Nashenas * Naim Popal * Nainawaz * Nasrat Sharqi P * Parasto Q * Qamar Gula * Qader Eshpari R * Rafiq Shinwari * Rahim Mehryar * Rahim Bakhsh * Rezwan Munawar * Rishad Zahir S * Sardar Ali Takkar * Shah Wali * Soosan Firooz * Shakeeb Hamdard * Seeta Qasemi * Soheila Zaland * Saifo * Seema Tarana T * Tahir Shubab * Tawab Arash U * Ubaidullah Jan V * Vahid Soroor W * Wajiha Rastagar * Wahed Wafa Z * Zahir Howaida Ahmad Zahir Farhad Darya jawd sharif new qataghani 2012 jawid sharif yak qadam pesh Jawid Sharif Yak Qadam Pesh yak qandam pesh Yak Qadam Pesh jawid sharif Raminmansour production new qataghani jawid sharif new qataghani 2012 yak qadam pesh jawid sharif jawid sharif new song 2012 Jawid Sharif Unknown gunmen shot dead famous Pushto singer Ghazala Javed along with her father in the provincial capital of Khyber-Pukhtunkhwa Jawid Sharif new Qataghani 2012 Jawid Sharif new song 2012 Jawid Sharif Jawid Sharif Yak Qadam Pesh New Qataghani 2012 Jawid Sharif - Yak Qadam Pesh Fayaz Hamid-Dard e Dil New Song-Nov 2011 720p HD Mp4 Singer : Fayaz Hamid Song : Dard E Dil Lyrics By : Qahar Aasi Compo… | ["Carnatic music", "Music", "Middle Eastern music", "Music of Bollywood", "Sitar"] | ["low quality", "noisy", "unbalanced stereo", "muffled", "resonant", "steel guitar melody", "wooden percussive elements", "flat male vocal", "vintage", "traditional"] | 4 | fZyq2pM2-dI | 3961 | |
Farhad Shams Qarsak-e Panjsher and Sheen Khaale | The low quality recording features a traditional pop song that consists of a flat male vocal, alongside exciting background vocals, singing over claps, wooden percussive elements, groovy bass and acoustic guitar melody. It sounds energetic, addictive, fun and joyful - like something you would hear at more traditional parties. | 2013-03-18T17:13:05Z | StylezhooDB3o9 | Farhad Shams Qarsak-e Panjsher and Sheen Khaale Farhad Shams Qarsak-e Panjsher and Sheen Khaale | ["Singing", "Folk music", "Music"] | ["low quality", "pop", "traditional", "acoustic guitar melody", "wooden percussive elements", "clapping", "groovy bass", "flat male vocal", "exciting background male vocals", "wide", "energetic", "addictive", "fun", "joyful"] | 4 | qM8F6ECriRc | 4779 |
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;