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?
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;…
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
If you’re using R, tidycensus has tools to download and analyze PUMS data walker-data.com/.../pums-data.html
Thank you, David!
Thank you, Matt!
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.
Thank you Jonathan