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 Longitude

View and edit SQL

Suggested facets: Deaths, Last Update (date)

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude ▼
212 Honolulu County, HI US 2020-03-07T02:03:30 1 0 0 21.307 -157.8584
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
204 Douglas County, OR US 2020-03-08T19:53:03 1 0 0 43.1261 -123.2492
104 Washington County, OR US 2020-03-08T19:43:03 8 0 0 45.547 -123.1386
72 British Columbia Canada 2020-03-08T05:13:07 27 0 4 49.2827 -123.1207
234 Sonoma County, CA US 2020-03-02T20:53:02 1 0 0 38.578 -122.9888
164 Jackson County, OR US 2020-03-08T00:13:16 2 0 0 42.3345 -122.7647
76 Grand Princess Cruise Ship US 2020-03-07T01:33:02 21 0 0 37.6489 -122.6655
224 Marion County, OR US 2020-03-08T19:43:03 1 0 0 44.8446 -122.5927
198 Clark County, WA US 2020-03-07T20:03:07 1 0 0 45.7466 -122.5194
101 San Francisco County, CA US 2020-03-08T01:23:12 9 0 0 37.7749 -122.4194
171 San Mateo, CA US 2020-03-03T00:43:02 2 0 0 37.563 -122.3255
133 Pierce County, WA US 2020-03-08T21:43:03 4 0 0 47.0676 -122.1295
46 King County, WA US 2020-03-08T20:23:09 83 17 1 47.548 -121.9836
63 Santa Clara County, CA US 2020-03-08T21:23:03 38 0 1 37.3541 -121.9552
255 Travis, CA (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 38.2721 -121.9399
92 Contra Costa County, CA US 2020-03-08T21:43:03 12 0 0 37.8534 -121.9018
247 Yolo County, CA US 2020-03-06T20:13:14 1 0 0 38.7646 -121.9018
68 Snohomish County, WA US 2020-03-08T21:43:03 31 1 0 48.033 -121.8339
158 Alameda County, CA US 2020-03-07T13:13:14 2 0 0 37.6017 -121.7195
219 Klamath County, OR US 2020-03-07T20:13:14 1 0 0 42.6953 -121.6142
169 Sacramento County, CA US 2020-02-27T20:33:02 2 0 0 38.4747 -121.3542
170 San Benito, CA US 2020-02-03T03:53:02 2 0 0 36.5761 -120.9876
218 Kittitas County, WA US 2020-03-08T00:43:03 1 0 0 47.175 -120.9319
122 Placer County, CA US 2020-03-06T23:13:07 5 1 0 39.0916 -120.8039
123 Unassigned Location, WA US 2020-03-06T00:33:03 5 0 0 47.7511 -120.7401
220 Madera County, CA US 2020-03-07T20:13:14 1 0 0 37.2519 -119.6963
175 Washoe County, NV US 2020-03-08T21:43:03 2 0 0 40.5608 -119.6035
209 Grant County, WA US 2020-03-05T20:23:07 1 0 0 47.1981 -119.3732
208 Fresno County, CA US 2020-03-08T04:23:15 1 0 0 36.9859 -119.2321
240 Umatilla, OR US 2020-03-02T20:23:16 1 0 0 45.775 -118.7606
88 Los Angeles, CA US 2020-03-08T01:13:48 14 0 0 34.0522 -118.2437
147 Orange County, CA US 2020-03-04T02:13:11 3 0 0 33.7879 -117.8531
235 Spokane County, WA US 2020-03-08T21:53:04 1 0 0 47.6587 -117.4225
229 Riverside County, CA US 2020-03-08T10:33:03 1 0 0 33.9533 -117.3961
149 San Diego County, CA US 2020-03-05T20:33:03 3 0 1 32.7157 -117.1611
160 Clark County, NV US 2020-03-08T21:43:03 2 0 0 36.0796 -115.094
179 Calgary, Alberta Canada 2020-03-06T13:13:34 1 0 0 51.0447 -114.0719
137 Edmonton, Alberta Canada 2020-03-08T16:23:07 3 0 0 53.5461 -113.4938
146 Maricopa County, AZ US 2020-03-07T19:53:02 3 0 1 33.2918 -112.4291
201 Davis County, UT US 2020-03-07T04:43:02 1 0 0 40.9629 -112.0953
166 Pinal County, AZ US 2020-03-07T17:13:23 2 0 0 32.8162 -111.2845
173 Summit County, CO US 2020-03-06T01:29:39 2 0 0 39.5912 -106.064
161 Denver County, CO US 2020-03-06T23:33:02 2 0 0 39.7392 -104.9903
144 Douglas County, CO US 2020-03-07T01:53:03 3 0 0 39.2587 -104.9389
205 El Paso County, CO US 2020-03-07T01:13:21 1 0 0 38.9108 -104.4723
107   Mexico 2020-03-08T05:13:06 7 0 1 23.0 -102.0
252 Lackland, TX (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 29.3829 -98.6134
230 San Antonio, TX US 2020-02-13T18:53:02 1 0 0 29.4241 -98.4936
203 Douglas County, NE US 2020-03-06T23:33:02 1 0 0 41.3148 -96.1951
254 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 41.2545 -95.9758
238 Tulsa County, OK US 2020-03-07T04:43:02 1 0 0 36.1593 -95.941
114 Fort Bend County, TX US 2020-03-08T17:33:03 6 0 0 29.5693 -95.8143
253 Montgomery County, TX US 2020-03-07T19:53:02 0 0 0 30.3213 -95.4778
120 Harris County, TX US 2020-03-07T05:13:03 5 0 0 29.7752 -95.3103
216 Johnson County, KS US 2020-03-08T00:33:02 1 0 0 38.8454 -94.8521
228 Ramsey County, MN US 2020-03-06T23:23:03 1 0 0 44.9964 -93.0616
236 St. Louis County, MO US 2020-03-08T11:23:08 1 0 0 38.6103 -90.4125
233 Shelby County, TN US 2020-03-08T16:13:36 1 0 0 35.1269 -89.9253
221 Madison, WI US 2020-03-03T15:53:03 1 0 1 43.0731 -89.4012
108 Cook County, IL US 2020-03-08T20:23:09 7 0 2 41.7377 -87.6976
231 Santa Rosa County, FL US 2020-03-08T15:33:04 1 1 0 30.769 -86.9824
246 Williamson County, TN US 2020-03-05T23:33:03 1 0 0 35.9179 -86.8622
200 Davidson County, TN US 2020-03-08T18:03:06 1 0 0 36.1343 -86.822
225 Okaloosa County, FL US 2020-03-08T03:03:08 1 0 0 30.5773 -86.6611
211 Hendricks County, IN US 2020-03-08T19:33:03 1 0 0 39.8065 -86.5401
223 Marion County, IN US 2020-03-06T17:13:12 1 0 0 39.8362 -86.1752
227 Polk County, GA US 2020-03-08T04:13:22 1 0 0 34.0132 -85.1479
199 Cobb County, GA US 2020-03-07T16:53:03 1 0 0 33.8999 -84.5641
207 Fayette County, KY US 2020-03-06T23:23:03 1 0 0 38.0606 -84.4803
145 Fulton County, GA US 2020-03-07T16:53:03 3 0 0 33.8034 -84.3963
116   Costa Rica 2020-03-08T05:13:07 5 0 0 9.7489 -83.7534
232 Sarasota, FL US 2020-03-02T03:23:06 1 0 0 27.3364 -82.5307
222 Manatee County, FL US 2020-03-08T06:23:05 1 0 0 27.4799 -82.3452
163 Hillsborough, FL US 2020-03-03T18:33:02 2 0 0 27.9904 -82.3018
165 Lee County, FL US 2020-03-08T15:33:04 2 1 0 26.663 -81.9535
180 London, ON Canada 2020-02-12T18:53:03 1 0 1 42.9849 -81.2453
243 Volusia County, FL US 2020-03-08T03:03:08 1 0 0 29.028 -81.0755
217 Kershaw County, SC US 2020-03-07T02:03:30 1 0 0 34.3672 -80.5883
159 Broward County, FL US 2020-03-07T04:43:02 2 0 0 26.1901 -80.3659
196 Charleston County, SC US 2020-03-07T01:53:03 1 0 0 32.7957 -79.7848
71 Toronto, ON Canada 2020-03-08T21:33:02 28 0 3 43.6532 -79.3832
197 Chatham County, NC US 2020-03-06T16:13:15 1 0 0 35.7211 -79.1781
244 Wake County, NC US 2020-03-03T20:53:02 1 0 0 35.8032 -78.5661
87   Ecuador 2020-03-08T05:23:03 14 0 0 -1.8312 -78.1834
131 Montgomery County, MD US 2020-03-08T21:53:04 4 0 0 39.1547 -77.2405
162 Fairfax County, VA US 2020-03-08T21:33:02 2 0 0 38.9085 -77.2405
174 Washington, D.C. US 2020-03-08T13:53:03 2 0 0 38.9072 -77.0369
210 Harford County, MD US 2020-03-08T21:53:03 1 0 0 39.5839 -76.3637
132 Montgomery County, PA US 2020-03-08T21:43:03 4 0 0 40.229 -75.3879
202 Delaware County, PA US 2020-03-06T15:33:03 1 0 0 39.9078 -75.3879
245 Wayne County, PA US 2020-03-06T16:13:15 1 0 0 41.6739 -75.2479
113   Peru 2020-03-08T05:23:03 6 0 0 -9.19 -75.0152
239 Ulster County, NY US 2020-03-08T16:23:07 1 0 0 41.8586 -74.3118
181   Colombia 2020-03-07T00:43:02 1 0 0 4.5709 -74.2973
129 Bergen County, NJ US 2020-03-08T21:23:03 4 0 0 40.9263 -74.077
213 Hudson County, NJ US 2020-03-08T19:43:03 1 0 0 40.7453 -74.0535
93 New York County, NY US 2020-03-08T04:13:22 12 0 0 40.7128 -74.006
168 Rockland County, NY US 2020-03-07T16:43:02 2 0 0 41.1489 -73.983

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