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

218 rows sorted by Latitude descending

View and edit SQL

Suggested facets: Deaths, Last Update (date)

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude ▲ Longitude
52   Iceland 2020-03-12T21:39:09 103 0 1 64.9631 -19.0208
69   Finland 2020-03-11T13:33:10 59 0 1 64.0 26.0
21   Sweden 2020-03-12T21:39:09 599 1 1 63.0 16.0
173 Faroe Islands Denmark 2020-03-11T20:53:02 2 0 0 61.8926 -6.9118
214 Alaska US 2020-03-10T02:33:04 0 0 0 61.3707 -152.4044
15   Norway 2020-03-12T13:13:31 702 0 1 60.472 8.4689
88   Russia 2020-03-12T08:53:02 28 0 3 60.0 90.0
113   Estonia 2020-03-11T22:13:12 16 0 0 58.5953 25.0136
130   Latvia 2020-03-11T13:53:24 10 0 1 56.8796 24.6032
20 Denmark Denmark 2020-03-12T09:53:06 615 0 1 56.2639 9.5018
26 UK United Kingdom 2020-03-11T21:33:03 456 8 18 55.3781 -3.436
167   Lithuania 2020-03-11T02:18:26 3 0 0 55.1694 23.8813
102 Alberta Canada 2020-03-11T23:13:07 19 0 0 53.9333 -116.5765
76 British Columbia Canada 2020-03-12T01:53:03 46 1 4 53.7267 -127.6476
121   Belarus 2020-03-12T08:53:02 12 0 3 53.7098 27.9534
80   Ireland 2020-03-11T21:33:03 43 1 0 53.1424 -7.6921
136 Quebec Canada 2020-03-12T01:53:03 9 0 0 52.9399 -73.5491
24   Netherlands 2020-03-11T14:13:11 503 5 0 52.1326 5.2913
73   Poland 2020-03-12T13:33:02 49 1 0 51.9194 19.1451
81 Ontario Canada 2020-03-12T01:53:03 42 0 4 51.2538 -85.3232
7   Germany 2020-03-12T09:53:06 2078 3 25 51.0 9.0
32   Belgium 2020-03-11T18:52:03 314 3 1 50.8333 4.0
54   Czechia 2020-03-12T01:33:03 94 0 0 49.8175 15.473
104   Luxembourg 2020-03-12T10:53:03 19 0 0 49.8144 6.1317
184 Channel Islands United Kingdom 2020-03-11T20:53:02 2 0 0 49.3723 -2.3644
114   Slovakia 2020-03-12T13:33:02 16 0 0 48.669 19.699
209   Ukraine 2020-03-03T15:33:02 1 0 0 48.3794 31.1656
25 Heilongjiang China 2020-03-12T13:13:31 482 13 441 47.862 127.7615
207 North Dakota US 2020-03-12T09:33:03 1 0 0 47.5289 -99.784
33   Austria 2020-03-12T11:13:29 302 1 4 47.5162 14.5501
169   Moldova 2020-03-11T18:52:03 3 0 0 47.4116 28.3699
27 Washington US 2020-03-12T23:44:33 442 31 1 47.4009 -121.4905
119   Hungary 2020-03-11T22:13:12 13 0 0 47.1625 19.5033
196   Liechtenstein 2020-03-04T01:33:07 1 0 0 47.14 9.55
206 Montana US 2020-03-11T23:13:06 1 0 0 46.9219 -110.4544
197   Mongolia 2020-03-10T06:13:43 1 0 0 46.8625 103.8467
17   Switzerland 2020-03-11T20:53:02 652 4 4 46.8182 8.2275
188 New Brunswick Canada 2020-03-11T23:13:06 1 0 0 46.5653 -66.4619
5 France France 2020-03-11T22:53:03 2281 48 12 46.2276 2.2137
56   Slovenia 2020-03-12T13:33:02 89 0 0 46.1512 14.9955
74   Romania 2020-03-12T09:13:24 49 0 6 46.0 25.0
139 Minnesota US 2020-03-12T21:39:10 9 0 0 45.6945 -93.9002
103   Croatia 2020-03-11T22:13:12 19 0 0 45.1667 15.5
216 Maine US 2020-03-10T02:33:04 0 0 0 44.6939 -69.3819
92 Oregon US 2020-03-12T23:44:33 24 0 0 44.572 -122.0709
141 South Dakota US 2020-03-11T22:53:03 8 1 0 44.2998 -99.4388
142 Wisconsin US 2020-03-12T21:39:10 8 0 1 44.2685 -89.6165
215 Idaho US 2020-03-10T02:33:04 0 0 0 44.2405 -114.4788
60 Inner Mongolia China 2020-03-11T03:53:03 75 1 71 44.0935 113.9448
183 Vermont US 2020-03-12T01:53:03 2 0 0 44.0459 -72.7107
105   Serbia 2020-03-12T09:13:24 19 0 0 44.0165 21.0059
65   San Marino 2020-03-12T08:53:02 69 3 0 43.9424 12.4578
126   Bosnia and Herzegovina 2020-03-12T09:13:26 11 0 0 43.9159 17.6791
177   Monaco 2020-03-12T12:53:03 2 0 0 43.7333 7.4167
55 Jilin China 2020-03-12T23:44:32 93 1 91 43.6661 126.1923
151 New Hampshire US 2020-03-12T21:39:10 6 0 0 43.4525 -71.5639
181 Michigan US 2020-03-11T03:33:05 2 0 0 43.3266 -84.5361
2   Italy 2020-03-11T21:33:02 12462 827 1045 43.0 12.0
208 Wyoming US 2020-03-12T03:13:09 1 0 0 42.756 -107.3025
144   Bulgaria 2020-03-11T22:13:12 7 1 0 42.7339 25.4858
185   Andorra 2020-03-12T23:44:32 1 0 1 42.5063 1.5218
91   Georgia 2020-03-11T22:13:12 24 0 0 42.3154 43.3569
51 Massachusetts US 2020-03-12T21:39:09 108 0 1 42.2302 -71.5301
30 New York US 2020-03-12T21:39:10 328 0 0 42.1657 -74.9481
115 Iowa US 2020-03-12T23:44:33 16 0 0 42.0115 -93.2105
194   Holy See 2020-03-10T19:13:21 1 0 0 41.9029 12.4534
159 Rhode Island US 2020-03-11T03:13:08 5 0 0 41.6809 -71.5118
145   North Macedonia 2020-03-10T10:53:03 7 0 0 41.6086 21.7453
156 Connecticut US 2020-03-12T23:44:33 5 0 0 41.5978 -72.7554
50 Liaoning China 2020-03-12T09:53:06 125 1 112 41.2956 122.6085
93   Albania 2020-03-12T21:39:09 23 1 0 41.1533 20.1683
133 Nebraska US 2020-03-12T01:53:03 10 0 0 41.1254 -98.2681
59 Xinjiang China 2020-03-11T02:18:14 76 3 73 41.1129 85.2401
96 Pennsylvania US 2020-03-12T21:39:10 22 0 0 40.5908 -77.2098
158 Ohio US 2020-03-12T09:33:03 5 0 0 40.3888 -82.7649
85 Illinois US 2020-03-12T23:44:33 32 0 2 40.3495 -88.9861
87 New Jersey US 2020-03-12T21:39:10 29 1 0 40.2989 -74.521
28 Beijing China 2020-03-12T01:13:05 435 8 334 40.1824 116.4142
160 Utah US 2020-03-12T23:44:33 5 0 0 40.15 -111.8624
125   Azerbaijan 2020-03-11T08:13:09 11 0 3 40.1431 47.5769
161   Armenia 2020-03-12T21:39:09 4 0 0 40.0691 45.0382
6   Spain 2020-03-12T01:17:58 2277 55 183 40.0 -4.0
120 Indiana US 2020-03-12T23:44:33 13 0 0 39.8494 -86.2583
31 Hebei China 2020-03-12T05:33:02 318 6 308 39.549 116.1306
70   Portugal 2020-03-11T13:33:11 59 0 0 39.3999 -8.2245
202 Delaware US 2020-03-11T23:13:06 1 0 0 39.3185 -75.5071
45 Tianjin China 2020-03-12T01:53:03 136 3 132 39.3054 117.323
53   Greece 2020-03-11T23:53:02 99 1 0 39.0742 21.8243
123 Maryland US 2020-03-12T01:53:03 12 0 0 39.0639 -76.8021
79 Colorado US 2020-03-12T21:39:10 45 0 0 39.0598 -105.3111
201   Turkey 2020-03-11T03:33:05 1 0 0 38.9637 35.2433
131 District of Columbia US 2020-03-11T22:53:03 10 0 0 38.8974 -77.0268
203 Kansas US 2020-03-10T03:13:17 1 0 0 38.5266 -96.7265
217 West Virginia US 2020-03-10T02:33:04 0 0 0 38.4912 -80.9545
205 Missouri US 2020-03-10T03:13:17 1 0 0 38.4561 -92.2884
118 Nevada US 2020-03-12T23:44:33 14 0 0 38.3135 -117.0554
213 Hebei Mainland China 2020-03-11T02:18:29 0 0 0 38.0428 114.5149
49 Gansu China 2020-03-11T14:33:03 127 2 88 37.8099 101.0583
112 Virginia US 2020-03-12T21:39:10 17 0 0 37.7693 -78.17
132 Kentucky US 2020-03-12T23:44:33 10 0 0 37.6681 -84.6701

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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