Closed simonw closed 4 years ago
See https://www.nytimes.com/article/coronavirus-county-data-us.html and https://github.com/nytimes/covid-19-data
This is now live.
Example query and graph: https://covid-19.datasettes.com/covid?sql=select+%5Bdate%5D%2C+sum%28cases%29+as+sum_cases%2C+sum%28deaths%29+as+sum_deaths%0D%0Afrom+ny_times_us_counties%0D%0Awhere+%22state%22+%3D+%3Astate%0D%0Agroup+by+%5Bdate%5D+order+by+%5Bdate%5D+desc&state=New+York#g.mark=bar&g.x_column=date&g.x_type=ordinal&g.y_column=sum_cases&g.y_type=quantitative
I need to update the README.
See https://www.nytimes.com/article/coronavirus-county-data-us.html and https://github.com/nytimes/covid-19-data