Hi all,
I am currently trying to create a county dataset containing demographic (specifically percentages of specific races) variables, so I am using the census API to try to expedite the process. I'm looking at the ACS 2021 response for DP05 for all counties and states, but when I make my CSV file of what the API gives me. I only have 834 counties, while there are 3,143 counties in the US. Is there any way I can change it to get all counties? Or are they better ways to achieve to get all the county info? This is what I currently have:
https://api.census.gov/data/2021/acs/acs1/profile?get=group(DP05)&for=county:*&in=state:*
Any advice would help.
Thanks!
Hello,
The ACS 1-year file is limited to counties with at least 65,000 people. For a complete set of counties you will need to use the ACS 5-year file (latest version covers the period from 2017-2021)…
not all counties are in ACS one year — you could get every county for 2020 with race/Hispanic from PL94 data (downloadable from Nhgis https://www.nhgis.org )
The ACS 1-year file is limited to counties with at least 65,000 people. For a complete set of counties you will need to use the ACS 5-year file (latest version covers the period from 2017-2021). I hope this helps.
-Mark