Skip to content
This repository has been archived by the owner on Dec 5, 2022. It is now read-only.

tested data for California counties ends 8/31 #610

Open
TomGoBravo opened this issue Sep 10, 2020 · 1 comment
Open

tested data for California counties ends 8/31 #610

TomGoBravo opened this issue Sep 10, 2020 · 1 comment

Comments

@TomGoBravo
Copy link

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
Copy link

Any updates?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants