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

276 rows sorted by Last Update

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Deaths, Last Update (date)

Link rowid Province/State Country/Region Last Update ▼ Confirmed Deaths Recovered Latitude Longitude
21 21 Anhui China 2020-03-11T02:18:14 990 6 984 31.8257 117.2264
43 43 Fujian China 2020-03-11T02:18:14 296 1 295 26.0789 117.9874
96 96 Xinjiang China 2020-03-11T02:18:14 76 3 73 41.1129 85.2401
172 172 Qinghai China 2020-03-11T02:18:14 18 0 18 35.7452 95.9956
248 248 Tibet China 2020-03-11T02:18:14 1 0 1 31.6927 88.0924
276 276   occupied Palestinian territory 2020-03-11T20:53:02 0 0 0 31.9522 35.2332
23 23 Jiangxi China 2020-03-12T02:13:04 935 1 934 27.614 115.7221
42 42 Hebei China 2020-03-13T11:09:03 318 6 310 38.0428 114.5149
79 79 Shanxi China 2020-03-13T11:09:03 133 0 133 37.5777 112.2922
27 27 Diamond Princess Cruise Ship 2020-03-13T14:13:25 696 7 325 35.4498 139.6649
245 245   Bhutan 2020-03-13T22:22:02 1 0 0 27.5142 90.4336
256 256   Holy See 2020-03-13T22:22:02 1 0 0 41.9029 12.4534
268 268   Togo 2020-03-13T22:22:02 1 0 0 8.6195 0.8248
260 260   Nepal 2020-03-13T22:22:03 1 0 1 28.3949 84.124
263 263   Sudan 2020-03-14T01:13:32 1 1 0 12.8628 30.2176
243 243 Northern Territory Australia 2020-03-14T01:53:03 1 0 0 -12.4634 130.8456
271 271 From Diamond Princess Australia 2020-03-14T02:33:04 0 0 0 35.4437 139.638
20 20 Hunan China 2020-03-14T08:33:03 1018 4 1014 27.6104 111.7088
15 15 Henan China 2020-03-14T09:53:08 1273 22 1250 33.882 113.614
253 253   Gabon 2020-03-14T13:33:04 1 0 0 -0.8037 11.6094
236 236 St Martin France 2020-03-14T16:33:03 2 0 0 18.0708 -63.0501
239 239   Namibia 2020-03-14T16:33:03 2 0 0 -22.9576 18.4904
261 261   Saint Vincent and the Grenadines 2020-03-14T16:33:03 1 0 0 12.9843 -61.2872
264 264   Suriname 2020-03-14T16:33:03 1 0 0 3.9193 -56.0278
29 29 Jiangsu China 2020-03-15T01:53:02 631 0 631 32.9711 119.455
246 246 Prince Edward Island Canada 2020-03-15T02:13:21 1 0 0 46.5107 -63.4168
30 30 Chongqing China 2020-03-15T03:53:04 576 6 570 30.0572 107.874
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
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
258 258   Mauritania 2020-03-15T18:20:19 1 0 0 21.0079 -10.9408
91 91 Jilin China 2020-03-16T00:22:10 93 1 92 43.6661 126.1923
89 89   United Arab Emirates 2020-03-16T00:22:11 98 0 23 23.4241 53.8478
219 219 Puerto Rico US 2020-03-16T00:22:11 5 0 0 18.2208 -66.5901
227 227   Kenya 2020-03-16T00:22:11 3 0 0 -0.0236 37.9062
87 87   San Marino 2020-03-16T01:33:03 109 7 4 43.9424 12.4578
226 226   Guam 2020-03-16T02:13:16 3 0 0 13.4443 144.7937
247 247   Central African Republic 2020-03-16T03:33:03 1 0 0 6.6111 20.9394
266 266   The Bahamas 2020-03-16T03:33:03 1 0 0 24.25 -76.0
68 68 Hainan China 2020-03-16T14:38:45 168 6 161 19.1959 109.7453
97 97 Inner Mongolia China 2020-03-16T14:38:45 75 1 73 44.0935 113.9448
98 98 Ningxia China 2020-03-16T14:38:45 75 0 75 37.2692 106.1655
117 117   South Africa 2020-03-16T14:38:45 62 0 0 -30.5595 22.9375
139 139   Belarus 2020-03-16T14:38:45 36 0 3 53.7098 27.9534
177 177   Burkina Faso 2020-03-16T14:38:45 15 0 0 12.2383 -1.5616
184 184   Bolivia 2020-03-16T14:38:45 11 0 0 -16.2902 -63.5887
209 209   Monaco 2020-03-16T14:38:45 7 0 0 43.7384 7.4246
213 213 Channel Islands United Kingdom 2020-03-16T14:38:45 6 0 0 49.3723 -2.3644
216 216   Ethiopia 2020-03-16T14:38:45 5 0 0 9.145 40.4897
225 225 Saint Barthelemy France 2020-03-16T14:38:45 3 0 0 17.9 -62.8333
249 249   Congo (Brazzaville) 2020-03-16T14:38:45 1 0 0 -0.228 15.8277
252 252 Mayotte France 2020-03-16T14:38:45 1 0 0 -12.8431 45.1383
259 259   Mayotte 2020-03-16T14:38:45 1 0 0 -12.8275 45.1662
149 149 South Australia Australia 2020-03-16T14:38:46 29 0 3 -34.9285 138.6007
185 185   French Guiana 2020-03-16T14:38:46 11 0 0 3.9339 -53.1258
202 202 Tasmania Australia 2020-03-16T14:38:46 7 0 0 -41.4545 145.9707
234 234 Australian Capital Territory Australia 2020-03-16T14:38:46 2 0 0 -35.4735 149.0124
244 244   Benin 2020-03-16T14:38:46 1 0 0 9.3077 2.3158
262 262   Somalia 2020-03-16T14:38:46 1 0 0 5.1521 46.1996
270 270 Cayman Islands United Kingdom 2020-03-16T14:53:04 1 1 0 19.3133 -81.2546
35 35   Qatar 2020-03-16T15:13:09 439 0 4 25.3548 51.1839
130 130 Diamond Princess US 2020-03-16T16:53:06 47 0 0 35.4437 139.638
254 254   Greenland 2020-03-16T16:53:06 1 0 0 71.7069 -42.6043
164 164 Arkansas US 2020-03-16T17:13:23 22 0 0 34.9697 -92.3731
183 183 Vermont US 2020-03-16T17:13:23 12 0 0 44.0459 -72.7107
88 88 British Columbia Canada 2020-03-16T19:13:13 103 4 4 53.7267 -127.6476
204 204 Saskatchewan Canada 2020-03-16T20:13:20 7 0 0 52.9399 -106.4509
65 65 Yunnan China 2020-03-16T23:53:02 176 2 172 24.974 101.487
160 160 Iowa US 2020-03-16T23:53:03 23 0 0 42.0115 -93.2105
165 165 District of Columbia US 2020-03-16T23:53:03 22 0 0 38.8974 -77.0268
25 25 Shandong China 2020-03-17T00:33:02 761 7 746 36.3427 118.1498
47 47 Guangxi China 2020-03-17T00:33:02 253 2 248 23.8298 108.7881
32 32 Heilongjiang China 2020-03-17T01:33:02 482 13 456 47.862 127.7615
265 265   Tanzania 2020-03-17T01:33:03 1 0 0 -6.369 34.8888
13 13 Guangdong China 2020-03-17T01:53:03 1364 8 1307 23.3417 113.4244
38 38 Shanghai China 2020-03-17T02:13:20 358 3 325 31.202 121.4491
17 17 Zhejiang China 2020-03-17T02:13:21 1232 1 1216 29.1832 120.0934
102 102   Slovakia 2020-03-17T02:13:34 72 0 0 48.669 19.699
150 150   Uruguay 2020-03-17T02:13:54 29 0 0 -32.5228 -55.7658
210 210   Rwanda 2020-03-17T02:33:10 7 0 0 -1.9403 29.8739
53 53   Ireland 2020-03-17T02:53:03 223 2 5 53.1424 -7.6921
233 233 Gibraltar United Kingdom 2020-03-17T02:53:03 3 0 1 36.1408 -5.3536
51 51   Bahrain 2020-03-17T03:13:15 228 1 81 26.0667 50.5577
118 118   Algeria 2020-03-17T03:13:15 60 4 12 28.0339 1.6596
121 121   Ecuador 2020-03-17T03:13:15 58 2 0 -1.8312 -78.1834
132 132   Cyprus 2020-03-17T03:13:15 46 0 0 35.1264 33.4299
134 134   Costa Rica 2020-03-17T03:13:15 41 0 0 9.7489 -83.7534
99 99 Alberta Canada 2020-03-17T03:13:18 74 0 0 53.9333 -116.5765
197 197 Grand Princess Canada 2020-03-17T03:13:18 8 0 0 37.6489 -122.6655
180 180 Macau China 2020-03-17T04:32:18 12 0 10 22.1667 113.55
240 240   Saint Lucia 2020-03-17T04:32:19 2 0 0 13.9094 -60.9789
195 195   Reunion 2020-03-17T07:15:25 9 0 0 -21.1151 55.5364
73 73 Guizhou China 2020-03-17T07:33:03 147 2 144 26.8154 106.8748

Next page

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
);