I've been asked to identify the number of households with children under 6 years of age with one and two incomes. I'm pretty sure it wouldn't impact the Table ID, but to be clear I'm looking for 1-year estimates at the state-level. Although I'll take 5-year estimates if 1-year are not available.
Basically, I'm looking for B23008 but with households or families as the universe instead of children. B23009 gets close but doesn't disaggregate by age of children. B11003 gets close but doesn't include number of workers or employment status. No luck as of yet via https://www.kidsdata.org/, https://datacenter.kidscount.org/, or https://nces.ed.gov/programs/edge/Demographic/ACS.
Found these threads that are similar but not exactly what I'm looking for:
Household Demographics with Children under 18 [ Any insight and/or suggestions would be very greatly appreciated. Thank you, Mark
Any insight and/or suggestions would be very greatly appreciated.
Thank you,
Mark
When does 2021 ACS microdata come out? I thought it was this week or next — you could stitch all that together from that (I generally wait for IPUMS which takes a little longer)
I thought this was an interesting question, so I wrote a little R code to pull PUMS via tidycensus and create these estimates. If you are not familiar, this is a good walk-through of how to use tidycensus…
Thank you, Tim. I'll look into this. Greatly appreciated.