musiccaps_details (view)
5 rows where musiccaps_aspects contains "sitar" and musiccaps_author = 3
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Vamsam - Tamil Serial | Episode 556 | 02/05/2015 | This is a traditional south asian dance song with a cheerful affect. We have a group of female singers singing in unison - a melody that matches with the one being played on the sitar. | 2015-05-02T16:00:00Z | Vision Time Tamil | Will Madan succeed in brainwashing Supriya to get married to him and will Archana be able to stop this marriage in time by arresting Madan for killing Bhoomika? Is Bhoomika really dead or alive?? Keep watching this space for more updates on your favorite serial VAMSAM. Cast: Ramya Krishnan, Sai Kiran, Vijayakumar, Seema, Vadivukkarasi | ["Folk music"] | ["south asian music", "indian music", "tamil music", "dance", "group female vocals", "sitar", "groovy rhythmic percussion", "cheerful"] | 3 | 5aCDam9_Ps4 | 671 | |
| R Nikpai In Ghazi Stadium Kabul | This is a traditional south asian song featuring the use of a pair of tablas for percussion, violins and a sitar. On the sitar, a rapid ascending melody is played in eighth notes. The song is played at a medium tempo and suitable for some energetic dancing. | 2008-08-29T12:22:40Z | Aziz Afghan | Watch Rohullah Nikpai in Ghazi Stadium Kabul among his people | ["Tabla", "Drum", "Percussion"] | ["tabla", "rhythmic percussion", "violins", "sitar", "south asian music", "indian music", "traditional south asian music"] | 3 | BTMWpYzpu5g | 1243 | |
| Sounds of Isha - Amla | Yoga Padhi | Meditative music | Instrumental | The clip is of traditional eastern sounds that would be found in India. We hear notes being played on a sitar, as well as an acoustic guitar. There's also a sustained buzzing instrument in the background which creates a relaxed atmosphere. | 2013-04-02T05:34:47Z | Sounds of Isha | Download this album here: https://www.ishashoppe.com/downloads/portfolio/yoga-padhi/ This is a unique compilation of music that by its own rhythm initiates a step into yoga, ‘Yoga Padhi.’ The music was created with the sole purpose of setting an atmosphere most conducive to receive the offerings of Isha Yoga. The instrumental vibrations that resound from the melodious melange of flute, guitar, sitar, veena, gatam and tribal drums instill a sense of dynamic peace that naturally eases the listener into a meditative state. ‘Yoga Padhi’ has already enchanted thousands of people around the world during Isha Yoga programs. Available for the very first time to a wide spectrum of listeners, the melodies convey joy and tranquility, creating a receptivity that will bring you a step closer to the Silence within. Follow us: https://www.facebook.com/soundsofisha http://isha.co/soundsofishadownloads https://www.twitter.com/soundsofisha https://www.soundcloud.com/soundsofisha http://isha.co/Gaana http://isha.co/Saavn http://isha.co/Itunes Isha Foundation is a non-religious, not-for-profit, public service organization, which addresses all aspects of human well being. http://www.ishafoundation.org/ Learn more about Sadhguru http://www.isha.sadhguru.org | ["Music", "Sitar"] | ["traditional south asian music", "eastern music", "sitar", "tranquil", "relaxing", "peaceful", "medtiation music", "sustained buzzing sound", "acoustic guitar arpeggio"] | 3 | Fh53p0Tnnxg | 1661 | |
| Sitar シタールの魅力 ヨシダダイキチ yoshidadaikiti | This is a recording of one note being played on the guitar, followed by some string bending. There is then a dialogue between male Japanese speakers. | 2010-12-29T19:42:40Z | JE55IC44 | シタール奏者 ヨシダダイキチさん http://www.yoshidadaikiti.com/ https://twitter.com/#!/yoshidadaikiti http://www.myspace.com/yoshidadaikiti ウスタッド・シュジャート・カーン/ustad shujaat khanに師事 | ["Music", "Musical instrument", "Speech", "Plucked string instrument", "Sitar"] | ["sitar", "string bend technique", "japanese dialogue", "japanese speaking", "live recording"] | 3 | OoJGMj5H7Wk | 2470 | |
| GREAT BEENKARS-Swami Parvatikar-raag pilu pahadi. | In this recording we hear two main instruments - the sitar and the tabla. The sitar player plays some simple and slow licks, in an emotive way. The tabla player plays a simple rhythm to support the sitar. The recording is an old recording - and this is a vintage south asian music piece. | 2011-09-19T13:27:35Z | thuryina | Swami Dattatreya Rama Rao Parvatikar,lived between 1916-1990 .he was a wandering sanyasi who hardly spoke to anybody.he innovated what is known as dattatreya veena,which had the features of veena sitar and swarmandal.he created his own style combining carnatic and Hindustani styles.this piece is from the unesco collection,anthology of Indian classical music created by alan danielou.movie made by purnabhat | ["Tabla", "Drum", "Percussion"] | ["sitar", "tabla", "sitar licks", "sitar arpeggio playing", "tabla", "vintage recording", "traditional south asian music", "indian music", "simple tabla rhythm"] | 3 | YvT7qFbUOO0 | 3322 |
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;