03-15-2020

Table actions
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

258 rows sorted by Last Update

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Deaths, Last Update (date)

Link rowid Province/State Country/Region Last Update ▼ Confirmed Deaths Recovered Latitude Longitude
103 103 Diamond Princess US 2020-03-10T02:33:04 46 0 0 35.4437 139.638
135 135 Grand Princess US 2020-03-10T02:33:04 21 0 0 37.6489 -122.6655
257 257 West Virginia US 2020-03-10T02:33:04 0 0 0 38.4912 -80.9545
17 17 Anhui China 2020-03-11T02:18:14 990 6 984 31.8257 117.2264
37 37 Fujian China 2020-03-11T02:18:14 296 1 295 26.0789 117.9874
81 81 Xinjiang China 2020-03-11T02:18:14 76 3 73 41.1129 85.2401
142 142 Qinghai China 2020-03-11T02:18:14 18 0 18 35.7452 95.9956
226 226 Tibet China 2020-03-11T02:18:14 1 0 1 31.6927 88.0924
82 82 Inner Mongolia China 2020-03-11T03:53:03 75 1 71 44.0935 113.9448
163 163 Macau China 2020-03-11T18:52:03 10 0 10 22.1667 113.55
258 258   occupied Palestinian territory 2020-03-11T20:53:02 0 0 0 31.9522 35.2332
39 39 Shaanxi China 2020-03-12T01:33:02 245 2 232 35.1917 108.8701
18 18 Jiangxi China 2020-03-12T02:13:04 935 1 934 27.614 115.7221
49 49 Hainan China 2020-03-12T03:53:02 168 6 160 19.1959 109.7453
252 252 North Dakota US 2020-03-12T09:33:03 1 0 0 47.5289 -99.784
36 36 Hebei China 2020-03-13T11:09:03 318 6 310 38.0428 114.5149
38 38 Guangxi China 2020-03-13T11:09:03 252 2 243 23.8298 108.7881
60 60 Shanxi China 2020-03-13T11:09:03 133 0 133 37.5777 112.2922
77 77 Jilin China 2020-03-13T11:09:03 93 1 91 43.6661 126.1923
151 151   Azerbaijan 2020-03-13T12:13:36 23 1 6 40.1431 47.5769
224 224   Cayman Islands 2020-03-13T12:33:03 1 0 0 19.3133 -81.2546
236 236   Guadeloupe 2020-03-13T12:33:03 3 0 0 16.265 -61.551
25 25 Diamond Princess Cruise Ship 2020-03-13T14:13:25 696 7 325 35.4498 139.6649
251 251 Alaska US 2020-03-13T14:53:03 1 0 0 61.3707 -152.4044
126 126   Belarus 2020-03-13T22:21:59 27 0 3 53.7098 27.9534
167 167   Jamaica 2020-03-13T22:22:02 10 0 0 18.1096 -77.2975
201 201   Ukraine 2020-03-13T22:22:02 3 1 0 48.3794 31.1656
204 204   Burkina Faso 2020-03-13T22:22:02 3 0 0 12.2383 -1.5616
205 205   Cameroon 2020-03-13T22:22:02 2 0 0 3.848 11.5021
208 208   Congo (Kinshasa) 2020-03-13T22:22:02 2 0 0 -4.0383 21.7587
214 214   Nigeria 2020-03-13T22:22:02 2 0 0 9.082 8.6753
217 217   Andorra 2020-03-13T22:22:02 1 0 1 42.5063 1.5218
221 221   Bhutan 2020-03-13T22:22:02 1 0 0 27.5142 90.4336
228 228   Cote d'Ivoire 2020-03-13T22:22:02 1 0 0 7.54 -5.5471
240 240   Holy See 2020-03-13T22:22:02 1 0 0 41.9029 12.4534
243 243   Mongolia 2020-03-13T22:22:02 1 0 0 46.8625 103.8467
250 250   Togo 2020-03-13T22:22:02 1 0 0 8.6195 0.8248
238 238   Guernsey 2020-03-13T22:22:03 1 0 0 49.45 -2.58
241 241   Kenya 2020-03-13T22:22:03 3 0 0 -0.0236 37.9062
244 244   Nepal 2020-03-13T22:22:03 1 0 1 28.3949 84.124
152 152   North Macedonia 2020-03-13T23:33:05 14 0 1 41.6086 21.7453
164 164   Senegal 2020-03-13T23:33:05 24 0 1 14.4974 -14.4524
179 179   Paraguay 2020-03-13T23:33:06 6 0 0 -23.4425 -58.4438
232 232   Ethiopia 2020-03-13T23:33:06 1 0 0 9.145 40.4897
191 191   Cuba 2020-03-13T23:53:02 4 0 0 21.5218 -77.7812
203 203   Aruba 2020-03-13T23:53:03 2 0 0 12.5211 -69.9683
190 190 Manitoba Canada 2020-03-14T00:13:05 4 0 0 53.7609 -98.8139
207 207 Saskatchewan Canada 2020-03-14T00:13:05 2 0 0 52.9399 -106.4509
52 52 Guizhou China 2020-03-14T00:53:03 146 2 143 26.8154 106.8748
248 248   Sudan 2020-03-14T01:13:32 1 1 0 12.8628 30.2176
237 237   Guatemala 2020-03-14T01:33:03 1 0 0 15.7835 -90.2308
219 219 Australian Capital Territory Australia 2020-03-14T01:53:03 1 0 0 -35.4735 149.0124
220 220 Northern Territory Australia 2020-03-14T01:53:03 1 0 0 -12.4634 130.8456
256 256 From Diamond Princess Australia 2020-03-14T02:33:04 0 0 0 35.4437 139.638
23 23 Shandong China 2020-03-14T04:33:02 760 7 741 36.3427 118.1498
16 16 Hunan China 2020-03-14T08:33:03 1018 4 1014 27.6104 111.7088
10 10 Henan China 2020-03-14T09:53:08 1273 22 1250 33.882 113.614
83 83 Ningxia China 2020-03-14T09:53:08 75 0 73 37.2692 106.1655
46 46   Bahrain 2020-03-14T11:53:29 214 0 60 26.0667 50.5577
120 120   Georgia 2020-03-14T12:33:03 33 0 0 42.3154 43.3569
162 162   Bolivia 2020-03-14T12:53:07 10 0 0 -16.2902 -63.5887
172 172   Cambodia 2020-03-14T12:53:07 7 0 1 12.5657 104.991
146 146 Western Australia Australia 2020-03-14T13:33:04 17 1 0 -31.9505 115.8605
235 235   Gabon 2020-03-14T13:33:04 1 0 0 -0.8037 11.6094
13 13 United Kingdom United Kingdom 2020-03-14T14:53:04 1140 21 18 55.3781 -3.436
165 165   Martinique 2020-03-14T14:53:04 9 0 0 14.6415 -61.0242
216 216   Trinidad and Tobago 2020-03-14T16:15:01 2 0 0 10.6918 -61.2225
229 229   Curacao 2020-03-14T16:15:18 1 0 0 12.1696 -68.99
246 246   Saint Lucia 2020-03-14T16:15:18 2 0 0 13.9094 -60.9789
253 253 Virgin Islands, U.S. US 2020-03-14T16:15:18 1 0 0 18.3358 -64.8963
195 195   Uruguay 2020-03-14T16:33:03 4 0 0 -32.5228 -55.7658
209 209 St Martin France 2020-03-14T16:33:03 2 0 0 18.0708 -63.0501
210 210   Jersey 2020-03-14T16:33:03 2 0 0 49.19 -2.11
213 213   Namibia 2020-03-14T16:33:03 2 0 0 -22.9576 18.4904
234 234 Saint Barthelemy France 2020-03-14T16:33:03 1 0 0 17.9 -62.8333
247 247   Saint Vincent and the Grenadines 2020-03-14T16:33:03 1 0 0 12.9843 -61.2872
249 249   Suriname 2020-03-14T16:33:03 1 0 0 3.9193 -56.0278
254 254 Gibraltar United Kingdom 2020-03-14T16:33:03 1 0 1 36.1408 -5.3536
166 166 South Dakota US 2020-03-14T16:53:03 9 1 0 44.2998 -99.4388
176 176 New Hampshire US 2020-03-14T16:53:03 13 0 0 43.4525 -71.5639
184 184 Mississippi US 2020-03-14T16:53:03 10 0 0 32.7416 -89.6787
194 194 Oklahoma US 2020-03-14T16:53:03 7 0 0 35.5653 -96.9289
181 181 Delaware US 2020-03-14T18:13:20 7 0 0 39.3185 -75.5071
158 158 Arizona US 2020-03-14T18:13:23 13 0 1 33.7298 -111.4312
199 199 Puerto Rico US 2020-03-14T18:33:03 5 0 0 18.2208 -66.5901
101 101 Pennsylvania US 2020-03-14T18:53:03 66 0 0 40.5908 -77.2098
140 140 Rhode Island US 2020-03-14T18:53:03 20 0 0 41.6809 -71.5118
2 2   Italy 2020-03-14T20:13:16 24747 1809 2335 41.8719 12.5674
62 62   Ireland 2020-03-14T20:13:16 129 2 0 53.1424 -7.6921
74 74   Saudi Arabia 2020-03-14T20:33:03 103 0 1 23.8859 45.0792
90 90   Chile 2020-03-14T20:33:03 74 0 0 -35.6751 -71.543
143 143   Tunisia 2020-03-14T20:53:02 18 0 0 33.8869 9.5375
156 156   Moldova 2020-03-14T20:53:02 23 0 0 47.4116 28.3699
160 160   Dominican Republic 2020-03-14T20:53:02 11 0 0 18.7357 -70.1627
193 193   Liechtenstein 2020-03-14T20:53:02 4 0 0 47.166 9.5554
233 233 Mayotte France 2020-03-14T20:53:03 1 0 0 -12.8275 45.1662
55 55 Massachusetts US 2020-03-14T22:13:19 164 0 1 42.2302 -71.5301
75 75 Colorado US 2020-03-14T22:13:32 131 1 0 39.0598 -105.3111
22 22   Japan 2020-03-14T22:33:03 839 22 118 36.2048 138.2529
35 35   Qatar 2020-03-14T22:33:03 401 0 4 25.3548 51.1839

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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