musiccaps_details (view)

1 row where musiccaps_aspects contains "amateur recording", musiccaps_names contains "Carnatic music", musiccaps_names contains "Folk music" and musiccaps_names contains "Sitar"

✎ 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
SANDHRA NEBU DEBUT PERFORMANCE IN CARNATIC MUSIC -SWAGATM KRISHNA This carnatic song features a female voice singing the main melody. This is accompanied by percussion played on the ghatam. A violin plays a melody matching the vocal melody. A morsing is played in the background. Other instruments are not clearly audible due to the low quality of recording. This song can be played in a religious gathering. 2013-04-01T17:04:50Z V S mob: 9446528452 https://www.youtube.com/watch?v=v2LhFEOX5aQ Swagatham Krishna By OOthukadu Venkata Subba iyer Raga Mohana Tala Aadi Ootthukkadu Venkata Kavi (c.1700 - 1765 CE) was a prominent composer in Indian classical Carnatic music. He lived in South India in the present-day state of Tamil Nadu. Also known by the name Oothukkadu Venkatasubba Iyer, he composed hundreds of compositions in Sanskrit, Tamil and Marathi of which over 500 are available. His works scarcely contain autobiographical notes and show that he had reached great spiritual and philosophical heights. His works also reveal the proximity he felt towards God and show his deep devotion. Alai Payuthe Kanna IS ANOTHER FAMOUS CREATION Pallavi swaagatam krishha saranaagatam krishnaa madhuraapuri sadanaa mridu vadanaa madhusoodana iha Anupallavi Boga Thaptha sulabha supushpa gandha kalapa, Kasthuri thilaka mahitha mama kantha nanda gopa Kandha Charanam Mushtikasura Chanoora malla , Madhu soodhana , Kuvalayapeeda, Mardhana, Kalinga narthana , Gokula Rakshana , Sakala sulakshana, Deva sishta jana pala , Sankalpa kalpa , kalpa satha koti samprabhava, Dheera , Muni jana vihara . Madana sukumara , Daithya samhara, deva, Madhura madhura rathi sahasa , sahasa Vruja yuvathi jana manasa poojitha. English translation BY P.R.Ramachander Pallavi Welcome to you Krishna, Surrender to you Krishna He who lived in Mathura, He who has a tender face, He who killed Madhu Anupallavi He who is hot with passion, he who is easy to get, He who is like a flower, He who apples sandal paste, He who puts musk Thilaka, He who is honoured, He who is my lord and baby son of Nanda Gopa. Charanam Killer of Madhu, wrestlers Mushtika and Chanoora and elephant Kuvalayapita, He who danced on Kaalinga, He who saved Gokula, He who has all good signs, H who looked after devas and good people, He who created time just by thought, He who is powerful in hundred crores of eons, He who is brave, He who lived with sages, He who is pretty God of love, He who killed Asuras,… ["Carnatic music", "Folk music", "Music", "Sitar"] ["amateur recording", "low quality audio", "female voice", "traditional song", "carnatic song", "violin", "ghatam", "morsing"] 0 QXe9BpTENCc 2625

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;