What is the difference between "God" and "Lord" in the Hebrew Bible/Old Testament?

"Yahweh" is the sacred, personal name of God revealed to Moses at the burning bush in the book of Exodus and is often translated as "the Lord" in English translations.