musiccaps_details (view)
1 row where musiccaps_aspects contains "arpeggiated plucked strings melody", musiccaps_aspects contains "echoing female vocal" and musiccaps_aspects contains "mystical"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Classical Music; concluding part | The low quality recording features a live performance of a traditional song and it consists of an echoing female vocal singing over breathy woodwind melody and arpeggiated plucked string melody. It sounds passionate, soulful and mystical, even though the recording is noisy. | 2011-07-22T14:55:51Z | KhyberWatch | Peshawar, Singer Humaira Naaz, Asfandyar Moomand and Gulzar Alam are performing at Baacha Khan Markaz where selected audience was gathered to listen to the classical show of AMN web tv. Also see; ,Bacha Khan, Baacha Khan, Wali Khan, Asfandyar Wali Khan, Mahmoud Khan Achakzai, Mahmood Khan, Khushal Khan Khattak, Ghani Khan, Pakhtunkhwa, Pashtoonkhwa, Pukhtoonkhwa, ANP, PkMPA, PkSF, Peshawar, Mardan, Rustam, Sawabi, Swabi, Kohat, Swat, Malakand, Buner, Karak, Waziristan, Chitral, Pakistan, Kabul, Kandahar, Qandahaar, Pakhtun Girl, Pakhtun women, KhyberWatch, Shamshad tv, AVT Khyber, Award Show, New Show, Khyber, Musafar, Pashto Music, Pashto Ghazal, Pashto Music, Pashto Song, 2009, 2010, 2011, 2012, Pushto, Pakhtu, Khan, Irfan Khan, Khalid Malik, Shoukat Mahmoud, Ashraf Gulzar, Hashamat Sahar, Maas Khan, Ghazala Javed, Ghazala Jawed, Janas Khan, Sarfaraz, Zeek Afridi, Mudassir Zaman, Bakhtiar Khattak, Hamayoun Khan, Hamayoon Khan, Pashto Singers, Nazia Iqbal, Saima Naaz, Saima Naz, Salma Naz, Rabia Tabassum, Noor Jehan, Asma Lata, Aasma lata, Raheem Shah, Arooj Mohmand, Moomand, Farzana, Farzana Naz, Naghma, Musarrat Mohmand, Muskaan, Muskan, Faza Fayaz, Fayaz Kheshki, Shabnam | ["Traditional music", "Music", "Classical music"] | ["low quality", "echoing female vocal", "breathy woodwind melody", "arpeggiated plucked strings melody", "mystical", "soulful", "passionate", "noisy"] | 4 | QrJVAHIkpCo | 2643 |
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;