musiccaps_details (view)
3 rows where musiccaps_aspects contains "shofar", musiccaps_author = 0 and musiccaps_names contains "Shofar"
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 song features a synth playing the rhythm section using a piano tone. The shofar plays a tremulous note. There is no percussion in this song. The mood of this song is melancholic. There are no other instruments in this song. There is no voice in this song. This song can be used in a romantic movie. | 2010-12-06T03:19:53Z | Roki Balboa | שופרות בחופה פתיחת טקס החופה בתקיעת שופר בחיבור של מיקרופון אלחוטי ביצוע: נועם ביט www.justbeat.co.ill 050-5151518 | ["Wind instrument, woodwind instrument", "Shofar"] | ["synth song", "shofar", "piano tone", "melancholic feel", "slow tempo", "no percussion", "no voice", "no other instruments", "instrumental"] | 0 | 3PoC1-xd4Yw | 463 | |
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 | |
Sound the Shofar Alarm | This song features the shofar being played. The shofar is blown and the pitch quickly changes from low to high while being blown. This is a religious instrument. There are no other instruments in this song. There are no voices in this song. This song can be played in a movie scene as a battle call. | 2014-02-02T02:10:52Z | Artists For Israel | Sound the Shofar Alarm | ["Wind instrument, woodwind instrument", "Shofar"] | ["shofar", "no other instruments", "no voices", "religious instrument", "battle call"] | 0 | Yd8JBTdUvrw | 3301 |
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;