musiccaps_details (view)
2 rows where musiccaps_aspects contains "no percussion" and musiccaps_aspects contains "shofar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- no percussion · 2 ✖
- shofar · 2 ✖
- amateur recording 1
- instrumental 1
- jewish instrument 1
- melancholic feel 1
- natural reverb 1
- no other instruments 1
- no voice 1
- piano tone 1
- religious instrument 1
- slow tempo 1
- synth song 1
musiccaps_names (array) 2 ✖
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 |
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;