How has Covid-19 affected your hometown?

Scientists have created an interactive graphic which reveals how different areas of England and Wales have been affected by the coronavirus.

Damning statistics yesterday revealed that more than 51,000 people have died with Covid-19 across the UK since the outbreak began in February. 

But not all areas have been hit equally hard. More than 1,000 have died in Birmingham, England’s second biggest city, whereas none at all died on the tiny Isles of Scilly off the coast of Cornwall.

Now researchers at the University of Cambridge have compiled data from the Office for National Statistics into an interactive module that the public can use to track deaths in England and Wales over the past six months.

They show the numbers of people dying each week surged well above average between the end of March and beginning of May as the virus swept through the UK, killing tens of thousands of elderly people and those with serious health conditions, as well as healthy citizens and children.

The data revealed that more than 13,000 people died of Covid-19 in care homes up to May 29, along with another 11,000 unexplained ‘excess’ deaths which experts believe may largely have been undiagnosed coronavirus.

A further 28,000 people died in NHS hospitals of the coronavirus, while people dying on wards of other causes dropped dramatically by around 10,000 amid suggestions Brits were too scared to seek medical care. 

At the same time, however, some 2,000 people have died at home with Covid-19, along with nearly 12,000 people who died in private homes of other causes. Many of those would have likely been hospital patients in normal times, the researchers said.

Here’s how to use the module: 

  • First select the area you want to look at – it can be England and Wales, either country individually, or a local authority within one of the nations;
  • Select the data set: ‘occurrences’ is the most accurate because it counts the day someone actually died, while ‘registrations’ is the day on which they were counted, which usually comes days or even weeks later; 
  • Baseline: The difference between the two options is minimal. Baseline is the average number of deaths against which this year’s figures are compared. They are collected from the past five years. The ‘five year average’ is the true average, and ‘adjusted’ is what would have been expected without the pandemic, adjusting the five-year average using the number of deaths in the first 10 weeks of this year;
  • Select time frame: Using the ‘start week’ and ‘stop week’ drop-down menus you can choose which date range to look at. The first coronavirus death in England happened on March 2, according to NHS England. Any time periods before March will not show any Covid-19 fatalities, but they are useful for comparing how the numbers rose.

The data from the Office for National Statistics (ONS) is the most accurate for England and Wales because it takes into account everyone who has Covid-19 mentioned on their death certificate, whether they were diagnosed with the virus or not.

HOW TO USE THE MODULE 

First select the area you want to look at: It can be England and Wales, either country individually, or a local authority within one of the nations.

Select the data set: ‘Occurrences’ is the most accurate because it counts the day someone actually died, while ‘registrations’ is the day on which they were counted, which usually comes days or even weeks later; 

Baseline: The difference between the two options is small. Baseline is the average number of deaths against which this year’s figures are compared. They are collected from the past five years. The ‘five year average’ is the true average, and ‘adjusted’ is what would have been expected without the pandemic, adjusting the five-year average using the number of deaths in the first 10 weeks of this year;

Select time frame: Using the ‘start week’ and ‘stop week’ drop-down menus you can choose which date range to look at. The first coronavirus death in England happened on March 2, according to NHS England. Any time periods before March will not show any Covid-19 fatalities, but they are useful for comparing how the numbers rose.

This means it includes people who were not tested before they died, meaning the number of deaths is higher than that announced by the Department of Health because the Government only tested hospital patients between March and the end of April.

Statistics show that Birmingham has had by far the most coronavirus deaths in hospitals, with 799, along with Leeds (359), Liverpool (354) and the London borough of Brent (350).

County Durham and Sheffield experienced the most Covid-19 deaths in care homes, with 304 and 260, respectively, although the researchers noted Durham has the third highest rate of care home deaths in normal times.

A five-fold surge in care home deaths happened in Islington, London, where 84 people died compared to the average of 16, while the number of people dying at home in Newham, in the east of the city, rose eight-fold from 16 to 141.

Dr Harry Giles and Professor David Spiegelhalter, the statisticians who created the interactive, pointed out the ‘notable’ local authorities above but said: ‘We deliberately avoid creating “league tables”, as chance variability can produce spurious rankings.’

Britain’s coronavirus death yesterday jumped by 286 to an official total 40,883. 

Northern Ireland has now gone three days in a row without recording a single fatality as the outbreak there continues to fade. 

Department of Health figures showed 277 of the Covid-19 victims were from England, while the other nine were in Wales. No laboratory-confirmed deaths were recorded in Scotland and Northern Ireland. 

But separate grim statistics suggest the disease has already claimed at least 51,000 lives in the UK. 

Other data shows nearly 64,000 ‘excess deaths’ have already been recorded across the home nations since the outbreak spiralled out of control in March.

Data compiled by the statistical bodies of each of the home nations show 51,086 people died of either confirmed or suspected Covid-19 across the UK by the end of May.

The real number of victims will be even higher because the tally only takes into account deaths that occurred up until May 31 in Scotland and May 29 in the rest of Britain, meaning it is up to 10 days out of date.

The Office for National Statistics on Tuesday confirmed that 46,421 people in England and Wales died with confirmed or suspected Covid-19 by May 29.

The total number of coronavirus deaths was 754 by the same date in Northern Ireland, according to the Northern Ireland Statistics and Research Agency (NISRA).

National Records Scotland — which collects statistics north of the border — said 3,911 people had died across the country by May 31.

Their tallies are always 10 days behind the Department of Health (DH) because they wait until as many fatalities as possible for each date have been counted, to avoid having to revise their statistics.

By comparison, the DH announces deaths for each day as soon as it receives them, meaning they are continuously updated as more registrations filter through the system.

REVEALED: THE 10 AREAS OF ENGLAND AND WALES WITH THE MOST COVID-19 DEATHS…

Birmingham

Leeds

County Durham

Liverpool

Sheffield

Brent

Croydon

Cheshire East

Barnet

Bradford 

1,148

645

624

550

534

472

471

454

446

441 

…. AND THE 10 AREAS OF ENGLAND AND WALES WITH THE FEWEST COVID-19 DEATHS 

Isles of Scilly

City of London

Ceredigion

Hastings

South Hams

West Devon

Mid Devon

Torridge

Rutland

Norwich 

Because of this recording lag, the number of deaths announced on any date is significantly higher by the time the ONS has calculated it. 

The difference between the statistics agencies’ total and the Department of Health total for May 29 is around 33.8 per cent (51,074 compared to 38,161).

If the most recent death toll announced by the government was increased by the same amount it would mean that there have already been 54,100 Covid-19 victims who died. 

Data released by the ONS, the statistical body for England and Wales, also showed weekly deaths in the seven-day spell ending May 29 plummeted to the lowest rate all year. 

Only 9,824 deaths were registered in the two countries that week — still 1,600 deaths higher than what would usually be expected. 

Both England and Wales — which suffered 16,000 deaths during the darkest fortnight of the crisis in April — are now en route to the way they were before the unprecedented lockdown was imposed on March 23.

The ONS figures also showed less than a fifth of deaths registered in the week ending May 29 in England and Wales involved coronavirus — the lowest proportion since when lockdown was imposed on March 23.   

It is also the first time the proportion of weekly Covid-19 deaths has fallen to under a fifth since the week lockdown was imposed, the week ending March 27, when the virus accounted for 5 per cent of the deaths.

While numbers are falling, there have been tens of thousands of ‘excess’ deaths compared to the average number of deaths over five years for the same period. 

The total number of excess deaths has passed 63,500, with Tuesday’s figures showing 57,961 excess deaths in England and Wales between March 21 and May 29 2020. 

Excess deaths are considered to be an accurate measure of the number of people killed by the pandemic because they include a broader spectrum of victims. 

As well as including people who may have died with Covid-19 without ever being tested, the data also shows how many more people died because their medical treatment was postponed, for example, or who didn’t or couldn’t get to hospital when they were seriously ill.

Nick Stripe, head of health analysis at the ONS, said some deaths involving coronavirus in care homes ‘will have brought forward deaths that might otherwise have happened relatively soon’.

He tweeted: ‘We might expect deaths not involving Covid in care homes to fall below 5-yr avgs (average) in the next few weeks.’

REVEALED: HOW MANY PEOPLE HAVE DIED OF COVID-19 IN YOUR LOCAL AUTHORITY (Data from the Office for National Statistics, up to May 29)
LOCAL AUTHORITY COVID-19 DEATHS LOCAL AUTHORITY COVID-19 DEATHS
Birmingham 1,148 Wycombe 101
Leeds 645 Charnwood 101
County Durham 624 Mole Valley 101
Liverpool 550 Hartlepool 100
Sheffield 534 Portsmouth 100
Brent 472 Ashford 100
Croydon 471 South Derbyshire 99
Cheshire East 454 Wealden 99
Barnet 446 Neath Port Talbot 98
Bradford 441 Wychavon 97
Wirral 394 East Hertfordshire 97
Ealing 393 Wyre 96
Harrow 384 Elmbridge 96
Enfield 377 Telford and Wrekin 95
Manchester 362 Chorley 95
Walsall 352 North Lincolnshire 93
Cardiff 349 Fareham 93
Sandwell 339 Eastleigh 92
Cheshire West and Chester 335 Broxtowe 92
Wiltshire 332 Chiltern 91
Sunderland 328 High Peak 91
Bromley 328 North Hertfordshire 91
Stockport 322 Sevenoaks 90
Wigan 319 Folkestone and Hythe 90
Redbridge 306 Stroud 89
Salford 305 Warwick 89
Hillingdon 305 Vale of Glamorgan 88
Wakefield 302 Bath and North East Somerset 87
Newham 298 Amber Valley 87
Bolton 297 Three Rivers 86
Wolverhampton 290 South Staffordshire 86
Dudley 288 Spelthorne 86
Kirklees 282 Bridgend 86
Lewisham 279 Powys 86
Derby 276 Blackburn with Darwen 85
Lambeth 271 Peterborough 85
Coventry 270 Dover 85
Havering 270 Breckland 85
Sefton 268 Surrey Heath 84
Rotherham 267 Guildford 83
Rhondda Cynon Taf 266 Tandridge 83
Solihull 262 Plymouth 82
Haringey 261 Hinckley and Bosworth 81
East Riding of Yorkshire 256 East Northamptonshire 81
Northumberland 247 Denbighshire 81
Leicester 246 Erewash 80
Oldham 240 Darlington 79
Southwark 240 Cambridge 79
Tameside 237 East Hampshire 79
Waltham Forest 237 Gravesham 79
Bristol, City of 230 Carmarthenshire 79
Northampton 229 Chesterfield 78
Central Bedfordshire 228 Rochford 78
Gateshead 226 South Ribble 78
Newcastle upon Tyne 225 Kettering 78
Hackney 221 Brentwood 77
Greenwich 219 Rushmoor 77
Hounslow 218 Fylde 77
Warrington 213 Epsom and Ewell 77
Shropshire 212 Chichester 77
Barnsley 212 Rushcliffe 76
Bexley 211 Isle of Wight 75
Nottingham 208 Scarborough 75
Trafford 208 Barrow-in-Furness 74
Wandsworth 208 Broxbourne 74
East Suffolk 204 Crawley 73
Bury 200 Fenland 71
Cornwall 198 Newark and Sherwood 71
Doncaster 198 North Warwickshire 71
Rochdale 196 Worthing 71
Merton 194 Monmouthshire 71
Swansea 194 Castle Point 70
Middlesbrough 193 Harlow 70
Luton 191 Oxford 70
Milton Keynes 191 Rugby 70
St. Helens 187 Cannock Chase 69
Basildon 184 West Suffolk 69
Tower Hamlets 183 Pendle 67
Westminster 181 Broadland 67
Epping Forest 177 Woking 67
Bournemouth, Christchurch and Poole 174 Derbyshire Dales 66
Hertsmere 174 Lancaster 66
Medway 173 Conwy 66
Southend-on-Sea 172 Tonbridge and Malling 65
Reigate and Banstead 169 Eastbourne 64
Stoke-on-Trent 168 Blaby 64
Sutton 168 Mid Suffolk 64
Hammersmith and Fulham 165 Torfaen 64
Kingston upon Hull, City of 163 Bracknell Forest 63
Barking and Dagenham 161 Merthyr Tydfil 63
South Gloucestershire 160 Allerdale 62
Stratford-on-Avon 159 Craven 62
Mid Sussex 159 Blaenau Gwent 62
Newport 158 Wellingborough 61
Reading 157 Mansfield 61
Swindon 156 Runnymede 61
Southampton 156 Uttlesford 60
York 155 Hambleton 60
Dorset 155 Sedgemoor 60
Camden 155 Staffordshire Moorlands 60
South Tyneside 154 North West Leicestershire 59
Harrogate 153 Arun 59
Islington 148 Gwynedd 59
North Tyneside 147 Wrexham 59
Tendring 146 Daventry 58
Brighton and Hove 145 Torbay 57
Richmond upon Thames 145 Cotswold 57
Gloucester 144 Worcester 57
South Lakeland 143 Stevenage 57
Wokingham 142 South Cambridgeshire 55
Bedford 141 Gosport 55
East Staffordshire 139 Tunbridge Wells 55
Knowsley 136 Burnley 55
King’s Lynn and West Norfolk 135 South Kesteven 55
Chelmsford 134 Redditch 55
Ashfield 132 Copeland 54
Cheltenham 131 Harborough 54
Thanet 131 Tamworth 54
Thurrock 130 Babergh 53
West Berkshire 129 Bolsover 52
North East Derbyshire 129 Hyndburn 52
Waverley 129 South Norfolk 52
Caerphilly 128 Bassetlaw 52
Aylesbury Vale 127 South Somerset 51
Nuneaton and Bedworth 127 South Bucks 50
Kingston upon Thames 126 Rossendale 50
Stockton-on-Tees 125 Rother 49
Windsor and Maidenhead 125 Oadby and Wigston 49
Bromsgrove 125 North Norfolk 49
New Forest 124 East Cambridgeshire 48
Kensington and Chelsea 121 South Holland 48
Carlisle 120 South Northamptonshire 48
Vale of White Horse 119 Malvern Hills 46
Newcastle-under-Lyme 119 Forest of Dean 45
North Somerset 118 East Devon 44
Ipswich 118 East Lindsey 44
St Albans 118 Somerset West and Taunton 44
Redcar and Cleveland 117 Corby 43
Blackpool 117 Hart 42
Dacorum 115 Richmondshire 42
Herefordshire, County of 113 Selby 41
Preston 113 North Kesteven 40
Gedling 113 Pembrokeshire 40
Cherwell 113 Great Yarmouth 39
Watford 112 Adur 39
West Oxfordshire 112 Eden 38
Wyre Forest 111 Exeter 38
South Oxfordshire 110 North East Lincolnshire 34
Braintree 109 Boston 33
Flintshire 109 Teignbridge 32
West Lancashire 108 Maldon 32
Lichfield 108 Ryedale 28
Calderdale 108 Isle of Anglesey 27
Test Valley 107 North Devon 26
Halton 106 Melton 26
Basingstoke and Deane 106 Mendip 26
Swale 106 Ribble Valley 22
Havant 105 Lincoln 22
Stafford 105 West Lindsey 22
Horsham 105 Rutland 21
Slough 104 Norwich 21
Huntingdonshire 104 Torridge 19
Colchester 104 Mid Devon 16
Winchester 104 West Devon 15
Maidstone 104 South Hams 12
Lewes 103 Hastings 9
Welwyn Hatfield 103 Ceredigion 7
Tewkesbury 102 City of London 4
Canterbury 102 Isles of Scilly 0
Dartford 102 SOURCE: Office for National Statistics