musiccaps_details (view)
2 rows where musiccaps_aspects contains "devotional" and musiccaps_names contains "Classical music" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- carnatic music 2
- devotional · 2 ✖
- clapping 1
- classical singing style 1
- concert 1
- duel 1
- emotional 1
- enthralling 1
- fast tempo 1
- female singers 1
- flute countermelody 1
- ghatak 1
- guitar accompaniment 1
- heartfelt 1
- hindu deities 1
- indian classical 1
- jugalbandi 1
- male vocalist 1
- meditational 1
- melodic 1
- mridangam 1
- muffled audio 1
- passionate 1
- people cheering 1
- prayers 1
- ragas 1
- south indian classical 1
- sruti 1
- stage performance 1
- steady techno drumming rhythm 1
- stringed instrument countermelody 1
- stringed instrument harmony 1
- strong bass line 1
- tamil devotional songs 1
- violin 1
- vocal duel 1
- vocal duo 1
- vocal harmony 1
musiccaps_names (array) 5 ✖
- Carnatic music 2
- Classical music · 2 ✖
- Music 2
- Middle Eastern music 1
- Music of Asia 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Parvai ondre pothume - Carnatic Fusion Tamil Kannan Song by S. J. Jananiy | Female singers sing this vocal in Tamil harmony. The song is medium tempo with a strong techno drumming rhythm, guitar accompaniment, stringed instrument accompaniment, flute countermelody, and a strong bass line. The song is devotional and highly passionate. The song is a Carnatic Hindu devotional song sung in Tamil. | 2010-02-08T22:06:22Z | Saumi Music | Sharing another beautiful carnatic fusion sung by S.J. Jananiy. Follow us on Facebook: https://www.facebook.com/pages/Gnanalayam-Berlin/246868511997333 | ["Carnatic music", "Music of Asia", "Music", "Classical music"] | ["carnatic music", "female singers", "vocal harmony", "guitar accompaniment", "stringed instrument harmony", "emotional", "passionate", "meditational", "devotional", "heartfelt", "classical singing style", "vocal duo", "tamil devotional songs", "prayers", "flute countermelody", "guitar accompaniment", "stringed instrument countermelody", "strong bass line", "steady techno drumming rhythm"] | 1 | ROA6DMBPlNM | 2695 | |
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 |
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;