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

255 rows sorted by Confirmed

View and edit SQL

Suggested facets: Deaths, Last Update (date)

Link rowid Province/State Country/Region Last Update Confirmed ▼ Deaths Recovered Latitude Longitude
250 From Diamond Princess Australia 2020-02-29T02:03:10 0 0 0 35.4437 139.638
251 Northern Territory Australia 2020-03-06T04:33:03 0 0 0 -12.4634 130.8456
252 Lackland, TX (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 29.3829 -98.6134
253 Montgomery County, TX US 2020-03-07T19:53:02 0 0 0 30.3213 -95.4778
254 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 41.2545 -95.9758
255 Travis, CA (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 38.2721 -121.9399
176   Andorra 2020-03-02T20:23:16 1 0 0 42.5063 1.5218
177   Armenia 2020-03-01T19:53:02 1 0 0 40.0691 45.0382
178   Bhutan 2020-03-06T15:43:02 1 0 0 27.5142 90.4336
179 Calgary, Alberta Canada 2020-03-06T13:13:34 1 0 0 51.0447 -114.0719
180 London, ON Canada 2020-02-12T18:53:03 1 0 1 42.9849 -81.2453
181   Colombia 2020-03-07T00:43:02 1 0 0 4.5709 -74.2973
182   Gibraltar 2020-03-04T13:03:13 1 0 0 36.1408 -5.3536
183   Jordan 2020-03-03T15:33:02 1 0 0 31.24 36.51
184   Liechtenstein 2020-03-04T01:33:07 1 0 0 47.14 9.55
185   Lithuania 2020-02-28T16:23:03 1 0 0 55.1694 23.8813
186 Tibet Mainland China 2020-02-12T06:43:02 1 0 1 31.6927 88.0924
187   Moldova 2020-03-08T05:13:07 1 0 0 47.4116 28.3699
188   Monaco 2020-02-29T00:33:01 1 0 0 43.7333 7.4167
189   Nepal 2020-02-12T14:43:03 1 0 1 28.1667 84.25
190   Nigeria 2020-02-28T16:23:03 1 0 0 9.082 8.6753
191   Paraguay 2020-03-08T09:13:16 1 0 0 -23.4425 -58.4438
192   Serbia 2020-03-06T15:43:02 1 0 0 44.0165 21.0059
193   Sri Lanka 2020-02-08T03:43:03 1 0 1 7.0 81.0
194   Togo 2020-03-07T02:13:09 1 0 0 8.6195 0.8248
195 Berkshire County, MA US 2020-03-08T00:43:03 1 0 0 42.3118 -73.1822
196 Charleston County, SC US 2020-03-07T01:53:03 1 0 0 32.7957 -79.7848
197 Chatham County, NC US 2020-03-06T16:13:15 1 0 0 35.7211 -79.1781
198 Clark County, WA US 2020-03-07T20:03:07 1 0 0 45.7466 -122.5194
199 Cobb County, GA US 2020-03-07T16:53:03 1 0 0 33.8999 -84.5641
200 Davidson County, TN US 2020-03-08T18:03:06 1 0 0 36.1343 -86.822
201 Davis County, UT US 2020-03-07T04:43:02 1 0 0 40.9629 -112.0953
202 Delaware County, PA US 2020-03-06T15:33:03 1 0 0 39.9078 -75.3879
203 Douglas County, NE US 2020-03-06T23:33:02 1 0 0 41.3148 -96.1951
204 Douglas County, OR US 2020-03-08T19:53:03 1 0 0 43.1261 -123.2492
205 El Paso County, CO US 2020-03-07T01:13:21 1 0 0 38.9108 -104.4723
206 Fairfield County, CT US 2020-03-08T21:23:03 1 0 0 41.256 -73.3709
207 Fayette County, KY US 2020-03-06T23:23:03 1 0 0 38.0606 -84.4803
208 Fresno County, CA US 2020-03-08T04:23:15 1 0 0 36.9859 -119.2321
209 Grant County, WA US 2020-03-05T20:23:07 1 0 0 47.1981 -119.3732
210 Harford County, MD US 2020-03-08T21:53:03 1 0 0 39.5839 -76.3637
211 Hendricks County, IN US 2020-03-08T19:33:03 1 0 0 39.8065 -86.5401
212 Honolulu County, HI US 2020-03-07T02:03:30 1 0 0 21.307 -157.8584
213 Hudson County, NJ US 2020-03-08T19:43:03 1 0 0 40.7453 -74.0535
214 Humboldt County, CA US 2020-02-21T05:13:09 1 0 0 40.745 -123.8695
215 Jefferson County, WA US 2020-03-07T16:43:02 1 0 0 47.7425 -123.304
216 Johnson County, KS US 2020-03-08T00:33:02 1 0 0 38.8454 -94.8521
217 Kershaw County, SC US 2020-03-07T02:03:30 1 0 0 34.3672 -80.5883
218 Kittitas County, WA US 2020-03-08T00:43:03 1 0 0 47.175 -120.9319
219 Klamath County, OR US 2020-03-07T20:13:14 1 0 0 42.6953 -121.6142
220 Madera County, CA US 2020-03-07T20:13:14 1 0 0 37.2519 -119.6963
221 Madison, WI US 2020-03-03T15:53:03 1 0 1 43.0731 -89.4012
222 Manatee County, FL US 2020-03-08T06:23:05 1 0 0 27.4799 -82.3452
223 Marion County, IN US 2020-03-06T17:13:12 1 0 0 39.8362 -86.1752
224 Marion County, OR US 2020-03-08T19:43:03 1 0 0 44.8446 -122.5927
225 Okaloosa County, FL US 2020-03-08T03:03:08 1 0 0 30.5773 -86.6611
226 Plymouth County, MA US 2020-03-07T03:53:03 1 0 0 42.1615 -70.7928
227 Polk County, GA US 2020-03-08T04:13:22 1 0 0 34.0132 -85.1479
228 Ramsey County, MN US 2020-03-06T23:23:03 1 0 0 44.9964 -93.0616
229 Riverside County, CA US 2020-03-08T10:33:03 1 0 0 33.9533 -117.3961
230 San Antonio, TX US 2020-02-13T18:53:02 1 0 0 29.4241 -98.4936
231 Santa Rosa County, FL US 2020-03-08T15:33:04 1 1 0 30.769 -86.9824
232 Sarasota, FL US 2020-03-02T03:23:06 1 0 0 27.3364 -82.5307
233 Shelby County, TN US 2020-03-08T16:13:36 1 0 0 35.1269 -89.9253
234 Sonoma County, CA US 2020-03-02T20:53:02 1 0 0 38.578 -122.9888
235 Spokane County, WA US 2020-03-08T21:53:04 1 0 0 47.6587 -117.4225
236 St. Louis County, MO US 2020-03-08T11:23:08 1 0 0 38.6103 -90.4125
237 Suffolk County, NY US 2020-03-08T16:03:05 1 0 0 40.9849 -72.6151
238 Tulsa County, OK US 2020-03-07T04:43:02 1 0 0 36.1593 -95.941
239 Ulster County, NY US 2020-03-08T16:23:07 1 0 0 41.8586 -74.3118
240 Umatilla, OR US 2020-03-02T20:23:16 1 0 0 45.775 -118.7606
241 Unassigned Location, VT US 2020-03-08T06:23:05 1 0 0 44.3378 -72.7563
242 Unknown Location, MA US 2020-03-08T21:23:03 1 0 0 42.4072 -71.3824
243 Volusia County, FL US 2020-03-08T03:03:08 1 0 0 29.028 -81.0755
244 Wake County, NC US 2020-03-03T20:53:02 1 0 0 35.8032 -78.5661
245 Wayne County, PA US 2020-03-06T16:13:15 1 0 0 41.6739 -75.2479
246 Williamson County, TN US 2020-03-05T23:33:03 1 0 0 35.9179 -86.8622
247 Yolo County, CA US 2020-03-06T20:13:14 1 0 0 38.7646 -121.9018
248   Ukraine 2020-03-03T15:33:02 1 0 0 48.3794 31.1656
249   Vatican City 2020-03-06T15:43:02 1 0 0 41.9029 12.4534
150 Tasmania Australia 2020-03-08T05:43:04 2 0 0 -41.4545 145.9707
151   Cambodia 2020-03-08T04:53:03 2 0 1 11.55 104.9167
152   Cameroon 2020-03-08T05:23:03 2 0 0 3.848 11.5021
153   Faroe Islands 2020-03-08T05:13:07 2 0 0 61.8926 -6.9118
154   Latvia 2020-03-08T10:33:03 2 0 0 56.8796 24.6032
155   Martinique 2020-03-07T03:23:05 2 0 0 14.6415 -61.0242
156   Morocco 2020-03-05T13:53:03 2 0 0 31.7917 -7.0926
157   Tunisia 2020-03-08T21:13:10 2 0 0 33.8869 9.5375
158 Alameda County, CA US 2020-03-07T13:13:14 2 0 0 37.6017 -121.7195
159 Broward County, FL US 2020-03-07T04:43:02 2 0 0 26.1901 -80.3659
160 Clark County, NV US 2020-03-08T21:43:03 2 0 0 36.0796 -115.094
161 Denver County, CO US 2020-03-06T23:33:02 2 0 0 39.7392 -104.9903
162 Fairfax County, VA US 2020-03-08T21:33:02 2 0 0 38.9085 -77.2405
163 Hillsborough, FL US 2020-03-03T18:33:02 2 0 0 27.9904 -82.3018
164 Jackson County, OR US 2020-03-08T00:13:16 2 0 0 42.3345 -122.7647
165 Lee County, FL US 2020-03-08T15:33:04 2 1 0 26.663 -81.9535
166 Pinal County, AZ US 2020-03-07T17:13:23 2 0 0 32.8162 -111.2845
167 Rockingham County, NH US 2020-03-08T17:53:03 2 0 0 42.9931 -71.0498
168 Rockland County, NY US 2020-03-07T16:43:02 2 0 0 41.1489 -73.983
169 Sacramento County, CA US 2020-02-27T20:33:02 2 0 0 38.4747 -121.3542

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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