musiccaps_details (view)
1 row where musiccaps_aspects contains "groovy tabla percussion", musiccaps_names contains "Percussion" and "youtube_published" is on date 2010-07-06
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 |
---|---|---|---|---|---|---|---|---|---|---|
Ustad Younas Khan 'Joona ' Tabla legend of Lahore | The low quality recording features a groovy tabla percussion playing. The recording is noisy and in mono. | 2010-07-06T04:51:47Z | Asarulislam | Ace Tabla player of Pakistan Ustad Younas Khan Joona, a maestro of Tabla, came from a family of musicians and percussionists. He lived in Mohalla Dhup Sari, Mozang Lahore. He was highly respected in the circle of musicians of Lahore. He was classically trained and lived a humble life. Returning from a musical performance in Sialkot, Ustad Joona was killed in a car accident near Muridke on June 17, 2010. He is survived by his four sons. His eldest son Naveed Hussain Joona is a celebrated Tabla player of Pakistan and won the first prize in Tabla in the All Pakistan Tabla Sangat 2009. The Sangat was organized by Ustad Altaf Hussain Khan Tafoo who was the judge in this Sangat competition. Ustad Younas Khan taught Tabla to young musicians of Lahore. He took Zain Syed of Berkeley California under his tutelage in 2003. This video is Zain Syed's homage to his master. | ["Tabla", "Drum", "Percussion"] | ["low quality", "noisy", "mono", "groovy tabla percussion"] | 4 | mOmYcOBqhwo | 4466 |
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;