Dear Steve,

What is the city ?  If you can send state name county and csd (county subdivision) or place (fips and name) or csd (name and fips)  I can run it using PUMS data and my Small Area Estimation program.

Best,

Dave

Can you use PUMS?

PUMS variable SCHL

If you can use PUMS data, they have cost of utilities.

There is BDSP and/or RMSP in the ACS PUMS data.  You might be able to use this as a proxy for square footage. You probably want to leverage this with other PUMS variables as covariates.  You would also need a regression model going from rooms and other…

You're correct: the ACS summary files do not have this information, so the PUMS is your best bet. IPUMS-USA has county codes, but if a county you're examining can't be identified in the PUMS data, you can use the CHAS data, a special tabulation of ACS…

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…

Thank you! Beth. I will check PUMS. 

Thanks! The new race iterations of table B25140 (housing costs as % of household income) are wonderful to have in the summary file. Disaggregated data on housing cost burden is one of the most common requests we get, but we've had to rely on the PUMS…