[Tutorial Kit] Health Insurance Coverage Data: Assessing Community Need

https://youtube.com/watch?v=https://youtu.be/HZ_aXQvPbl4

Workshop Chapters

Recorded live Dec 9 2025, timestamps are below

• 00:00:00:00 Intro

• 00:01:24:11 Disclosure & Background

• 00:03:42:09 Outline & Learning Objectives

• 00:08:19:06 Why are we here?

• 00:09:57:20 The Plan

• 00:10:47:14 Data Hunt for Uninsured Rates

• 00:23:54:00 DATA CHALLENGE START

• 00:34:56:20 PORTFOLIO PROJECT 1: Infogram

• 00:34:56:20 PORTFOLIO PROJECT 2: 1-Pager for Elected Official

---

Continuing Educational Credit

CHES® / MCHES®

BroadStreet Institute is a designated provider (ID# 1167363) of continuing education contact hours (CECH) in health education by the National Commission for Health Education Credentialing, Inc. Total contact hours earned 1 • Entry-level contact hours earned 1 • Advanced-level contact hours earned 0.

CPH (Certified in Public Health) Recertification Credits

The BroadStreet Institute is an approved provider of Certified in Public Health (CPH) Recertification Credits by the National Board of Public Health Examiners. Up to 1 CPH Recertification Credits may be earned at this event.

---

🎯 The Data Challenge

Create a shareable portfolio project highlighting uninsured rates in your region.

3 Learning Objectives

1. Identify publicly available secondary data sources (e.g. U.S. Census Bureau ACS) relevant to health insurance coverage.

2. Procure and calculate key indicators (e.g., uninsured rate) from a secondary data source for a selected geography, to determine the health status of the priority population.

3. Develop a data visualization or brief (e.g., infogram or 1-pager) tailored to a defined target audience, such as an elected official.

Conflicts of Interest Disclosure

There are no financial conflicts of interest to disclose. None of the presenters or organizers of this event have any financial relationship, nor affiliation with the brands and organizations mentioned in this tutorial. We just really like this tool.

🧰 🛠️ Inventory

To succeed, here's what you'll need.

• ⏰ Time. 20-40 minutes

• 📊 Data

  • Data source: U.S. Census Bureau, American Community Survey, 5-Year Estimates, 2023, Table S2701, retrieved from: https://data.census.gov/table/ACSST5Y2023.S2701?q=uninsured

  • 3 indicators:

    • Total Population (#)

    • Population that is Uninsured (#)

    • Percent Uninsured (%)

• 🎨 Template Kits

  • Select one:

    • Portfolio Project 1. Infogram (see below, left)

    • Portfolio Project 2. 1-Pager for Elected Official (see below, right)

• 

• 

Why it Matters

Health insurance is an important social determinant of health and lack of health insurance has been linked to poor health outcomes including a higher risk of premature mortality (Woolhandler & Himmelstein, 2017).

Data Makes a Difference

Local data can be powerful if shared with those who can act upon it. That is why we encourage sharing information with policymakers (Portfolio Project 2) and/or raising awareness with your network (Portfolio Project 1).

Step-By-Step

Please see video for a step-by-step guide. Note: This challenge can be completed any time without the "Challenge Tracker Spreadsheet" that is referenced in the videos. Each Canva design contains a mini spreadsheet of the indicators and phrases needed to fill in the template. The initial workshop was in Dec 2025.

You've Earned a Certificate!
BroadStreet Certificate (FREE)	Submit Your Project for a Certificate
CHES® / MCHES® Credit   1 total credit hours ($10)	Submit Project for CHES® / MCHES® Credit
CPH - Certified in Public Health Recertification Credits (1 credit hr) ($10)	Submit Project for CPH Credit

Note: We review projects every 2-4 weeks, typically at the end of the month.

References

Steffie Woolhandler, David U. Himmelstein. The Relationship of Health Insurance and Mortality: Is Lack of Insurance Deadly?. Ann Intern Med.2017;167:424-431. [Epub 27 June 2017]. doi:10.7326/M17-1403