03-13-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

230 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last Update, Deaths, Last Update (date)

Link rowid ▲ Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
230 230   Taiwan* 2020-03-11T20:00:00 50 1 20 23.7 121.0
229 229   Guyana 2020-03-11T20:00:00 1 1 0 5.0 -58.75
228 228   Liechtenstein 2020-03-11T20:00:00 1 0 0 47.14 9.55
227 227   Monaco 2020-03-11T20:00:00 2 0 0 43.7333 7.4167
226 226   Afghanistan 2020-03-11T20:00:00 13 0 0 33.0 65.0
225 225   Jamaica 2020-03-11T20:00:00 8 0 0 18.1096 -77.2975
224 224   Mongolia 2020-03-11T20:00:00 1 0 0 46.8625 103.8467
223 223   Vietnam 2020-03-11T20:00:00 47 0 16 14.0583 108.2772
222 222 Wyoming US 2020-03-11T20:00:00 1 0 0 42.755966 -107.30249
221 221 Wisconsin US 2020-03-11T20:00:00 19 0 1 44.268543 -89.616508
220 220 West Virginia US 2020-03-11T20:00:00 0 0 0 38.491226 -80.954453
219 219 Washington US 2020-03-11T20:00:00 568 37 1 47.400902 -121.490494
218 218 Virginia US 2020-03-11T20:00:00 30 0 0 37.769337 -78.169968
217 217 Vermont US 2020-03-11T20:00:00 2 0 0 44.045876 -72.710686
216 216 Utah US 2020-03-11T20:00:00 9 0 0 40.150032 -111.862434
215 215 Texas US 2020-03-11T20:00:00 43 0 0 31.054487 -97.563461
214 214 Tennessee US 2020-03-11T20:00:00 26 0 0 35.747845 -86.692345
213 213 South Dakota US 2020-03-11T20:00:00 8 1 0 44.299782 -99.438828
212 212 South Carolina US 2020-03-11T20:00:00 13 0 0 33.856892 -80.945007
211 211 Rhode Island US 2020-03-11T20:00:00 14 0 0 41.680893 -71.51178
210 210 Pennsylvania US 2020-03-11T20:00:00 41 0 0 40.590752 -77.209755
209 209 Oregon US 2020-03-11T20:00:00 30 0 0 44.572021 -122.070938
208 208 Oklahoma US 2020-03-11T20:00:00 2 0 0 35.565342 -96.928917
207 207 Ohio US 2020-03-11T20:00:00 13 0 0 40.388783 -82.764915
206 206 North Dakota US 2020-03-11T20:00:00 1 0 0 47.528912 -99.784012
205 205 North Carolina US 2020-03-11T20:00:00 17 0 0 35.630066 -79.806419
204 204 New York US 2020-03-11T20:00:00 421 0 0 42.165726 -74.948051
203 203 New Mexico US 2020-03-11T20:00:00 10 0 0 34.840515 -106.248482
202 202 New Jersey US 2020-03-11T20:00:00 29 1 0 40.298904 -74.521011
201 201 New Hampshire US 2020-03-11T20:00:00 6 0 0 43.452492 -71.563896
200 200 Nevada US 2020-03-11T20:00:00 17 0 0 38.313515 -117.055374
199 199 Nebraska US 2020-03-11T20:00:00 13 0 0 41.12537 -98.268082
198 198 Montana US 2020-03-11T20:00:00 1 0 0 46.921925 -110.454353
197 197 Missouri US 2020-03-11T20:00:00 2 0 0 38.456085 -92.288368
196 196 Mississippi US 2020-03-11T20:00:00 1 0 0 32.741646 -89.678696
195 195 Minnesota US 2020-03-11T20:00:00 14 0 0 45.694454 -93.900192
194 194 Michigan US 2020-03-11T20:00:00 16 0 0 43.326618 -84.536095
193 193 Massachusetts US 2020-03-11T20:00:00 123 0 1 42.230171 -71.530106
192 192 Maryland US 2020-03-11T20:00:00 18 0 0 39.063946 -76.802101
191 191 Maine US 2020-03-11T20:00:00 1 0 0 44.693947 -69.381927
190 190 Louisiana US 2020-03-11T20:00:00 36 0 0 31.169546 -91.867805
189 189 Kentucky US 2020-03-11T20:00:00 14 0 0 37.66814 -84.670067
188 188 Kansas US 2020-03-11T20:00:00 5 1 0 38.5266 -96.726486
187 187 Iowa US 2020-03-11T20:00:00 17 0 0 42.011539 -93.210526
186 186 Indiana US 2020-03-11T20:00:00 13 0 0 39.849426 -86.258278
185 185 Illinois US 2020-03-11T20:00:00 46 0 2 40.349457 -88.986137
184 184 Idaho US 2020-03-11T20:00:00 1 0 0 44.240459 -114.478828
183 183 Hawaii US 2020-03-11T20:00:00 2 0 0 21.094318 -157.498337
182 182 Georgia US 2020-03-11T20:00:00 42 1 0 33.040619 -83.643074
181 181 Florida US 2020-03-11T20:00:00 50 2 0 27.766279 -81.686783
180 180 District of Columbia US 2020-03-11T20:00:00 10 0 0 38.897438 -77.026817
179 179 Delaware US 2020-03-11T20:00:00 4 0 0 39.318523 -75.507141
178 178 Connecticut US 2020-03-11T20:00:00 11 0 0 41.597782 -72.755371
177 177 Colorado US 2020-03-11T20:00:00 49 0 0 39.059811 -105.311104
176 176 California US 2020-03-11T20:00:00 282 4 6 36.116203 -119.681564
175 175 Arkansas US 2020-03-11T20:00:00 6 0 0 34.969704 -92.373123
174 174 Arizona US 2020-03-11T20:00:00 9 0 1 33.729759 -111.431221
173 173 Alaska US 2020-03-11T20:00:00 1 0 0 61.370716 -152.404419
172 172   Cyprus 2020-03-11T20:00:00 14 0 0 35.1264 33.4299
171 171   Tunisia 2020-03-11T20:00:00 16 0 0 33.8869 9.5375
170 170   Bulgaria 2020-03-11T20:00:00 23 1 0 42.7339 25.4858
169 169   Maldives 2020-03-11T20:00:00 9 0 0 3.2028 73.2207
168 168   Moldova 2020-03-11T20:00:00 6 0 0 47.4116 28.3699
167 167   Paraguay 2020-03-11T20:00:00 6 0 0 -23.4425 -58.4438
166 166   Malta 2020-03-11T20:00:00 12 0 1 35.9375 14.3754
165 165   French Guiana 2020-03-11T20:00:00 5 0 0 3.9339 -53.1258
164 164   Martinique 2020-03-11T20:00:00 3 0 0 14.6415 -61.0242
163 163   Brunei 2020-03-11T20:00:00 37 0 0 4.5353 114.7277
162 162 Grand Princess US 2020-03-11T20:00:00 21 0 0 37.64894 -122.665479
161 161   Colombia 2020-03-11T20:00:00 13 0 0 4.5709 -74.2973
160 160   Mexico 2020-03-11T20:00:00 12 0 4 23.6345 -102.5528
159 159   Romania 2020-03-11T20:00:00 89 0 7 45.9432 24.9668
158 158   Peru 2020-03-11T20:00:00 28 0 0 -9.19 -75.0152
157 157   Togo 2020-03-11T20:00:00 1 0 0 8.6195 0.8248
156 156   Slovakia 2020-03-11T20:00:00 32 0 0 48.669 19.699
155 155   Cameroon 2020-03-11T20:00:00 2 0 0 3.848 11.5021
154 154   Serbia 2020-03-11T20:00:00 35 0 0 44.0165 21.0059
153 153   Holy See 2020-03-11T20:00:00 1 0 0 41.9029 12.4534
152 152   Malaysia 2020-03-11T20:00:00 197 0 26 4.2105 101.9758
151 151   Spain 2020-03-11T20:00:00 5232 133 193 40.4637 -3.7492
150 150   Bhutan 2020-03-11T20:00:00 1 0 0 27.5142 90.4336
149 149 Alberta Canada 2020-03-11T20:00:00 29 0 0 53.9333 -116.5765
148 148   Costa Rica 2020-03-11T20:00:00 23 0 0 9.7489 -83.7534
147 147   Luxembourg 2020-03-11T20:00:00 34 0 0 49.8153 6.1296
146 146   Cote d'Ivoire 2020-03-11T20:00:00 1 0 0 7.54 -5.5471
145 145   Saudi Arabia 2020-03-11T20:00:00 86 0 1 23.8859 45.0792
144 144   Bosnia and Herzegovina 2020-03-11T20:00:00 13 0 0 43.9159 17.6791
143 143   South Africa 2020-03-11T20:00:00 24 0 0 -30.5595 22.9375
142 142   Finland 2020-03-11T20:00:00 155 0 1 61.9241 25.7482
141 141   Slovenia 2020-03-11T20:00:00 141 0 0 46.1512 14.9955
140 140 Alabama US 2020-03-11T20:00:00 5 0 0 32.3182 -86.9023
139 139 Northern Territory Australia 2020-03-11T20:00:00 1 0 0 -12.4634 130.8456
138 138   Hungary 2020-03-11T20:00:00 19 0 0 47.1625 19.5033
137 137 Gibraltar United Kingdom 2020-03-11T20:00:00 1 0 1 36.1408 -5.3536
136 136 Faroe Islands Denmark 2020-03-11T20:00:00 3 0 0 61.8926 -6.9118
135 135   Poland 2020-03-11T20:00:00 68 2 0 51.9194 19.1451
134 134 St Martin France 2020-03-11T20:00:00 2 0 0 18.0708 -63.0501
133 133 Saint Barthelemy France 2020-03-11T20:00:00 1 0 0 17.9 -62.8333
132 132   Kenya 2020-03-11T20:00:00 1 0 0 -0.0236 37.9062
131 131   Jordan 2020-03-11T20:00:00 1 0 1 31.24 36.51

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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