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

299 rows sorted by Deaths

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last Update (date)

Link rowid Province/State Country/Region Last Update Confirmed Deaths ▼ Recovered Latitude Longitude
29 29   Czechia 2020-03-20T20:13:15 833 0 4 49.8175 15.473
35 35 Jiangsu China 2020-03-15T01:53:02 631 0 631 32.9711 119.455
47 47   Qatar 2020-03-20T20:13:16 470 0 10 25.3548 51.1839
48 48   Finland 2020-03-20T15:43:24 450 0 10 61.9241 25.7482
49 49   Chile 2020-03-20T20:13:17 434 0 6 -35.6751 -71.543
53 53   Iceland 2020-03-20T15:13:21 409 0 5 64.9631 -19.0208
55 55   Singapore 2020-03-20T15:43:24 385 0 124 1.3521 103.8198
62 62   Saudi Arabia 2020-03-20T20:43:02 344 0 8 23.8859 45.0792
67 67   Romania 2020-03-20T15:13:21 308 0 25 45.9432 24.9668
72 72   Estonia 2020-03-20T14:43:04 283 0 1 58.5953 25.0136
80 80 Tennessee US 2020-03-20T23:43:03 233 0 0 35.7478 -86.6923
84 84   South Africa 2020-03-20T14:43:04 202 0 0 -30.5595 22.9375
86 86 Queensland Australia 2020-03-20T21:13:30 184 0 8 -28.0167 153.4
89 89 North Carolina US 2020-03-20T23:43:03 172 0 0 35.6301 -79.8064
93 93   Kuwait 2020-03-20T14:43:04 159 0 18 29.3117 47.4818
103 103   Armenia 2020-03-20T14:43:04 136 0 1 40.0691 45.0382
107 107 Shanxi China 2020-03-13T11:09:03 133 0 133 37.5777 112.2922
109 109   Colombia 2020-03-20T14:13:08 128 0 1 4.5709 -74.2973
115 115 Victoria Australia 2020-03-18T12:13:09 121 0 8 -37.8136 144.9631
116 116 Minnesota US 2020-03-20T19:13:30 115 0 0 45.6945 -93.9002
119 119   Latvia 2020-03-20T14:43:04 111 0 1 56.8796 24.6032
120 120 Arkansas US 2020-03-20T21:43:03 96 0 0 34.9697 -92.3731
121 121   Uruguay 2020-03-20T01:43:03 94 0 0 -32.5228 -55.7658
123 123   Vietnam 2020-03-20T20:43:02 91 0 16 14.0583 108.2772
125 125   Bosnia and Herzegovina 2020-03-20T20:43:02 89 0 2 43.9159 17.6791
129 129   Jordan 2020-03-20T20:43:02 85 0 1 30.5852 36.2384
130 130 Alabama US 2020-03-20T21:43:03 83 0 0 32.3182 -86.9023
131 131 Faroe Islands Denmark 2020-03-20T15:13:21 80 0 0 61.8926 -6.9118
133 133   Brunei 2020-03-20T15:43:24 78 0 1 4.5353 114.7277
134 134 Arizona US 2020-03-20T19:13:30 78 0 0 33.7298 -111.4312
135 135 Utah US 2020-03-20T16:13:23 78 0 0 40.15 -111.8624
138 138   Andorra 2020-03-20T15:13:21 75 0 1 42.5063 1.5218
140 140 Ningxia China 2020-03-16T14:38:45 75 0 75 37.2692 106.1655
141 141   Sri Lanka 2020-03-20T16:13:11 73 0 3 7.8731 80.7718
145 145   Belarus 2020-03-20T14:43:04 69 0 5 53.7098 27.9534
146 146   Cyprus 2020-03-19T18:13:29 67 0 0 35.1264 33.4299
147 147   North Macedonia 2020-03-20T14:43:04 67 0 1 41.6086 21.7453
150 150   Malta 2020-03-20T15:13:21 64 0 2 35.9375 14.3754
151 151 Maine US 2020-03-20T19:13:30 56 0 0 44.6939 -69.3819
153 153 Rhode Island US 2020-03-20T19:43:03 54 0 0 41.6809 -71.5118
155 155   Cambodia 2020-03-20T15:43:24 51 0 1 12.5657 104.991
156 156 South Australia Australia 2020-03-20T21:13:30 50 0 3 -34.9285 138.6007
157 157   Kazakhstan 2020-03-20T14:13:08 49 0 0 48.0196 66.9237
158 158   Lithuania 2020-03-20T15:43:24 47 0 0 55.1694 23.8813
159 159 Diamond Princess US 2020-03-20T19:43:03 49 0 0 35.4437 139.638
161 161   Oman 2020-03-19T20:13:34 48 0 12 21.4735 55.9754
163 163   Guadeloupe 2020-03-20T10:13:38 45 0 0 16.265 -61.551
164 164 Iowa US 2020-03-20T19:43:03 45 0 0 42.0115 -93.2105
167 167 New Hampshire US 2020-03-19T23:43:04 44 0 0 43.4525 -71.5639
168 168   Georgia 2020-03-20T14:43:04 43 0 1 42.3154 43.3569
169 169 New Mexico US 2020-03-20T21:43:03 43 0 0 34.8405 -106.2485
170 170   Venezuela 2020-03-19T20:13:34 42 0 0 6.4238 -66.5897
172 172   New Zealand 2020-03-20T02:13:50 39 0 0 -40.9006 174.886
173 173   Senegal 2020-03-20T15:43:24 38 0 2 14.4974 -14.4524
174 174 Delaware US 2020-03-20T19:43:03 38 0 0 39.3185 -75.5071
175 175 Nebraska US 2020-03-20T21:43:03 37 0 0 41.1254 -98.2681
176 176   Uzbekistan 2020-03-20T14:43:04 33 0 0 41.3775 64.5853
180 180   Liechtenstein 2020-03-18T19:14:33 28 0 0 47.166 9.5554
181 181   Reunion 2020-03-20T02:13:59 28 0 0 -21.1151 55.5364
182 182 Hawaii US 2020-03-20T02:43:10 26 0 0 21.0943 -157.4983
183 183   Afghanistan 2020-03-20T14:43:04 29 0 1 33.9391 67.71
184 184   Honduras 2020-03-20T14:13:08 24 0 0 15.2 -86.2419
185 185 Grand Princess US 2020-03-20T19:43:03 23 0 0 37.6489 -122.6655
186 186 Idaho US 2020-03-20T02:43:10 23 0 0 44.2405 -114.4788
188 188   Cameroon 2020-03-20T14:43:04 20 0 0 3.848 11.5021
189 189 Saskatchewan Canada 2020-03-20T03:13:18 20 0 0 52.9399 -106.4509
190 190 North Dakota US 2020-03-20T02:43:10 19 0 0 47.5289 -99.784
191 191 Wyoming US 2020-03-20T22:14:43 19 0 0 42.756 -107.3025
192 192 Qinghai China 2020-03-11T02:18:14 18 0 18 35.7452 95.9956
193 193   Congo (Kinshasa) 2020-03-20T14:43:04 18 0 0 -4.0383 21.7587
194 194 Manitoba Canada 2020-03-19T03:13:26 17 0 0 53.7609 -98.8139
195 195 Macau China 2020-03-19T01:02:56 17 0 10 22.1667 113.55
196 196   Rwanda 2020-03-20T20:43:03 17 0 0 -1.9403 29.8739
198 198   Ghana 2020-03-20T15:43:24 16 0 0 7.9465 -1.0232
200 200   Bolivia 2020-03-20T02:43:10 15 0 0 -16.2902 -63.5887
201 201 Nova Scotia Canada 2020-03-20T21:13:29 15 0 0 44.682 -63.7443
202 202   French Guiana 2020-03-20T10:13:39 15 0 0 3.9339 -53.1258
203 203 Montana US 2020-03-20T16:43:10 15 0 0 46.9219 -110.4544
204 204   Montenegro 2020-03-20T20:43:03 14 0 0 42.7087 19.3744
205 205 Guam US 2020-03-20T16:43:10 14 0 0 13.4443 144.7937
206 206 Puerto Rico US 2020-03-20T22:13:55 14 0 0 18.2208 -66.5901
208 208 Channel Islands United Kingdom 2020-03-20T20:43:03 14 0 0 49.3723 -2.3644
209 209   Maldives 2020-03-15T18:20:18 13 0 0 3.2028 73.2207
210 210   Paraguay 2020-03-20T02:13:50 13 0 0 -23.4425 -58.4438
212 212   Mauritius 2020-03-20T15:13:21 12 0 0 -20.3484 57.5522
213 213   Nigeria 2020-03-20T02:13:50 12 0 1 9.082 8.6753
214 214 Alaska US 2020-03-20T16:43:10 12 0 0 61.3707 -152.4044
215 215 New Brunswick Canada 2020-03-18T18:33:03 11 0 0 46.5653 -66.4619
216 216 French Polynesia France 2020-03-20T10:13:37 11 0 0 -17.6797 -149.4068
217 217   Monaco 2020-03-20T14:43:04 11 0 0 43.7384 7.4246
218 218 Tasmania Australia 2020-03-19T11:13:54 10 0 3 -41.4545 145.9707
219 219 Grand Princess Canada 2020-03-20T03:13:18 10 0 0 37.6489 -122.6655
220 220 Gibraltar United Kingdom 2020-03-19T20:13:52 10 0 2 36.1408 -5.3536
221 221   Cote d'Ivoire 2020-03-19T01:03:46 9 0 1 7.54 -5.5471
222 222   Ethiopia 2020-03-20T14:13:11 9 0 0 9.145 40.4897
223 223   Togo 2020-03-20T14:43:04 9 0 1 8.6195 0.8248
224 224   Trinidad and Tobago 2020-03-19T10:53:03 9 0 0 10.6918 -61.2225
226 226   Kenya 2020-03-19T02:33:08 7 0 0 -0.0236 37.9062
227 227   Seychelles 2020-03-20T15:43:24 7 0 0 -4.6796 55.492
228 228 West Virginia US 2020-03-20T19:43:03 7 0 0 38.4912 -80.9545

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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