Updating data.

diff --git a/rolling-averages/anomalies.csv b/rolling-averages/anomalies.csv
index 7108f5b..1da8f16 100644 (file)
--- a/rolling-averages/anomalies.csv
+++ b/rolling-averages/anomalies.csv
@@ -558,8 +558,7 @@ date,end_date,county,state,geoid,type,omit_from_rolling_average,omit_from_rollin
 2021-06-21,,,Nevada,USA-32,deaths,yes,,Nevada removed several deaths in Washoe County.
 2021-06-22,2021-06-24,Houston,Texas,USA-48225,cases,yes,,Texas added a backlog of cases in Houston County.
 2021-06-22,2021-06-24,Benewah,Idaho,USA-16009,cases,yes,,Benewah County added a backlog of older cases.
-2021-06-23,2021-06-25,,Alaska,USA-02,cases,yes,,Texas added a backlog of cases in Upshur County.
-2021-06-23,2021-06-25,Harrison,Texas,USA-48203,cases,yes,,Texas added a backlog of cases in Harrison County.
+2021-06-23,2021-06-29,Harrison,Texas,USA-48203,cases,yes,,Texas added a backlog of cases in Harrison County.
 2021-06-23,,Medina,Texas,USA-48325,cases,yes,,"Texas removed many duplicate cases, including about 100 cases in Medina County."
 2021-06-23,,Calhoun,Texas,USA-48057,cases,yes,,"Texas removed many duplicate cases, including about 25 cases in Calhoun County."
 2021-06-23,,Wilson,Texas,USA-48493,cases,yes,,"Texas removed many duplicate cases, including about 30 cases in Wilson County."
@@ -583,7 +582,7 @@ date,end_date,county,state,geoid,type,omit_from_rolling_average,omit_from_rollin
 2021-06-23,,Kinney,Texas,USA-48271,cases,yes,,"Texas removed many duplicate cases, including several cases in Kinney County."
 2021-06-23,,Lavaca,Texas,USA-48285,cases,yes,,"Texas removed many duplicate cases, including about 40 cases in Lavaca County."
 2021-06-23,,Real,Texas,USA-48385,cases,yes,,"Texas removed many duplicate cases, including several cases in Real County."
-2021-06-23,2021-06-24,Panola,Texas,USA-48365,cases,yes,,Texas added a backlog of cases in Panola County.
+2021-06-23,2021-06-29,Panola,Texas,USA-48365,cases,yes,,Texas added a backlog of cases in Panola County.
 2021-06-23,2021-06-26,Bowie,Texas,USA-48037,cases,yes,,Texas added a backlog of cases in Bowie County.
 2021-06-23,2021-06-24,Camp,Texas,USA-48063,cases,yes,,Texas added a backlog of cases in Camp County.
 2021-06-23,2021-06-25,Cass,Texas,USA-48067,cases,yes,,Texas added a backlog of cases in Cass County.
@@ -592,12 +591,13 @@ date,end_date,county,state,geoid,type,omit_from_rolling_average,omit_from_rollin
 2021-06-23,2021-06-25,Hopkins,Texas,USA-48223,cases,yes,,Texas added a backlog of cases in Hopkins County.
 2021-06-23,2021-06-24,Marion,Texas,USA-48315,cases,yes,,Texas added a backlog of cases in Marion County.
 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-06-26,Nacogdoches,Texas,USA-48347,cases,yes,,Texas added a backlog of cases in Nacogdoches County.
-2021-06-23,2021-06-25,Red River,Texas,USA-48387,cases,yes,,Texas added a backlog of cases in Red River County.
+2021-06-23,2021-06-29,Nacogdoches,Texas,USA-48347,cases,yes,,Texas added a backlog of cases in Nacogdoches County.
+2021-06-23,2021-06-29,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-06-26,Shelby,Texas,USA-48419,cases,yes,,Texas added a backlog of cases in Shelby County.
-2021-06-23,2021-06-25,Titus,Texas,USA-48449,cases,yes,,Texas added a backlog of cases in Titus County.
+2021-06-23,2021-06-29,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-23,2021-06-26,Upshur,Texas,USA-48459,cases,yes,,Texas added a backlog of cases in Upshur County.
 2021-06-24,,Harris,Texas,USA-48201,cases,yes,,Harris County removed more than 100 cases.
 2021-06-27,,Ellis,Texas,USA-48139,cases,yes,,Ellis County removed 96 cases.
 2021-06-28,,Harris,Texas,USA-48201,cases,yes,,Harris County removed about 180 duplicate cases.

diff --git a/rolling-averages/us-counties-recent.csv b/rolling-averages/us-counties-recent.csv
index e36ae42..7c287bd 100644 (file)
--- a/rolling-averages/us-counties-recent.csv
+++ b/rolling-averages/us-counties-recent.csv
@@ -75178,7 +75178,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-23,USA-48465,Val Verde,Texas,0,2.14,4.37,0,0,0
 2021-06-23,USA-48463,Uvalde,Texas,5,1.29,4.81,0,0,0
 2021-06-23,USA-48461,Upton,Texas,0,0,0,0,0,0
-2021-06-23,USA-48459,Upshur,Texas,46,19.8,47.42,0,0,0
+2021-06-23,USA-48459,Upshur,Texas,46,13.25,31.73,0,0,0
 2021-06-23,USA-48457,Tyler,Texas,0,0,0,0,0,0
 2021-06-23,USA-48455,Trinity,Texas,6,3.67,25.03,1,0.14,0.98
 2021-06-23,USA-48453,Travis,Texas,84,27.57,2.16,1,0.29,0.02
@@ -78424,7 +78424,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-24,USA-48465,Val Verde,Texas,0,2.14,4.37,0,0,0
 2021-06-24,USA-48463,Uvalde,Texas,4,1.86,6.94,0,0,0
 2021-06-24,USA-48461,Upton,Texas,0,0,0,0,0,0
-2021-06-24,USA-48459,Upshur,Texas,47,29.2,69.94,0,0,0
+2021-06-24,USA-48459,Upshur,Texas,47,17.67,42.31,0,0,0
 2021-06-24,USA-48457,Tyler,Texas,0,0,0,0,0,0
 2021-06-24,USA-48455,Trinity,Texas,26,4.4,30.03,0,0.14,0.98
 2021-06-24,USA-48453,Travis,Texas,42,29.43,2.31,1,0.43,0.03
@@ -81669,7 +81669,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-25,USA-48465,Val Verde,Texas,0,2.14,4.37,0,0,0
 2021-06-25,USA-48463,Uvalde,Texas,7,2.86,10.68,0,0,0
 2021-06-25,USA-48461,Upton,Texas,0,0,0,0,0,0
-2021-06-25,USA-48459,Upshur,Texas,44,37.8,90.53,0,0,0
+2021-06-25,USA-48459,Upshur,Texas,44,26,62.27,0,0,0
 2021-06-25,USA-48457,Tyler,Texas,2,0.29,1.32,0,0,0
 2021-06-25,USA-48455,Trinity,Texas,1,4.4,30.03,0,0.14,0.98
 2021-06-25,USA-48453,Travis,Texas,25,27.14,2.13,0,0.29,0.02
@@ -81716,7 +81716,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-25,USA-48371,Pecos,Texas,4,2.29,14.45,0,0,0
 2021-06-25,USA-48369,Parmer,Texas,-2,3.2,33.32,0,0,0
 2021-06-25,USA-48367,Parker,Texas,14,11.14,7.8,1,0.29,0.2
-2021-06-25,USA-48365,Panola,Texas,31,12.8,55.19,0,0,0
+2021-06-25,USA-48365,Panola,Texas,31,8.25,35.57,0,0,0
 2021-06-25,USA-48363,Palo Pinto,Texas,2,1.57,5.38,0,0,0
 2021-06-25,USA-48361,Orange,Texas,13,3.43,4.11,0,0.14,0.17
 2021-06-25,USA-48359,Oldham,Texas,0,0.14,6.76,0,0,0
@@ -84914,12 +84914,12 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-26,USA-48465,Val Verde,Texas,14,2,4.08,0,0,0
 2021-06-26,USA-48463,Uvalde,Texas,0,2.86,10.68,0,0,0
 2021-06-26,USA-48461,Upton,Texas,0,0,0,0,0,0
-2021-06-26,USA-48459,Upshur,Texas,12,29.8,71.37,0,0,0
+2021-06-26,USA-48459,Upshur,Texas,12,0,0,0,0,0
 2021-06-26,USA-48457,Tyler,Texas,0,0.29,1.32,0,0,0
 2021-06-26,USA-48455,Trinity,Texas,0,0.6,4.1,0,0.14,0.98
 2021-06-26,USA-48453,Travis,Texas,37,32.43,2.55,1,0.43,0.03
 2021-06-26,USA-48451,Tom Green,Texas,0,0.71,0.6,0,0,0
-2021-06-26,USA-48449,Titus,Texas,51,13,39.69,0,0,0
+2021-06-26,USA-48449,Titus,Texas,51,0.33,1.02,0,0,0
 2021-06-26,USA-48447,Throckmorton,Texas,0,0,0,0,0,0
 2021-06-26,USA-48445,Terry,Texas,0,0,0,0,0,0
 2021-06-26,USA-48443,Terrell,Texas,0,0,0,0,0,0
@@ -84950,7 +84950,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-26,USA-48393,Roberts,Texas,0,0,0,0,0,0
 2021-06-26,USA-48391,Refugio,Texas,0,0.14,2.06,0,0,0
 2021-06-26,USA-48389,Reeves,Texas,53,19,118.93,0,0,0
-2021-06-26,USA-48387,Red River,Texas,9,3,24.95,0,0,0
+2021-06-26,USA-48387,Red River,Texas,9,0,0,0,0,0
 2021-06-26,USA-48385,Real,Texas,1,0.17,4.83,0,0,0
 2021-06-26,USA-48383,Reagan,Texas,0,0.14,3.71,0,0,0
 2021-06-26,USA-48381,Randall,Texas,0,9.14,6.64,0,0.29,0.21
@@ -84961,7 +84961,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-26,USA-48371,Pecos,Texas,-4,1,6.32,0,0,0
 2021-06-26,USA-48369,Parmer,Texas,1,1.6,16.66,0,0,0
 2021-06-26,USA-48367,Parker,Texas,17,11.29,7.9,0,0.14,0.1
-2021-06-26,USA-48365,Panola,Texas,37,14,60.36,0,0,0
+2021-06-26,USA-48365,Panola,Texas,37,0.67,2.87,0,0,0
 2021-06-26,USA-48363,Palo Pinto,Texas,5,1.43,4.89,0,0,0
 2021-06-26,USA-48361,Orange,Texas,2,3.71,4.45,0,0.14,0.17
 2021-06-26,USA-48359,Oldham,Texas,0,0.14,6.76,0,0,0
@@ -85042,7 +85042,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-26,USA-48209,Hays,Texas,0,10.43,4.53,0,0.29,0.12
 2021-06-26,USA-48207,Haskell,Texas,0,0,0,0,0,0
 2021-06-26,USA-48205,Hartley,Texas,1,0.4,7.17,0,0,0
-2021-06-26,USA-48203,Harrison,Texas,83,28.33,42.57,0,0,0
+2021-06-26,USA-48203,Harrison,Texas,83,1,1.5,0,0,0
 2021-06-26,USA-48201,Harris,Texas,142,73.8,1.57,8,4,0.08
 2021-06-26,USA-48199,Hardin,Texas,5,3.5,6.08,0,0,0
 2021-06-26,USA-48197,Hardeman,Texas,0,0.29,7.26,0,0,0
@@ -88159,12 +88159,12 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-27,USA-48465,Val Verde,Texas,0,2,4.08,0,0,0
 2021-06-27,USA-48463,Uvalde,Texas,0,2.29,8.55,0,0,0
 2021-06-27,USA-48461,Upton,Texas,0,0,0,0,0,0
-2021-06-27,USA-48459,Upshur,Texas,0,24.83,59.48,0,0,0
+2021-06-27,USA-48459,Upshur,Texas,0,0,0,0,0,0
 2021-06-27,USA-48457,Tyler,Texas,0,0.29,1.32,0,0,0
 2021-06-27,USA-48455,Trinity,Texas,0,0.6,4.1,0,0.14,0.98
 2021-06-27,USA-48453,Travis,Texas,0,32.43,2.55,0,0.43,0.03
 2021-06-27,USA-48451,Tom Green,Texas,0,0.71,0.6,0,0,0
-2021-06-27,USA-48449,Titus,Texas,2,13.5,41.22,0,0,0
+2021-06-27,USA-48449,Titus,Texas,2,0.5,1.53,0,0,0
 2021-06-27,USA-48447,Throckmorton,Texas,0,0,0,0,0,0
 2021-06-27,USA-48445,Terry,Texas,0,0,0,0,0,0
 2021-06-27,USA-48443,Terrell,Texas,0,0,0,0,0,0
@@ -88195,7 +88195,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-27,USA-48393,Roberts,Texas,0,0,0,0,0,0
 2021-06-27,USA-48391,Refugio,Texas,0,0.14,2.06,0,0,0
 2021-06-27,USA-48389,Reeves,Texas,0,18.67,116.84,0,0,0
-2021-06-27,USA-48387,Red River,Texas,1,3.33,27.72,0,0,0
+2021-06-27,USA-48387,Red River,Texas,1,0,0,0,0,0
 2021-06-27,USA-48385,Real,Texas,0,0.17,4.83,0,0,0
 2021-06-27,USA-48383,Reagan,Texas,0,0.14,3.71,0,0,0
 2021-06-27,USA-48381,Randall,Texas,0,9.14,6.64,0,0.29,0.21
@@ -88206,7 +88206,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-27,USA-48371,Pecos,Texas,0,1,6.32,0,0,0
 2021-06-27,USA-48369,Parmer,Texas,0,1.6,16.66,0,0,0
 2021-06-27,USA-48367,Parker,Texas,0,11.29,7.9,0,0.14,0.1
-2021-06-27,USA-48365,Panola,Texas,0,14,60.36,0,0,0
+2021-06-27,USA-48365,Panola,Texas,0,1,4.31,0,0,0
 2021-06-27,USA-48363,Palo Pinto,Texas,0,1.43,4.89,0,0,0
 2021-06-27,USA-48361,Orange,Texas,0,3.71,4.45,0,0.14,0.17
 2021-06-27,USA-48359,Oldham,Texas,0,0.14,6.76,0,0,0
@@ -88215,7 +88215,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-27,USA-48353,Nolan,Texas,0,0.14,0.97,0,0,0
 2021-06-27,USA-48351,Newton,Texas,0,0,0,0,0,0
 2021-06-27,USA-48349,Navarro,Texas,0,2.43,4.85,0,0,0
-2021-06-27,USA-48347,Nacogdoches,Texas,0,1.33,2.04,0,0,0
+2021-06-27,USA-48347,Nacogdoches,Texas,0,2,3.07,0,0,0
 2021-06-27,USA-48345,Motley,Texas,0,0.14,11.9,0,0,0
 2021-06-27,USA-48343,Morris,Texas,2,2.8,22.6,0,0,0
 2021-06-27,USA-48341,Moore,Texas,0,0.8,3.82,0,0,0
@@ -88287,7 +88287,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-27,USA-48209,Hays,Texas,0,10.43,4.53,0,0.29,0.12
 2021-06-27,USA-48207,Haskell,Texas,0,0,0,0,0,0
 2021-06-27,USA-48205,Hartley,Texas,0,0.4,7.17,0,0,0
-2021-06-27,USA-48203,Harrison,Texas,0,28,42.07,0,0,0
+2021-06-27,USA-48203,Harrison,Texas,0,1,1.5,0,0,0
 2021-06-27,USA-48201,Harris,Texas,0,73.8,1.57,2,3.86,0.08
 2021-06-27,USA-48199,Hardin,Texas,0,3.5,6.08,0,0,0
 2021-06-27,USA-48197,Hardeman,Texas,0,0.29,7.26,0,0,0
@@ -91404,12 +91404,12 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-28,USA-48465,Val Verde,Texas,0,2,4.08,0,0,0
 2021-06-28,USA-48463,Uvalde,Texas,3,2.71,10.15,0,0,0
 2021-06-28,USA-48461,Upton,Texas,1,0.14,3.91,0,0,0
-2021-06-28,USA-48459,Upshur,Texas,1,25,59.88,0,0,0
+2021-06-28,USA-48459,Upshur,Texas,1,0.5,1.2,0,0,0
 2021-06-28,USA-48457,Tyler,Texas,0,0.29,1.32,0,0,0
 2021-06-28,USA-48455,Trinity,Texas,2,0.8,5.46,0,0.14,0.98
 2021-06-28,USA-48453,Travis,Texas,0,32.43,2.55,0,0.43,0.03
 2021-06-28,USA-48451,Tom Green,Texas,8,1.71,1.44,0,0,0
-2021-06-28,USA-48449,Titus,Texas,0,13.5,41.22,0,0,0
+2021-06-28,USA-48449,Titus,Texas,0,1,3.05,0,0,0
 2021-06-28,USA-48447,Throckmorton,Texas,0,0,0,0,0,0
 2021-06-28,USA-48445,Terry,Texas,0,0,0,0,0,0
 2021-06-28,USA-48443,Terrell,Texas,0,0,0,0,0,0
@@ -91440,7 +91440,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-28,USA-48393,Roberts,Texas,0,0,0,0,0,0
 2021-06-28,USA-48391,Refugio,Texas,0,0.14,2.06,0,0,0
 2021-06-28,USA-48389,Reeves,Texas,0,17.33,108.5,0,0,0
-2021-06-28,USA-48387,Red River,Texas,0,3.33,27.72,0,0,0
+2021-06-28,USA-48387,Red River,Texas,0,0,0,0,0,0
 2021-06-28,USA-48385,Real,Texas,0,0.17,4.83,0,0,0
 2021-06-28,USA-48383,Reagan,Texas,0,0.14,3.71,0,0,0
 2021-06-28,USA-48381,Randall,Texas,3,8.86,6.43,0,0.29,0.21
@@ -91451,7 +91451,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-28,USA-48371,Pecos,Texas,0,1,6.32,0,0,0
 2021-06-28,USA-48369,Parmer,Texas,0,1.6,16.66,0,0,0
 2021-06-28,USA-48367,Parker,Texas,0,11.29,7.9,0,0.14,0.1
-2021-06-28,USA-48365,Panola,Texas,1,13.8,59.5,0,0,0
+2021-06-28,USA-48365,Panola,Texas,1,0,0,0,0,0
 2021-06-28,USA-48363,Palo Pinto,Texas,0,1.43,4.89,0,0,0
 2021-06-28,USA-48361,Orange,Texas,0,3.71,4.45,0,0.14,0.17
 2021-06-28,USA-48359,Oldham,Texas,0,0.14,6.76,0,0,0
@@ -91460,7 +91460,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-28,USA-48353,Nolan,Texas,0,0.14,0.97,0,0,0
 2021-06-28,USA-48351,Newton,Texas,0,0,0,0,0,0
 2021-06-28,USA-48349,Navarro,Texas,0,2.43,4.85,0,0,0
-2021-06-28,USA-48347,Nacogdoches,Texas,1,1.33,2.04,0,0,0
+2021-06-28,USA-48347,Nacogdoches,Texas,1,3,4.6,0,0,0
 2021-06-28,USA-48345,Motley,Texas,0,0.14,11.9,0,0,0
 2021-06-28,USA-48343,Morris,Texas,1,2.8,22.6,0,0,0
 2021-06-28,USA-48341,Moore,Texas,0,0.8,3.82,0,0,0
@@ -91532,7 +91532,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-28,USA-48209,Hays,Texas,37,11.29,4.9,1,0.29,0.12
 2021-06-28,USA-48207,Haskell,Texas,0,0,0,0,0,0
 2021-06-28,USA-48205,Hartley,Texas,0,0.4,7.17,0,0,0
-2021-06-28,USA-48203,Harrison,Texas,1,21.25,31.93,0,0,0
+2021-06-28,USA-48203,Harrison,Texas,1,1,1.5,0,0,0
 2021-06-28,USA-48201,Harris,Texas,-127,73.8,1.57,0,3.71,0.08
 2021-06-28,USA-48199,Hardin,Texas,0,3.5,6.08,0,0,0
 2021-06-28,USA-48197,Hardeman,Texas,0,0.29,7.26,0,0,0
@@ -94411,7 +94411,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-29,USA-53077,Yakima,Washington,30,20.14,8.03,0,0.29,0.11
 2021-06-29,USA-53075,Whitman,Washington,6,1.43,2.85,0,0,0
 2021-06-29,USA-53073,Whatcom,Washington,12,8.43,3.68,0,0,0
-2021-06-29,USA-53071,Walla Walla,Washington,0,12.29,20.22,0,0,0
+2021-06-29,USA-53071,Walla Walla,Washington,12,14,23.04,0,0,0
 2021-06-29,USA-53069,Wahkiakum,Washington,0,0.29,6.37,0,0,0
 2021-06-29,USA-53067,Thurston,Washington,10,19.71,6.79,0,0.14,0.05
 2021-06-29,USA-53065,Stevens,Washington,4,2.71,5.94,0,0.43,0.94
@@ -94649,12 +94649,12 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-29,USA-48465,Val Verde,Texas,0,2,4.08,0,0,0
 2021-06-29,USA-48463,Uvalde,Texas,7,3.71,13.89,0,0,0
 2021-06-29,USA-48461,Upton,Texas,0,0.14,3.91,0,0,0
-2021-06-29,USA-48459,Upshur,Texas,3,21.86,52.35,0,0,0
+2021-06-29,USA-48459,Upshur,Texas,3,1.33,3.19,0,0,0
 2021-06-29,USA-48457,Tyler,Texas,0,0.29,1.32,0,0,0
 2021-06-29,USA-48455,Trinity,Texas,1,0.8,5.46,1,0.29,1.95
 2021-06-29,USA-48453,Travis,Texas,39,32.43,2.55,0,0.43,0.03
 2021-06-29,USA-48451,Tom Green,Texas,5,2.29,1.92,0,0,0
-2021-06-29,USA-48449,Titus,Texas,39,23,70.23,0,0,0
+2021-06-29,USA-48449,Titus,Texas,39,0,0,0,0,0
 2021-06-29,USA-48447,Throckmorton,Texas,0,0,0,0,0,0
 2021-06-29,USA-48445,Terry,Texas,0,0,0,0,0,0
 2021-06-29,USA-48443,Terrell,Texas,0,0,0,0,0,0
@@ -94685,7 +94685,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-29,USA-48393,Roberts,Texas,0,0,0,0,0,0
 2021-06-29,USA-48391,Refugio,Texas,0,0.14,2.06,0,0,0
 2021-06-29,USA-48389,Reeves,Texas,50,25.67,160.66,0,0,0
-2021-06-29,USA-48387,Red River,Texas,20,7.5,62.38,0,0,0
+2021-06-29,USA-48387,Red River,Texas,20,0,0,0,0,0
 2021-06-29,USA-48385,Real,Texas,1,0.33,9.66,0,0,0
 2021-06-29,USA-48383,Reagan,Texas,0,0.14,3.71,0,0,0
 2021-06-29,USA-48381,Randall,Texas,10,9.29,6.74,0,0.29,0.21
@@ -94696,7 +94696,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-29,USA-48371,Pecos,Texas,0,1,6.32,1,0.14,0.9
 2021-06-29,USA-48369,Parmer,Texas,3,1.83,19.09,0,0,0
 2021-06-29,USA-48367,Parker,Texas,37,13.43,9.4,0,0.14,0.1
-2021-06-29,USA-48365,Panola,Texas,41,22,94.85,0,0,0
+2021-06-29,USA-48365,Panola,Texas,41,0,0,0,0,0
 2021-06-29,USA-48363,Palo Pinto,Texas,4,1.71,5.87,0,0,0
 2021-06-29,USA-48361,Orange,Texas,0,2.14,2.57,0,0,0
 2021-06-29,USA-48359,Oldham,Texas,0,0,0,0,0,0
@@ -94705,7 +94705,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-29,USA-48353,Nolan,Texas,0,0,0,0,0,0
 2021-06-29,USA-48351,Newton,Texas,2,0.29,2.1,0,0,0
 2021-06-29,USA-48349,Navarro,Texas,2,2.43,4.85,0,0,0
-2021-06-29,USA-48347,Nacogdoches,Texas,83,28,42.94,0,0,0
+2021-06-29,USA-48347,Nacogdoches,Texas,83,0,0,0,0,0
 2021-06-29,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-06-29,USA-48343,Morris,Texas,6,4,32.29,0,0,0
 2021-06-29,USA-48341,Moore,Texas,1,0.83,3.98,0,0,0
@@ -94777,7 +94777,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-29,USA-48209,Hays,Texas,14,11.43,4.96,0,0.29,0.12
 2021-06-29,USA-48207,Haskell,Texas,0,0,0,0,0,0
 2021-06-29,USA-48205,Hartley,Texas,-1,0.4,7.17,0,0,0
-2021-06-29,USA-48203,Harrison,Texas,82,41.5,62.36,0,0,0
+2021-06-29,USA-48203,Harrison,Texas,82,0,0,0,0,0
 2021-06-29,USA-48201,Harris,Texas,0,43.4,0.92,2,3.71,0.08
 2021-06-29,USA-48199,Hardin,Texas,-2,3.2,5.56,1,0.14,0.25
 2021-06-29,USA-48197,Hardeman,Texas,0,0.29,7.26,0,0,0

diff --git a/rolling-averages/us-counties.csv b/rolling-averages/us-counties.csv
index 6cfc082..bb5b6aa 100644 (file)
--- a/rolling-averages/us-counties.csv
+++ b/rolling-averages/us-counties.csv
@@ -1450513,7 +1450513,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-23,USA-48465,Val Verde,Texas,0,2.14,4.37,0,0,0
 2021-06-23,USA-48463,Uvalde,Texas,5,1.29,4.81,0,0,0
 2021-06-23,USA-48461,Upton,Texas,0,0,0,0,0,0
-2021-06-23,USA-48459,Upshur,Texas,46,19.8,47.42,0,0,0
+2021-06-23,USA-48459,Upshur,Texas,46,13.25,31.73,0,0,0
 2021-06-23,USA-48457,Tyler,Texas,0,0,0,0,0,0
 2021-06-23,USA-48455,Trinity,Texas,6,3.67,25.03,1,0.14,0.98
 2021-06-23,USA-48453,Travis,Texas,84,27.57,2.16,1,0.29,0.02
@@ -1453759,7 +1453759,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-24,USA-48465,Val Verde,Texas,0,2.14,4.37,0,0,0
 2021-06-24,USA-48463,Uvalde,Texas,4,1.86,6.94,0,0,0
 2021-06-24,USA-48461,Upton,Texas,0,0,0,0,0,0
-2021-06-24,USA-48459,Upshur,Texas,47,29.2,69.94,0,0,0
+2021-06-24,USA-48459,Upshur,Texas,47,17.67,42.31,0,0,0
 2021-06-24,USA-48457,Tyler,Texas,0,0,0,0,0,0
 2021-06-24,USA-48455,Trinity,Texas,26,4.4,30.03,0,0.14,0.98
 2021-06-24,USA-48453,Travis,Texas,42,29.43,2.31,1,0.43,0.03
@@ -1457004,7 +1457004,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-25,USA-48465,Val Verde,Texas,0,2.14,4.37,0,0,0
 2021-06-25,USA-48463,Uvalde,Texas,7,2.86,10.68,0,0,0
 2021-06-25,USA-48461,Upton,Texas,0,0,0,0,0,0
-2021-06-25,USA-48459,Upshur,Texas,44,37.8,90.53,0,0,0
+2021-06-25,USA-48459,Upshur,Texas,44,26,62.27,0,0,0
 2021-06-25,USA-48457,Tyler,Texas,2,0.29,1.32,0,0,0
 2021-06-25,USA-48455,Trinity,Texas,1,4.4,30.03,0,0.14,0.98
 2021-06-25,USA-48453,Travis,Texas,25,27.14,2.13,0,0.29,0.02
@@ -1457051,7 +1457051,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-25,USA-48371,Pecos,Texas,4,2.29,14.45,0,0,0
 2021-06-25,USA-48369,Parmer,Texas,-2,3.2,33.32,0,0,0
 2021-06-25,USA-48367,Parker,Texas,14,11.14,7.8,1,0.29,0.2
-2021-06-25,USA-48365,Panola,Texas,31,12.8,55.19,0,0,0
+2021-06-25,USA-48365,Panola,Texas,31,8.25,35.57,0,0,0
 2021-06-25,USA-48363,Palo Pinto,Texas,2,1.57,5.38,0,0,0
 2021-06-25,USA-48361,Orange,Texas,13,3.43,4.11,0,0.14,0.17
 2021-06-25,USA-48359,Oldham,Texas,0,0.14,6.76,0,0,0
@@ -1460249,12 +1460249,12 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-26,USA-48465,Val Verde,Texas,14,2,4.08,0,0,0
 2021-06-26,USA-48463,Uvalde,Texas,0,2.86,10.68,0,0,0
 2021-06-26,USA-48461,Upton,Texas,0,0,0,0,0,0
-2021-06-26,USA-48459,Upshur,Texas,12,29.8,71.37,0,0,0
+2021-06-26,USA-48459,Upshur,Texas,12,0,0,0,0,0
 2021-06-26,USA-48457,Tyler,Texas,0,0.29,1.32,0,0,0
 2021-06-26,USA-48455,Trinity,Texas,0,0.6,4.1,0,0.14,0.98
 2021-06-26,USA-48453,Travis,Texas,37,32.43,2.55,1,0.43,0.03
 2021-06-26,USA-48451,Tom Green,Texas,0,0.71,0.6,0,0,0
-2021-06-26,USA-48449,Titus,Texas,51,13,39.69,0,0,0
+2021-06-26,USA-48449,Titus,Texas,51,0.33,1.02,0,0,0
 2021-06-26,USA-48447,Throckmorton,Texas,0,0,0,0,0,0
 2021-06-26,USA-48445,Terry,Texas,0,0,0,0,0,0
 2021-06-26,USA-48443,Terrell,Texas,0,0,0,0,0,0
@@ -1460285,7 +1460285,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-26,USA-48393,Roberts,Texas,0,0,0,0,0,0
 2021-06-26,USA-48391,Refugio,Texas,0,0.14,2.06,0,0,0
 2021-06-26,USA-48389,Reeves,Texas,53,19,118.93,0,0,0
-2021-06-26,USA-48387,Red River,Texas,9,3,24.95,0,0,0
+2021-06-26,USA-48387,Red River,Texas,9,0,0,0,0,0
 2021-06-26,USA-48385,Real,Texas,1,0.17,4.83,0,0,0
 2021-06-26,USA-48383,Reagan,Texas,0,0.14,3.71,0,0,0
 2021-06-26,USA-48381,Randall,Texas,0,9.14,6.64,0,0.29,0.21
@@ -1460296,7 +1460296,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-26,USA-48371,Pecos,Texas,-4,1,6.32,0,0,0
 2021-06-26,USA-48369,Parmer,Texas,1,1.6,16.66,0,0,0
 2021-06-26,USA-48367,Parker,Texas,17,11.29,7.9,0,0.14,0.1
-2021-06-26,USA-48365,Panola,Texas,37,14,60.36,0,0,0
+2021-06-26,USA-48365,Panola,Texas,37,0.67,2.87,0,0,0
 2021-06-26,USA-48363,Palo Pinto,Texas,5,1.43,4.89,0,0,0
 2021-06-26,USA-48361,Orange,Texas,2,3.71,4.45,0,0.14,0.17
 2021-06-26,USA-48359,Oldham,Texas,0,0.14,6.76,0,0,0
@@ -1460377,7 +1460377,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-26,USA-48209,Hays,Texas,0,10.43,4.53,0,0.29,0.12
 2021-06-26,USA-48207,Haskell,Texas,0,0,0,0,0,0
 2021-06-26,USA-48205,Hartley,Texas,1,0.4,7.17,0,0,0
-2021-06-26,USA-48203,Harrison,Texas,83,28.33,42.57,0,0,0
+2021-06-26,USA-48203,Harrison,Texas,83,1,1.5,0,0,0
 2021-06-26,USA-48201,Harris,Texas,142,73.8,1.57,8,4,0.08
 2021-06-26,USA-48199,Hardin,Texas,5,3.5,6.08,0,0,0
 2021-06-26,USA-48197,Hardeman,Texas,0,0.29,7.26,0,0,0
@@ -1463494,12 +1463494,12 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-27,USA-48465,Val Verde,Texas,0,2,4.08,0,0,0
 2021-06-27,USA-48463,Uvalde,Texas,0,2.29,8.55,0,0,0
 2021-06-27,USA-48461,Upton,Texas,0,0,0,0,0,0
-2021-06-27,USA-48459,Upshur,Texas,0,24.83,59.48,0,0,0
+2021-06-27,USA-48459,Upshur,Texas,0,0,0,0,0,0
 2021-06-27,USA-48457,Tyler,Texas,0,0.29,1.32,0,0,0
 2021-06-27,USA-48455,Trinity,Texas,0,0.6,4.1,0,0.14,0.98
 2021-06-27,USA-48453,Travis,Texas,0,32.43,2.55,0,0.43,0.03
 2021-06-27,USA-48451,Tom Green,Texas,0,0.71,0.6,0,0,0
-2021-06-27,USA-48449,Titus,Texas,2,13.5,41.22,0,0,0
+2021-06-27,USA-48449,Titus,Texas,2,0.5,1.53,0,0,0
 2021-06-27,USA-48447,Throckmorton,Texas,0,0,0,0,0,0
 2021-06-27,USA-48445,Terry,Texas,0,0,0,0,0,0
 2021-06-27,USA-48443,Terrell,Texas,0,0,0,0,0,0
@@ -1463530,7 +1463530,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-27,USA-48393,Roberts,Texas,0,0,0,0,0,0
 2021-06-27,USA-48391,Refugio,Texas,0,0.14,2.06,0,0,0
 2021-06-27,USA-48389,Reeves,Texas,0,18.67,116.84,0,0,0
-2021-06-27,USA-48387,Red River,Texas,1,3.33,27.72,0,0,0
+2021-06-27,USA-48387,Red River,Texas,1,0,0,0,0,0
 2021-06-27,USA-48385,Real,Texas,0,0.17,4.83,0,0,0
 2021-06-27,USA-48383,Reagan,Texas,0,0.14,3.71,0,0,0
 2021-06-27,USA-48381,Randall,Texas,0,9.14,6.64,0,0.29,0.21
@@ -1463541,7 +1463541,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-27,USA-48371,Pecos,Texas,0,1,6.32,0,0,0
 2021-06-27,USA-48369,Parmer,Texas,0,1.6,16.66,0,0,0
 2021-06-27,USA-48367,Parker,Texas,0,11.29,7.9,0,0.14,0.1
-2021-06-27,USA-48365,Panola,Texas,0,14,60.36,0,0,0
+2021-06-27,USA-48365,Panola,Texas,0,1,4.31,0,0,0
 2021-06-27,USA-48363,Palo Pinto,Texas,0,1.43,4.89,0,0,0
 2021-06-27,USA-48361,Orange,Texas,0,3.71,4.45,0,0.14,0.17
 2021-06-27,USA-48359,Oldham,Texas,0,0.14,6.76,0,0,0
@@ -1463550,7 +1463550,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-27,USA-48353,Nolan,Texas,0,0.14,0.97,0,0,0
 2021-06-27,USA-48351,Newton,Texas,0,0,0,0,0,0
 2021-06-27,USA-48349,Navarro,Texas,0,2.43,4.85,0,0,0
-2021-06-27,USA-48347,Nacogdoches,Texas,0,1.33,2.04,0,0,0
+2021-06-27,USA-48347,Nacogdoches,Texas,0,2,3.07,0,0,0
 2021-06-27,USA-48345,Motley,Texas,0,0.14,11.9,0,0,0
 2021-06-27,USA-48343,Morris,Texas,2,2.8,22.6,0,0,0
 2021-06-27,USA-48341,Moore,Texas,0,0.8,3.82,0,0,0
@@ -1463622,7 +1463622,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-27,USA-48209,Hays,Texas,0,10.43,4.53,0,0.29,0.12
 2021-06-27,USA-48207,Haskell,Texas,0,0,0,0,0,0
 2021-06-27,USA-48205,Hartley,Texas,0,0.4,7.17,0,0,0
-2021-06-27,USA-48203,Harrison,Texas,0,28,42.07,0,0,0
+2021-06-27,USA-48203,Harrison,Texas,0,1,1.5,0,0,0
 2021-06-27,USA-48201,Harris,Texas,0,73.8,1.57,2,3.86,0.08
 2021-06-27,USA-48199,Hardin,Texas,0,3.5,6.08,0,0,0
 2021-06-27,USA-48197,Hardeman,Texas,0,0.29,7.26,0,0,0
@@ -1466739,12 +1466739,12 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-28,USA-48465,Val Verde,Texas,0,2,4.08,0,0,0
 2021-06-28,USA-48463,Uvalde,Texas,3,2.71,10.15,0,0,0
 2021-06-28,USA-48461,Upton,Texas,1,0.14,3.91,0,0,0
-2021-06-28,USA-48459,Upshur,Texas,1,25,59.88,0,0,0
+2021-06-28,USA-48459,Upshur,Texas,1,0.5,1.2,0,0,0
 2021-06-28,USA-48457,Tyler,Texas,0,0.29,1.32,0,0,0
 2021-06-28,USA-48455,Trinity,Texas,2,0.8,5.46,0,0.14,0.98
 2021-06-28,USA-48453,Travis,Texas,0,32.43,2.55,0,0.43,0.03
 2021-06-28,USA-48451,Tom Green,Texas,8,1.71,1.44,0,0,0
-2021-06-28,USA-48449,Titus,Texas,0,13.5,41.22,0,0,0
+2021-06-28,USA-48449,Titus,Texas,0,1,3.05,0,0,0
 2021-06-28,USA-48447,Throckmorton,Texas,0,0,0,0,0,0
 2021-06-28,USA-48445,Terry,Texas,0,0,0,0,0,0
 2021-06-28,USA-48443,Terrell,Texas,0,0,0,0,0,0
@@ -1466775,7 +1466775,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-28,USA-48393,Roberts,Texas,0,0,0,0,0,0
 2021-06-28,USA-48391,Refugio,Texas,0,0.14,2.06,0,0,0
 2021-06-28,USA-48389,Reeves,Texas,0,17.33,108.5,0,0,0
-2021-06-28,USA-48387,Red River,Texas,0,3.33,27.72,0,0,0
+2021-06-28,USA-48387,Red River,Texas,0,0,0,0,0,0
 2021-06-28,USA-48385,Real,Texas,0,0.17,4.83,0,0,0
 2021-06-28,USA-48383,Reagan,Texas,0,0.14,3.71,0,0,0
 2021-06-28,USA-48381,Randall,Texas,3,8.86,6.43,0,0.29,0.21
@@ -1466786,7 +1466786,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-28,USA-48371,Pecos,Texas,0,1,6.32,0,0,0
 2021-06-28,USA-48369,Parmer,Texas,0,1.6,16.66,0,0,0
 2021-06-28,USA-48367,Parker,Texas,0,11.29,7.9,0,0.14,0.1
-2021-06-28,USA-48365,Panola,Texas,1,13.8,59.5,0,0,0
+2021-06-28,USA-48365,Panola,Texas,1,0,0,0,0,0
 2021-06-28,USA-48363,Palo Pinto,Texas,0,1.43,4.89,0,0,0
 2021-06-28,USA-48361,Orange,Texas,0,3.71,4.45,0,0.14,0.17
 2021-06-28,USA-48359,Oldham,Texas,0,0.14,6.76,0,0,0
@@ -1466795,7 +1466795,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-28,USA-48353,Nolan,Texas,0,0.14,0.97,0,0,0
 2021-06-28,USA-48351,Newton,Texas,0,0,0,0,0,0
 2021-06-28,USA-48349,Navarro,Texas,0,2.43,4.85,0,0,0
-2021-06-28,USA-48347,Nacogdoches,Texas,1,1.33,2.04,0,0,0
+2021-06-28,USA-48347,Nacogdoches,Texas,1,3,4.6,0,0,0
 2021-06-28,USA-48345,Motley,Texas,0,0.14,11.9,0,0,0
 2021-06-28,USA-48343,Morris,Texas,1,2.8,22.6,0,0,0
 2021-06-28,USA-48341,Moore,Texas,0,0.8,3.82,0,0,0
@@ -1466867,7 +1466867,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-28,USA-48209,Hays,Texas,37,11.29,4.9,1,0.29,0.12
 2021-06-28,USA-48207,Haskell,Texas,0,0,0,0,0,0
 2021-06-28,USA-48205,Hartley,Texas,0,0.4,7.17,0,0,0
-2021-06-28,USA-48203,Harrison,Texas,1,21.25,31.93,0,0,0
+2021-06-28,USA-48203,Harrison,Texas,1,1,1.5,0,0,0
 2021-06-28,USA-48201,Harris,Texas,-127,73.8,1.57,0,3.71,0.08
 2021-06-28,USA-48199,Hardin,Texas,0,3.5,6.08,0,0,0
 2021-06-28,USA-48197,Hardeman,Texas,0,0.29,7.26,0,0,0
@@ -1469746,7 +1469746,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-29,USA-53077,Yakima,Washington,30,20.14,8.03,0,0.29,0.11
 2021-06-29,USA-53075,Whitman,Washington,6,1.43,2.85,0,0,0
 2021-06-29,USA-53073,Whatcom,Washington,12,8.43,3.68,0,0,0
-2021-06-29,USA-53071,Walla Walla,Washington,0,12.29,20.22,0,0,0
+2021-06-29,USA-53071,Walla Walla,Washington,12,14,23.04,0,0,0
 2021-06-29,USA-53069,Wahkiakum,Washington,0,0.29,6.37,0,0,0
 2021-06-29,USA-53067,Thurston,Washington,10,19.71,6.79,0,0.14,0.05
 2021-06-29,USA-53065,Stevens,Washington,4,2.71,5.94,0,0.43,0.94
@@ -1469984,12 +1469984,12 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-29,USA-48465,Val Verde,Texas,0,2,4.08,0,0,0
 2021-06-29,USA-48463,Uvalde,Texas,7,3.71,13.89,0,0,0
 2021-06-29,USA-48461,Upton,Texas,0,0.14,3.91,0,0,0
-2021-06-29,USA-48459,Upshur,Texas,3,21.86,52.35,0,0,0
+2021-06-29,USA-48459,Upshur,Texas,3,1.33,3.19,0,0,0
 2021-06-29,USA-48457,Tyler,Texas,0,0.29,1.32,0,0,0
 2021-06-29,USA-48455,Trinity,Texas,1,0.8,5.46,1,0.29,1.95
 2021-06-29,USA-48453,Travis,Texas,39,32.43,2.55,0,0.43,0.03
 2021-06-29,USA-48451,Tom Green,Texas,5,2.29,1.92,0,0,0
-2021-06-29,USA-48449,Titus,Texas,39,23,70.23,0,0,0
+2021-06-29,USA-48449,Titus,Texas,39,0,0,0,0,0
 2021-06-29,USA-48447,Throckmorton,Texas,0,0,0,0,0,0
 2021-06-29,USA-48445,Terry,Texas,0,0,0,0,0,0
 2021-06-29,USA-48443,Terrell,Texas,0,0,0,0,0,0
@@ -1470020,7 +1470020,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-29,USA-48393,Roberts,Texas,0,0,0,0,0,0
 2021-06-29,USA-48391,Refugio,Texas,0,0.14,2.06,0,0,0
 2021-06-29,USA-48389,Reeves,Texas,50,25.67,160.66,0,0,0
-2021-06-29,USA-48387,Red River,Texas,20,7.5,62.38,0,0,0
+2021-06-29,USA-48387,Red River,Texas,20,0,0,0,0,0
 2021-06-29,USA-48385,Real,Texas,1,0.33,9.66,0,0,0
 2021-06-29,USA-48383,Reagan,Texas,0,0.14,3.71,0,0,0
 2021-06-29,USA-48381,Randall,Texas,10,9.29,6.74,0,0.29,0.21
@@ -1470031,7 +1470031,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-29,USA-48371,Pecos,Texas,0,1,6.32,1,0.14,0.9
 2021-06-29,USA-48369,Parmer,Texas,3,1.83,19.09,0,0,0
 2021-06-29,USA-48367,Parker,Texas,37,13.43,9.4,0,0.14,0.1
-2021-06-29,USA-48365,Panola,Texas,41,22,94.85,0,0,0
+2021-06-29,USA-48365,Panola,Texas,41,0,0,0,0,0
 2021-06-29,USA-48363,Palo Pinto,Texas,4,1.71,5.87,0,0,0
 2021-06-29,USA-48361,Orange,Texas,0,2.14,2.57,0,0,0
 2021-06-29,USA-48359,Oldham,Texas,0,0,0,0,0,0
@@ -1470040,7 +1470040,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-29,USA-48353,Nolan,Texas,0,0,0,0,0,0
 2021-06-29,USA-48351,Newton,Texas,2,0.29,2.1,0,0,0
 2021-06-29,USA-48349,Navarro,Texas,2,2.43,4.85,0,0,0
-2021-06-29,USA-48347,Nacogdoches,Texas,83,28,42.94,0,0,0
+2021-06-29,USA-48347,Nacogdoches,Texas,83,0,0,0,0,0
 2021-06-29,USA-48345,Motley,Texas,0,0,0,0,0,0
 2021-06-29,USA-48343,Morris,Texas,6,4,32.29,0,0,0
 2021-06-29,USA-48341,Moore,Texas,1,0.83,3.98,0,0,0
@@ -1470112,7 +1470112,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-06-29,USA-48209,Hays,Texas,14,11.43,4.96,0,0.29,0.12
 2021-06-29,USA-48207,Haskell,Texas,0,0,0,0,0,0
 2021-06-29,USA-48205,Hartley,Texas,-1,0.4,7.17,0,0,0
-2021-06-29,USA-48203,Harrison,Texas,82,41.5,62.36,0,0,0
+2021-06-29,USA-48203,Harrison,Texas,82,0,0,0,0,0
 2021-06-29,USA-48201,Harris,Texas,0,43.4,0.92,2,3.71,0.08
 2021-06-29,USA-48199,Hardin,Texas,-2,3.2,5.56,1,0.14,0.25
 2021-06-29,USA-48197,Hardeman,Texas,0,0.29,7.26,0,0,0

diff --git a/rolling-averages/us-states.csv b/rolling-averages/us-states.csv
index 7e66772..364cb62 100644 (file)
--- a/rolling-averages/us-states.csv
+++ b/rolling-averages/us-states.csv
@@ -26301,7 +26301,7 @@ date,geoid,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg
 2021-06-23,USA-06,California,880,941.29,2.38,55,28.71,0.07
 2021-06-23,USA-05,Arkansas,389,273.14,9.05,3,2.86,0.09
 2021-06-23,USA-04,Arizona,490,431.14,5.92,10,11,0.15
-2021-06-23,USA-02,Alaska,71,31.5,4.31,1,0.14,0.02
+2021-06-23,USA-02,Alaska,71,37.14,5.08,1,0.14,0.02
 2021-06-23,USA-01,Alabama,381,153,3.12,17,5.71,0.12
 2021-06-24,USA-69,Northern Mariana Islands,0,0,0,0,0,0
 2021-06-24,USA-66,Guam,6,7.14,4.24,0,0,0
@@ -26356,7 +26356,7 @@ date,geoid,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg
 2021-06-24,USA-06,California,1014,941.86,2.38,65,33.71,0.09
 2021-06-24,USA-05,Arkansas,383,286.71,9.5,3,3,0.1
 2021-06-24,USA-04,Arizona,626,473.14,6.5,7,9.43,0.13
-2021-06-24,USA-02,Alaska,0,37.8,5.17,0,0.14,0.02
+2021-06-24,USA-02,Alaska,0,37.14,5.08,0,0.14,0.02
 2021-06-24,USA-01,Alabama,0,153,3.12,0,5.71,0.12
 2021-06-25,USA-69,Northern Mariana Islands,0,0,0,0,0,0
 2021-06-25,USA-66,Guam,12,8.71,5.17,0,0,0
@@ -26411,7 +26411,7 @@ date,geoid,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg
 2021-06-25,USA-06,California,1400,978.71,2.48,53,36.14,0.09
 2021-06-25,USA-05,Arkansas,302,290.43,9.62,3,2.71,0.09
 2021-06-25,USA-04,Arizona,587,505,6.94,28,11.57,0.16
-2021-06-25,USA-02,Alaska,42,21.75,2.97,0,0.14,0.02
+2021-06-25,USA-02,Alaska,42,28.57,3.91,0,0.14,0.02
 2021-06-25,USA-01,Alabama,540,182.43,3.72,8,4.29,0.09
 2021-06-26,USA-69,Northern Mariana Islands,0,0,0,0,0,0
 2021-06-26,USA-66,Guam,0,8.71,5.17,0,0,0
@@ -26466,7 +26466,7 @@ date,geoid,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg
 2021-06-26,USA-06,California,785,1012.86,2.56,12,35.14,0.09
 2021-06-26,USA-05,Arkansas,0,254.57,8.44,0,2.71,0.09
 2021-06-26,USA-04,Arizona,475,481.29,6.61,11,10.86,0.15
-2021-06-26,USA-02,Alaska,0,21.75,2.97,0,0.14,0.02
+2021-06-26,USA-02,Alaska,0,28.57,3.91,0,0.14,0.02
 2021-06-26,USA-01,Alabama,0,182.43,3.72,0,4.29,0.09
 2021-06-27,USA-69,Northern Mariana Islands,0,0,0,0,0,0
 2021-06-27,USA-66,Guam,0,8.71,5.17,0,0,0
@@ -26521,7 +26521,7 @@ date,geoid,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg
 2021-06-27,USA-06,California,867,1044.57,2.64,31,35.57,0.09
 2021-06-27,USA-05,Arkansas,0,235.57,7.81,0,2.71,0.09
 2021-06-27,USA-04,Arizona,436,488.57,6.71,-1,11.83,0.16
-2021-06-27,USA-02,Alaska,0,21.75,2.97,0,0.14,0.02
+2021-06-27,USA-02,Alaska,0,28.57,3.91,0,0.14,0.02
 2021-06-27,USA-01,Alabama,0,182.43,3.72,0,4.29,0.09
 2021-06-28,USA-69,Northern Mariana Islands,0,0,0,0,0,0
 2021-06-28,USA-66,Guam,16,8.57,5.09,1,0.14,0.08
@@ -26576,7 +26576,7 @@ date,geoid,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg
 2021-06-28,USA-06,California,1610,1090.14,2.76,11,34.86,0.09
 2021-06-28,USA-05,Arkansas,966,360.71,11.95,4,3,0.1
 2021-06-28,USA-04,Arizona,413,492.71,6.77,0,11.83,0.16
-2021-06-28,USA-02,Alaska,96,24,3.28,0,0.14,0.02
+2021-06-28,USA-02,Alaska,96,29.86,4.08,0,0.14,0.02
 2021-06-28,USA-01,Alabama,517,205.43,4.19,2,3.86,0.08
 2021-06-29,USA-69,Northern Mariana Islands,0,0,0,0,0,0
 2021-06-29,USA-66,Guam,4,6.29,3.73,0,0.14,0.08
@@ -26585,7 +26585,7 @@ date,geoid,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg
 2021-06-29,USA-56,Wyoming,96,70.14,12.12,7,1.86,0.32
 2021-06-29,USA-55,Wisconsin,135,85.71,1.47,17,8.43,0.14
 2021-06-29,USA-54,West Virginia,25,52.14,2.91,1,1.29,0.07
-2021-06-29,USA-53,Washington,335,434.57,5.71,7,12.83,0.17
+2021-06-29,USA-53,Washington,347,436.29,5.73,7,12.83,0.17
 2021-06-29,USA-51,Virginia,148,165.14,1.93,10,6.43,0.08
 2021-06-29,USA-50,Vermont,4,5,0.8,0,0,0
 2021-06-29,USA-49,Utah,361,363.86,11.35,3,5,0.16
@@ -26631,5 +26631,5 @@ date,geoid,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg
 2021-06-29,USA-06,California,564,1017.14,2.57,9,33.71,0.09
 2021-06-29,USA-05,Arkansas,479,359.86,11.92,8,3,0.1
 2021-06-29,USA-04,Arizona,546,510.43,7.01,17,12.17,0.17
-2021-06-29,USA-02,Alaska,0,24,3.28,0,0.14,0.02
+2021-06-29,USA-02,Alaska,0,29.86,4.08,0,0.14,0.02
 2021-06-29,USA-01,Alabama,0,205.43,4.19,0,3.86,0.08
\ No newline at end of file

diff --git a/rolling-averages/us.csv b/rolling-averages/us.csv
index 159ca50..c8e6332 100644 (file)
--- a/rolling-averages/us.csv
+++ b/rolling-averages/us.csv
@@ -524,4 +524,4 @@ date,geoid,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg_per_1
 2021-06-26,USA,6771,11876.43,3.58,126,306.71,0.09
 2021-06-27,USA,4087,11879.86,3.58,96,307.57,0.09
 2021-06-28,USA,15570,11842.14,3.57,161,289.43,0.09
-2021-06-29,USA,10610,11532.57,3.48,311,272.14,0.08
\ No newline at end of file
+2021-06-29,USA,10622,11534.29,3.48,311,272.14,0.08
\ No newline at end of file

diff --git a/us-counties-recent.csv b/us-counties-recent.csv
index 4b67013..4a1b24f 100644 (file)
--- a/us-counties-recent.csv
+++ b/us-counties-recent.csv
@@ -97240,7 +97240,7 @@ date,county,state,fips,cases,deaths
 2021-06-29,Stevens,Washington,53065,2390,31
 2021-06-29,Thurston,Washington,53067,11026,112
 2021-06-29,Wahkiakum,Washington,53069,156,1
-2021-06-29,Walla Walla,Washington,53071,5530,67
+2021-06-29,Walla Walla,Washington,53071,5542,67
 2021-06-29,Whatcom,Washington,53073,9905,103
 2021-06-29,Whitman,Washington,53075,4414,50
 2021-06-29,Yakima,Washington,53077,31772,451

diff --git a/us-counties.csv b/us-counties.csv
index 2f36863..09d5c52 100644 (file)
--- a/us-counties.csv
+++ b/us-counties.csv
@@ -1468936,7 +1468936,7 @@ date,county,state,fips,cases,deaths
 2021-06-29,Stevens,Washington,53065,2390,31
 2021-06-29,Thurston,Washington,53067,11026,112
 2021-06-29,Wahkiakum,Washington,53069,156,1
-2021-06-29,Walla Walla,Washington,53071,5530,67
+2021-06-29,Walla Walla,Washington,53071,5542,67
 2021-06-29,Whatcom,Washington,53073,9905,103
 2021-06-29,Whitman,Washington,53075,4414,50
 2021-06-29,Yakima,Washington,53077,31772,451

diff --git a/us-states.csv b/us-states.csv
index 1cccf0e..affc6e5 100644 (file)
--- a/us-states.csv
+++ b/us-states.csv
@@ -26629,7 +26629,7 @@ date,state,fips,cases,deaths
 2021-06-29,Vermont,50,24406,256
 2021-06-29,Virgin Islands,78,3858,30
 2021-06-29,Virginia,51,680065,11412
-2021-06-29,Washington,53,453295,5963
+2021-06-29,Washington,53,453307,5963
 2021-06-29,West Virginia,54,163992,2879
 2021-06-29,Wisconsin,55,677743,8126
 2021-06-29,Wyoming,56,62195,747
\ No newline at end of file

diff --git a/us.csv b/us.csv
index 097f6b6..df24e00 100644 (file)
--- a/us.csv
+++ b/us.csv
@@ -524,4 +524,4 @@ date,cases,deaths
 2021-06-26,33588238,603501
 2021-06-27,33592325,603597
 2021-06-28,33607895,603758
-2021-06-29,33618505,604069
\ No newline at end of file
+2021-06-29,33618517,604069
\ No newline at end of file