search

CSSEGISandData / COVID-19

Novel Coronavirus (COVID-19) Cases, provided by JHU CSSE
https://systems.jhu.edu/research/public-health/ncov/
29.16k stars 18.46k forks source link

Whitespace issue: 'Norfolk County, MA' v.s. ' Norfolk County, MA' #388

Open simonw opened 4 years ago

simonw commented 4 years ago

Minor data cleanliness problem: https://github.com/CSSEGISandData/COVID-19/blob/f70933a798f3a78b11f9fa455704881f627af787/csse_covid_19_data/csse_covid_19_daily_reports/03-09-2020.csv#L121 v.s. https://github.com/CSSEGISandData/COVID-19/blob/abcfb889b38c0747e11a10ce01bd1aeb2c42f71f/csse_covid_19_data/csse_covid_19_daily_reports/03-06-2020.csv#L125

I spotted this while exploring the data using https://github.com/simonw/covid-19-datasette - which grabs the daily reports from this repo hourly and publishes them as a SQLite database using my Datasette tool here: https://covid-19.datasettes.com/

simonw commented 4 years ago

I count 8 places total where the " Norfolk County, MA" value shows up: https://github.com/CSSEGISandData/COVID-19/search?q=norfolk+county&unscoped_q=norfolk+county