search

CSSEGISandData / COVID-19

Novel Coronavirus (COVID-19) Cases, provided by JHU CSSE
https://systems.jhu.edu/research/public-health/ncov/
29.1k stars 18.38k forks source link

San Francisco Bay Area counties #1088

Open mroyle opened 4 years ago

mroyle commented 4 years ago

they all show zero confirmed cases since March 10th. I live in Contra Costa county and I know the current number of confirmed cases is 41 but this data shows 26/

Sleekery commented 4 years ago

They counted by US city/county through 3/9/20. Since 3/10/20, they aggregate by states. You'll have to aggregate the city/county data by state up through 3/9/20. Filter rows by commas in Province/State, split it by comma, extract the US state postal code, map postal codes to states, and then groupby and sum to get all the values by state.

mroyle commented 4 years ago

Great. Thank you. It wasn't clear if it was an error or something like that.

Mike

On Thu, Mar 19, 2020 at 8:49 PM Sleekery notifications@github.com wrote:

They counted by US city/county through 3/9/20. Since 3/10/20, they aggregate by states. You'll have to aggregate the city/county data by state up through 3/9/20. Filter rows by commas in Province/State, split it by comma, extract the US state postal code, map postal codes to states, and then groupby and sum to get all the values by state.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/CSSEGISandData/COVID-19/issues/1088#issuecomment-601512968, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALBOQOSKN3OWCMY5BA3TRWLRILRTHANCNFSM4LP6ONLA .

-- Mike Royle 747-232-1001 mike@doit-intl.com

glennparham commented 4 years ago

hmm...I'm confused. How does doing this successfully extract the latest county numbers? Isn't this just getting the latest state sum?

Sleekery commented 4 years ago

Yeah, you can't get county data after 3/9/20. The only thing you can do is aggregate county data to the state level through 3/9/20 so that you have a continuous dataset for states.

ismaelc commented 4 years ago

Does anyone know of any other resource still reporting by county/day?

muneebaahmad commented 4 years ago

@ismaelc I found the following to get data by county. https://coronadatascraper.com/#timeseries-byLocation.json

ismaelc commented 4 years ago

@ismaelc I found the following to get data by county. https://coronadatascraper.com/#timeseries-byLocation.json

Amazing! Thank you

glennparham commented 4 years ago

@ismaelc I found the following to get data by county. https://coronadatascraper.com/#timeseries-byLocation.json

Awesome! We used this data in our Covid-19 sms bot! https://covid-helpline.com

Text "COVID" to (914)-268-4399 for the latest local info on Covid-19!