musiccaps_details (view)
3 rows where musiccaps_aspects contains "no other instruments", musiccaps_aspects contains "no percussion" and musiccaps_names contains "Shofar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- instrumental 3
- no other instruments · 3 ✖
- no percussion · 3 ✖
- no voice 2
- slow tempo 2
- flute song 1
- meditation music 1
- melancholic feel 1
- no voices 1
- piano tone 1
- relaxing music 1
- sad melody 1
- shofar 1
- shofar song 1
- synth song 1
- synth sounds 1
musiccaps_names (array) 2 ✖
- Shofar · 3 ✖
- Wind instrument, woodwind instrument 3
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 | |
SHOFAR IN THE DESERT | This song features a shofar playing the main melody. This is accompanied by a synth playing chords in the background. There are no other instruments in this song. There are no voices in this song. This song can be played in a sad scene in a movie. | 2007-09-27T07:25:37Z | essnerhaim | SHOFAR IN THE DESERT ARIK DAVIDOFF UZI$HAIM ESSNER | ["Wind instrument, woodwind instrument", "Shofar"] | ["shofar song", "synth sounds", "no other instruments", "no percussion", "no voice", "instrumental", "slow tempo", "sad melody"] | 0 | 7YWMPBHKdyY | 856 | |
A Teaching By Zen Master Jinen Part 2 | This instrumental song features a flute playing a high pitched melody. The melody starts off with one high pitched staccato note. After a brief pause, the flute plays two ascending notes in which the second note is sustained. Then a third higher note is played followed by a descending run of four more notes and ending on one higher note. There are no other instruments in this song. There is no percussion in this song. This song has a relaxing mood. This song can be played at a meditation center. | 2010-06-14T10:18:34Z | El-Branden Brazil | This is the second in a series of teachings by my teacher, Zen master Jinen-san. - How do I know when my practice is correct? -The importance of Zazen (sitting). | ["Wind instrument, woodwind instrument", "Shofar"] | ["flute song", "no voices", "instrumental", "no percussion", "no other instruments", "meditation music", "relaxing music"] | 0 | nkSRzaqpOCQ | 4573 |
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;