musiccaps_details (view)
2 rows where musiccaps_aspects contains "sitar" and musiccaps_names contains "Folk music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- sitar · 2 ✖
- carnatic classical 1
- cheerful 1
- dance 1
- dreamy 1
- female vocal 1
- groovy rhythmic percussion 1
- group female vocals 1
- indian music 1
- sentimental 1
- south asian music 1
- tabla 1
- tamil music 1
- veena-like singing 1
- vibrant 1
musiccaps_names (array) 3 ✖
- Folk music · 2 ✖
- Carnatic music 1
- Music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jagadodharana | Sudha Raghunathan Songs | Carnatic Classical Music | Idea Jalsa | Art and Artistes | This is a Carnatic classical music piece. There is a female vocalist singing melodically while shifting her voice in a veena-like manner. The sitar is playing the melody and the tabla is playing the rhythm. There is a sentimental and dreamy atmosphere to this piece. | 2014-04-30T12:47:18Z | Art And Artistes | --- Click on SUBSCRIBE to get updates, and stay tuned for the richest collection of the Traditional Music of India. Concept: Durga Jasraj, follow her at: Facebook.com/DurgaJasraj Instagram.com/DurgaJasraj Twitter.com/DurgaJasraj Producers - Durga Jasraj & Neeraj Jaitly Label: Art and Artistes, follow us at: Facebook.com/ArtAndArtistes Instagram.com/ArtAndArtistes Twitter.com/ArtAndArtistes LinkedIn.com/ArtAndArtistes YouTube.com/ArtAndArtistes | ["Carnatic music", "Folk music", "Music"] | ["carnatic classical", "female vocal", "veena-like singing", "sitar", "tabla", "sentimental", "dreamy", "vibrant"] | 9 | 1JqNiV03kog | 258 | |
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 |
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;