Excel spreadsheet blamed for 16,000 missed Covid-19 cases

5 October 2020, 11:05 | Updated: 5 October 2020, 12:40

Test and Trace programme scientific adviser says PM's 'world-beating' system promise isn't helpful

By Matt Drake

Public Health England (PHE) has apologised for a technical glitch which meant almost 16,000 Covid-19 cases went unreported.

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

The technical issue also means that daily totals reported on the Government's coronavirus dashboard over the last week have been lower than the true number.

The problem was reportedly caused by an Excel spreadsheet reaching its maximum file size, which stopped new names being added in an automated process. The files have now been split into smaller multiple files to prevent the issue happening again.

There were 4,786 cases which were due to be reported on October 2 but were not included in the daily total on the dashboard that day, when the figure was given as 6,968.

The Government's dashboard said that, as of 9am on Sunday, there had been a further 22,961 lab-confirmed cases of coronavirus in the UK, taking the total number of cases in the UK to 502,978.

A note on the dashboard said: "The cases by publish date for 3 and 4 October include 15,841 additional cases with specimen dates between 25 September and 2 October - they are therefore artificially high for England and the UK."

Scientific advisor to the Test and Trace Programme, Clinician and Senior Researcher at Oxford University's Nuffield, Dr David Bonsall, told LBC that manual testing was not "built for a pandemic this size" and stressed the importance of automatic tracing via smartphone technology.

Prime Minister Boris Johnson said in May that the UK would have a "world-beating" system to track and trace Covid-19.

When Nick Ferrari asked how close the UK was to achieving this, Dr Bonsall replied: "I don't think it is helpful language... It's no my choice of language. The development of the app was an international development.

"We worked alongside governments internationally. The app in the UK has been the most tested and engineered of all of them, it is something to be proud of if people trust and use it."

Read more: Almost 16,000 coronavirus cases added due to system glitch

Boris Johnson said in May that the UK would have a "world-beating" system to track and trace Covid-19
Boris Johnson said in May that the UK would have a "world-beating" system to track and trace Covid-19. Picture: PA

Prime Minister Boris Johnson said of the missing coronavirus cases: "What happened here was that some of the data got truncated and it was lost.

"But what they have done now is not only contacted all the people who were identified as having the disease - that was done in the first place - but they are now working through all the contacts as well.

"The key thing, I would say, and it goes for everybody, is that if you are contacted by NHS Test and Trace then you must self-isolate, if you are told you have been in contact with somebody who has the virus."

Senior officials said the outstanding cases were transferred to NHS Test and Trace "immediately" after the issue was resolved and thanked contact tracers for their "additional efforts" over the weekend to clear the backlog.

All cases were passed on to tracers by 1am on Saturday, meaning potential delays of more than a week in contacting thousands of people who were exposed to the virus and telling them to self-isolate.

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.

Joint medical director of PHE, Dr Susan Hopkins, told Sky News: "There's no delay in people receiving their test results.

Caller explains how 16,000 test results could have been lost on Excel

Read more: Over 12,000 Covid-19 cases reported in UK after technical issues increase numbers

"The delays are in reporting to the dashboard and to the public and there's been a delay in contact tracing initiation.

"Public Health England apologise that this occurred and have put in place steps to prevent this happening again."

Shadow health secretary Jonathan Ashworth said: "This is shambolic and people across the country will be understandably alarmed.

"Matt Hancock should come to the House of Commons on Monday to explain what on earth has happened, what impact it has had on our ability to contain this virus and what he plans to do to fix test and trace."

Listen & subscribe: Global Player | Apple Podcasts | Google Podcasts | Spotify

More Latest News

See more More Latest News

Sheriff vehicles are pictured near Trump International Golf Club (Stephanie Matat/AP)

Trump was subject of apparent assassination attempt at Florida golf club – FBI

Britain's Prime Minister Keir Starmer, right, meets with the new U.K. Border Security Commander Martin Hewitt, ahead of his visit to Rome, at an airfield near London, Sunday, Sept. 15, 2024. (Phil Noble/Pool Photo via AP)

Former top police chief named Border Security Commander - as Starmer takes aim at illegal migration on Rome trip

Donald Trump is 'safe' after the former president was the subject of an 'assassination attempt' after gunshots were fired at his Florida golf club leading to a man being arrested and an AK-47 rifle being seized.

Donald Trump 'safe' after apparent assassination attempt at Florida golf club - as one arrested and AK-47 seized

Republican presidential nominee Donald Trump (Alex Brandon/AP)

Trump safe after Secret Service opened fire at ‘armed suspect’ near golf club

Donald Trump has released a statement after he was rushed to safety following gunshots being fired in his vicinity.

'I will NEVER SURRENDER': Donald Trump releases statement after gunshots fired in his vicinity

Prime Minister Sir Keir Starmer has said he is 'interested' in Italy's deal with Albania to send migrants there after they are rescued at sea.

Starmer 'interested in Italy's migrant deal' with Albania ahead of visit to Rome to meet right-wing PM Meloni

Taylor Swift arrives before the start of a game between the Kansas City Chiefs and the Cincinnati Bengals (Ed Zurga/AP)

Taylor Swift back in Kansas to watch boyfriend Travis Kelce and the Chiefs

Donald Trump is 'safe' after former president reportedly had gunshots fired near him just weeks after a near-miss assassination attempt, campaign sources say.

Donald Trump safe after 'shots fired in his vicinity at Florida golf club' just weeks after assassination attempt

Britain is set to get last gasp days of warm weather - after blustery conditions blighted the first weeks of September.

Exact date warm weather is set to bless UK with Indian summer - after cold start to autumn

Former FA chief David Bernstein has branded UEFA's threat to exclude England from their home Euros in 2028 over plans for regulation as empty.

'Last throw of the dice': Former FA chief slams threat to exclude England from Euros as empty threat from UEFA

Liberal Democrat leader Sir Ed Davey has backed Ukraine's bid to use British-made long-range missiles to strike Russia even without US approval - as he closed his party's autumn conference in Brighton on Sunday.

Ed Davey backs Ukraine using UK missiles without US approval - as he addresses stunt-heavy Lib Dem conference

Flooded houses in Jesenik, Czech Republic (Petr David Josek/AP)

Death toll rises as rain and flooding force evacuations across central Europe

Tributes have been paid to a 13-year-old girl with a 'beautiful soul' after she, her mum, and her brother were found dead in a flat in Luton on Friday

'Beautiful soul': Tributes paid after woman and two teens found dead in Luton flat as man, 18, charged with murder

Flames coming from an apartment building

Couple killed in missile attack on Odesa

Jay Blades has resigned from the King's Foundation.

Jay Blades resigns from King's Foundation after being charged with ‘controlling and coercive behaviour'

Europe has been hit by mass flooding

Storm Boris sweeps through Europe - with at least six dead and thousands evacuated from their homes