musiccaps_details (view)
1 row where musiccaps_aspects contains "ensemble of vocalists", musiccaps_aspects contains "indian classical" and musiccaps_aspects contains "raga"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Learn a carnatic composition | Krithi - Bhajare Gopalam - HIndolam | Online Carnatic Vocal Classes | This is an Indian classical duet. The tempo is slow with the ensemble of vocalists singing this melody in harmony to the rhythm of tanpura and keeping count by tapping. The song is a composition of Ragas, tala and Sruti . It is melodic, engaging, skilled, controlled and pleasing. This song is an Indian Carnatic Classical. | 2013-03-26T14:51:09Z | Acharyanet | This is an excerpt. The full lesson is available on www.acharyanet.com, use the search tool to find this lesson on the Acharyanet. Join the subscription along with thousands of other learners to become a member and enjoy unlimited learning of hundreds of lessons taught by renowned gurus, from the comfort of your home, at your own pace. Acharyanet.com is the leading online resource for learning Carnatic Music from top Gurus. Find comprehensive video lessons recorded in live classrooms and learn in-depth from basics to advanced topics. Visit https://streaming.acharyanet.com to know more. If you have any doubts regarding these ragas or lessons or want more personalized training, email Acharyanet at support@acharyanet.com and we will schedule online or live sessions with our Faculty. Lessons are taught in a comprehensive manner with an emphasis on fundamental concepts and introduction to raga phrases with numerous tips for practising with the right methodology. Email: support@acharyanet.com Facebook: https://www.facebook.com/Acharyanet Twitter: https://twitter.com/acharyanet Blog: https://blog.acharyanet.com | ["Carnatic music", "Music", "Musical instrument", "Classical music"] | ["classical song", "indian classical", "classical duet", "vocal backup", "south indian classical music", "carnatic", "taal", "raga", "ancient music", "melodious", "chanting", "kriti", "sruti", "musical notes", "ensemble of vocalists", "tanpura rhythm", "tapping"] | 7 | W-nkxlYTdV4 | 3052 |
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;