musiccaps_details (view)
2 rows where musiccaps_aspects contains "no other instruments" and musiccaps_aspects contains "shofar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- no other instruments · 2 ✖
- shofar · 2 ✖
- battle call 1
- instrumental 1
- melancholic feel 1
- no percussion 1
- no voice 1
- no voices 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 | |
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;