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

View and edit SQL

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude ▼ Longitude
37 Shaanxi China 2020-03-12T01:33:02 245 2 232 35.1917 108.8701
16 Diamond Princess Cruise Ship 2020-03-11T22:13:12 696 7 325 35.4437 139.638
77 Diamond Princess US 2020-03-10T02:33:04 46 0 0 35.4437 139.638
211 From Diamond Princess Australia 2020-02-29T02:03:10 0 0 0 35.4437 139.638
182 Oklahoma US 2020-03-10T17:13:25 2 0 0 35.5653 -96.9289
117 North Carolina US 2020-03-12T21:39:10 15 0 0 35.6301 -79.8064
107 Qinghai China 2020-03-11T02:18:14 18 0 18 35.7452 95.9956
109 Tennessee US 2020-03-12T21:39:10 18 0 0 35.7478 -86.6923
148   Malta 2020-03-11T11:33:08 6 0 0 35.9375 14.3754
4   Korea, South 2020-03-12T05:13:02 7869 66 333 36.0 128.0
18   Japan 2020-03-12T05:13:02 639 16 118 36.0 138.0
212 Gansu Mainland China 2020-03-11T02:18:28 0 0 0 36.0611 103.8343
38 California US 2020-03-12T23:44:33 221 4 6 36.1162 -119.6816
210 Gibraltar United Kingdom 2020-03-11T20:53:02 1 0 1 36.1408 -5.3536
14 Shandong China 2020-03-12T07:53:02 760 6 734 36.3427 118.1498
61 Ningxia China 2020-03-11T09:33:12 75 0 72 37.2692 106.1655
46 Shanxi China 2020-03-12T09:13:24 133 0 132 37.5777 112.2922
98 Grand Princess US 2020-03-10T02:33:04 21 0 0 37.6489 -122.6655
132 Kentucky US 2020-03-12T23:44:33 10 0 0 37.6681 -84.6701
112 Virginia US 2020-03-12T21:39:10 17 0 0 37.7693 -78.17
49 Gansu China 2020-03-11T14:33:03 127 2 88 37.8099 101.0583
213 Hebei Mainland China 2020-03-11T02:18:29 0 0 0 38.0428 114.5149
118 Nevada US 2020-03-12T23:44:33 14 0 0 38.3135 -117.0554
205 Missouri US 2020-03-10T03:13:17 1 0 0 38.4561 -92.2884
217 West Virginia US 2020-03-10T02:33:04 0 0 0 38.4912 -80.9545
203 Kansas US 2020-03-10T03:13:17 1 0 0 38.5266 -96.7265
131 District of Columbia US 2020-03-11T22:53:03 10 0 0 38.8974 -77.0268
201   Turkey 2020-03-11T03:33:05 1 0 0 38.9637 35.2433
79 Colorado US 2020-03-12T21:39:10 45 0 0 39.0598 -105.3111
123 Maryland US 2020-03-12T01:53:03 12 0 0 39.0639 -76.8021
53   Greece 2020-03-11T23:53:02 99 1 0 39.0742 21.8243
45 Tianjin China 2020-03-12T01:53:03 136 3 132 39.3054 117.323
202 Delaware US 2020-03-11T23:13:06 1 0 0 39.3185 -75.5071
70   Portugal 2020-03-11T13:33:11 59 0 0 39.3999 -8.2245
31 Hebei China 2020-03-12T05:33:02 318 6 308 39.549 116.1306
120 Indiana US 2020-03-12T23:44:33 13 0 0 39.8494 -86.2583
6   Spain 2020-03-12T01:17:58 2277 55 183 40.0 -4.0
161   Armenia 2020-03-12T21:39:09 4 0 0 40.0691 45.0382
125   Azerbaijan 2020-03-11T08:13:09 11 0 3 40.1431 47.5769
160 Utah US 2020-03-12T23:44:33 5 0 0 40.15 -111.8624
28 Beijing China 2020-03-12T01:13:05 435 8 334 40.1824 116.4142
87 New Jersey US 2020-03-12T21:39:10 29 1 0 40.2989 -74.521
85 Illinois US 2020-03-12T23:44:33 32 0 2 40.3495 -88.9861
158 Ohio US 2020-03-12T09:33:03 5 0 0 40.3888 -82.7649
96 Pennsylvania US 2020-03-12T21:39:10 22 0 0 40.5908 -77.2098
59 Xinjiang China 2020-03-11T02:18:14 76 3 73 41.1129 85.2401
133 Nebraska US 2020-03-12T01:53:03 10 0 0 41.1254 -98.2681
93   Albania 2020-03-12T21:39:09 23 1 0 41.1533 20.1683
50 Liaoning China 2020-03-12T09:53:06 125 1 112 41.2956 122.6085
156 Connecticut US 2020-03-12T23:44:33 5 0 0 41.5978 -72.7554
145   North Macedonia 2020-03-10T10:53:03 7 0 0 41.6086 21.7453
159 Rhode Island US 2020-03-11T03:13:08 5 0 0 41.6809 -71.5118
194   Holy See 2020-03-10T19:13:21 1 0 0 41.9029 12.4534
115 Iowa US 2020-03-12T23:44:33 16 0 0 42.0115 -93.2105
30 New York US 2020-03-12T21:39:10 328 0 0 42.1657 -74.9481
51 Massachusetts US 2020-03-12T21:39:09 108 0 1 42.2302 -71.5301
91   Georgia 2020-03-11T22:13:12 24 0 0 42.3154 43.3569
185   Andorra 2020-03-12T23:44:32 1 0 1 42.5063 1.5218
144   Bulgaria 2020-03-11T22:13:12 7 1 0 42.7339 25.4858
208 Wyoming US 2020-03-12T03:13:09 1 0 0 42.756 -107.3025
2   Italy 2020-03-11T21:33:02 12462 827 1045 43.0 12.0
181 Michigan US 2020-03-11T03:33:05 2 0 0 43.3266 -84.5361
151 New Hampshire US 2020-03-12T21:39:10 6 0 0 43.4525 -71.5639
55 Jilin China 2020-03-12T23:44:32 93 1 91 43.6661 126.1923
177   Monaco 2020-03-12T12:53:03 2 0 0 43.7333 7.4167
126   Bosnia and Herzegovina 2020-03-12T09:13:26 11 0 0 43.9159 17.6791
65   San Marino 2020-03-12T08:53:02 69 3 0 43.9424 12.4578
105   Serbia 2020-03-12T09:13:24 19 0 0 44.0165 21.0059
183 Vermont US 2020-03-12T01:53:03 2 0 0 44.0459 -72.7107
60 Inner Mongolia China 2020-03-11T03:53:03 75 1 71 44.0935 113.9448
215 Idaho US 2020-03-10T02:33:04 0 0 0 44.2405 -114.4788
142 Wisconsin US 2020-03-12T21:39:10 8 0 1 44.2685 -89.6165
141 South Dakota US 2020-03-11T22:53:03 8 1 0 44.2998 -99.4388
92 Oregon US 2020-03-12T23:44:33 24 0 0 44.572 -122.0709
216 Maine US 2020-03-10T02:33:04 0 0 0 44.6939 -69.3819
103   Croatia 2020-03-11T22:13:12 19 0 0 45.1667 15.5
139 Minnesota US 2020-03-12T21:39:10 9 0 0 45.6945 -93.9002
74   Romania 2020-03-12T09:13:24 49 0 6 46.0 25.0
56   Slovenia 2020-03-12T13:33:02 89 0 0 46.1512 14.9955
5 France France 2020-03-11T22:53:03 2281 48 12 46.2276 2.2137
188 New Brunswick Canada 2020-03-11T23:13:06 1 0 0 46.5653 -66.4619
17   Switzerland 2020-03-11T20:53:02 652 4 4 46.8182 8.2275
197   Mongolia 2020-03-10T06:13:43 1 0 0 46.8625 103.8467
206 Montana US 2020-03-11T23:13:06 1 0 0 46.9219 -110.4544
196   Liechtenstein 2020-03-04T01:33:07 1 0 0 47.14 9.55
119   Hungary 2020-03-11T22:13:12 13 0 0 47.1625 19.5033
27 Washington US 2020-03-12T23:44:33 442 31 1 47.4009 -121.4905
169   Moldova 2020-03-11T18:52:03 3 0 0 47.4116 28.3699
33   Austria 2020-03-12T11:13:29 302 1 4 47.5162 14.5501
207 North Dakota US 2020-03-12T09:33:03 1 0 0 47.5289 -99.784
25 Heilongjiang China 2020-03-12T13:13:31 482 13 441 47.862 127.7615
209   Ukraine 2020-03-03T15:33:02 1 0 0 48.3794 31.1656
114   Slovakia 2020-03-12T13:33:02 16 0 0 48.669 19.699
184 Channel Islands United Kingdom 2020-03-11T20:53:02 2 0 0 49.3723 -2.3644
104   Luxembourg 2020-03-12T10:53:03 19 0 0 49.8144 6.1317
54   Czechia 2020-03-12T01:33:03 94 0 0 49.8175 15.473
32   Belgium 2020-03-11T18:52:03 314 3 1 50.8333 4.0
7   Germany 2020-03-12T09:53:06 2078 3 25 51.0 9.0
81 Ontario Canada 2020-03-12T01:53:03 42 0 4 51.2538 -85.3232
73   Poland 2020-03-12T13:33:02 49 1 0 51.9194 19.1451

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