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

206 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 ▼
164 Hawaii US 2020-03-10T03:13:17 2 0 0 21.0943 -157.4983
194 Alaska US 2020-03-10T02:33:04 0 0 0 61.3707 -152.4044
74 British Columbia Canada 2020-03-09T22:43:25 32 1 4 53.7267 -127.6476
83 Grand Princess US 2020-03-10T02:33:04 21 0 0 37.6489 -122.6655
98 Oregon US 2020-03-10T19:53:13 15 0 0 44.572 -122.0709
31 Washington US 2020-03-10T22:13:11 267 23 1 47.4009 -121.4905
41 California US 2020-03-10T19:13:28 144 2 2 36.1162 -119.6816
144 Nevada US 2020-03-10T02:33:04 4 0 0 38.3135 -117.0554
117 Alberta Canada 2020-03-09T17:53:24 7 0 0 53.9333 -116.5765
197 Idaho US 2020-03-10T02:33:04 0 0 0 44.2405 -114.4788
166 Utah US 2020-03-10T16:53:13 2 0 0 40.15 -111.8624
128 Arizona US 2020-03-10T02:53:04 6 0 1 33.7298 -111.4312
201 Montana US 2020-03-10T02:33:04 0 0 0 46.9219 -110.4544
206 Wyoming US 2020-03-10T02:33:04 0 0 0 42.756 -107.3025
202 New Mexico US 2020-03-10T02:33:04 0 0 0 34.8405 -106.2485
95 Colorado US 2020-03-10T18:33:03 15 0 0 39.0598 -105.3111
118   Mexico 2020-03-10T05:13:07 7 0 4 23.0 -102.0
203 North Dakota US 2020-03-10T02:33:04 0 0 0 47.5289 -99.784
204 South Dakota US 2020-03-10T02:33:04 0 0 0 44.2998 -99.4388
152 Nebraska US 2020-03-10T03:13:17 3 0 0 41.1254 -98.2681
101 Texas US 2020-03-10T04:13:13 13 0 0 31.0545 -97.5635
165 Oklahoma US 2020-03-10T17:13:25 2 0 0 35.5653 -96.9289
188 Kansas US 2020-03-10T03:13:17 1 0 0 38.5266 -96.7265
151 Minnesota US 2020-03-10T19:53:13 3 0 0 45.6945 -93.9002
114 Iowa US 2020-03-10T02:33:04 8 0 0 42.0115 -93.2105
195 Arkansas US 2020-03-10T02:33:04 0 0 0 34.9697 -92.3731
190 Missouri US 2020-03-10T03:13:17 1 0 0 38.4561 -92.2884
189 Louisiana US 2020-03-10T03:13:17 1 0 0 31.1695 -91.8678
200 Mississippi US 2020-03-10T02:33:04 0 0 0 32.7416 -89.6787
155 Wisconsin US 2020-03-10T17:13:25 3 0 1 44.2685 -89.6165
103 Illinois US 2020-03-10T18:33:03 12 0 2 40.3495 -88.9861
124 Tennessee US 2020-03-10T19:53:13 7 0 0 35.7478 -86.6923
129 Indiana US 2020-03-10T17:13:25 6 0 0 39.8494 -86.2583
71 Ontario Canada 2020-03-10T17:13:32 36 0 4 51.2538 -85.3232
130 Kentucky US 2020-03-10T02:33:04 6 0 0 37.6681 -84.6701
199 Michigan US 2020-03-10T02:33:04 0 0 0 43.3266 -84.5361
111   Costa Rica 2020-03-09T09:03:03 9 0 0 9.7489 -83.7534
91 Georgia US 2020-03-10T03:53:03 17 0 0 33.0406 -83.6431
153 Ohio US 2020-03-10T03:13:17 3 0 0 40.3888 -82.7649
96 Florida US 2020-03-10T13:13:14 15 2 0 27.7663 -81.6868
205 West Virginia US 2020-03-10T02:33:04 0 0 0 38.4912 -80.9545
123 South Carolina US 2020-03-10T02:33:04 7 0 0 33.8569 -80.945
183   Panama 2020-03-10T06:13:43 1 0 0 8.538 -80.7821
122 North Carolina US 2020-03-10T02:33:04 7 0 0 35.6301 -79.8064
93   Ecuador 2020-03-09T09:03:03 15 0 0 -1.8312 -78.1834
125 Virginia US 2020-03-10T03:53:03 7 0 0 37.7693 -78.17
104 Pennsylvania US 2020-03-10T18:13:16 12 0 0 40.5908 -77.2098
140 District of Columbia US 2020-03-10T03:53:03 5 0 0 38.8974 -77.0268
115 Maryland US 2020-03-10T18:13:16 8 0 0 39.0639 -76.8021
196 Delaware US 2020-03-10T02:33:04 0 0 0 39.3185 -75.5071
106   Peru 2020-03-10T16:33:13 11 0 0 -9.19 -75.0152
37 New York US 2020-03-10T17:13:27 173 0 0 42.1657 -74.9481
97 New Jersey US 2020-03-10T18:13:16 15 1 0 40.2989 -74.521
147   Colombia 2020-03-10T05:33:02 3 0 0 4.5709 -74.2973
142 Quebec Canada 2020-03-10T00:53:03 4 0 0 52.9399 -73.5491
163 Connecticut US 2020-03-10T03:13:17 2 0 0 41.5978 -72.7554
191 Vermont US 2020-03-10T03:13:17 1 0 0 44.0459 -72.7107
145 New Hampshire US 2020-03-10T02:33:04 4 0 0 43.4525 -71.5639
100   Chile 2020-03-10T05:13:07 13 0 0 -35.6751 -71.543
50 Massachusetts US 2020-03-10T22:13:11 92 0 1 42.2302 -71.5301
154 Rhode Island US 2020-03-10T03:13:17 3 0 0 41.6809 -71.5118
133   Dominican Republic 2020-03-08T17:23:08 5 0 0 18.7357 -70.1627
198 Maine US 2020-03-10T02:33:04 0 0 0 44.6939 -69.3819
90   Argentina 2020-03-10T05:13:07 17 1 0 -38.4161 -63.6167
162   Saint Martin 2020-03-10T05:33:02 2 0 0 18.0708 -63.0501
185   Saint Barthelemy 2020-03-09T10:43:06 1 0 0 17.9 -62.8333
160   Martinique 2020-03-07T03:23:05 2 0 0 14.6415 -61.0242
184   Paraguay 2020-03-08T09:13:16 1 0 0 -23.4425 -58.4438
134   French Guiana 2020-03-07T03:23:05 5 0 0 3.9339 -53.1258
75   Brazil 2020-03-10T16:53:13 31 0 0 -14.235 -51.9253
57   Iceland 2020-03-10T12:53:02 69 0 1 64.9631 -19.0208
143   Senegal 2020-03-08T20:23:08 4 0 1 14.4974 -14.4524
69   Portugal 2020-03-10T12:53:02 41 0 0 39.3999 -8.2245
72   Ireland 2020-03-10T19:13:21 34 0 0 53.1424 -7.6921
149   Morocco 2020-03-10T14:13:14 3 1 0 31.7917 -7.0926
159   Faroe Islands 2020-03-08T05:13:07 2 0 0 61.8926 -6.9118
174   Gibraltar 2020-03-10T08:33:03 1 0 1 36.1408 -5.3536
6   Spain 2020-03-10T23:53:02 1695 35 32 40.0 -4.0
25   UK 2020-03-10T23:53:02 382 6 18 55.0 -3.0
173   Channel Islands 2020-03-10T05:33:02 1 0 0 49.3723 -2.3644
172   Burkina Faso 2020-03-10T05:33:02 1 0 0 12.2383 -1.5616
187   Togo 2020-03-07T02:13:09 1 0 0 8.6195 0.8248
167   Andorra 2020-03-02T20:23:16 1 0 0 42.5063 1.5218
84   Algeria 2020-03-09T10:13:06 20 0 0 28.0339 1.6596
5   France 2020-03-10T18:53:02 1773 33 12 47.0 2.0
30   Belgium 2020-03-10T11:53:03 267 0 1 50.8333 4.0
24   Netherlands 2020-03-10T13:53:06 382 4 0 52.1326 5.2913
135   Luxembourg 2020-03-10T05:13:07 5 0 0 49.8144 6.1317
180   Monaco 2020-02-29T00:33:01 1 0 0 43.7333 7.4167
20   Switzerland 2020-03-10T23:53:02 491 3 3 46.8182 8.2275
23   Norway 2020-03-10T23:53:02 400 0 1 60.472 8.4689
161   Nigeria 2020-03-09T09:43:03 2 0 0 9.082 8.6753
7   Germany 2020-03-10T18:53:02 1457 2 18 51.0 9.0
32   Denmark 2020-03-10T17:33:34 262 0 1 56.2639 9.5018
139   Tunisia 2020-03-10T05:13:07 5 0 0 33.8869 9.5375
177   Liechtenstein 2020-03-04T01:33:07 1 0 0 47.14 9.55
158   Cameroon 2020-03-08T05:23:03 2 0 0 3.848 11.5021
2   Italy 2020-03-10T17:53:02 10149 631 724 43.0 12.0
175   Holy See 2020-03-10T19:13:21 1 0 0 41.9029 12.4534
64   San Marino 2020-03-10T05:13:07 51 2 0 43.9424 12.4578

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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