04-16-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,043 rows sorted by Active

✎ 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
229 229 54007 Braxton West Virginia US 2020-04-16 23:30:51 38.70036159 -80.72011184 1 0 0 1 Braxton, West Virginia, US
232 232 21025 Breathitt Kentucky US 2020-04-16 23:30:51 37.52333168 -83.31959161 1 0 0 1 Breathitt, Kentucky, US
238 238 51520 Bristol Virginia US 2020-04-16 23:30:51 36.616302399999995 -82.16359122 1 0 0 1 Bristol, Virginia, US
278 278 31021 Burt Nebraska US 2020-04-16 23:30:51 41.85056773 -96.32605633 1 0 0 1 Burt, Nebraska, US
280 280 19023 Butler Iowa US 2020-04-16 23:30:51 42.73172833 -92.79015971 1 0 0 1 Butler, Iowa, US
305 305 17013 Calhoun Illinois US 2020-04-16 23:30:51 39.16840183 -90.66330078 1 0 0 1 Calhoun, Illinois, US
310 310 48059 Callahan Texas US 2020-04-16 23:30:51 32.29760619 -99.37326312 1 0 0 1 Callahan, Texas, US
315 315 16025 Camas Idaho US 2020-04-16 23:30:51 43.46665742 -114.8065892 1 0 0 1 Camas, Idaho, US
321 321 42023 Cameron Pennsylvania US 2020-04-16 23:30:51 41.43625568 -78.20376845 1 0 0 1 Cameron, Pennsylvania, US
338 338 16029 Caribou Idaho US 2020-04-16 23:30:51 42.77149116 -111.5597683 1 0 0 1 Caribou, Idaho, US
346 346 19027 Carroll Iowa US 2020-04-16 23:30:51 42.03617207 -94.86032705 1 0 0 1 Carroll, Iowa, US
357 357 40019 Carter Oklahoma US 2020-04-16 23:30:51 34.25103751 -97.28552485 1 0 0 1 Carter, Oklahoma, US
362 362 21045 Casey Kentucky US 2020-04-16 23:30:51 37.32533118 -84.92726209 1 0 0 1 Casey, Kentucky, US
364 364 19029 Cass Iowa US 2020-04-16 23:30:51 41.33149454 -94.92792482 1 0 0 1 Cass, Iowa, US
377 377 35003 Catron New Mexico US 2020-04-16 23:30:51 33.91514144 -108.4046587 1 0 0 1 Catron, New Mexico, US
420 420 31031 Cherry Nebraska US 2020-04-16 23:30:51 42.54502621 -101.1244332 1 0 0 1 Cherry, Nebraska, US
444 444 32001 Churchill Nevada US 2020-04-16 23:30:51 39.58105744 -118.3394607 1 0 0 1 Churchill, Nevada, US
459 459 29045 Clark Missouri US 2020-04-16 23:30:51 40.41040752 -91.73661677 1 0 0 1 Clark, Missouri, US
462 462 46025 Clark South Dakota US 2020-04-16 23:30:51 44.85834507 -97.72925109 1 0 0 1 Clark, South Dakota, US
472 472 5021 Clay Arkansas US 2020-04-16 23:30:51 36.36826212 -90.4148172 1 0 0 1 Clay, Arkansas, US
475 475 17025 Clay Illinois US 2020-04-16 23:30:51 38.75388572 -88.48914513 1 0 0 1 Clay, Illinois, US
478 478 20027 Clay Kansas US 2020-04-16 23:30:51 39.34948772 -97.16518128 1 0 0 1 Clay, Kansas, US
536 536 53013 Columbia Washington US 2020-04-16 23:30:51 46.29442881 -117.9051983 1 0 0 1 Columbia, Washington, US
544 544 48095 Concho Texas US 2020-04-16 23:30:51 31.32635934 -99.86473038 1 0 0 1 Concho, Texas, US
555 555 41011 Coos Oregon US 2020-04-16 23:30:51 43.17406868 -124.0594514 1 0 0 1 Coos, Oregon, US
558 558 46031 Corson South Dakota US 2020-04-16 23:30:51 45.70889983 -101.1970473 1 0 0 1 Corson, South Dakota, US
567 567 51580 Covington Virginia US 2020-04-16 23:30:51 37.7824656 -79.98631446 1 0 0 1 Covington, Virginia, US
593 593 41013 Crook Oregon US 2020-04-16 23:30:51 44.14230227 -120.356297 1 0 0 1 Crook, Oregon, US
598 598 8025 Crowley Colorado US 2020-04-16 23:30:51 38.32608609 -103.7844965 2 1 0 1 Crowley, Colorado, US
624 624 5039 Dallas Arkansas US 2020-04-16 23:30:51 33.97042763 -92.65167437 1 0 0 1 Dallas, Arkansas, US
645 645 17039 De Witt Illinois US 2020-04-16 23:30:51 40.17514519 -88.90959682 1 0 0 1 De Witt, Illinois, US
671 671 48119 Delta Texas US 2020-04-16 23:30:51 33.38570922 -95.66921122 1 0 0 1 Delta, Texas, US
677 677 46039 Deuel South Dakota US 2020-04-16 23:30:51 44.75994309 -96.66943645 1 0 0 1 Deuel, South Dakota, US
679 679 48125 Dickens Texas US 2020-04-16 23:30:51 33.61616822 -100.7788855 1 0 0 1 Dickens, Texas, US
681 681 19059 Dickinson Iowa US 2020-04-16 23:30:51 43.37787725 -95.1510206 1 0 0 1 Dickinson, Iowa, US
682 682 20041 Dickinson Kansas US 2020-04-16 23:30:51 38.86600962 -97.15532383 1 0 0 1 Dickinson, Kansas, US
683 683 26043 Dickinson Michigan US 2020-04-16 23:30:51 46.00999672 -87.86961634 3 2 0 1 Dickinson, Michigan, US
686 686 48127 Dimmit Texas US 2020-04-16 23:30:51 28.42270064 -99.75645095 1 0 0 1 Dimmit, Texas, US
689 689 38023 Divide North Dakota US 2020-04-16 23:30:51 48.814938700000006 -103.48736109999999 1 0 0 1 Divide, North Dakota, US
696 696 20043 Doniphan Kansas US 2020-04-16 23:30:51 39.79067154 -95.14056866 1 0 0 1 Doniphan, Kansas, US
707 707 27041 Douglas Minnesota US 2020-04-16 23:30:51 45.93348491 -95.45335469 1 0 0 1 Douglas, Minnesota, US
726 726 48131 Duval Texas US 2020-04-16 23:30:51 27.68184592 -98.50864568 1 0 0 1 Duval, Texas, US
731 731 22035 East Carroll Louisiana US 2020-04-16 23:30:51 32.73926954 -91.23425694 1 0 0 1 East Carroll, Louisiana, US
739 739 38027 Eddy North Dakota US 2020-04-16 23:30:51 47.71701474 -98.90432337 1 0 0 1 Eddy, North Dakota, US
771 771 50009 Essex Vermont US 2020-04-16 23:30:51 44.72736416 -71.73579864 1 0 0 1 Essex, Vermont, US
782 782 46047 Fall River South Dakota US 2020-04-16 23:30:51 43.23929297 -103.5275691 1 0 0 1 Fall River, South Dakota, US
783 783 48145 Falls Texas US 2020-04-16 23:30:51 31.25350609 -96.93630086 1 0 0 1 Falls, Texas, US
788 788 46049 Faulk South Dakota US 2020-04-16 23:30:51 45.07082625 -99.14535601 1 0 0 1 Faulk, South Dakota, US
804 804 53019 Ferry Washington US 2020-04-16 23:30:51 48.471143100000006 -118.5154041 1 0 0 1 Ferry, Washington, US
816 816 51063 Floyd Virginia US 2020-04-16 23:30:51 36.9302126 -80.36738849 1 0 0 1 Floyd, Virginia, US
826 826 38031 Foster North Dakota US 2020-04-16 23:30:51 47.457108399999996 -98.88279923 1 0 0 1 Foster, North Dakota, US
829 829 5047 Franklin Arkansas US 2020-04-16 23:30:51 35.51202821 -93.89299569 1 0 0 1 Franklin, Arkansas, US
834 834 19069 Franklin Iowa US 2020-04-16 23:30:51 42.73270384 -93.26256925 1 0 0 1 Franklin, Iowa, US
848 848 48159 Franklin Texas US 2020-04-16 23:30:51 33.17653242 -95.21917243 1 0 0 1 Franklin, Texas, US
857 857 48161 Freestone Texas US 2020-04-16 23:30:51 31.70422788 -96.15072516 1 0 0 1 Freestone, Texas, US
862 862 48163 Frio Texas US 2020-04-16 23:30:51 28.86751206 -99.10804207 1 0 0 1 Frio, Texas, US
864 864 17057 Fulton Illinois US 2020-04-16 23:30:51 40.47289135 -90.20862357 1 0 0 1 Fulton, Illinois, US
872 872 51640 Galax Virginia US 2020-04-16 23:30:51 36.66601852 -80.91703124 1 0 0 1 Galax, Virginia, US
874 874 21077 Gallatin Kentucky US 2020-04-16 23:30:51 38.75398691 -84.8558382 1 0 0 1 Gallatin, Kentucky, US
880 880 49017 Garfield Utah US 2020-04-16 23:30:51 37.85447192 -111.4418764 1 0 0 1 Garfield, Utah, US
894 894 29075 Gentry Missouri US 2020-04-16 23:30:51 40.21097916 -94.40944419 1 0 0 1 Gentry, Missouri, US
903 903 48171 Gillespie Texas US 2020-04-16 23:30:51 30.31824095 -98.94676915 1 0 0 1 Gillespie, Texas, US
905 905 8047 Gilpin Colorado US 2020-04-16 23:30:51 39.85646523 -105.5252597 1 0 0 1 Gilpin, Colorado, US
914 914 30037 Golden Valley Montana US 2020-04-16 23:30:51 46.3816474 -109.17685220000001 1 0 0 1 Golden Valley, Montana, US
922 922 31073 Gosper Nebraska US 2020-04-16 23:30:51 40.51481965 -99.83020279 1 0 0 1 Gosper, Nebraska, US
923 923 20063 Gove Kansas US 2020-04-16 23:30:51 38.91588178 -100.4829321 1 0 0 1 Gove, Kansas, US
930 930 49019 Grand Utah US 2020-04-16 23:30:51 38.98103848 -109.5704487 1 0 0 1 Grand, Utah, US
939 939 38037 Grant North Dakota US 2020-04-16 23:30:51 46.35821257 -101.63900129999999 1 0 0 1 Grant, North Dakota, US
941 941 41023 Grant Oregon US 2020-04-16 23:30:51 44.49024544 -119.0068631 1 0 0 1 Grant, Oregon, US
943 943 54023 Grant West Virginia US 2020-04-16 23:30:51 39.10314817 -79.19440518 1 0 0 1 Grant, West Virginia, US
953 953 21087 Green Kentucky US 2020-04-16 23:30:51 37.26484328 -85.5540745 1 0 0 1 Green, Kentucky, US
955 955 55047 Green Lake Wisconsin US 2020-04-16 23:30:51 43.80025981 -89.04679553 1 0 0 1 Green Lake, Wisconsin, US
960 960 17061 Greene Illinois US 2020-04-16 23:30:51 39.35907414 -90.388865 1 0 0 1 Greene, Illinois, US
962 962 19073 Greene Iowa US 2020-04-16 23:30:51 42.03614551 -94.39658081 1 0 0 1 Greene, Iowa, US
975 975 20073 Greenwood Kansas US 2020-04-16 23:30:51 37.8774388 -96.23250453 1 0 0 1 Greenwood, Kansas, US
982 982 19075 Grundy Iowa US 2020-04-16 23:30:51 42.40183723 -92.78829551 1 0 0 1 Grundy, Iowa, US
987 987 12045 Gulf Florida US 2020-04-16 23:30:51 29.93543004 -85.24270990000002 1 0 0 1 Gulf, Florida, US
1002 1002 20075 Hamilton Kansas US 2020-04-16 23:30:51 37.99978709 -101.7921066 1 0 0 1 Hamilton, Kansas, US
1025 1025 48195 Hansford Texas US 2020-04-16 23:30:51 36.27743284 -101.3545796 1 0 0 1 Hansford, Texas, US
1029 1029 19083 Hardin Iowa US 2020-04-16 23:30:51 42.38353877 -93.23654611 1 0 0 1 Hardin, Iowa, US
1044 1044 39067 Harrison Ohio US 2020-04-16 23:30:51 40.29380509 -81.09068544 1 0 0 1 Harrison, Ohio, US
1049 1049 21099 Hart Kentucky US 2020-04-16 23:30:51 37.29943898 -85.88461055 1 0 0 1 Hart, Kentucky, US
1058 1058 48211 Hemphill Texas US 2020-04-16 23:30:51 35.83764858 -100.2703577 1 0 0 1 Hemphill, Texas, US
1087 1087 30041 Hill Montana US 2020-04-16 23:30:51 48.62879827 -110.1129252 1 0 0 1 Hill, Montana, US
1100 1100 29087 Holt Missouri US 2020-04-16 23:30:51 40.09799248 -95.21638879999999 1 0 0 1 Holt, Missouri, US
1109 1109 56017 Hot Springs Wyoming US 2020-04-16 23:30:51 43.71930657 -108.44231740000001 1 0 0 1 Hot Springs, Wyoming, US
1113 1113 27055 Houston Minnesota US 2020-04-16 23:30:51 43.67129565 -91.49143057 1 0 0 1 Houston, Minnesota, US
1123 1123 8055 Huerfano Colorado US 2020-04-16 23:30:51 37.68473101 -104.9612585 1 0 0 1 Huerfano, Colorado, US
1137 1137 46069 Hyde South Dakota US 2020-04-16 23:30:51 44.54747703 -99.48572582 1 0 0 1 Hyde, South Dakota, US
1152 1152 29093 Iron Missouri US 2020-04-16 23:30:51 37.55487945 -90.7735296 1 0 0 1 Iron, Missouri, US
1154 1154 55051 Iron Wisconsin US 2020-04-16 23:30:51 46.26302338 -90.24295041 2 1 0 1 Iron, Wisconsin, US
1166 1166 5067 Jackson Arkansas US 2020-04-16 23:30:51 35.59802983 -91.21494602 1 0 0 1 Jackson, Arkansas, US
1172 1172 20085 Jackson Kansas US 2020-04-16 23:30:51 39.41673394 -95.79356799 1 0 0 1 Jackson, Kansas, US
1176 1176 27063 Jackson Minnesota US 2020-04-16 23:30:51 43.67423373 -95.15398258 1 0 0 1 Jackson, Minnesota, US
1215 1215 40067 Jefferson Oklahoma US 2020-04-16 23:30:51 34.11130184 -97.83182974 1 0 0 1 Jefferson, Oklahoma, US
1216 1216 41031 Jefferson Oregon US 2020-04-16 23:30:51 44.62806839 -121.17832 1 0 0 1 Jefferson, Oregon, US
1240 1240 21115 Johnson Kentucky US 2020-04-16 23:30:51 37.85106355 -82.8264322 1 0 0 1 Johnson, Kentucky, US
1242 1242 31097 Johnson Nebraska US 2020-04-16 23:30:51 40.39257596 -96.26522753 1 0 0 1 Johnson, Nebraska, US
1303 1303 21119 Knott Kentucky US 2020-04-16 23:30:51 37.35388197 -82.94981134 1 0 0 1 Knott, Kentucky, US
1311 1311 48275 Knox Texas US 2020-04-16 23:30:51 33.60519951 -99.74229059999999 1 0 0 1 Knox, Texas, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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