search

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

Should split AHR topics into tables by category #3523

Closed benhammondmusic closed 1 month ago

benhammondmusic commented 1 month ago

Right now we have all AHR topics being written into the same table. This makes the json files big (will be huge with time series expansion) and also very hard to read/debug since each topic has up to 5-6 columns.

We should divide the topics into tables by category. This can be accomplished by passing a new category argument into the write_to_bq function from the call in the DAG (similar to how we can pass in a demographic or geographic argument) and then run the graphql_ahr datasource on only the subset of relevant ids

Chronic Disease

  'asthma',
  'cardiovascular_diseases',
  'chronic_kidney_disease',
  'copd',
  'diabetes',

Behavioral Health

  'depression',
  'excessive_drinking',
  'frequent_mental_distress',
  'suicide',
  'substance',

SDOH_PDOH

  'avoided_care',
  'preventable_hospitalizations',
  'voter_participation',