Hi Jake,
You could also access PUMA-level data from the 1990 and 2000 Census Public Use Microdata Sample (PUMS) files, which are available through the IPUMS website: https://usa.ipums.org/usa/

Dear Tom,

Tim is correct if you want to know "how much money is floating around in a community" use average (mean) and multiply by head count.  If you want to know what the  amount of money that a "typical" household or person has use median.…

Dear Andy,

Here is some info that I found on intercensal group quarters.  The methods are part of the Population Estimates Program (PEP).  I also emailed with the people in the GQ group. You may be familiar with this info.  Here is how GQ population estimates…

I use the PUMS data with replicate weights for the MOE calculations.

Hi Gan,

My understanding is that the summary tables are already adjusted into 2014 dollars. I'm assuming they would have to use the same adjustments that users have to use when working with PUMS data, if you wanted to create your own tables not published…

I came across this problem yesterday and was quite surprised in light of a Census Bureau press release that featured the break out of additional languages in this table. I'll be able to work around this problem once the PUMS data is available, but it…

This ACS Handbooks provide a set of formulas you can use to calculate MOE. (See Chapter 8 https://www.census.gov/content/dam/Census/library/publications/2020/acs/acs_general_handbook_2020_ch08.pdf)

The only challenge is (as you described above) the formulas…

The income/earnings questions don't go by calendar years, they go by "earnings/income in the past 12 months." I think what they are doing is somehow averaging the current survey year's and the previous year's CPI-U-RS (although...not everyone would be…