[CTPP News] ACS 2021 Single Year Estimates -- working at home data

Well, the single year 2021 estimates from the American Community Survey were released today! Honking and hollerin' Here’s a message I posted on the ACS Data Community (Population Research Board) discussion board: It’s been a busy day with the new single year 2021 estimates released!! I was using a tidycensus R script to pull relevant data on workers working at home, total workers, and total population. Usually I go to table B08006 to get data on workers by means of transportation to work. Kyle Walker, creator of tidycensus, posted a tweet this morning about the top ten or so places by work-at-home share... He used the DP03 table (specifically, table cell DP03_0024P) (Percent working at home). My initial run pulling data from table B08006 missed a few places that Kyle mentioned in his tweet. (Dublin, California, for example) . This is because the DP03 table is almost a "super-collapsed" version of B08006... Even more collapsed than C08006. There is much less likely to be place-level suppression in a DP table compared to the standard "B" (basic) or "C" (collapsed) tables. Not sure if this holds comparing DP to S tables. Ya learn something new every day. My R-script from today's adventures is on my github for all to enjoy (and hopefully correct if I screwed up!) https://github.com/chuckpurvis/r_scripts/blob/main/ACS_WorkatHome_Focus_201… <https://github.com/chuckpurvis/r_scripts/blob/main/ACS_WorkatHome_Focus_2019_2021.r> Chuck