musiccaps_details (view)
2 rows where musiccaps_aspects contains "chant", musiccaps_aspects contains "meditative" and musiccaps_names contains "Music"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Ganesh Puja Aarambh | A male vocalist sings this gentle Puja song. The tempo is slow with atmospheric synthesiser, chimes, keyboard harmony and electronic arrangements to give an intense, ethereal, celestial vibe. The song is a Sanskrit chant, melodious prayer, and devotion song. It is soothing, calming, meditative, prayerful, reflective and pensive. | 2009-08-06T18:23:59Z | sacredverses | Shlokas from complete Ganesh Puja performed by Pundit Rajendra Kimothi, Ph.D. Track: Puja Aarambh Artist: Pt. Rajendra Prasad Kimothi, Ph.D. Album: Ganesh Puja Download links: http://www.amazon.com/Ganesh-Puja/dp/B00A14SHAK/ http://www.amazon.co.uk/Ganesh-Puja/dp/B00A13LXFM/ http://music.ovi.com/in/en/pc/Product/Pandit-Rajendra-Prasad-Kimothi/Ganesh-Puja/15277030 Buy CD: http://www.flipkart.com/ganesh-puja-music/p/itmd7vh9u5yfsyzc Just as Om is the Vedic mantra which is added to the beginning of every shloka, similarly, one must do the puja of Lord Ganesh before one does the puja of any other God. This is a boon granted to Lord Ganesh by Lord Shiva himself! The names used to refer to Lord Ganesh include the following: Vakratunda - one with a twisted trunk. Mahakaya- one with a huge body. Koti Surya Samaprabham - one who shines like ten million stars. Vighnaharta - one who removes all the obstacles. Riddhidayak - one who has the ability to grant great wealth. Siddhidayak - one who has the ability to grant all wishes. According to Narad Puran, "...those students who desire knowledge, or those people who desire wealth, or those who have no progeny but desire children, will have their wishes and desires granted by doing the puja of Lord Ganesh." "OM GAN GANPATAYE NAMAH." | ["Carnatic music", "Mantra", "Music"] | ["male vocalist", "slow", "pensive", "contemplative", "reflective", "devotional", "reverence", "tempo", "ethereal", "celestial", "indian morning prayer", "hindu prayer", "festivals", "indian festival", "hindu festivals", "mantras", "atmospheric synthesiser", "auto tune", "electronic instrumentation", "chant", "indian classical", "worship", "devotion", "sanskrit", "sanskrit chant", "ambient", "meditative", "prayerful", "chimes", "surround sound", "keyboard hamony", "puja"] | 7 | AzWIKyRnhG8 | 1188 | |
| Maha Mantra Hare Krishna | A female vocalist sings this pleasant chant. The song is medium fast tempo with groovy basslines, mellifluous flute, steel pan beat,small hand cymbals and synthesiser arrangement. The song is sweet, melodic, hypnotic, enthralling, enigmatic, trance-like, trippy and psychedelic. This song is a contemporary indian worship song. | 2010-06-28T19:06:46Z | Nettan Von Pavarga | Hare Krishna mantra sung by Krishna Premi Krishna Premi (ACBSP) from her album "Nectar of the Holy Name". | ["Mantra", "Folk music", "Music", "Middle Eastern music", "Song"] | ["female singer", "medium fast tempo", "enigmatic", "hypnotic", "trance", "contemporary", "synthesiser arrangements", "flute melody", "small hand cymbals", "groovy bass lines", "keyboard accompaniment", "steel pan percussion", "synthesiser arrangement", "psychedelic harmony", "chant", "meditative", "indian classical", "puja", "devotional", "catchy riff", "melodious", "contemporary", "indian god", "worship"] | 7 | tdrz4EkIsow | 5055 |
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;