I just published a new version of my Python Census Explorer app. This version lets you select a State, County and Demographic statistic. It then presents two visualizations of the data over time:
The app defaults to visualizing Total Population for San Francisco County, California:
The data comes from the 1-year American Community Survey (ACS), which covers 2005-2022. Note that data is only provided for counties with a population over 65,000. Due to Covid-19, data was not published for 2020.
My hope is that before reading further you take a moment to visit the app, enter in your own county, and see what the data says about where you live. I’m particularly interested to know how the visualizations you see compare to your recollection of how your county changed at the time.
In my case, I vividly recall large numbers of people moving out of San Francisco during Covid. So the 8% drop in total population did not surprise me. But seeing that change in the context of the entire dataset (which shows that San Francisco has generally been growing since 2005) did stand out to me. Even among the few years when SF did shrink, the intensity of the 2021 drop was truly unprecedented.
In this version of the app I also added in a new variable: total number of people who worked from home. As you can see below, the number of people in San Francisco who worked from home increased 400% between 2019 and 2021! While I expected an increase, I had no idea how large the number would be. And again, the intensity of the spike in the context of the entire time series surprised me.
Longtime readers will recall my last post, where I had the app visualize the demographics of Census Tracts in a given year:
My goal at the time was to add in a “percent change” visualization showing how a given demographic changed before and after Covid. Unfortunately, I quickly learned that I could not extend the tract-level analysis in that way:
I have several ideas on how to improve this app. But my purpose in this post is to try and get more people to simply use and provide feedback on it. If you have any thoughts you’d like to share after using the app, please feel free to contact me to share them!