More than 1,000 people a day were in hospital with the bug according to the latest NHS figures