The 2025 ACS Data Users Conference will be held on May 29, 2025 (virtual day) and June 3, 2025 (in-person in DC)
Details
  • Views 6028 views
  • Replies 2 replies
  • Subscribers 541 subscribers
  • Users 0 members are here
Labels
Related Census Bureau Resources
Related Forum Threads

API change for 2017 5 year data for tracts?

Diana Lavery
over 5 years ago

It seems that my API calls for tract-level data are not working for the 2017 5 year data, yet the same call for the 2016 5-year tract-level data work!  I am successfully getting data for my calls for state and county for 2017 5 year data, just having a problem with tract-level.  Here's what I'm doing to get median age data for all tracts in AL, for example:

https://api.census.gov/data/2017/acs/acs5?get=NAME,B01002_001E,B01002_001M,B01002_002E,B01002_002M,B01002_003E,B01002_003M&for=tract:*&in=state:01

error: unknown/unsupported geography hierarchy

 

https://api.census.gov/data/2016/acs/acs5?get=NAME,B01002_001E,B01002_001M,B01002_002E,B01002_002M,B01002_003E,B01002_003M&for=tract:*&in=state:01

gets data successfully

 

What's going on?

  • over 5 years ago
    My understanding is that there's a systemwide (intermittent) API issue today (or so says @uscensusbureau twitter twitter.com/.../1070692966212227072) But I don't know if that's what's causing the specific problem you're seeing?
  • over 5 years ago
    Update from my email correspondence with Census:


    If you look in the geographies section of the dataset you will find that state > tract is not a valid geography. Your query is being automatically corrected to the correct state > county > tract geography for the 2016 dataset but not for the 2017 dataset. To see the list of supported geographies you can look at the geography page of the dataset.

    api.census.gov/.../geography.html
    api.census.gov/.../geography.html

    This may be due to a difference where the county wildcard variable is not allowed in the 2017 dataset while not being the bottommost hierarchy.

    You can see in the 2016 examples link that it contains that middle example where wildcards are allowed in the county variable while the 2017 examples link does not contain that middle example for state > county > tract.

    api.census.gov/.../examples.html
    api.census.gov/.../examples.html


    I will contact our developers/survey providers about this discrepancy. In the meantime if you want tract level data from the 2017 ACS 5 year you will have to use the format provided in the example link and go county by county.
For more information about the American Community Survey Census Bureau Website