musiccaps_details (view)

1 row where musiccaps_aspects contains "harmonium", musiccaps_aspects contains "male voice" and musiccaps_author = 0

✎ 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
Music of Dharwad - Pt Venkatesh Kumar Sings Gaud Malhar This classical Indian song features a male voice singing in vocables without any lyrics. This is accompanied by a harmonium playing the same melody as the voice and continuing to play after the voice has rested. Sitars are playing in the background. There is no percussion in this song. This song can be played in a retro movie in which a classical singer is performing in front of a live audience. 2012-06-02T07:54:35Z havanurmic Pt M Venkatesh Kumar stands tall among the leading Hindustani vocalists today and carries forward the musical traditions of Dharwad with distinction. The Gwalior-Kirana gayaki of Pt Panchakshari Gavai and Pt Puttaraja Gavai continues to live thanks to his dedication. Pt Venkatesh Kumar's voice is deep and vibrant, so is his music. His soulful singing and robust ragadari have earned him the respect of listeners as well as critics. Besides being a popular concert performer he is also an outstanding teacher, author and head of the music department at Karnataka University, Dharwad. Venkatesh Kumar was born in the hamlet of Lakshmipura in Bellary district. His father was a leather puppeteer and an accomplished folk singer. Though the parents were too poor to think of a musical career for their gifted son, his maternal uncle recognised young Venkatesh's talent and took him to Veereshwara Punyashrama in Gadag, run by Pt Puttaraja Gavai. The senior gavai was physically blind but was a visionary when it came to music. Venkatesh Kumar groomed himself rigorously under him for over 12 years and emerged as a thinker musician. "Chintana as my guru would say, is most important. There is a tradition and there are these maestros. I had to find a path between these two, without messing with tradition. Long hours of practice and thinking have come to my rescue." Here he sings the monsoon melody Gaud Malhar, accompanied by Shri Udayaraj Karpur on tabla and Shri Ravindra Katoti on harmonium ["Singing", "Music", "Musical instrument", "Sitar"] ["classical indian song", "harmonium", "male voice", "sitar", "no percussion", "vocables", "no lyrics"] 0 AVmJF1uaRuE 1127

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;