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 Confirmed

View and edit SQL

Suggested facets: Last Update (date)

Link rowid Province/State Country/Region Last Update Confirmed ▼ Deaths Recovered Latitude Longitude
292 From Diamond Princess Australia 2020-03-14T02:33:04 0 0 0 35.4437 139.638
293 French Guiana France 2020-03-18T14:33:15 0 0 0 4.0 -53.0
294 Guadeloupe France 2020-03-18T14:33:15 0 0 0 16.25 -61.5833
295 Mayotte France 2020-03-18T14:33:15 0 0 0 -12.8431 45.1383
296 Reunion France 2020-03-18T14:33:15 0 0 0 -21.1351 55.2471
297   Greenland 2020-03-19T09:33:04 0 0 0 72.0 -40.0
298   Guam 2020-03-18T19:14:33 0 0 0 13.4443 144.7937
299   Guernsey 2020-03-17T18:33:03 0 0 0 49.45 -2.58
300   Jersey 2020-03-17T18:33:03 0 0 0 49.19 -2.11
301   Puerto Rico 2020-03-17T16:13:14 0 0 0 18.2 -66.5
302   Republic of the Congo 2020-03-17T21:33:03 0 0 0 -1.44 15.556
303   The Bahamas 2020-03-19T12:13:38 0 0 0 24.25 -76.0
304   The Gambia 2020-03-18T14:13:56 0 0 0 13.4667 -16.6
270   Antigua and Barbuda 2020-03-15T18:20:19 1 0 0 17.0608 -61.7964
271 Northwest Territories Canada 2020-03-21T21:13:30 1 0 0 64.8255 -124.8457
272   Cape Verde 2020-03-21T23:43:02 1 0 0 15.1111 -23.6167
273   Chad 2020-03-21T03:13:14 1 0 0 15.4542 18.7322
274 Tibet China 2020-03-11T02:18:14 1 0 1 31.6927 88.0924
275   Djibouti 2020-03-19T14:53:06 1 0 0 11.8251 42.5903
276   East Timor 2020-03-21T14:43:04 1 0 0 -8.55 125.56
277   Eritrea 2020-03-21T21:13:30 1 0 0 15.1794 39.7823
278   Eswatini 2020-03-15T06:41:54 1 0 0 -26.5225 31.4659
279   Fiji 2020-03-19T14:53:06 1 0 0 -17.7134 178.065
280   Gambia, The 2020-03-18T14:13:56 1 0 0 13.4432 -15.3101
281   Holy See 2020-03-13T22:22:02 1 0 0 41.9029 12.4534
282   Nepal 2020-03-13T22:22:03 1 0 1 28.3949 84.124
283 Sint Maarten Netherlands 2020-03-20T21:13:30 1 0 0 18.0425 -63.0548
284   Niger 2020-03-20T02:13:52 1 0 0 17.6078 8.0817
285   Papua New Guinea 2020-03-21T23:43:02 1 0 0 -6.315 143.9555
286   Saint Vincent and the Grenadines 2020-03-14T16:33:03 1 0 0 12.9843 -61.2872
287   Somalia 2020-03-18T00:53:03 1 0 0 5.1521 46.1996
288 US US 2020-03-21T19:43:03 1 0 171 37.0902 -95.7129
289   Uganda 2020-03-21T23:43:02 1 0 0 1.0 32.0
290 Isle of Man United Kingdom 2020-03-20T15:13:21 1 0 0 54.2361 -4.5481
291 Montserrat United Kingdom 2020-03-18T11:53:04 1 0 0 16.7425 -62.1874
256   Angola 2020-03-21T14:43:04 2 0 0 -11.2027 17.8739
257   Benin 2020-03-18T14:13:56 2 0 0 9.3077 2.3158
258   Bhutan 2020-03-20T14:13:37 2 0 0 27.5142 90.4336
259 Prince Edward Island Canada 2020-03-19T18:43:03 2 0 0 46.5107 -63.4168
260 Greenland Denmark 2020-03-19T08:13:19 2 0 0 71.7069 -42.6043
261   Guinea 2020-03-21T02:13:32 2 0 0 9.9456 -9.6966
262   Haiti 2020-03-21T14:43:04 2 0 0 18.9712 -72.2852
263   Kosovo 2020-03-15T18:20:19 2 0 0 42.6026 20.903
264   Mauritania 2020-03-19T02:33:08 2 0 0 21.0079 -10.9408
265   Nicaragua 2020-03-21T02:13:34 2 0 0 12.8654 -85.2072
266   Saint Lucia 2020-03-17T04:32:19 2 0 0 13.9094 -60.9789
267   Sudan 2020-03-18T12:13:09 2 1 0 12.8628 30.2176
268 Bermuda United Kingdom 2020-03-21T03:13:14 2 0 0 32.3078 -64.7505
269   Zambia 2020-03-19T01:53:06 2 0 0 -13.1339 27.8493
244 Northern Territory Australia 2020-03-20T21:13:29 3 0 0 -12.4634 130.8456
245   Cabo Verde 2020-03-21T15:13:46 3 0 0 16.5388 -23.0418
246   Central African Republic 2020-03-20T20:43:03 3 0 0 6.6111 20.9394
247   Congo (Brazzaville) 2020-03-19T20:13:56 3 0 0 -0.228 15.8277
248   El Salvador 2020-03-21T12:43:08 3 0 0 13.7942 -88.8965
249 Saint Barthelemy France 2020-03-16T14:38:45 3 0 0 17.9 -62.8333
250   Liberia 2020-03-21T12:43:08 3 0 0 6.4281 -9.4295
251   Madagascar 2020-03-20T22:13:53 3 0 0 -18.7669 46.8691
252   Namibia 2020-03-19T20:13:52 3 0 0 -22.9576 18.4904
253 Curacao Netherlands 2020-03-19T08:53:03 3 1 0 12.1696 -68.99
254 Cayman Islands United Kingdom 2020-03-19T20:13:56 3 1 0 19.3133 -81.2546
255   Zimbabwe 2020-03-21T12:43:08 3 0 0 -19.0154 29.1549
239   Bahamas, The 2020-03-21T02:43:03 4 0 0 25.0343 -77.3963
240 New Caledonia France 2020-03-21T17:43:03 4 0 0 -20.9043 165.618
241 St Martin France 2020-03-19T09:33:04 4 0 0 18.0708 -63.0501
242   Gabon 2020-03-21T02:13:32 4 1 0 -0.8037 11.6094
243   Suriname 2020-03-20T14:43:04 4 0 0 3.9193 -56.0278
238 Aruba Netherlands 2020-03-20T02:43:10 5 0 0 12.5211 -69.9683
233   Barbados 2020-03-21T02:43:03 6 0 0 13.1939 -59.5432
234 Newfoundland and Labrador Canada 2020-03-21T21:13:29 6 0 0 53.1355 -57.6604
235   Equatorial Guinea 2020-03-19T20:43:03 6 0 0 1.6508 10.2679
236   Tanzania 2020-03-19T11:33:36 6 0 0 -6.369 34.8888
237 United States Virgin Islands US 2020-03-21T17:43:03 6 0 0 18.3358 -64.8963
229   Guyana 2020-03-17T10:53:03 7 1 0 4.8604 -58.9302
230   Kenya 2020-03-19T02:33:08 7 0 0 -0.0236 37.9062
231   Mayotte 2020-03-21T13:13:35 7 0 0 -12.8275 45.1662
232   Seychelles 2020-03-20T15:43:24 7 0 0 -4.6796 55.492
228 West Virginia US 2020-03-21T02:43:03 8 0 0 38.4912 -80.9545
226 Australian Capital Territory Australia 2020-03-21T13:13:35 9 0 0 -35.4735 149.0124
227   Ethiopia 2020-03-20T14:13:11 9 0 0 9.145 40.4897
223 Grand Princess Canada 2020-03-20T03:13:18 10 0 0 37.6489 -122.6655
224   Mongolia 2020-03-21T12:43:08 10 0 0 46.8625 103.8467
225 Gibraltar United Kingdom 2020-03-19T20:13:52 10 0 2 36.1408 -5.3536
222   Monaco 2020-03-21T13:13:32 11 0 0 43.7384 7.4246
221   Maldives 2020-03-15T18:20:18 13 0 0 3.2028 73.2207
216   Cote d'Ivoire 2020-03-21T12:43:08 14 0 1 7.54 -5.5471
217   Kyrgyzstan 2020-03-21T17:43:03 14 0 0 41.2044 74.7661
218   Mauritius 2020-03-21T12:43:08 14 1 0 -20.3484 57.5522
219   Montenegro 2020-03-20T20:43:03 14 0 0 42.7087 19.3744
220 South Dakota US 2020-03-20T02:43:10 14 1 0 44.2998 -99.4388
213 French Polynesia France 2020-03-21T12:43:08 15 0 0 -17.6797 -149.4068
214 Alaska US 2020-03-21T23:13:18 15 0 0 61.3707 -152.4044
215 Guam US 2020-03-21T17:43:03 15 0 0 13.4443 144.7937
210 Tasmania Australia 2020-03-21T13:13:35 16 0 3 -41.4545 145.9707
211   Jamaica 2020-03-20T14:13:11 16 1 2 18.1096 -77.2975
212   Togo 2020-03-21T17:43:03 16 0 1 8.6195 0.8248
207 New Brunswick Canada 2020-03-21T21:13:30 17 0 0 46.5653 -66.4619
208   Guatemala 2020-03-21T21:13:14 17 1 0 15.7835 -90.2308
209   Rwanda 2020-03-20T20:43:03 17 0 0 -1.9403 29.8739
202 Manitoba Canada 2020-03-21T17:43:03 18 0 0 53.7609 -98.8139
203 Macau China 2020-03-21T22:13:24 18 0 10 22.1667 113.55

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