Vote up to Idea Population by Zip Vote down to Idea Population by Zip

Rank54

Idea#153

This idea is active.
API Technical Discussions »

Population by Zip

Hoping someone can point me in the right direction. I'd like to query the population for a specific zip code. I'm hoping there's a way to do this without defining the two number state code in the query.

Here's what my current query looks like...

http://api.census.gov/data/2010/sf1?key=[myKey]&get=P0010001&for=zip+code+tabulation+area:[myZipCode]&for=state:*";

This works perfectly when I define the Zip Code and State but not when I try to use a wildcard for the State.

Thanks in advance.

Robert

Comment

Submitted by 1 year ago

Comments (5)

  1. I'm in a similar spot. It seems that SUMLEV: 860 (zip code tabulation area) is not available, while SUMLEV: 871 (state-zip code tabulation area) is.

    To Census folks: Are there plans to allow access to other SUMLEVs? I'm working on the census_api gem and we're trying to allow access to SUMLEV:860 with a workaround. I think it would be more elegant to simply allow this SUMLEV on the API level.

    References

    census_api gem: https://github.com/tyrauber/census_api

    Available summary levels:

    SF1: http://api.census.gov/data/2010/sf1/geo.html

    ACS5: http://api.census.gov/data/2010/acs5/geo.html

    1 year ago
    1. joe

      FWIW, I see that all of the available sumlevs are constrained by state. As well as ZCTA, it would be nice to have CBSA & CSA without having to build them up from the states that those areas are in, and while I've never had cause to use them, the AIANHH geographies can also cross state boundaries...

      1 year ago
  2. In the same boat here just for a one-time data project. It's shockingly hard to just get a simple table of ZCTA vs. population! Thanks for posting cloydster

    1 year ago
    1. Simple ZCTA vs population is very simple. See here: http://api.census.gov/data/2010/sf1/geo.html

      The problem is if you do not know the state your ZCTA is in. Then it becomes complicated.

      8 months ago
  3. Hi All,

    This is similar to my comment here: http://apiforum.ideascale.com/a/dtd/API-extension-for-query-across-hierarchy/591562-18378

    walking across the geography hierarchy at the same level but two states will not work.

    It is similar because the API is severely constrained in the geographic levels of query and without making it more flexible, neither of us can do what we want.

    8 months ago

Vote Activity Show

Events

  1. The idea was posted
    1 year ago