03-21-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

304 rows sorted by Last Update

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last Update (date)

Link rowid Province/State Country/Region Last Update ▼ Confirmed Deaths Recovered Latitude Longitude
29 29 Anhui China 2020-03-11T02:18:14 990 6 984 31.8257 117.2264
149 149 Xinjiang China 2020-03-11T02:18:14 76 3 73 41.1129 85.2401
204 204 Qinghai China 2020-03-11T02:18:14 18 0 18 35.7452 95.9956
274 274 Tibet China 2020-03-11T02:18:14 1 0 1 31.6927 88.0924
30 30 Jiangxi China 2020-03-12T02:13:04 935 1 934 27.614 115.7221
71 71 Hebei China 2020-03-13T11:09:03 318 6 310 38.0428 114.5149
119 119 Shanxi China 2020-03-13T11:09:03 133 0 133 37.5777 112.2922
281 281   Holy See 2020-03-13T22:22:02 1 0 0 41.9029 12.4534
282 282   Nepal 2020-03-13T22:22:03 1 0 1 28.3949 84.124
292 292 From Diamond Princess Australia 2020-03-14T02:33:04 0 0 0 35.4437 139.638
26 26 Hunan China 2020-03-14T08:33:03 1018 4 1014 27.6104 111.7088
22 22 Henan China 2020-03-14T09:53:08 1273 22 1250 33.882 113.614
286 286   Saint Vincent and the Grenadines 2020-03-14T16:33:03 1 0 0 12.9843 -61.2872
41 41 Jiangsu China 2020-03-15T01:53:02 631 0 631 32.9711 119.455
44 44 Chongqing China 2020-03-15T03:53:04 576 6 570 30.0572 107.874
278 278   Eswatini 2020-03-15T06:41:54 1 0 0 -26.5225 31.4659
221 221   Maldives 2020-03-15T18:20:18 13 0 0 3.2028 73.2207
263 263   Kosovo 2020-03-15T18:20:19 2 0 0 42.6026 20.903
270 270   Antigua and Barbuda 2020-03-15T18:20:19 1 0 0 17.0608 -61.7964
134 134 Jilin China 2020-03-16T00:22:10 93 1 92 43.6661 126.1923
103 103 Hainan China 2020-03-16T14:38:45 168 6 161 19.1959 109.7453
151 151 Ningxia China 2020-03-16T14:38:45 75 0 75 37.2692 106.1655
249 249 Saint Barthelemy France 2020-03-16T14:38:45 3 0 0 17.9 -62.8333
99 99 Yunnan China 2020-03-16T23:53:02 176 2 172 24.974 101.487
266 266   Saint Lucia 2020-03-17T04:32:19 2 0 0 13.9094 -60.9789
229 229   Guyana 2020-03-17T10:53:03 7 1 0 4.8604 -58.9302
301 301   Puerto Rico 2020-03-17T16:13:14 0 0 0 18.2 -66.5
299 299   Guernsey 2020-03-17T18:33:03 0 0 0 49.45 -2.58
300 300   Jersey 2020-03-17T18:33:03 0 0 0 49.19 -2.11
302 302   Republic of the Congo 2020-03-17T21:33:03 0 0 0 -1.44 15.556
287 287   Somalia 2020-03-18T00:53:03 1 0 0 5.1521 46.1996
111 111 Guizhou China 2020-03-18T01:53:03 146 2 144 26.8154 106.8748
291 291 Montserrat United Kingdom 2020-03-18T11:53:04 1 0 0 16.7425 -62.1874
267 267   Sudan 2020-03-18T12:13:09 2 1 0 12.8628 30.2176
257 257   Benin 2020-03-18T14:13:56 2 0 0 9.3077 2.3158
280 280   Gambia, The 2020-03-18T14:13:56 1 0 0 13.4432 -15.3101
304 304   The Gambia 2020-03-18T14:13:56 0 0 0 13.4667 -16.6
293 293 French Guiana France 2020-03-18T14:33:15 0 0 0 4.0 -53.0
294 294 Guadeloupe France 2020-03-18T14:33:15 0 0 0 16.25 -61.5833
295 295 Mayotte France 2020-03-18T14:33:15 0 0 0 -12.8431 45.1383
296 296 Reunion France 2020-03-18T14:33:15 0 0 0 -21.1351 55.2471
298 298   Guam 2020-03-18T19:14:33 0 0 0 13.4443 144.7937
150 150 Inner Mongolia China 2020-03-19T01:03:02 75 1 74 44.0935 113.9448
269 269   Zambia 2020-03-19T01:53:06 2 0 0 -13.1339 27.8493
230 230   Kenya 2020-03-19T02:33:08 7 0 0 -0.0236 37.9062
264 264   Mauritania 2020-03-19T02:33:08 2 0 0 21.0079 -10.9408
260 260 Greenland Denmark 2020-03-19T08:13:19 2 0 0 71.7069 -42.6043
253 253 Curacao Netherlands 2020-03-19T08:53:03 3 1 0 12.1696 -68.99
241 241 St Martin France 2020-03-19T09:33:04 4 0 0 18.0708 -63.0501
297 297   Greenland 2020-03-19T09:33:04 0 0 0 72.0 -40.0
236 236   Tanzania 2020-03-19T11:33:36 6 0 0 -6.369 34.8888
303 303   The Bahamas 2020-03-19T12:13:38 0 0 0 24.25 -76.0
275 275   Djibouti 2020-03-19T14:53:06 1 0 0 11.8251 42.5903
279 279   Fiji 2020-03-19T14:53:06 1 0 0 -17.7134 178.065
259 259 Prince Edward Island Canada 2020-03-19T18:43:03 2 0 0 46.5107 -63.4168
225 225 Gibraltar United Kingdom 2020-03-19T20:13:52 10 0 2 36.1408 -5.3536
252 252   Namibia 2020-03-19T20:13:52 3 0 0 -22.9576 18.4904
247 247   Congo (Brazzaville) 2020-03-19T20:13:56 3 0 0 -0.228 15.8277
254 254 Cayman Islands United Kingdom 2020-03-19T20:13:56 3 1 0 19.3133 -81.2546
235 235   Equatorial Guinea 2020-03-19T20:43:03 6 0 0 1.6508 10.2679
116 116 Tianjin China 2020-03-19T23:43:03 137 3 133 39.3054 117.323
81 81 Guangxi China 2020-03-20T00:43:02 254 2 250 23.8298 108.7881
122 122 Liaoning China 2020-03-20T01:43:03 126 2 122 41.2956 122.6085
54 54 Heilongjiang China 2020-03-20T02:13:46 484 13 463 47.862 127.7615
284 284   Niger 2020-03-20T02:13:52 1 0 0 17.6078 8.0817
220 220 South Dakota US 2020-03-20T02:43:10 14 1 0 44.2998 -99.4388
238 238 Aruba Netherlands 2020-03-20T02:43:10 5 0 0 12.5211 -69.9683
223 223 Grand Princess Canada 2020-03-20T03:13:18 10 0 0 37.6489 -122.6655
183 183   Martinique 2020-03-20T10:13:37 32 1 0 14.6415 -61.0242
191 191   Honduras 2020-03-20T14:13:08 24 0 0 15.2 -86.2419
211 211   Jamaica 2020-03-20T14:13:11 16 1 2 18.1096 -77.2975
227 227   Ethiopia 2020-03-20T14:13:11 9 0 0 9.145 40.4897
258 258   Bhutan 2020-03-20T14:13:37 2 0 0 27.5142 90.4336
190 190   Afghanistan 2020-03-20T14:43:04 30 0 1 33.9391 67.71
243 243   Suriname 2020-03-20T14:43:04 4 0 0 3.9193 -56.0278
290 290 Isle of Man United Kingdom 2020-03-20T15:13:21 1 0 0 54.2361 -4.5481
232 232   Seychelles 2020-03-20T15:43:24 7 0 0 -4.6796 55.492
172 172 Diamond Princess US 2020-03-20T19:43:03 49 0 0 35.4437 139.638
193 193 Grand Princess US 2020-03-20T19:43:03 23 0 0 37.6489 -122.6655
139 139   Jordan 2020-03-20T20:43:02 85 0 1 30.5852 36.2384
209 209   Rwanda 2020-03-20T20:43:03 17 0 0 -1.9403 29.8739
219 219   Montenegro 2020-03-20T20:43:03 14 0 0 42.7087 19.3744
246 246   Central African Republic 2020-03-20T20:43:03 3 0 0 6.6111 20.9394
244 244 Northern Territory Australia 2020-03-20T21:13:29 3 0 0 -12.4634 130.8456
283 283 Sint Maarten Netherlands 2020-03-20T21:13:30 1 0 0 18.0425 -63.0548
177 177 New Mexico US 2020-03-20T21:43:03 43 0 0 34.8405 -106.2485
185 185 Vermont US 2020-03-20T21:43:03 29 2 0 44.0459 -72.7107
251 251   Madagascar 2020-03-20T22:13:53 3 0 0 -18.7669 46.8691
162 162 New Hampshire US 2020-03-21T00:13:22 55 0 0 43.4525 -71.5639
34 34 Shandong China 2020-03-21T00:43:02 764 7 749 36.3427 118.1498
77 77 Fujian China 2020-03-21T01:13:10 303 1 295 26.0789 117.9874
45 45 Sichuan China 2020-03-21T01:13:11 542 3 536 30.6171 102.7103
39 39   Turkey 2020-03-21T01:43:03 670 9 0 38.9637 35.2433
83 83 Shaanxi China 2020-03-21T01:43:03 248 3 239 35.1917 108.8701
173 173   Senegal 2020-03-21T01:43:03 47 0 5 14.4974 -14.4524
37 37 Diamond Princess Cruise Ship 2020-03-21T02:13:32 712 8 325 35.4498 139.6649
91 91   Panama 2020-03-21T02:13:32 200 1 0 8.538 -80.7821
168 168   New Zealand 2020-03-21T02:13:32 52 0 0 -40.9006 174.886
197 197   Cuba 2020-03-21T02:13:32 21 1 0 21.5218 -77.7812
242 242   Gabon 2020-03-21T02:13:32 4 1 0 -0.8037 11.6094

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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