musiccaps_details (view)
1 row where musiccaps_aspects contains "call and response", musiccaps_aspects contains "moderate tempo" and musiccaps_aspects contains "tabla"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Hebrew Chanting - Sacred Jewish Music | This song starts with a male narrator speaking a line. This is followed by a female voice singing the main melody and each line is repeated by male and female voices. This song has a repetitive melody. This song has a call and response pattern. This is accompanied by an acoustic guitar playing chords and riffs at the end of lines. The percussion is played on a tabla. This song has a religious chant feel. This song can be played in a religious gathering. | 2007-03-11T19:02:36Z | Eyal Rivlin | Featuring Danya Rivlin (Vocals), Eyal Rivlin (Vocals and guitar), Michelle Wolf (Vocals), and Stephan Bross (Tabla). Knows as the band Temple, they released their CD "Coming Home" with Sounds True. Based in Boulder, CO and blending world music, Kabbalah, and Kirtan, with the ecstatic styles of Deva Premal, Krishna Das, Jai Uttal, and Snatam Kaur. | ["New-age music", "Music", "Middle Eastern music", "Speech", "Happy music"] | ["religious chanting", "acoustic guitar", "tabla", "female main voice", "male and female voices", "moderate tempo", "call and response", "gospel feel", "male narrator voice"] | 0 | 2zrPFxxT1VM | 429 |
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;