COVID_Johns_Hopkins_time_series

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: README

Custom SQL query

Errata

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

171 rows

time_series_covid19_confirmed_US

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

3,261 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...

266 rows

time_series_covid19_deaths_US

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

3,261 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...

266 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...

252 rows

Download SQLite DB: COVID_Johns_Hopkins_time_series.db 2.0 MB

Powered by Datasette · Query took 13.073ms · Data source: Big Local News · About: README