Dear Christine,

MAKING PROGRESS

I was able to reproduce the AL row in the Lifeline spreadsheet.  The value is 626087 I used the 2021 1-year PUMS. I added SPORDER==1 to the code posted earlier  This code here computes with only SPORDER==1 person records…

Dear Lorna,

Here is some additional documentation that might be useful.

Here is some documentation on how the income and expense items in the SPM PUMS file are computed.

https://www2.census.gov/programs-surveys/supplemental-poverty-measure/technical-documentation…

Thanks, Diana. I'm working with counties of 20-30K population so not working with PUMS.

I realized after posting that it is problematic using the BLS calculator since it requires that you enter a month as well as a year to adjust from and to.

I found…

Dear Madalsa,

I was hoping to see if I could make an example out of what you discovered but here are 3 reasons why "things don't add up" in tables

  1) You added an extra variable to the tabulation. In your case, the total US population is…

Yes, the 2020 Redistricting Data files included no data for ZCTAs. I suppose this is because the Bureau hasn't (or hadn't) yet defined the official 2020 version of ZCTAs and are waiting to release 2020 summaries for ZCTAs until that is done. (As I recall…

[For anyone who received an email with a previous response from me, please see this one instead. I hit "reply" prematurely before.]

Median incomes can be found in the set of tables starting with B19013. If you want mutually exclusive categories, then…