Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are time series reports which provide cases, deaths and recovered for global locations as well as United States counties. Each file covers from Jan 22 to the present. For the United States there is one file for cases and one for deaths. For the global locations, there is one file for cases, one for deaths and one for recovered cases. The entire set of CSV files are refreshed daily. The zipped archives contain previous time series reports and are date stamped when they were uplaoded by Big Local News. Please cite Johns Hopkins University as described in the README.

Data source: Big Local News · About: big-local-datasette

Custom SQL query

Errata

Update Date, File, Location, Field Updated, Old, New, Comments

1,060 rows

time_series_covid19_confirmed_US

UID, iso2, iso3, code3, FIPS, Admin2, Province_State, Country_Region, Lat...

3,340 rows

time_series_covid19_confirmed_global

Province/State, Country/Region, Lat, Long, 1/22/20, 1/23/20, 1/24/20, 1/25/20, 1/26/20...

274 rows

time_series_covid19_deaths_US

UID, iso2, iso3, code3, FIPS, Admin2, Province_State, Country_Region, Lat...

3,340 rows

time_series_covid19_deaths_global

Province/State, Country/Region, Lat, Long, 1/22/20, 1/23/20, 1/24/20, 1/25/20, 1/26/20...

274 rows

time_series_covid19_recovered_global

Province/State, Country/Region, Lat, Long, 1/22/20, 1/23/20, 1/24/20, 1/25/20, 1/26/20...

259 rows

Download SQLite DB: Johns_Hopkins_COVID_data_-_time_series.db 7.5 MB