Itsallaguess wrote:swill453 wrote:Mike4 wrote:
I am trying to find a source of data that shows infection rates by area, so I can browse the town or city a potential customer is from before travelling to them. This info seem to be withheld by the government now, unless someone knows otherwise!
If you go here https://coronavirus.data.gov.uk/ and download the CSV spreadsheet, you can see daily cases narrowed down as far as lower tier local authority.
And from that link above, the direct CSV-data link below can be used to open the latest 'England cases' CSV file into Excel or similar -
https://coronavirus.data.gov.uk/downloads/csv/coronavirus-cases_latest.csv
Note that in the above CSV data, there is the following data for today and historical days -
Nation (England)
Region (South West / West Midlands etc..)
Upper Tier Local Authority (County level)
Lower Tier Local Authority (Town level)
Cheers,
Itsallaguess
I can't make sense of that data. Column E shows "Daily lab cases" which is 41 for England, then Column J says there are 372 more cumulative cases. But surely that should be the same number as "Daily lab cases"?
Column J is possibly the most useful "Cumulative lab-confirmed rate" - presumably confirmed cases per 100,000?
There are 50,000-odd rows in the dataset, presumably repeated data for different time periods?
I did sort by "Cumulative lab-confirmed rate" - Leicester, Ashford, Preston, Barrow, Bradford look to be in the top 5.