musiccaps_details (view)
2 rows where musiccaps_aspects contains "sitar", musiccaps_names = "["Carnatic music", "Music", "Sitar"]" and musiccaps_names contains "Carnatic 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 |
---|---|---|---|---|---|---|---|---|---|---|
Relaxing sitar music Ravi Shankar | This is an instrumental sitar music piece. The sitar is being played at a medium-to-high range. There is a calming and relaxing atmosphere to this piece. This piece can be used in the background of a meditation video. It could also be played during a meditation session at a course. | 2013-04-21T03:11:58Z | MelanieMoonbeams | **I do not own this** Beautiful sitar music played by Ravi Shankar. Enjoy! Rest in peace Ravi Shankar. You were a gift to the world. | ["Carnatic music", "Music", "Sitar"] | ["sitar", "no singer", "instrumental", "single instrument", "medium-to-high range", "transcendental", "relaxing", "calming", "meditation"] | 9 | -f1DNyngKVY | 71 | |
Carnatic music concert of Kalaimamani Shri. K R Kedaranathan | The track fits the carnatic music genre from India. A male vocalist sings with a sharp and nasal voice. The ambience melody is made with a sitar that has a rough and sharp sound. The atmosphere is mystical and traditional. | 2007-12-06T13:29:06Z | venkatkedhar | Shri. K.R. Kedaranathan is the senior most disciple of Sangeetha Kalanidhi Sangeetha Pithamah Semmangudi Shri R. Srinivasa Iyer. This concert was his last solo concert given in Podhigai TV. Accompanying are Shri. Parur M S Anantharaman on violin & Shri Kalakkadu Srinivasan on Mridangam. | ["Carnatic music", "Music", "Sitar"] | ["carnatic music", "indian folk", "sharp male vocals", "traditional music", "mystic", "sitar"] | 5 | ZMd8mAKe-k8 | 3368 |
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;