Voting

I'm working on a school project with 2010 Census data.
Currently, we are getting tract-level data using codes from http://api.census.gov/data/2010/sf1/variables.json to get data.
For example, to find the white 65-year old males in a county's tracts, we make the API call:
http://api.census.gov/data/2010/sf1?key=[key]&get=PCT012I068,NAME&for=tract:*&in=state:08+county:059
However, when making the same call at a block
...more »

Voting

the api should simply ignore any parameter it doesn't understand instead of throwing an error. For example jquery will append _=randomNumber to prevent caching of jsonp by the browser. This feature breaks that.

Voting

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

First, let me applaud the Census Bureau for doing this, it's an awesome project.
I'm glad to see JSON as the response format for the API, but structure makes it really hard to use. I also haven't seen this list-of-lists format for individual records before.
What would work much better would be one of the following:
a) an array of objects. Within each object, each field name is a key, each value is the value associated
...more »

Voting

I need so assistance in creating an API to pull Median Household Income based on a specific address or if that creates a geocoding problem, i have Lat/long coordinates already. My response from the call should be able to provide me with a dollar amount or a percent over national median household income. The result will be used in an equation. I have a key already.

Voting

Greetings,
Though we have provided this infomation in a reply to an existing thread, we also wanted to create a "fresh" post to let everyone know that the maximum number of variables per request has been increased from 4 to 50. The documentation on www.census.gov/developers/ will be updated to reflect this information as well.
Thank you to everyone who has provided feekback so far. We do take the feedback into account
...more »

Voting

Hello everyone,
This is a question requiring some general direction and also some technical help:
I would like to automatically (daily, weekly?) upload ACS reports by county (all 3200+) into a database hosted locally. My boss wants it in MS Access (this is not up for debate, I have tried).
From MS Access, we'd like to be able to extract the fields we need to populate a .xls file or any other format. Eventually, even
...more »

Voting

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

Voting

this applies to block groups, but others as well ... '+county:*+tract:*' with acs5 is not set to operate with the * wildcarding (using the above selects the first BG in each county only) but would be immensely valuable if county and tract can accept wildcarding rather than specific values. For most users, looking up a tract code is infeasible and generally not desireable (multi tracts being the norm).
Thank you and
...more »

Voting

The XML format for the data dictionary is a great start, but it could be a lot better. In particular, the hierarchical structure of the variables is not mapped.
Let's take P012B049: African American female 85 years and over. It's extremely tedious to tease apart that this is the combination of three variables: race, sex, and age group. One of the great features of XML is its hierarchical structure, which makes it easy
...more »