musiccaps_details (view)
2 rows where musiccaps_aspects contains "bhakti" and musiccaps_aspects contains "devotional" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- bhakti · 2 ✖
- devotional · 2 ✖
- tabla 2
- carnatic music 1
- classical music 1
- concert 1
- drone layer 1
- fast tempo 1
- female vocal 1
- ghatam 1
- hindu 1
- indian classical music 1
- live performance 1
- male vocalist 1
- medium-to-high pitch singing 1
- melodic layer 1
- minimalist music 1
- mridangam 1
- percussion layer 1
- raga 1
- religious 1
- sitar 1
- soloist 1
- south indian classical music 1
- south indian music 1
- spiritual 1
- sruti 1
- taal 1
- violin accompaniment 1
musiccaps_names (array) 5 ✖
- Carnatic music 1
- Drum 1
- Music 1
- Percussion 1
- Tabla 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Malakkuda 2012 - Kacheri By Thrikkodithanam Sachithanandan / Aalayal Thara Venam | A male vocalist sings this Classical song. The tempo is fast with animated ghatam, mridangam and tabla accompaniment and violin harmony. The vocals are classical notes and lyrics in a South Indian language. The song has three layers, the melody, percussion and drone. This song is a devotional Carnatic Classical song. | 2013-03-11T04:02:09Z | Poruvazhy Peruviruthy Malanada Temple | Poruvazhy Peruviruthy Malanada - The one and only Duryodhana Temple in South India | ["Tabla", "Drum", "Percussion"] | ["male vocalist", "fast tempo", "carnatic music", "soloist", "classical music", "indian classical music", "south indian music", "south indian classical music", "ghatam", "mridangam", "violin accompaniment", "tabla", "raga", "sruti", "taal", "concert", "live performance", "melodic layer", "percussion layer", "drone layer", "minimalist music", "bhakti", "devotional"] | 7 | mx7kjFY7ALs | 4505 | |
Shri Durga Stuti Paath Vidhi By Anuradha Paudwal [Full Song] - Shri Durga Stuti | This is a Hindu music piece. There is a female vocalist singing at a medium-to-high pitch in a devotional manner. A sitar provides a melodic background. The tabla is being played in the rhythmic background. The atmosphere is spiritual. This piece could be played at religious events and online content related to Hindu religion. | 2011-05-23T12:48:02Z | T-Series Bhakti Sagar | #AnuradhaPaudwal Song: Shri Durga Stuti Paath Vidhi Title: Shri Durga Stuti Singer: Anuradha Paudwal Music Director: Shekhar Sen Lyricist: Pandit Chama Lal Bhardwaj Chaman, Music Label: T-Series If you like the video Please don't forget to share with others. Please share you views. Click To Subscribe: http://www.youtube.com/tseriesbhakti Facebook: http://www.facebook.com/tseriesmusic Twitter: http://www.twitter.com/_Tseries If You like the video don't forget to share with others & also share your views. Stay connected with us!!! ► Subscribe: http://www.youtube.com/tseriesbhakti ► Like us on Facebook: https://www.facebook.com/BhaktiSagarTseries/ ► Follow us on Twitter: https://twitter.com/tseriesbhakti For Spiritual Voice Alerts, Airtel subscribers Dial 589991 (toll free) To set popular Bhakti Dhun as your HelloTune, Airtel subscribers Dial 57878881 facebook: https://www.facebook.com/BhaktiSagarTseries/ | ["Carnatic music", "Music"] | ["hindu", "female vocal", "medium-to-high pitch singing", "sitar", "tabla", "bhakti", "spiritual", "devotional", "religious"] | 9 | cS2gRhH6it4 | 3707 |
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;