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

230 rows sorted by Longitude

View and edit SQL

Suggested facets: Last Update, Deaths, Last Update (date)

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude ▼
183 Hawaii US 2020-03-11T20:00:00 2 0 0 21.094318 -157.498337
173 Alaska US 2020-03-11T20:00:00 1 0 0 61.370716 -152.404419
39 British Columbia Canada 2020-03-11T20:00:00 64 1 4 53.7267 -127.6476
128 Grand Princess Canada 2020-03-11T20:00:00 2 0 0 37.6489 -122.6655
162 Grand Princess US 2020-03-11T20:00:00 21 0 0 37.64894 -122.665479
209 Oregon US 2020-03-11T20:00:00 30 0 0 44.572021 -122.070938
219 Washington US 2020-03-11T20:00:00 568 37 1 47.400902 -121.490494
176 California US 2020-03-11T20:00:00 282 4 6 36.116203 -119.681564
200 Nevada US 2020-03-11T20:00:00 17 0 0 38.313515 -117.055374
149 Alberta Canada 2020-03-11T20:00:00 29 0 0 53.9333 -116.5765
184 Idaho US 2020-03-11T20:00:00 1 0 0 44.240459 -114.478828
216 Utah US 2020-03-11T20:00:00 9 0 0 40.150032 -111.862434
174 Arizona US 2020-03-11T20:00:00 9 0 1 33.729759 -111.431221
198 Montana US 2020-03-11T20:00:00 1 0 0 46.921925 -110.454353
222 Wyoming US 2020-03-11T20:00:00 1 0 0 42.755966 -107.30249
112 Saskatchewan Canada 2020-03-11T20:00:00 2 0 0 52.9399 -106.4509
203 New Mexico US 2020-03-11T20:00:00 10 0 0 34.840515 -106.248482
177 Colorado US 2020-03-11T20:00:00 49 0 0 39.059811 -105.311104
160   Mexico 2020-03-11T20:00:00 12 0 4 23.6345 -102.5528
206 North Dakota US 2020-03-11T20:00:00 1 0 0 47.528912 -99.784012
213 South Dakota US 2020-03-11T20:00:00 8 1 0 44.299782 -99.438828
111 Manitoba Canada 2020-03-11T20:00:00 4 0 0 53.7609 -98.8139
199 Nebraska US 2020-03-11T20:00:00 13 0 0 41.12537 -98.268082
215 Texas US 2020-03-11T20:00:00 43 0 0 31.054487 -97.563461
208 Oklahoma US 2020-03-11T20:00:00 2 0 0 35.565342 -96.928917
188 Kansas US 2020-03-11T20:00:00 5 1 0 38.5266 -96.726486
195 Minnesota US 2020-03-11T20:00:00 14 0 0 45.694454 -93.900192
187 Iowa US 2020-03-11T20:00:00 17 0 0 42.011539 -93.210526
175 Arkansas US 2020-03-11T20:00:00 6 0 0 34.969704 -92.373123
197 Missouri US 2020-03-11T20:00:00 2 0 0 38.456085 -92.288368
190 Louisiana US 2020-03-11T20:00:00 36 0 0 31.169546 -91.867805
196 Mississippi US 2020-03-11T20:00:00 1 0 0 32.741646 -89.678696
221 Wisconsin US 2020-03-11T20:00:00 19 0 1 44.268543 -89.616508
185 Illinois US 2020-03-11T20:00:00 46 0 2 40.349457 -88.986137
140 Alabama US 2020-03-11T20:00:00 5 0 0 32.3182 -86.9023
214 Tennessee US 2020-03-11T20:00:00 26 0 0 35.747845 -86.692345
186 Indiana US 2020-03-11T20:00:00 13 0 0 39.849426 -86.258278
56   Honduras 2020-03-11T20:00:00 2 0 0 15.2 -86.2419
52 Ontario Canada 2020-03-11T20:00:00 74 0 4 51.2538 -85.3232
189 Kentucky US 2020-03-11T20:00:00 14 0 0 37.66814 -84.670067
194 Michigan US 2020-03-11T20:00:00 16 0 0 43.326618 -84.536095
148   Costa Rica 2020-03-11T20:00:00 23 0 0 9.7489 -83.7534
182 Georgia US 2020-03-11T20:00:00 42 1 0 33.040619 -83.643074
207 Ohio US 2020-03-11T20:00:00 13 0 0 40.388783 -82.764915
181 Florida US 2020-03-11T20:00:00 50 2 0 27.766279 -81.686783
102   Cayman Islands 2020-03-11T20:00:00 1 0 0 19.3133 -81.2546
220 West Virginia US 2020-03-11T20:00:00 0 0 0 38.491226 -80.954453
212 South Carolina US 2020-03-11T20:00:00 13 0 0 33.856892 -80.945007
34   Panama 2020-03-11T20:00:00 27 1 0 8.538 -80.7821
205 North Carolina US 2020-03-11T20:00:00 17 0 0 35.630066 -79.806419
84   Ecuador 2020-03-11T20:00:00 17 0 0 -1.8312 -78.1834
218 Virginia US 2020-03-11T20:00:00 30 0 0 37.769337 -78.169968
89   Cuba 2020-03-11T20:00:00 4 0 0 21.5218 -77.7812
225   Jamaica 2020-03-11T20:00:00 8 0 0 18.1096 -77.2975
210 Pennsylvania US 2020-03-11T20:00:00 41 0 0 40.590752 -77.209755
180 District of Columbia US 2020-03-11T20:00:00 10 0 0 38.897438 -77.026817
192 Maryland US 2020-03-11T20:00:00 18 0 0 39.063946 -76.802101
179 Delaware US 2020-03-11T20:00:00 4 0 0 39.318523 -75.507141
158   Peru 2020-03-11T20:00:00 28 0 0 -9.19 -75.0152
204 New York US 2020-03-11T20:00:00 421 0 0 42.165726 -74.948051
202 New Jersey US 2020-03-11T20:00:00 29 1 0 40.298904 -74.521011
161   Colombia 2020-03-11T20:00:00 13 0 0 4.5709 -74.2973
90 Quebec Canada 2020-03-11T20:00:00 17 0 0 52.9399 -73.5491
178 Connecticut US 2020-03-11T20:00:00 11 0 0 41.597782 -72.755371
217 Vermont US 2020-03-11T20:00:00 2 0 0 44.045876 -72.710686
201 New Hampshire US 2020-03-11T20:00:00 6 0 0 43.452492 -71.563896
130   Chile 2020-03-11T20:00:00 43 0 0 -35.6751 -71.543
193 Massachusetts US 2020-03-11T20:00:00 123 0 1 42.230171 -71.530106
211 Rhode Island US 2020-03-11T20:00:00 14 0 0 41.680893 -71.51178
108   Dominican Republic 2020-03-11T20:00:00 5 0 0 18.7357 -70.1627
127   Aruba 2020-03-11T20:00:00 2 0 0 12.5211 -69.9683
191 Maine US 2020-03-11T20:00:00 1 0 0 44.693947 -69.381927
62 New Brunswick Canada 2020-03-11T20:00:00 1 0 0 46.5653 -66.4619
129   Argentina 2020-03-11T20:00:00 31 2 0 -38.4161 -63.6167
110   Bolivia 2020-03-11T20:00:00 3 0 0 -16.2902 -63.5887
134 St Martin France 2020-03-11T20:00:00 2 0 0 18.0708 -63.0501
133 Saint Barthelemy France 2020-03-11T20:00:00 1 0 0 17.9 -62.8333
122   Antigua and Barbuda 2020-03-11T20:00:00 1 0 0 17.0608 -61.7964
107   Guadeloupe 2020-03-11T20:00:00 1 0 0 16.265 -61.551
164   Martinique 2020-03-11T20:00:00 3 0 0 14.6415 -61.0242
229   Guyana 2020-03-11T20:00:00 1 1 0 5.0 -58.75
167   Paraguay 2020-03-11T20:00:00 6 0 0 -23.4425 -58.4438
165   French Guiana 2020-03-11T20:00:00 5 0 0 3.9339 -53.1258
75   Brazil 2020-03-11T20:00:00 151 0 0 -14.235 -51.9253
83   Iceland 2020-03-11T20:00:00 134 0 1 64.9631 -19.0208
116   Senegal 2020-03-11T20:00:00 10 0 1 14.4974 -14.4524
121   Guinea 2020-03-11T20:00:00 1 0 0 9.9456 -9.6966
119   Portugal 2020-03-11T20:00:00 112 0 1 39.3999 -8.2245
70   Ireland 2020-03-11T20:00:00 90 1 0 53.1424 -7.6921
126   Morocco 2020-03-11T20:00:00 7 1 1 31.7917 -7.0926
136 Faroe Islands Denmark 2020-03-11T20:00:00 3 0 0 61.8926 -6.9118
146   Cote d'Ivoire 2020-03-11T20:00:00 1 0 0 7.54 -5.5471
137 Gibraltar United Kingdom 2020-03-11T20:00:00 1 0 1 36.1408 -5.3536
151   Spain 2020-03-11T20:00:00 5232 133 193 40.4637 -3.7492
87 United Kingdom United Kingdom 2020-03-11T20:00:00 798 8 18 55.3781 -3.436
44 Channel Islands United Kingdom 2020-03-11T20:00:00 2 0 0 49.372284 -2.364351
37   Burkina Faso 2020-03-11T20:00:00 2 0 0 12.2383 -1.5616
157   Togo 2020-03-11T20:00:00 1 0 0 8.6195 0.8248
120   Andorra 2020-03-11T20:00:00 1 0 0 42.5063 1.5218
58   Algeria 2020-03-11T20:00:00 26 2 8 28.0339 1.6596

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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