Right, I'd forgotten you may be looking for the 2020 relationships, and Geocorr doesn't have those yet. (Looking forward to that, Glenn!)

Joe Germuska shared another good idea, but you wouldn't need to go down to the block level to get this relationship…

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…

It looks like you are coming from the SQL tradition rather than the statistics tradition.

table (SQL) = file (statistics)

key (SQL) = unique ID variable (statistics)

join (SQL) = merge (statistics)

For statisticians, a table is a summary, so it would…

Thanks Alicia.  I had read that readme doc but I was looking for more detailed explanations.  One of the Census research paper explains a bit better why the reduced variance estimates are an essential byproduct of entrophy-balanced weights (See page 33…