PHE Coronavirus COVID-19 Cases & Deaths in the UK
Period, ONS Geography Code, Area Type, Reported Case Type, Measure Type, Unit, Marker, Value
A - Area name - We have the code so do not this column
B - Area code - change to ONS Geography Code
C - Area Type (Codelist)
D - Specimen Date - change to Period and format as required
E1:K1 - Reported Case Type
Add Measure Type column with values Cases and Rate
Add Unit column with value Count
A - Area name - We have the code so do not this column
B - Area code - change to ONS Geography Code
C - Area Type (Codelist)
D - Reporting Date - change to Period and format as required
E1:F1 - Reported Case Type
Add Measure Type column with values Deaths
Add Unit column with value Count
Periods for Cases are Specimen Data.
Periods for Deaths are Reporting Date.
Deaths and lab-confirmed case counts and rates for England and subnational areas are provided by Public Health England. All data for the rest of the UK are provided by the Department of Health and Social Care based on data from the devolved administrations. Maps include Ordnance Survey data © Crown copyright and database right 2020 and Office for National Statistics data © Crown copyright and database right 2020. See the About the data page (link at top of this page) for details. The England total excludes 392 lab-confirmed cases that are not yet in the automated reporting system. These are included in the total number of lab-confirmed UK cases.