Emmy winner and ‘Crazy Ex-Girlfriend’ songwriter had been treated in hospital in upstate New York for over a week