03-17-2020

Table actions
Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are daily reports which provide cases, deaths and recovered for all global locations as wells as United States counties. There is one CSV file for each day's report. The entire set of CSV files are refreshed daily. The zipped archives contain previous daily 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

14 rows where "Last Update" is on date 2020-03-15

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Country/Region, Last Update, Confirmed, Deaths, Recovered

Last Update (date) ✖

  • 2020-03-15 · 14 ✖
Link rowid ▼ Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
29 29 Jiangsu China 2020-03-15T01:53:02 631 0 631 32.9711 119.455
30 30 Chongqing China 2020-03-15T03:53:04 576 6 570 30.0572 107.874
77 77 Tianjin China 2020-03-15T18:20:18 136 3 133 39.3054 117.323
78 78 Gansu China 2020-03-15T18:20:18 133 2 91 36.0611 103.8343
179 179   Maldives 2020-03-15T18:20:18 13 0 0 3.2028 73.2207
224 224 French Polynesia France 2020-03-15T18:20:19 3 0 0 -17.6797 -149.4068
231 231 Guam US 2020-03-15T18:20:19 3 0 0 13.4443 144.7937
237 237   Kosovo 2020-03-15T18:20:19 2 0 0 42.6026 20.903
242 242   Antigua and Barbuda 2020-03-15T18:20:19 1 0 0 17.0608 -61.7964
246 246 Prince Edward Island Canada 2020-03-15T02:13:21 1 0 0 46.5107 -63.4168
250 250   Equatorial Guinea 2020-03-15T06:41:54 1 0 0 1.5 10.0
251 251   Eswatini 2020-03-15T06:41:54 1 0 0 -26.5225 31.4659
255 255   Guinea 2020-03-15T06:41:54 1 0 0 9.9456 -9.6966
258 258   Mauritania 2020-03-15T18:20:19 1 0 0 21.0079 -10.9408

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-17-2020] (
   [Province/State] TEXT,
   [Country/Region] TEXT,
   [Last Update] TEXT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER,
   [Latitude] FLOAT,
   [Longitude] FLOAT
);