CDC PLACES DATA

Aim: The project aims to analyze and visualize Indiana and Kentucky state datasets from the CDC PLACES website, providing insights into health measures at small geographic levels. By leveraging PLACES data, the project aims to facilitate informed public health interventions and improve understanding of health trends and disparities in these regions.

Description: The project focuses on accessing and analyzing health datasets from the CDC PLACES website for Indiana and Kentucky states. Utilizing small area estimation methods, the aim is to provide detailed insights into various health measures, including prevalence, prevention, risk behaviors, and outcomes at the county, place, census tract, and ZIP Code Tabulation Area (ZCTA) levels. Through visualizations and analysis, the project seeks to aid local health departments in identifying key health issues and planning targeted interventions while promoting the accessibility and value of public health data.

Dataset: waiting for dataset

Key Findings:

  • Challenges encountered in exploring options on the CDC Places website for filtering latest year data files and formatting.
  • Lack of solid breakthrough in finding suitable solutions for data retrieval and formatting.
  • Need for further discussion with Jay to clarify requirements and obtain necessary reference files and indicators, with focus remaining on exploring the web portal for accessing latest year files.
  • Emphasis on automation of downloading and formatting processes to streamline workflow and meet Jay’s requirements.

Workflow:

  • Exploration of options on the CDC Places website for filtering latest year data files and formatting.
  • Lack of breakthroughs leading to ongoing challenges in finding suitable solutions.
  • Discussed with Jay to clarify requirements and obtain necessary reference files and indicators.
  • Continued focus on exploring the web portal for accessing latest year files.
  • Planned steps to automate downloading and formatting processes:
  • Check for latest similar original file as a sample from the portal.
  • Automate the download process.
  • Change indicators as per reference indicator.
  • Automate formatting process as per sample.