US COVID-19 Vaccination Statistics

An Interactive Streamlit App Dashboard to visualize and analyze USA Covid-19 Vaccination stats Streamlit module. You can try here.

Data from the Centers for Disease Control and Prevention (CDC) collected during Jan 2020 to Dec 2022, were analyzed to assess COVID-19 vaccination, intent for vaccination, and attitudes towards vaccination among sociodemographic categories like Gender, Age group, race and ethnicity across USA at county level.

Results:

At anytime Covid 19 Vaccination coverage was highest in women aged 18–49 years. Men had lower coverage than women in all age groups. Intent to definitely get a COVID-19 vaccine was high in non-Hispanic/Laino and Native Hawaiian and other Pacific Island (NH/OPI). While, whites have higher levels of vaccine hesitancy.

Author

Leela Josna Kona

• LinkedIn

Primary objectives

• Basic options for users to choose
  • Dataset Date Period
  • US State and County Multiselect Filters
  • Maintaining and updating filter values across multiple pages with session state
  • A Home page and Multipage app to categorize the dataset at different hierarchy
    • US State Reports:
      • Display a COVID-19 Vaccination Coverage Across U.S. Counties in a Geoshape Map
      • Draw a Rank Chart with the selection (state-level or County-level comparisons)
    • Detail Reports and North Carolina - level Reports:
      • Draw a Violin Plot of Total Vaccination Distribution accross Age and Gender
      • Draw a line chart of Weekly Initiation by Age group in [State], [County]
      • Draw a Bump Chart by Race over Time in [State], [County]
      • Draw a Pie Chart by Ethnicity Breakdown for the selected date range

Data sources and design

• Vaccinations data source
  • Centers for Disease Control and Prevention (CDC): COVID-19 Case Surveillance Public Use Data with Geography dataset
• Geographic data
  • Altair Vega_Datasets: Geographical shapedata for states and counties
  • counties <- alt$topo_feature(vega_data$us_10m$url, "counties")
  • states <- alt$topo_feature(vega_data$us_10m$url, "states")

Selected modules used

• Streamlit
• Altair: Altair chart module used to draw Geoshape Map and other charts like Bump, Pie, Rank (streamlit.altair_chart)
• Plotly: Plotly chart module used to draw Violin Plot, (streamlit.plotly_chart)
• Multipage app
• Session State

Snapshots

1. Landing Page

)

2. US State Report

Input values saved in Session state

US State Report - selected states

US State Report - selected county

3. Detail Reports

Vaccinations - Age and Gender Distribution

Vaccinations - Age Group Trend

Vaccinations - Race Dynamics

Vaccinations - Ethnicity Breakdown

Future work

This Framework can be used at global scale and can include additional virus vaccination data. Adding more criteria in Visualizations can provide understanding of vaccination dynamics. This promotes an equitable vaccine distribution and reduces racial and ethnic disparities in vaccination. Also, work on the session state capturing sidebar input values across multiple pages.