musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_author = 0, musiccaps_names contains "Happy music" and musiccaps_names contains "Music"

✎ View and edit SQL

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

CSV options: 

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;