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 Recovered

View and edit SQL

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

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered ▼ Latitude Longitude
34   Panama 2020-03-11T20:00:00 27 1 0 8.538 -80.7821
35 Tasmania Australia 2020-03-11T20:00:00 5 0 0 -41.4545 145.9707
37   Burkina Faso 2020-03-11T20:00:00 2 0 0 12.2383 -1.5616
38   Albania 2020-03-11T20:00:00 33 1 0 41.1533 20.1683
44 Channel Islands United Kingdom 2020-03-11T20:00:00 2 0 0 49.372284 -2.364351
51   San Marino 2020-03-11T20:00:00 80 5 0 43.9424 12.4578
53 Australian Capital Territory Australia 2020-03-11T20:00:00 1 0 0 -35.4735 149.0124
55   Congo (Kinshasa) 2020-03-11T20:00:00 2 0 0 -4.0383 21.7587
56   Honduras 2020-03-11T20:00:00 2 0 0 15.2 -86.2419
57 Diamond Princess US 2020-03-11T20:00:00 46 0 0 35.4437 139.638
59   Reunion 2020-03-11T20:00:00 5 0 0 -21.1151 55.5364
62 New Brunswick Canada 2020-03-11T20:00:00 1 0 0 46.5653 -66.4619
66 From Diamond Princess Australia 2020-03-11T20:00:00 0 0 0 35.4437 139.638
67   Ukraine 2020-03-11T20:00:00 3 1 0 48.3794 31.1656
70   Ireland 2020-03-11T20:00:00 90 1 0 53.1424 -7.6921
71   Georgia 2020-03-11T20:00:00 25 0 0 42.3154 43.3569
72   Bangladesh 2020-03-11T20:00:00 3 0 0 23.685 90.3563
75   Brazil 2020-03-11T20:00:00 151 0 0 -14.235 -51.9253
76   Greece 2020-03-11T20:00:00 190 1 0 39.0742 21.8243
81   Turkey 2020-03-11T20:00:00 5 0 0 38.9637 35.2433
84   Ecuador 2020-03-11T20:00:00 17 0 0 -1.8312 -78.1834
85   Estonia 2020-03-11T20:00:00 79 0 0 58.5953 25.0136
88   Netherlands 2020-03-11T20:00:00 804 10 0 52.1326 5.2913
89   Cuba 2020-03-11T20:00:00 4 0 0 21.5218 -77.7812
90 Quebec Canada 2020-03-11T20:00:00 17 0 0 52.9399 -73.5491
91   Nigeria 2020-03-11T20:00:00 2 0 0 9.082 8.6753
92   Lithuania 2020-03-11T20:00:00 4 0 0 55.1694 23.8813
93   New Zealand 2020-03-11T20:00:00 5 0 0 -40.9006 174.886
96   Armenia 2020-03-11T20:00:00 8 0 0 40.0691 45.0382
97   Kazakhstan 2020-03-11T20:00:00 4 0 0 48.0196 66.9237
100 French Polynesia France 2020-03-11T20:00:00 3 0 0 -17.6797 149.4068
101 Western Australia Australia 2020-03-11T20:00:00 14 1 0 -31.9505 115.8605
102   Cayman Islands 2020-03-11T20:00:00 1 0 0 19.3133 -81.2546
104   Czechia 2020-03-11T20:00:00 141 0 0 49.8175 15.473
105   Qatar 2020-03-11T20:00:00 320 0 0 25.3548 51.1839
107   Guadeloupe 2020-03-11T20:00:00 1 0 0 16.265 -61.551
108   Dominican Republic 2020-03-11T20:00:00 5 0 0 18.7357 -70.1627
110   Bolivia 2020-03-11T20:00:00 3 0 0 -16.2902 -63.5887
111 Manitoba Canada 2020-03-11T20:00:00 4 0 0 53.7609 -98.8139
112 Saskatchewan Canada 2020-03-11T20:00:00 2 0 0 52.9399 -106.4509
117   Ethiopia 2020-03-11T20:00:00 1 0 0 9.145 40.4897
118   Sudan 2020-03-11T20:00:00 0 1 0 12.8628 30.2176
120   Andorra 2020-03-11T20:00:00 1 0 0 42.5063 1.5218
121   Guinea 2020-03-11T20:00:00 1 0 0 9.9456 -9.6966
122   Antigua and Barbuda 2020-03-11T20:00:00 1 0 0 17.0608 -61.7964
127   Aruba 2020-03-11T20:00:00 2 0 0 12.5211 -69.9683
128 Grand Princess Canada 2020-03-11T20:00:00 2 0 0 37.6489 -122.6655
129   Argentina 2020-03-11T20:00:00 31 2 0 -38.4161 -63.6167
130   Chile 2020-03-11T20:00:00 43 0 0 -35.6751 -71.543
132   Kenya 2020-03-11T20:00:00 1 0 0 -0.0236 37.9062
133 Saint Barthelemy France 2020-03-11T20:00:00 1 0 0 17.9 -62.8333
134 St Martin France 2020-03-11T20:00:00 2 0 0 18.0708 -63.0501
135   Poland 2020-03-11T20:00:00 68 2 0 51.9194 19.1451
136 Faroe Islands Denmark 2020-03-11T20:00:00 3 0 0 61.8926 -6.9118
138   Hungary 2020-03-11T20:00:00 19 0 0 47.1625 19.5033
139 Northern Territory Australia 2020-03-11T20:00:00 1 0 0 -12.4634 130.8456
140 Alabama US 2020-03-11T20:00:00 5 0 0 32.3182 -86.9023
141   Slovenia 2020-03-11T20:00:00 141 0 0 46.1512 14.9955
143   South Africa 2020-03-11T20:00:00 24 0 0 -30.5595 22.9375
144   Bosnia and Herzegovina 2020-03-11T20:00:00 13 0 0 43.9159 17.6791
146   Cote d'Ivoire 2020-03-11T20:00:00 1 0 0 7.54 -5.5471
147   Luxembourg 2020-03-11T20:00:00 34 0 0 49.8153 6.1296
148   Costa Rica 2020-03-11T20:00:00 23 0 0 9.7489 -83.7534
149 Alberta Canada 2020-03-11T20:00:00 29 0 0 53.9333 -116.5765
150   Bhutan 2020-03-11T20:00:00 1 0 0 27.5142 90.4336
153   Holy See 2020-03-11T20:00:00 1 0 0 41.9029 12.4534
154   Serbia 2020-03-11T20:00:00 35 0 0 44.0165 21.0059
155   Cameroon 2020-03-11T20:00:00 2 0 0 3.848 11.5021
156   Slovakia 2020-03-11T20:00:00 32 0 0 48.669 19.699
157   Togo 2020-03-11T20:00:00 1 0 0 8.6195 0.8248
158   Peru 2020-03-11T20:00:00 28 0 0 -9.19 -75.0152
161   Colombia 2020-03-11T20:00:00 13 0 0 4.5709 -74.2973
162 Grand Princess US 2020-03-11T20:00:00 21 0 0 37.64894 -122.665479
163   Brunei 2020-03-11T20:00:00 37 0 0 4.5353 114.7277
164   Martinique 2020-03-11T20:00:00 3 0 0 14.6415 -61.0242
165   French Guiana 2020-03-11T20:00:00 5 0 0 3.9339 -53.1258
167   Paraguay 2020-03-11T20:00:00 6 0 0 -23.4425 -58.4438
168   Moldova 2020-03-11T20:00:00 6 0 0 47.4116 28.3699
169   Maldives 2020-03-11T20:00:00 9 0 0 3.2028 73.2207
170   Bulgaria 2020-03-11T20:00:00 23 1 0 42.7339 25.4858
171   Tunisia 2020-03-11T20:00:00 16 0 0 33.8869 9.5375
172   Cyprus 2020-03-11T20:00:00 14 0 0 35.1264 33.4299
173 Alaska US 2020-03-11T20:00:00 1 0 0 61.370716 -152.404419
175 Arkansas US 2020-03-11T20:00:00 6 0 0 34.969704 -92.373123
177 Colorado US 2020-03-11T20:00:00 49 0 0 39.059811 -105.311104
178 Connecticut US 2020-03-11T20:00:00 11 0 0 41.597782 -72.755371
179 Delaware US 2020-03-11T20:00:00 4 0 0 39.318523 -75.507141
180 District of Columbia US 2020-03-11T20:00:00 10 0 0 38.897438 -77.026817
181 Florida US 2020-03-11T20:00:00 50 2 0 27.766279 -81.686783
182 Georgia US 2020-03-11T20:00:00 42 1 0 33.040619 -83.643074
183 Hawaii US 2020-03-11T20:00:00 2 0 0 21.094318 -157.498337
184 Idaho US 2020-03-11T20:00:00 1 0 0 44.240459 -114.478828
186 Indiana US 2020-03-11T20:00:00 13 0 0 39.849426 -86.258278
187 Iowa US 2020-03-11T20:00:00 17 0 0 42.011539 -93.210526
188 Kansas US 2020-03-11T20:00:00 5 1 0 38.5266 -96.726486
189 Kentucky US 2020-03-11T20:00:00 14 0 0 37.66814 -84.670067
190 Louisiana US 2020-03-11T20:00:00 36 0 0 31.169546 -91.867805
191 Maine US 2020-03-11T20:00:00 1 0 0 44.693947 -69.381927
192 Maryland US 2020-03-11T20:00:00 18 0 0 39.063946 -76.802101
194 Michigan US 2020-03-11T20:00:00 16 0 0 43.326618 -84.536095

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