musiccaps_details (view)

2 rows where musiccaps_aspects contains "calming", musiccaps_aspects contains "no voice" and musiccaps_names contains "Music"

✎ 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
Best of Mandolin U Srinivas Vol 1 | Carnatic Classical Instrumental The Indian traditional music is purely instrumental, there is no voice. All instruments used are from Indian culture. A sitar one-note harmonic pedal can be heard throughout the music excerpt. The atmosphere is somewhat calming, meditating. 2014-09-20T08:11:12Z INRECO Carnatic Songs Uppalapu Srinivas (Telugu: ఉప్పలపు శ్రీనివాస్; 28 February 1969 – 19 September 2014) was an Indian mandolin player and composer of the Carnatic musical tradition of Southern India. A child prodigy, he made his debut in 1978, and came to be popularly known as Mandolin Srinivas. Over the next four decades, he toured across the world, and collaborated with ohn McLaughlin,Michael Nyman, and Michael Brook. Srinivas was born 28 February 1969, in Palakol in Andhra Pradesh. At the age of six he picked up his father U. Satyanarayana's mandolin, after he heard it played at a concert he attended with his father. Upon realising the talent of his son, his father who had studied classical music, bought him a new mandolin, and started teaching him.He started with the acoustic mandolin, though later he switched to the electric mandolin as he felt it allowed making long notes clearly audible. He was the first musician to use electric mandolin in Carnatic music, he even modified a difficult electric western instrument, using five strings instead of traditional eight, to suit the Carnatic pitch, raga system, and especially gamakas, and nuanced oscillations. He was awarded the Padma Shri in 1998 by Government of India, and the Sangeet Natak Akademi Award in 2009. He was a follower and devotee of Sri Sathya Sai Baba and he had performed before him on several occasions. Track List: 1. Maha Ganapathim 00:00 2. Nee Paadame 09:09 3. Yaaro Ivar Yaaro 19:07 4. Ranjani Niranjani 22:47 5. Bhavanutha 28:04 6. Krishna Nee Begane Baaro 47:14 7. Kuzhaloodhi 52:20 ==Track Details== Track - Maha Ganapathim Artist - Mandolin U.Srinivas Lyr & Comp - Dikshitar Track - Nee Paadame Artist - Mandolin U.Srinivas Lyr & Comp - G. N. Balasubramaniam Track - Yaaro Ivar Yaaro Artist - Mandolin U.Srinivas Lyr & Comp - Arunachala Kavirayar Track - Ranjani Niranjani Artist - Mandolin U.Srinivas Lyr & Comp - G. N. Balasubramaniam Track - Bhavanutha Artist - Mandolin U.Srinivas Lyr & Comp - Thyagaraja Track - Krishna Nee Begane Baaro Artist - Mandolin U.Sr… ["Carnatic music", "Music", "Mandolin", "Sitar"] ["instrumental", "no voice", "sitar", "indian traditional music", "calming", "meditating"] 2 5JkPsWsq3E8 652
Relaxing Harp Instrumental Christian Music The instrumental music features a harp playing a combination of melody and accompaniment. In the background one can hear a synth pad providing harmony throughout the music excerpt. The message of the song seems romantic and the atmosphere is calming. 2014-04-11T20:46:55Z okcSDRmedia   ["Christmas music", "Gospel music", "Music"] ["harp", "synth pad", "romantic", "calming", "instrumental", "no voice"] 2 FKChZXXhufE 1636

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;