search

tomwhite / covid-19-uk-data

Coronavirus (COVID-19) UK Historical Data
http://tom-e-white.com/covid-19-uk-data/
The Unlicense
162 stars 79 forks source link

Area name not constant for area code E09000012 and E06000052 #15

Closed timday closed 4 years ago

timday commented 4 years ago

Minor point easily dealt with, and I'm not sure where it's being introduced, but there's a couple of areas where the names are a bit unstable earlier on.

$ grep E09000012 data/covid-19-cases-uk.csv 
2020-03-05,England,E09000012,Hackney,0
2020-03-07,England,E09000012,Hackney and City of London,2
2020-03-08,England,E09000012,Hackney,2
2020-03-09,England,E09000012,Hackney and City of London,2
2020-03-10,England,E09000012,Hackney and City of London,3

(and then always "Hackney and City of London")

$ grep E06000052 data/covid-19-cases-uk.csv 
2020-03-05,England,E06000052,Cornwall,1 to 4
2020-03-07,England,E06000052,Cornwall and Isles of Scilly,2
2020-03-08,England,E06000052,Cornwall,3
2020-03-09,England,E06000052,Cornwall and Isles of Scilly,4
2020-03-10,England,E06000052,Cornwall and Isles of Scilly,4

(and then always "Cornwall and Isles of Scilly")

Don't know if it reflects the upstream sources not actually having data for the "City of London" and "Isles of Scilly" that day or not.

tomwhite commented 4 years ago

Hi Tim,

Thanks for raising this issue. Early on there was some inconsistency between area definitions, so for example on 5 March Hackney was reported on separately to City of London. After that date they were merged.

It looks like 8 March is wrong (the name should be "Hackney and City of London" and "Cornwall and Isles of Scilly") and I'll change it. But on 5 March they were broken out, so I'll leave them as recorded.