04-02-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

2,572 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
201 201 44001 Bristol Rhode Island US 4/2/20 23:25 41.71018079 -71.28652315 21 0 0 0 Bristol, Rhode Island, US
202 202 51520 Bristol Virginia US 4/2/20 23:25 36.6163024 -82.16359122 1 0 0 0 Bristol, Virginia, US
203 203 30007 Broadwater Montana US 4/2/20 23:25 46.33277565 -111.4955813 3 0 0 0 Broadwater, Montana, US
204 204 46011 Brookings South Dakota US 4/2/20 23:25 44.36974375 -96.79079945 2 0 0 0 Brookings, South Dakota, US
205 205 13027 Brooks Georgia US 4/2/20 23:25 30.83922642 -83.58303423 3 0 0 0 Brooks, Georgia, US
206 206 36007 Broome New York US 4/2/20 23:25 42.15903158 -75.81326086 46 4 0 0 Broome, New York, US
207 207 8014 Broomfield Colorado US 4/2/20 23:25 39.95998787 -105.0566324 21 2 0 0 Broomfield, Colorado, US
208 208 12011 Broward Florida US 4/2/20 23:25 26.15184651 -80.48725556 1481 17 0 0 Broward, Florida, US
209 209 18013 Brown Indiana US 4/2/20 23:25 39.19605589 -86.22868909 3 0 0 0 Brown, Indiana, US
210 210 27015 Brown Minnesota US 4/2/20 23:25 44.24205652 -94.72562874 2 0 0 0 Brown, Minnesota, US
211 211 39015 Brown Ohio US 4/2/20 23:25 38.93416837 -83.86788395 2 1 0 0 Brown, Ohio, US
212 212 46013 Brown South Dakota US 4/2/20 23:25 45.58994323 -98.35165355 6 0 0 0 Brown, South Dakota, US
213 213 48049 Brown Texas US 4/2/20 23:25 31.77430356 -98.99907113 3 0 0 0 Brown, Texas, US
214 214 55009 Brown Wisconsin US 4/2/20 23:25 44.4526553 -88.00411844 17 0 0 0 Brown, Wisconsin, US
215 215 37019 Brunswick North Carolina US 4/2/20 23:25 34.070565 -78.22814204 23 0 0 0 Brunswick, North Carolina, US
216 216 51025 Brunswick Virginia US 4/2/20 23:25 36.76366949 -77.8593436 1 0 0 0 Brunswick, Virginia, US
217 217 13029 Bryan Georgia US 4/2/20 23:25 32.00979311 -81.44002948 10 1 0 0 Bryan, Georgia, US
218 218 40013 Bryan Oklahoma US 4/2/20 23:25 33.96472458 -96.25903472 2 0 0 0 Bryan, Oklahoma, US
219 219 19019 Buchanan Iowa US 4/2/20 23:25 42.4709188 -91.83510825 3 0 0 0 Buchanan, Iowa, US
220 220 29021 Buchanan Missouri US 4/2/20 23:25 39.65816401 -94.80138942 5 0 0 0 Buchanan, Missouri, US
221 221 51029 Buckingham Virginia US 4/2/20 23:25 37.57242268 -78.52518834 2 0 0 0 Buckingham, Virginia, US
222 222 42017 Bucks Pennsylvania US 4/2/20 23:25 40.33682119 -75.10836643 373 6 0 0 Bucks, Pennsylvania, US
223 223 31019 Buffalo Nebraska US 4/2/20 23:25 40.85486962 -99.07500296 8 1 0 0 Buffalo, Nebraska, US
224 224 55011 Buffalo Wisconsin US 4/2/20 23:25 44.37835084 -91.75332578 2 0 0 0 Buffalo, Wisconsin, US
225 225 21029 Bullitt Kentucky US 4/2/20 23:25 37.97162523 -85.68955617 6 1 0 0 Bullitt, Kentucky, US
226 226 13031 Bulloch Georgia US 4/2/20 23:25 32.39577406 -81.74811421 3 0 0 0 Bulloch, Georgia, US
227 227 1011 Bullock Alabama US 4/2/20 23:25 32.10030533 -85.71265535 2 0 0 0 Bullock, Alabama, US
228 228 37021 Buncombe North Carolina US 4/2/20 23:25 35.61113393 -82.53305 22 1 0 0 Buncombe, North Carolina, US
229 229 17011 Bureau Illinois US 4/2/20 23:25 41.40385234 -89.5283051 2 0 0 0 Bureau, Illinois, US
230 230 13033 Burke Georgia US 4/2/20 23:25 33.05917989 -81.99928721 8 0 0 0 Burke, Georgia, US
231 231 37023 Burke North Carolina US 4/2/20 23:25 35.74989637 -81.70755735 9 0 0 0 Burke, North Carolina, US
232 232 38013 Burke North Dakota US 4/2/20 23:25 48.79094471 -102.5182117 2 0 0 0 Burke, North Dakota, US
233 233 38015 Burleigh North Dakota US 4/2/20 23:25 46.97847375 -100.4645214 32 0 0 0 Burleigh, North Dakota, US
234 234 48051 Burleson Texas US 4/2/20 23:25 30.49273808 -96.62158484 1 0 0 0 Burleson, Texas, US
235 235 34005 Burlington New Jersey US 4/2/20 23:25 39.87681124 -74.66927768 294 8 0 0 Burlington, New Jersey, US
236 236 48053 Burnet Texas US 4/2/20 23:25 30.78801353 -98.181887 4 0 0 0 Burnet, Texas, US
237 237 1013 Butler Alabama US 4/2/20 23:25 31.75300095 -86.68057478 1 0 0 0 Butler, Alabama, US
238 238 19023 Butler Iowa US 4/2/20 23:25 42.73172833 -92.79015971 1 0 0 0 Butler, Iowa, US
239 239 20015 Butler Kansas US 4/2/20 23:25 37.78134351 -96.83878537 7 0 0 0 Butler, Kansas, US
240 240 21031 Butler Kentucky US 4/2/20 23:25 37.20946153 -86.68748787 1 0 0 0 Butler, Kentucky, US
241 241 29023 Butler Missouri US 4/2/20 23:25 36.71462476 -90.40421163 1 0 0 0 Butler, Missouri, US
242 242 39017 Butler Ohio US 4/2/20 23:25 39.44012838 -84.57388716 45 1 0 0 Butler, Ohio, US
243 243 42019 Butler Pennsylvania US 4/2/20 23:25 40.91152759 -79.91351055 69 2 0 0 Butler, Pennsylvania, US
244 244 6007 Butte California US 4/2/20 23:25 39.66727762 -121.6005252 9 0 0 0 Butte, California, US
245 245 46019 Butte South Dakota US 4/2/20 23:25 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
246 246 13035 Butts Georgia US 4/2/20 23:25 33.2830945 -83.9543504 9 0 0 0 Butts, Georgia, US
247 247 37025 Cabarrus North Carolina US 4/2/20 23:25 35.3877799 -80.55267168 50 1 0 0 Cabarrus, North Carolina, US
248 248 54011 Cabell West Virginia US 4/2/20 23:25 38.42424062 -82.23855912 3 0 0 0 Cabell, West Virginia, US
249 249 49005 Cache Utah US 4/2/20 23:25 41.72330587 -111.7443667 7 0 0 0 Cache, Utah, US
250 250 22017 Caddo Louisiana US 4/2/20 23:25 32.57991587 -93.88375652 336 10 0 0 Caddo, Louisiana, US
251 251 40015 Caddo Oklahoma US 4/2/20 23:25 35.17364557 -98.37534464 2 0 0 0 Caddo, Oklahoma, US
252 252 6009 Calaveras California US 4/2/20 23:25 38.20537103 -120.552913 3 0 0 0 Calaveras, California, US
253 253 22019 Calcasieu Louisiana US 4/2/20 23:25 30.22931235 -93.35400434 108 1 0 0 Calcasieu, Louisiana, US
254 254 29025 Caldwell Missouri US 4/2/20 23:25 39.65620858 -93.98308093 1 0 0 0 Caldwell, Missouri, US
255 255 37027 Caldwell North Carolina US 4/2/20 23:25 35.95204977 -81.54799522 3 0 0 0 Caldwell, North Carolina, US
256 256 48055 Caldwell Texas US 4/2/20 23:25 29.83668859 -97.61814775 1 0 0 0 Caldwell, Texas, US
257 257 50005 Caledonia Vermont US 4/2/20 23:25 44.46548598 -72.10314651 4 0 0 0 Caledonia, Vermont, US
258 258 1015 Calhoun Alabama US 4/2/20 23:25 33.77483727 -85.82630386 12 0 0 0 Calhoun, Alabama, US
259 259 12013 Calhoun Florida US 4/2/20 23:25 30.40666734 -85.19394153 1 0 0 0 Calhoun, Florida, US
260 260 13037 Calhoun Georgia US 4/2/20 23:25 31.53169785 -84.62725131 10 1 0 0 Calhoun, Georgia, US
261 261 26025 Calhoun Michigan US 4/2/20 23:25 42.24633834 -85.00493569 25 0 0 0 Calhoun, Michigan, US
262 262 28013 Calhoun Mississippi US 4/2/20 23:25 33.93683395 -89.33686647 4 1 0 0 Calhoun, Mississippi, US
263 263 45017 Calhoun South Carolina US 4/2/20 23:25 33.66926881 -80.77722168 3 1 0 0 Calhoun, South Carolina, US
264 264 48057 Calhoun Texas US 4/2/20 23:25 28.47048236 -96.61633945 8 0 0 0 Calhoun, Texas, US
265 265 29027 Callaway Missouri US 4/2/20 23:25 38.83674754 -91.92186505 18 0 0 0 Callaway, Missouri, US
266 266 21035 Calloway Kentucky US 4/2/20 23:25 36.62093411 -88.2731593 3 0 0 0 Calloway, Kentucky, US
267 267 55015 Calumet Wisconsin US 4/2/20 23:25 44.0816316 -88.21780273 3 0 0 0 Calumet, Wisconsin, US
268 268 24009 Calvert Maryland US 4/2/20 23:25 38.53961642 -76.56820632 22 1 0 0 Calvert, Maryland, US
269 269 16025 Camas Idaho US 4/2/20 23:25 43.46665742 -114.8065892 1 0 0 0 Camas, Idaho, US
270 270 42021 Cambria Pennsylvania US 4/2/20 23:25 40.49527404 -78.71377428 4 0 0 0 Cambria, Pennsylvania, US
271 271 13039 Camden Georgia US 4/2/20 23:25 30.92951916 -81.66601818 6 0 0 0 Camden, Georgia, US
272 272 29029 Camden Missouri US 4/2/20 23:25 38.02199522 -92.76083747 19 1 0 0 Camden, Missouri, US
273 273 34007 Camden New Jersey US 4/2/20 23:25 39.80343818 -74.96388753 343 6 0 0 Camden, New Jersey, US
274 274 42023 Cameron Pennsylvania US 4/2/20 23:25 41.43625568 -78.20376845 1 0 0 0 Cameron, Pennsylvania, US
275 275 48061 Cameron Texas US 4/2/20 23:25 26.14524221 -97.48140372 37 0 0 0 Cameron, Texas, US
276 276 48063 Camp Texas US 4/2/20 23:25 32.97195142 -94.97790104 1 0 0 0 Camp, Texas, US
277 277 21037 Campbell Kentucky US 4/2/20 23:25 38.94384345 -84.37875208 8 0 0 0 Campbell, Kentucky, US
278 278 47013 Campbell Tennessee US 4/2/20 23:25 36.40355516 -84.1510856 4 0 0 0 Campbell, Tennessee, US
279 279 51031 Campbell Virginia US 4/2/20 23:25 37.20553386 -79.09678609 2 0 0 0 Campbell, Virginia, US
280 280 56005 Campbell Wyoming US 4/2/20 23:25 44.24886082 -105.5474404 6 0 0 0 Campbell, Wyoming, US
281 281 40017 Canadian Oklahoma US 4/2/20 23:25 35.5426055 -97.98465569 28 1 0 0 Canadian, Oklahoma, US
282 282 13043 Candler Georgia US 4/2/20 23:25 32.40209349 -82.07702563 1 0 0 0 Candler, Georgia, US
283 283 47015 Cannon Tennessee US 4/2/20 23:25 35.80990797 -86.05738983 4 0 0 0 Cannon, Tennessee, US
284 284 16027 Canyon Idaho US 4/2/20 23:25 43.61970148 -116.7095499 68 1 0 0 Canyon, Idaho, US
285 285 29031 Cape Girardeau Missouri US 4/2/20 23:25 37.38489388 -89.6843587 15 0 0 0 Cape Girardeau, Missouri, US
286 286 34009 Cape May New Jersey US 4/2/20 23:25 39.15008829 -74.80170244 34 0 0 0 Cape May, New Jersey, US
287 287 30009 Carbon Montana US 4/2/20 23:25 45.22850116 -109.0274047 1 0 0 0 Carbon, Montana, US
288 288 42025 Carbon Pennsylvania US 4/2/20 23:25 40.91545395 -75.7068525 26 1 0 0 Carbon, Pennsylvania, US
289 289 56007 Carbon Wyoming US 4/2/20 23:25 41.69357844 -106.9326084 3 0 0 0 Carbon, Wyoming, US
290 290 27017 Carlton Minnesota US 4/2/20 23:25 46.59180601 -92.67601019 3 0 0 0 Carlton, Minnesota, US
291 291 24011 Caroline Maryland US 4/2/20 23:25 38.87172293 -75.82904158 4 0 0 0 Caroline, Maryland, US
292 292 5015 Carroll Arkansas US 4/2/20 23:25 36.3403856 -93.54270261 1 0 0 0 Carroll, Arkansas, US
293 293 13045 Carroll Georgia US 4/2/20 23:25 33.58138199 -85.07976677 133 2 0 0 Carroll, Georgia, US
294 294 17015 Carroll Illinois US 4/2/20 23:25 42.06823429 -89.93395545 4 1 0 0 Carroll, Illinois, US
295 295 18015 Carroll Indiana US 4/2/20 23:25 40.5807832 -86.56198812 2 0 0 0 Carroll, Indiana, US
296 296 19027 Carroll Iowa US 4/2/20 23:25 42.03617207 -94.86032705 1 0 0 0 Carroll, Iowa, US
297 297 21041 Carroll Kentucky US 4/2/20 23:25 38.66599534 -85.12601074 2 0 0 0 Carroll, Kentucky, US
298 298 24013 Carroll Maryland US 4/2/20 23:25 39.56453592 -77.02373735 105 4 0 0 Carroll, Maryland, US
299 299 28015 Carroll Mississippi US 4/2/20 23:25 33.44834567 -89.91994479 3 0 0 0 Carroll, Mississippi, US
300 300 33003 Carroll New Hampshire US 4/2/20 23:25 43.87498583 -71.20430216 14 0 0 0 Carroll, New Hampshire, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-02-2020] (
   [FIPS] INTEGER,
   [Admin2] TEXT,
   [Province_State] TEXT,
   [Country_Region] TEXT,
   [Last_Update] TEXT,
   [Lat] FLOAT,
   [Long_] FLOAT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER,
   [Active] INTEGER,
   [Combined_Key] TEXT
);