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

3,179 rows sorted by Deaths

✎ 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
215 215 48035 Bosque Texas US 2020-05-01 02:32:28 31.89978581 -97.63613524 4 0 0 4 Bosque, Texas, US
219 219 16021 Boundary Idaho US 2020-05-01 02:32:28 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
223 223 38011 Bowman North Dakota US 2020-05-01 02:32:28 46.11285362 -103.5203343 1 0 0 1 Bowman, North Dakota, US
224 224 31013 Box Butte Nebraska US 2020-05-01 02:32:28 42.22079243 -103.08788340000001 1 0 0 1 Box Butte, Nebraska, US
226 226 21021 Boyle Kentucky US 2020-05-01 02:32:28 37.62680923 -84.8633779 17 0 0 17 Boyle, Kentucky, US
227 227 21023 Bracken Kentucky US 2020-05-01 02:32:28 38.69158994 -84.08532444 7 0 0 7 Bracken, Kentucky, US
234 234 54007 Braxton West Virginia US 2020-05-01 02:32:28 38.70036159 -80.72011184 2 0 0 2 Braxton, West Virginia, US
237 237 21025 Breathitt Kentucky US 2020-05-01 02:32:28 37.52333168 -83.31959161 2 0 0 2 Breathitt, Kentucky, US
238 238 21027 Breckinridge Kentucky US 2020-05-01 02:32:28 37.77377239 -86.42885017 9 0 0 9 Breckinridge, Kentucky, US
242 242 44001 Bristol Rhode Island US 2020-05-01 02:32:28 41.71018079 -71.28652315 143 0 0 143 Bristol, Rhode Island, US
243 243 51520 Bristol Virginia US 2020-05-01 02:32:28 36.616302399999995 -82.16359122 1 0 0 1 Bristol, Virginia, US
244 244 30007 Broadwater Montana US 2020-05-01 02:32:28 46.33277565 -111.49558130000001 4 0 0 4 Broadwater, Montana, US
245 245 54009 Brooke West Virginia US 2020-05-01 02:32:28 40.27367263 -80.57915332 3 0 0 3 Brooke, West Virginia, US
246 246 46011 Brookings South Dakota US 2020-05-01 02:32:28 44.36974375 -96.79079945 13 0 0 13 Brookings, South Dakota, US
248 248 48047 Brooks Texas US 2020-05-01 02:32:28 27.03103197 -98.21808402 1 0 0 1 Brooks, Texas, US
255 255 46013 Brown South Dakota US 2020-05-01 02:32:28 45.58994323 -98.35165355 39 0 0 39 Brown, South Dakota, US
258 258 46015 Brule South Dakota US 2020-05-01 02:32:28 43.71756379 -99.08118954 0 0 0 0 Brule, South Dakota, US
260 260 51025 Brunswick Virginia US 2020-05-01 02:32:28 36.76366949 -77.8593436 14 0 0 14 Brunswick, Virginia, US
263 263 19019 Buchanan Iowa US 2020-05-01 02:32:28 42.4709188 -91.83510825 17 0 0 17 Buchanan, Iowa, US
265 265 51027 Buchanan Virginia US 2020-05-01 02:32:28 37.26818323 -82.03749726 16 0 0 16 Buchanan, Virginia, US
266 266 51029 Buckingham Virginia US 2020-05-01 02:32:28 37.57242268 -78.52518834 58 0 0 58 Buckingham, Virginia, US
268 268 19021 Buena Vista Iowa US 2020-05-01 02:32:28 42.73545875 -95.15100162 4 0 0 4 Buena Vista, Iowa, US
269 269 51530 Buena Vista Virginia US 2020-05-01 02:32:28 37.73484642 -79.35296097 6 0 0 6 Buena Vista, Virginia, US
271 271 46017 Buffalo South Dakota US 2020-05-01 02:32:28 44.07657829 -99.20814467 1 0 0 1 Buffalo, South Dakota, US
275 275 1011 Bullock Alabama US 2020-05-01 02:32:28 32.10030533 -85.71265535 13 0 0 13 Bullock, Alabama, US
277 277 17011 Bureau Illinois US 2020-05-01 02:32:28 41.40385234 -89.5283051 10 0 0 10 Bureau, Illinois, US
280 280 38013 Burke North Dakota US 2020-05-01 02:32:28 48.79094471 -102.51821170000001 3 0 0 3 Burke, North Dakota, US
281 281 38015 Burleigh North Dakota US 2020-05-01 02:32:28 46.97847375 -100.46452140000001 77 0 0 77 Burleigh, North Dakota, US
282 282 48051 Burleson Texas US 2020-05-01 02:32:28 30.49273808 -96.62158484 12 0 0 12 Burleson, Texas, US
284 284 48053 Burnet Texas US 2020-05-01 02:32:28 30.78801353 -98.181887 19 0 0 19 Burnet, Texas, US
285 285 31021 Burt Nebraska US 2020-05-01 02:32:28 41.85056773 -96.32605633 3 0 0 3 Burt, Nebraska, US
287 287 19023 Butler Iowa US 2020-05-01 02:32:28 42.73172833 -92.79015971 9 0 0 9 Butler, Iowa, US
288 288 20015 Butler Kansas US 2020-05-01 02:32:28 37.78134351 -96.83878537 16 0 0 16 Butler, Kansas, US
290 290 29023 Butler Missouri US 2020-05-01 02:32:28 36.71462476 -90.40421163 26 0 0 26 Butler, Missouri, US
291 291 31023 Butler Nebraska US 2020-05-01 02:32:28 41.22703692 -97.13106306 4 0 0 4 Butler, Nebraska, US
294 294 6007 Butte California US 2020-05-01 02:32:28 39.66727762 -121.6005252 16 0 0 16 Butte, California, US
295 295 46019 Butte South Dakota US 2020-05-01 02:32:28 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
298 298 54011 Cabell West Virginia US 2020-05-01 02:32:28 38.42424062 -82.23855912 42 0 0 42 Cabell, West Virginia, US
301 301 6009 Calaveras California US 2020-05-01 02:32:28 38.20537103 -120.55291299999999 13 0 0 13 Calaveras, California, US
303 303 21033 Caldwell Kentucky US 2020-05-01 02:32:28 37.14749129 -87.86948214 13 0 0 13 Caldwell, Kentucky, US
304 304 22021 Caldwell Louisiana US 2020-05-01 02:32:28 32.0902519 -92.11752148 18 0 0 18 Caldwell, Louisiana, US
305 305 29025 Caldwell Missouri US 2020-05-01 02:32:28 39.65620858 -93.98308093 3 0 0 3 Caldwell, Missouri, US
306 306 37027 Caldwell North Carolina US 2020-05-01 02:32:28 35.95204977 -81.54799522 34 0 0 34 Caldwell, North Carolina, US
307 307 48055 Caldwell Texas US 2020-05-01 02:32:28 29.83668859 -97.61814775 14 0 0 14 Caldwell, Texas, US
308 308 50005 Caledonia Vermont US 2020-05-01 02:32:28 44.46548598 -72.10314651 13 0 0 13 Caledonia, Vermont, US
310 310 12013 Calhoun Florida US 2020-05-01 02:32:28 30.40666734 -85.19394153 8 0 0 8 Calhoun, Florida, US
312 312 17013 Calhoun Illinois US 2020-05-01 02:32:28 39.16840183 -90.66330078 1 0 0 1 Calhoun, Illinois, US
317 317 48059 Callahan Texas US 2020-05-01 02:32:28 32.29760619 -99.37326312 2 0 0 2 Callahan, Texas, US
320 320 55015 Calumet Wisconsin US 2020-05-01 02:32:28 44.0816316 -88.21780273 13 0 0 13 Calumet, Wisconsin, US
322 322 16025 Camas Idaho US 2020-05-01 02:32:28 43.46665742 -114.8065892 1 0 0 1 Camas, Idaho, US
327 327 37029 Camden North Carolina US 2020-05-01 02:32:28 36.33804939 -76.15568396 1 0 0 1 Camden, North Carolina, US
328 328 22023 Cameron Louisiana US 2020-05-01 02:32:28 29.87592238 -93.19310676 3 0 0 3 Cameron, Louisiana, US
329 329 42023 Cameron Pennsylvania US 2020-05-01 02:32:28 41.43625568 -78.20376845 1 0 0 1 Cameron, Pennsylvania, US
331 331 48063 Camp Texas US 2020-05-01 02:32:28 32.97195142 -94.97790104 6 0 0 6 Camp, Texas, US
334 334 51031 Campbell Virginia US 2020-05-01 02:32:28 37.20553386 -79.09678609 12 0 0 12 Campbell, Virginia, US
335 335 56005 Campbell Wyoming US 2020-05-01 02:32:28 44.24886082 -105.54744040000001 24 0 0 24 Campbell, Wyoming, US
337 337 13043 Candler Georgia US 2020-05-01 02:32:28 32.40209349 -82.07702563 7 0 0 7 Candler, Georgia, US
338 338 47015 Cannon Tennessee US 2020-05-01 02:32:28 35.80990797 -86.05738983 12 0 0 12 Cannon, Tennessee, US
342 342 30009 Carbon Montana US 2020-05-01 02:32:28 45.22850116 -109.0274047 6 0 0 6 Carbon, Montana, US
344 344 56007 Carbon Wyoming US 2020-05-01 02:32:28 41.69357844 -106.9326084 4 0 0 4 Carbon, Wyoming, US
345 345 16029 Caribou Idaho US 2020-05-01 02:32:28 42.77149116 -111.5597683 1 0 0 1 Caribou, Idaho, US
346 346 21039 Carlisle Kentucky US 2020-05-01 02:32:28 36.85372876 -88.96692220000001 2 0 0 2 Carlisle, Kentucky, US
347 347 27017 Carlton Minnesota US 2020-05-01 02:32:28 46.59180601 -92.67601019 59 0 0 59 Carlton, Minnesota, US
348 348 24011 Caroline Maryland US 2020-05-01 02:32:28 38.87172293 -75.82904158 71 0 0 71 Caroline, Maryland, US
350 350 5015 Carroll Arkansas US 2020-05-01 02:32:28 36.34038560000001 -93.54270261 5 0 0 5 Carroll, Arkansas, US
354 354 19027 Carroll Iowa US 2020-05-01 02:32:28 42.03617207 -94.86032705 2 0 0 2 Carroll, Iowa, US
355 355 21041 Carroll Kentucky US 2020-05-01 02:32:28 38.66599534 -85.12601074 2 0 0 2 Carroll, Kentucky, US
358 358 29033 Carroll Missouri US 2020-05-01 02:32:28 39.42762566 -93.50626255 3 0 0 3 Carroll, Missouri, US
359 359 33003 Carroll New Hampshire US 2020-05-01 02:32:28 43.87498583 -71.20430216 31 0 0 31 Carroll, New Hampshire, US
362 362 51035 Carroll Virginia US 2020-05-01 02:32:28 36.73066666 -80.73455942 11 0 0 11 Carroll, Virginia, US
363 363 48065 Carson Texas US 2020-05-01 02:32:28 35.40365929 -101.35426690000001 2 0 0 2 Carson, Texas, US
365 365 21043 Carter Kentucky US 2020-05-01 02:32:28 38.31690743 -83.05092385 5 0 0 5 Carter, Kentucky, US
370 370 27019 Carver Minnesota US 2020-05-01 02:32:28 44.82017001 -93.80099179999999 21 0 0 21 Carver, Minnesota, US
372 372 21045 Casey Kentucky US 2020-05-01 02:32:28 37.32533118 -84.92726209 1 0 0 1 Casey, Kentucky, US
373 373 17017 Cass Illinois US 2020-05-01 02:32:28 39.96991073 -90.24734436 33 0 0 33 Cass, Illinois, US
375 375 19029 Cass Iowa US 2020-05-01 02:32:28 41.33149454 -94.92792482 1 0 0 1 Cass, Iowa, US
377 377 27021 Cass Minnesota US 2020-05-01 02:32:28 46.95043611 -94.32603968 5 0 0 5 Cass, Minnesota, US
379 379 31025 Cass Nebraska US 2020-05-01 02:32:28 40.90899107 -96.13971217 5 0 0 5 Cass, Nebraska, US
381 381 48067 Cass Texas US 2020-05-01 02:32:28 33.07499881 -94.34646905 13 0 0 13 Cass, Texas, US
384 384 37033 Caswell North Carolina US 2020-05-01 02:32:28 36.39312665 -79.33353281 22 0 0 22 Caswell, North Carolina, US
387 387 13047 Catoosa Georgia US 2020-05-01 02:32:28 34.89872298 -85.13757014 47 0 0 47 Catoosa, Georgia, US
389 389 36009 Cattaraugus New York US 2020-05-01 02:32:28 42.24778241 -78.67923096 47 0 0 47 Cattaraugus, New York, US
392 392 19031 Cedar Iowa US 2020-05-01 02:32:28 41.77233777 -91.13246684 29 0 0 29 Cedar, Iowa, US
393 393 29039 Cedar Missouri US 2020-05-01 02:32:28 37.72391475 -93.85445441 5 0 0 5 Cedar, Missouri, US
394 394 31027 Cedar Nebraska US 2020-05-01 02:32:28 42.598885100000004 -97.25311951 4 0 0 4 Cedar, Nebraska, US
395 395   Central Utah Utah US 2020-05-01 02:32:28 39.37231946 -111.5758676 23 0 0 23 Central Utah, Utah, US
397 397 19033 Cerro Gordo Iowa US 2020-05-01 02:32:28 43.08177563 -93.2612239 14 0 0 14 Cerro Gordo, Iowa, US
400 400 48071 Chambers Texas US 2020-05-01 02:32:28 29.70972016 -94.67154501 41 0 0 41 Chambers, Texas, US
403 403 29041 Chariton Missouri US 2020-05-01 02:32:28 39.51499357 -92.9629191 5 0 0 5 Chariton, Missouri, US
406 406 46023 Charles Mix South Dakota US 2020-05-01 02:32:28 43.20660134 -98.58856175 5 0 0 5 Charles Mix, South Dakota, US
410 410 51037 Charlotte Virginia US 2020-05-01 02:32:28 37.01909701 -78.66314092 7 0 0 7 Charlotte, Virginia, US
412 412 13049 Charlton Georgia US 2020-05-01 02:32:28 30.78371028 -82.13951596 8 0 0 8 Charlton, Georgia, US
413 413 20017 Chase Kansas US 2020-05-01 02:32:28 38.30292938 -96.59563862 3 0 0 3 Chase, Kansas, US
416 416 13053 Chattahoochee Georgia US 2020-05-01 02:32:28 32.34341231 -84.78809239 12 0 0 12 Chattahoochee, Georgia, US
418 418 20019 Chautauqua Kansas US 2020-05-01 02:32:28 37.14994405 -96.2454192 4 0 0 4 Chautauqua, Kansas, US
421 421 47021 Cheatham Tennessee US 2020-05-01 02:32:28 36.26136216 -87.08903581 46 0 0 46 Cheatham, Tennessee, US
425 425 36017 Chenango New York US 2020-05-01 02:32:28 42.49430041 -75.60887553 98 0 0 98 Chenango, New York, US
426 426 1019 Cherokee Alabama US 2020-05-01 02:32:28 34.17805983 -85.60638968 16 0 0 15 Cherokee, Alabama, US
428 428 19035 Cherokee Iowa US 2020-05-01 02:32:28 42.73538914 -95.62389402 2 0 0 2 Cherokee, Iowa, US
429 429 20021 Cherokee Kansas US 2020-05-01 02:32:28 37.16928494 -94.8462897 8 0 0 8 Cherokee, Kansas, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-30-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
);