ACS Data Users Group

 View Only
  • 1.  Measuring Trends Children in Households

    Posted 07-09-2021 02:55 PM

    I'm working on a project, in R studio using ACS1, to find trends of the total number of children 6 to 14 years old (individually, total number of children 6, 7, 8 , 9-years old, etc..) in households with either both parents, or single parents. I can only find combine ages such as 6 to 11 years and 12 to 17 years, however, I'm looking for individual ages. Does the US Census release that coding information? if so, do you have any suggestions on where or how to find it?

    Thank you!!



  • 2.  RE: Measuring Trends Children in Households

    Posted 07-09-2021 03:44 PM

    Not sure the level of geography you're interested in, but for something this specific when you want to see single-years of age, it's likely you'll have to custom calculate the number off the ACS Public Use Microdata Samples (PUMS). The PUMS have miminum geographic sizes of 100,000 people. They are state specific files so if you're trying to isolate a metro that crosses state lines you'd have to download and run the data for the appropriate individual states. A general link to learn more about the PUMS is here: https://www.census.gov/programs-surveys/acs/microdata.html



  • 3.  RE: Measuring Trends Children in Households

    Posted 07-09-2021 05:33 PM

    Thank you, David!



  • 4.  RE: Measuring Trends Children in Households

    Posted 07-09-2021 03:47 PM

    If you’re using R, tidycensus has tools to download and analyze PUMS data walker-data.com/.../pums-data.html



  • 5.  RE: Measuring Trends Children in Households

    Posted 07-09-2021 05:33 PM

    Thank you, Matt!



  • 6.  RE: Measuring Trends Children in Households

    Posted 07-09-2021 06:17 PM

    IPUMS USA is a go-to source for PUMS data for many users. It provides an interface to customize data files or to tabulate stats online; it provides integrated variables that standardize codes across time; it adds various supplemental geographic information to the Census files; and it provides detailed documentation and guides.



  • 7.  RE: Measuring Trends Children in Households

    Posted 07-13-2021 06:56 PM

    Thank you Jonathan