[CTPP News] Re: Working at Home in America: 2019 vs 2021:

Hey Ed: My guess with Redmond, WA and Dublin, CA is that they both popped the magical 65,000 total population barrier in 2021. Of course, my detailed spreadsheets found enough weirdness to question everything. Pearland, Texas. Population = 131,448 (2019) and 120,694 (2021). Table DP03 shows workers by mean of commute for 2019 but not for 2021. My R script results match what I can find on data.census.gov <http://data.census.gov/>. Why the population decline? I’m suspicious. Meridian, Idaho. Population = 114,161 (2019) and 125,959 (2021). Again, table DP03 shows workers by means of commute for 2019 but not for 2021. Again, matches data.census.gov <http://data.census.gov/>. The Villages, Florida. Population 85,377 (2019) and 80,691 (2021). No data on workers by means of transportation to work for either year. This makes sense (?) since The Villages is the largest age 55+ community in the USA. VERY few commuters to be expected. But what happened with total population? A decline? Question: Is the 2021 ACS taking into account data on total population, population by age/sex from the now available Census 2020?? I don’t know. Both the US and States pull both 1 and 52 (states + DC + PR) in my R script for both 2019 and 2021. That’s a relief. County = 840 in 2019; 841 in 2021… The joined dataset is 852 counties. A little more messy. Place = 634 places in 2019; 634 places in 2021; but the joined dataset is 650 places. Some places pop-in; some places are popping-out. Good grief. PUMA = 2,364 in 2019; 2,364 in 2021; and joined together, still, 2,364. We get the most number of geographic areas in the single-year ACS using PUMAs. And it’s wall-to-wall, shore-to-shining-shore coverage. This is really good to know and to share. I think we have 2,487 PUMAs based on Census 2020, but I need some verification/ backup from Census Bureau or State Data Centers to check over my analyses. I may want to do a test run at the county and place level, for a single year, say 2021, for commuting data in tables DP03, B08006, and C08006. DP03 has data on workers by 6 means of transportation; B08006 has data on workers by 13 means of transportation; C08006 has data on workers by 8 means of transportation. I think the fewer categories, the less suppression? I went to the White Sox / Athletics game this past Sunday. Dave Stewart’s number retired. Rickey, Dennis, Carney, McGwire, Reggie, Wally Haas, and LaRussa were all there. A’s win the game, too. Fun day in Oakland. Chuck