Updating data.
[repo] / rolling-averages / us-counties.csv
index 3215113..9b6414c 100644 (file)
@@ -1560664,7 +1560664,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-53077,Yakima,Washington,0,39.71,15.83,1,0.29,0.11
 2021-07-27,USA-53075,Whitman,Washington,10,2,3.99,0,0.14,0.29
 2021-07-27,USA-53073,Whatcom,Washington,28,20.43,8.91,0,0.29,0.12
-2021-07-27,USA-53071,Walla Walla,Washington,0,17.71,29.15,0,0.14,0.24
+2021-07-27,USA-53071,Walla Walla,Washington,23,21,34.56,0,0.14,0.24
 2021-07-27,USA-53069,Wahkiakum,Washington,1,0.57,12.73,1,0.29,6.37
 2021-07-27,USA-53067,Thurston,Washington,32,41,14.11,0,0.14,0.05
 2021-07-27,USA-53065,Stevens,Washington,5,6.33,13.85,0,0,0
@@ -1560848,8 +1560848,8 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-50005,Caledonia,Vermont,0,0,0,0,0,0
 2021-07-27,USA-50003,Bennington,Vermont,0,0.71,2.01,0,0,0
 2021-07-27,USA-50001,Addison,Vermont,0,2.43,6.6,0,0,0
-2021-07-27,USA-49999,Unknown,Utah,60,31.5,,1,0.17,
-2021-07-27,USA-49057,Weber,Utah,0,52.71,20.26,0,1,0.38
+2021-07-27,USA-49999,Unknown,Utah,-47,22,,1,0.17,
+2021-07-27,USA-49057,Weber,Utah,88,65.29,25.09,0,1,0.38
 2021-07-27,USA-49055,Wayne,Utah,0,0.14,5.27,0,0,0
 2021-07-27,USA-49053,Washington,Utah,27,43.57,24.54,0,0.29,0.16
 2021-07-27,USA-49051,Wasatch,Utah,19,10.14,29.75,0,0,0
@@ -1560868,13 +1560868,13 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-49025,Kane,Utah,0,1.14,14.49,0,0,0
 2021-07-27,USA-49023,Juab,Utah,2,3.43,28.53,0,0,0
 2021-07-27,USA-49021,Iron,Utah,9,13.57,24.75,0,0,0
-2021-07-27,USA-49019,Grand,Utah,0,0.57,5.86,0,0,0
+2021-07-27,USA-49019,Grand,Utah,5,1.29,13.18,0,0,0
 2021-07-27,USA-49017,Garfield,Utah,0,0.43,8.48,0,0,0
-2021-07-27,USA-49015,Emery,Utah,0,0.57,5.71,0,0,0
+2021-07-27,USA-49015,Emery,Utah,2,0.86,8.56,0,0,0
 2021-07-27,USA-49013,Duchesne,Utah,1,7.71,38.69,0,0,0
 2021-07-27,USA-49011,Davis,Utah,64,62.71,17.64,1,0.43,0.12
 2021-07-27,USA-49009,Daggett,Utah,1,0.14,15.04,0,0,0
-2021-07-27,USA-49007,Carbon,Utah,0,3.29,16.06,0,0,0
+2021-07-27,USA-49007,Carbon,Utah,12,5,24.43,0,0,0
 2021-07-27,USA-49005,Cache,Utah,7,21,16.37,0,0,0
 2021-07-27,USA-49003,Box Elder,Utah,22,10.29,18.35,0,0.14,0.25
 2021-07-27,USA-49001,Beaver,Utah,0,1,14.9,0,0,0
@@ -1560911,7 +1560911,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-48447,Throckmorton,Texas,0,0,0,0,0,0
 2021-07-27,USA-48445,Terry,Texas,0,0.43,3.47,0,0,0
 2021-07-27,USA-48443,Terrell,Texas,0,0.86,110.46,0,0,0
-2021-07-27,USA-48441,Taylor,Texas,0,13.71,9.94,0,0,0
+2021-07-27,USA-48441,Taylor,Texas,110,29.43,21.32,0,0,0
 2021-07-27,USA-48439,Tarrant,Texas,405,456.29,21.7,3,2,0.1
 2021-07-27,USA-48437,Swisher,Texas,3,1.43,19.31,0,0,0
 2021-07-27,USA-48435,Sutton,Texas,0,0.86,22.7,0,0,0
@@ -1561413,43 +1561413,43 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-42005,Armstrong,Pennsylvania,4,3.29,5.08,0,0,0
 2021-07-27,USA-42003,Allegheny,Pennsylvania,96,59.43,4.89,1,0.14,0.01
 2021-07-27,USA-42001,Adams,Pennsylvania,10,7.71,7.49,0,0.14,0.14
-2021-07-27,USA-41071,Yamhill,Oregon,0,8.57,8,0,0.14,0.13
+2021-07-27,USA-41071,Yamhill,Oregon,29,12.71,11.87,0,0.14,0.13
 2021-07-27,USA-41069,Wheeler,Oregon,0,0.14,10.73,0,0,0
-2021-07-27,USA-41067,Washington,Oregon,0,31.43,5.22,0,0,0
-2021-07-27,USA-41065,Wasco,Oregon,0,2.86,10.71,0,0,0
-2021-07-27,USA-41063,Wallowa,Oregon,0,2,27.75,0,0,0
-2021-07-27,USA-41061,Union,Oregon,0,6.71,25.02,0,0,0
-2021-07-27,USA-41059,Umatilla,Oregon,0,28.71,36.84,0,0,0
-2021-07-27,USA-41057,Tillamook,Oregon,0,1.71,6.34,0,0.14,0.53
+2021-07-27,USA-41067,Washington,Oregon,95,45,7.48,0,0,0
+2021-07-27,USA-41065,Wasco,Oregon,9,4.14,15.53,0,0,0
+2021-07-27,USA-41063,Wallowa,Oregon,3,2.43,33.69,0,0,0
+2021-07-27,USA-41061,Union,Oregon,19,9.43,35.14,0,0,0
+2021-07-27,USA-41059,Umatilla,Oregon,110,44.43,57,0,0,0
+2021-07-27,USA-41057,Tillamook,Oregon,3,2.14,7.93,0,0.14,0.53
 2021-07-27,USA-41055,Sherman,Oregon,0,0.14,8.03,0,0,0
-2021-07-27,USA-41053,Polk,Oregon,0,6.43,7.47,0,0,0
-2021-07-27,USA-41051,Multnomah,Oregon,0,45.86,5.64,0,0,0
-2021-07-27,USA-41049,Morrow,Oregon,0,2.14,18.47,0,0,0
-2021-07-27,USA-41047,Marion,Oregon,0,21.14,6.08,0,0.14,0.04
-2021-07-27,USA-41045,Malheur,Oregon,0,1.43,4.67,0,0,0
-2021-07-27,USA-41043,Linn,Oregon,0,22.14,17.07,0,0,0
-2021-07-27,USA-41041,Lincoln,Oregon,0,2.14,4.29,0,0,0
-2021-07-27,USA-41039,Lane,Oregon,0,31.43,8.23,0,0,0
-2021-07-27,USA-41037,Lake,Oregon,0,0.5,6.35,0,0,0
-2021-07-27,USA-41035,Klamath,Oregon,0,4.14,6.07,0,0,0
-2021-07-27,USA-41033,Josephine,Oregon,0,19.86,22.7,0,0,0
-2021-07-27,USA-41031,Jefferson,Oregon,0,4.29,17.38,0,0,0
-2021-07-27,USA-41029,Jackson,Oregon,0,27.86,12.61,0,0,0
-2021-07-27,USA-41027,Hood River,Oregon,0,1.14,4.89,0,0,0
-2021-07-27,USA-41025,Harney,Oregon,0,0.57,7.73,0,0,0
-2021-07-27,USA-41023,Grant,Oregon,0,0.14,1.98,0,0,0
-2021-07-27,USA-41021,Gilliam,Oregon,0,0.29,14.94,0,0,0
-2021-07-27,USA-41019,Douglas,Oregon,0,18.57,16.73,0,0.14,0.13
-2021-07-27,USA-41017,Deschutes,Oregon,0,18.43,9.32,0,0,0
-2021-07-27,USA-41015,Curry,Oregon,0,1.33,5.82,0,0,0
-2021-07-27,USA-41013,Crook,Oregon,0,1.43,5.85,0,0,0
-2021-07-27,USA-41011,Coos,Oregon,0,2.86,4.43,0,0,0
-2021-07-27,USA-41009,Columbia,Oregon,0,4.71,9,0,0,0
-2021-07-27,USA-41007,Clatsop,Oregon,0,2.29,5.68,0,0,0
-2021-07-27,USA-41005,Clackamas,Oregon,0,29.29,7,0,0,0
-2021-07-27,USA-41003,Benton,Oregon,0,6.43,6.91,0,0,0
-2021-07-27,USA-41001,Baker,Oregon,0,0.71,4.43,0,0,0
-2021-07-27,USA-40999,Unknown,Oklahoma,0,1074,,0,0,
+2021-07-27,USA-41053,Polk,Oregon,24,9.86,11.45,1,0.14,0.17
+2021-07-27,USA-41051,Multnomah,Oregon,72,56.14,6.91,0,0,0
+2021-07-27,USA-41049,Morrow,Oregon,5,2.86,24.62,0,0,0
+2021-07-27,USA-41047,Marion,Oregon,119,38.14,10.97,1,0.29,0.08
+2021-07-27,USA-41045,Malheur,Oregon,3,1.86,6.07,0,0,0
+2021-07-27,USA-41043,Linn,Oregon,26,25.86,19.93,0,0,0
+2021-07-27,USA-41041,Lincoln,Oregon,12,3.86,7.72,0,0,0
+2021-07-27,USA-41039,Lane,Oregon,91,44.43,11.63,2,0.29,0.07
+2021-07-27,USA-41037,Lake,Oregon,2,0.83,10.59,0,0,0
+2021-07-27,USA-41035,Klamath,Oregon,18,6.71,9.84,0,0,0
+2021-07-27,USA-41033,Josephine,Oregon,19,22.57,25.8,1,0.14,0.16
+2021-07-27,USA-41031,Jefferson,Oregon,19,7,28.39,0,0,0
+2021-07-27,USA-41029,Jackson,Oregon,106,43,19.46,0,0,0
+2021-07-27,USA-41027,Hood River,Oregon,4,1.71,7.33,0,0,0
+2021-07-27,USA-41025,Harney,Oregon,2,0.86,11.59,0,0,0
+2021-07-27,USA-41023,Grant,Oregon,1,0.29,3.97,0,0,0
+2021-07-27,USA-41021,Gilliam,Oregon,1,0.43,22.41,0,0,0
+2021-07-27,USA-41019,Douglas,Oregon,63,27.57,24.84,0,0.14,0.13
+2021-07-27,USA-41017,Deschutes,Oregon,35,23.43,11.85,0,0,0
+2021-07-27,USA-41015,Curry,Oregon,5,2.17,9.45,0,0,0
+2021-07-27,USA-41013,Crook,Oregon,8,2.57,10.54,0,0,0
+2021-07-27,USA-41011,Coos,Oregon,4,3.43,5.32,0,0,0
+2021-07-27,USA-41009,Columbia,Oregon,13,6.57,12.55,0,0,0
+2021-07-27,USA-41007,Clatsop,Oregon,13,4.14,10.3,0,0,0
+2021-07-27,USA-41005,Clackamas,Oregon,72,39.57,9.46,0,0,0
+2021-07-27,USA-41003,Benton,Oregon,14,8.43,9.06,0,0,0
+2021-07-27,USA-41001,Baker,Oregon,3,1.14,7.09,0,0,0
+2021-07-27,USA-40999,Unknown,Oklahoma,733,1196.17,,0,0,
 2021-07-27,USA-40153,Woodward,Oklahoma,0,0.29,1.41,0,0.14,0.71
 2021-07-27,USA-40151,Woods,Oklahoma,0,1.29,14.62,0,0,0
 2021-07-27,USA-40149,Washita,Oklahoma,0,1.43,13.09,0,0,0
@@ -1561738,7 +1561738,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-37069,Franklin,North Carolina,2,12.71,18.25,0,0,0
 2021-07-27,USA-37067,Forsyth,North Carolina,47,50.57,13.23,0,0.43,0.11
 2021-07-27,USA-37065,Edgecombe,North Carolina,0,7,13.6,0,0.14,0.28
-2021-07-27,USA-37063,Durham,North Carolina,0,24.57,7.64,0,0,0
+2021-07-27,USA-37063,Durham,North Carolina,35,29.57,9.2,0,0,0
 2021-07-27,USA-37061,Duplin,North Carolina,25,16.29,27.72,0,0,0
 2021-07-27,USA-37059,Davie,North Carolina,3,5.71,13.34,0,0.14,0.33
 2021-07-27,USA-37057,Davidson,North Carolina,28,24.57,14.66,1,0.29,0.17
@@ -1561828,39 +1561828,39 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-36007,Broome,New York,9,7,3.67,0,0,0
 2021-07-27,USA-36003,Allegany,New York,0,0.71,1.55,0,0,0
 2021-07-27,USA-36001,Albany,New York,19,16,5.24,0,0,0
-2021-07-27,USA-35061,Valencia,New Mexico,0,7.71,10.06,0,0.29,0.37
+2021-07-27,USA-35061,Valencia,New Mexico,6,8.57,11.18,0,0.29,0.37
 2021-07-27,USA-35059,Union,New Mexico,0,0,0,0,0,0
-2021-07-27,USA-35057,Torrance,New Mexico,0,1.57,10.16,0,0,0
-2021-07-27,USA-35055,Taos,New Mexico,0,2.57,7.86,0,0.14,0.44
+2021-07-27,USA-35057,Torrance,New Mexico,1,1.71,11.09,0,0,0
+2021-07-27,USA-35055,Taos,New Mexico,1,2.71,8.29,0,0.14,0.44
 2021-07-27,USA-35053,Socorro,New Mexico,0,0.86,5.15,0,0,0
 2021-07-27,USA-35051,Sierra,New Mexico,0,0.57,5.3,0,0,0
-2021-07-27,USA-35049,Santa Fe,New Mexico,0,8.43,5.61,0,0,0
-2021-07-27,USA-35043,Sandoval,New Mexico,0,12,8.18,0,0,0
-2021-07-27,USA-35047,San Miguel,New Mexico,0,2.86,10.47,0,0,0
-2021-07-27,USA-35045,San Juan,New Mexico,0,11.43,9.22,0,0.14,0.12
-2021-07-27,USA-35041,Roosevelt,New Mexico,0,2.29,12.36,0,0,0
-2021-07-27,USA-35039,Rio Arriba,New Mexico,0,2.86,7.34,0,0.14,0.37
-2021-07-27,USA-35037,Quay,New Mexico,0,0.86,10.39,0,0,0
-2021-07-27,USA-35035,Otero,New Mexico,0,18.43,27.31,0,0.14,0.21
+2021-07-27,USA-35049,Santa Fe,New Mexico,9,9.71,6.46,0,0,0
+2021-07-27,USA-35043,Sandoval,New Mexico,14,14,9.54,0,0,0
+2021-07-27,USA-35047,San Miguel,New Mexico,3,3.29,12.05,0,0,0
+2021-07-27,USA-35045,San Juan,New Mexico,3,11.86,9.57,0,0.14,0.12
+2021-07-27,USA-35041,Roosevelt,New Mexico,2,2.57,13.9,0,0,0
+2021-07-27,USA-35039,Rio Arriba,New Mexico,9,4.14,10.64,0,0.14,0.37
+2021-07-27,USA-35037,Quay,New Mexico,2,1.14,13.85,0,0,0
+2021-07-27,USA-35035,Otero,New Mexico,13,20.29,30.06,0,0.14,0.21
 2021-07-27,USA-35033,Mora,New Mexico,0,0.14,3.16,0,0,0
-2021-07-27,USA-35031,McKinley,New Mexico,0,3.29,4.6,0,0.14,0.2
+2021-07-27,USA-35031,McKinley,New Mexico,4,3.86,5.4,0,0.14,0.2
 2021-07-27,USA-35029,Luna,New Mexico,0,1.57,6.63,0,0,0
 2021-07-27,USA-35028,Los Alamos,New Mexico,0,0.29,1.48,0,0,0
-2021-07-27,USA-35027,Lincoln,New Mexico,0,3.43,17.52,0,0,0
-2021-07-27,USA-35025,Lea,New Mexico,0,8.43,11.86,0,0,0
-2021-07-27,USA-35023,Hidalgo,New Mexico,0,2.86,68.06,0,0,0
+2021-07-27,USA-35027,Lincoln,New Mexico,5,4.14,21.17,0,0,0
+2021-07-27,USA-35025,Lea,New Mexico,24,11.86,16.68,1,0.14,0.2
+2021-07-27,USA-35023,Hidalgo,New Mexico,2,3.14,74.87,0,0,0
 2021-07-27,USA-35021,Harding,New Mexico,0,0,0,0,0,0
 2021-07-27,USA-35019,Guadalupe,New Mexico,0,0.14,3.32,0,0,0
-2021-07-27,USA-35017,Grant,New Mexico,0,0.86,3.17,0,0,0
-2021-07-27,USA-35015,Eddy,New Mexico,0,16.71,28.59,0,0.29,0.49
-2021-07-27,USA-35013,Doña Ana,New Mexico,0,11.43,5.24,0,0.14,0.07
+2021-07-27,USA-35017,Grant,New Mexico,1,1,3.7,0,0,0
+2021-07-27,USA-35015,Eddy,New Mexico,33,21.43,36.66,0,0.29,0.49
+2021-07-27,USA-35013,Doña Ana,New Mexico,12,13.14,6.02,0,0.14,0.07
 2021-07-27,USA-35011,De Baca,New Mexico,0,0,0,0,0,0
-2021-07-27,USA-35009,Curry,New Mexico,0,5.43,11.09,0,0,0
-2021-07-27,USA-35007,Colfax,New Mexico,0,0.71,5.98,0,0,0
-2021-07-27,USA-35006,Cibola,New Mexico,0,0.57,2.14,0,0,0
-2021-07-27,USA-35005,Chaves,New Mexico,0,6.43,9.95,0,0,0
+2021-07-27,USA-35009,Curry,New Mexico,11,7,14.3,0,0,0
+2021-07-27,USA-35007,Colfax,New Mexico,5,1.43,11.96,0,0,0
+2021-07-27,USA-35006,Cibola,New Mexico,1,0.71,2.68,0,0,0
+2021-07-27,USA-35005,Chaves,New Mexico,9,7.71,11.94,0,0,0
 2021-07-27,USA-35003,Catron,New Mexico,0,0.14,4.05,0,0.14,4.05
-2021-07-27,USA-35001,Bernalillo,New Mexico,0,67.57,9.95,0,0.29,0.04
+2021-07-27,USA-35001,Bernalillo,New Mexico,68,77.29,11.38,1,0.43,0.06
 2021-07-27,USA-34999,Unknown,New Jersey,3,1.75,,0,0,
 2021-07-27,USA-34041,Warren,New Jersey,4,3,2.85,0,0,0
 2021-07-27,USA-34039,Union,New Jersey,44,44.43,7.99,0,0.29,0.05
@@ -1561911,8 +1561911,8 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-32003,Clark,Nevada,951,803.43,35.44,17,12.57,0.55
 2021-07-27,USA-32001,Churchill,Nevada,7,2.14,8.6,0,0,0
 2021-07-27,USA-32510,Carson City,Nevada,7,5.14,9.2,0,0.14,0.26
-2021-07-27,USA-31999,Unknown,Nebraska,200,76.5,,0,0,
-2021-07-27,USA-31185,York,Nebraska,0,0.43,3.13,0,0.43,3.13
+2021-07-27,USA-31999,Unknown,Nebraska,123,63.67,,0,0,
+2021-07-27,USA-31185,York,Nebraska,6,1.29,9.4,0,0.43,3.13
 2021-07-27,USA-31183,Wheeler,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31181,Webster,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31179,Wayne,Nebraska,0,0.43,4.57,0,0,0
@@ -1561925,7 +1561925,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-31165,Sioux,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31163,Sherman,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31161,Sheridan,Nebraska,5,0.71,13.62,0,0,0
-2021-07-27,USA-31159,Seward,Nebraska,0,0.71,4.13,0,0,0
+2021-07-27,USA-31159,Seward,Nebraska,4,1.29,7.44,0,0,0
 2021-07-27,USA-31157,Scotts Bluff,Nebraska,19,2.71,7.62,0,0,0
 2021-07-27,USA-31155,Saunders,Nebraska,5,2.29,10.59,0,0,0
 2021-07-27,USA-31153,Sarpy,Nebraska,16,12.43,6.64,0,0,0
@@ -1561933,14 +1561933,14 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-31149,Rock,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31147,Richardson,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31145,Red Willow,Nebraska,0,0,0,0,0,0
-2021-07-27,USA-31143,Polk,Nebraska,0,0.14,2.74,0,0,0
+2021-07-27,USA-31143,Polk,Nebraska,2,0.43,8.22,0,0,0
 2021-07-27,USA-31141,Platte,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31139,Pierce,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31137,Phelps,Nebraska,0,0.14,1.58,0,0,0
 2021-07-27,USA-31135,Perkins,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31133,Pawnee,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31131,Otoe,Nebraska,0,0,0,0,0,0
-2021-07-27,USA-31129,Nuckolls,Nebraska,2,0.29,6.89,0,0,0
+2021-07-27,USA-31129,Nuckolls,Nebraska,3,0.43,10.33,0,0,0
 2021-07-27,USA-31127,Nemaha,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31125,Nance,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31123,Morrill,Nebraska,10,1.43,30.77,0,0,0
@@ -1561950,7 +1561950,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-31115,Loup,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31113,Logan,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31111,Lincoln,Nebraska,0,0,0,0,0,0
-2021-07-27,USA-31109,Lancaster,Nebraska,0,26.57,8.33,0,0,0
+2021-07-27,USA-31109,Lancaster,Nebraska,64,35.71,11.19,0,0,0
 2021-07-27,USA-31107,Knox,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31105,Kimball,Nebraska,0,0,0,0,0,0
 2021-07-27,USA-31103,Keya Paha,Nebraska,0,0,0,0,0,0
@@ -1562104,7 +1562104,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-29153,Ozark,Missouri,5,5.86,63.85,0,0,0
 2021-07-27,USA-29151,Osage,Missouri,19,6.29,46.17,0,0,0
 2021-07-27,USA-29149,Oregon,Missouri,6,8.14,77.34,0,0,0
-2021-07-27,USA-29147,Nodaway,Missouri,0,4.57,20.69,0,0.14,0.65
+2021-07-27,USA-29147,Nodaway,Missouri,13,6.43,29.1,1,0.29,1.29
 2021-07-27,USA-29145,Newton,Missouri,43,28.71,55.06,3,0.57,1.1
 2021-07-27,USA-29143,New Madrid,Missouri,1,2.57,15.06,0,0,0
 2021-07-27,USA-29141,Morgan,Missouri,16,10.57,51.25,0,0,0
@@ -1562114,7 +1562114,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-29133,Mississippi,Missouri,3,2,15.17,0,0,0
 2021-07-27,USA-29131,Miller,Missouri,26,18.71,73.05,1,0.14,0.56
 2021-07-27,USA-29129,Mercer,Missouri,0,0.83,23.04,0,0,0
-2021-07-27,USA-29119,McDonald,Missouri,0,9.57,41.91,0,0.14,0.63
+2021-07-27,USA-29119,McDonald,Missouri,48,16.43,71.94,0,0.14,0.63
 2021-07-27,USA-29127,Marion,Missouri,26,19.57,68.6,1,0.14,0.5
 2021-07-27,USA-29125,Maries,Missouri,7,5.71,65.7,0,0,0
 2021-07-27,USA-29123,Madison,Missouri,1,2.29,18.91,0,0,0
@@ -1562177,7 +1562177,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-29007,Audrain,Missouri,3,7.43,29.26,0,0,0
 2021-07-27,USA-29005,Atchison,Missouri,0,0.57,11.11,0,0,0
 2021-07-27,USA-29003,Andrew,Missouri,5,10,56.46,0,0,0
-2021-07-27,USA-29001,Adair,Missouri,0,7,27.62,0,0.29,1.13
+2021-07-27,USA-29001,Adair,Missouri,16,9.29,36.64,0,0.29,1.13
 2021-07-27,USA-28163,Yazoo,Mississippi,15,10.29,34.64,0,0.14,0.48
 2021-07-27,USA-28161,Yalobusha,Mississippi,2,1.71,14.16,0,0,0
 2021-07-27,USA-28159,Winston,Mississippi,3,3.29,18.3,0,0,0
@@ -1562690,7 +1562690,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-20181,Sherman,Kansas,0,1,16.9,0,0,0
 2021-07-27,USA-20179,Sheridan,Kansas,0,0,0,0,0,0
 2021-07-27,USA-20177,Shawnee,Kansas,0,35.86,20.27,0,0.57,0.32
-2021-07-27,USA-20175,Seward,Kansas,0,3.71,17.33,0,0,0
+2021-07-27,USA-20175,Seward,Kansas,7,4.71,22,0,0,0
 2021-07-27,USA-20173,Sedgwick,Kansas,0,90.29,17.5,0,1.29,0.25
 2021-07-27,USA-20171,Scott,Kansas,0,0,0,0,0,0
 2021-07-27,USA-20169,Saline,Kansas,0,15.14,27.93,0,0,0
@@ -1562702,7 +1562702,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-20157,Republic,Kansas,0,0,0,0,0,0
 2021-07-27,USA-20155,Reno,Kansas,0,8.14,13.13,0,0.14,0.23
 2021-07-27,USA-20153,Rawlins,Kansas,0,0,0,0,0,0
-2021-07-27,USA-20151,Pratt,Kansas,0,1.14,12.47,0,0,0
+2021-07-27,USA-20151,Pratt,Kansas,3,1.57,17.15,0,0,0
 2021-07-27,USA-20149,Pottawatomie,Kansas,0,7,28.71,0,0.29,1.17
 2021-07-27,USA-20147,Phillips,Kansas,0,0.57,10.92,0,0,0
 2021-07-27,USA-20145,Pawnee,Kansas,0,0.33,5.2,0,0,0
@@ -1562744,13 +1562744,13 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-20073,Greenwood,Kansas,0,1.71,28.66,0,0,0
 2021-07-27,USA-20071,Greeley,Kansas,0,0,0,0,0,0
 2021-07-27,USA-20069,Gray,Kansas,0,2.43,40.56,0,0,0
-2021-07-27,USA-20067,Grant,Kansas,0,0.86,11.99,0,0.14,2
+2021-07-27,USA-20067,Grant,Kansas,11,2.43,33.97,0,0.14,2
 2021-07-27,USA-20065,Graham,Kansas,0,0.29,11.51,0,0,0
 2021-07-27,USA-20063,Gove,Kansas,0,0.29,10.84,0,0,0
 2021-07-27,USA-20061,Geary,Kansas,0,8.71,27.52,0,0.14,0.45
 2021-07-27,USA-20059,Franklin,Kansas,0,8,31.32,0,0.29,1.12
 2021-07-27,USA-20057,Ford,Kansas,0,3.86,11.47,0,0.43,1.27
-2021-07-27,USA-20055,Finney,Kansas,0,0,0,0,0,0
+2021-07-27,USA-20055,Finney,Kansas,18,2.57,7.05,0,0,0
 2021-07-27,USA-20053,Ellsworth,Kansas,-9,0,0,0,0,0
 2021-07-27,USA-20051,Ellis,Kansas,0,1.29,4.5,0,0,0
 2021-07-27,USA-20049,Elk,Kansas,0,0.29,11.29,0,0,0
@@ -1562970,7 +1562970,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-18005,Bartholomew,Indiana,6,6.43,7.67,0,0,0
 2021-07-27,USA-18003,Allen,Indiana,80,66.14,17.44,0,0,0
 2021-07-27,USA-18001,Adams,Indiana,6,4.43,12.38,0,0,0
-2021-07-27,USA-17999,Unknown,Illinois,0,0,,0,2,
+2021-07-27,USA-17999,Unknown,Illinois,0,0,,-1,2.33,
 2021-07-27,USA-17203,Woodford,Illinois,2,2.43,6.31,0,0,0
 2021-07-27,USA-17201,Winnebago,Illinois,22,29.86,10.57,0,0.29,0.1
 2021-07-27,USA-17199,Williamson,Illinois,53,39,58.56,0,0,0
@@ -1563001,7 +1563001,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-17149,Pike,Illinois,13,8.57,55.08,0,0,0
 2021-07-27,USA-17147,Piatt,Illinois,5,1.57,9.61,0,0,0
 2021-07-27,USA-17145,Perry,Illinois,3,4.86,23.22,1,0.29,1.37
-2021-07-27,USA-17143,Peoria,Illinois,10,4.14,2.31,0,0,0
+2021-07-27,USA-17143,Peoria,Illinois,107,18,10.05,1,0.14,0.08
 2021-07-27,USA-17141,Ogle,Illinois,6,3.71,7.33,0,0,0
 2021-07-27,USA-17139,Moultrie,Illinois,5,3.14,21.67,0,0,0
 2021-07-27,USA-17137,Morgan,Illinois,0,9,26.74,0,0,0
@@ -1563428,60 +1563428,60 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-27,USA-08005,Arapahoe,Colorado,81,67.14,10.23,0,0.14,0.02
 2021-07-27,USA-08003,Alamosa,Colorado,0,2.29,14.08,0,0.14,0.88
 2021-07-27,USA-08001,Adams,Colorado,78,62.86,12.15,0,0.29,0.06
-2021-07-27,USA-06115,Yuba,California,0,17.14,21.79,0,0,0
+2021-07-27,USA-06115,Yuba,California,38,22.57,28.69,0,0,0
 2021-07-27,USA-06113,Yolo,California,34,41.14,18.66,0,0.29,0.13
 2021-07-27,USA-06111,Ventura,California,0,95.86,11.33,0,0,0
-2021-07-27,USA-06109,Tuolumne,California,0,13.29,24.39,0,0,0
+2021-07-27,USA-06109,Tuolumne,California,30,17.57,32.25,0,0,0
 2021-07-27,USA-06107,Tulare,California,44,38.71,8.3,0,0,0
 2021-07-27,USA-06105,Trinity,California,0,1,8.14,0,0,0
 2021-07-27,USA-06103,Tehama,California,2,4.43,6.8,0,0.14,0.22
-2021-07-27,USA-06101,Sutter,California,0,18.29,18.86,0,0.14,0.15
+2021-07-27,USA-06101,Sutter,California,26,22,22.69,0,0.14,0.15
 2021-07-27,USA-06099,Stanislaus,California,136,104,18.89,0,0.43,0.08
 2021-07-27,USA-06097,Sonoma,California,123,77.43,15.66,0,0.29,0.06
 2021-07-27,USA-06095,Solano,California,0,103,23.01,0,0.17,0.04
-2021-07-27,USA-06093,Siskiyou,California,0,5.29,12.14,0,0,0
+2021-07-27,USA-06093,Siskiyou,California,10,6.71,15.42,0,0,0
 2021-07-27,USA-06091,Sierra,California,0,0.14,4.75,0,0,0
 2021-07-27,USA-06089,Shasta,California,31,18.14,10.07,0,0,0
 2021-07-27,USA-06087,Santa Cruz,California,0,15.29,5.59,0,0,0
 2021-07-27,USA-06085,Santa Clara,California,191,210.14,10.9,0,0.14,0.01
-2021-07-27,USA-06083,Santa Barbara,California,0,40.43,9.05,0,0.86,0.19
+2021-07-27,USA-06083,Santa Barbara,California,138,60.14,13.47,0,0.86,0.19
 2021-07-27,USA-06081,San Mateo,California,108,104.86,13.68,0,0.57,0.07
 2021-07-27,USA-06079,San Luis Obispo,California,229,36.14,12.77,1,0.14,0.05
-2021-07-27,USA-06077,San Joaquin,California,0,76.29,10.01,0,0,0
+2021-07-27,USA-06077,San Joaquin,California,881,202.14,26.52,14,2,0.26
 2021-07-27,USA-06075,San Francisco,California,137,191,21.67,0,0.5,0.06
 2021-07-27,USA-06073,San Diego,California,2062,713.29,21.37,0,1,0.03
 2021-07-27,USA-06071,San Bernardino,California,902,322.43,14.79,0,1.4,0.06
 2021-07-27,USA-06069,San Benito,California,5,4.14,6.6,0,0,0
 2021-07-27,USA-06067,Sacramento,California,333,361.57,23.3,4,1.86,0.12
 2021-07-27,USA-06065,Riverside,California,1247,681,27.56,1,1.71,0.07
-2021-07-27,USA-06063,Plumas,California,0,2.71,14.43,0,0,0
+2021-07-27,USA-06063,Plumas,California,2,3,15.95,0,0,0
 2021-07-27,USA-06061,Placer,California,200,85.14,21.38,3,0.43,0.11
 2021-07-27,USA-06059,Orange,California,505,452.14,14.24,0,0.57,0.02
 2021-07-27,USA-06057,Nevada,California,24,21,21.05,0,0,0
 2021-07-27,USA-06055,Napa,California,16,21.71,15.76,0,0.14,0.1
 2021-07-27,USA-06053,Monterey,California,40,26.86,6.19,2,1.14,0.26
-2021-07-27,USA-06051,Mono,California,0,0.57,3.96,0,0,0
+2021-07-27,USA-06051,Mono,California,3,1,6.92,0,0,0
 2021-07-27,USA-06049,Modoc,California,0,0,0,0,0,0
 2021-07-27,USA-06047,Merced,California,0,25.57,9.21,0,0,0
 2021-07-27,USA-06045,Mendocino,California,57,14.86,17.13,0,0,0
-2021-07-27,USA-06043,Mariposa,California,0,3.5,20.35,0,0,0
+2021-07-27,USA-06043,Mariposa,California,1,3.67,21.31,0,0,0
 2021-07-27,USA-06041,Marin,California,21,30,11.59,0,0.71,0.28
 2021-07-27,USA-06039,Madera,California,24,17.86,11.35,0,0.14,0.09
-2021-07-27,USA-06037,Los Angeles,California,0,2127,21.19,4,6.71,0.07
-2021-07-27,USA-06035,Lassen,California,1,1.57,5.14,0,0.29,0.93
+2021-07-27,USA-06037,Los Angeles,California,2060,2421.29,24.12,4,6.71,0.07
+2021-07-27,USA-06035,Lassen,California,1,1.57,5.14,-2,0.33,1.09
 2021-07-27,USA-06033,Lake,California,24,40.71,63.23,0,0.14,0.22
 2021-07-27,USA-06031,Kings,California,36,34.29,22.42,1,0.29,0.19
 2021-07-27,USA-06029,Kern,California,175,129.14,14.35,1,0.57,0.06
-2021-07-27,USA-06027,Inyo,California,0,0,0,0,0,0
+2021-07-27,USA-06027,Inyo,California,7,1,5.54,0,0,0
 2021-07-27,USA-06025,Imperial,California,-3,24.83,13.7,0,0.14,0.08
-2021-07-27,USA-06023,Humboldt,California,0,24.71,18.23,0,0,0
-2021-07-27,USA-06021,Glenn,California,0,0.86,3.02,0,0,0
+2021-07-27,USA-06023,Humboldt,California,18,27.29,20.13,0,0,0
+2021-07-27,USA-06021,Glenn,California,4,1.43,5.03,0,0,0
 2021-07-27,USA-06019,Fresno,California,124,113.29,11.34,0,1.57,0.16
 2021-07-27,USA-06017,El Dorado,California,21,28,14.52,0,0.29,0.15
 2021-07-27,USA-06015,Del Norte,California,0,6.29,22.6,0,0,0
 2021-07-27,USA-06013,Contra Costa,California,368,297.86,25.82,0,0.71,0.06
 2021-07-27,USA-06011,Colusa,California,0,2.43,11.27,0,0,0
-2021-07-27,USA-06009,Calaveras,California,1,2.86,6.22,0,0,0
+2021-07-27,USA-06009,Calaveras,California,6,3.57,7.78,0,0,0
 2021-07-27,USA-06007,Butte,California,8,25.86,11.8,0,0.14,0.07
 2021-07-27,USA-06005,Amador,California,6,7.43,18.69,0,0,0
 2021-07-27,USA-06003,Alpine,California,0,0,0,0,0,0