Updating data.
[repo] / rolling-averages / us-counties-recent.csv
index bc4cd0e..90ecba2 100644 (file)
@@ -94439,7 +94439,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-04-27,USA-54005,Boone,West Virginia,4,7.29,33.95,-7,0.17,0.78
 2021-04-27,USA-54003,Berkeley,West Virginia,20,38.14,32.01,-6,0.5,0.42
 2021-04-27,USA-54001,Barbour,West Virginia,-1,4.6,27.98,-1,0,0
-2021-04-27,USA-53077,Yakima,Washington,0,51.14,20.39,0,0.71,0.28
+2021-04-27,USA-53077,Yakima,Washington,29,55.29,22.04,0,0.71,0.28
 2021-04-27,USA-53075,Whitman,Washington,1,11,21.95,0,0,0
 2021-04-27,USA-53073,Whatcom,Washington,30,35.29,15.39,0,0,0
 2021-04-27,USA-53071,Walla Walla,Washington,10,7,11.52,0,0,0
@@ -94465,7 +94465,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-04-27,USA-53031,Jefferson,Washington,0,1,3.1,0,0.14,0.44
 2021-04-27,USA-53029,Island,Washington,9,8.29,9.73,0,0.14,0.17
 2021-04-27,USA-53027,Grays Harbor,Washington,8,9.86,13.13,1,0.29,0.38
-2021-04-27,USA-53025,Grant,Washington,0,19.29,19.73,0,0.71,0.73
+2021-04-27,USA-53025,Grant,Washington,23,22.57,23.09,0,0.71,0.73
 2021-04-27,USA-53023,Garfield,Washington,0,0,0,0,0,0
 2021-04-27,USA-53021,Franklin,Washington,15,25.86,27.15,0,0.29,0.3
 2021-04-27,USA-53019,Ferry,Washington,-1,7,91.78,0,0,0
@@ -94478,139 +94478,139 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-04-27,USA-53005,Benton,Washington,29,33.57,16.43,0,0.14,0.07
 2021-04-27,USA-53003,Asotin,Washington,2,3.29,14.55,0,0.14,0.63
 2021-04-27,USA-53001,Adams,Washington,4,3.14,15.73,0,0,0
-2021-04-27,USA-51199,York,Virginia,0,5,7.32,0,0,0
-2021-04-27,USA-51197,Wythe,Virginia,0,5.71,19.92,0,0,0
-2021-04-27,USA-51195,Wise,Virginia,0,4.71,12.61,0,0.14,0.38
+2021-04-27,USA-51199,York,Virginia,11,6.57,9.62,0,0,0
+2021-04-27,USA-51197,Wythe,Virginia,13,7.57,26.4,1,0.14,0.5
+2021-04-27,USA-51195,Wise,Virginia,9,6,16.05,0,0.14,0.38
 2021-04-27,USA-51840,Winchester city,Virginia,0,3.43,12.21,0,0.14,0.51
 2021-04-27,USA-51830,Williamsburg city,Virginia,0,2,13.37,0,0,0
-2021-04-27,USA-51193,Westmoreland,Virginia,0,2,11.1,0,0,0
-2021-04-27,USA-51820,Waynesboro city,Virginia,0,1.71,7.58,0,0,0
-2021-04-27,USA-51191,Washington,Virginia,0,8.43,15.68,0,0.29,0.53
-2021-04-27,USA-51187,Warren,Virginia,0,9.71,24.19,0,0,0
-2021-04-27,USA-51810,Virginia Beach city,Virginia,0,53.71,11.94,0,0.57,0.13
-2021-04-27,USA-51185,Tazewell,Virginia,0,4.71,11.61,0,0,0
-2021-04-27,USA-51183,Sussex,Virginia,0,1.29,11.52,0,0,0
+2021-04-27,USA-51193,Westmoreland,Virginia,2,2.29,12.69,0,0,0
+2021-04-27,USA-51820,Waynesboro city,Virginia,8,2.86,12.63,1,0.14,0.63
+2021-04-27,USA-51191,Washington,Virginia,8,9.57,17.81,1,0.43,0.8
+2021-04-27,USA-51187,Warren,Virginia,11,11.29,28.1,0,0,0
+2021-04-27,USA-51810,Virginia Beach city,Virginia,81,65.29,14.51,0,0.57,0.13
+2021-04-27,USA-51185,Tazewell,Virginia,9,6,14.78,1,0.14,0.35
+2021-04-27,USA-51183,Sussex,Virginia,1,1.43,12.8,0,0,0
 2021-04-27,USA-51181,Surry,Virginia,0,0.43,6.67,0,0,0
-2021-04-27,USA-51800,Suffolk city,Virginia,0,9,9.77,0,0.43,0.47
-2021-04-27,USA-51790,Staunton city,Virginia,0,2.33,9.36,0,0,0
-2021-04-27,USA-51179,Stafford,Virginia,0,24.14,15.79,0,0.29,0.19
-2021-04-27,USA-51177,Spotsylvania,Virginia,0,17.57,12.9,0,0,0
-2021-04-27,USA-51175,Southampton,Virginia,0,1,5.67,0,0,0
-2021-04-27,USA-51173,Smyth,Virginia,0,6.71,22.3,0,0,0
-2021-04-27,USA-51171,Shenandoah,Virginia,0,8.86,20.31,0,0.14,0.33
-2021-04-27,USA-51169,Scott,Virginia,0,1.71,7.95,0,0.14,0.66
+2021-04-27,USA-51800,Suffolk city,Virginia,16,11.29,12.25,0,0.43,0.47
+2021-04-27,USA-51790,Staunton city,Virginia,1,2.5,10.03,1,0.14,0.57
+2021-04-27,USA-51179,Stafford,Virginia,21,27.14,17.75,0,0.29,0.19
+2021-04-27,USA-51177,Spotsylvania,Virginia,24,21,15.42,0,0,0
+2021-04-27,USA-51175,Southampton,Virginia,4,1.57,8.91,0,0,0
+2021-04-27,USA-51173,Smyth,Virginia,10,8.14,27.05,0,0,0
+2021-04-27,USA-51171,Shenandoah,Virginia,8,10,22.93,0,0.14,0.33
+2021-04-27,USA-51169,Scott,Virginia,6,2.57,11.92,0,0.14,0.66
 2021-04-27,USA-51775,Salem city,Virginia,0,4.67,18.44,0,0.14,0.56
-2021-04-27,USA-51167,Russell,Virginia,0,2,7.52,0,0,0
-2021-04-27,USA-51165,Rockingham,Virginia,0,8.29,10.11,0,0,0
-2021-04-27,USA-51163,Rockbridge,Virginia,0,1.57,6.96,0,0,0
+2021-04-27,USA-51167,Russell,Virginia,1,2.14,8.06,0,0,0
+2021-04-27,USA-51165,Rockingham,Virginia,6,9.14,11.16,1,0.14,0.17
+2021-04-27,USA-51163,Rockbridge,Virginia,2,1.86,8.23,0,0,0
 2021-04-27,USA-51770,Roanoke city,Virginia,0,7.86,7.93,0,0.29,0.29
-2021-04-27,USA-51161,Roanoke,Virginia,0,7.29,7.74,0,0.57,0.61
-2021-04-27,USA-51760,Richmond city,Virginia,0,19.86,8.62,0,0.17,0.07
-2021-04-27,USA-51159,Richmond,Virginia,0,2.43,26.92,0,0,0
+2021-04-27,USA-51161,Roanoke,Virginia,228,39.86,42.32,52,8,8.49
+2021-04-27,USA-51760,Richmond city,Virginia,27,23.71,10.29,0,0.17,0.07
+2021-04-27,USA-51159,Richmond,Virginia,0,2.43,26.92,1,0.14,1.58
 2021-04-27,USA-51157,Rappahannock,Virginia,0,0.71,9.69,0,0,0
-2021-04-27,USA-51750,Radford city,Virginia,0,3.14,17.22,0,0,0
-2021-04-27,USA-51155,Pulaski,Virginia,0,4.71,13.85,0,0,0
-2021-04-27,USA-51153,Prince William,Virginia,0,55.86,11.88,0,0,0
-2021-04-27,USA-51149,Prince George,Virginia,0,8.14,21.23,0,0.14,0.37
-2021-04-27,USA-51147,Prince Edward,Virginia,0,2.86,12.53,0,0.14,0.63
-2021-04-27,USA-51145,Powhatan,Virginia,0,3,10.12,0,0,0
-2021-04-27,USA-51740,Portsmouth city,Virginia,0,12.57,13.32,0,0.29,0.3
-2021-04-27,USA-51735,Poquoson city,Virginia,0,0.57,4.66,0,0,0
-2021-04-27,USA-51143,Pittsylvania,Virginia,0,4.43,7.34,0,0.14,0.24
-2021-04-27,USA-51730,Petersburg city,Virginia,0,7.14,22.79,0,0.29,0.91
-2021-04-27,USA-51141,Patrick,Virginia,0,1.86,10.55,0,0.14,0.81
-2021-04-27,USA-51139,Page,Virginia,0,4.29,17.93,0,0,0
-2021-04-27,USA-51137,Orange,Virginia,0,5.43,14.65,0,0.14,0.39
-2021-04-27,USA-51135,Nottoway,Virginia,0,1.14,7.5,0,0,0
-2021-04-27,USA-51720,Norton city,Virginia,0,0.29,7.18,0,0,0
+2021-04-27,USA-51750,Radford city,Virginia,2,3.43,18.79,0,0,0
+2021-04-27,USA-51155,Pulaski,Virginia,3,5.14,15.11,0,0,0
+2021-04-27,USA-51153,Prince William,Virginia,66,65.29,13.88,0,0,0
+2021-04-27,USA-51149,Prince George,Virginia,14,10.14,26.45,0,0.14,0.37
+2021-04-27,USA-51147,Prince Edward,Virginia,3,3.29,14.41,0,0.14,0.63
+2021-04-27,USA-51145,Powhatan,Virginia,4,3.57,12.04,0,0,0
+2021-04-27,USA-51740,Portsmouth city,Virginia,18,15.14,16.04,0,0.29,0.3
+2021-04-27,USA-51735,Poquoson city,Virginia,1,0.71,5.82,0,0,0
+2021-04-27,USA-51143,Pittsylvania,Virginia,3,4.86,8.05,0,0.14,0.24
+2021-04-27,USA-51730,Petersburg city,Virginia,13,9,28.71,0,0.29,0.91
+2021-04-27,USA-51141,Patrick,Virginia,1,2,11.36,0,0.14,0.81
+2021-04-27,USA-51139,Page,Virginia,2,4.57,19.13,0,0,0
+2021-04-27,USA-51137,Orange,Virginia,9,6.71,18.12,0,0.14,0.39
+2021-04-27,USA-51135,Nottoway,Virginia,1,1.29,8.44,0,0,0
+2021-04-27,USA-51720,Norton city,Virginia,3,0.71,17.94,0,0,0
 2021-04-27,USA-51133,Northumberland,Virginia,0,0.57,4.72,0,0,0
-2021-04-27,USA-51131,Northampton,Virginia,0,0.71,6.1,0,0,0
-2021-04-27,USA-51710,Norfolk city,Virginia,0,25.14,10.36,0,1.14,0.47
-2021-04-27,USA-51700,Newport News city,Virginia,0,22.43,12.51,0,0.29,0.16
-2021-04-27,USA-51127,New Kent,Virginia,0,2.57,11.14,0,0.14,0.62
+2021-04-27,USA-51131,Northampton,Virginia,1,0.86,7.32,0,0,0
+2021-04-27,USA-51710,Norfolk city,Virginia,38,30.57,12.59,0,1.14,0.47
+2021-04-27,USA-51700,Newport News city,Virginia,23,25.71,14.35,0,0.29,0.16
+2021-04-27,USA-51127,New Kent,Virginia,1,2.71,11.75,0,0.14,0.62
 2021-04-27,USA-51125,Nelson,Virginia,0,0.86,5.74,0,0,0
-2021-04-27,USA-51121,Montgomery,Virginia,0,11,11.16,0,0.14,0.14
+2021-04-27,USA-51121,Montgomery,Virginia,9,12.29,12.47,0,0.14,0.14
 2021-04-27,USA-51119,Middlesex,Virginia,0,0.29,2.7,0,0,0
-2021-04-27,USA-51117,Mecklenburg,Virginia,0,2.71,8.87,0,0.14,0.47
-2021-04-27,USA-51115,Mathews,Virginia,0,0,0,0,0,0
+2021-04-27,USA-51117,Mecklenburg,Virginia,10,4.14,13.54,0,0.14,0.47
+2021-04-27,USA-51115,Mathews,Virginia,1,0.14,1.62,0,0,0
 2021-04-27,USA-51690,Martinsville city,Virginia,0,1.29,10.24,0,0,0
 2021-04-27,USA-51685,Manassas Park city,Virginia,0,1.86,10.63,0,0,0
 2021-04-27,USA-51683,Manassas city,Virginia,0,3.83,9.33,0,0.14,0.35
 2021-04-27,USA-51113,Madison,Virginia,0,1.17,8.8,0,0,0
-2021-04-27,USA-51680,Lynchburg city,Virginia,0,10.67,12.98,0,0.14,0.17
-2021-04-27,USA-51111,Lunenburg,Virginia,0,0.86,7.03,0,0,0
-2021-04-27,USA-51109,Louisa,Virginia,0,3.57,9.5,0,0,0
-2021-04-27,USA-51107,Loudoun,Virginia,0,44.14,10.67,0,0,0
+2021-04-27,USA-51680,Lynchburg city,Virginia,29,15.5,18.86,0,0.14,0.17
+2021-04-27,USA-51111,Lunenburg,Virginia,1,1,8.2,0,0,0
+2021-04-27,USA-51109,Louisa,Virginia,8,4.71,12.54,0,0,0
+2021-04-27,USA-51107,Loudoun,Virginia,55,52,12.57,0,0,0
 2021-04-27,USA-51678,Lexington city,Virginia,0,0.86,11.51,0,0,0
-2021-04-27,USA-51105,Lee,Virginia,0,1.14,4.88,0,0,0
+2021-04-27,USA-51105,Lee,Virginia,2,1.43,6.1,0,0,0
 2021-04-27,USA-51103,Lancaster,Virginia,0,0.29,2.69,0,0.14,1.35
-2021-04-27,USA-51101,King William,Virginia,0,3,17.49,0,0.14,0.83
-2021-04-27,USA-51099,King George,Virginia,0,2.83,10.56,0,0,0
-2021-04-27,USA-51097,King and Queen,Virginia,0,0.29,4.07,0,0,0
-2021-04-27,USA-51095,James City,Virginia,0,6,7.84,0,0.14,0.19
-2021-04-27,USA-51093,Isle of Wight,Virginia,0,3.43,9.24,0,0.14,0.38
-2021-04-27,USA-51670,Hopewell city,Virginia,0,5,22.19,0,0.29,1.27
+2021-04-27,USA-51101,King William,Virginia,1,3.14,18.33,0,0.14,0.83
+2021-04-27,USA-51099,King George,Virginia,2,3.17,11.8,0,0,0
+2021-04-27,USA-51097,King and Queen,Virginia,1,0.43,6.1,0,0,0
+2021-04-27,USA-51095,James City,Virginia,9,7.29,9.52,0,0.14,0.19
+2021-04-27,USA-51093,Isle of Wight,Virginia,3,3.86,10.39,0,0.14,0.38
+2021-04-27,USA-51670,Hopewell city,Virginia,5,5.83,25.89,0,0.29,1.27
 2021-04-27,USA-51091,Highland,Virginia,0,0.14,6.52,0,0,0
-2021-04-27,USA-51089,Henry,Virginia,0,1.57,3.11,0,0,0
-2021-04-27,USA-51087,Henrico,Virginia,0,39.57,11.96,0,0.57,0.17
-2021-04-27,USA-51660,Harrisonburg city,Virginia,0,7.14,13.47,0,0,0
-2021-04-27,USA-51085,Hanover,Virginia,0,12.14,11.27,0,0.29,0.27
-2021-04-27,USA-51650,Hampton city,Virginia,0,15.57,11.58,0,0.43,0.32
+2021-04-27,USA-51089,Henry,Virginia,1,1.71,3.39,0,0,0
+2021-04-27,USA-51087,Henrico,Virginia,49,46.57,14.08,2,0.86,0.26
+2021-04-27,USA-51660,Harrisonburg city,Virginia,7,8.14,15.36,0,0,0
+2021-04-27,USA-51085,Hanover,Virginia,17,14.57,13.52,0,0.29,0.27
+2021-04-27,USA-51650,Hampton city,Virginia,18,18.14,13.49,1,0.57,0.42
 2021-04-27,USA-51083,Halifax,Virginia,0,3.43,10.11,0,0,0
-2021-04-27,USA-51081,Greensville,Virginia,0,1.29,11.34,0,0,0
-2021-04-27,USA-51079,Greene,Virginia,0,1.29,6.49,0,0,0
-2021-04-27,USA-51077,Grayson,Virginia,0,4.14,26.64,0,0,0
-2021-04-27,USA-51075,Goochland,Virginia,0,2.57,10.83,0,0,0
-2021-04-27,USA-51073,Gloucester,Virginia,0,1.29,3.44,0,0,0
-2021-04-27,USA-51071,Giles,Virginia,0,3.14,18.8,0,0.29,1.71
-2021-04-27,USA-51640,Galax city,Virginia,0,3.33,52.52,0,0,0
-2021-04-27,USA-51630,Fredericksburg city,Virginia,0,5.71,19.68,0,0,0
-2021-04-27,USA-51069,Frederick,Virginia,0,14.71,16.47,0,0,0
-2021-04-27,USA-51620,Franklin city,Virginia,0,0.71,8.97,0,0.14,1.79
-2021-04-27,USA-51067,Franklin,Virginia,0,1.86,3.31,0,0,0
-2021-04-27,USA-51065,Fluvanna,Virginia,0,2.43,8.91,0,0,0
+2021-04-27,USA-51081,Greensville,Virginia,1,1.43,12.6,0,0,0
+2021-04-27,USA-51079,Greene,Virginia,2,1.57,7.93,0,0,0
+2021-04-27,USA-51077,Grayson,Virginia,3,4.57,29.4,0,0,0
+2021-04-27,USA-51075,Goochland,Virginia,1,2.71,11.43,0,0,0
+2021-04-27,USA-51073,Gloucester,Virginia,2,1.57,4.21,0,0,0
+2021-04-27,USA-51071,Giles,Virginia,4,3.71,22.21,0,0.29,1.71
+2021-04-27,USA-51640,Galax city,Virginia,4,4,63.02,0,0,0
+2021-04-27,USA-51630,Fredericksburg city,Virginia,10,7.14,24.6,0,0,0
+2021-04-27,USA-51069,Frederick,Virginia,20,17.57,19.67,0,0,0
+2021-04-27,USA-51620,Franklin city,Virginia,1,0.86,10.76,0,0.14,1.79
+2021-04-27,USA-51067,Franklin,Virginia,2,2.14,3.82,0,0,0
+2021-04-27,USA-51065,Fluvanna,Virginia,2,2.71,9.95,0,0,0
 2021-04-27,USA-51063,Floyd,Virginia,0,0.83,5.29,0,0,0
-2021-04-27,USA-51061,Fauquier,Virginia,0,5.43,7.62,0,0,0
-2021-04-27,USA-51610,Falls Church city,Virginia,0,0.83,5.7,0,0,0
-2021-04-27,USA-51600,Fairfax city,Virginia,0,0.14,0.59,0,0.14,0.59
-2021-04-27,USA-51059,Fairfax,Virginia,0,101.29,8.83,0,0.57,0.05
+2021-04-27,USA-51061,Fauquier,Virginia,12,7.14,10.03,0,0,0
+2021-04-27,USA-51610,Falls Church city,Virginia,4,1.5,10.26,0,0,0
+2021-04-27,USA-51600,Fairfax city,Virginia,4,0.71,2.97,0,0.14,0.59
+2021-04-27,USA-51059,Fairfax,Virginia,61,110,9.59,2,0.86,0.07
 2021-04-27,USA-51057,Essex,Virginia,0,0.57,5.22,0,0,0
 2021-04-27,USA-51595,Emporia city,Virginia,0,0.29,5.34,0,0,0
 2021-04-27,USA-51053,Dinwiddie,Virginia,0,2.71,9.51,0,0,0
 2021-04-27,USA-51051,Dickenson,Virginia,0,0.71,4.99,0,0,0
-2021-04-27,USA-51590,Danville city,Virginia,0,6,14.98,0,0,0
-2021-04-27,USA-51049,Cumberland,Virginia,0,2,20.14,0,0,0
-2021-04-27,USA-51047,Culpeper,Virginia,0,5.14,9.78,0,0.29,0.54
+2021-04-27,USA-51590,Danville city,Virginia,11,7.57,18.91,0,0,0
+2021-04-27,USA-51049,Cumberland,Virginia,2,2.29,23.01,0,0,0
+2021-04-27,USA-51047,Culpeper,Virginia,6,6,11.41,0,0.29,0.54
 2021-04-27,USA-51045,Craig,Virginia,0,1.14,22.27,0,0,0
 2021-04-27,USA-51580,Covington city,Virginia,0,1.17,21.07,0,0,0
-2021-04-27,USA-51570,Colonial Heights city,Virginia,0,3.57,20.56,0,0.29,1.64
+2021-04-27,USA-51570,Colonial Heights city,Virginia,5,4.29,24.67,0,0.29,1.64
 2021-04-27,USA-51043,Clarke,Virginia,0,2,13.68,0,0,0
-2021-04-27,USA-51041,Chesterfield,Virginia,0,40.43,11.46,0,0.29,0.08
-2021-04-27,USA-51550,Chesapeake city,Virginia,0,30.14,12.31,0,0.71,0.29
-2021-04-27,USA-51540,Charlottesville city,Virginia,0,4.67,9.87,0,0,0
+2021-04-27,USA-51041,Chesterfield,Virginia,52,47.86,13.56,3,0.71,0.2
+2021-04-27,USA-51550,Chesapeake city,Virginia,53,37.71,15.4,0,0.71,0.29
+2021-04-27,USA-51540,Charlottesville city,Virginia,6,5.67,11.99,0,0,0
 2021-04-27,USA-51037,Charlotte,Virginia,0,1,8.42,0,0,0
 2021-04-27,USA-51036,Charles City,Virginia,0,1,14.36,0,0,0
-2021-04-27,USA-51035,Carroll,Virginia,0,6.57,22.06,0,0.29,0.96
-2021-04-27,USA-51033,Caroline,Virginia,0,31.33,101.98,0,0,0
-2021-04-27,USA-51031,Campbell,Virginia,0,3.71,6.77,0,0,0
-2021-04-27,USA-51530,Buena Vista city,Virginia,0,0.83,12.86,0,0,0
+2021-04-27,USA-51035,Carroll,Virginia,8,7.71,25.89,0,0.29,0.96
+2021-04-27,USA-51033,Caroline,Virginia,10,33,107.4,0,0,0
+2021-04-27,USA-51031,Campbell,Virginia,12,5.43,9.89,0,0,0
+2021-04-27,USA-51530,Buena Vista city,Virginia,3,1.33,20.58,0,0,0
 2021-04-27,USA-51029,Buckingham,Virginia,0,2.17,12.64,0,0,0
-2021-04-27,USA-51027,Buchanan,Virginia,0,1.29,6.12,0,0,0
-2021-04-27,USA-51025,Brunswick,Virginia,0,0.86,5.28,0,0.14,0.88
-2021-04-27,USA-51520,Bristol city,Virginia,0,4.71,28.12,0,0.17,0.99
-2021-04-27,USA-51023,Botetourt,Virginia,0,2,5.98,0,0,0
+2021-04-27,USA-51027,Buchanan,Virginia,4,1.86,8.84,0,0,0
+2021-04-27,USA-51025,Brunswick,Virginia,3,1.29,7.92,0,0.14,0.88
+2021-04-27,USA-51520,Bristol city,Virginia,10,6.14,36.65,0,0.17,0.99
+2021-04-27,USA-51023,Botetourt,Virginia,1,2.14,6.41,0,0,0
 2021-04-27,USA-51021,Bland,Virginia,0,0.71,11.37,0,0,0
-2021-04-27,USA-51019,Bedford,Virginia,0,7.57,9.58,0,0.14,0.18
-2021-04-27,USA-51017,Bath,Virginia,0,0.14,3.44,0,0,0
-2021-04-27,USA-51015,Augusta,Virginia,0,6.43,8.51,0,0,0
-2021-04-27,USA-51013,Arlington,Virginia,0,20.86,8.81,0,0.43,0.18
+2021-04-27,USA-51019,Bedford,Virginia,7,8.57,10.85,1,0.29,0.36
+2021-04-27,USA-51017,Bath,Virginia,1,0.29,6.89,0,0,0
+2021-04-27,USA-51015,Augusta,Virginia,11,8,10.59,0,0,0
+2021-04-27,USA-51013,Arlington,Virginia,13,22.71,9.59,0,0.43,0.18
 2021-04-27,USA-51011,Appomattox,Virginia,0,1.14,7.18,0,0,0
-2021-04-27,USA-51009,Amherst,Virginia,0,2,6.33,0,0.14,0.45
-2021-04-27,USA-51007,Amelia,Virginia,0,2,15.21,0,0,0
-2021-04-27,USA-51005,Alleghany,Virginia,0,2.17,14.58,0,0,0
-2021-04-27,USA-51510,Alexandria city,Virginia,0,13.43,8.42,0,0.17,0.1
-2021-04-27,USA-51003,Albemarle,Virginia,0,15.86,14.5,0,0,0
-2021-04-27,USA-51001,Accomack,Virginia,0,2.33,7.22,0,0,0
+2021-04-27,USA-51009,Amherst,Virginia,8,3.33,10.55,0,0.14,0.45
+2021-04-27,USA-51007,Amelia,Virginia,3,2.43,18.48,1,0.17,1.27
+2021-04-27,USA-51005,Alleghany,Virginia,9,3.67,24.67,0,0,0
+2021-04-27,USA-51510,Alexandria city,Virginia,10,14.86,9.32,0,0.17,0.1
+2021-04-27,USA-51003,Albemarle,Virginia,7,16.86,15.42,0,0,0
+2021-04-27,USA-51001,Accomack,Virginia,6,3.33,10.31,0,0,0
 2021-04-27,USA-50999,Unknown,Vermont,0,0,,0,0,
 2021-04-27,USA-50027,Windsor,Vermont,0,5,9.08,0,0,0
 2021-04-27,USA-50025,Windham,Vermont,4,5.29,12.52,0,0,0
@@ -97246,7 +97246,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-04-27,USA-06043,Mariposa,California,0,1.71,9.97,0,0,0
 2021-04-27,USA-06041,Marin,California,-3,8,3.09,0,0.14,0.06
 2021-04-27,USA-06039,Madera,California,7,9.14,5.81,0,0,0
-2021-04-27,USA-06037,Los Angeles,California,0,309.43,3.08,3,22.83,0.23
+2021-04-27,USA-06037,Los Angeles,California,273,348.43,3.47,3,22.83,0.23
 2021-04-27,USA-06035,Lassen,California,0,1.71,5.61,0,0,0
 2021-04-27,USA-06033,Lake,California,1,1.71,2.66,0,0,0
 2021-04-27,USA-06031,Kings,California,3,9.86,6.45,0,0.14,0.09