musiccaps_details (view)

1 row where musiccaps_aspects contains "no other instruments", musiccaps_aspects contains "shofar sound" and musiccaps_names contains "Wind instrument, woodwind instrument"

✎ 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
הרב ניסים פרץ - תוקע בשופר בסליחות אלול תש"ע This is the sound of a shofar, a bugle-like instrument. It is blown by a person using the lips. This shofar music is playing only one note. There are no other instruments in this song. There is no voice in this song. This song is used for religious purposes. 2011-01-12T13:53:25Z רפאל רחמים לסרטונים נוספים בקרו ב- http://sites.google.com/site/rabbinissimperetz תקיעת שופר בסליחות באשמורת הבוקר אלול תש"ע בכולל הוראה של מוסדות התורה בית-אל בני ברק ע"י ראש המוסדות מו"ר הגה"צ הרב נסים פרץ זצוק"ל. צילום ועריכה - רפאל רחמים. ["Wind instrument, woodwind instrument", "Shofar"] ["shofar sound", "jewish instrument", "religious sound", "no other instruments", "no voice", "instrumental"] 0 pVfV09CDmus 4714

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;