covidatlas / li

Next-generation serverless crawler for COVID-19 data
Apache License 2.0
57 stars 33 forks source link

tested data for California counties ends 8/31 #610

Open TomGoBravo opened 4 years ago

TomGoBravo commented 4 years ago

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
igorkofman commented 4 years ago

Any updates?