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

272 rows sorted by Longitude

View and edit SQL

Suggested facets: Deaths, Last Update (date)

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude ▼
191 Hawaii US 2020-03-16T02:53:12 7 0 0 21.0943 -157.4983
265 Alaska US 2020-03-13T14:53:03 1 0 0 61.3707 -152.4044
212 French Polynesia France 2020-03-15T18:20:19 3 0 0 -17.6797 -149.4068
82 British Columbia Canada 2020-03-16T19:13:13 103 4 4 53.7267 -127.6476
152 Grand Princess US 2020-03-16T17:13:23 20 0 0 37.6489 -122.6655
224 Grand Princess Canada 2020-03-16T00:22:11 2 0 0 37.6489 -122.6655
123 Oregon US 2020-03-16T02:33:09 39 1 0 44.572 -122.0709
23 Washington US 2020-03-16T23:53:03 904 48 1 47.4009 -121.4905
30 California US 2020-03-16T23:53:03 557 7 6 36.1162 -119.6816
120 Nevada US 2020-03-16T20:13:20 45 1 0 38.3135 -117.0554
102 Alberta Canada 2020-03-16T02:33:09 56 0 0 53.9333 -116.5765
205 Idaho US 2020-03-15T18:20:19 5 0 0 44.2405 -114.4788
124 Utah US 2020-03-16T22:33:03 39 0 0 40.15 -111.8624
157 Arizona US 2020-03-16T17:13:23 18 0 1 33.7298 -111.4312
192 Montana US 2020-03-15T18:20:19 7 0 0 46.9219 -110.4544
220 Wyoming US 2020-03-15T02:53:03 3 0 0 42.756 -107.3025
189 Saskatchewan Canada 2020-03-16T20:13:20 7 0 0 52.9399 -106.4509
163 New Mexico US 2020-03-16T02:53:12 17 0 0 34.8405 -106.2485
59 Colorado US 2020-03-16T23:53:03 160 1 0 39.0598 -105.3111
109   Mexico 2020-03-16T14:38:45 53 0 4 23.6345 -102.5528
266 North Dakota US 2020-03-12T09:33:03 1 0 0 47.5289 -99.784
179 South Dakota US 2020-03-16T20:13:20 10 1 0 44.2998 -99.4388
188 Manitoba Canada 2020-03-16T02:53:12 7 0 0 53.7609 -98.8139
158 Nebraska US 2020-03-16T17:13:23 18 0 0 41.1254 -98.2681
88 Texas US 2020-03-16T23:53:03 85 0 0 31.0545 -97.5635
178 Oklahoma US 2020-03-16T18:14:12 10 0 0 35.5653 -96.9289
175 Kansas US 2020-03-16T17:13:23 11 1 0 38.5266 -96.7265
108 Minnesota US 2020-03-16T16:53:06 54 0 0 45.6945 -93.9002
144 Iowa US 2020-03-16T23:53:03 23 0 0 42.0115 -93.2105
146 Arkansas US 2020-03-16T17:13:23 22 0 0 34.9697 -92.3731
198 Missouri US 2020-03-16T17:13:23 6 0 0 38.4561 -92.2884
70 Louisiana US 2020-03-16T22:13:21 136 3 0 31.1695 -91.8678
227   Guatemala 2020-03-16T14:38:45 2 1 0 15.7835 -90.2308
169 Mississippi US 2020-03-16T22:33:03 13 0 0 32.7416 -89.6787
119 Wisconsin US 2020-03-16T20:13:20 47 0 1 44.2685 -89.6165
81 Illinois US 2020-03-16T22:13:21 105 0 2 40.3495 -88.9861
137 Alabama US 2020-03-16T22:33:03 29 0 0 32.3182 -86.9023
113 Tennessee US 2020-03-16T22:13:21 52 0 0 35.7478 -86.6923
141 Indiana US 2020-03-16T22:33:03 25 1 0 39.8494 -86.2583
197   Honduras 2020-03-16T14:38:45 6 0 0 15.2 -86.2419
53 Ontario Canada 2020-03-16T16:13:26 177 0 5 51.2538 -85.3232
149 Kentucky US 2020-03-16T18:33:03 21 1 1 37.6681 -84.6701
110 Michigan US 2020-03-16T14:38:46 53 0 0 43.3266 -84.5361
128   Costa Rica 2020-03-16T02:33:08 35 0 0 9.7489 -83.7534
77 Georgia US 2020-03-16T16:53:06 121 1 0 33.0406 -83.6431
116 Ohio US 2020-03-16T20:13:21 50 0 0 40.3888 -82.7649
63 Florida US 2020-03-16T22:13:21 155 5 0 27.7663 -81.6868
268 Cayman Islands United Kingdom 2020-03-16T14:53:04 1 1 0 19.3133 -81.2546
271 West Virginia US 2020-03-10T02:33:04 0 0 0 38.4912 -80.9545
132 South Carolina US 2020-03-16T22:33:03 33 1 0 33.8569 -80.945
103   Panama 2020-03-16T14:38:45 55 1 0 8.538 -80.7821
125 North Carolina US 2020-03-16T23:53:03 38 0 0 35.6301 -79.8064
126   Ecuador 2020-03-16T02:33:08 37 2 0 -1.8312 -78.1834
117 Virginia US 2020-03-16T22:13:21 49 1 0 37.7693 -78.17
208   Cuba 2020-03-13T23:53:02 4 0 0 21.5218 -77.7812
176   Jamaica 2020-03-16T01:53:03 10 0 2 18.1096 -77.2975
90 Pennsylvania US 2020-03-16T20:13:20 77 0 0 40.5908 -77.2098
147 District of Columbia US 2020-03-16T23:53:03 22 0 0 38.8974 -77.0268
121 Maryland US 2020-03-16T20:13:20 41 0 3 39.0639 -76.8021
263   The Bahamas 2020-03-16T03:33:03 1 0 0 24.25 -76.0
184 Delaware US 2020-03-16T20:13:20 8 0 0 39.3185 -75.5071
87   Peru 2020-03-16T14:38:45 86 0 0 -9.19 -75.0152
20 New York US 2020-03-16T21:53:03 967 10 0 42.1657 -74.9481
52 New Jersey US 2020-03-16T22:13:21 178 2 1 40.2989 -74.521
107   Colombia 2020-03-16T14:38:45 54 0 0 4.5709 -74.2973
115 Quebec Canada 2020-03-16T20:13:20 50 0 0 52.9399 -73.5491
134 Connecticut US 2020-03-16T20:13:20 30 0 0 41.5978 -72.7554
170 Vermont US 2020-03-16T17:13:23 12 0 0 44.0459 -72.7107
162 New Hampshire US 2020-03-16T22:33:03 17 0 0 43.4525 -71.5639
61   Chile 2020-03-16T14:38:45 155 0 0 -35.6751 -71.543
50 Massachusetts US 2020-03-16T21:53:03 197 0 1 42.2302 -71.5301
150 Rhode Island US 2020-03-16T18:14:12 21 0 0 41.6809 -71.5118
173   Dominican Republic 2020-03-14T20:53:02 11 0 0 18.7357 -70.1627
222   Aruba 2020-03-13T23:53:03 2 0 0 12.5211 -69.9683
161 Maine US 2020-03-16T18:14:12 17 0 0 44.6939 -69.3819
256 Curacao Netherlands 2020-03-16T00:22:11 1 0 0 12.1696 -68.99
206 Puerto Rico US 2020-03-16T00:22:11 5 0 0 18.2208 -66.5901
164   Venezuela 2020-03-16T00:53:03 17 0 0 6.4238 -66.5897
217   Puerto Rico 2020-03-16T14:38:45 3 0 0 18.2 -66.5
194 New Brunswick Canada 2020-03-16T02:53:12 6 0 0 46.5653 -66.4619
267 Virgin Islands US 2020-03-16T00:22:11 1 0 0 18.3358 -64.8963
201 Nova Scotia Canada 2020-03-16T17:53:03 5 0 0 44.682 -63.7443
101   Argentina 2020-03-16T14:38:45 56 2 1 -38.4161 -63.6167
171   Bolivia 2020-03-16T14:38:45 11 0 0 -16.2902 -63.5887
238 Prince Edward Island Canada 2020-03-15T02:13:21 1 0 0 46.5107 -63.4168
226 St Martin France 2020-03-14T16:33:03 2 0 0 18.0708 -63.0501
214 Saint Barthelemy France 2020-03-16T14:38:45 3 0 0 17.9 -62.8333
233   Antigua and Barbuda 2020-03-15T18:20:19 1 0 0 17.0608 -61.7964
213 Guadeloupe France 2020-03-16T14:38:45 3 0 0 16.25 -61.5833
196   Guadeloupe 2020-03-16T14:38:45 6 0 0 16.265 -61.551
258   Saint Vincent and the Grenadines 2020-03-14T16:33:03 1 0 0 12.9843 -61.2872
211   Trinidad and Tobago 2020-03-16T14:38:45 4 0 0 10.6918 -61.2225
167   Martinique 2020-03-16T14:38:45 15 1 0 14.6415 -61.0242
232   Saint Lucia 2020-03-16T00:22:11 2 0 0 13.9094 -60.9789
209   Guyana 2020-03-15T18:20:19 4 1 0 4.8604 -58.9302
183   Paraguay 2020-03-16T14:38:45 8 0 0 -23.4425 -58.4438
237 Newfoundland and Labrador Canada 2020-03-15T02:13:21 1 0 0 53.1355 -57.6604
261   Suriname 2020-03-14T16:33:03 1 0 0 3.9193 -56.0278
185   Uruguay 2020-03-16T14:38:45 8 0 0 -32.5228 -55.7658
174   French Guiana 2020-03-16T14:38:46 11 0 0 3.9339 -53.1258

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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