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

66 rows where "Last Update" is on date 2020-03-14

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Deaths, Recovered

Last Update (date) ✖

  • 2020-03-14 · 66 ✖
Link rowid ▼ Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
2 2   Italy 2020-03-14T20:13:16 24747 1809 2335 41.8719 12.5674
10 10 Henan China 2020-03-14T09:53:08 1273 22 1250 33.882 113.614
13 13 United Kingdom United Kingdom 2020-03-14T14:53:04 1140 21 18 55.3781 -3.436
16 16 Hunan China 2020-03-14T08:33:03 1018 4 1014 27.6104 111.7088
22 22   Japan 2020-03-14T22:33:03 839 22 118 36.2048 138.2529
23 23 Shandong China 2020-03-14T04:33:02 760 7 741 36.3427 118.1498
34 34 Shanghai China 2020-03-14T23:53:02 353 3 324 31.202 121.4491
35 35   Qatar 2020-03-14T22:33:03 401 0 4 25.3548 51.1839
46 46   Bahrain 2020-03-14T11:53:29 214 0 60 26.0667 50.5577
48 48 Yunnan China 2020-03-14T23:33:02 174 2 172 24.974 101.487
52 52 Guizhou China 2020-03-14T00:53:03 146 2 143 26.8154 106.8748
55 55 Massachusetts US 2020-03-14T22:13:19 164 0 1 42.2302 -71.5301
62 62   Ireland 2020-03-14T20:13:16 129 2 0 53.1424 -7.6921
71 71   Iraq 2020-03-14T22:33:03 116 10 26 33.2232 43.6793
74 74   Saudi Arabia 2020-03-14T20:33:03 103 0 1 23.8859 45.0792
75 75 Colorado US 2020-03-14T22:13:32 131 1 0 39.0598 -105.3111
83 83 Ningxia China 2020-03-14T09:53:08 75 0 73 37.2692 106.1655
90 90   Chile 2020-03-14T20:33:03 74 0 0 -35.6751 -71.543
101 101 Pennsylvania US 2020-03-14T18:53:03 66 0 0 40.5908 -77.2098
102 102   Serbia 2020-03-14T22:53:02 48 0 0 44.0165 21.0059
118 118 Tennessee US 2020-03-14T22:33:04 39 0 0 35.7478 -86.6923
120 120   Georgia 2020-03-14T12:33:03 33 0 0 42.3154 43.3569
123 123   Ecuador 2020-03-14T22:53:02 28 2 0 -1.8312 -78.1834
128 128   Cyprus 2020-03-14T22:53:02 26 0 0 35.1264 33.4299
136 136 Nevada US 2020-03-14T22:33:03 24 0 0 38.3135 -117.0554
140 140 Rhode Island US 2020-03-14T18:53:03 20 0 0 41.6809 -71.5118
141 141 South Carolina US 2020-03-14T22:33:03 28 0 0 33.8569 -80.945
143 143   Tunisia 2020-03-14T20:53:02 18 0 0 33.8869 9.5375
146 146 Western Australia Australia 2020-03-14T13:33:04 17 1 0 -31.9505 115.8605
156 156   Moldova 2020-03-14T20:53:02 23 0 0 47.4116 28.3699
158 158 Arizona US 2020-03-14T18:13:23 13 0 1 33.7298 -111.4312
160 160   Dominican Republic 2020-03-14T20:53:02 11 0 0 18.7357 -70.1627
162 162   Bolivia 2020-03-14T12:53:07 10 0 0 -16.2902 -63.5887
165 165   Martinique 2020-03-14T14:53:04 9 0 0 14.6415 -61.0242
166 166 South Dakota US 2020-03-14T16:53:03 9 1 0 44.2998 -99.4388
170 170 Kansas US 2020-03-14T22:33:03 8 1 0 38.5266 -96.7265
172 172   Cambodia 2020-03-14T12:53:07 7 0 1 12.5657 104.991
176 176 New Hampshire US 2020-03-14T16:53:03 13 0 0 43.4525 -71.5639
181 181 Delaware US 2020-03-14T18:13:20 7 0 0 39.3185 -75.5071
184 184 Mississippi US 2020-03-14T16:53:03 10 0 0 32.7416 -89.6787
189 189 Vermont US 2020-03-14T22:33:04 8 0 0 44.0459 -72.7107
190 190 Manitoba Canada 2020-03-14T00:13:05 4 0 0 53.7609 -98.8139
193 193   Liechtenstein 2020-03-14T20:53:02 4 0 0 47.166 9.5554
194 194 Oklahoma US 2020-03-14T16:53:03 7 0 0 35.5653 -96.9289
195 195   Uruguay 2020-03-14T16:33:03 4 0 0 -32.5228 -55.7658
199 199 Puerto Rico US 2020-03-14T18:33:03 5 0 0 18.2208 -66.5901
207 207 Saskatchewan Canada 2020-03-14T00:13:05 2 0 0 52.9399 -106.4509
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
212 212   Monaco 2020-03-14T23:13:05 2 0 0 43.7384 7.4246
213 213   Namibia 2020-03-14T16:33:03 2 0 0 -22.9576 18.4904
216 216   Trinidad and Tobago 2020-03-14T16:15:01 2 0 0 10.6918 -61.2225
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
229 229   Curacao 2020-03-14T16:15:18 1 0 0 12.1696 -68.99
233 233 Mayotte France 2020-03-14T20:53:03 1 0 0 -12.8275 45.1662
234 234 Saint Barthelemy France 2020-03-14T16:33:03 1 0 0 17.9 -62.8333
235 235   Gabon 2020-03-14T13:33:04 1 0 0 -0.8037 11.6094
237 237   Guatemala 2020-03-14T01:33:03 1 0 0 15.7835 -90.2308
246 246   Saint Lucia 2020-03-14T16:15:18 2 0 0 13.9094 -60.9789
247 247   Saint Vincent and the Grenadines 2020-03-14T16:33:03 1 0 0 12.9843 -61.2872
248 248   Sudan 2020-03-14T01:13:32 1 1 0 12.8628 30.2176
249 249   Suriname 2020-03-14T16:33:03 1 0 0 3.9193 -56.0278
253 253 Virgin Islands, U.S. US 2020-03-14T16:15:18 1 0 0 18.3358 -64.8963
254 254 Gibraltar United Kingdom 2020-03-14T16:33:03 1 0 1 36.1408 -5.3536
256 256 From Diamond Princess Australia 2020-03-14T02:33:04 0 0 0 35.4437 139.638

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