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 rowid descending

View and edit SQL

Suggested facets: Deaths, Last Update (date)

Link rowid ▲ Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
276   occupied Palestinian territory 2020-03-11T20:53:02 0 0 0 31.9522 35.2332
275   Republic of the Congo 2020-03-17T21:33:03 0 0 0 -1.44 15.556
274   Puerto Rico 2020-03-17T16:13:14 0 0 0 18.2 -66.5
273   Jersey 2020-03-17T18:33:03 0 0 0 49.19 -2.11
272   Guernsey 2020-03-17T18:33:03 0 0 0 49.45 -2.58
271 From Diamond Princess Australia 2020-03-14T02:33:04 0 0 0 35.4437 139.638
270 Cayman Islands United Kingdom 2020-03-16T14:53:04 1 1 0 19.3133 -81.2546
269 West Virginia US 2020-03-17T23:33:02 1 0 0 38.4912 -80.9545
268   Togo 2020-03-13T22:22:02 1 0 0 8.6195 0.8248
267   The Gambia 2020-03-17T23:33:02 1 0 0 13.4667 -16.6
266   The Bahamas 2020-03-16T03:33:03 1 0 0 24.25 -76.0
265   Tanzania 2020-03-17T01:33:03 1 0 0 -6.369 34.8888
264   Suriname 2020-03-14T16:33:03 1 0 0 3.9193 -56.0278
263   Sudan 2020-03-14T01:13:32 1 1 0 12.8628 30.2176
262   Somalia 2020-03-16T14:38:46 1 0 0 5.1521 46.1996
261   Saint Vincent and the Grenadines 2020-03-14T16:33:03 1 0 0 12.9843 -61.2872
260   Nepal 2020-03-13T22:22:03 1 0 1 28.3949 84.124
259   Mayotte 2020-03-16T14:38:45 1 0 0 -12.8275 45.1662
258   Mauritania 2020-03-15T18:20:19 1 0 0 21.0079 -10.9408
257   Liberia 2020-03-17T12:13:16 1 0 0 6.4281 -9.4295
256   Holy See 2020-03-13T22:22:02 1 0 0 41.9029 12.4534
255   Guinea 2020-03-15T06:41:54 1 0 0 9.9456 -9.6966
254   Greenland 2020-03-16T16:53:06 1 0 0 71.7069 -42.6043
253   Gabon 2020-03-14T13:33:04 1 0 0 -0.8037 11.6094
252 Mayotte France 2020-03-16T14:38:45 1 0 0 -12.8431 45.1383
251   Eswatini 2020-03-15T06:41:54 1 0 0 -26.5225 31.4659
250   Equatorial Guinea 2020-03-15T06:41:54 1 0 0 1.5 10.0
249   Congo (Brazzaville) 2020-03-16T14:38:45 1 0 0 -0.228 15.8277
248 Tibet China 2020-03-11T02:18:14 1 0 1 31.6927 88.0924
247   Central African Republic 2020-03-16T03:33:03 1 0 0 6.6111 20.9394
246 Prince Edward Island Canada 2020-03-15T02:13:21 1 0 0 46.5107 -63.4168
245   Bhutan 2020-03-13T22:22:02 1 0 0 27.5142 90.4336
244   Benin 2020-03-16T14:38:46 1 0 0 9.3077 2.3158
243 Northern Territory Australia 2020-03-14T01:53:03 1 0 0 -12.4634 130.8456
242   Antigua and Barbuda 2020-03-15T18:20:19 1 0 0 17.0608 -61.7964
241 Virgin Islands US 2020-03-17T20:53:02 2 0 0 18.3358 -64.8963
240   Saint Lucia 2020-03-17T04:32:19 2 0 0 13.9094 -60.9789
239   Namibia 2020-03-14T16:33:03 2 0 0 -22.9576 18.4904
238   Montenegro 2020-03-17T21:33:02 2 0 0 42.5 19.3
237   Kosovo 2020-03-15T18:20:19 2 0 0 42.6026 20.903
236 St Martin France 2020-03-14T16:33:03 2 0 0 18.0708 -63.0501
235   Barbados 2020-03-17T16:13:14 2 0 0 13.1939 -59.5432
234 Australian Capital Territory Australia 2020-03-16T14:38:46 2 0 0 -35.4735 149.0124
233 Gibraltar United Kingdom 2020-03-17T02:53:03 3 0 1 36.1408 -5.3536
232 North Dakota US 2020-03-17T23:33:02 3 0 0 47.5289 -99.784
231 Guam US 2020-03-15T18:20:19 3 0 0 13.4443 144.7937
230 Alaska US 2020-03-17T17:33:03 3 0 0 61.3707 -152.4044
229   Nigeria 2020-03-17T12:33:06 3 0 0 9.082 8.6753
228 Curacao Netherlands 2020-03-17T12:33:07 3 0 0 12.1696 -68.99
227   Kenya 2020-03-16T00:22:11 3 0 0 -0.0236 37.9062
226   Guam 2020-03-16T02:13:16 3 0 0 13.4443 144.7937
225 Saint Barthelemy France 2020-03-16T14:38:45 3 0 0 17.9 -62.8333
224 French Polynesia France 2020-03-15T18:20:19 3 0 0 -17.6797 -149.4068
223   Congo (Kinshasa) 2020-03-17T12:33:06 3 0 0 -4.0383 21.7587
222 Newfoundland and Labrador Canada 2020-03-17T17:53:03 3 0 0 53.1355 -57.6604
221   Aruba 2020-03-17T12:33:07 3 0 0 12.5211 -69.9683
220   Seychelles 2020-03-17T12:33:06 4 0 0 -4.6796 55.492
219 Puerto Rico US 2020-03-16T00:22:11 5 0 0 18.2208 -66.5901
218   Trinidad and Tobago 2020-03-17T15:53:13 5 0 0 10.6918 -61.2225
217   Mongolia 2020-03-17T15:53:13 5 0 0 46.8625 103.8467
216   Ethiopia 2020-03-16T14:38:45 5 0 0 9.145 40.4897
215   Cuba 2020-03-17T15:53:13 5 0 0 21.5218 -77.7812
214   Cote d'Ivoire 2020-03-17T14:33:05 5 0 1 7.54 -5.5471
213 Channel Islands United Kingdom 2020-03-16T14:38:45 6 0 0 49.3723 -2.3644
212   Guatemala 2020-03-17T12:13:16 6 1 0 15.7835 -90.2308
211 Guadeloupe France 2020-03-17T07:33:03 6 0 0 16.25 -61.5833
210   Rwanda 2020-03-17T02:33:10 7 0 0 -1.9403 29.8739
209   Monaco 2020-03-16T14:38:45 7 0 0 43.7384 7.4246
208   Liechtenstein 2020-03-17T12:13:16 7 0 0 47.166 9.5554
207   Guyana 2020-03-17T10:53:03 7 1 0 4.8604 -58.9302
206   Ghana 2020-03-17T19:33:02 7 0 0 7.9465 -1.0232
205 French Guiana France 2020-03-17T07:33:03 7 0 0 4.0 -53.0
204 Saskatchewan Canada 2020-03-16T20:13:20 7 0 0 52.9399 -106.4509
203 Nova Scotia Canada 2020-03-17T19:33:03 7 0 0 44.682 -63.7443
202 Tasmania Australia 2020-03-16T14:38:46 7 0 0 -41.4545 145.9707
201 Idaho US 2020-03-17T23:33:02 8 0 0 44.2405 -114.4788
200   Honduras 2020-03-17T12:13:16 8 0 0 15.2 -86.2419
199 New Brunswick Canada 2020-03-17T19:33:03 8 0 0 46.5653 -66.4619
198 Manitoba Canada 2020-03-17T19:33:03 8 0 0 53.7609 -98.8139
197 Grand Princess Canada 2020-03-17T03:13:18 8 0 0 37.6489 -122.6655
196 Montana US 2020-03-17T17:33:03 9 0 0 46.9219 -110.4544
195   Reunion 2020-03-17T07:15:25 9 0 0 -21.1151 55.5364
194   Paraguay 2020-03-17T12:13:16 9 0 0 -23.4425 -58.4438
193 Reunion France 2020-03-17T11:13:29 9 0 0 -21.1351 55.2471
192   Uzbekistan 2020-03-17T12:13:16 10 0 0 41.3775 64.5853
191 Hawaii US 2020-03-17T17:33:03 10 0 0 21.0943 -157.4983
190   Cameroon 2020-03-17T15:53:13 10 0 0 3.848 11.5021
189   Bangladesh 2020-03-17T12:13:16 10 0 3 23.685 90.3563
188 Wyoming US 2020-03-17T23:53:03 11 0 0 42.756 -107.3025
187 South Dakota US 2020-03-17T23:33:02 11 1 0 44.2998 -99.4388
186 Missouri US 2020-03-17T23:33:02 11 0 0 38.4561 -92.2884
185   French Guiana 2020-03-16T14:38:46 11 0 0 3.9339 -53.1258
184   Bolivia 2020-03-16T14:38:45 11 0 0 -16.2902 -63.5887
183 Vermont US 2020-03-16T17:13:23 12 0 0 44.0459 -72.7107
182   New Zealand 2020-03-17T11:53:10 12 0 0 -40.9006 174.886
181   Jamaica 2020-03-17T12:13:16 12 0 2 18.1096 -77.2975
180 Macau China 2020-03-17T04:32:18 12 0 10 22.1667 113.55
179   Maldives 2020-03-15T18:20:18 13 0 0 3.2028 73.2207
178   Ukraine 2020-03-17T19:33:02 14 2 0 48.3794 31.1656
177   Burkina Faso 2020-03-16T14:38:45 15 0 0 12.2383 -1.5616

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