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

284 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
22 22 Anhui China 2020-03-11T02:18:14 990 6 984 31.8257 117.2264
46 46 Fujian China 2020-03-11T02:18:14 296 1 295 26.0789 117.9874
115 115 Xinjiang China 2020-03-11T02:18:14 76 3 73 41.1129 85.2401
178 178 Qinghai China 2020-03-11T02:18:14 18 0 18 35.7452 95.9956
253 253 Tibet China 2020-03-11T02:18:14 1 0 1 31.6927 88.0924
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
85 85 Shanxi China 2020-03-13T11:09:03 133 0 133 37.5777 112.2922
250 250   Bhutan 2020-03-13T22:22:02 1 0 0 27.5142 90.4336
261 261   Holy See 2020-03-13T22:22:02 1 0 0 41.9029 12.4534
269 269   Togo 2020-03-13T22:22:02 1 0 0 8.6195 0.8248
264 264   Nepal 2020-03-13T22:22:03 1 0 1 28.3949 84.124
249 249 Northern Territory Australia 2020-03-14T01:53:03 1 0 0 -12.4634 130.8456
274 274 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
17 17 Henan China 2020-03-14T09:53:08 1273 22 1250 33.882 113.614
257 257   Gabon 2020-03-14T13:33:04 1 0 0 -0.8037 11.6094
241 241   Namibia 2020-03-14T16:33:03 2 0 0 -22.9576 18.4904
265 265   Saint Vincent and the Grenadines 2020-03-14T16:33:03 1 0 0 12.9843 -61.2872
267 267   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
251 251 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
256 256   Eswatini 2020-03-15T06:41:54 1 0 0 -26.5225 31.4659
260 260   Guinea 2020-03-15T06:41:54 1 0 0 9.9456 -9.6966
83 83 Tianjin China 2020-03-15T18:20:18 136 3 133 39.3054 117.323
84 84 Gansu China 2020-03-15T18:20:18 133 2 91 36.0611 103.8343
190 190   Maldives 2020-03-15T18:20:18 13 0 0 3.2028 73.2207
228 228 French Polynesia France 2020-03-15T18:20:19 3 0 0 -17.6797 -149.4068
239 239   Kosovo 2020-03-15T18:20:19 2 0 0 42.6026 20.903
248 248   Antigua and Barbuda 2020-03-15T18:20:19 1 0 0 17.0608 -61.7964
262 262   Mauritania 2020-03-15T18:20:19 1 0 0 21.0079 -10.9408
99 99 Jilin China 2020-03-16T00:22:10 93 1 92 43.6661 126.1923
221 221 Puerto Rico US 2020-03-16T00:22:11 5 0 0 18.2208 -66.5901
231 231   Kenya 2020-03-16T00:22:11 3 0 0 -0.0236 37.9062
252 252   Central African Republic 2020-03-16T03:33:03 1 0 0 6.6111 20.9394
268 268   The Bahamas 2020-03-16T03:33:03 1 0 0 24.25 -76.0
74 74 Hainan China 2020-03-16T14:38:45 168 6 161 19.1959 109.7453
116 116 Inner Mongolia China 2020-03-16T14:38:45 75 1 73 44.0935 113.9448
117 117 Ningxia China 2020-03-16T14:38:45 75 0 75 37.2692 106.1655
211 211   Monaco 2020-03-16T14:38:45 7 0 0 43.7384 7.4246
219 219 Channel Islands United Kingdom 2020-03-16T14:38:45 6 0 0 49.3723 -2.3644
229 229 Saint Barthelemy France 2020-03-16T14:38:45 3 0 0 17.9 -62.8333
254 254   Congo (Brazzaville) 2020-03-16T14:38:45 1 0 0 -0.228 15.8277
195 195   French Guiana 2020-03-16T14:38:46 11 0 0 3.9339 -53.1258
272 272 Cayman Islands United Kingdom 2020-03-16T14:53:04 1 1 0 19.3133 -81.2546
137 137 Diamond Princess US 2020-03-16T16:53:06 47 0 0 35.4437 139.638
259 259   Greenland 2020-03-16T16:53:06 1 0 0 71.7069 -42.6043
71 71 Yunnan China 2020-03-16T23:53:02 176 2 172 24.974 101.487
26 26 Shandong China 2020-03-17T00:33:02 761 7 746 36.3427 118.1498
18 18 Zhejiang China 2020-03-17T02:13:21 1232 1 1216 29.1832 120.0934
243 243   Saint Lucia 2020-03-17T04:32:19 2 0 0 13.9094 -60.9789
171 171   Dominican Republic 2020-03-17T08:13:22 21 1 0 18.7357 -70.1627
210 210   Guyana 2020-03-17T10:53:03 7 1 0 4.8604 -58.9302
161 161   Azerbaijan 2020-03-17T11:53:10 28 1 6 40.1431 47.5769
170 170   Afghanistan 2020-03-17T11:53:10 24 0 1 33.9391 67.71
215 215   Guatemala 2020-03-17T12:13:16 6 1 0 15.7835 -90.2308
225 225   Seychelles 2020-03-17T12:33:06 4 0 0 -4.6796 55.492
235 235 Curacao Netherlands 2020-03-17T12:33:07 3 0 0 12.1696 -68.99
146 146   Malta 2020-03-17T15:53:12 38 0 2 35.9375 14.3754
200 200   Cameroon 2020-03-17T15:53:13 10 0 0 3.848 11.5021
282 282   Puerto Rico 2020-03-17T16:13:14 0 0 0 18.2 -66.5
48 48   Slovenia 2020-03-17T16:53:04 275 1 0 46.1512 14.9955
73 73   Saudi Arabia 2020-03-17T17:53:03 171 0 6 23.8859 45.0792
177 177 Oklahoma US 2020-03-17T17:53:03 19 0 0 35.5653 -96.9289
227 227 Newfoundland and Labrador Canada 2020-03-17T17:53:03 3 0 0 53.1355 -57.6604
280 280   Guernsey 2020-03-17T18:33:03 0 0 0 49.45 -2.58
281 281   Jersey 2020-03-17T18:33:03 0 0 0 49.19 -2.11
188 188   Ukraine 2020-03-17T19:33:02 14 2 0 48.3794 31.1656
209 209   Ghana 2020-03-17T19:33:02 7 0 0 7.9465 -1.0232
132 132 Utah US 2020-03-17T20:53:02 51 0 0 40.15 -111.8624
141 141   Andorra 2020-03-17T20:53:02 39 0 1 42.5063 1.5218
172 172 Grand Princess US 2020-03-17T20:53:02 21 0 0 37.6489 -122.6655
246 246 Virgin Islands US 2020-03-17T20:53:02 2 0 0 18.3358 -64.8963
283 283   Republic of the Congo 2020-03-17T21:33:03 0 0 0 -1.44 15.556
123 123 Connecticut US 2020-03-17T23:13:10 68 0 0 41.5978 -72.7554
138 138 South Carolina US 2020-03-17T23:13:10 47 1 0 33.8569 -80.945
167 167 New Hampshire US 2020-03-17T23:13:10 26 0 0 43.4525 -71.5639
169 169 New Mexico US 2020-03-17T23:13:10 23 0 0 34.8405 -106.2485
179 179 Kansas US 2020-03-17T23:13:10 18 1 0 38.5266 -96.7265
198 198 South Dakota US 2020-03-17T23:33:02 11 1 0 44.2998 -99.4388
271 271 West Virginia US 2020-03-17T23:33:02 1 0 0 38.4912 -80.9545
245 245 United States Virgin Islands US 2020-03-18T00:13:13 2 0 0 18.35 -64.933
55 55 Guangxi China 2020-03-18T00:33:02 253 2 250 23.8298 108.7881
242 242 Aruba Netherlands 2020-03-18T00:53:02 2 0 0 12.5186 -70.0358
266 266   Somalia 2020-03-18T00:53:03 1 0 0 5.1521 46.1996
80 80 Guizhou China 2020-03-18T01:53:03 146 2 144 26.8154 106.8748
31 31 Sichuan China 2020-03-18T02:13:05 540 3 525 30.6171 102.7103
87 87 Liaoning China 2020-03-18T02:13:06 125 1 122 41.2956 122.6085
91 91   United Arab Emirates 2020-03-18T02:33:06 113 0 26 23.4241 53.8478
95 95   Turkey 2020-03-18T02:33:06 98 1 0 38.9637 35.2433
7 7   Korea, South 2020-03-18T02:53:03 8413 84 1540 35.9078 127.7669
89 89   San Marino 2020-03-18T02:53:03 119 11 4 43.9424 12.4578
174 174   New Zealand 2020-03-18T02:53:03 20 0 0 -40.9006 174.886
234 234   Mayotte 2020-03-18T02:53:03 3 0 0 -12.8275 45.1662
47 47   Ireland 2020-03-18T03:13:12 292 2 5 53.1424 -7.6921
67 67   Egypt 2020-03-18T03:13:14 196 6 32 26.8206 30.8025
92 92   Ecuador 2020-03-18T03:13:19 111 2 0 -1.8312 -78.1834
135 135   Cyprus 2020-03-18T03:13:19 49 0 0 35.1264 33.4299
240 240   Liberia 2020-03-18T03:13:22 2 0 0 6.4281 -9.4295

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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