For these types of multi-way crosstabs, the Public Use Microdata Sample (PUMS) is your best bet. You can access data and documentation here: https://www.census.gov/programs-surveys/acs/microdata.html
Use PUMS data FOD1P for example.
B15012
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…
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
Hello,
In my current project, I need to analyze some housing trends using PUMS data (housing needs assessment and estimating the future housing demand and so on).
However, changing PUMA boundaries is making my job harder. Currently, I am working with…
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…
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…
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…
Can you use PUMS?
If you can use PUMS data, they have cost of utilities.