API Technical Discussions

Query help

Hi, I've been working with the following query: http://api.census.gov/data/2012/popproj/pop?get=TOTAL_POP,POP_4,POP_3,POP_2,POP_1,POP_0&ORIGIN=0&RACE=0&SEX=0&YEAR=2012&key= I think it is returning total usa population of age 5 and under for the year 2012. Is there a way to get the same information for each state? In other words is per state information available from popproj/pop? Or do I need to query another data ...more »

Voting

0 votes
0 up votes
0 down votes
Active
(@elizabeth.duncan)

Bugs / Problems

Duplicate (and incorrect) "Female 85 years and older" variable

I'm examining a tract in NYC. I found two different codes (P0120026 and P0120049) whose label and concept match exactly: "label": "Female: !! 85 years and over", "concept": "P12. Sex By Age [49]" Furthermore, they return VASTLY different values. See queries below: http://api.census.gov/data/2010/sf1?key=[key]&get=P0120049,NAME&for=block:*&in=state:36+county:061+tract:004200 http://api.census.gov/data/2010/sf1?key=[key]&get=P0120026,NAME&for=block:*&in=state:36+county:061+tract:004200 ...more »

Voting

2 votes
2 up votes
0 down votes
Active
(@lilybradley)

Using Data

Improving API documentation

Example of easier to follow API documentation: http://developer.usatoday.com/docs/read/Census Versus no coded variable definitions on the page: https://www.census.gov/developers/data/ All the needed content is in this presentation, but it was not intuitive to click on it since it refers to a specific event: https://www.census.gov/developers/NDoCH_Support_Slides.pdf Maybe rename it "ACS API Handbook"? Great great ...more »

Voting

2 votes
2 up votes
0 down votes
Active
(@lilybradley)

Using Data

Improving API documentation

Example of easier to follow API documentation: http://developer.usatoday.com/docs/read/Census Versus no coded variable definitions on the page: https://www.census.gov/developers/data/ All the needed content is in this presentation, but it was not intuitive to click on it since it refers to a specific event: https://www.census.gov/developers/NDoCH_Support_Slides.pdf Maybe rename it "ACS API Handbook"? Great great ...more »

Voting

2 votes
2 up votes
0 down votes
Active
(@dgcatanzaro)

API Technical Discussions

API extension for query across hierarchy

Hi All, The API has incredible functionality for query/results within the nested US Census Bureau Geography (e.g. getting data for all the tracts in a county or all the block groups within a track). However, it does not appear to support queries that run across the same geography very well. For instance It does not appear to allow me to query the same parameter (e.g. race) in Tract A within County B and Tract C ...more »

Voting

1 vote
1 up votes
0 down votes
Active
(@dgcatanzaro)

API Technical Discussions

API extension for query across hierarchy

Hi All, The API has incredible functionality for query/results within the nested US Census Bureau Geography (e.g. getting data for all the tracts in a county or all the block groups within a track). However, it does not appear to support queries that run across the same geography very well. For instance It does not appear to allow me to query the same parameter (e.g. race) in Tract A within County B and Tract C ...more »

Voting

1 vote
1 up votes
0 down votes
Active
(@dgcatanzaro)

API Technical Discussions

API supporting multiple geography query

Hi All,

I have been working on my application and one of the things I would like to do is query the same variable on multiple geographies. For instance, get the total population at the Block Group, Tract, County, State, and Nation.

 

Right now, it is my understanding that this would represent five different calls to the API.

 

Can this be done in one call to the API ?

Voting

2 votes
2 up votes
0 down votes
Active
(@dgcatanzaro)

API Technical Discussions

API supporting multiple geography query

Hi All,

I have been working on my application and one of the things I would like to do is query the same variable on multiple geographies. For instance, get the total population at the Block Group, Tract, County, State, and Nation.

 

Right now, it is my understanding that this would represent five different calls to the API.

 

Can this be done in one call to the API ?

Voting

2 votes
2 up votes
0 down votes
Active
(@dgcatanzaro)

Bugs / Problems

Invalid API Key

I just signed up and received a key from the Census API. I created a query, copied the key into the query and submitted it. The response said: A valid key must be included with each data API request. You included a key with this request, however, it is not valid. Please check your key and try again. If you do not have a key you my sign up for one here. I am not sure how I could have screwed this up here... Any ...more »

Voting

0 votes
0 up votes
0 down votes
Active
(@dgcatanzaro)

Bugs / Problems

Invalid API Key

I just signed up and received a key from the Census API. I created a query, copied the key into the query and submitted it. The response said: A valid key must be included with each data API request. You included a key with this request, however, it is not valid. Please check your key and try again. If you do not have a key you my sign up for one here. I am not sure how I could have screwed this up here... Any ...more »

Voting

0 votes
0 up votes
0 down votes
Active
(@eitanbarazani)

API Technical Discussions

How to decode the Variables?

I am looking at the examples of Request URL examples. I am wondering if the Variables follow any structure and if so were I can learn about it. In another words, can those variables be interpreted to what data is requested? If so, is there a document that describe it? Are the letters in the front has any significance/rules, and are the following digits follow any rules? P012D007, B02001_001E, PCT012A015 etc.... ...more »

Voting

0 votes
0 up votes
0 down votes
Active
(@eitanbarazani)

API Technical Discussions

How to decode the Variables?

I am looking at the examples of Request URL examples. I am wondering if the Variables follow any structure and if so were I can learn about it. In another words, can those variables be interpreted to what data is requested? If so, is there a document that describe it? Are the letters in the front has any significance/rules, and are the following digits follow any rules? P012D007, B02001_001E, PCT012A015 etc.... ...more »

Voting

0 votes
0 up votes
0 down votes
Active
(@brian.hyman)

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 ...more »

Voting

2 votes
2 up votes
0 down votes
Active