API Technical Discussions

API Variable Question for ACS2011 5 Year

Preface: New to API Calls & Census Data (not sure the proper Campaign to post on)

Curious, how can I more efficiently pull data through the API without having to specify each individual Unique ID (found in the ACS2011_5-Year_TableShells.xls file)?

If I wanted to pull all data for Table ID: B01001 what would my {&get=} be?

Currently, I am using each individual Unique ID as so:


Is there a syntax for spanning Unique ID values within a single table?

And why is it that I cannot use the Unique ID value as is outlined in the ACS2011_5-YearTableShells.xls file, rather I need to split the value after the Table ID with an underscore and Unique ID value, as so: B01001002 needs to become B01001_002E inorder for the call to work.

Any assistance would be most helpful.




Submitted by

Stage: Active

Feedback Score

2 votes
2 up votes
0 down votes

Idea Details

Vote Activity

  1. Upvoted
  2. Upvoted

Similar Ideas [ 4 ]


  1. The idea was posted


  1. Comment
    brian.hyman ( Idea Submitter )

    Still floundering with this one... anyone out there in dataland feel compelled to assist?

  2. Comment

    Thanks for your feedback. Currently the API is not able to get all variables within a table by passing a table id. You need to specify the variable(s) you are trying to get from the URL. We also defined a limit within our API configuration for 50 variables and some tables in the ACS contain more than 50 variables. We will consider this idea for future enhancement/development of the API grammar and features.

    The unique ID does not distinguish between margin of error and estimate. We use the letter s “E” or “M” for the estimate or margin of error, which is not included in the table shell definition. The underscore is used as a visual separation between the table and individual estimate. We will work towards making sure that documentation across products is consistent.

Add your comment