Dear Christine,

I think that i understand what numbers you are trying to reproduce.  I can't do it either:

Here is what I get for AL (fips code "01") Accessing the state csv file on

 https://www2.census.gov/programs-surveys/acs/data/pums/2021…

I'm working on a related project that tries to do a similar analysis by recreating the HUD AMI data (as close as possible) using ACS (PUMS) data (via Small Area Estimation if needed).

One issue that I have is finding a cross walk between HUD AMI areas…

If you’re using R, tidycensus has tools to download and analyze PUMS data walker-data.com/.../pums-data.html

There are many ways to adjust zcta data "down to" blockgroups.  This simplest way to do this is to scale by the factor  block group population/ zcta population.  However you can do much better than this.  You can build a model (multiway tabulation…

Thank you for the suggestion, Beth. I have not before used the PUMS files, so that will be a new dataset for me to try!

You need to use a PUMS file  The vehicle question (household section of the ACS survey form) is #12 How many automobiles, vans, and trucks of one-ton capacity or less are kept at home for use by members of this household?  Split the PUMS data  by using None…

I thought this was an interesting question, so I wrote a little R code to pull PUMS via tidycensus and create these estimates. If you are not familiar, this is a good walk-through of how to use tidycensus for PUMS data. If you also want standard errors…

Depending on the size of your county/counties of interest, PUMS would work. Larger counties tend to have clear PUMA-to-County crosswalks. Smaller counties may have PUMAs that overlap with adjacent counties. Geocorr can produce the necessary crosswalk…

Can I use PUMS to get data by county by race/ethnicity? Single parent households with children, -by county- by race/ethnicity ?

Additional comment.  If you want people living alone with/without a phone you will need to use the PUMS (microdata) file.  PUMS files don't go down to the county level only to the PUMA level (public use microdata area) These have to be at least 100,000…