musiccaps_details (view)
2 rows where musiccaps_aspects contains "violin", musiccaps_names contains "Carnatic music" and musiccaps_names contains "Classical music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- violin · 2 ✖
- calm 1
- carnatic music 1
- clapping 1
- concert 1
- devotional 1
- duel 1
- enthralling 1
- fast tempo 1
- ghatak 1
- hindu deities 1
- hindustani classical music 1
- indian classical 1
- jugalbandi 1
- male vocalist 1
- melodic 1
- mridangam 1
- muffled audio 1
- people cheering 1
- ragas 1
- relaxing 1
- south indian classical 1
- sruti 1
- stage performance 1
- tanpura 1
- vocal duel 1
musiccaps_names (array) 6 ✖
- Carnatic music · 2 ✖
- Classical music · 2 ✖
- Music 2
- Middle Eastern music 1
- Musical instrument 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chembai and Yesudas Shiva Shiva Shiva enarAdA - 2 of 3 | Two male vocalists sing this melodic Indian Classical music. The tempo is medium slow with Carnatic music accompaniments like violin, Ghatak and mridangam. The song is a good natured vocal duel between two carnatically trained vocalists. There is the sound of people cheering and clapping to the beat in the background. | 2010-03-04T07:13:39Z | Sunil Anandatheertha, PhD | This is a classic by "Chembai and Yesudas". In this concert, we get a rare chance to know the Guru-Sishya sambandha of these two great vocalists, wherein, Chembai is actually teaching Yesudas and Yesudas tries very hard to follow his Guru. :) http://vishnuiseverywhere.blog | ["Carnatic music", "Music", "Middle Eastern music", "Classical music"] | ["male vocalist", "fast tempo", "ghatak", "devotional", "hindu deities", "mridangam", "ragas", "sruti", "violin", "carnatic music", "indian classical", "south indian classical", "people cheering", "clapping", "jugalbandi", "duel", "vocal duel", "enthralling", "melodic", "muffled audio", "concert", "stage performance"] | 7 | GHyUAl9Yaos | 1708 | |
banTureeti kOlu - hamsanAdam - Adi | This is a style of Hindustani classical music performance which involves a calm and soothing musical performance. There is a male singer singing open-mouthed syllables. | 2006-11-19T10:05:38Z | Kumaran Nadesan | banTureeti kOlu - hamsanAdam - Adi - tyAgarAja TN Seshagopalan accompanied by TNS Krishna (backup vocals), SD Sridhar (violin), Mannargudi A Easwaran (mrudangam) and Neyveli B Venkatesh (kanjira) * Courtesy of S. Ranganathan and www.sangeethapriya.org ** To watch more clips, join http://www.youtube.com/group/karnatik | ["Singing", "Carnatic music", "Music", "Musical instrument", "Classical music"] | ["hindustani classical music", "violin", "tanpura", "calm", "relaxing"] | 3 | fTGZEmn3BY4 | 3949 |
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;