Data Wrangling for Advocacy: Tidy Data to Support the Affordable Connectivity Program
summary
Dashboard cleans messy FCC ACP spreadsheets with R using tidyverse, stringr, and tidycensus, fixes leading-zero FIPS, joins enrollment and claims, and estimates eligibility from ACS; visuals are rendered in Tableau and one simple linear model is used. It shows the program’s $14.2B pot is insufficient, prompts a White House briefing, is cited in congressional letters and hearings, and directs on-the-ground outreach via ZIP-code enrollment maps. Program ends in June, leaving about 23 million households without assistance.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 1:29From requests to dashboard
- 3:17Accessing federal data
- 5:31Cleaning enrollment spreadsheets
- 7:39Simple user-focused dashboards
- 8:44Calculating eligibility
- 9:51Collaborating on data products
- 10:34Sharing the dashboard
- 12:44End of the program
- 14:11Key takeaways
- 15:57Q&A
related talks
17mR at the ACLU Joining tables to to reunite families
24mData science, apps and civic responsibility
19mA Journey Into Data Science: From an Idea to a Viable Product
05mWhy tidy data matters
10mCivic Hacking & Urban Informatics: Mapping Data with GeoPandas
20mSpatial data science in the Tidyverse
13mData Science: Where are We Going?
18mCatalyzing the Health Data Ecosystem