"the" is used only if it is actually part of the name of the hospital, as you would see it painted on the building eg
The City Hospital
Great Ormond Street Hospital
HOWEVER, with very large and well-known hospitals, we might actually say in conversation:
Their child was rushed to Great Ormond Street.