musiccaps_details (view)
2 rows where musiccaps_author = 8 and musiccaps_names contains "Tabla" sorted by youtube_link
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 14 ✖
musiccaps_names (array) 3 ✖
- Percussion 2
- Tabla · 2 ✖
- Drum 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ekkadi Manusha Janmam? (Annamacharya song) | Hand percussion accompanies a male singer and violin doubling a melody with a constant regular rhythm. Mood is hypnotic and trance inducing. Features additive rhythms and odd meters. | 2007-06-11T23:00:23Z | musiquebox | Prince Rama Varma renders an eloquent Annamacharya composition in the Raaga Revagupti at NGMA Mumbai. He is accompanied on the violin by Shri Madhavan and on the mridangam by Shri Ganesh. | ["Tabla", "Percussion"] | ["hand percussion", "male singer", "regular rhythm", "violin", "violin doubling singer", "hypnotic", "trance inducing", "additive rhythm", "odd meter"] | 8 | w_XFNKSRgKI | 5276 | |
Hare Krishna Sivananda (1 of 2) | Tablas and accordion lead a coed group chant with a male lead singer. Sounds spiritual. | 2007-08-07T23:29:23Z | Raymond Falcon-Lugo | In Ashram (Canada) 2003 Second part added in Jan 7, 2009 !! (See "Video Response") | ["Tabla", "Drum", "Percussion"] | ["coed group chanting", "spiritual", "tabla", "accordian", "male vocalist lead"] | 8 | InKK8z21UYo | 1939 |
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;