musiccaps_details (view)
2 rows where musiccaps_aspects contains "sitar" and musiccaps_aspects contains "south asian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- indian music 2
- sitar · 2 ✖
- south asian music · 2 ✖
- cheerful 1
- dance 1
- groovy rhythmic percussion 1
- group female vocals 1
- rhythmic percussion 1
- tabla 1
- tamil music 1
- traditional south asian music 1
- violins 1
musiccaps_names (array) 4 ✖
- Drum 1
- Folk music 1
- Percussion 1
- Tabla 1
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 |
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;