musiccaps_details (view)

1 row where musiccaps_aspects contains "healing" and "youtube_published" is on date 2015-04-17

✎ View and edit SQL

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

CSV options: 

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;