03-31-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,437 rows sorted by Confirmed

✎ 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
368 368 28021 Claiborne Mississippi US 2020-03-31 23:43:56 31.97061673 -90.90702196 1 0 0 0 Claiborne, Mississippi, US
371 371 26035 Clare Michigan US 2020-03-31 23:43:56 43.98794227 -84.84819859999998 1 0 0 0 Clare, Michigan, US
375 375 17023 Clark Illinois US 2020-03-31 23:43:56 39.33425789 -87.78705622 1 0 0 0 Clark, Illinois, US
380 380 46025 Clark South Dakota US 2020-03-31 23:43:56 44.85834507 -97.72925109 1 0 0 0 Clark, South Dakota, US
389 389 18021 Clay Indiana US 2020-03-31 23:43:56 39.39561833 -87.11723506 1 0 0 0 Clay, Indiana, US
390 390 20027 Clay Kansas US 2020-03-31 23:43:56 39.34948772 -97.16518128 1 0 0 0 Clay, Kansas, US
394 394 37043 Clay North Carolina US 2020-03-31 23:43:56 35.05704275 -83.74353633 1 0 0 0 Clay, North Carolina, US
397 397 19043 Clayton Iowa US 2020-03-31 23:43:56 42.84443388 -91.34133693 1 0 0 0 Clayton, Iowa, US
407 407 13065 Clinch Georgia US 2020-03-31 23:43:56 30.91395822 -82.70432472 1 0 0 0 Clinch, Georgia, US
409 409 18023 Clinton Indiana US 2020-03-31 23:43:56 40.30319754 -86.47277257 1 0 0 0 Clinton, Indiana, US
418 418 47029 Cocke Tennessee US 2020-03-31 23:43:56 35.9278914 -83.11828725 1 0 0 0 Cocke, Tennessee, US
422 422 47031 Coffee Tennessee US 2020-03-31 23:43:56 35.49090731 -86.07311784 1 0 0 0 Coffee, Tennessee, US
431 431 5027 Columbia Arkansas US 2020-03-31 23:43:56 33.21230701 -93.22642793 1 0 0 0 Columbia, Arkansas, US
435 435 41009 Columbia Oregon US 2020-03-31 23:43:56 45.94464254 -123.08908980000001 1 0 0 0 Columbia, Oregon, US
437 437 53013 Columbia Washington US 2020-03-31 23:43:56 46.29442881 -117.9051983 1 0 0 0 Columbia, Washington, US
441 441 6011 Colusa California US 2020-03-31 23:43:56 39.17881957 -122.2331726 1 0 0 0 Colusa, California, US
447 447 56009 Converse Wyoming US 2020-03-31 23:43:56 42.97272268 -105.5081848 1 0 0 0 Converse, Wyoming, US
448 448 5029 Conway Arkansas US 2020-03-31 23:43:56 35.26205537 -92.70506566 1 1 0 0 Conway, Arkansas, US
449 449 13075 Cook Georgia US 2020-03-31 23:43:56 31.16068491 -83.42947229 1 0 0 0 Cook, Georgia, US
455 455 48099 Coryell Texas US 2020-03-31 23:43:56 31.39078397 -97.79936155 1 0 0 0 Coryell, Texas, US
458 458 40033 Cotton Oklahoma US 2020-03-31 23:43:56 34.28845626 -98.37053567 1 0 0 0 Cotton, Oklahoma, US
464 464 40035 Craig Oklahoma US 2020-03-31 23:43:56 36.76268118 -95.20916602 1 0 0 0 Craig, Oklahoma, US
468 468 5033 Crawford Arkansas US 2020-03-31 23:43:56 35.58928601 -94.2446814 1 0 0 0 Crawford, Arkansas, US
469 469 17033 Crawford Illinois US 2020-03-31 23:43:56 39.0032229 -87.75954624 1 0 0 0 Crawford, Illinois, US
470 470 18025 Crawford Indiana US 2020-03-31 23:43:56 38.28814402 -86.44518825 1 0 0 0 Crawford, Indiana, US
471 471 19047 Crawford Iowa US 2020-03-31 23:43:56 42.03718237 -95.3819718 1 0 0 0 Crawford, Iowa, US
473 473 26039 Crawford Michigan US 2020-03-31 23:43:56 44.68255561 -84.61006219 1 0 0 0 Crawford, Michigan, US
474 474 29055 Crawford Missouri US 2020-03-31 23:43:56 37.97663738 -91.30528104 1 0 0 0 Crawford, Missouri, US
478 478 1041 Crenshaw Alabama US 2020-03-31 23:43:56 31.72941803 -86.31593104 1 0 0 0 Crenshaw, Alabama, US
481 481 5037 Cross Arkansas US 2020-03-31 23:43:56 35.29631396 -90.77185818 1 0 0 0 Cross, Arkansas, US
482 482 8025 Crowley Colorado US 2020-03-31 23:43:56 38.32608609 -103.7844965 1 1 0 0 Crowley, Colorado, US
485 485 17035 Cumberland Illinois US 2020-03-31 23:43:56 39.27432424 -88.2401158 1 0 0 0 Cumberland, Illinois, US
491 491 37053 Currituck North Carolina US 2020-03-31 23:43:56 36.36123664 -75.95876401 1 0 0 0 Currituck, North Carolina, US
493 493 16037 Custer Idaho US 2020-03-31 23:43:56 44.24186819 -114.2855494 1 0 0 0 Custer, Idaho, US
496 496 13083 Dade Georgia US 2020-03-31 23:43:56 34.854916700000004 -85.50490424 1 0 0 0 Dade, Georgia, US
514 514 31047 Dawson Nebraska US 2020-03-31 23:43:56 40.87028216 -99.82014609999999 1 0 0 0 Dawson, Nebraska, US
520 520 18033 DeKalb Indiana US 2020-03-31 23:43:56 41.39804622 -84.99906934 1 0 0 0 DeKalb, Indiana, US
537 537 8029 Delta Colorado US 2020-03-31 23:43:56 38.86246243 -107.86313419999999 1 0 0 0 Delta, Colorado, US
538 538 26041 Delta Michigan US 2020-03-31 23:43:56 45.90484910000001 -86.9080745 1 0 0 0 Delta, Michigan, US
541 541 19057 Des Moines Iowa US 2020-03-31 23:43:56 40.92012606 -91.18326592 1 0 0 0 Des Moines, Iowa, US
544 544 46039 Deuel South Dakota US 2020-03-31 23:43:56 44.75994309 -96.66943645 1 0 0 0 Deuel, South Dakota, US
545 545 19059 Dickinson Iowa US 2020-03-31 23:43:56 43.37787725 -95.1510206 1 0 0 0 Dickinson, Iowa, US
548 548 45033 Dillon South Carolina US 2020-03-31 23:43:56 34.39007791 -79.37741872 1 0 0 0 Dillon, South Carolina, US
550 550 38023 Divide North Dakota US 2020-03-31 23:43:56 48.814938700000006 -103.48736109999999 1 0 0 0 Divide, North Dakota, US
556 556 20043 Doniphan Kansas US 2020-03-31 23:43:56 39.79067154 -95.14056866 1 0 0 0 Doniphan, Kansas, US
557 557 48129 Donley Texas US 2020-03-31 23:43:56 34.96517499 -100.8140093 1 0 0 0 Donley, Texas, US
559 559 55029 Door Wisconsin US 2020-03-31 23:43:56 44.95856458 -87.30002707 1 0 0 0 Door, Wisconsin, US
566 566 27041 Douglas Minnesota US 2020-03-31 23:43:56 45.93348491 -95.45335469 1 0 0 0 Douglas, Minnesota, US
572 572 5043 Drew Arkansas US 2020-03-31 23:43:56 33.59035001 -91.71777921 1 0 0 0 Drew, Arkansas, US
578 578 38025 Dunn North Dakota US 2020-03-31 23:43:56 47.35423935 -102.61604679999999 1 0 0 0 Dunn, North Dakota, US
580 580 37061 Duplin North Carolina US 2020-03-31 23:43:56 34.93449805 -77.93140529 1 0 0 0 Duplin, North Carolina, US
588 588 22035 East Carroll Louisiana US 2020-03-31 23:43:56 32.73926954 -91.23425694 1 0 0 0 East Carroll, Louisiana, US
607 607 16039 Elmore Idaho US 2020-03-31 23:43:56 43.3507101 -115.4701578 1 0 0 0 Elmore, Idaho, US
608 608 13107 Emanuel Georgia US 2020-03-31 23:43:56 32.59221302 -82.30239915 1 0 0 0 Emanuel, Georgia, US
623 623 51600 Fairfax City Virginia US 2020-03-31 23:43:56 38.85157547 -77.29779640000002 1 0 0 0 Fairfax City, Virginia, US
627 627 46047 Fall River South Dakota US 2020-03-31 23:43:56 43.23929297 -103.5275691 1 0 0 0 Fall River, South Dakota, US
628 628 48145 Falls Texas US 2020-03-31 23:43:56 31.25350609 -96.93630086 1 0 0 0 Falls, Texas, US
630 630 48147 Fannin Texas US 2020-03-31 23:43:56 33.59564294 -96.10751083 1 0 0 0 Fannin, Texas, US
632 632 46049 Faulk South Dakota US 2020-03-31 23:43:56 45.07082625 -99.14535601 1 0 0 0 Faulk, South Dakota, US
635 635 1057 Fayette Alabama US 2020-03-31 23:43:56 33.72076938 -87.73886638 1 0 0 0 Fayette, Alabama, US
637 637 17051 Fayette Illinois US 2020-03-31 23:43:56 39.00072038 -89.02452658 1 0 0 0 Fayette, Illinois, US
641 641 39047 Fayette Ohio US 2020-03-31 23:43:56 39.56021306 -83.4562016 1 0 0 0 Fayette, Ohio, US
645 645 47049 Fentress Tennessee US 2020-03-31 23:43:56 36.38128818 -84.92870012 1 0 0 0 Fentress, Tennessee, US
646 646 53019 Ferry Washington US 2020-03-31 23:43:56 48.471143100000006 -118.5154041 1 0 0 0 Ferry, Washington, US
648 648 20055 Finney Kansas US 2020-03-31 23:43:56 38.04340344 -100.73819379999999 1 0 0 0 Finney, Kansas, US
656 656 17053 Ford Illinois US 2020-03-31 23:43:56 40.59706922 -88.22350769 1 0 0 0 Ford, Illinois, US
657 657 20057 Ford Kansas US 2020-03-31 23:43:56 37.69200114 -99.88825298 1 0 0 0 Ford, Kansas, US
662 662 38031 Foster North Dakota US 2020-03-31 23:43:56 47.457108399999996 -98.88279923 1 0 0 0 Foster, North Dakota, US
663 663 18045 Fountain Indiana US 2020-03-31 23:43:56 40.12361933 -87.24217689 1 0 0 0 Fountain, Indiana, US
666 666 17055 Franklin Illinois US 2020-03-31 23:43:56 37.99189086 -88.92567818 1 0 0 0 Franklin, Illinois, US
680 680 48159 Franklin Texas US 2020-03-31 23:43:56 33.17653242 -95.21917243 1 0 0 0 Franklin, Texas, US
684 684 51620 Franklin City Virginia US 2020-03-31 23:43:56 36.6831435 -76.93859681 1 0 0 0 Franklin City, Virginia, US
687 687 51630 Fredericksburg Virginia US 2020-03-31 23:43:56 38.2977863 -77.4922454 1 0 0 0 Fredericksburg, Virginia, US
689 689 16043 Fremont Idaho US 2020-03-31 23:43:56 44.22800938 -111.48099429999999 1 0 0 0 Fremont, Idaho, US
693 693 18049 Fulton Indiana US 2020-03-31 23:43:56 41.0469907 -86.26252745 1 0 0 0 Fulton, Indiana, US
694 694 36035 Fulton New York US 2020-03-31 23:43:56 43.11363907 -74.41798804 1 0 0 0 Fulton, New York, US
696 696 12039 Gadsden Florida US 2020-03-31 23:43:56 30.57796289 -84.61915825 1 0 0 0 Gadsden, Florida, US
697 697 48165 Gaines Texas US 2020-03-31 23:43:56 32.74055318 -102.6353295 1 0 0 0 Gaines, Texas, US
698 698 51640 Galax Virginia US 2020-03-31 23:43:56 36.66601852 -80.91703124 1 0 0 0 Galax, Virginia, US
700 700 39053 Gallia Ohio US 2020-03-31 23:43:56 38.82708533 -82.31647569 1 1 0 0 Gallia, Ohio, US
704 704 49017 Garfield Utah US 2020-03-31 23:43:56 37.85447192 -111.4418764 1 0 0 0 Garfield, Utah, US
717 717 4007 Gila Arizona US 2020-03-31 23:43:56 33.80190085 -110.8132779 1 0 0 0 Gila, Arizona, US
719 719 48171 Gillespie Texas US 2020-03-31 23:43:56 30.31824095 -98.94676915 1 0 0 0 Gillespie, Texas, US
720 720 13123 Gilmer Georgia US 2020-03-31 23:43:56 34.69316688 -84.45802506 1 0 0 0 Gilmer, Georgia, US
731 731 56015 Goshen Wyoming US 2020-03-31 23:43:56 42.08798185 -104.3534743 1 0 0 0 Goshen, Wyoming, US
732 732 31073 Gosper Nebraska US 2020-03-31 23:43:56 40.51481965 -99.83020279 1 0 0 0 Gosper, Nebraska, US
733 733 20063 Gove Kansas US 2020-03-31 23:43:56 38.91588178 -100.4829321 1 0 0 0 Gove, Kansas, US
734 734 13131 Grady Georgia US 2020-03-31 23:43:56 30.87454847 -84.23418364 1 0 0 0 Grady, Georgia, US
739 739 49019 Grand Utah US 2020-03-31 23:43:56 38.98103848 -109.5704487 1 0 0 0 Grand, Utah, US
744 744 21081 Grant Kentucky US 2020-03-31 23:43:56 38.64962758 -84.62415957 1 0 0 0 Grant, Kentucky, US
746 746 38037 Grant North Dakota US 2020-03-31 23:43:56 46.35821257 -101.63900129999999 1 0 0 0 Grant, North Dakota, US
747 747 41023 Grant Oregon US 2020-03-31 23:43:56 44.49024544 -119.0068631 1 0 0 0 Grant, Oregon, US
757 757 1063 Greene Alabama US 2020-03-31 23:43:56 32.85504247 -87.95684022 1 0 0 0 Greene, Alabama, US
758 758 5055 Greene Arkansas US 2020-03-31 23:43:56 36.11735460000001 -90.55832668 1 0 0 0 Greene, Arkansas, US
767 767 51079 Greene Virginia US 2020-03-31 23:43:56 38.29545894 -78.46525378 1 0 0 0 Greene, Virginia, US
768 768 4011 Greenlee Arizona US 2020-03-31 23:43:56 33.21498827 -109.2405279 1 0 0 0 Greenlee, Arizona, US
780 780 19077 Guthrie Iowa US 2020-03-31 23:43:56 41.68378965 -94.50111014 1 0 0 0 Guthrie, Iowa, US
783 783 1065 Hale Alabama US 2020-03-31 23:43:56 32.76039258 -87.63284988 1 0 0 0 Hale, Alabama, US
784 784 48189 Hale Texas US 2020-03-31 23:43:56 34.07044901 -101.82681140000001 1 0 0 0 Hale, Texas, US
786 786 51083 Halifax Virginia US 2020-03-31 23:43:56 36.76654925 -78.93512622 1 0 0 0 Halifax, Virginia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-31-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
);