I came across the Table of confirmed cases of COVID-19 in England provided by Public Health England and thought it would be useful to visualise it. I have no doubt a similar visualisation already exists, but I thought it would be an interesting exercise. The data used throughout this notebook was last updated at 9:00 am on 10 March 2020.

Note taken from the data source Data may be subject to delays in case confirmation and reporting, as well as ongoing data cleaning. Location is based on case residential postcode. When this is not available, NHS trust or reporting laboratory postcode is used. The data is therefore subject to change. Counts for Isles of Scilly and City of London are combined with Cornwall and Hackney respectively for disclosure control.

Visualising the Table¶

The first step was to copy and paste the data from the table into a CSV, followed by adding two column headings for lat and lon respectively. I have hosted the CSV for convenient and easy reproducibility.