Updating data.

diff --git a/rolling-averages/anomalies.csv b/rolling-averages/anomalies.csv
index 399234d..98260a0 100644 (file)
--- a/rolling-averages/anomalies.csv
+++ b/rolling-averages/anomalies.csv
@@ -553,7 +553,7 @@ date,end_date,county,state,geoid,type,omit_from_rolling_average,omit_from_rollin
 2021-06-19,,Gray,Texas,USA-48179,cases,yes,,Texas added a backlog of cases in Gray County.
 2021-06-19,,Hutchinson,Texas,USA-48233,cases,yes,,Texas added a backlog of cases in Hutchinson County.
 2021-06-19,,Bowie,Texas,USA-48037,cases,yes,,Texas added a backlog of cases in Bowie County.
-2021-06-19,2021-06-30,Nacogdoches,Texas,USA-48347,cases,yes,,Texas added a backlog of cases in Nacogdoches County.
+2021-06-19,2021-07-01,Nacogdoches,Texas,USA-48347,cases,yes,,Texas added a backlog of cases in Nacogdoches County.
 2021-06-19,,San Jacinto,Texas,USA-48407,cases,yes,,Texas added a backlog of cases in San Jacinto County.
 2021-06-19,,Shelby,Texas,USA-48419,cases,yes,,Texas added a backlog of cases in Shelby County.
 2021-06-19,2021-06-26,Upshur,Texas,USA-48459,cases,yes,,Texas added a backlog of cases in Upshur County.
@@ -596,7 +596,7 @@ date,end_date,county,state,geoid,type,omit_from_rolling_average,omit_from_rollin
 2021-06-23,2021-06-24,Morris,Texas,USA-48343,cases,yes,,Texas added a backlog of cases in Morris County.
 2021-06-23,2021-07-01,Red River,Texas,USA-48387,cases,yes,,Texas added a backlog of cases in Red River County.
 2021-06-23,,San Jacinto,Texas,USA-48407,cases,yes,,Texas added a backlog of cases in San Jacinto County.
-2021-06-23,2021-07-01,Shelby,Texas,USA-48419,cases,yes,,Texas added a backlog of cases in Shelby County.
+2021-06-23,2021-07-03,Shelby,Texas,USA-48419,cases,yes,,Texas added a backlog of cases in Shelby County.
 2021-06-23,2021-07-01,Titus,Texas,USA-48449,cases,yes,,Texas added a backlog of cases in Titus County.
 2021-06-23,2021-06-24,Trinity,Texas,USA-48455,cases,yes,,Texas added a backlog of cases in Trinity County.
 2021-06-24,,Harris,Texas,USA-48201,cases,yes,,Harris County removed more than 100 cases.
@@ -607,7 +607,9 @@ date,end_date,county,state,geoid,type,omit_from_rolling_average,omit_from_rollin
 2021-06-30,,,California,USA-06,cases,yes,yes,California removed many duplicate and incorrectly categorized cases.
 2021-06-30,,,West Virginia,USA-54,deaths,yes,,West Virginia added 11 deaths that occurred in late 2020 and early 2021. 
 2021-06-30,2021-07-02,Davidson,Tennessee,USA-47037,cases,yes,,Davidson County removed many cases.
+2021-06-30,2021-07-07,Richmond,Virginia,USA-51159,cases,yes,,Virginia removed many cases in Richmond County.
 2021-07-01,,Butler,Ohio,USA-39017,cases,yes,,Ohio added a backlog of cases in Butler County.
 2021-07-02,,,,USA,deaths,yes,,"Santa Clara County, Calif., officials revised their total death toll downward after a review of records."
 2021-07-02,,,California,USA-06,deaths,yes,,Santa Clara County removed many deaths from causes unrelated to Covid-19.
-2021-07-02,,Santa Clara,California,USA-06085,deaths,yes,,Santa Clara County removed many deaths from causes unrelated to Covid-19.
\ No newline at end of file
+2021-07-02,,Santa Clara,California,USA-06085,deaths,yes,,Santa Clara County removed many deaths from causes unrelated to Covid-19.
+2021-07-07,,Richmond city,Virginia,USA-51760,cases,yes,,Virginia added many cases in Richmond after removing many cases the previous week.
\ No newline at end of file

diff --git a/rolling-averages/us-counties-recent.csv b/rolling-averages/us-counties-recent.csv
index 5895040..8688abd 100644 (file)
--- a/rolling-averages/us-counties-recent.csv
+++ b/rolling-averages/us-counties-recent.csv
@@ -75210,7 +75210,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-01,USA-48353,Nolan,Texas,0,0,0,0,0,0
 2021-07-01,USA-48351,Newton,Texas,0,0.29,2.1,0,0,0
 2021-07-01,USA-48349,Navarro,Texas,0,1.57,3.14,0,0,0
-2021-07-01,USA-48347,Nacogdoches,Texas,37,37,56.74,1,0.14,0.22
+2021-07-01,USA-48347,Nacogdoches,Texas,37,0,0,1,0.14,0.22
 2021-07-01,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-01,USA-48343,Morris,Texas,0,3.14,25.37,0,0,0
 2021-07-01,USA-48341,Moore,Texas,2,0.86,4.09,0,0,0
@@ -78420,7 +78420,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-02,USA-48425,Somervell,Texas,0,0.43,4.7,0,0,0
 2021-07-02,USA-48423,Smith,Texas,33,9.57,4.11,0,0,0
 2021-07-02,USA-48421,Sherman,Texas,0,0,0,0,0,0
-2021-07-02,USA-48419,Shelby,Texas,40,40,158.27,0,0.17,0.66
+2021-07-02,USA-48419,Shelby,Texas,40,0,0,0,0.17,0.66
 2021-07-02,USA-48417,Shackelford,Texas,0,0,0,0,0,0
 2021-07-02,USA-48415,Scurry,Texas,2,0.67,3.99,0,0,0
 2021-07-02,USA-48413,Schleicher,Texas,0,0,0,0,0,0
@@ -78456,7 +78456,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-02,USA-48353,Nolan,Texas,0,0,0,0,0,0
 2021-07-02,USA-48351,Newton,Texas,1,0.43,3.15,0,0,0
 2021-07-02,USA-48349,Navarro,Texas,5,1.71,3.42,0,0,0
-2021-07-02,USA-48347,Nacogdoches,Texas,1,19,29.14,0,0.14,0.22
+2021-07-02,USA-48347,Nacogdoches,Texas,1,1,1.53,0,0.14,0.22
 2021-07-02,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-02,USA-48343,Morris,Texas,1,1.71,13.84,0,0,0
 2021-07-02,USA-48341,Moore,Texas,0,0.86,4.09,0,0,0
@@ -81666,7 +81666,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-03,USA-48425,Somervell,Texas,0,0.43,4.7,0,0,0
 2021-07-03,USA-48423,Smith,Texas,0,9.57,4.11,1,0.14,0.06
 2021-07-03,USA-48421,Sherman,Texas,0,0,0,0,0,0
-2021-07-03,USA-48419,Shelby,Texas,31,35.5,140.46,0,0.14,0.57
+2021-07-03,USA-48419,Shelby,Texas,31,0,0,0,0.14,0.57
 2021-07-03,USA-48417,Shackelford,Texas,0,0,0,0,0,0
 2021-07-03,USA-48415,Scurry,Texas,1,0.83,4.99,0,0,0
 2021-07-03,USA-48413,Schleicher,Texas,0,0,0,0,0,0
@@ -81702,7 +81702,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-03,USA-48353,Nolan,Texas,2,0.29,1.94,0,0,0
 2021-07-03,USA-48351,Newton,Texas,0,0.43,3.15,0,0,0
 2021-07-03,USA-48349,Navarro,Texas,0,1.71,3.42,0,0,0
-2021-07-03,USA-48347,Nacogdoches,Texas,2,13.33,20.45,0,0.14,0.22
+2021-07-03,USA-48347,Nacogdoches,Texas,2,1.5,2.3,0,0.14,0.22
 2021-07-03,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-03,USA-48343,Morris,Texas,3,2.14,17.3,0,0,0
 2021-07-03,USA-48341,Moore,Texas,0,0.43,2.05,0,0,0
@@ -84717,7 +84717,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-04,USA-51770,Roanoke city,Virginia,4,4.29,4.32,0,0.29,0.29
 2021-07-04,USA-51161,Roanoke,Virginia,2,2.14,2.28,0,0,0
 2021-07-04,USA-51760,Richmond city,Virginia,3,4.5,1.95,0,0.17,0.07
-2021-07-04,USA-51159,Richmond,Virginia,0,0.67,7.39,0,0,0
+2021-07-04,USA-51159,Richmond,Virginia,0,1,11.08,0,0,0
 2021-07-04,USA-51157,Rappahannock,Virginia,1,0.57,7.75,0,0,0
 2021-07-04,USA-51750,Radford city,Virginia,0,0.14,0.78,0,0,0
 2021-07-04,USA-51155,Pulaski,Virginia,0,2,5.88,0,0,0
@@ -84911,7 +84911,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-04,USA-48425,Somervell,Texas,0,0.43,4.7,0,0,0
 2021-07-04,USA-48423,Smith,Texas,0,9.57,4.11,1,0.29,0.12
 2021-07-04,USA-48421,Sherman,Texas,0,0,0,0,0,0
-2021-07-04,USA-48419,Shelby,Texas,0,23.67,93.64,1,0.29,1.13
+2021-07-04,USA-48419,Shelby,Texas,0,0,0,1,0.29,1.13
 2021-07-04,USA-48417,Shackelford,Texas,0,0,0,0,0,0
 2021-07-04,USA-48415,Scurry,Texas,1,1,5.99,0,0,0
 2021-07-04,USA-48413,Schleicher,Texas,0,0,0,0,0,0
@@ -84947,7 +84947,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-04,USA-48353,Nolan,Texas,0,0.29,1.94,0,0,0
 2021-07-04,USA-48351,Newton,Texas,0,0.43,3.15,0,0,0
 2021-07-04,USA-48349,Navarro,Texas,0,1.71,3.42,0,0,0
-2021-07-04,USA-48347,Nacogdoches,Texas,1,10.25,15.72,0,0.14,0.22
+2021-07-04,USA-48347,Nacogdoches,Texas,1,1.33,2.04,0,0.14,0.22
 2021-07-04,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-04,USA-48343,Morris,Texas,0,1.86,14.99,0,0,0
 2021-07-04,USA-48341,Moore,Texas,0,0.43,2.05,0,0,0
@@ -87962,7 +87962,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-05,USA-51770,Roanoke city,Virginia,6,5,5.04,0,0.29,0.29
 2021-07-05,USA-51161,Roanoke,Virginia,5,2.86,3.03,0,0,0
 2021-07-05,USA-51760,Richmond city,Virginia,3,3,1.3,0,0.17,0.07
-2021-07-05,USA-51159,Richmond,Virginia,0,0.33,3.69,0,0,0
+2021-07-05,USA-51159,Richmond,Virginia,0,1,11.08,0,0,0
 2021-07-05,USA-51157,Rappahannock,Virginia,3,1,13.57,0,0,0
 2021-07-05,USA-51750,Radford city,Virginia,0,0.14,0.78,0,0,0
 2021-07-05,USA-51155,Pulaski,Virginia,1,2.14,6.3,0,0,0
@@ -88156,7 +88156,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-05,USA-48425,Somervell,Texas,0,0.43,4.7,0,0,0
 2021-07-05,USA-48423,Smith,Texas,0,4.71,2.03,0,0.29,0.12
 2021-07-05,USA-48421,Sherman,Texas,0,0,0,0,0,0
-2021-07-05,USA-48419,Shelby,Texas,0,17.75,70.23,0,0.14,0.57
+2021-07-05,USA-48419,Shelby,Texas,0,0,0,0,0.14,0.57
 2021-07-05,USA-48417,Shackelford,Texas,0,0,0,0,0,0
 2021-07-05,USA-48415,Scurry,Texas,0,1,5.99,0,0,0
 2021-07-05,USA-48413,Schleicher,Texas,0,0,0,0,0,0
@@ -88192,7 +88192,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-05,USA-48353,Nolan,Texas,0,0.29,1.94,0,0,0
 2021-07-05,USA-48351,Newton,Texas,0,0.43,3.15,0,0,0
 2021-07-05,USA-48349,Navarro,Texas,0,1.71,3.42,0,0,0
-2021-07-05,USA-48347,Nacogdoches,Texas,0,8.2,12.58,0,0.14,0.22
+2021-07-05,USA-48347,Nacogdoches,Texas,0,1,1.53,0,0.14,0.22
 2021-07-05,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-05,USA-48343,Morris,Texas,0,1.71,13.84,0,0,0
 2021-07-05,USA-48341,Moore,Texas,0,0.43,2.05,0,0,0
@@ -91401,7 +91401,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-06,USA-48425,Somervell,Texas,1,0.29,3.13,0,0,0
 2021-07-06,USA-48423,Smith,Texas,0,4.71,2.03,0,0.29,0.12
 2021-07-06,USA-48421,Sherman,Texas,0,0,0,0,0,0
-2021-07-06,USA-48419,Shelby,Texas,1,14.4,56.98,0,0.14,0.57
+2021-07-06,USA-48419,Shelby,Texas,1,0.33,1.32,0,0.14,0.57
 2021-07-06,USA-48417,Shackelford,Texas,0,0,0,0,0,0
 2021-07-06,USA-48415,Scurry,Texas,1,0.83,4.99,0,0,0
 2021-07-06,USA-48413,Schleicher,Texas,0,0,0,0,0,0
@@ -91437,7 +91437,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-06,USA-48353,Nolan,Texas,0,0.29,1.94,0,0,0
 2021-07-06,USA-48351,Newton,Texas,0,0.14,1.05,0,0,0
 2021-07-06,USA-48349,Navarro,Texas,0,1.43,2.85,0,0,0
-2021-07-06,USA-48347,Nacogdoches,Texas,0,6.83,10.48,0,0.14,0.22
+2021-07-06,USA-48347,Nacogdoches,Texas,0,0.8,1.23,0,0.14,0.22
 2021-07-06,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-06,USA-48343,Morris,Texas,3,1.29,10.38,0,0,0
 2021-07-06,USA-48341,Moore,Texas,1,0.43,2.05,0,0,0
@@ -94451,7 +94451,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-07,USA-51163,Rockbridge,Virginia,0,0.71,3.16,0,0,0
 2021-07-07,USA-51770,Roanoke city,Virginia,1,4.43,4.47,0,0.14,0.14
 2021-07-07,USA-51161,Roanoke,Virginia,12,4.43,4.7,0,0,0
-2021-07-07,USA-51760,Richmond city,Virginia,146,50.67,21.99,0,0,0
+2021-07-07,USA-51760,Richmond city,Virginia,146,3,1.3,0,0,0
 2021-07-07,USA-51159,Richmond,Virginia,-64,0,0,0,0,0
 2021-07-07,USA-51157,Rappahannock,Virginia,-1,1,13.57,0,0,0
 2021-07-07,USA-51750,Radford city,Virginia,1,0.43,2.35,0,0,0
@@ -94646,7 +94646,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-07,USA-48425,Somervell,Texas,0,0.29,3.13,0,0,0
 2021-07-07,USA-48423,Smith,Texas,47,11.43,4.91,0,0.29,0.12
 2021-07-07,USA-48421,Sherman,Texas,1,0.14,4.73,0,0,0
-2021-07-07,USA-48419,Shelby,Texas,1,12.17,48.14,0,0.14,0.57
+2021-07-07,USA-48419,Shelby,Texas,1,0.5,1.98,0,0.14,0.57
 2021-07-07,USA-48417,Shackelford,Texas,0,0,0,0,0,0
 2021-07-07,USA-48415,Scurry,Texas,-1,0.83,4.99,0,0,0
 2021-07-07,USA-48413,Schleicher,Texas,0,0,0,0,0,0
@@ -94682,7 +94682,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-07,USA-48353,Nolan,Texas,3,0.71,4.85,0,0,0
 2021-07-07,USA-48351,Newton,Texas,0,0.14,1.05,0,0,0
 2021-07-07,USA-48349,Navarro,Texas,9,2,3.99,0,0,0
-2021-07-07,USA-48347,Nacogdoches,Texas,1,6,9.2,0,0.14,0.22
+2021-07-07,USA-48347,Nacogdoches,Texas,1,0.83,1.28,0,0.14,0.22
 2021-07-07,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-07,USA-48343,Morris,Texas,4,1.57,12.69,0,0,0
 2021-07-07,USA-48341,Moore,Texas,4,1,4.78,0,0,0

diff --git a/rolling-averages/us-counties.csv b/rolling-averages/us-counties.csv
index 27c1bdb..0a3a41c 100644 (file)
--- a/rolling-averages/us-counties.csv
+++ b/rolling-averages/us-counties.csv
@@ -1476537,7 +1476537,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-01,USA-48353,Nolan,Texas,0,0,0,0,0,0
 2021-07-01,USA-48351,Newton,Texas,0,0.29,2.1,0,0,0
 2021-07-01,USA-48349,Navarro,Texas,0,1.57,3.14,0,0,0
-2021-07-01,USA-48347,Nacogdoches,Texas,37,37,56.74,1,0.14,0.22
+2021-07-01,USA-48347,Nacogdoches,Texas,37,0,0,1,0.14,0.22
 2021-07-01,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-01,USA-48343,Morris,Texas,0,3.14,25.37,0,0,0
 2021-07-01,USA-48341,Moore,Texas,2,0.86,4.09,0,0,0
@@ -1479747,7 +1479747,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-02,USA-48425,Somervell,Texas,0,0.43,4.7,0,0,0
 2021-07-02,USA-48423,Smith,Texas,33,9.57,4.11,0,0,0
 2021-07-02,USA-48421,Sherman,Texas,0,0,0,0,0,0
-2021-07-02,USA-48419,Shelby,Texas,40,40,158.27,0,0.17,0.66
+2021-07-02,USA-48419,Shelby,Texas,40,0,0,0,0.17,0.66
 2021-07-02,USA-48417,Shackelford,Texas,0,0,0,0,0,0
 2021-07-02,USA-48415,Scurry,Texas,2,0.67,3.99,0,0,0
 2021-07-02,USA-48413,Schleicher,Texas,0,0,0,0,0,0
@@ -1479783,7 +1479783,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-02,USA-48353,Nolan,Texas,0,0,0,0,0,0
 2021-07-02,USA-48351,Newton,Texas,1,0.43,3.15,0,0,0
 2021-07-02,USA-48349,Navarro,Texas,5,1.71,3.42,0,0,0
-2021-07-02,USA-48347,Nacogdoches,Texas,1,19,29.14,0,0.14,0.22
+2021-07-02,USA-48347,Nacogdoches,Texas,1,1,1.53,0,0.14,0.22
 2021-07-02,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-02,USA-48343,Morris,Texas,1,1.71,13.84,0,0,0
 2021-07-02,USA-48341,Moore,Texas,0,0.86,4.09,0,0,0
@@ -1482993,7 +1482993,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-03,USA-48425,Somervell,Texas,0,0.43,4.7,0,0,0
 2021-07-03,USA-48423,Smith,Texas,0,9.57,4.11,1,0.14,0.06
 2021-07-03,USA-48421,Sherman,Texas,0,0,0,0,0,0
-2021-07-03,USA-48419,Shelby,Texas,31,35.5,140.46,0,0.14,0.57
+2021-07-03,USA-48419,Shelby,Texas,31,0,0,0,0.14,0.57
 2021-07-03,USA-48417,Shackelford,Texas,0,0,0,0,0,0
 2021-07-03,USA-48415,Scurry,Texas,1,0.83,4.99,0,0,0
 2021-07-03,USA-48413,Schleicher,Texas,0,0,0,0,0,0
@@ -1483029,7 +1483029,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-03,USA-48353,Nolan,Texas,2,0.29,1.94,0,0,0
 2021-07-03,USA-48351,Newton,Texas,0,0.43,3.15,0,0,0
 2021-07-03,USA-48349,Navarro,Texas,0,1.71,3.42,0,0,0
-2021-07-03,USA-48347,Nacogdoches,Texas,2,13.33,20.45,0,0.14,0.22
+2021-07-03,USA-48347,Nacogdoches,Texas,2,1.5,2.3,0,0.14,0.22
 2021-07-03,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-03,USA-48343,Morris,Texas,3,2.14,17.3,0,0,0
 2021-07-03,USA-48341,Moore,Texas,0,0.43,2.05,0,0,0
@@ -1486044,7 +1486044,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-04,USA-51770,Roanoke city,Virginia,4,4.29,4.32,0,0.29,0.29
 2021-07-04,USA-51161,Roanoke,Virginia,2,2.14,2.28,0,0,0
 2021-07-04,USA-51760,Richmond city,Virginia,3,4.5,1.95,0,0.17,0.07
-2021-07-04,USA-51159,Richmond,Virginia,0,0.67,7.39,0,0,0
+2021-07-04,USA-51159,Richmond,Virginia,0,1,11.08,0,0,0
 2021-07-04,USA-51157,Rappahannock,Virginia,1,0.57,7.75,0,0,0
 2021-07-04,USA-51750,Radford city,Virginia,0,0.14,0.78,0,0,0
 2021-07-04,USA-51155,Pulaski,Virginia,0,2,5.88,0,0,0
@@ -1486238,7 +1486238,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-04,USA-48425,Somervell,Texas,0,0.43,4.7,0,0,0
 2021-07-04,USA-48423,Smith,Texas,0,9.57,4.11,1,0.29,0.12
 2021-07-04,USA-48421,Sherman,Texas,0,0,0,0,0,0
-2021-07-04,USA-48419,Shelby,Texas,0,23.67,93.64,1,0.29,1.13
+2021-07-04,USA-48419,Shelby,Texas,0,0,0,1,0.29,1.13
 2021-07-04,USA-48417,Shackelford,Texas,0,0,0,0,0,0
 2021-07-04,USA-48415,Scurry,Texas,1,1,5.99,0,0,0
 2021-07-04,USA-48413,Schleicher,Texas,0,0,0,0,0,0
@@ -1486274,7 +1486274,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-04,USA-48353,Nolan,Texas,0,0.29,1.94,0,0,0
 2021-07-04,USA-48351,Newton,Texas,0,0.43,3.15,0,0,0
 2021-07-04,USA-48349,Navarro,Texas,0,1.71,3.42,0,0,0
-2021-07-04,USA-48347,Nacogdoches,Texas,1,10.25,15.72,0,0.14,0.22
+2021-07-04,USA-48347,Nacogdoches,Texas,1,1.33,2.04,0,0.14,0.22
 2021-07-04,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-04,USA-48343,Morris,Texas,0,1.86,14.99,0,0,0
 2021-07-04,USA-48341,Moore,Texas,0,0.43,2.05,0,0,0
@@ -1489289,7 +1489289,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-05,USA-51770,Roanoke city,Virginia,6,5,5.04,0,0.29,0.29
 2021-07-05,USA-51161,Roanoke,Virginia,5,2.86,3.03,0,0,0
 2021-07-05,USA-51760,Richmond city,Virginia,3,3,1.3,0,0.17,0.07
-2021-07-05,USA-51159,Richmond,Virginia,0,0.33,3.69,0,0,0
+2021-07-05,USA-51159,Richmond,Virginia,0,1,11.08,0,0,0
 2021-07-05,USA-51157,Rappahannock,Virginia,3,1,13.57,0,0,0
 2021-07-05,USA-51750,Radford city,Virginia,0,0.14,0.78,0,0,0
 2021-07-05,USA-51155,Pulaski,Virginia,1,2.14,6.3,0,0,0
@@ -1489483,7 +1489483,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-05,USA-48425,Somervell,Texas,0,0.43,4.7,0,0,0
 2021-07-05,USA-48423,Smith,Texas,0,4.71,2.03,0,0.29,0.12
 2021-07-05,USA-48421,Sherman,Texas,0,0,0,0,0,0
-2021-07-05,USA-48419,Shelby,Texas,0,17.75,70.23,0,0.14,0.57
+2021-07-05,USA-48419,Shelby,Texas,0,0,0,0,0.14,0.57
 2021-07-05,USA-48417,Shackelford,Texas,0,0,0,0,0,0
 2021-07-05,USA-48415,Scurry,Texas,0,1,5.99,0,0,0
 2021-07-05,USA-48413,Schleicher,Texas,0,0,0,0,0,0
@@ -1489519,7 +1489519,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-05,USA-48353,Nolan,Texas,0,0.29,1.94,0,0,0
 2021-07-05,USA-48351,Newton,Texas,0,0.43,3.15,0,0,0
 2021-07-05,USA-48349,Navarro,Texas,0,1.71,3.42,0,0,0
-2021-07-05,USA-48347,Nacogdoches,Texas,0,8.2,12.58,0,0.14,0.22
+2021-07-05,USA-48347,Nacogdoches,Texas,0,1,1.53,0,0.14,0.22
 2021-07-05,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-05,USA-48343,Morris,Texas,0,1.71,13.84,0,0,0
 2021-07-05,USA-48341,Moore,Texas,0,0.43,2.05,0,0,0
@@ -1492728,7 +1492728,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-06,USA-48425,Somervell,Texas,1,0.29,3.13,0,0,0
 2021-07-06,USA-48423,Smith,Texas,0,4.71,2.03,0,0.29,0.12
 2021-07-06,USA-48421,Sherman,Texas,0,0,0,0,0,0
-2021-07-06,USA-48419,Shelby,Texas,1,14.4,56.98,0,0.14,0.57
+2021-07-06,USA-48419,Shelby,Texas,1,0.33,1.32,0,0.14,0.57
 2021-07-06,USA-48417,Shackelford,Texas,0,0,0,0,0,0
 2021-07-06,USA-48415,Scurry,Texas,1,0.83,4.99,0,0,0
 2021-07-06,USA-48413,Schleicher,Texas,0,0,0,0,0,0
@@ -1492764,7 +1492764,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-06,USA-48353,Nolan,Texas,0,0.29,1.94,0,0,0
 2021-07-06,USA-48351,Newton,Texas,0,0.14,1.05,0,0,0
 2021-07-06,USA-48349,Navarro,Texas,0,1.43,2.85,0,0,0
-2021-07-06,USA-48347,Nacogdoches,Texas,0,6.83,10.48,0,0.14,0.22
+2021-07-06,USA-48347,Nacogdoches,Texas,0,0.8,1.23,0,0.14,0.22
 2021-07-06,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-06,USA-48343,Morris,Texas,3,1.29,10.38,0,0,0
 2021-07-06,USA-48341,Moore,Texas,1,0.43,2.05,0,0,0
@@ -1495778,7 +1495778,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-07,USA-51163,Rockbridge,Virginia,0,0.71,3.16,0,0,0
 2021-07-07,USA-51770,Roanoke city,Virginia,1,4.43,4.47,0,0.14,0.14
 2021-07-07,USA-51161,Roanoke,Virginia,12,4.43,4.7,0,0,0
-2021-07-07,USA-51760,Richmond city,Virginia,146,50.67,21.99,0,0,0
+2021-07-07,USA-51760,Richmond city,Virginia,146,3,1.3,0,0,0
 2021-07-07,USA-51159,Richmond,Virginia,-64,0,0,0,0,0
 2021-07-07,USA-51157,Rappahannock,Virginia,-1,1,13.57,0,0,0
 2021-07-07,USA-51750,Radford city,Virginia,1,0.43,2.35,0,0,0
@@ -1495973,7 +1495973,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-07,USA-48425,Somervell,Texas,0,0.29,3.13,0,0,0
 2021-07-07,USA-48423,Smith,Texas,47,11.43,4.91,0,0.29,0.12
 2021-07-07,USA-48421,Sherman,Texas,1,0.14,4.73,0,0,0
-2021-07-07,USA-48419,Shelby,Texas,1,12.17,48.14,0,0.14,0.57
+2021-07-07,USA-48419,Shelby,Texas,1,0.5,1.98,0,0.14,0.57
 2021-07-07,USA-48417,Shackelford,Texas,0,0,0,0,0,0
 2021-07-07,USA-48415,Scurry,Texas,-1,0.83,4.99,0,0,0
 2021-07-07,USA-48413,Schleicher,Texas,0,0,0,0,0,0
@@ -1496009,7 +1496009,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-07-07,USA-48353,Nolan,Texas,3,0.71,4.85,0,0,0
 2021-07-07,USA-48351,Newton,Texas,0,0.14,1.05,0,0,0
 2021-07-07,USA-48349,Navarro,Texas,9,2,3.99,0,0,0
-2021-07-07,USA-48347,Nacogdoches,Texas,1,6,9.2,0,0.14,0.22
+2021-07-07,USA-48347,Nacogdoches,Texas,1,0.83,1.28,0,0.14,0.22
 2021-07-07,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-07-07,USA-48343,Morris,Texas,4,1.57,12.69,0,0,0
 2021-07-07,USA-48341,Moore,Texas,4,1,4.78,0,0,0