musiccaps_details (view)
2 rows where musiccaps_author = 8 and musiccaps_names contains "Tabla"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
musiccaps_names (array) 3 ✖
- Percussion 2
- Tabla · 2 ✖
- Drum 1
youtube_published (date) 2 ✖
- 2007-06-11 1
- 2007-08-07 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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;