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:

http://api.census.gov/data/2011/acs5?{key}&get=B01001_001E,B01001_002E,B01001_003E,B01001_004E,B01001_005E,B01001_006E,B01001_007E,B01001_008E,B01001_009E,B01001_010E,NAME&for=state:06

 

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.

 

Cheers,

B

Tags

Voting

2 votes
2 up votes
0 down votes
Active
Idea No. 120