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