musiccaps_details (view)
1 row where musiccaps_aspects contains "devotional music", musiccaps_aspects contains "live performance", musiccaps_aspects contains "slow tempo po" and musiccaps_author = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|
Classical Instrumental (Fusion) - Raag Madhuvanti - Ateetam - Tabla|Sitar|Flute|Keyboard | The song is an instrumental. The tempo is slow with an Indian flute or bansuri playing soulfully to the keyboard accompaniment, sitar accompaniment and a tabla player waiting to join in. The music is soulful and emotional. The audio quality is poor. | 2015-04-17T11:38:44Z | Geethanjali - Indian Classical Music | Madhuvanti Raaga - Madhuvanti is the name of a raga used in Indian classical music. It is a Hindustani music raga, which is reported to have been borrowed into Carnatic music, and is structurally similar to Multani. This Raag is based on Kalyan Thaat(Mode).It is a romantic raga based on the foundation, eternity and colors of love. Madhu literally means honey. It is a very sweet raga with a very simple philosophy of love and romance. Sounds of Traditions Past, Energies of Momentous Present, and Imaginations of Futures Beyond, the musical creations of ATEETAM. The music of India includes multiple varieties of folk music, pop, and Indian classical music. India's classical music tradition, including Hindustani music and Carnatic, has a history spanning millennia and developed over several eras. Music in India began as an integral part of socio-religious life. PERCUSSIONS - VENKY D C SITAR - B. SIVARAMAKRISHNA RAO FLUTE - SHAKTHIDHAR V R KEYBOARD, AUDIO MIXING & MASTERING - VARUN PRADEEP GUEST ARTISTS - ANWAR MANUEL ALAM, JYOTSNA SRIKANTH, MANJUNATH N S & ANIL C J | ["Wind instrument, woodwind instrument", "Flute"] | ["hindustaani music", "flute solo", "bansuri", "meditational", "devotional music", "fusion music", "slow tempo", "keyboards accompaniment", "tabla percussion", "instrumental music", "slow tempo po", "traditional indian instruments", "soulful", "romantic passionate", "range of emotions", "live performance", "live audience", "youtube music video", "healing", "heartfelt", "sitar accompaniment"] | 1 | rW5YKFsiWM8 | 4883 |
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;