I'm having a heck of a time downloading median income for zip codes on the ACS 5-year surveys. I know I'm doing something wrong but can't figure it out. I choose the survey, go to geographies, click five digit zip code tabluation area and no zip codes show up. Forgive my impertinence, but can someone help? Thank you.
Why not just use data.census.gov? If you're not very familiar with the API, data.census.gov would be much easier to get what you want.
AMI data are computed and disseminated by HUD using ACS data. Here's a link to the Excel file that provides the figure for every county: https://www.huduser.gov/portal/datasets/il/il20/Section8-FY20…
your API call URL doesn't work. This one will give you PCI by ZCTA: https://api.census.gov/data/2019/acs/acs5?get=NAME,B19301_001E&for=zip%20code%20tabulation%20area:*
For top 10% within state…
This is data.census.gov? I find that impossible to use as well -- I've started using the API where you change the URL to get data, it sounds hard but if you start with an example, study the variables for a couple minutes you can figure out how to craft the URL to get what you want
I want to use the census api for finding that a zipcode is within the top 10% of per capita income of the state i have found the per capita income of zipcode but how to find that it exist in top 10%.
here i am attaching the url for per capita income:
api.census.gov/.../acs5 code tabulation area:*
Thanks in advance.
For top 10% within state, you'll need to do some post processing
Thank you for the reply sir,the above url is giving the PCI with their state and zipcode?Now what should i do for getting the PCI for a single state with their respected zipcodes?
Just filter the results for whatever state you're interested in. Or you might be able to designate a specific state in the API call. You'd need to review the API documentation. https://www.census.gov/data/developers/guidance/api-user-guide.Core_Concepts.html
ok thank you.
Does data.census.gov contain AMI data by county? I tried endlessly to find this data but not getting it. Trying to avoid sourcing the data 50 times at the state leve and instead have AMI listed by county for 2020 or most recent year
AMI data are computed and disseminated by HUD using ACS data. Here's a link to the Excel file that provides the figure for every county: https://www.huduser.gov/portal/datasets/il/il20/Section8-FY20.xlsx
Awesome, I think this gets me closer to the data set I need. Is HUD the best place to source the directly to refresh it annually? Want to provide our developer with the exact link to source the data
Here's the web page: https://www.huduser.gov/portal/datasets/il.html
And here's the API access: https://www.huduser.gov/portal/dataset/fmr-api.html
Thank you so much Bryan!
Hello sir,I found the per capita income according to zip code using the above url but i also want to fetch the place name of the zip code area using the cansus api .Please help me out.Thanks in advance
What do you mean? ZCTAs don't have names.
I've done that by matching on USPS data -- not impossible -- they tend to have multiple names, let me see if I can reconstruct what I did
I happened to answer this very question on the Census Slack today: