musiccaps_details (view)

1 row where musiccaps_aspects contains "guitar like instrumental", musiccaps_aspects contains "sad", musiccaps_names contains "Music" and musiccaps_names contains "Yodeling"

✎ View and edit SQL

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
HEBREW - YEDID NEFESH ~ NEW MUSIC VIDEO FROM MICHA'EL BEN DAVID Someone is playing a guitar-like instrument in a tremolo fashion along with someone playing a melody on a harp along with a bass playing the root note. A male voice is singing, sounding sad and sensitive. A backing voice that seems to be female is singing along, providing harmonies. This song may be playing in a dance performance. 2013-07-29T00:15:22Z מיכאל אליהו בן-דוד Micha'el BenDavid Official This Video was shot this past June 2013 at the end of the month in Antwerp and Brugge Belgium when I pass through for a short visit at the beginning of the Summer Tour! And with G-d's help we were able to put this video together with such wonderful who volunteered helped and sponsored the making of this wonderful, warm & family oriented music video! I sure hope the world is blessed by its beauty, message and melodies! YHVH is the God of ALL the families of Israel [Jeremiah 31:1] Mashiach Tsidkenu the Beloved of our Soul! With Love! Micha'el ~ Beloved of YHVH YEDID NEFESH ~ LYRICS Yedid Nefesh Av HaRachaman Meshoch Avdecha El Retsonecha Yarutz Avdecha Kemo Ayal ..... Yishtachave el Mul Hadorecha Yeerav Lo Yedidotecha Mi Nofet Tsuf v'chol Ta'am Beloved of the Soul, Compassionate Father, Draw/Anoint Your Servant to [do] Your will. Then Your servant will hurry like a hart [deer] to bow before Your Majesty. To him Your Friendship will be sweeter than the dripping of the honeycomb and of any taste. Verse 1 Hadur Naeh Ziv HaOlam Nafshi Cholat Ahavatecha Ana El Na Refa Na La [Ana El Refa Na La] Be Harot La Noam Zivecha Az Titchazek VeTitrape Ve Hayita La Simchat Olam [V'Hayita La Simchat Olam] Majestic, Beautiful, Radiance of the Universe--my soul pines for Your Love. Please, O God, heal her now By showing her the pleasantness of Your Radiance. Then she will be strengthened and healed, and Eternal gladness shall be hers. YEDID NEFESH.... Yadaidai break/bridge Verse 2 Higale Na U'Fros Chavivi Alai Et Sukkat Sh'lomecha Tair Eretz MiKvodecha Tair Eretz MiK'vodecha Nagilah Ve Nismecha (Nismecha Bach) Maher Ehov Ki Va Moed Ve'Chanenu Ki Ymey Olam [Ve'Chanenu Ki Ymey Olam] Please be revealed and spread upon me, my Beloved, the shelter of Your Peace. Illuminate the world with Your Glory that we may rejoice and be glad with You. Hashem (Adonai) show Love, for the time has come, and be Gracious to us as in the days of Old! Back to YEDID NEFESH......till end Yedid Nefesh was written by El'azar ben Mosheh Askari,… ["Yodeling", "Music", "Inside, large room or hall"] ["oriental/ballad", "guitar like instrumental", "bass", "male voice singing", "female backing voice singing", "sad", "slow tempo", "harp"] 6 -EVRXQpt1-8 29

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;