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

199 rows

View and edit SQL

Link rowid ▼ Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
101 Placer County, CA US 2020-03-06T23:13:07 5 1 0 39.0916 -120.8039
102 Unassigned Location, WA US 2020-03-06T00:33:03 5 0 0 47.7511 -120.7401
103   Chile 2020-03-05T18:13:04 4 0 0 -35.6751 -71.543
104   Georgia 2020-03-05T13:53:03 4 0 0 42.3154 43.3569
105   Indonesia 2020-03-06T12:33:03 4 0 0 -0.7893 113.9213
106   New Zealand 2020-03-06T01:29:39 4 0 0 -40.9006 174.886
107   Senegal 2020-03-04T20:43:02 4 0 0 14.4974 -14.4524
108 Western Australia Australia 2020-03-05T17:13:35 3 1 0 -31.9505 115.8605
109   North Macedonia 2020-03-06T20:23:11 3 0 0 41.6086 21.7453
110   Saint Barthelemy 2020-03-04T02:43:03 3 0 0 17.9 -62.8333
111 Contra Costa County, CA US 2020-03-06T19:43:02 3 0 0 37.8534 -121.9018
112 Harris County, TX US 2020-03-06T15:43:02 3 0 0 29.7752 -95.3103
113 Montgomery County, MD US 2020-03-06T04:03:17 3 0 0 39.1547 -77.2405
114 Orange County, CA US 2020-03-04T02:13:11 3 0 0 33.7879 -117.8531
115 San Diego County, CA US 2020-03-05T20:33:03 3 0 1 32.7157 -117.1611
116 Suffolk County, MA US 2020-03-06T18:33:03 3 0 1 42.3601 -71.0589
117   Argentina 2020-03-06T01:29:39 2 0 0 -38.4161 -63.6167
118   Bosnia and Herzegovina 2020-03-05T17:13:30 2 0 0 43.9159 17.6791
119 Montreal, QC Canada 2020-03-05T14:03:04 2 0 0 45.5017 -73.5673
120   Dominican Republic 2020-03-06T15:33:03 2 0 0 18.7357 -70.1627
121   Hungary 2020-03-05T17:13:27 2 0 0 47.1625 19.5033
122   Luxembourg 2020-03-06T01:29:39 2 0 0 49.8144 6.1317
123   Morocco 2020-03-05T13:53:03 2 0 0 31.7917 -7.0926
124 Norfolk County, MA US 2020-03-06T18:33:03 2 0 0 42.1767 -71.1449
125 Bergen County, NJ US 2020-03-05T21:03:12 2 0 0 40.9263 -74.077
126 Denver County, CO US 2020-03-06T23:33:02 2 0 0 39.7392 -104.9903
127 Fulton County, GA US 2020-03-03T03:33:02 2 0 0 33.8034 -84.3963
128 Grafton County, NH US 2020-03-03T23:33:03 2 0 0 43.9088 -71.826
129 Hillsborough, FL US 2020-03-03T18:33:02 2 0 0 27.9904 -82.3018
130 Maricopa County, AZ US 2020-03-06T18:33:03 2 0 0 33.2918 -112.4291
131 Providence, RI US 2020-03-02T03:43:02 2 0 0 41.824 -71.4128
132 Sacramento County, CA US 2020-02-27T20:33:02 2 0 0 38.4747 -121.3542
133 San Benito, CA US 2020-02-03T03:53:02 2 0 0 36.5761 -120.9876
134 San Francisco County, CA US 2020-03-05T20:33:03 2 0 0 37.7749 -122.4194
135 San Mateo, CA US 2020-03-03T00:43:02 2 0 0 37.563 -122.3255
136 Summit County, CO US 2020-03-06T01:29:39 2 0 0 39.5912 -106.064
137 Washington County, OR US 2020-03-03T03:03:02 2 0 0 45.547 -123.1386
138   Afghanistan 2020-02-24T23:33:02 4 0 0 33.0 65.0
139   Andorra 2020-03-02T20:23:16 1 0 0 42.5063 1.5218
140   Armenia 2020-03-01T19:53:02 1 0 0 40.0691 45.0382
141 Tasmania Australia 2020-03-02T20:53:02 1 0 0 -41.4545 145.9707
142   Bhutan 2020-03-06T15:43:02 1 0 0 27.5142 90.4336
143   Cambodia 2020-02-12T07:43:02 1 0 1 11.55 104.9167
144   Cameroon 2020-03-06T15:43:02 1 0 0 3.848 11.5021
145 Calgary, Alberta Canada 2020-03-06T13:13:34 1 0 0 51.0447 -114.0719
146 London, ON Canada 2020-02-12T18:53:03 1 0 1 42.9849 -81.2453
147   Colombia 2020-03-06T20:43:03 1 0 0 4.5709 -74.2973
148   Costa Rica 2020-03-06T01:29:39 1 0 0 9.7489 -83.7534
149   Faroe Islands 2020-03-04T12:53:03 1 0 0 61.8926 -6.9118
150   Gibraltar 2020-03-04T13:03:13 1 0 0 36.1408 -5.3536
151   Jordan 2020-03-03T15:33:02 1 0 0 31.24 36.51
152   Latvia 2020-03-04T01:33:07 1 0 0 56.8796 24.6032
153   Liechtenstein 2020-03-04T01:33:07 1 0 0 47.14 9.55
154   Lithuania 2020-02-28T16:23:03 1 0 0 55.1694 23.8813
155 Tibet Mainland China 2020-02-12T06:43:02 1 0 1 31.6927 88.0924
156   Monaco 2020-02-29T00:33:01 1 0 0 43.7333 7.4167
157   Nepal 2020-02-12T14:43:03 1 0 1 28.1667 84.25
158   Nigeria 2020-02-28T16:23:03 1 0 0 9.082 8.6753
159   Peru 2020-03-06T15:43:02 1 0 0 -9.19 -75.0152
160   Serbia 2020-03-06T15:43:02 1 0 0 44.0165 21.0059
161   Slovakia 2020-03-06T13:03:14 1 0 0 48.669 19.699
162   South Africa 2020-03-06T15:43:02 1 0 0 -30.5595 22.9375
163   Sri Lanka 2020-02-08T03:43:03 1 0 1 7.0 81.0
164   Togo 2020-03-06T15:33:03 1 0 0 8.6195 0.8248
165   Tunisia 2020-03-04T01:33:07 1 0 0 34.0 9.0
166 Berkeley, CA US 2020-03-03T23:53:03 1 0 0 37.8715 -122.273
167 Chatham County, NC US 2020-03-06T16:13:15 1 0 0 35.7211 -79.1781
168 Clark County, NV US 2020-03-05T20:53:03 1 0 0 36.0796 -115.094
169 Delaware County, PA US 2020-03-06T15:33:03 1 0 0 39.9078 -75.3879
170 Douglas County, NE US 2020-03-06T23:33:02 1 0 0 41.3148 -96.1951
171 Fayette County, KY US 2020-03-06T23:23:03 1 0 0 38.0606 -84.4803
172 Floyd County, GA US 2020-03-06T17:53:03 1 0 0 34.2829 -85.2308
173 Fort Bend County, TX US 2020-03-05T01:16:59 1 0 0 29.5693 -95.8143
174 Grant County, WA US 2020-03-05T20:23:07 1 0 0 47.1981 -119.3732
175 Humboldt County, CA US 2020-02-21T05:13:09 1 0 0 40.745 -123.8695
176 Madison, WI US 2020-03-03T15:53:03 1 0 1 43.0731 -89.4012
177 Marion County, IN US 2020-03-06T17:13:12 1 0 0 39.8362 -86.1752
178 Middlesex County, MA US 2020-03-06T01:29:39 1 0 0 42.4672 -71.2874
179 Nassau County, NY US 2020-03-06T14:43:15 1 0 0 40.6546 -73.5594
180 Norwell County, MA US 2020-03-06T02:33:03 1 0 0 42.1615 -70.7928
181 Ramsey County, MN US 2020-03-06T23:23:03 1 0 0 44.9964 -93.0616
182 San Antonio, TX US 2020-02-13T18:53:02 1 0 0 29.4241 -98.4936
183 Santa Rosa County, FL US 2020-03-05T20:03:03 1 0 0 30.769 -86.9824
184 Sarasota, FL US 2020-03-02T03:23:06 1 0 0 27.3364 -82.5307
185 Sonoma County, CA US 2020-03-02T20:53:02 1 0 0 38.578 -122.9888
186 Tempe, AZ US 2020-02-25T21:23:03 1 0 1 33.4255 -111.94
187 Umatilla, OR US 2020-03-02T20:23:16 1 0 0 45.775 -118.7606
188 Wake County, NC US 2020-03-03T20:53:02 1 0 0 35.8032 -78.5661
189 Washoe County, NV US 2020-03-06T19:43:02 1 0 0 40.5608 -119.6035
190 Wayne County, PA US 2020-03-06T16:13:15 1 0 0 41.6739 -75.2479
191 Williamson County, TN US 2020-03-05T23:33:03 1 0 0 35.9179 -86.8622
192 Yolo County, CA US 2020-03-06T20:13:14 1 0 0 38.7646 -121.9018
193   Ukraine 2020-03-03T15:33:02 1 0 0 48.3794 31.1656
194   Vatican City 2020-03-06T15:43:02 1 0 0 41.9029 12.4534
195 From Diamond Princess Australia 2020-02-29T02:03:10 0 0 0 35.4437 139.638
196 Northern Territory Australia 2020-03-06T04:33:03 0 0 0 -12.4634 130.8456
197 Lackland, TX (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 29.3829 -98.6134
198 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 41.2545 -95.9758
199 Travis, CA (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 38.2721 -121.9399

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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