Hello. I am trying to download 2005-2009 ACS 5-year estimates for table "B25003" on https://data.census.gov/. However, the earliest ACS 5-year estimates it allows me to download is 2006-2010. Therefore, I was wondering how I would be able to access 2005-2009 ACS 5-year estimates for certain tables, and for geographic units of my choice (e.g., census tracts in a few counties). Thank you.
Good morning, for pre-2010 ACS data, I would recommend using the ACS Summary File or the API. Since you are just interested in one table, perhaps the API could be better for you. Here's the API call for…
IPUMS NHGIS provides a web interface that allows you to select and download census and ACS tables for years from 1790 through the present, including all tables from the 2005-2009 5-year ACS summary files. One…
Good morning, for pre-2010 ACS data, I would recommend using the ACS Summary File or the API. Since you are just interested in one table, perhaps the API could be better for you. Here's the API call for B25003 for Census Tracts - you'll need to change the state/county/Census Tract IDs for the ones that you want.
api.census.gov/data/2009/acs/acs5?get=NAME,group(B25003)&for=tract:*&in=state:06&in=county:*
These resources may help with API:
API Handbook What Users of the Census Data API Need to Know
Tutorial Using the API to Get All Results for an ACS Table (census.gov)
Tutorial Using the API to Get Results for Multiple Estimates (census.gov)
IPUMS NHGIS provides a web interface that allows you to select and download census and ACS tables for years from 1790 through the present, including all tables from the 2005-2009 5-year ACS summary files. One caveat is that NHGIS provides tract and higher-level data only in nationwide files, but you could still use your own software to select the records for your the counties of interest after downloading the file.
Thank you!