musiccaps_details (view)
3 rows where musiccaps_aspects contains "indian classical" and musiccaps_names contains "Musical instrument"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Daud Khan Sadozai - live - 2013 | This music is a mellifluous Indian classical instrumental. The tempo is fast with a harmonic sarod and rhythmic Oud accompaniment. The music is mesmerising, spirited, engaging, captivating and skilfully rendered Ragas. This instrumental is an Indian/Pakistani classical music. | 2013-02-10T17:18:05Z | soon4ward | Daud Khan live 26-01-2013 in Hagen, Germany. Daud Khan Sadozai - Robab, Sarod Efren Lopez - Robab, Oud Yma Karin / Shekab Wadwa- Tabla | ["Tabla", "Traditional music", "Guitar", "Music", "Musical instrument", "Percussion"] | ["instrumental", "medium tempo", "sarod harmony", "oud", "hindustani music", "indian classical", "stringed instrument", "lute", "pakistani music", "mesmerising", "engaging", "skilful musicians", "raga", "sympathetic strings", "sliding pitches", "indian classical instruments"] | 7 | ALU-1AILj1c | 1107 | |
| 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 | |
| Taj Mahal Tea presents E-baithak, India’s biggest classical concert. | This music is an Indian classical instrumental. The tempo is fast with an animated Sitar lead, supported with rhythmic beats of lively tabla and dholak , along with a soft and subtle keyboard accompaniment. The music is upbeat, vibrant, vivacious, vigorous , engaging and captivating. This instrumental is a Hindustani classical. | 2014-12-19T12:37:54Z | Taj Mahal Tea | Experience Indian Classical Music at its best with E-baithak, India’s biggest classical concert featuring the maestro Niladri Kumar and hosted by the gorgeous Madhuri Dixit. We are sure that this experience will make your heart say ‘Wah Taj!’ | ["Music", "Musical instrument", "Plucked string instrument", "Classical music", "Sitar"] | ["instrumental", "fast tempo", "lively sitar", "hindustani music", "dexterous", "skilled", "hindustani classical", "spirited tabla", "vivacious", "vibrant", "energetic dholak", "indian percussions", "indian string instrument", "indian classical", "raga", "taal", "subtle keyboard harmony", "vigorous", "engaging", "captivating"] | 7 | nUs5SJyQPnM | 4544 |
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;