Leeds Council responds to massive coronavirus infection rate spike after Excel spreadsheet data blunder

The leader of Leeds City Council has responded to the large jump in recorded coronavirus cases in the city after an Excel spreadsheet error.
Watch more of our videos on Shots! 
and live on Freeview channel 276
Visit Shots! now

The weekly rate of new Covid-19 cases has soared in dozens of areas of England, following the addition of nearly 16,000 cases that went unreported because of a technical error with an Excel spreadsheet.

There were a total of 2,177 new cases in Leeds following a review, according to the PA News Agency.

Hide Ad
Hide Ad

Leeds City Council said the weekly Covid-19 infection rate in the city was now 216.3 per 100,000 people.

Leeds City Council leader Judith Blake.Leeds City Council leader Judith Blake.
Leeds City Council leader Judith Blake.

The problem has also led to a delay in efforts by NHS Test and Trace to find the contacts of those who tested positive for the virus, in some cases by around a week.

Judith Blake, Leader of Leeds City Council, said: “As is the case for many large cities across the country, the recent delay in national recording of positive tests for Covid-19 has resulted in a sharp rise in reported cases in Leeds over the weekend.

"The delay in tracing people who have been in contact with those who tested positive is also a concern."

Hide Ad
Hide Ad

“It is too early to know what the impact of this will be for Leeds and across the country, in terms of any potential further restrictions.

"However, the continued increase in the number of cases means it is absolutely critical that we all follow the latest rules and guidance in order to contain the spread of the virus and protect the city.

"We urge everyone to play their part to help keep each other safe.”

Prime Minister Boris Johnson was unable to say on Monday morning how many contacts of positive coronavirus cases had been missed.

Hide Ad
Hide Ad

The issue occurred when people who tested positive were not recorded once a master Excel spreadsheet reached its maximum size.

Public Health England (PHE) said the technical issue resulted in 15,841 cases between September 25 and October 2 being left out of the reported daily coronavirus cases.

It said the outstanding cases were transferred to NHS Test and Trace “immediately” after the issue was noted and all cases were passed on to tracers by 1am on Saturday.

Dr Duncan Robertson, lecturer in management sciences and analytics at Loughborough University and fellow of St Catherine’s College, Oxford, said the error was “an absolute scandal”.

Hide Ad
Hide Ad

He tweeted: “These individuals will not have had their contacts identified and those contacts may have become infectious and may have been spreading the virus.”

Paul Hunter, professor of health protection at the University of East Anglia, said “there will be occasional glitches” in a system this size, but added: “I think the thing that surprised me was the size of it – almost 16,000 results going missing over the course of a week is quite alarming I think.”

Prof Hunter told BBC Radio 4’s Today programme: “If you’re going to do your contact tracing, there is a very short time frame in which you can do it effectively.

“And the reason is that we know now that this infection is most infectious at around the time people develop symptoms – so very early on in the illness – and if you’re going to therefore identify contacts… it really needs to be done within a matter of a day or so if you’re going to actually have any effect.”

Hide Ad
Hide Ad

Rowland Kao, professor of veterinary epidemiology and data science at the University of Edinburgh, said the contacts of those affected will “have already contributed extra infections which we shall see over the coming week or so.”

The Excel spreadsheet reached its maximum file size, which stopped new names being added in an automated process, the PA news agency understands.

The files have now been split into smaller multiple files to prevent the issue happening again.

PHE said every single person who was tested initially had received their test result as normal, with all those testing positive told to self-isolate.

Hide Ad
Hide Ad

The number of call attempts to contacts of those affected is being increased from 10 to 15 over 96 hours.

Asked on Monday how many contacts of positive coronavirus cases had been missed as a result of the error, Mr Johnson told reporters in central London: “I can’t give you those figures. What I can say is all those people are obviously being contacted and the key thing is that everybody, whether in this group or generally, should self-isolate.”

He said the updated figures meant that the prevalence of the virus was where experts had expected it to be and it would soon be apparent if extra restrictions were having the intended impact.

“The incidence that we are seeing in the cases corresponds to pretty much where we thought we were,” he said.

Hide Ad
Hide Ad

“And, to be frank, I think that the slightly lower numbers that we’d seen, you know, didn’t really reflect where we thought the disease was likely to go, so I think these numbers are realistic.”

Shadow health secretary Jonathan Ashworth said the error was “shambolic”, adding that “people across the country will be understandably alarmed.”

Health Secretary Matt Hancock is to make a Commons statement on Monday afternoon on the issue.

Comment Guidelines

National World encourages reader discussion on our stories. User feedback, insights and back-and-forth exchanges add a rich layer of context to reporting. Please review our Community Guidelines before commenting.