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"
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
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;