musiccaps_details (view)
2 rows where musiccaps_aspects contains "jewish instrument" and musiccaps_names contains "Wind instrument, woodwind instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- jewish instrument · 2 ✖
- amateur recording 1
- instrumental 1
- natural reverb 1
- no other instruments 1
- no percussion 1
- no voice 1
- religious instrument 1
- religious sound 1
- shofar 1
- shofar sound 1
youtube_published (date) 2 ✖
- 2010-04-18 1
- 2011-01-12 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Linda playing sounding blowing Shofar in Israel Part 2 of 2.f4v Jerusalem Israel expert rams horn | This amateur recording features a shofar being played. It sounds like a bugle. The melody starts on a low note followed by a higher note and alternates the same with a long ring of the high note. It is played in a place with a lot of reverb. There are no other instruments in this song. There are no voices in this song. This can be played in a movie scene just before a war. | 2010-04-18T01:08:56Z | WonByHim | Blowing Shofar all over Israel in 2009. trip to Israel Feb/Mar 2009. antelope horn | ["Wind instrument, woodwind instrument", "Shofar"] | ["amateur recording", "shofar", "jewish instrument", "no percussion", "religious instrument", "natural reverb"] | 0 | T9fk99yqwN4 | 2817 | |
הרב ניסים פרץ - תוקע בשופר בסליחות אלול תש"ע | 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;