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 Confirmed

✎ 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
66 66 From Diamond Princess Australia 2020-03-11T20:00:00 0 0 0 35.4437 139.638
118 118   Sudan 2020-03-11T20:00:00 0 1 0 12.8628 30.2176
220 220 West Virginia US 2020-03-11T20:00:00 0 0 0 38.491226 -80.954453
33 33 Tibet China 2020-03-11T02:18:14 1 0 1 31.6927 88.0924
46 46   Nepal 2020-03-11T20:00:00 1 0 1 28.3949 84.124
53 53 Australian Capital Territory Australia 2020-03-11T20:00:00 1 0 0 -35.4735 149.0124
62 62 New Brunswick Canada 2020-03-11T20:00:00 1 0 0 46.5653 -66.4619
102 102   Cayman Islands 2020-03-11T20:00:00 1 0 0 19.3133 -81.2546
107 107   Guadeloupe 2020-03-11T20:00:00 1 0 0 16.265 -61.551
117 117   Ethiopia 2020-03-11T20:00:00 1 0 0 9.145 40.4897
120 120   Andorra 2020-03-11T20:00:00 1 0 0 42.5063 1.5218
121 121   Guinea 2020-03-11T20:00:00 1 0 0 9.9456 -9.6966
122 122   Antigua and Barbuda 2020-03-11T20:00:00 1 0 0 17.0608 -61.7964
131 131   Jordan 2020-03-11T20:00:00 1 0 1 31.24 36.51
132 132   Kenya 2020-03-11T20:00:00 1 0 0 -0.0236 37.9062
133 133 Saint Barthelemy France 2020-03-11T20:00:00 1 0 0 17.9 -62.8333
137 137 Gibraltar United Kingdom 2020-03-11T20:00:00 1 0 1 36.1408 -5.3536
139 139 Northern Territory Australia 2020-03-11T20:00:00 1 0 0 -12.4634 130.8456
146 146   Cote d'Ivoire 2020-03-11T20:00:00 1 0 0 7.54 -5.5471
150 150   Bhutan 2020-03-11T20:00:00 1 0 0 27.5142 90.4336
153 153   Holy See 2020-03-11T20:00:00 1 0 0 41.9029 12.4534
157 157   Togo 2020-03-11T20:00:00 1 0 0 8.6195 0.8248
173 173 Alaska US 2020-03-11T20:00:00 1 0 0 61.370716 -152.404419
184 184 Idaho US 2020-03-11T20:00:00 1 0 0 44.240459 -114.478828
191 191 Maine US 2020-03-11T20:00:00 1 0 0 44.693947 -69.381927
196 196 Mississippi US 2020-03-11T20:00:00 1 0 0 32.741646 -89.678696
198 198 Montana US 2020-03-11T20:00:00 1 0 0 46.921925 -110.454353
206 206 North Dakota US 2020-03-11T20:00:00 1 0 0 47.528912 -99.784012
222 222 Wyoming US 2020-03-11T20:00:00 1 0 0 42.755966 -107.30249
224 224   Mongolia 2020-03-11T20:00:00 1 0 0 46.8625 103.8467
228 228   Liechtenstein 2020-03-11T20:00:00 1 0 0 47.14 9.55
229 229   Guyana 2020-03-11T20:00:00 1 1 0 5.0 -58.75
37 37   Burkina Faso 2020-03-11T20:00:00 2 0 0 12.2383 -1.5616
44 44 Channel Islands United Kingdom 2020-03-11T20:00:00 2 0 0 49.372284 -2.364351
55 55   Congo (Kinshasa) 2020-03-11T20:00:00 2 0 0 -4.0383 21.7587
56 56   Honduras 2020-03-11T20:00:00 2 0 0 15.2 -86.2419
91 91   Nigeria 2020-03-11T20:00:00 2 0 0 9.082 8.6753
112 112 Saskatchewan Canada 2020-03-11T20:00:00 2 0 0 52.9399 -106.4509
127 127   Aruba 2020-03-11T20:00:00 2 0 0 12.5211 -69.9683
128 128 Grand Princess Canada 2020-03-11T20:00:00 2 0 0 37.6489 -122.6655
134 134 St Martin France 2020-03-11T20:00:00 2 0 0 18.0708 -63.0501
155 155   Cameroon 2020-03-11T20:00:00 2 0 0 3.848 11.5021
183 183 Hawaii US 2020-03-11T20:00:00 2 0 0 21.094318 -157.498337
197 197 Missouri US 2020-03-11T20:00:00 2 0 0 38.456085 -92.288368
208 208 Oklahoma US 2020-03-11T20:00:00 2 0 0 35.565342 -96.928917
217 217 Vermont US 2020-03-11T20:00:00 2 0 0 44.045876 -72.710686
227 227   Monaco 2020-03-11T20:00:00 2 0 0 43.7333 7.4167
67 67   Ukraine 2020-03-11T20:00:00 3 1 0 48.3794 31.1656
72 72   Bangladesh 2020-03-11T20:00:00 3 0 0 23.685 90.3563
100 100 French Polynesia France 2020-03-11T20:00:00 3 0 0 -17.6797 149.4068
110 110   Bolivia 2020-03-11T20:00:00 3 0 0 -16.2902 -63.5887
136 136 Faroe Islands Denmark 2020-03-11T20:00:00 3 0 0 61.8926 -6.9118
164 164   Martinique 2020-03-11T20:00:00 3 0 0 14.6415 -61.0242
89 89   Cuba 2020-03-11T20:00:00 4 0 0 21.5218 -77.7812
92 92   Lithuania 2020-03-11T20:00:00 4 0 0 55.1694 23.8813
97 97   Kazakhstan 2020-03-11T20:00:00 4 0 0 48.0196 66.9237
111 111 Manitoba Canada 2020-03-11T20:00:00 4 0 0 53.7609 -98.8139
179 179 Delaware US 2020-03-11T20:00:00 4 0 0 39.318523 -75.507141
35 35 Tasmania Australia 2020-03-11T20:00:00 5 0 0 -41.4545 145.9707
50 50   Cambodia 2020-03-11T20:00:00 5 0 1 12.5657 104.991
59 59   Reunion 2020-03-11T20:00:00 5 0 0 -21.1151 55.5364
81 81   Turkey 2020-03-11T20:00:00 5 0 0 38.9637 35.2433
93 93   New Zealand 2020-03-11T20:00:00 5 0 0 -40.9006 174.886
108 108   Dominican Republic 2020-03-11T20:00:00 5 0 0 18.7357 -70.1627
140 140 Alabama US 2020-03-11T20:00:00 5 0 0 32.3182 -86.9023
165 165   French Guiana 2020-03-11T20:00:00 5 0 0 3.9339 -53.1258
188 188 Kansas US 2020-03-11T20:00:00 5 1 0 38.5266 -96.726486
47 47   Sri Lanka 2020-03-11T20:00:00 6 0 1 7.8731 80.7718
167 167   Paraguay 2020-03-11T20:00:00 6 0 0 -23.4425 -58.4438
168 168   Moldova 2020-03-11T20:00:00 6 0 0 47.4116 28.3699
175 175 Arkansas US 2020-03-11T20:00:00 6 0 0 34.969704 -92.373123
201 201 New Hampshire US 2020-03-11T20:00:00 6 0 0 43.452492 -71.563896
126 126   Morocco 2020-03-11T20:00:00 7 1 1 31.7917 -7.0926
96 96   Armenia 2020-03-11T20:00:00 8 0 0 40.0691 45.0382
213 213 South Dakota US 2020-03-11T20:00:00 8 1 0 44.299782 -99.438828
225 225   Jamaica 2020-03-11T20:00:00 8 0 0 18.1096 -77.2975
169 169   Maldives 2020-03-11T20:00:00 9 0 0 3.2028 73.2207
174 174 Arizona US 2020-03-11T20:00:00 9 0 1 33.729759 -111.431221
216 216 Utah US 2020-03-11T20:00:00 9 0 0 40.150032 -111.862434
32 32 Macau China 2020-03-11T18:52:03 10 0 10 22.1667 113.55
116 116   Senegal 2020-03-11T20:00:00 10 0 1 14.4974 -14.4524
180 180 District of Columbia US 2020-03-11T20:00:00 10 0 0 38.897438 -77.026817
203 203 New Mexico US 2020-03-11T20:00:00 10 0 0 34.840515 -106.248482
178 178 Connecticut US 2020-03-11T20:00:00 11 0 0 41.597782 -72.755371
160 160   Mexico 2020-03-11T20:00:00 12 0 4 23.6345 -102.5528
166 166   Malta 2020-03-11T20:00:00 12 0 1 35.9375 14.3754
144 144   Bosnia and Herzegovina 2020-03-11T20:00:00 13 0 0 43.9159 17.6791
161 161   Colombia 2020-03-11T20:00:00 13 0 0 4.5709 -74.2973
186 186 Indiana US 2020-03-11T20:00:00 13 0 0 39.849426 -86.258278
199 199 Nebraska US 2020-03-11T20:00:00 13 0 0 41.12537 -98.268082
207 207 Ohio US 2020-03-11T20:00:00 13 0 0 40.388783 -82.764915
212 212 South Carolina US 2020-03-11T20:00:00 13 0 0 33.856892 -80.945007
226 226   Afghanistan 2020-03-11T20:00:00 13 0 0 33.0 65.0
74 74   North Macedonia 2020-03-11T20:00:00 14 0 1 41.6086 21.7453
101 101 Western Australia Australia 2020-03-11T20:00:00 14 1 0 -31.9505 115.8605
172 172   Cyprus 2020-03-11T20:00:00 14 0 0 35.1264 33.4299
189 189 Kentucky US 2020-03-11T20:00:00 14 0 0 37.66814 -84.670067
195 195 Minnesota US 2020-03-11T20:00:00 14 0 0 45.694454 -93.900192
211 211 Rhode Island US 2020-03-11T20:00:00 14 0 0 41.680893 -71.51178
95 95   Azerbaijan 2020-03-11T20:00:00 15 1 3 40.1431 47.5769

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