04-12-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,990 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
233 233 51520 Bristol Virginia US 2020-04-12 23:18:00 36.6163024 -82.16359122 1 0 0 1 Bristol, Virginia, US
247 247 46015 Brule South Dakota US 2020-04-12 23:18:00 43.71756379 -99.08118954 1 0 0 1 Brule, South Dakota, US
273 273 31021 Burt Nebraska US 2020-04-12 23:18:00 41.85056773 -96.32605633 1 0 0 1 Burt, Nebraska, US
275 275 19023 Butler Iowa US 2020-04-12 23:18:00 42.73172833 -92.79015971 1 0 0 1 Butler, Iowa, US
293 293 29025 Caldwell Missouri US 2020-04-12 23:18:00 39.65620858 -93.98308093 1 0 0 1 Caldwell, Missouri, US
300 300 17013 Calhoun Illinois US 2020-04-12 23:18:00 39.16840183 -90.66330078 1 0 0 1 Calhoun, Illinois, US
305 305 48059 Callahan Texas US 2020-04-12 23:18:00 32.29760619 -99.37326312 1 0 0 1 Callahan, Texas, US
310 310 16025 Camas Idaho US 2020-04-12 23:18:00 43.46665742 -114.8065892 1 0 0 1 Camas, Idaho, US
316 316 42023 Cameron Pennsylvania US 2020-04-12 23:18:00 41.43625568 -78.20376845 1 0 0 1 Cameron, Pennsylvania, US
333 333 16029 Caribou Idaho US 2020-04-12 23:18:00 42.77149116 -111.5597683 1 0 0 1 Caribou, Idaho, US
341 341 19027 Carroll Iowa US 2020-04-12 23:18:00 42.03617207 -94.86032705 1 0 0 1 Carroll, Iowa, US
350 350 21043 Carter Kentucky US 2020-04-12 23:18:00 38.31690743 -83.05092385 1 0 0 1 Carter, Kentucky, US
352 352 40019 Carter Oklahoma US 2020-04-12 23:18:00 34.25103751 -97.28552485 1 0 0 1 Carter, Oklahoma, US
370 370 35003 Catron New Mexico US 2020-04-12 23:18:00 33.91514144 -108.4046587 1 0 0 1 Catron, New Mexico, US
413 413 31031 Cherry Nebraska US 2020-04-12 23:18:00 42.54502621 -101.1244332 1 0 0 1 Cherry, Nebraska, US
451 451 29045 Clark Missouri US 2020-04-12 23:18:00 40.41040752 -91.73661677 1 0 0 1 Clark, Missouri, US
454 454 46025 Clark South Dakota US 2020-04-12 23:18:00 44.85834507 -97.72925109 1 0 0 1 Clark, South Dakota, US
464 464 5021 Clay Arkansas US 2020-04-12 23:18:00 36.36826212 -90.4148172 1 0 0 1 Clay, Arkansas, US
469 469 20027 Clay Kansas US 2020-04-12 23:18:00 39.34948772 -97.16518128 1 0 0 1 Clay, Kansas, US
514 514 35007 Colfax New Mexico US 2020-04-12 23:18:00 36.60569702 -104.6472674 1 0 0 1 Colfax, New Mexico, US
527 527 53013 Columbia Washington US 2020-04-12 23:18:00 46.29442881 -117.9051983 1 0 0 1 Columbia, Washington, US
535 535 48095 Concho Texas US 2020-04-12 23:18:00 31.32635934 -99.86473038 1 0 0 1 Concho, Texas, US
543 543 48097 Cooke Texas US 2020-04-12 23:18:00 33.63979567 -97.21240912 1 0 0 1 Cooke, Texas, US
548 548 46031 Corson South Dakota US 2020-04-12 23:18:00 45.70889983 -101.1970473 1 0 0 1 Corson, South Dakota, US
557 557 51580 Covington Virginia US 2020-04-12 23:18:00 37.7824656 -79.98631446 1 0 0 1 Covington, Virginia, US
583 583 41013 Crook Oregon US 2020-04-12 23:18:00 44.14230227 -120.356297 1 0 0 1 Crook, Oregon, US
585 585 48107 Crosby Texas US 2020-04-12 23:18:00 33.61431553 -101.3000364 1 0 0 1 Crosby, Texas, US
588 588 8025 Crowley Colorado US 2020-04-12 23:18:00 38.32608609 -103.7844965 2 1 0 1 Crowley, Colorado, US
608 608 13083 Dade Georgia US 2020-04-12 23:18:00 34.8549167 -85.50490424 2 1 0 1 Dade, Georgia, US
612 612 48111 Dallam Texas US 2020-04-12 23:18:00 36.27787176 -102.6020725 1 0 0 1 Dallam, Texas, US
614 614 5039 Dallas Arkansas US 2020-04-12 23:18:00 33.97042763 -92.65167437 1 0 0 1 Dallas, Arkansas, US
635 635 17039 De Witt Illinois US 2020-04-12 23:18:00 40.17514519 -88.90959682 1 0 0 1 De Witt, Illinois, US
661 661 48119 Delta Texas US 2020-04-12 23:18:00 33.38570922 -95.66921122 1 0 0 1 Delta, Texas, US
667 667 46039 Deuel South Dakota US 2020-04-12 23:18:00 44.75994309 -96.66943645 1 0 0 1 Deuel, South Dakota, US
668 668 40043 Dewey Oklahoma US 2020-04-12 23:18:00 35.98772922 -99.00730714 1 0 0 1 Dewey, Oklahoma, US
671 671 19059 Dickinson Iowa US 2020-04-12 23:18:00 43.37787725 -95.1510206 1 0 0 1 Dickinson, Iowa, US
672 672 26043 Dickinson Michigan US 2020-04-12 23:18:00 46.00999672 -87.86961634 3 2 0 1 Dickinson, Michigan, US
675 675 48127 Dimmit Texas US 2020-04-12 23:18:00 28.42270064 -99.75645095 1 0 0 1 Dimmit, Texas, US
678 678 38023 Divide North Dakota US 2020-04-12 23:18:00 48.8149387 -103.4873611 1 0 0 1 Divide, North Dakota, US
685 685 20043 Doniphan Kansas US 2020-04-12 23:18:00 39.79067154 -95.14056866 1 0 0 1 Doniphan, Kansas, US
696 696 27041 Douglas Minnesota US 2020-04-12 23:18:00 45.93348491 -95.45335469 1 0 0 1 Douglas, Minnesota, US
719 719 22035 East Carroll Louisiana US 2020-04-12 23:18:00 32.73926954 -91.23425694 1 0 0 1 East Carroll, Louisiana, US
727 727 38027 Eddy North Dakota US 2020-04-12 23:18:00 47.71701474 -98.90432337 1 0 0 1 Eddy, North Dakota, US
741 741 20051 Ellis Kansas US 2020-04-12 23:18:00 38.91458712 -99.31751551 1 0 0 1 Ellis, Kansas, US
759 759 50009 Essex Vermont US 2020-04-12 23:18:00 44.72736416 -71.73579864 1 0 0 1 Essex, Vermont, US
765 765 51600 Fairfax City Virginia US 2020-04-12 23:18:00 38.85157547 -77.2977964 1 0 0 1 Fairfax City, Virginia, US
769 769 46047 Fall River South Dakota US 2020-04-12 23:18:00 43.23929297 -103.5275691 1 0 0 1 Fall River, South Dakota, US
770 770 48145 Falls Texas US 2020-04-12 23:18:00 31.25350609 -96.93630086 1 0 0 1 Falls, Texas, US
775 775 46049 Faulk South Dakota US 2020-04-12 23:18:00 45.07082625 -99.14535601 1 0 0 1 Faulk, South Dakota, US
790 790 53019 Ferry Washington US 2020-04-12 23:18:00 48.4711431 -118.5154041 1 0 0 1 Ferry, Washington, US
795 795 21069 Fleming Kentucky US 2020-04-12 23:18:00 38.36758311 -83.69657514 1 0 0 1 Fleming, Kentucky, US
800 800 21071 Floyd Kentucky US 2020-04-12 23:18:00 37.56213922 -82.74750924 1 0 0 1 Floyd, Kentucky, US
801 801 48153 Floyd Texas US 2020-04-12 23:18:00 34.07227468 -101.3031546 1 0 0 1 Floyd, Texas, US
802 802 51063 Floyd Virginia US 2020-04-12 23:18:00 36.9302126 -80.36738849 1 0 0 1 Floyd, Virginia, US
812 812 38031 Foster North Dakota US 2020-04-12 23:18:00 47.4571084 -98.88279923 1 0 0 1 Foster, North Dakota, US
815 815 5047 Franklin Arkansas US 2020-04-12 23:18:00 35.51202821 -93.89299569 1 0 0 1 Franklin, Arkansas, US
820 820 19069 Franklin Iowa US 2020-04-12 23:18:00 42.73270384 -93.26256925 1 0 0 1 Franklin, Iowa, US
834 834 48159 Franklin Texas US 2020-04-12 23:18:00 33.17653242 -95.21917243 1 0 0 1 Franklin, Texas, US
847 847 48163 Frio Texas US 2020-04-12 23:18:00 28.86751206 -99.10804207 1 0 0 1 Frio, Texas, US
849 849 17057 Fulton Illinois US 2020-04-12 23:18:00 40.47289135 -90.20862357 1 0 0 1 Fulton, Illinois, US
853 853 42057 Fulton Pennsylvania US 2020-04-12 23:18:00 39.92913544 -78.11163677 1 0 0 1 Fulton, Pennsylvania, US
856 856 48165 Gaines Texas US 2020-04-12 23:18:00 32.74055318 -102.6353295 1 0 0 1 Gaines, Texas, US
857 857 51640 Galax Virginia US 2020-04-12 23:18:00 36.66601852 -80.91703124 1 0 0 1 Galax, Virginia, US
858 858 17059 Gallatin Illinois US 2020-04-12 23:18:00 37.76430935 -88.22953869 1 0 0 1 Gallatin, Illinois, US
859 859 21077 Gallatin Kentucky US 2020-04-12 23:18:00 38.75398691 -84.8558382 1 0 0 1 Gallatin, Kentucky, US
865 865 49017 Garfield Utah US 2020-04-12 23:18:00 37.85447192 -111.4418764 1 0 0 1 Garfield, Utah, US
877 877 1061 Geneva Alabama US 2020-04-12 23:18:00 31.09389027 -85.83572839 1 0 0 1 Geneva, Alabama, US
878 878 29075 Gentry Missouri US 2020-04-12 23:18:00 40.21097916 -94.40944419 1 0 0 1 Gentry, Missouri, US
887 887 48171 Gillespie Texas US 2020-04-12 23:18:00 30.31824095 -98.94676915 1 0 0 1 Gillespie, Texas, US
889 889 8047 Gilpin Colorado US 2020-04-12 23:18:00 39.85646523 -105.5252597 1 0 0 1 Gilpin, Colorado, US
898 898 30037 Golden Valley Montana US 2020-04-12 23:18:00 46.3816474 -109.1768522 1 0 0 1 Golden Valley, Montana, US
906 906 31073 Gosper Nebraska US 2020-04-12 23:18:00 40.51481965 -99.83020279 1 0 0 1 Gosper, Nebraska, US
907 907 20063 Gove Kansas US 2020-04-12 23:18:00 38.91588178 -100.4829321 1 0 0 1 Gove, Kansas, US
914 914 49019 Grand Utah US 2020-04-12 23:18:00 38.98103848 -109.5704487 1 0 0 1 Grand, Utah, US
923 923 38037 Grant North Dakota US 2020-04-12 23:18:00 46.35821257 -101.6390013 1 0 0 1 Grant, North Dakota, US
925 925 41023 Grant Oregon US 2020-04-12 23:18:00 44.49024544 -119.0068631 1 0 0 1 Grant, Oregon, US
942 942 17061 Greene Illinois US 2020-04-12 23:18:00 39.35907414 -90.388865 1 0 0 1 Greene, Illinois, US
944 944 19073 Greene Iowa US 2020-04-12 23:18:00 42.03614551 -94.39658081 1 0 0 1 Greene, Iowa, US
957 957 20073 Greenwood Kansas US 2020-04-12 23:18:00 37.8774388 -96.23250453 1 0 0 1 Greenwood, Kansas, US
964 964 19075 Grundy Iowa US 2020-04-12 23:18:00 42.40183723 -92.78829551 1 0 0 1 Grundy, Iowa, US
969 969 12045 Gulf Florida US 2020-04-12 23:18:00 29.93543004 -85.2427099 1 0 0 1 Gulf, Florida, US
971 971 19077 Guthrie Iowa US 2020-04-12 23:18:00 41.68378965 -94.50111014 1 0 0 1 Guthrie, Iowa, US
984 984 20075 Hamilton Kansas US 2020-04-12 23:18:00 37.99978709 -101.7921066 1 0 0 1 Hamilton, Kansas, US
990 990 46057 Hamlin South Dakota US 2020-04-12 23:18:00 44.67385954 -97.18829593 1 0 0 1 Hamlin, South Dakota, US
997 997 17067 Hancock Illinois US 2020-04-12 23:18:00 40.40423981 -91.16313899 1 0 0 1 Hancock, Illinois, US
1007 1007 48195 Hansford Texas US 2020-04-12 23:18:00 36.27743284 -101.3545796 1 0 0 1 Hansford, Texas, US
1011 1011 19083 Hardin Iowa US 2020-04-12 23:18:00 42.38353877 -93.23654611 1 0 0 1 Hardin, Iowa, US
1030 1030 21099 Hart Kentucky US 2020-04-12 23:18:00 37.29943898 -85.88461055 1 0 0 1 Hart, Kentucky, US
1039 1039 48211 Hemphill Texas US 2020-04-12 23:18:00 35.83764858 -100.2703577 1 0 0 1 Hemphill, Texas, US
1056 1056 39069 Henry Ohio US 2020-04-12 23:18:00 41.3339642 -84.06830637 1 0 0 1 Henry, Ohio, US
1068 1068 30041 Hill Montana US 2020-04-12 23:18:00 48.62879827 -110.1129252 1 0 0 1 Hill, Montana, US
1089 1089 56017 Hot Springs Wyoming US 2020-04-12 23:18:00 43.71930657 -108.4423174 1 0 0 1 Hot Springs, Wyoming, US
1090 1090 26061 Houghton Michigan US 2020-04-12 23:18:00 46.89988536 -88.68495385 1 0 0 1 Houghton, Michigan, US
1093 1093 27055 Houston Minnesota US 2020-04-12 23:18:00 43.67129565 -91.49143057 1 0 0 1 Houston, Minnesota, US
1097 1097 19089 Howard Iowa US 2020-04-12 23:18:00 43.35671042 -92.31702714 1 0 0 1 Howard, Iowa, US
1099 1099 29089 Howard Missouri US 2020-04-12 23:18:00 39.1435761 -92.69756691 1 0 0 1 Howard, Missouri, US
1103 1103 8055 Huerfano Colorado US 2020-04-12 23:18:00 37.68473101 -104.9612585 1 0 0 1 Huerfano, Colorado, US
1131 1131 29093 Iron Missouri US 2020-04-12 23:18:00 37.55487945 -90.7735296 1 0 0 1 Iron, Missouri, US
1133 1133 55051 Iron Wisconsin US 2020-04-12 23:18:00 46.26302338 -90.24295041 2 1 0 1 Iron, Wisconsin, US
1142 1142 5065 Izard Arkansas US 2020-04-12 23:18:00 36.09604046 -91.90847954 1 0 0 1 Izard, Arkansas, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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