Updating data.

diff --git a/live/us-counties.csv b/live/us-counties.csv
index 1c156e2..3882e51 100644 (file)
--- a/live/us-counties.csv
+++ b/live/us-counties.csv
@@ -192,7 +192,7 @@ date,county,state,fips,cases,deaths,confirmed_cases,confirmed_deaths,probable_ca
 2021-08-12,Calaveras,California,06009,2509,58,2491,57,18,1
 2021-08-12,Colusa,California,06011,2459,18,2088,16,371,2
 2021-08-12,Contra Costa,California,06013,81603,841,80628,841,975,
-2021-08-12,Del Norte,California,06015,1946,10,1946,10,,
+2021-08-12,Del Norte,California,06015,1972,10,1972,10,,
 2021-08-12,El Dorado,California,06017,12690,121,11734,117,956,4
 2021-08-12,Fresno,California,06019,117294,1747,107616,1747,9678,
 2021-08-12,Glenn,California,06021,3148,27,2538,27,610,0
@@ -202,8 +202,8 @@ date,county,state,fips,cases,deaths,confirmed_cases,confirmed_deaths,probable_ca
 2021-08-12,Kern,California,06029,116475,1433,116475,1433,,
 2021-08-12,Kings,California,06031,25575,253,24370,253,1205,
 2021-08-12,Lake,California,06033,4713,67,4700,67,13,
-2021-08-12,Lassen,California,06035,5970,26,5970,21,,5
-2021-08-12,Los Angeles,California,06037,1333863,24821,1331859,24821,2004,
+2021-08-12,Lassen,California,06035,5977,26,5977,21,,5
+2021-08-12,Los Angeles,California,06037,1336029,24833,1335332,24821,697,12
 2021-08-12,Madera,California,06039,18542,249,17481,245,1061,4
 2021-08-12,Marin,California,06041,15497,239,15194,239,303,
 2021-08-12,Mariposa,California,06043,601,7,601,7,,0
@@ -231,11 +231,11 @@ date,county,state,fips,cases,deaths,confirmed_cases,confirmed_deaths,probable_ca
 2021-08-12,Santa Cruz,California,06087,18029,209,17142,209,887,
 2021-08-12,Shasta,California,06089,15481,244,13604,244,1877,
 2021-08-12,Sierra,California,06091,90,0,76,0,14,
-2021-08-12,Siskiyou,California,06093,2708,40,2708,40,,0
+2021-08-12,Siskiyou,California,06093,2735,40,2735,40,,0
 2021-08-12,Solano,California,06095,37536,262,37355,262,181,
 2021-08-12,Sonoma,California,06097,34474,337,34126,337,348,
 2021-08-12,Stanislaus,California,06099,68119,1102,61228,1102,6891,
-2021-08-12,Sutter,California,06101,10681,130,10681,130,,
+2021-08-12,Sutter,California,06101,10737,130,10737,130,,
 2021-08-12,Tehama,California,06103,6070,66,5392,66,678,
 2021-08-12,Trinity,California,06105,460,3,385,3,75,
 2021-08-12,Tulare,California,06107,61738,854,51489,854,10249,
@@ -1934,7 +1934,7 @@ date,county,state,fips,cases,deaths,confirmed_cases,confirmed_deaths,probable_ca
 2021-08-12,Davidson,North Carolina,37057,18149,209,16081,182,2068,27
 2021-08-12,Davie,North Carolina,37059,4504,43,3550,34,954,9
 2021-08-12,Duplin,North Carolina,37061,7177,146,4723,129,2454,17
-2021-08-12,Durham,North Carolina,37063,27569,241,27569,240,,1
+2021-08-12,Durham,North Carolina,37063,27700,241,27700,240,,1
 2021-08-12,Edgecombe,North Carolina,37065,5980,115,5685,112,295,3
 2021-08-12,Forsyth,North Carolina,37067,39160,435,34754,399,4406,36
 2021-08-12,Franklin,North Carolina,37069,7458,55,7017,54,441,1
@@ -2636,7 +2636,7 @@ date,county,state,fips,cases,deaths,confirmed_cases,confirmed_deaths,probable_ca
 2021-08-12,Baylor,Texas,48023,309,13,135,,174,
 2021-08-12,Bee,Texas,48025,3958,76,3497,,461,
 2021-08-12,Bell,Texas,48027,28616,475,25628,,2988,
-2021-08-12,Bexar,Texas,48029,254645,3728,203975,3643,50670,85
+2021-08-12,Bexar,Texas,48029,256594,3728,203975,3652,52619,76
 2021-08-12,Blanco,Texas,48031,859,22,705,,154,
 2021-08-12,Borden,Texas,48033,33,2,22,,11,
 2021-08-12,Bosque,Texas,48035,1879,38,1500,,379,
@@ -3096,7 +3096,7 @@ date,county,state,fips,cases,deaths,confirmed_cases,confirmed_deaths,probable_ca
 2021-08-12,Walla Walla,Washington,53071,6454,75,6091,74,363,1
 2021-08-12,Whatcom,Washington,53073,10785,109,10280,,505,
 2021-08-12,Whitman,Washington,53075,4547,53,4427,52,120,1
-2021-08-12,Yakima,Washington,53077,33849,464,28478,,5371,
+2021-08-12,Yakima,Washington,53077,34009,464,28478,,5531,
 2021-08-12,Barbour,West Virginia,54001,1587,34,1217,,370,
 2021-08-12,Berkeley,West Virginia,54003,13394,139,10741,,2653,
 2021-08-12,Boone,West Virginia,54005,2250,36,1994,,256,

diff --git a/live/us-states.csv b/live/us-states.csv
index e5c8b43..5f004b0 100644 (file)
--- a/live/us-states.csv
+++ b/live/us-states.csv
@@ -3,7 +3,7 @@ date,state,fips,cases,deaths,confirmed_cases,confirmed_deaths,probable_cases,pro
 2021-08-12,Alaska,02,78415,383,0,383,78415,0
 2021-08-12,Arizona,04,952797,18406,,,,
 2021-08-12,Arkansas,05,410832,6366,312141,5058,98691,1308
-2021-08-12,California,06,4166298,64469,4055682,64445,110616,24
+2021-08-12,California,06,4168580,64481,4059271,64445,109309,36
 2021-08-12,Colorado,08,589778,7170,,,,
 2021-08-12,Connecticut,09,360552,8297,,,,
 2021-08-12,Delaware,10,113251,1836,,,,
@@ -33,7 +33,7 @@ date,state,fips,cases,deaths,confirmed_cases,confirmed_deaths,probable_cases,pro
 2021-08-12,New Jersey,34,1053398,26665,920268,23945,133130,2720
 2021-08-12,New Mexico,35,216494,4439,216494,4439,0,0
 2021-08-12,New York,36,2185142,53400,2170773,48275,14369,5125
-2021-08-12,North Carolina,37,1096220,13806,928918,12180,167302,1626
+2021-08-12,North Carolina,37,1096351,13806,929049,12180,167302,1626
 2021-08-12,North Dakota,38,112775,1574,102825,,9950,
 2021-08-12,Northern Mariana Islands,69,183,2,183,2,0,0
 2021-08-12,Ohio,39,1149318,20580,,,,
@@ -45,12 +45,12 @@ date,state,fips,cases,deaths,confirmed_cases,confirmed_deaths,probable_cases,pro
 2021-08-12,South Carolina,45,648508,10007,529198,8823,119310,1184
 2021-08-12,South Dakota,46,126454,2051,110902,,15552,
 2021-08-12,Tennessee,47,916320,12794,743026,2113,173294,10681
-2021-08-12,Texas,48,3281326,54061,2768214,24199,513112,29862
+2021-08-12,Texas,48,3283275,54061,2768214,24208,515061,29853
 2021-08-12,Utah,49,442319,2518,0,2444,442319,74
 2021-08-12,Vermont,50,25757,263,0,,25757,
 2021-08-12,Virginia,51,713195,11581,,,,
 2021-08-12,Virgin Islands,78,5066,41,5066,41,0,0
-2021-08-12,Washington,53,501781,6250,453358,2052,48423,4198
+2021-08-12,Washington,53,501941,6250,453358,2052,48583,4198
 2021-08-12,West Virginia,54,171202,2974,133242,,37960,
 2021-08-12,Wisconsin,55,701288,8314,633133,7462,68155,852
 2021-08-12,Wyoming,56,67582,793,56187,,11395,
\ No newline at end of file

diff --git a/live/us.csv b/live/us.csv
index a302581..7cd35c7 100644 (file)
--- a/live/us.csv
+++ b/live/us.csv
@@ -1,2 +1,2 @@
 date,cases,deaths,confirmed_cases,confirmed_deaths,probable_cases,probable_deaths
-2021-08-12,36303737,618689,,,,
\ No newline at end of file
+2021-08-12,36308259,618701,,,,
\ No newline at end of file

diff --git a/rolling-averages/anomalies.csv b/rolling-averages/anomalies.csv
index d4761b9..38f05ff 100644 (file)
--- a/rolling-averages/anomalies.csv
+++ b/rolling-averages/anomalies.csv
@@ -757,9 +757,13 @@ date,end_date,county,state,geoid,type,omit_from_rolling_average,omit_from_rollin
 2021-07-31,,Knox,Nebraska,USA-31107,both,,,State and local officials are no longer reporting data.
 2021-07-31,,Pierce,Nebraska,USA-31139,both,,,State and local officials are no longer reporting data.
 2021-07-31,,Rock,Nebraska,USA-31149,both,,,State and local officials are no longer reporting data.
+2021-08-02,,Santa Clara,California,USA-06085,deaths,yes,,California added a backlog of deaths in Santa Clara County.
 2021-08-03,,Hood,Texas,USA-48221,cases,yes,,Texas added a backlog of 140 cases in Hood County.
 2021-08-06,,,Texas,USA-48,cases,yes,,"Texas added around 7,000 probable cases in Cameron County."
 2021-08-06,,Cameron,Texas,USA-48061,cases,yes,,Texas began reporting probable cases in Cameron County.
 2021-08-09,2021-08-11,New York City,New York,USA-36998,both,,,New York City released three days of data at once on Aug. 11 after the city was unable to update for two days because of technical issues.
 2021-08-09,,,North Carolina,USA-37,cases,,,"North Carolina added a backlog of about 2,600 cases from July."
-2021-08-09,,,Rhode Island,USA-44,both,,,"Rhode Island did not release data because of Victory Day, a state holiday."
\ No newline at end of file
+2021-08-09,,,Rhode Island,USA-44,both,,,"Rhode Island did not release data because of Victory Day, a state holiday."
+2021-08-11,,,New York,USA-36,cases,,,"New York City released three days of data at once, resulting in a high one-day total for the state."
+2021-08-11,,,California,USA-06,deaths,yes,,California removed around 400 deaths in Santa Clara County after verifying records.
+2021-08-11,,Santa Clara,California,USA-06085,deaths,yes,,California removed around 400 deaths in Santa Clara County after verifying records.
\ No newline at end of file

diff --git a/rolling-averages/us-counties-recent.csv b/rolling-averages/us-counties-recent.csv
index b7505ce..291b35a 100644 (file)
--- a/rolling-averages/us-counties-recent.csv
+++ b/rolling-averages/us-counties-recent.csv
@@ -68013,7 +68013,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-02,USA-06091,Sierra,California,3,0.86,28.52,0,0,0
 2021-08-02,USA-06089,Shasta,California,118,38.29,21.26,0,0,0
 2021-08-02,USA-06087,Santa Cruz,California,133,33.86,12.39,0,0,0
-2021-08-02,USA-06085,Santa Clara,California,897,249.14,12.92,84,12,0.62
+2021-08-02,USA-06085,Santa Clara,California,897,249.14,12.92,84,0,0
 2021-08-02,USA-06083,Santa Barbara,California,278,81.71,18.3,2,0.29,0.06
 2021-08-02,USA-06081,San Mateo,California,414,126.14,16.46,0,0,0
 2021-08-02,USA-06079,San Luis Obispo,California,161,51.57,18.22,0,0.14,0.05
@@ -71263,7 +71263,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-03,USA-06091,Sierra,California,0,0.86,28.52,0,0,0
 2021-08-03,USA-06089,Shasta,California,13,39.57,21.97,0,0,0
 2021-08-03,USA-06087,Santa Cruz,California,37,36.43,13.33,0,0,0
-2021-08-03,USA-06085,Santa Clara,California,144,244.29,12.67,0,12,0.62
+2021-08-03,USA-06085,Santa Clara,California,144,244.29,12.67,0,0,0
 2021-08-03,USA-06083,Santa Barbara,California,42,80.57,18.05,0,0.29,0.06
 2021-08-03,USA-06081,San Mateo,California,118,127.57,16.64,0,0,0
 2021-08-03,USA-06079,San Luis Obispo,California,10,51.43,18.17,0,0,0
@@ -74512,7 +74512,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-04,USA-06091,Sierra,California,1,1,33.28,0,0,0
 2021-08-04,USA-06089,Shasta,California,42,41.71,23.16,0,0,0
 2021-08-04,USA-06087,Santa Cruz,California,32,36.71,13.44,0,0,0
-2021-08-04,USA-06085,Santa Clara,California,259,256.14,13.29,0,12,0.62
+2021-08-04,USA-06085,Santa Clara,California,259,256.14,13.29,0,0,0
 2021-08-04,USA-06083,Santa Barbara,California,61,83,18.59,0,0.29,0.06
 2021-08-04,USA-06081,San Mateo,California,101,130.43,17.01,0,0,0
 2021-08-04,USA-06079,San Luis Obispo,California,73,54.57,19.28,2,0.29,0.1
@@ -77761,7 +77761,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-05,USA-06091,Sierra,California,1,0.86,28.52,0,0,0
 2021-08-05,USA-06089,Shasta,California,97,43.71,24.27,1,0.14,0.08
 2021-08-05,USA-06087,Santa Cruz,California,44,38.71,14.17,1,0.14,0.05
-2021-08-05,USA-06085,Santa Clara,California,238,258.14,13.39,0,12,0.62
+2021-08-05,USA-06085,Santa Clara,California,238,258.14,13.39,0,0,0
 2021-08-05,USA-06083,Santa Barbara,California,111,84.57,18.94,1,0.43,0.1
 2021-08-05,USA-06081,San Mateo,California,191,138.43,18.06,0,0,0
 2021-08-05,USA-06079,San Luis Obispo,California,109,58.57,20.69,0,0.29,0.1
@@ -81010,7 +81010,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-06,USA-06091,Sierra,California,0,0.71,23.77,0,0,0
 2021-08-06,USA-06089,Shasta,California,83,50.43,28,0,0.14,0.08
 2021-08-06,USA-06087,Santa Cruz,California,47,41.86,15.32,-1,0.17,0.06
-2021-08-06,USA-06085,Santa Clara,California,363,271.57,14.09,2,12.29,0.64
+2021-08-06,USA-06085,Santa Clara,California,363,271.57,14.09,2,0.33,0.02
 2021-08-06,USA-06083,Santa Barbara,California,99,84.43,18.91,0,0.43,0.1
 2021-08-06,USA-06081,San Mateo,California,162,140.86,18.37,0,0,0
 2021-08-06,USA-06079,San Luis Obispo,California,117,67.14,23.72,0,0.29,0.1
@@ -84259,7 +84259,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-07,USA-06091,Sierra,California,0,0.71,23.77,0,0,0
 2021-08-07,USA-06089,Shasta,California,0,50.43,28,0,0.14,0.08
 2021-08-07,USA-06087,Santa Cruz,California,0,41.86,15.32,0,0.17,0.06
-2021-08-07,USA-06085,Santa Clara,California,0,271.57,14.09,0,12.29,0.64
+2021-08-07,USA-06085,Santa Clara,California,0,271.57,14.09,0,0.33,0.02
 2021-08-07,USA-06083,Santa Barbara,California,0,84.43,18.91,0,0.43,0.1
 2021-08-07,USA-06081,San Mateo,California,0,140.86,18.37,0,0,0
 2021-08-07,USA-06079,San Luis Obispo,California,0,67.14,23.72,0,0.29,0.1
@@ -87507,7 +87507,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-08,USA-06091,Sierra,California,1,0.86,28.52,0,0,0
 2021-08-08,USA-06089,Shasta,California,144,71,39.43,0,0.14,0.08
 2021-08-08,USA-06087,Santa Cruz,California,127,60,21.96,2,0.5,0.18
-2021-08-08,USA-06085,Santa Clara,California,706,372.43,19.32,3,12.71,0.66
+2021-08-08,USA-06085,Santa Clara,California,706,372.43,19.32,3,0.83,0.04
 2021-08-08,USA-06083,Santa Barbara,California,191,111.71,25.02,0,0.43,0.1
 2021-08-08,USA-06081,San Mateo,California,250,176.57,23.03,0,0,0
 2021-08-08,USA-06079,San Luis Obispo,California,217,98.14,34.67,0,0.29,0.1
@@ -94467,7 +94467,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-11,USA-54005,Boone,West Virginia,9,5,23.3,0,0,0
 2021-08-11,USA-54003,Berkeley,West Virginia,54,29.71,24.93,0,0.14,0.12
 2021-08-11,USA-54001,Barbour,West Virginia,8,4.43,26.94,0,0,0
-2021-08-11,USA-53077,Yakima,Washington,0,64.43,25.68,0,0.57,0.23
+2021-08-11,USA-53077,Yakima,Washington,160,87.29,34.79,0,0.57,0.23
 2021-08-11,USA-53075,Whitman,Washington,8,8.57,17.11,1,0.14,0.29
 2021-08-11,USA-53073,Whatcom,Washington,76,43,18.76,0,0,0
 2021-08-11,USA-53071,Walla Walla,Washington,42,28.29,46.55,0,0.43,0.71
@@ -94923,7 +94923,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-11,USA-48035,Bosque,Texas,15,7.86,42.05,0,0,0
 2021-08-11,USA-48033,Borden,Texas,1,0.14,21.84,0,0,0
 2021-08-11,USA-48031,Blanco,Texas,8,5,41.91,0,0.14,1.2
-2021-08-11,USA-48029,Bexar,Texas,0,1404.43,70.1,10,5.57,0.28
+2021-08-11,USA-48029,Bexar,Texas,1949,1682.86,83.99,10,5.57,0.28
 2021-08-11,USA-48027,Bell,Texas,544,167.86,46.25,5,1.57,0.43
 2021-08-11,USA-48025,Bee,Texas,43,26.57,81.6,0,0.14,0.44
 2021-08-11,USA-48023,Baylor,Texas,0,0.14,4.07,0,0,0
@@ -95544,7 +95544,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-11,USA-37069,Franklin,North Carolina,39,29.14,41.82,0,0,0
 2021-08-11,USA-37067,Forsyth,North Carolina,115,122.43,32.02,0,0.43,0.11
 2021-08-11,USA-37065,Edgecombe,North Carolina,7,11.14,21.65,0,0.17,0.32
-2021-08-11,USA-37063,Durham,North Carolina,0,95.29,29.64,0,0.14,0.04
+2021-08-11,USA-37063,Durham,North Carolina,131,114,35.46,0,0.14,0.04
 2021-08-11,USA-37061,Duplin,North Carolina,49,41.86,71.26,0,0.29,0.49
 2021-08-11,USA-37059,Davie,North Carolina,19,18.43,43.01,0,0,0
 2021-08-11,USA-37057,Davidson,North Carolina,60,74.14,44.24,3,0.43,0.26
@@ -97246,7 +97246,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-11,USA-06099,Stanislaus,California,230,214.29,38.91,2,0.71,0.13
 2021-08-11,USA-06097,Sonoma,California,121,119.29,24.13,0,0.86,0.17
 2021-08-11,USA-06095,Solano,California,114,123.14,27.51,0,0.14,0.03
-2021-08-11,USA-06093,Siskiyou,California,0,14.71,33.8,0,0,0
+2021-08-11,USA-06093,Siskiyou,California,27,18.57,42.65,0,0,0
 2021-08-11,USA-06091,Sierra,California,1,0.57,19.02,0,0,0
 2021-08-11,USA-06089,Shasta,California,64,60.57,33.64,0,0.29,0.16
 2021-08-11,USA-06087,Santa Cruz,California,60,52.29,19.14,0,0.5,0.18
@@ -97274,7 +97274,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-11,USA-06043,Mariposa,California,9,9.14,53.15,0,0,0
 2021-08-11,USA-06041,Marin,California,40,41.71,16.12,0,0,0
 2021-08-11,USA-06039,Madera,California,52,42,26.7,0,0,0
-2021-08-11,USA-06037,Los Angeles,California,1307,3073,30.61,16,14.29,0.14
+2021-08-11,USA-06037,Los Angeles,California,3473,3382.43,33.69,28,16,0.16
 2021-08-11,USA-06035,Lassen,California,0,9.29,30.37,0,0,0
 2021-08-11,USA-06033,Lake,California,30,41.71,64.79,1,0.33,0.52
 2021-08-11,USA-06031,Kings,California,97,75,49.04,0,0.14,0.09
@@ -97285,7 +97285,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-11,USA-06021,Glenn,California,6,9.57,33.71,0,0,0
 2021-08-11,USA-06019,Fresno,California,306,281.71,28.2,0,0.14,0.01
 2021-08-11,USA-06017,El Dorado,California,62,77.57,40.23,0,0.14,0.07
-2021-08-11,USA-06015,Del Norte,California,0,28.43,102.22,0,0,0
+2021-08-11,USA-06015,Del Norte,California,26,32.14,115.57,0,0,0
 2021-08-11,USA-06013,Contra Costa,California,278,330.43,28.65,1,0.43,0.04
 2021-08-11,USA-06011,Colusa,California,18,11.14,51.71,0,0,0
 2021-08-11,USA-06009,Calaveras,California,19,19.14,41.7,0,0,0

diff --git a/rolling-averages/us-counties.csv b/rolling-averages/us-counties.csv
index eea343a..d349c2a 100644 (file)
--- a/rolling-averages/us-counties.csv
+++ b/rolling-averages/us-counties.csv
@@ -1583809,7 +1583809,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-02,USA-06091,Sierra,California,3,0.86,28.52,0,0,0
 2021-08-02,USA-06089,Shasta,California,118,38.29,21.26,0,0,0
 2021-08-02,USA-06087,Santa Cruz,California,133,33.86,12.39,0,0,0
-2021-08-02,USA-06085,Santa Clara,California,897,249.14,12.92,84,12,0.62
+2021-08-02,USA-06085,Santa Clara,California,897,249.14,12.92,84,0,0
 2021-08-02,USA-06083,Santa Barbara,California,278,81.71,18.3,2,0.29,0.06
 2021-08-02,USA-06081,San Mateo,California,414,126.14,16.46,0,0,0
 2021-08-02,USA-06079,San Luis Obispo,California,161,51.57,18.22,0,0.14,0.05
@@ -1587059,7 +1587059,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-03,USA-06091,Sierra,California,0,0.86,28.52,0,0,0
 2021-08-03,USA-06089,Shasta,California,13,39.57,21.97,0,0,0
 2021-08-03,USA-06087,Santa Cruz,California,37,36.43,13.33,0,0,0
-2021-08-03,USA-06085,Santa Clara,California,144,244.29,12.67,0,12,0.62
+2021-08-03,USA-06085,Santa Clara,California,144,244.29,12.67,0,0,0
 2021-08-03,USA-06083,Santa Barbara,California,42,80.57,18.05,0,0.29,0.06
 2021-08-03,USA-06081,San Mateo,California,118,127.57,16.64,0,0,0
 2021-08-03,USA-06079,San Luis Obispo,California,10,51.43,18.17,0,0,0
@@ -1590308,7 +1590308,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-04,USA-06091,Sierra,California,1,1,33.28,0,0,0
 2021-08-04,USA-06089,Shasta,California,42,41.71,23.16,0,0,0
 2021-08-04,USA-06087,Santa Cruz,California,32,36.71,13.44,0,0,0
-2021-08-04,USA-06085,Santa Clara,California,259,256.14,13.29,0,12,0.62
+2021-08-04,USA-06085,Santa Clara,California,259,256.14,13.29,0,0,0
 2021-08-04,USA-06083,Santa Barbara,California,61,83,18.59,0,0.29,0.06
 2021-08-04,USA-06081,San Mateo,California,101,130.43,17.01,0,0,0
 2021-08-04,USA-06079,San Luis Obispo,California,73,54.57,19.28,2,0.29,0.1
@@ -1593557,7 +1593557,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-05,USA-06091,Sierra,California,1,0.86,28.52,0,0,0
 2021-08-05,USA-06089,Shasta,California,97,43.71,24.27,1,0.14,0.08
 2021-08-05,USA-06087,Santa Cruz,California,44,38.71,14.17,1,0.14,0.05
-2021-08-05,USA-06085,Santa Clara,California,238,258.14,13.39,0,12,0.62
+2021-08-05,USA-06085,Santa Clara,California,238,258.14,13.39,0,0,0
 2021-08-05,USA-06083,Santa Barbara,California,111,84.57,18.94,1,0.43,0.1
 2021-08-05,USA-06081,San Mateo,California,191,138.43,18.06,0,0,0
 2021-08-05,USA-06079,San Luis Obispo,California,109,58.57,20.69,0,0.29,0.1
@@ -1596806,7 +1596806,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-06,USA-06091,Sierra,California,0,0.71,23.77,0,0,0
 2021-08-06,USA-06089,Shasta,California,83,50.43,28,0,0.14,0.08
 2021-08-06,USA-06087,Santa Cruz,California,47,41.86,15.32,-1,0.17,0.06
-2021-08-06,USA-06085,Santa Clara,California,363,271.57,14.09,2,12.29,0.64
+2021-08-06,USA-06085,Santa Clara,California,363,271.57,14.09,2,0.33,0.02
 2021-08-06,USA-06083,Santa Barbara,California,99,84.43,18.91,0,0.43,0.1
 2021-08-06,USA-06081,San Mateo,California,162,140.86,18.37,0,0,0
 2021-08-06,USA-06079,San Luis Obispo,California,117,67.14,23.72,0,0.29,0.1
@@ -1600055,7 +1600055,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-07,USA-06091,Sierra,California,0,0.71,23.77,0,0,0
 2021-08-07,USA-06089,Shasta,California,0,50.43,28,0,0.14,0.08
 2021-08-07,USA-06087,Santa Cruz,California,0,41.86,15.32,0,0.17,0.06
-2021-08-07,USA-06085,Santa Clara,California,0,271.57,14.09,0,12.29,0.64
+2021-08-07,USA-06085,Santa Clara,California,0,271.57,14.09,0,0.33,0.02
 2021-08-07,USA-06083,Santa Barbara,California,0,84.43,18.91,0,0.43,0.1
 2021-08-07,USA-06081,San Mateo,California,0,140.86,18.37,0,0,0
 2021-08-07,USA-06079,San Luis Obispo,California,0,67.14,23.72,0,0.29,0.1
@@ -1603303,7 +1603303,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-08,USA-06091,Sierra,California,1,0.86,28.52,0,0,0
 2021-08-08,USA-06089,Shasta,California,144,71,39.43,0,0.14,0.08
 2021-08-08,USA-06087,Santa Cruz,California,127,60,21.96,2,0.5,0.18
-2021-08-08,USA-06085,Santa Clara,California,706,372.43,19.32,3,12.71,0.66
+2021-08-08,USA-06085,Santa Clara,California,706,372.43,19.32,3,0.83,0.04
 2021-08-08,USA-06083,Santa Barbara,California,191,111.71,25.02,0,0.43,0.1
 2021-08-08,USA-06081,San Mateo,California,250,176.57,23.03,0,0,0
 2021-08-08,USA-06079,San Luis Obispo,California,217,98.14,34.67,0,0.29,0.1
@@ -1610263,7 +1610263,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-11,USA-54005,Boone,West Virginia,9,5,23.3,0,0,0
 2021-08-11,USA-54003,Berkeley,West Virginia,54,29.71,24.93,0,0.14,0.12
 2021-08-11,USA-54001,Barbour,West Virginia,8,4.43,26.94,0,0,0
-2021-08-11,USA-53077,Yakima,Washington,0,64.43,25.68,0,0.57,0.23
+2021-08-11,USA-53077,Yakima,Washington,160,87.29,34.79,0,0.57,0.23
 2021-08-11,USA-53075,Whitman,Washington,8,8.57,17.11,1,0.14,0.29
 2021-08-11,USA-53073,Whatcom,Washington,76,43,18.76,0,0,0
 2021-08-11,USA-53071,Walla Walla,Washington,42,28.29,46.55,0,0.43,0.71
@@ -1610719,7 +1610719,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-11,USA-48035,Bosque,Texas,15,7.86,42.05,0,0,0
 2021-08-11,USA-48033,Borden,Texas,1,0.14,21.84,0,0,0
 2021-08-11,USA-48031,Blanco,Texas,8,5,41.91,0,0.14,1.2
-2021-08-11,USA-48029,Bexar,Texas,0,1404.43,70.1,10,5.57,0.28
+2021-08-11,USA-48029,Bexar,Texas,1949,1682.86,83.99,10,5.57,0.28
 2021-08-11,USA-48027,Bell,Texas,544,167.86,46.25,5,1.57,0.43
 2021-08-11,USA-48025,Bee,Texas,43,26.57,81.6,0,0.14,0.44
 2021-08-11,USA-48023,Baylor,Texas,0,0.14,4.07,0,0,0
@@ -1611340,7 +1611340,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-11,USA-37069,Franklin,North Carolina,39,29.14,41.82,0,0,0
 2021-08-11,USA-37067,Forsyth,North Carolina,115,122.43,32.02,0,0.43,0.11
 2021-08-11,USA-37065,Edgecombe,North Carolina,7,11.14,21.65,0,0.17,0.32
-2021-08-11,USA-37063,Durham,North Carolina,0,95.29,29.64,0,0.14,0.04
+2021-08-11,USA-37063,Durham,North Carolina,131,114,35.46,0,0.14,0.04
 2021-08-11,USA-37061,Duplin,North Carolina,49,41.86,71.26,0,0.29,0.49
 2021-08-11,USA-37059,Davie,North Carolina,19,18.43,43.01,0,0,0
 2021-08-11,USA-37057,Davidson,North Carolina,60,74.14,44.24,3,0.43,0.26
@@ -1613042,7 +1613042,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-11,USA-06099,Stanislaus,California,230,214.29,38.91,2,0.71,0.13
 2021-08-11,USA-06097,Sonoma,California,121,119.29,24.13,0,0.86,0.17
 2021-08-11,USA-06095,Solano,California,114,123.14,27.51,0,0.14,0.03
-2021-08-11,USA-06093,Siskiyou,California,0,14.71,33.8,0,0,0
+2021-08-11,USA-06093,Siskiyou,California,27,18.57,42.65,0,0,0
 2021-08-11,USA-06091,Sierra,California,1,0.57,19.02,0,0,0
 2021-08-11,USA-06089,Shasta,California,64,60.57,33.64,0,0.29,0.16
 2021-08-11,USA-06087,Santa Cruz,California,60,52.29,19.14,0,0.5,0.18
@@ -1613070,7 +1613070,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-11,USA-06043,Mariposa,California,9,9.14,53.15,0,0,0
 2021-08-11,USA-06041,Marin,California,40,41.71,16.12,0,0,0
 2021-08-11,USA-06039,Madera,California,52,42,26.7,0,0,0
-2021-08-11,USA-06037,Los Angeles,California,1307,3073,30.61,16,14.29,0.14
+2021-08-11,USA-06037,Los Angeles,California,3473,3382.43,33.69,28,16,0.16
 2021-08-11,USA-06035,Lassen,California,0,9.29,30.37,0,0,0
 2021-08-11,USA-06033,Lake,California,30,41.71,64.79,1,0.33,0.52
 2021-08-11,USA-06031,Kings,California,97,75,49.04,0,0.14,0.09
@@ -1613081,7 +1613081,7 @@ date,geoid,county,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,dea
 2021-08-11,USA-06021,Glenn,California,6,9.57,33.71,0,0,0
 2021-08-11,USA-06019,Fresno,California,306,281.71,28.2,0,0.14,0.01
 2021-08-11,USA-06017,El Dorado,California,62,77.57,40.23,0,0.14,0.07
-2021-08-11,USA-06015,Del Norte,California,0,28.43,102.22,0,0,0
+2021-08-11,USA-06015,Del Norte,California,26,32.14,115.57,0,0,0
 2021-08-11,USA-06013,Contra Costa,California,278,330.43,28.65,1,0.43,0.04
 2021-08-11,USA-06011,Colusa,California,18,11.14,51.71,0,0,0
 2021-08-11,USA-06009,Calaveras,California,19,19.14,41.7,0,0,0

diff --git a/rolling-averages/us-states.csv b/rolling-averages/us-states.csv
index 3578d8c..6148302 100644 (file)
--- a/rolling-averages/us-states.csv
+++ b/rolling-averages/us-states.csv
@@ -28950,11 +28950,11 @@ date,geoid,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg
 2021-08-11,USA-56,Wyoming,256,232.71,40.21,0,1,0.17
 2021-08-11,USA-55,Wisconsin,1524,1269.57,21.8,3,2.83,0.05
 2021-08-11,USA-54,West Virginia,546,410.29,22.89,2,2.57,0.14
-2021-08-11,USA-53,Washington,4010,2420.43,31.79,17,9.29,0.12
+2021-08-11,USA-53,Washington,4170,2443.29,32.09,17,9.29,0.12
 2021-08-11,USA-51,Virginia,2117,1733.71,20.31,3,5.71,0.07
 2021-08-11,USA-50,Vermont,94,89.71,14.38,0,0.43,0.07
 2021-08-11,USA-49,Utah,1115,822.43,25.65,7,5.57,0.17
-2021-08-11,USA-48,Texas,19905,13791.83,47.56,108,68.86,0.24
+2021-08-11,USA-48,Texas,21854,14116.67,48.69,108,68.86,0.24
 2021-08-11,USA-47,Tennessee,4156,3387.57,49.6,7,15,0.22
 2021-08-11,USA-46,South Dakota,862,123.14,13.92,1,0.14,0.02
 2021-08-11,USA-45,South Carolina,2649,2900.86,56.34,15,11,0.21
@@ -28964,7 +28964,7 @@ date,geoid,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg
 2021-08-11,USA-40,Oklahoma,2199,2030.57,51.32,63,9,0.23
 2021-08-11,USA-39,Ohio,3393,2050.43,17.54,0,7.14,0.06
 2021-08-11,USA-38,North Dakota,184,115.86,15.2,1,0.29,0.04
-2021-08-11,USA-37,North Carolina,4844,4673.57,44.56,22,12.86,0.12
+2021-08-11,USA-37,North Carolina,4975,4692.29,44.74,22,12.86,0.12
 2021-08-11,USA-36,New York,7224,3714.71,19.1,40,14.14,0.07
 2021-08-11,USA-35,New Mexico,713,559.57,26.69,7,3,0.14
 2021-08-11,USA-34,New Jersey,1686,1385.14,15.59,6,5.71,0.06
@@ -28993,7 +28993,7 @@ date,geoid,state,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg
 2021-08-11,USA-10,Delaware,161,195.29,20.05,0,0.43,0.04
 2021-08-11,USA-09,Connecticut,914,550.14,15.43,0,0.71,0.02
 2021-08-11,USA-08,Colorado,1161,1065.14,18.5,3,7.43,0.13
-2021-08-11,USA-06,California,9260,11756.57,29.75,-369,35.33,0.09
+2021-08-11,USA-06,California,11479,12073.57,30.56,-357,35.33,0.09
 2021-08-11,USA-05,Arkansas,2940,2338.71,77.5,20,19.43,0.64
 2021-08-11,USA-04,Arizona,1970,2450,33.66,6,16.71,0.23
 2021-08-11,USA-02,Alaska,375,312.14,42.67,0,1,0.14

diff --git a/rolling-averages/us.csv b/rolling-averages/us.csv
index be44685..ef9d0ff 100644 (file)
--- a/rolling-averages/us.csv
+++ b/rolling-averages/us.csv
@@ -567,4 +567,4 @@ date,geoid,cases,cases_avg,cases_avg_per_100k,deaths,deaths_avg,deaths_avg_per_1
 2021-08-08,USA,36068,110360,33.26,131,516,0.16
 2021-08-09,USA,178466,116379.43,35.07,720,553.43,0.17
 2021-08-10,USA,161990,118066.57,35.58,1049,607.71,0.18
-2021-08-11,USA,151117,123596.71,37.25,326,550.71,0.17
\ No newline at end of file
+2021-08-11,USA,155576,124233.71,37.44,338,552.43,0.17
\ No newline at end of file

diff --git a/us-counties-recent.csv b/us-counties-recent.csv
index 181aab2..da2eca7 100644 (file)
--- a/us-counties-recent.csv
+++ b/us-counties-recent.csv
@@ -94353,7 +94353,7 @@ date,county,state,fips,cases,deaths
 2021-08-11,Calaveras,California,06009,2509,58
 2021-08-11,Colusa,California,06011,2459,18
 2021-08-11,Contra Costa,California,06013,81603,841
-2021-08-11,Del Norte,California,06015,1946,10
+2021-08-11,Del Norte,California,06015,1972,10
 2021-08-11,El Dorado,California,06017,12690,121
 2021-08-11,Fresno,California,06019,117294,1747
 2021-08-11,Glenn,California,06021,3148,27
@@ -94364,7 +94364,7 @@ date,county,state,fips,cases,deaths
 2021-08-11,Kings,California,06031,25575,253
 2021-08-11,Lake,California,06033,4713,67
 2021-08-11,Lassen,California,06035,5970,26
-2021-08-11,Los Angeles,California,06037,1333863,24821
+2021-08-11,Los Angeles,California,06037,1336029,24833
 2021-08-11,Madera,California,06039,18542,249
 2021-08-11,Marin,California,06041,15497,239
 2021-08-11,Mariposa,California,06043,601,7
@@ -94392,7 +94392,7 @@ date,county,state,fips,cases,deaths
 2021-08-11,Santa Cruz,California,06087,18029,209
 2021-08-11,Shasta,California,06089,15481,244
 2021-08-11,Sierra,California,06091,90,0
-2021-08-11,Siskiyou,California,06093,2708,40
+2021-08-11,Siskiyou,California,06093,2735,40
 2021-08-11,Solano,California,06095,37536,262
 2021-08-11,Sonoma,California,06097,34474,337
 2021-08-11,Stanislaus,California,06099,68119,1102
@@ -96095,7 +96095,7 @@ date,county,state,fips,cases,deaths
 2021-08-11,Davidson,North Carolina,37057,18149,209
 2021-08-11,Davie,North Carolina,37059,4504,43
 2021-08-11,Duplin,North Carolina,37061,7177,146
-2021-08-11,Durham,North Carolina,37063,27569,241
+2021-08-11,Durham,North Carolina,37063,27700,241
 2021-08-11,Edgecombe,North Carolina,37065,5980,115
 2021-08-11,Forsyth,North Carolina,37067,39160,435
 2021-08-11,Franklin,North Carolina,37069,7458,55
@@ -96797,7 +96797,7 @@ date,county,state,fips,cases,deaths
 2021-08-11,Baylor,Texas,48023,309,13
 2021-08-11,Bee,Texas,48025,3958,76
 2021-08-11,Bell,Texas,48027,28616,475
-2021-08-11,Bexar,Texas,48029,254645,3728
+2021-08-11,Bexar,Texas,48029,256594,3728
 2021-08-11,Blanco,Texas,48031,859,22
 2021-08-11,Borden,Texas,48033,33,2
 2021-08-11,Bosque,Texas,48035,1879,38
@@ -97257,7 +97257,7 @@ date,county,state,fips,cases,deaths
 2021-08-11,Walla Walla,Washington,53071,6454,75
 2021-08-11,Whatcom,Washington,53073,10785,109
 2021-08-11,Whitman,Washington,53075,4547,53
-2021-08-11,Yakima,Washington,53077,33849,464
+2021-08-11,Yakima,Washington,53077,34009,464
 2021-08-11,Barbour,West Virginia,54001,1587,34
 2021-08-11,Berkeley,West Virginia,54003,13394,139
 2021-08-11,Boone,West Virginia,54005,2250,36

diff --git a/us-counties.csv b/us-counties.csv
index 0701ccf..6c34100 100644 (file)
--- a/us-counties.csv
+++ b/us-counties.csv
@@ -1605606,7 +1605606,7 @@ date,county,state,fips,cases,deaths
 2021-08-11,Calaveras,California,06009,2509,58
 2021-08-11,Colusa,California,06011,2459,18
 2021-08-11,Contra Costa,California,06013,81603,841
-2021-08-11,Del Norte,California,06015,1946,10
+2021-08-11,Del Norte,California,06015,1972,10
 2021-08-11,El Dorado,California,06017,12690,121
 2021-08-11,Fresno,California,06019,117294,1747
 2021-08-11,Glenn,California,06021,3148,27
@@ -1605617,7 +1605617,7 @@ date,county,state,fips,cases,deaths
 2021-08-11,Kings,California,06031,25575,253
 2021-08-11,Lake,California,06033,4713,67
 2021-08-11,Lassen,California,06035,5970,26
-2021-08-11,Los Angeles,California,06037,1333863,24821
+2021-08-11,Los Angeles,California,06037,1336029,24833
 2021-08-11,Madera,California,06039,18542,249
 2021-08-11,Marin,California,06041,15497,239
 2021-08-11,Mariposa,California,06043,601,7
@@ -1605645,7 +1605645,7 @@ date,county,state,fips,cases,deaths
 2021-08-11,Santa Cruz,California,06087,18029,209
 2021-08-11,Shasta,California,06089,15481,244
 2021-08-11,Sierra,California,06091,90,0
-2021-08-11,Siskiyou,California,06093,2708,40
+2021-08-11,Siskiyou,California,06093,2735,40
 2021-08-11,Solano,California,06095,37536,262
 2021-08-11,Sonoma,California,06097,34474,337
 2021-08-11,Stanislaus,California,06099,68119,1102
@@ -1607348,7 +1607348,7 @@ date,county,state,fips,cases,deaths
 2021-08-11,Davidson,North Carolina,37057,18149,209
 2021-08-11,Davie,North Carolina,37059,4504,43
 2021-08-11,Duplin,North Carolina,37061,7177,146
-2021-08-11,Durham,North Carolina,37063,27569,241
+2021-08-11,Durham,North Carolina,37063,27700,241
 2021-08-11,Edgecombe,North Carolina,37065,5980,115
 2021-08-11,Forsyth,North Carolina,37067,39160,435
 2021-08-11,Franklin,North Carolina,37069,7458,55
@@ -1608050,7 +1608050,7 @@ date,county,state,fips,cases,deaths
 2021-08-11,Baylor,Texas,48023,309,13
 2021-08-11,Bee,Texas,48025,3958,76
 2021-08-11,Bell,Texas,48027,28616,475
-2021-08-11,Bexar,Texas,48029,254645,3728
+2021-08-11,Bexar,Texas,48029,256594,3728
 2021-08-11,Blanco,Texas,48031,859,22
 2021-08-11,Borden,Texas,48033,33,2
 2021-08-11,Bosque,Texas,48035,1879,38
@@ -1608510,7 +1608510,7 @@ date,county,state,fips,cases,deaths
 2021-08-11,Walla Walla,Washington,53071,6454,75
 2021-08-11,Whatcom,Washington,53073,10785,109
 2021-08-11,Whitman,Washington,53075,4547,53
-2021-08-11,Yakima,Washington,53077,33849,464
+2021-08-11,Yakima,Washington,53077,34009,464
 2021-08-11,Barbour,West Virginia,54001,1587,34
 2021-08-11,Berkeley,West Virginia,54003,13394,139
 2021-08-11,Boone,West Virginia,54005,2250,36

diff --git a/us-states.csv b/us-states.csv
index 6b3d3c2..5515070 100644 (file)
--- a/us-states.csv
+++ b/us-states.csv
@@ -28947,7 +28947,7 @@ date,state,fips,cases,deaths
 2021-08-11,Alaska,02,78415,383
 2021-08-11,Arizona,04,952797,18406
 2021-08-11,Arkansas,05,410832,6366
-2021-08-11,California,06,4166298,64469
+2021-08-11,California,06,4168517,64481
 2021-08-11,Colorado,08,589778,7170
 2021-08-11,Connecticut,09,360552,8297
 2021-08-11,Delaware,10,113251,1836
@@ -28977,7 +28977,7 @@ date,state,fips,cases,deaths
 2021-08-11,New Jersey,34,1053398,26665
 2021-08-11,New Mexico,35,216494,4439
 2021-08-11,New York,36,2185142,53400
-2021-08-11,North Carolina,37,1096220,13806
+2021-08-11,North Carolina,37,1096351,13806
 2021-08-11,North Dakota,38,112775,1574
 2021-08-11,Northern Mariana Islands,69,183,2
 2021-08-11,Ohio,39,1149318,20580
@@ -28989,12 +28989,12 @@ date,state,fips,cases,deaths
 2021-08-11,South Carolina,45,648508,10007
 2021-08-11,South Dakota,46,126454,2051
 2021-08-11,Tennessee,47,916320,12794
-2021-08-11,Texas,48,3281326,54061
+2021-08-11,Texas,48,3283275,54061
 2021-08-11,Utah,49,442319,2518
 2021-08-11,Vermont,50,25757,263
 2021-08-11,Virgin Islands,78,5066,41
 2021-08-11,Virginia,51,713195,11581
-2021-08-11,Washington,53,501781,6250
+2021-08-11,Washington,53,501941,6250
 2021-08-11,West Virginia,54,171202,2974
 2021-08-11,Wisconsin,55,701288,8314
 2021-08-11,Wyoming,56,67582,793
\ No newline at end of file

diff --git a/us.csv b/us.csv
index 24a5af3..3ac859c 100644 (file)
--- a/us.csv
+++ b/us.csv
@@ -567,4 +567,4 @@ date,cases,deaths
 2021-08-08,35812164,616594
 2021-08-09,35990630,617314
 2021-08-10,36152620,618363
-2021-08-11,36303737,618689
\ No newline at end of file
+2021-08-11,36308196,618701
\ No newline at end of file