Arkansascovid / Main

Arkansascovid Data and Code
Creative Commons Zero v1.0 Universal
8 stars 7 forks source link

Age group breakdown in age_master.csv #3

Closed kitkatbun closed 3 years ago

kitkatbun commented 3 years ago

I noticed that the age breakdown for deaths (cumulative, not new) had 2 columns for the ages 0-10 and 11-17, but that the 11-17 was NA. I wanted to verify that the 2 deaths reported in the 0-10 column were in fact 0-10 or if they were really in the 0-17 age ranged.

amwilkins commented 3 years ago

I just checked the raw data from the state, they're putting out NA for deaths in age range 11-17. Can confirm from this address: https://services5.arcgis.com/vlhGQkz6fSnofVMD/ArcGIS/rest/services/ADH_COVID19_STATS_BY_STATE/FeatureServer/0/query?where=0%3D0&objectIds=&time=&resultType=none&outFields=*&returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnDistinctValues=false&cacheHint=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&having=&resultOffset=&resultRecordCount=&sqlFormat=none&f=pjson&token= And searching for the attribute: "d_age_2" : null

It looks like this is pushing both new, and cumulative death counts in that range to NA. The state has recently changed their measurements, so they may have changed their age ranges. We should follow up on that.

Arkansascovid commented 3 years ago

The ADH changed the reporting on these values and we will be updating the data this week to reflect the change

On Wed, Jul 28, 2021 at 9:43 AM kitkatbun @.***> wrote:

I noticed that the age breakdown for deaths (cumulative, not new) had 2 columns for the ages 0-10 and 11-17, but that the 11-17 was NA. I wanted to verify that the 2 deaths reported in the 0-10 column were in fact 0-10 or if they were really in the 0-17 age ranged.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/Arkansascovid/Main/issues/3, or unsubscribe https://github.com/notifications/unsubscribe-auth/AQ6N5RRJIWL3UIUNLJB7YYLT2AJQVANCNFSM5BEQL5CA .

kitkatbun commented 3 years ago

Thank you for looking into that.