li
li copied to clipboard
tested data for California counties ends 8/31
I expect the tested
metric to have data for recent dates but noticed that California counties stopped updating. This means CovidActNow no longer shows Positive test rate
at https://covidactnow.org/us/ca/county/sonoma_county
List of counties with dates:
import pandas as pd
df = pd.read_csv('https://liproduction-reportsbucket-bhk8fnhv1s76.s3-us-west-1.amazonaws.com/v1/latest/timeseries.csv')
df.loc[(df['state']=='California') & (~df['tested'].isna())].groupby('locationID').tail(1).reset_index().loc[:,['locationID','date','tested']].sort_values('date')
Count of California counties by most recent tested date shows most counties stopped updating over a week ago:
df.loc[(df['state']=='California') & (~df['tested'].isna())].groupby('locationID').tail(1)['date'].value_counts()
2020-08-31 40
2020-09-10 5
2020-09-07 1
2020-09-09 1
2020-07-15 1
2020-07-31 1
2020-04-15 1
2020-06-28 1
2020-08-02 1
2020-07-27 1
2020-09-08 1
Count of Illinois counties by most recent tested date looks more like what I'd expect:
df.loc[(df['state']=='Illinois') & (~df['tested'].isna())].groupby('locationID').tail(1)
2020-09-10 104
Any updates?