SatcherInstitute / health-equity-tracker

Health Equity Tracker is a free-to-use data visualization platform that is enabling new insights into the impact of COVID-19 and other social and political determinants of health on historically underrepresented groups in the United States.
https://healthequitytracker.org/
MIT License
17 stars 24 forks source link

Fix graphql ahr; voter and preventable aren't propagating? #3461

Closed benhammondmusic closed 1 month ago

eriwarr commented 1 month ago

Voter participation data is available only for election years (2008, 2012, 2016, and 2020). The data is missing for non-election years, which results in null values. Let's use the voter participation rate from the most recent election year for the years between elections.

eriwarr commented 1 month ago

So I double-checked AHR's database, and the data provides only one age breakdown category, Ages 65-74. Because of that, all other age categories will be null in the age_national and age_state tables. I think we should decide whether the age breakdown for Preventable Hospitalizations should be shown at all. Maybe we could do a "Senior Report" focusing on the 'Ages 65-74' category?

benhammondmusic commented 1 month ago

So I double-checked AHR's database, and the data provides only one age breakdown category, Ages 65-74. Because of that, all other age categories will be null in the age_national and age_state tables. I think we should decide whether the age breakdown for Preventable Hospitalizations should be shown at all. Maybe we could do a "Senior Report" focusing on the 'Ages 65-74' category?

@eriwarr I believe Preventable Hospitalizations is only measuring medicare beneficiaries, so that's probably why they don't show other age groups as the data would be much more sparse. I think we can probably hide the age breakdown for now, and then yes I think we should explore doing focused reports for seniors / kids / Black / Women etc