Hi,
For research that I am currently conducting, I would like to create a panel data set with 1-year estimate data at the ZCTA level for 2009-2019. The data should have population counts by age, education level, and employment status, as well as median income.
Using the FTP site I see that I can identify the appropriate tables for each variable, use the sequence number to identify the the right file, and download that file. For a relatively long panel though, this is a bit laborious because it seems there are sometimes changes across years in tables, sequence numbers, and variables.
Has anyone created a panel of ACS 1-year estimates, so that I don't have to replicate this process?
If I do have to pull data for each year from the FTP site, are there any tips or best practices to efficiently wade though all those data?
Hi! Unfortunately, there is no ZCTA-level data at one-year estimates. There isn't a big enough sample in one year to produce meaningful data at that small a geography.
The 1-year estimates are published only for areas with at least 65,000 residents, which excludes most counties (though the included counties, with their larger populations, include a significant majority…